Advertisement
Guest User

Untitled

a guest
Mar 6th, 2019
143
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.28 KB | None | 0 0
  1.     public String url;
  2.     private String user;
  3.     private String pass;
  4.     public DataBase() throws SQLException, Exception {
  5.         Connection connect;
  6.         FileConfiguration FC = ClanSystem.getInstance().getConfig();
  7.         if (FC.getString("database.type").equals("mysql")) {
  8.             String host = FC.getString("database.host");
  9.             int port = FC.getInt("database.port");
  10.             user = FC.getString("database.username");
  11.             pass = FC.getString("database.password");
  12.             String dbname = FC.getString("database.databasename");
  13.             url = "jdbc:mysql://" + host + ":" + port + "/" + dbname;
  14.         }
  15.         else {
  16.             url = "jdbc:sqlite:" + ClanSystem.getInstance().getDataFolder() + File.separator + "database.db";
  17.         }
  18.         connect = getConnection();
  19.         Statement state = connect.createStatement();
  20.         state.executeUpdate("CREATE TABLE IF NOT EXISTS clans_info (`clan_name` TEXT, `exp` LONG, `lvl` LONG);");
  21.         state.close();
  22.         connect.close();
  23.     }
  24.     public Connection getConnection() throws SQLException, InstantiationException, IllegalAccessException, ClassNotFoundException {
  25.         if (user != null) {
  26.             Class.forName("com.mysql.jdbc.Driver").newInstance();
  27.             return DriverManager.getConnection(url, user, pass);
  28.         }
  29.         else {
  30.             Class.forName("org.sqlite.JDBC").newInstance();
  31.             return DriverManager.getConnection(url);
  32.         }
  33.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement