Advertisement
Guest User

Code for MYSQL

a guest
Oct 21st, 2016
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 2.40 KB | None | 0 0
  1. import...;
  2. public class mySQLplugin extends JavaPlugin implements Listener{
  3.  
  4. public static String host = "mysql.host";
  5. public static String port = "3306";
  6. public Static String database = "playerdata";
  7. public static String username = "mysql.username";
  8. public static String password = "mysql.password";
  9. public static Connection connection;
  10.  
  11. static ConsoleCommandSender console = Bukkit.getConsoleSender();
  12.  
  13. public static void Connect() {
  14.  
  15. if (!isConnected()) {
  16.  
  17. try {
  18.  
  19. con = DriverManager.getConnection("jdbc:mysql://" + host + ":" + port + "/" + database, username, password);
  20. Bukkit.getConsoleSender().sendMessage(ChatColor.GREEN + "Settings> MySQL Connection has been connected successfully.")
  21. }catch (SQLException e){
  22.  
  23. e.printStackTrace();
  24.  
  25. }
  26.  
  27. }
  28.  
  29. public static void disConnect() {
  30.  
  31. if (isConnected()) {
  32. try {
  33. connection.close();
  34. Bukkit.getConsoleSender().sendMessage(ChatColor.GREEN + "Settings> MySQL Connection has been disconnected successfully.");
  35. }
  36.  
  37. }
  38.  
  39. public static boolean isConnected() {
  40. return (connection == null ? false : true)
  41. }
  42.  
  43. public static Connection getConnection() {
  44. return connection;
  45. }
  46.  
  47. @Override
  48. public void onEnable() {
  49.  
  50. PreparedSatement ps = getConnection().prepareStatement("CREATE TABLE IF NOT EXIST playerdata(UUID VARCHAR(100), USERNAME VARCHAR(100), TREEPOINTS INT(100), TREETOKENS INT(100), PRIMARY KEY (UUID));");
  51. ps.executeUpdate();
  52.  
  53. Connect();
  54. Bukkit.getServer().getConsole().log(ChatColor.RED + "Plugin has been enabled successfully.");
  55.  
  56. }
  57.  
  58. @Override
  59. public void onDisable() {
  60. disConnect();
  61. Bukkit.getServer().getConsole().log(ChatColor.RED + "Plugin has been disabled successfully.");
  62.  
  63. }
  64.  
  65. @EventHandler
  66. public void PlayerPlay (PlayerJoinEvent event) {
  67.  
  68. Player p = event.getPlayer();
  69. if (!p.hasPlayedBefore()) {
  70.  
  71. PreparedSatement ps = getConnection().prepareStatement("INSERT IGNORE INTO playerdata (UUID, USERNAME, TREEPOINTS, TREETOKENS) VALUES (?,?,?,?)");
  72. ps.setString(1, p.getUniqueId.toString());
  73. ps.setString(2, p.getDisplayName());
  74. ps.setString(3, 100);
  75. ps.setString(4, 5);
  76. ps.executeUpdate();
  77. }
  78. }
  79.  
  80. public int getPoints(Player player) {
  81. PreparedSatement ps = getConnection().prepareStatement("SELECT TREEPOINTS WHERE UUID = ?");
  82. ps.setString(1, p.getUniqueId.toString());
  83. ResultSet rs = ps.executeQuery();
  84. int points = 0;
  85. if (rs.next() == true) {
  86.  
  87. points = rs.getInt("TREEPOINTS");
  88. return points;
  89. }else {
  90. return 0;
  91. }
  92. }
  93.  
  94. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement