Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.chickenstyle.report;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.SQLException;
- import org.bukkit.Bukkit;
- import org.bukkit.ChatColor;
- import org.bukkit.event.Listener;
- import org.bukkit.plugin.java.JavaPlugin;
- public class Main extends JavaPlugin implements Listener {
- private static Connection connection;
- private String host, database, username, password;
- private int port;
- public void onEnable() {
- getCommand("report").setExecutor(new Report());
- Bukkit.getPluginManager().registerEvents(this, this);
- host = "localhost";
- port = 3306;
- database = "player_report";
- username = "root";
- password = "";
- try {
- openConnection();
- System.out.println(ChatColor.GREEN + "MySQL Connected!");
- }catch (SQLException x) {
- x.printStackTrace();
- }
- }
- public static PreparedStatement prepareState(String query) {
- PreparedStatement ps = null;
- try {
- ps = connection.prepareStatement(query);
- } catch (SQLException x) {
- x.printStackTrace();
- }
- return ps;
- }
- private void openConnection() throws SQLException {
- if (connection != null && !connection.isClosed()) {
- return;
- }
- connection = DriverManager.getConnection("jdbc:mysql://" + this.host + ":" + this.port + "/" + this.database, this.username, this.password);
- }
- }
Add Comment
Please, Sign In to add comment