Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package me.robin.main;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.util.UUID;
- import org.bukkit.entity.Player;
- public class MySQL {
- public static String host = "";
- public static int port = 3306;
- public static String database = "";
- public static String username = "";
- public static String password = "";
- private static Connection con;
- public static boolean connect() {
- try {
- con = DriverManager.getConnection("jdbc:mysql://" + host + ":" + port + "/" + database, username, password);
- return true;
- } catch (SQLException e) {
- System.err.println(e.getMessage());
- }
- return false;
- }
- public static Connection getConnection() {
- return con;
- }
- public static boolean isConnected() {
- return con != null;
- }
- public static boolean existsPlayer(UUID uuid) {
- if(isConnected())
- if(!connect())
- return false;
- try {
- PreparedStatement ps = con.prepareStatement("SELECT ? FROM ?");
- ps.setString(1, "UUID");
- ps.setString(1, "rangliste");
- ResultSet rs = ps.executeQuery();
- while(rs.next())
- if(rs.getString("UUID").equals(uuid.toString()))
- return true;
- } catch (SQLException e) {
- e.printStackTrace();
- }
- return false;
- }
- public static boolean createPlayer(Player p) {
- if(isConnected())
- if(!connect())
- return false;
- try {
- PreparedStatement ps = con.prepareStatement("INSERT INTO ? (?,?,?) VALUES (?,?,?)");
- int i = 1;
- ps.setString(i++, "rangliste");
- ps.setString(i++, "UUID");
- ps.setString(i++, "Spieler");
- ps.setString(i++, "Kills");
- ps.setString(i++, "Tode");
- ps.setString(i++, p.getUniqueId().toString());
- ps.setString(i++, p.getName());
- ps.setInt(i++, 0);
- ps.setInt(i++, 0);
- ps.executeQuery();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- return false;
- }
- public static int getKills(Player p) {
- if(isConnected())
- if(!connect())
- return -1;
- if(!existsPlayer(p.getUniqueId()))
- if(!createPlayer(p));
- return -1;
- }
- public static int getDeaths(Player p) {
- if(isConnected())
- if(!connect())
- return -1;
- if(!existsPlayer(p.getUniqueId()))
- if(!createPlayer(p));
- return -1;
- try {
- PreparedStatement ps = con.prepareStatement("SELECT ?,? FROM ? WHERE ?,? =?,?");
- ps.setString(1, "Kills");
- ps.setString(3, "Deaths");
- ps.setString(4, "rangliste");
- ps.setString(5, "UUID");
- ps.setString(6, p.getUniqueId().toString());
- ResultSet rs = ps.executeQuery();
- while(rs.next())
- return rs.getInt("Kills");
- return -1;
- ResultSet rs1 = ps.executeQuery();
- while(rs1.next())
- return rs1.getInt("Deaths");
- return -1;
- } catch (SQLException e) {
- e.printStackTrace();
- }
- return -1;
- }
- public static void setKills(Player p, int kills) {
- if(isConnected())
- if(!connect())
- return;
- if(existsPlayer(p.getUniqueId()))
- if(!createPlayer(p))
- return;
- public static void setDeaths(Player p, int deaths) {
- if(isConnected())
- if(!connect())
- return;
- if(existsPlayer(p.getUniqueId()))
- if(!createPlayer(p))
- return;
- try {
- PreparedStatement ps = con.prepareStatement("UPDATE ? SET ? = ?");
- ps.setString(1, "rangliste");
- ps.setString(2, "Kills");
- ps.setString(3, "Tode");
- ps.setInt(4, kills);
- ps.setInt(5, deaths);
- ps.executeQuery();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement