package test;

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

public class Database {

	private static Connection conn;
	private static Statement stm;

	public static Connection connectToDatabase(String url, String username, String password)
			throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException {
		/* Call the driver class' no argument constructor */
		Class.forName("org.mariadb.jdbc.Driver").newInstance();

		/* get Connection object via the DriverManager */
		return (Connection) DriverManager.getConnection(url, username, password);
	}

	public Database(String server, int port, String database, String username, String password)
			throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException {
		conn = connectToDatabase("jdbc:mysql://" + server + ":" + port + "/" + database, username, password);
		stm = conn.createStatement();
	}

	public Database() throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException {
		this(DBConstant.server, DBConstant.port, DBConstant.database, DBConstant.username, DBConstant.password);
	}

	public static ResultSet doQuery(String command) throws SQLException {
		return stm.executeQuery(command);
	}

	public static int doUpdate(String command) throws SQLException {
		return stm.executeUpdate(command);
	}

}