package DBControl;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.SQLException;
import java.util.logging.Logger;

public class ConnectionFactory {

	private static final Logger LOGGER = Logger.getLogger(ConnectionFactory.class.getName());
	private static final String DRIVER = "com.mysql.cj.jdbc.Driver";
	private static final String DBURL = "jdbc:mysql://localhost:3306/schooldb";
	private static final String USER = "root";
	private static final String PASSWORD = "";
	private static Connection connect = null;
	private static Statement stmt = null;

	public static ConnectionFactory singleInstance = new ConnectionFactory();

	public static Connection createConnection() {
		try {
			System.out.println("connecting");
			connect = DriverManager.getConnection(DBURL,USER,PASSWORD);
			System.out.println("Connected");
		}catch(Exception ex) {
			ex.printStackTrace();
		}
		return connect;
	}

	public static Connection getConnection() {
		return connect;
	}

	public static void close(Connection connection) {
		try {
			connection.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	}

	public static void close(Statement statement) {
		try {
			statement.close();
		}catch(Exception e) {
			e.printStackTrace();
		}
	}

	public static void close(ResultSet resultset) {
		try {
			resultset.close();
		}catch(Exception e){
			e.printStackTrace();
			}
	}
}