public class JDBCUtil{
public static DataSource datasource;
static{
try{
Properties properties=new Properties();
properties.load(JDBCUtil.class.getClassLoader().getResourceStream("properties"));
datasource=DruidDataSourceFactory.createDataSource(properties);
}catch(Exception e){
e.printStackTrace();
}
}
public static Connection getConnection(){
Connection connection=null;
try{
connection=datasource.getConnection();
}catch(Exception e){
e.printStackTrace();
}
}
public static void close(Connection connection){
try{
connection.close();
}catch(Exception e){
e.printStackTrace();
}
public static void close(ResultSet rs, Statement statement,
Connection connection) {
try {
if (rs != null) {
rs.close();
}
if (statement != null) {
statement.close();
}
if (connection != null) {
connection.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
DBUtil工具类的编写
最新推荐文章于 2022-09-19 23:47:47 发布