package database;

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

public class Database {

    public static Database myDB;

    private static final String MYSQL_SERVER_PASSWORD = "GNz7ZJdGfzxm";
    private static final String MYSQL_SERVER_ADDRESS = "jdbc:mysql://hand4help.com:3306/hand4help?useUnicode=true&characterEncoding=UTF-8";
    private static final String MYSQL_SERVER_USERNAME = "h4hremote";
    private static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";

    private Connection conn;

    private Database() {
        try {
            Class.forName(JDBC_DRIVER);
            conn = DriverManager.getConnection(MYSQL_SERVER_ADDRESS, MYSQL_SERVER_USERNAME, MYSQL_SERVER_PASSWORD);
            if (conn == null) {
                System.out.println("Connection is null, abort");
                throw new SQLException("Connection is null, abort");
            }
        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }
    }

    public static Database getInstance() {
        if (myDB == null) {
            myDB = new Database();
        }
        return myDB;
    }

    public Connection getConn() {
        return conn;
    }

}