Unnamed

public void showSeedWindow(L2PcInstance player, int val)
    {
        NpcHtmlMessage html = new NpcHtmlMessage(1);
        StringBuffer html1 = new StringBuffer("<html><body><table border=0>");
        html1.append("<tr><td>Output:</td></tr>");
        html1.append("<tr><td><br></td></tr>");
        
        java.sql.Connection con = null;
        try {
            con = L2DatabaseFactory.getInstance().getConnection();
            
            PreparedStatement statement = con.prepareStatement("SELECT id, territory, price, orig_price FROM seeds WHERE territory = ?");   
            statement.setInt(1, val);
            ResultSet rset = statement.executeQuery();
            
            while(rset.next())
            {
                int itemId = rset.getInt("id");
                int territory = rset.getInt("territory");
                int price = rset.getInt("price");
                int originalprice = rset.getInt("orig_price");
                
                html1.append("<tr><td>itemId: "+itemId+"</td></tr>");
                html1.append("<tr><td>territory: "+territory+"</td></tr>");
                html1.append("<tr><td>price: "+price+"</td></tr>");
                html1.append("<tr><td>originalprice: "+originalprice+"</td></tr>");
                html1.append("<tr><td><br></td></tr>");
            }
            
        } catch (SQLException e) {
            _log.log(Level.SEVERE, "", e);
        } finally {
            try { con.close(); } catch (Exception e) {}
        }            
        
        html1.append("</body></html>");
        html.setHtml(html1.toString());
        player.sendPacket(html);
        
        player.sendPacket( new ActionFailed() );
    }