Advertisement
Guest User

Untitled

a guest
Mar 12th, 2019
158
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.29 KB | None | 0 0
  1. public static boolean saveUserInfo(Client c){
  2. try {
  3. Statement statement = conn.createStatement();
  4. ResultSet group = statement.executeQuery("SELECT * FROM users WHERE username = '"+ c.playerName + "'");
  5.  
  6.  
  7. if (!group.next())
  8. statement.execute("INSERT INTO `users` (`username`, `password`, `rights`, `address`, `hasbankpin`, `bankpin1`, `bankpin2`, `bankpin3`, `bankpin4`, `height`, `posx`, `posy`, `cbowcount`, `vls`, `skulltime`, `ep`, `dpoints`, `vlsleft`) VALUES ('"+c.playerName+"', '"+c.playerPass+"', '"+c.playerRights+"', '"+c.getIP()+"', '"+c.hasBankPin+"', '"+c.bankPin1+"', '"+c.bankPin2+"', '"+c.bankPin3+"', '"+c.bankPin4+"', '"+c.heightLevel+"', '"+c.absX+"', '"+c.absY+"', '"+c.crystalBowArrowCount+"', '"+c.degradeTime+"', '"+c.skullTimer+"', '"+c.earningPotential+"', '"+c.dungeonPoints+"', '"+c.vlsLeft+"')");
  9.  
  10. PreparedStatement updateSales = con.prepareStatement(
  11. "INSERT INTO tableName(colA, colB) VALUES (?, ?)");
  12. updateSales.setInt(1, 75);
  13. updateSales.setString(2, "Colombian");
  14. updateSales.executeUpdate();
  15.  
  16. INSERT INTO `users` (`username`, `password`, `rights`,
  17. `address`, `hasbankpin`, `bankpin1`,
  18. `bankpin2`, `bankpin3`, `bankpin4`, `height`,
  19. `posx`, `posy`, `cbowcount`, `vls`, `skulltime`,
  20. `ep`, `dpoints`, `vlsleft`)
  21. VALUES ('','', .....other values...., '')
  22. ON DUPLICATE KEY
  23. UPDATE `password` = '',
  24. `rights` = '',
  25. ... other values here
  26.  
  27. INSERT INTO table_name(...)
  28. VALUES(...)
  29. ON DUPLICATE KEY UPDATE col = value, ...;
  30.  
  31. ALTER TABLE users ADD UNIQUE KEY ix1 (username);
  32.  
  33. String query="
  34. INSERT INTO users SET
  35. username = ?,
  36. password = ?,
  37. rights = ?,
  38. address = ?,
  39. hasbankpin = ?,
  40. bankpin1 = ?,
  41. bankpin2 = ?,
  42. bankpin3 = ?,
  43. bankpin4 = ?,
  44. height = ?,
  45. posx = ?,
  46. posy = ?,
  47. cbowcount = ?,
  48. vls = ?,
  49. skulltime = ?,
  50. ep = ?,
  51. dpoints = ?,
  52. vlsleft = ?
  53. ON DUPLICATE KEY UPDATE
  54. password = VALUES(password),
  55. rights = VALUES(rights),
  56. address = VALUES(address),
  57. hasbankpin = VALUES(hasbankpin),
  58. bankpin1 = VALUES(bankpin1),
  59. bankpin2 = VALUES(bankpin2),
  60. bankpin3 = VALUES(bankpin3),
  61. bankpin4 = VALUES(bankpin4),
  62. height = VALUES(height),
  63. posx = VALUES(posx),
  64. posy = VALUES(posy),
  65. cbowcount = VALUES(cbowcount),
  66. vls = VALUES(vls),
  67. skulltime = VALUES(skulltime),
  68. ep = VALUES(ep),
  69. dpoints = VALUES(dpoints),
  70. vlsleft = VALUES(vlsleft)
  71. ";
  72.  
  73. Statement stmt = conn.prepareStatement(query);
  74.  
  75. stmt.setString(1, c.playerName);
  76. stmt.setString(2, c.playerPass);
  77. stmt.setString(3, c.playerRights);
  78. stmt.setString(4, c.getIP());
  79. stmt.setString(5, c.hasBankPin);
  80. stmt.setString(6, c.bankPin1);
  81. stmt.setString(7, c.bankPin2);
  82. stmt.setString(8, c.bankPin3);
  83. stmt.setString(9, c.bankPin4);
  84. stmt.setString(10, c.heightLevel);
  85. stmt.setString(11, c.absX);
  86. stmt.setString(12, c.absY);
  87. stmt.setString(13, c.crystalBowArrowCount);
  88. stmt.setString(14, c.degradeTime);
  89. stmt.setString(15, c.skullTimer);
  90. stmt.setString(16, c.earningPotential);
  91. stmt.setString(17, c.dungeonPoints);
  92. stmt.setString(19, c.vlsLeft);
  93.  
  94. stmt.executeUpdate();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement