package de.vollzeitcrew.lobby.mysql;


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

import net.minecraft.server.v1_8_R3.RemoteStatusListener;



public class MySQL {

	private String HOST = "";
	private String DATABASE = "";
	private String USER = "";
	private String PASSWORD = "";

	private Connection con;

	public MySQL(String HOST, String DATABASE, String USER, String PASSWORD) {
		this.HOST = HOST;
		this.DATABASE= DATABASE;
		this.USER = USER;
		this.PASSWORD = PASSWORD;

		connect();
	}
	public void connect() {
		try {
			con = DriverManager.getConnection("jdbc:mysql://" + HOST + ":3306/" + DATABASE + "?autoReconnect=true", USER, PASSWORD);
		}catch (SQLException ex) {
			ex.printStackTrace();

		}
	}

	public void close() {
		try {
			if(con != null) {
				con.close();
			}
		}catch (SQLException ex) {
			ex.printStackTrace();

		}
	}

	public void update(String qry) {
		try {
			Statement st = con.createStatement();
			st.executeUpdate(qry);
			st.close();
		}catch (SQLException ex) {
			connect();
			ex.printStackTrace();

		}
	}

	public ResultSet query(String qry) {
		ResultSet rs = null;
		try {
			Statement st = con.createStatement();
			rs = st.executeQuery(qry);
		}catch (SQLException ex) {
			connect();
			ex.printStackTrace();

		}
		return rs;

	}

}