Guest User

Untitled

a guest
Feb 19th, 2017
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.69 KB | None | 0 0
  1. package at.freaktube.mysql;
  2.  
  3. import java.sql.*;
  4.  
  5. /**
  6. * Created by Freaktube on 04.08.2016.
  7. */
  8. public class MySQL {
  9.  
  10. private final String HOST;
  11. private final int PORT;
  12. private final String DATABASE;
  13. private final String USERNAME;
  14. private final String PASSWORD;
  15.  
  16. private Connection connection;
  17.  
  18. public MySQL(String host, int port, String database, String username, String password) {
  19. HOST = host;
  20. PORT = port;
  21. DATABASE = database;
  22. USERNAME = username;
  23. PASSWORD = password;
  24. }
  25.  
  26. public void connect() {
  27. try {
  28. connection = DriverManager.getConnection("jdbc:mysql://" + HOST + ":" + PORT + "/" + DATABASE + "?autoReconnect=true", USERNAME, PASSWORD);
  29. System.out.println("[Proxy-System] MySQL erfolgreich verbunden.");
  30. } catch (SQLException e) {
  31. e.printStackTrace();
  32. }
  33. }
  34.  
  35. public void disconnect() {
  36. try {
  37. connection.close();
  38. System.out.println("[Proxy-System] MySQL erfolgreich getrennt.");
  39. } catch (SQLException e) {
  40. e.printStackTrace();
  41. }
  42. }
  43.  
  44. public void createTable() {
  45. update("CREATE TABLE IF NOT EXISTS `supporter_rating` (`playername` VARCHAR(100), `uuid` VARCHAR(100), `rating` FLOAT(2), `five` INT(100), `four` INT(100), `three` INT(100), `two` INT(100), `one` INT(100));");
  46. update("CREATE TABLE IF NOT EXISTS `bans` (`playername` VARCHAR(100), `uuid` VARCHAR(100), `banned_by` VARCHAR(100), `reason` VARCHAR(100), `end` INT(100));");
  47. update("CREATE TABLE IF NOT EXISTS `mutes` (`playername` VARCHAR(100), `uuid` VARCHAR(100), `muted_by` VARCHAR(100), `reason` VARCHAR(100), `end` INT(100));");
  48. update("CREATE TABLE IF NOT EXISTS `warns` (`playername` VARCHAR(100), `uuid` VARCHAR(100), `amount` SMALLINT(5) UNSIGNED);");
  49. update("CREATE TABLE IF NOT EXISTS `warn_history` (`id` BIGINT(20) UNSIGNED, `playername` VARCHAR(100), `uuid` VARCHAR(100), `warned_by` VARCHAR(100), `reason` VARCHAR(100));");
  50. }
  51.  
  52. public void update(String qry) {
  53. try {
  54. Statement st = connection.createStatement();
  55. st.executeUpdate(qry);
  56. st.close();
  57. } catch (SQLException e) {
  58. e.printStackTrace();
  59. }
  60. }
  61.  
  62. public ResultSet query(String qry) {
  63. ResultSet rs = null;
  64. try {
  65. Statement st = connection.createStatement();
  66. rs = st.executeQuery(qry);
  67. } catch (SQLException e) {
  68. e.printStackTrace();
  69. }
  70. return rs;
  71. }
  72.  
  73. public boolean isConnected() {
  74. return connection != null;
  75. }
  76. }
Add Comment
Please, Sign In to add comment