业务场景:保存业务数据表的时候,同时记录下日志。
import java.sql.Connection;
import java.sql.DriverManager;
public class DBUtil {
// 数据库配置
private static final String driver = "com.mysql.jdbc.Driver";
private static final String url = "jdbc:mysql://localhost:3306/test";
private static final String username = "root";
private static final String password = "root";
private static Connection conn = null;
public static Connection getDbConnection() {
try {
Class.forName(driver);
conn = DriverManager.getConnection(url, username, password);
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
// 关闭数据库连接
public static void closeDbConnection() {
try {
if (conn != null) {
conn.close();
}
} catch (Exception e) {