Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static void updateDeaths(Player player, int kills, int deaths, boolean remove) {
- int death = getDeaths(player);
- deaths += death;
- if (isUserExists(player)) {
- try {
- PreparedStatement ps = MySQL.getConnection()
- .prepareStatement("UPDATE creepergames SET Deaths = (Deaths+1) WHERE Name = ?");
- ps.setString(1, player.getName());
- ps.executeUpdate();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- } else {
- try {
- PreparedStatement ps = MySQL.getConnection()
- .prepareStatement("INSERT INTO creepergames (Name,Kills,Deaths) VALUES (?,?,?)");
- ps.setString(1, player.getName());
- ps.setInt(2, kills);
- ps.setInt(3, deaths);
- ps.executeUpdate();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }
- }
- public static Integer getKills(Player player) {
- try {
- PreparedStatement ps = MySQL.getConnection()
- .prepareStatement("SELECT Kills FROM creepergames WHERE Name = ?");
- ps.setString(1, player.getName());
- ResultSet rs = ps.executeQuery();
- while (rs.next()) {
- return rs.getInt("Kills");
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- return 0;
- }
- public static Integer getDeaths(Player player) {
- try {
- PreparedStatement ps = MySQL.getConnection()
- .prepareStatement("SELECT Deaths FROM creepergames WHERE Name = ?");
- ps.setString(1, player.getName());
- ResultSet rs = ps.executeQuery();
- while (rs.next()) {
- return rs.getInt("Deaths");
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- return 0;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement