Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package me.hotribs.voidshooter.managers;
- import me.hotribs.voidshooter.VoidShooter;
- import org.bukkit.Bukkit;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.SQLException;
- import static me.hotribs.voidshooter.utils.ChatUtils.format;
- public class SQLManager {
- private static SQLManager instance = new SQLManager();
- private VoidShooter plugin = VoidShooter.getPlugin();
- private Connection connection;
- private String host, database, username, password;
- private int port;
- public static SQLManager getInstance() {
- return instance;
- }
- public void setup() {
- host = plugin.getConfig().getString("database.host");
- port = plugin.getConfig().getInt("database.port");
- database = plugin.getConfig().getString("database.database");
- username = plugin.getConfig().getString("database.username");
- password = plugin.getConfig().getString("database.password");
- try {
- synchronized (this) {
- if (getConnection() != null && !getConnection().isClosed()) {
- return;
- }
- Class.forName("com.mysql.jdbc.Driver");
- setConnection(DriverManager.getConnection("jdbc:mysql://"
- + this.host + ":" + this.port + "/" + this.database, this.username, this.password));
- Bukkit.getConsoleSender().sendMessage(format("&aSuccesfully connected with database!"));
- }
- } catch (SQLException e) {
- e.printStackTrace();
- } catch (ClassNotFoundException e) {
- e.printStackTrace();
- }
- }
- private Connection getConnection() {
- return connection;
- }
- private void setConnection(Connection connection) {
- this.connection = connection;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement