BungeeBanSystem - MySQL

package de.betacoding.bansystem.mysql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import net.md_5.bungee.api.ProxyServer;

public class MySQL {

	public static String host = "localhost";
	public static String password = "abc";
	public static String port = "3306";
	public static String username = "localhost";
	public static String database = "System";

	public  static Connection con;

	public static Connection getConnection() {
		return con;
	}

	public static boolean isConnected() {
		return con != null;
	}

	@SuppressWarnings("deprecation")
	public static void connect() {
		if(!isConnected()) {
			try{
				con = DriverManager.getConnection("jdbc:mysql://"+host+":"+port+"/"+database+username+password);
				ProxyServer.getInstance().getConsole().sendMessage("§5[MySQL] §4Verbindung wurde aufgebaut.");
			}catch(SQLException ex) {
				ProxyServer.getInstance().getConsole().sendMessage("§5[MySQL] §4Verbindung konnte nicht aufgebaut werden.");
			}
		}
	}

	@SuppressWarnings("deprecation")
	public static void disconnect() {
		if(isConnected()) {
			try{
				con.close();
				ProxyServer.getInstance().getConsole().sendMessage("§5[MySQL] §4Verbindung wurde aufgebaut.");
			}catch(SQLException ex) {
				ProxyServer.getInstance().getConsole().sendMessage("§5[MySQL] §4Verbindung konnte nicht aufgebaut werden.");
			}
		}
	}

	public static void createTable() {
		if(isConnected()) {
			try{
				PreparedStatement ps = getConnection().prepareStatement("CREATE TABLE IF NOT EXISTS BanPlugin (Spielername VARCHAR(100), UUID VARCHAR(100), Ende VARCHAR(100), Grund VARCHAR(200))");
				ps.executeUpdate();
				ps.close();
			}catch(SQLException ex) {
				ex.printStackTrace();
			}
		}
	}

	public static boolean isPlayerExisting(String uuid) {
		try{
			PreparedStatement ps = getConnection().prepareStatement("SELECT * FROM BanPlugin WHERE UUID = '"+uuid+"'");
			ps.executeUpdate();
			ResultSet rs = ps.executeQuery();
			boolean exists = rs.next();
			rs.close();
			ps.close();
			return exists;
		}catch(SQLException ex) {
			ex.printStackTrace();
		}
		return false;
	}

	public static void addPlayer(String name, String uuid, long end, String reason) {
		try{
			PreparedStatement ps = getConnection().prepareStatement("INSERT INTO BanPlugin (Spielername, UUID, Ende, Grund) VALUES ('"+name+"', '"+uuid+"', '"+end+"', '"+reason+"')");
			ps.execute();
			ps.close();
		}catch(SQLException ex) {
			ex.printStackTrace();
		}
	}
}