时间:2021-07-01 10:21:17 帮助过:3人阅读
package com.demo.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ResourceBundle;
public class jdbcUtils {
public static final String DRIVERCLASS;
public static final String URL;
public static final String USERNAME;
public static final String PASSWORD;
static{
//加载配置文件
ResourceBundle bundle =ResourceBundle.getBundle("db");
DRIVERCLASS=bundle.getString("jdbc.driverClass");
URL =bundle.getString("jdbc.url");
USERNAME =bundle.getString("jdbc.username");
PASSWORD =bundle.getString("jdbc.password");
}
//静态方法加载驱动
static{
try {
Class.forName(DRIVERCLASS);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
//获取连接
public static Connection getConnection() throws Exception{
return DriverManager.getConnection(URL,USERNAME,PASSWORD);
}
//释放资源
public static void closeReasoure(Connection conn,Statement st,ResultSet rs ){
closeResultSet(rs);
closeStatement(st);
closeConn(conn);
}
public static void closeConn(Connection conn){
if(conn !=null){
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
conn=null;
}
}
}
public static void closeStatement(Statement st){
if(st !=null){
try {
st.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
st=null;
}
}
}
public static void closeResultSet(ResultSet rs){
if(rs !=null){
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
rs=null;
}
}
}
}
数据库同步软件
[easou 数据库同步注册]jdbc数据库连接之jdbcUtils工具类抽取
标签:void jdb url utils password tco title 释放 exception