/** Update the characters table of the database with power grade. */ public void updatePowerGrade() { ThreadConnection con = null; FiltredPreparedStatement statement = null; try { con = L2DatabaseFactory.getInstance().getConnection(); statement = con.prepareStatement(Characters.UPDATE_CHAR_POWER_GRADE); statement.setLong(1, _powerGrade); statement.setInt(2, getObjectId()); statement.execute(); } catch (Exception e) { _log.log(Level.ERROR, "Could not update power _grade: " + e.getMessage(), e); } finally { DatabaseUtils.closeDatabaseCS(con, statement); } }
public void saveApprenticeAndSponsor(int apprentice, int sponsor) { ThreadConnection con = null; FiltredPreparedStatement statement = null; try { con = L2DatabaseFactory.getInstance().getConnection(); statement = con.prepareStatement(Characters.UPDATE_CHAR_APPRENTICE_SPONSOR); statement.setInt(1, apprentice); statement.setInt(2, sponsor); statement.setInt(3, getObjectId()); statement.execute(); } catch (SQLException e) { _log.log(Level.ERROR, "Could not save apprentice/sponsor: " + e.getMessage(), e); } finally { DatabaseUtils.closeDatabaseCS(con, statement); } }