source: src/main/java/com/example/cookbook/dbConfig/DB.java

package com.example.cookbook.dbConfig;


import org.springframework.stereotype.Component;


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

@Component
public class DB {
//    private static final String SSH_HOST = "194.149.135.130";
//    private static final String SSH_USER = "t_cbdb";
//    private static final String SSH_PASSWORD = "b6cd27a3";


    //Remote database parameters
    private static final String DB_URL = "jdbc:postgresql://localhost:9999/db_202324z_va_prj_cbdb";
    private static final String DB_USERNAME = "db_202324z_va_prj_cbdb_owner";
    private static final String DB_PASSWORD = "d922daf2bfec";


    //Local database parameters
    private static final String LDB_URL = "jdbc:postgresql://localhost:5432/cbdb";
    private static final String LDB_USERNAME = "postgres";
    private static final String LDB_PASSWORD = "04UF@bak";

    private static Connection connection = null;






    private static void setConnection() throws SQLException {

        if (connection == null || connection.isClosed()){
            connection = DriverManager.getConnection(LDB_URL, LDB_USERNAME, LDB_PASSWORD);
            connection.createStatement().execute("set search_path to project");
        }
    }

    public static Connection getConnection() throws SQLException {
        setConnection();
        return connection;
    }


    public static void closeConnection() throws SQLException {
        if (connection != null){
            connection.close();
        }
    }
}