MySQL.java

package fr.jackycraft.vigilance;

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

import com.mysql.jdbc.PreparedStatement;

import net.md_5.bungee.api.connection.ProxiedPlayer;

public class MySQL {
    private java.sql.Connection connection;
    private String urlbase, host, database, user, pass;



	public MySQL(String urlbase, String host, String database, String user, String pass) {
		this.urlbase = urlbase;
		this.host = host;
		this.database = database;
		this.user = user;
		this.pass = pass;
	}

	public void connection() {
		if(!isConnected()){
			try {
				connection = DriverManager.getConnection(urlbase + host + "/" + database, user, pass);
				System.out.println("VigilanceExtends: MySQL connected !");
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}



	}

	public void disconnect() {
		if(isConnected()){
			try {
				connection.close();
				System.out.println("VigilanceExtends: MySQL disconnected !");
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}



	}

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


 	public void openConnection() throws SQLException, ClassNotFoundException {

    }

    public void createAccount(ProxiedPlayer player){
    	if(!hasAccount(player)){
    		//INSERT
    		try {
				java.sql.PreparedStatement q = connection.prepareStatement("INSERT INTO vigilancekicks(uuid, kicks, reason1, reason2, reason3, banned, reason) VALUES (?, ?, ?, ?, ?, ?, ?) ");
				q.setString(1, player.getUniqueId().toString());
				q.setInt(2, 0);
				q.setString(3, "d"+ player.getName());
				q.setString(4, "d" + player.getName());
				q.setString(5, "d" +player.getName() );
				q.setInt(6, 0);
				q.setString(7, "d"+ player.getName());
				q.execute();
				q.close();


    		} catch (SQLException e) {
				e.printStackTrace();
			}
    	}
    }

    public boolean hasAccount(ProxiedPlayer player){
    	//SELECT
    	try {
			PreparedStatement q = (PreparedStatement) connection.prepareStatement("SELECT uuid FROM vigilancekicks WHERE uuid = ?");
			q.setString(1, player.getUniqueId().toString());
			ResultSet resultat = q.executeQuery();
			boolean hasAccount = resultat.next();
			q.close();
			return hasAccount;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}


    	return false;
    }

    public int getKicked(ProxiedPlayer player){
    	return 0;
    }

    public void addKicked(ProxiedPlayer player, int amount){
    	//UPDATE
    }

    public void removeKicked(ProxiedPlayer player, int amount){
    	//UPDATE

    }
}