Connection con = null;
PreparedStatement statement = null;
try
{
con = DatabaseFactory.getInstance().getConnection();
statement = con.prepareStatement("UPDATE castle SET tax_percent=?, treasury=?, reward_count=?, siege_date=?, last_siege_date=?, own_date=? WHERE id=?");
statement.setInt(1, castle.getTaxPercent0());
statement.setLong(2, castle.getTreasury());
statement.setInt(3, castle.getRewardCount());
statement.setLong(4, castle.getSiegeDate().getTimeInMillis());
statement.setLong(5, castle.getLastSiegeDate().getTimeInMillis());
statement.setLong(6, castle.getOwnDate().getTimeInMillis());
statement.setInt(7, castle.getId());
statement.execute();
}
catch(Exception e)
{
_log.warn("CastleDAO#update0(Castle): " + e, e);
}
finally
{
DbUtils.closeQuietly(con, statement);
}Code: Java
на пример.
Добавлено через 47 секунд
с результатом:
Connection con = null;
PreparedStatement statement = null;
ResultSet rset = null;
try
{
con = DatabaseFactory.getInstance().getConnection();
statement = con.prepareStatement("SELECT tax_percent, treasury, reward_count, siege_date, last_siege_date, own_date FROM castle WHERE id=? LIMIT 1");
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"));
castle.getLastSiegeDate().setTimeInMillis(rset.getLong("last_siege_date"));
castle.getOwnDate().setTimeInMillis(rset.getLong("own_date"));
}
}
catch(Exception e)
{
_log.error("CastleDAO.select(Castle):" + e, e);
}
finally
{
DbUtils.closeQuietly(con, statement, rset);
}
Code: Java