import java.sql.*;
import java.util.ResourceBundle;
public class DBUtils {
//资源绑定
private static ResourceBundle bundle = ResourceBundle.getBundle("resources/db");
static {
try {
//注册驱动
Class.forName(bundle.getString("driver"));
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
//关闭资源
public static void close(Connection conn, Statement stm, ResultSet rs){
if(rs!=null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(stm!=null){
try {
stm.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public static Connection getConnection() throws SQLException {
String url = bundle.getString("url");
String user = bundle.getString("user");
String password = bundle.getString("password");
Connection conn = DriverManager.getConnection(url, user, password);
return conn;
}
}
jdbc工具类
最新推荐文章于 2024-09-25 15:32:02 发布