package com.dengyu.mysql;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import org.bukkit.command.CommandSender;
public class MySQLManager {
private String ip;
private String databaseName;
private String userName;
private String userPassword;
private Connection connection;
private int port;
public static MySQLManager instance = null;
public static MySQLManager get() {
return instance == null ? instance = new MySQLManager() : instance;
}
public void enableMySQL()
{
ip = Main.getConfigString("mysql.ip");
databaseName = Main.getConfigString("mysql.databasename");
userName = Main.getConfigString("mysql.username");
userPassword = Main.getConfigString("mysql.password");
port = Main.getConfigInt("mysql.port");
connectMySQL();
String cmd = SQLCommand.CREATE_TABLE1.commandToString();
try {
PreparedStatement ps = connection.prepareStatement(cmd);
doCommand(ps);
} catch (SQLException e) {
e.printStackTrace();
}
}
private void connectMySQL()
{
try {
connection = DriverManager.getConnection("jdbc:mysql://" + ip + ":" + port + "/" + databaseName + "?autoReconnect=true", userName, userPassword);
} catch (SQLException e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
}
public void doCommand(PreparedStatement ps)
{
try {
ps.executeUpdate();
} catch (SQLException e) {
System.out.println("执行指令失败,以下为错误提示");
e.printStackTrace();
}
}
}