package fr.elecube.core.utils;

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

import fr.elecube.core.ElecubeCore;

public class SQL {
	public ElecubeCore plugin;
	public SQL(ElecubeCore main){
		this.plugin = main;
	}
	//on connect la BDD
	 private String url = "jdbc:mysql://adresse de bdd/bdd";
	 private String user = "servers_user";
	 private String password = "ton mot de passe de bdd";
	 public Connection conn;
	 public ResultSet result;
	 public Statement state;

	 public void connect() {
		 try{
			 Class.forName("com.mysql.jdbc.Driver");

		 }
		 catch (ClassNotFoundException e1){
			 e1.printStackTrace();

		 }
		 try{
			 this.conn = DriverManager.getConnection(url, user, password);
			 System.out.println("Connexion établie:");
		 }
		 catch (SQLException e){
			 e.printStackTrace();
		 }
		 }
	 //INSERT INTO VALUES SELECT FROM WHERE SET UPDATE -- mots clés importants

	 public void CreateAccount(String pseudo, String uuid, String mute, String raison_mute, String ban, String raison_ban, String banip, String raison_banip ){
		 try{
	            Statement state = this.conn.createStatement();
	            state.executeUpdate("INSERT INTO sanctions (pseudo, uuid, mute, raison_mute, ban, raison_ban, banip, raison_banip) VALUES ('"+ pseudo +"', "+uuid+", "+ mute +", "+ raison_mute +", "+ ban +", "+ raison_ban +", "+ banip +", "+ raison_banip +", )");
	            state.close();
	        }catch(SQLException SQLE)
	        {
	            SQLE.printStackTrace();
	        }
	    }

	 public String getName(String pseudo)
	    {
	        try{
	            this.state = this.conn.createStatement();
	            this.result = this.state.executeQuery("SELECT * FROM sanctions WHERE pseudo = '"+pseudo+"'");

	            while(this.result.next())
	            {
	                return this.result.getString(1);
	            }
	            //state.close();
	        }catch(SQLException SQLE){
	            SQLE.printStackTrace();
	        }
	        return "null";
	    }


}