Advertisement
Guest User

Untitled

a guest
Aug 20th, 2019
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. public static void updateKill(Player player, int kills, int deaths, boolean remove) {
  2. int kill = getKills(player);
  3. kills+=kill;
  4. if(isUserExists(player)) {
  5. try {
  6. PreparedStatement ps = MySQL.getConnection().prepareStatement("UPDATE creepergames SET Kills = ? WHERE Name = ?");
  7. ps.setString(1, player.getName());
  8. ps.setInt(2, kill);
  9. ps.setInt(3, deaths);
  10. ps.executeUpdate();
  11. } catch (SQLException e) {
  12. // TODO Auto-generated catch block
  13. e.printStackTrace();
  14. }
  15. }else {
  16. try {
  17. PreparedStatement ps = MySQL.getConnection().prepareStatement("INSERT INTO creepergames (Name,Kills,Deaths) VALUES (?,?,?)");
  18. ps.setString(1, player.getName());
  19. ps.setInt(2, kills);
  20. ps.setInt(3, deaths);
  21. ps.executeUpdate();
  22. } catch (SQLException e) {
  23. // TODO Auto-generated catch block
  24. e.printStackTrace();
  25. }
  26. }
  27.  
  28. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement