Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package io.github.thediamondpicks.bans;
- import org.bukkit.Bukkit;
- import org.bukkit.event.Listener;
- import org.bukkit.plugin.Plugin;
- import org.bukkit.plugin.java.JavaPlugin;
- import org.bukkit.scheduler.BukkitRunnable;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.SQLException;
- import java.sql.Statement;
- /**
- * Created by TheDiamondPicks on 28/09/2016.
- */
- public class Main extends JavaPlugin {
- private Connection connection;
- private String host, database, username, password;
- private int port;
- private static Plugin plugin;
- @Override
- public void onEnable() {
- getCommand("ban").setExecutor(new BanCommand());
- plugin = this;
- host = "jerryandjamy.com";
- port = 3306;
- database = "Bans";
- username = "nanana";
- password = "youthoughtwouldgetthepass";
- try {
- openConnection();
- Statement statement = connection.createStatement();
- } catch (ClassNotFoundException e) {
- e.printStackTrace();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- @Override
- public void onDisable() {
- plugin = null; // Prevents mem leaks
- }
- //Much eaisier then registering events in 10 diffirent methods
- public static void registerEvents(org.bukkit.plugin.Plugin plugin, Listener... listeners) {
- for (Listener listener : listeners) {
- Bukkit.getServer().getPluginManager().registerEvents(listener, plugin);
- }
- }
- //To access the plugin variable from other classes
- public static Plugin getPlugin() {
- return plugin;
- }
- public void openConnection() throws SQLException, ClassNotFoundException {
- if (connection != null && !connection.isClosed()) {
- return;
- }
- synchronized (this) {
- if (connection != null && !connection.isClosed()) {
- return;
- }
- Class.forName("com.mysql.jdbc.Driver");
- connection = DriverManager.getConnection("jdbc:mysql://" + this.host + ":" + this.port + "/" + this.database, this.username, this.password);
- }
- }
- BukkitRunnable r = new BukkitRunnable() {
- public void run() {
- try {
- openConnection();
- Statement statement = connection.createStatement();
- } catch(ClassNotFoundException e) {
- e.printStackTrace();
- } catch(SQLException e) {
- e.printStackTrace();
- }
- }
- };
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement