import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DatabaseConnection {

	/**
	 * Define MySQL connection info.
	 */
	static final String host = "mysql9.000webhost.com";
	static final String db = "a8193581_xorcist";
	static final String user = "a8193581_xorcist";
	static final String pass = "bjballer79";;
	static final String port = "3306";

	/**
	 * The database connection in use
	 */
	private Connection con;
	/**
	 * A statement for running queries on
	 */
	private Statement statement;
	/**
	 * The last query being executed
	 */
	private String lastQuery;

	static {
		testForDriver();
	}

	/**
	 * Tests we have a mysql Driver
	 */
	private static void testForDriver() {
		try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException cnfe) {
			Misc.println("Class not found exception");
		}
	}

	/**
	 * Instantiates a new database connection
	 */
	public DatabaseConnection() {
		if (!createConnection()) {
			Misc.println("Unable to connect to MySQL");
			System.exit(1);
		}
	}

	public boolean createConnection() {
		try {
			con = DriverManager.getConnection("jdbc:mysql://" + host + ":"
					+ port + "/" + db, user, pass);
			statement = con.createStatement();
			statement.setEscapeProcessing(true);
			return isConnected();
		} catch (SQLException e) {
			Misc.println(e.getMessage());
			return false;
		}
	}

	public boolean isConnected() {
		try {
			statement.executeQuery("SELECT CURRENT_DATE");
			return true;
		} catch (SQLException e) {
			return false;
		}
	}

	/**
	 * Runs a select query on the current database connection
	 *
	 * @param s
	 *            The query to be ran
	 */
	public ResultSet getQuery(String q) throws SQLException {
		try {
			lastQuery = q;
			return statement.executeQuery(q);
		} catch (SQLException e) {
			if (!isConnected() && createConnection()) {
				return getQuery(q);
			}
			throw new SQLException(e.getMessage() + ": '" + lastQuery + "'", e
					.getSQLState(), e.getErrorCode());
		}
	}

	/**
	 * Runs a update/insert/replace query on the current database connection
	 *
	 * @param s
	 *            The query to be ran
	 */
	public int updateQuery(String q) throws SQLException {
		try {
			lastQuery = q;
			return statement.executeUpdate(q);
		} catch (SQLException e) {
			if (!isConnected() && createConnection()) {
				return updateQuery(q);
			}
			throw new SQLException(e.getMessage() + ": '" + lastQuery + "'", e.getSQLState(), e.getErrorCode());
		}
	}


	public int newQuery(String q) throws SQLException {
		try {
			Statement tempStatement = con.createStatement();
			lastQuery = q;
			return tempStatement.executeUpdate(q);
		} catch (SQLException e) {
			if (!isConnected() && createConnection()) {
				return updateQuery(q);
			}
			throw new SQLException(e.getMessage() + ": '" + lastQuery + "'", e
					.getSQLState(), e.getErrorCode());
		}
	}

	/**
	 * Closes the database conection.
	 *
	 * @throws SQLException
	 *             if there was an error when closing the connection
	 */
	public void close() throws SQLException {
		con.close();
		con = null;
	}

}