Advertisement
Guest User

Untitled

a guest
Jan 20th, 2018
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.23 KB | None | 0 0
  1. public static Connection connect() {
  2. try {
  3. Connection con = DriverManager.getConnection("jdbc:mysql://" + Main.config.getString("MySQL.Host") + ":" + Main.config.getString("MySQL.Port") + "/" + Main.config.getString("MySQL.Database") + "?autoReconnect=true", Main.config.getString("MySQL.User"), Main.config.getString("MySQL.Password"));
  4. ProxyServer.getInstance().getConsole().sendMessage(new TextComponent(Messages.prefix + Messages.mysqlRunning));
  5. } catch (SQLException se) {
  6. ProxyServer.getInstance().getConsole().sendMessage(new TextComponent(Messages.prefix + Messages.mysqlError));
  7. }
  8. return con;
  9.  
  10. }
  11.  
  12. public static void createTables() {
  13. try {
  14. java.sql.PreparedStatement pst = con.prepareStatement( "CREATE TABLE IF NOT EXISTS Reports(ID varchar(100),UUID varchar(100),Reporter varchar(100),Reason varchar(100),Timestamp varchar(100),Server varchar(100))" );
  15. pst.executeUpdate("CREATE TABLE IF NOT EXISTS Reports(ID varchar(100),UUID varchar(100),Reporter varchar(100),Reason varchar(100),Timestamp varchar(100),Server varchar(100))");
  16. pst.close();
  17. } catch (SQLException exc1) {
  18. exc1.printStackTrace();
  19. }
  20.  
  21. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement