-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathDBUtil.java
More file actions
74 lines (59 loc) · 1.38 KB
/
Copy pathDBUtil.java
File metadata and controls
74 lines (59 loc) · 1.38 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
package com.feeyo.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
/**
*
* @author [email protected]
*
*/
public class DBUtil {
private static final Logger LOGGER = LoggerFactory.getLogger(DBUtil.class);
static {
try {
Class.forName("org.sqlite.JDBC");
} catch (ClassNotFoundException e) {
LOGGER.error(e.getMessage());
}
}
public static Connection getConnection() {
String dbUrl = Globals.getXMLProperty("database.url");
try {
return DriverManager.getConnection(dbUrl);
} catch (SQLException e) {
LOGGER.error(e.getMessage());
}
return null;
}
public static void close(Connection connection, Statement stat, ResultSet rs) {
try {
if (rs != null && !rs.isClosed()) {
rs.close();
}
if (stat != null && !stat.isClosed()) {
stat.close();
}
if (connection != null && !connection.isClosed()) {
connection.close();
}
} catch (SQLException e) {
LOGGER.error(e.getMessage());
}
}
public static void close(Connection conn, Statement stat) {
try {
if (stat != null && !stat.isClosed()) {
stat.close();
}
if (conn != null && !conn.isClosed()) {
conn.close();
}
} catch (SQLException e) {
LOGGER.error(e.getMessage());
}
}
}