public void select(Castle castle) {
Connection con = null;
PreparedStatement statement = null;
ResultSet rset = null;
try {
con = DatabaseFactory.getInstance().getConnection();
statement = con.prepareStatement(SELECT_SQL_QUERY);
statement.setInt(1, castle.getId());
rset = statement.executeQuery();
if (rset.next()) {
castle.setTaxPercent(rset.getInt("tax_percent"));
castle.setTreasury(rset.getLong("treasury"));
castle.setRewardCount(rset.getInt("reward_count"));
castle.getSiegeDate().setTimeInMillis(rset.getLong("siege_date") * 1000L);
castle.getLastSiegeDate().setTimeInMillis(rset.getLong("last_siege_date") * 1000L);
castle.getOwnDate().setTimeInMillis(rset.getLong("own_date") * 1000L);
castle.setResidenceSide(ResidenceSide.VALUES[rset.getInt("side")], true);
}
} catch (Exception e) {
_log.error("CastleDAO.select(Castle):" + e, e);
} finally {
DbUtils.closeQuietly(con, statement, rset);
}
}
