Advertisement
Guest User

Untitled

a guest
Feb 28th, 2017
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.04 KB | None | 0 0
  1. static int host = Main.getPlugin().getConfig().getInt("mysql.host");
  2. static String database = Main.getPlugin().getConfig().getString("mysql.database");
  3. static String username = Main.getPlugin().getConfig().getString("mysql.user");
  4. static String password = Main.getPlugin().getConfig().getString("mysql.pass");
  5. static int port = Main.getPlugin().getConfig().getInt("mysql.port");
  6.  
  7. public static Connection SQLconnect() {
  8. try {
  9. Class.forName("com.mysql.jdbc.Driver").newInstance();
  10. final Connection con = DriverManager.getConnection("jdbc:mysql://" + host + ":" + port + "/" + database,
  11. username, password);
  12. return con;
  13. } catch (final ClassNotFoundException ex) {
  14. System.err.println("[Training] No MySQL driver found!");
  15. } catch (final SQLException ex) {
  16. System.err.println("[Training] Error while fetching MySQL connection!");
  17. } catch (final Exception ex) {
  18. System.err.println("[Training] Unknown error while fetchting MySQL connection.");
  19. }
  20. return null;
  21. }
  22.  
  23. public static void SQLdisconnect(Connection con) {
  24. try {
  25. con.close();
  26. } catch (SQLException | NullPointerException ex) {
  27. System.err.println("[Training] Error while closing the connection...");
  28. }
  29. }
  30.  
  31. public static void createTable() {
  32. if (!Training.getSql())
  33. return;
  34. final Connection con = SQLconnect();
  35. try {
  36. final Statement state = con.createStatement();
  37. state.executeUpdate(
  38. "CREATE TABLE IF NOT EXISTS accounts(uuid VARCHAR(255),name VARCHAR(16),rank VARCHAR(32),coins INT,level INT,exp INT,played INT,kills INT,deaths INT,kit VARCHAR(255),ks INT)");
  39. state.executeUpdate(
  40. "CREATE TABLE IF NOT EXISTS achievements(uuid VARCHAR(255),name VARCHAR(16),kills VARCHAR(5),blocks VARCHAR(5),pickaxe VARCHAR(5))");
  41. state.executeUpdate(
  42. "CREATE TABLE IF NOT EXISTS configurations(uuid VARCHAR(255),name VARCHAR(16),anim VARCHAR(5),msg VARCHAR(5),compass VARCHAR(5),title VARCHAR(5))");
  43. } catch (final SQLException e) {
  44. System.err.println(e);
  45. e.printStackTrace();
  46. }
  47. SQLdisconnect(con);
  48. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement