Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package fr.spacetube.dailya.spigot.dailyawars.sql;
- import fr.spacetube.dailya.spigot.dailyawars.Main;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.SQLException;
- import static fr.spacetube.dailya.spigot.dailyawars.Main.*;
- public class SQLCredentials {
- private String host,database,user,password;
- private int port;
- private Connection connection;
- private int i = 5;
- public void tryConnection() {
- if (!hasConnection()) {
- while (i != 0) {
- if (host.isEmpty() || database.isEmpty() || user.isEmpty() || password.isEmpty()) {
- host = getInstance().getConfig().getString("config.sql.host");
- database = getInstance().getConfig().getString("config.sql.database");
- user = getInstance().getConfig().getString("config.sql.user");
- password = getInstance().getConfig().getString("config.sql.password");
- port = getInstance().getConfig().getInt("config.sql.port");
- } else {
- try {
- connection = DriverManager.getConnection("jdbc:mysql://" + host + ":" + port + "/" + database, user, password);
- Main.getInstance().getServer().getConsoleSender().sendMessage(Main.getInstance().getClassManager().getMessageSQL().sqlSucessfulConnection);
- } catch (SQLException e) {Main.getInstance().getServer().getConsoleSender().sendMessage(Main.getInstance().getClassManager().getMessageSQL().sqlMissingConnection);}
- }
- }
- if (i == 0) {
- getInstance().getServer().shutdown();
- }
- } else {
- Main.getInstance().getServer().getConsoleSender().sendMessage(Main.getInstance().getClassManager().getMessageSQL().sqlAllreadyExist);
- }
- }
- public void destroyConnection(){
- if(hasConnection()){
- try {
- connection.close();
- } catch (SQLException e) {Main.getInstance().getServer().getConsoleSender().sendMessage(Main.getInstance().getClassManager().getMessageSQL().sqlSucessfulDisconnection);}
- }
- }
- public String getHost() {return host;}
- public String getDatabase() {return database;}
- public String getUser() {return user;}
- public String getPassword() {return password;}
- public int getPort() {return port;}
- private boolean hasConnection(){return connection != null;}
- public Connection getConnection() { return connection;}
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement