chFhx1Bs

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   }