Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static Connection connect() {
- try {
- 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"));
- ProxyServer.getInstance().getConsole().sendMessage(new TextComponent(Messages.prefix + Messages.mysqlRunning));
- } catch (SQLException se) {
- ProxyServer.getInstance().getConsole().sendMessage(new TextComponent(Messages.prefix + Messages.mysqlError));
- }
- return con;
- }
- public static void createTables() {
- try {
- 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))" );
- 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))");
- pst.close();
- } catch (SQLException exc1) {
- exc1.printStackTrace();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement