package de.ktpvp.de.FFA.mysql;

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



public class Connector {

	public static String host = "localhost";
	public static String port = "3306";
	public static String database = "FFA";
	public static String username = "localhost";
	public static String password = "ZockerBoysHD1";

	public static java.sql.Connection con;


	public static void connect(){
		if(!isConnected()){
			try {
				con = DriverManager.getConnection("jdbc:mysql//"+host+":"+port+"/"+database,username,password);
				System.out.println("[MySQL] Verbindung aufgebaut!");
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}



	}
	public static void disconnect(){
		if(isConnected()){
			try {
				con.close();
				System.out.println("[MySQL] Verbindung Geschlossen!");
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}

	}
	public static boolean isConnected(){

		return(con == null ? false : true);


	}
	public static void Update(String qry){
		java.sql.PreparedStatement ps;
		try {
			ps = con.prepareStatement(qry);
			ps.executeUpdate();
		} catch (SQLException e1) {
			e1.printStackTrace();
		}


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

	}
}