Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import...;
- public class mySQLplugin extends JavaPlugin implements Listener{
- public static String host = "mysql.host";
- public static String port = "3306";
- public Static String database = "playerdata";
- public static String username = "mysql.username";
- public static String password = "mysql.password";
- public static Connection connection;
- static ConsoleCommandSender console = Bukkit.getConsoleSender();
- public static void Connect() {
- if (!isConnected()) {
- try {
- con = DriverManager.getConnection("jdbc:mysql://" + host + ":" + port + "/" + database, username, password);
- Bukkit.getConsoleSender().sendMessage(ChatColor.GREEN + "Settings> MySQL Connection has been connected successfully.")
- }catch (SQLException e){
- e.printStackTrace();
- }
- }
- public static void disConnect() {
- if (isConnected()) {
- try {
- connection.close();
- Bukkit.getConsoleSender().sendMessage(ChatColor.GREEN + "Settings> MySQL Connection has been disconnected successfully.");
- }
- }
- public static boolean isConnected() {
- return (connection == null ? false : true)
- }
- public static Connection getConnection() {
- return connection;
- }
- @Override
- public void onEnable() {
- PreparedSatement ps = getConnection().prepareStatement("CREATE TABLE IF NOT EXIST playerdata(UUID VARCHAR(100), USERNAME VARCHAR(100), TREEPOINTS INT(100), TREETOKENS INT(100), PRIMARY KEY (UUID));");
- ps.executeUpdate();
- Connect();
- Bukkit.getServer().getConsole().log(ChatColor.RED + "Plugin has been enabled successfully.");
- }
- @Override
- public void onDisable() {
- disConnect();
- Bukkit.getServer().getConsole().log(ChatColor.RED + "Plugin has been disabled successfully.");
- }
- @EventHandler
- public void PlayerPlay (PlayerJoinEvent event) {
- Player p = event.getPlayer();
- if (!p.hasPlayedBefore()) {
- PreparedSatement ps = getConnection().prepareStatement("INSERT IGNORE INTO playerdata (UUID, USERNAME, TREEPOINTS, TREETOKENS) VALUES (?,?,?,?)");
- ps.setString(1, p.getUniqueId.toString());
- ps.setString(2, p.getDisplayName());
- ps.setString(3, 100);
- ps.setString(4, 5);
- ps.executeUpdate();
- }
- }
- public int getPoints(Player player) {
- PreparedSatement ps = getConnection().prepareStatement("SELECT TREEPOINTS WHERE UUID = ?");
- ps.setString(1, p.getUniqueId.toString());
- ResultSet rs = ps.executeQuery();
- int points = 0;
- if (rs.next() == true) {
- points = rs.getInt("TREEPOINTS");
- return points;
- }else {
- return 0;
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement