Advertisement
Guest User

Untitled

a guest
May 12th, 2020
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.99 KB | None | 0 0
  1. public int getEloGuild(String guildname, String nomdelacolonne) {
  2. int value = 0;
  3. try {
  4. PreparedStatement q = connection.prepareStatement("SELECT uuid FROM playerguild WHERE guildname = ?");
  5. q.setString(1, guildname);
  6. ResultSet res = q.executeQuery();
  7.  
  8. while (res.next()) {
  9. String s = res.getString("uuid");
  10. Main.guild.add(s);
  11. }
  12.  
  13. q.close();
  14.  
  15. } catch (SQLException e) {
  16. e.printStackTrace();
  17. }
  18.  
  19. for(String uuid : Main.guild) {
  20. try {
  21. String stat = "SELECT " + nomdelacolonne + " FROM stats WHERE uuid = ?";
  22. PreparedStatement q = connection.prepareStatement(stat);
  23. q.setString(1, uuid);
  24. ResultSet res = q.executeQuery();
  25. while (res.next()) {
  26. int valeur = res.getInt(nomdelacolonne);
  27. value += valeur;
  28. }
  29. q.close();
  30. } catch (SQLException e) {
  31. e.printStackTrace();
  32. }
  33. }
  34. if(Main.guild.size() != 0) {
  35. value = value / Main.guild.size();
  36. }
  37. Main.guild.clear();
  38. return value;
  39. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement