java.sql.Connection con = null; try { con = L2DatabaseFactory.getInstance().getConnection(); //--------------------------------------------------- //Different part //------------------------------------------------ PreparedStatement statement = con.prepareStatement("SELECT account_name FROM characters WHERE char_name=?"); statement.setString(1, name); ResultSet rset = statement.executeQuery(); result = rset.next(); rset.close(); //----------------------------------------------------- statement.close(); } catch (Exception e) { _log.warning(e.getMessage()); e.printStackTrace(); } finally { try { con.close(); } catch (Exception e) {e.printStackTrace();} }