package Ch.Dkrieger.Bedwars.MySQL;

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

import Ch.Dkrieger.Bedwars.API.Bedwars;

public class MySQL{

	public static String host = "localhost";
	public static String port = "3306";
	public static String user = "root";
	public static String password = "CXG34twryNE7DME";
	public static String database = "DKNick";
	public static Connection conn;

	public static void connect(){
		if(!isConnect()){
			try {
				conn = DriverManager.getConnection("jdbc:mysql://" + host + ":"+port+"/" + database + "?autoReconnect=true",user, password);
				System.out.println(Bedwars.prefix+"§eMySQL §7Verbindung erfolgreich aufgebaut!");
			} catch (SQLException e) {
				System.out.println(Bedwars.prefix+" §eMySQL §7Konnte nicht zur Datenbank verbinden");
				System.out.println(Bedwars.prefix+" §eMySQL §7prüfen sie Ihre UserDaten");
			}
		}
	}
	public static void disconect(){
		if(isConnect()){
			try {
				conn.close();
				System.out.println(Bedwars.prefix+" §§MySQL §7Verbindung wurde geschlossen!");
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
	public static boolean isConnect(){
		return (conn==null? false : true);
	}
	public static void update(String qry){
		try{
	    	PreparedStatement ps = conn.prepareStatement(qry);
	    	ps.executeUpdate();
		}catch(SQLException e){
			e.printStackTrace();
		}
	}
	public static ResultSet getResult(String qry){
		try{
		PreparedStatement ps = conn.prepareStatement(qry);
		return ps.executeQuery();
		}catch(SQLException e){
			e.printStackTrace();
		}
		return null;
	}
	public static Connection getConnecion(){
		return conn;
	}
}