Changeset 501396e for src/main/java/com/example/cookbook/dbConfig/DB.java

Timestamp:

02/03/24 15:58:58 (9 months ago)

Author:

Blazho <aleksandar.blazhevski@…>

Branches:

master

Children:

aea04dd

Parents:

3e572eb

Message:

added missing files

File:

• src/main/java/com/example/cookbook/dbConfig/DB.java (modified) (1 diff)

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

@@ -1 @@
-package com.example.cookbook.dbConfig;public class DB {
+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";
+
+    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";
+
+
+    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();
+        }
+    }
 }
+