connectionClass.java

import java.sql.*;

public class connectionClass {
    static final String URL = "jdbc:mysql://localhost:3306/empl_java_imp";
    static final String USER = "root";
    static final String PASS = "root";

    private Connection conn;// returns it's object ie conn

    public connectionClass() {
        try {
            this.conn = DriverManager.getConnection(URL, USER, PASS);
            System.out.println("\nConnection Successful\n");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public PreparedStatement createPrepareStatement(String query) {
        try {
            return conn.prepareStatement(query);
        } catch (SQLException e) {
            e.printStackTrace();
            return null;
        }
    }

    public Statement createStatement() {
        try {
            return conn.createStatement();
        } catch (SQLException e) {
            e.printStackTrace();
            return null;
        }
    }

    public void closeConnection() {
        try {
            if (conn != null) conn.close();
            System.out.println("Connection closed.");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}