Skip to content

Commit 765bc72

Browse files
uurdevuurdev
committed
Connection managment class added
and config class rename configparam
1 parent 5f7c58f commit 765bc72

4 files changed

Lines changed: 47 additions & 29 deletions

File tree

‎.gitignore‎

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -10,3 +10,5 @@ db-example/target/classes/print/PrintDbResultSet.class
1010
db-example/target/classes/query/InsertQueryApi.class
1111
db-example/target/classes/query/SelectQueryApi.class
1212
db-example/.idea/vcs.xml
13+
db-example/.idea/uiDesigner.xml
14+
db-example/target/classes/config/DbConnectionManagement.class

‎db-example/src/main/java/Main.java‎

Lines changed: 2 additions & 28 deletions
Original file line numberDiff line numberDiff line change
@@ -1,38 +1,12 @@
1-
import config.DbConnectionConfig;
1+
import config.DbConnectionManagement;
22

33
import java.sql.Connection;
4-
import java.sql.DriverManager;
54
import java.sql.SQLException;
65

76
public class Main {
8-
97
public static void main(String[] args) {
10-
try {
11-
testConnectToDatabase(DbConnectionConfig.getDbHost(), DbConnectionConfig.getDbUsername(), DbConnectionConfig.getDbUserPassword(), DbConnectionConfig.getJdbcDriver());
12-
} catch (SQLException e) {
13-
e.printStackTrace();
14-
}
15-
}
168

17-
public static void testConnectToDatabase(String dbHost, String dbUser, String dbPassword, String jdbc) throws SQLException {
18-
Connection dbConnecttion = null;
19-
try {
20-
Class.forName(jdbc);
21-
dbConnecttion = DriverManager.getConnection(dbHost, dbUser, dbPassword);
9+
}
2210

23-
if (dbConnecttion != null) {
24-
System.out.println("Veritabanına baglanıldı");
25-
dbConnecttion.close();
26-
} else {
27-
System.out.println("Veritabanına erişim hatalı");
28-
}
2911

30-
} catch (Exception e) {
31-
e.printStackTrace();
32-
} finally {
33-
if (dbConnecttion != null) {
34-
dbConnecttion.close();
35-
}
36-
}
37-
}
3812
}

db-example/src/main/java/config/DbConnectionConfig.java renamed to db-example/src/main/java/config/DbConnectionConfigParam.java

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,6 @@
11
package config;
22

3-
public class DbConnectionConfig {
3+
public class DbConnectionConfigParam {
44

55
private final static String DB_HOST = "jdbc:mysql://remotemysql.com:3306/BiEfcKCYFs?useSSL=false";
66
private final static String DB_USERNAME = "BiEfcKCYFs";
@@ -22,4 +22,5 @@ public static String getDbUserPassword() {
2222
public static String getJdbcDriver() {
2323
return JDBC_DRIVER;
2424
}
25+
2526
}

‎db-example/src/main/java/config/DbConnectionManagement.java‎

Lines changed: 41 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,41 @@
1+
package config;
2+
3+
import java.sql.Connection;
4+
import java.sql.DriverManager;
5+
import java.sql.SQLException;
6+
7+
public class DbConnectionManagement {
8+
9+
/*
10+
bu metod final olarak belırlenmıs ," dbhost-dbusername-dbpassword-dbjdbc " 4 parametre ile bir conneciton nesnesi oluşturur ve bu nesneyi döner
11+
*/
12+
public static Connection connectToDatabase() {
13+
Connection dbConnection = null;
14+
try {
15+
Class.forName(DbConnectionConfigParam.getJdbcDriver());
16+
dbConnection = DriverManager.getConnection(DbConnectionConfigParam.getDbHost(), DbConnectionConfigParam.getDbUsername(), DbConnectionConfigParam.getDbUserPassword());
17+
18+
if (dbConnection != null) {
19+
System.out.println("Veritabanına baglanıldı");
20+
} else {
21+
System.out.println("Veritabanına erişim hatalı");
22+
}
23+
} catch (Exception e) {
24+
e.printStackTrace();
25+
}
26+
return dbConnection;
27+
}
28+
29+
30+
/*
31+
Bu metod dışarıdan verılen açık database baglantısını kapatır
32+
*/
33+
public static void killDbConnection(Connection connection) throws SQLException {
34+
//veritabanı baglantısı hala mevcutsa baglantıyı yok eder
35+
if (connection != null) {
36+
connection.close();
37+
System.out.println("Veritabanı bağlantısı silindi");
38+
}
39+
40+
}
41+
}

0 commit comments

Comments
 (0)