package de.clashside.main;

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



public class mysql {


	public static String HOST = "localhost";
	public static String PORT = "3306";
	public static String DATABASE = "ClashSide";
	public static String USER = "root";
	public static String PASSWORD = "vX3CmZcJ";
	public static Connection con;


	public static void connect() {
		if(!isConnected()) {
			try {
								 con = DriverManager.getConnection("jdbc:mysql://" + HOST + ":3306/" + DATABASE, USER, PASSWORD);
				System.out.println("[MYSQL] Verbindung erfolreich aufgebaut");
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}

	}

	public static void disconnect() {
		if(isConnected()) {
			try {
				con.close();
				System.out.println("[MYSQL] Wurde erfolgreich geschlossen");
			} catch (SQLException e) {
				e.printStackTrace();
			}

		}
	}

	public static boolean isConnected() {
	return (con == null ? false : true);

	}



	public static void createTable() {


	}


	public static ResultSet getResult(String qry) {
		try {
			PreparedStatement ps = con.prepareStatement(qry);
			return ps.executeQuery();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return null;
	}


	public static PreparedStatement getStatement(String sql) {
		if(isConnected()){
			PreparedStatement ps;
			try {
				ps = con.prepareStatement(sql);
				return ps;
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}

		return null;
	}
	public static void Update(String qry){
        try{
            Statement stmt = con.createStatement();
            stmt.executeUpdate(qry);
        }catch(Exception e){
            e.printStackTrace();
        }
    }

	public static ResultSet Query(String query) throws SQLException {
        Statement statement = con.createStatement();
        return statement.executeQuery(query);
    }


}