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

itemId: "+itemId+"
price: "+price+"
originalprice: "+originalprice+"