Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public String url;
- private String user;
- private String pass;
- public DataBase() throws SQLException, Exception {
- Connection connect;
- FileConfiguration FC = ClanSystem.getInstance().getConfig();
- if (FC.getString("database.type").equals("mysql")) {
- String host = FC.getString("database.host");
- int port = FC.getInt("database.port");
- user = FC.getString("database.username");
- pass = FC.getString("database.password");
- String dbname = FC.getString("database.databasename");
- url = "jdbc:mysql://" + host + ":" + port + "/" + dbname;
- }
- else {
- url = "jdbc:sqlite:" + ClanSystem.getInstance().getDataFolder() + File.separator + "database.db";
- }
- connect = getConnection();
- Statement state = connect.createStatement();
- state.executeUpdate("CREATE TABLE IF NOT EXISTS clans_info (`clan_name` TEXT, `exp` LONG, `lvl` LONG);");
- state.close();
- connect.close();
- }
- public Connection getConnection() throws SQLException, InstantiationException, IllegalAccessException, ClassNotFoundException {
- if (user != null) {
- Class.forName("com.mysql.jdbc.Driver").newInstance();
- return DriverManager.getConnection(url, user, pass);
- }
- else {
- Class.forName("org.sqlite.JDBC").newInstance();
- return DriverManager.getConnection(url);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement