import tools.packet.CWvsContext.Reward; //导入依赖的package包/类
public void updateReward() {
    List<MapleReward> rewards = new LinkedList();
    try {
        Connection con = DatabaseConnection.getConnection();
        try (PreparedStatement ps = con.prepareStatement("SELECT * FROM rewards WHERE `cid`=?")) {
            ps.setInt(1, id);
            try (ResultSet rs = ps.executeQuery()) {
                //rewards.last();
                //int size = rewards.getRow();
                //rewards.first();
                //client.getSession().write(Reward.updateReward(rewards.getInt("id"), (byte) 9, rewards, size, 9));
                while (rs.next()) {
                    rewards.add(new MapleReward(
                            rs.getInt("id"),
                            rs.getLong("start"),
                            rs.getLong("end"),
                            rs.getInt("type"),
                            rs.getInt("itemId"),
                            rs.getInt("mp"),
                            rs.getInt("meso"),
                            rs.getInt("exp"),
                            rs.getString("desc")));
                }
            }
        }
    } catch (SQLException e) {
        System.err.println("Unable to update rewards: " + e);
    }
    client.getSession().write(Reward.updateReward(0, (byte) 9, rewards, 9));
}