该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
来了 工具类如下
package Util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class DBUtil {
private static final String DRIVER = "com.mysql.jdbc.Driver";
private static final String USERNAME = "root";
private static final String PASSWORD = "root";
private static final String URL = "jdbc:mysql://localhost:3306/java?useUnicode=true&characterEncoding=UTF-8";
private static Connection conn = null;
static{
try {
Class.forName(DRIVER);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection getConnection() throws Exception{
if(conn == null){
conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
return conn;
}
return conn;
}
public static void closeAll(ResultSet rs,PreparedStatement ps,Connection conn){
if(rs != null){
try {
rs.close();
rs = null;
} catch (SQLException e) {
e.printStackTrace();
}
}
if(ps != null){
try {
ps.close();
ps = null;
} catch (SQLException e) {
e.printStackTrace();
}
}
if(conn != null){
try {
conn.close();
conn = null;
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}