public class MySQL {

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

	private Connection con;

	public MySQL(String host, String databse, String user, String password) {
		this.HOST =  host;
		this.DATABASE =  databse;
		this.USER = user;
		this.PASSWORD = password;

		connect();
	}

	private void connect() {
		try{
			con = DriverManager.getConnection("jdbc:mysql://" + HOST + ":3306/"+ DATABASE + "?autoReconnect=true", USER , PASSWORD);
            System.out.println("[ScrCloud] MySQL Connected !");
		}catch (SQLException e) {
			System.out.println("[ScrCloud] SystemError , ErrorCode : "+e.getMessage());
			e.printStackTrace();
		}

	}
	public void close() {
		try {
			if(con != null) {
				con.close();
				System.out.println("[ScrCloud] Conection to MySQL is offline ");
			}
		} catch (SQLException e) {
			System.out.println("[ScrCloud] SystemError , ErrorCode : "+e.getMessage());
			e.printStackTrace();
		}
	}

	public void update(String qry) {
		try {
			Statement st = con.createStatement();
			st.executeUpdate(qry);
			st.close();
		} catch (SQLException e) {
			connect();
			System.err.println(e);
		}

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

			e.printStackTrace();
		}
		return rs;
	}
}