Banana-Coding.com - Java Knuddels Emulator

Java-Quelltext

private void saveStats() {
        PoolConnection pcon = ConnectionPool.getConnection();
        PreparedStatement ps = null;

        try {
            Connection con = pcon.connect();
            ps = con.prepareStatement("UPDATE `accounts` SET `kisses` = ?, `knuddels` = ?, `onlineTime` = ?, `ipAddress` = ? WHERE `name` = ?");
            ps.setInt(1, kisses);
            ps.setInt(2, knuddels);
            ps.setInt(3, getOnlineTime());
            ps.setString(4, ipAddress);
            ps.setString(5, name);
            ps.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            if (ps != null) {
                try {
                    ps.close();
                } catch (SQLException e) {
                }
            }

            pcon.close();
        }
    }