JDBC连接的工具类
通用的数据库连接工具类
降低了对数据库的依赖,可以通过修改配置文件中的配置信息来使用不同的数据库或用户信息
----------------------------------------------------------------------------------------------------
src下面创建一个文件: dbinfo.properties
className=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/day14
user=root
password=123456
----------------------------------------------------------------------------------------------------
public class JdbcUtil {
private static String className;
private static String url;
private static String user;
private static String password;
static{
try {
// 使用类加载器读取配置文件中的信息
InputStream in = JdbcUtil.class.getClassLoader().getResourceAsStream("dbinfo.properties");
Properties props = new Properties();
props.load(in);
className = props.getProperty("className");
url = props.getProperty("url");
user = props.getProperty("user");
password = props.getProperty("password");
Class.forName(className);
} catch (Exception e) {
e.printStackTrace();
}
}
public static Connection getConnection() throws Exception{
return DriverManager.getConnection(url,user,password);
}
public static void release(ResultSet rs,Statement stmt,Connection conn){
if(rs!=null){
try{
rs.close();
}catch(SQLException e){
e.printStackTrace();
}
rs = null;
}
if(stmt!=null){
try{
stmt.close();
}catch(SQLException e){
e.printStackTrace();
}
stmt = null;
}
if(conn!=null){
try{
conn.close();
}catch(SQLException e){
e.printStackTrace();
}
conn = null;
}
}
}
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
通用的数据库连接工具类
降低了对数据库的依赖,可以通过修改配置文件中的配置信息来使用不同的数据库或用户信息
----------------------------------------------------------------------------------------------------
src下面创建一个文件: dbinfo.properties
className=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/day14
user=root
password=123456
----------------------------------------------------------------------------------------------------
public class JdbcUtil {
private static String className;
private static String url;
private static String user;
private static String password;
static{
try {
// 使用类加载器读取配置文件中的信息
InputStream in = JdbcUtil.class.getClassLoader().getResourceAsStream("dbinfo.properties");
Properties props = new Properties();
props.load(in);
className = props.getProperty("className");
url = props.getProperty("url");
user = props.getProperty("user");
password = props.getProperty("password");
Class.forName(className);
} catch (Exception e) {
e.printStackTrace();
}
}
public static Connection getConnection() throws Exception{
return DriverManager.getConnection(url,user,password);
}
public static void release(ResultSet rs,Statement stmt,Connection conn){
if(rs!=null){
try{
rs.close();
}catch(SQLException e){
e.printStackTrace();
}
rs = null;
}
if(stmt!=null){
try{
stmt.close();
}catch(SQLException e){
e.printStackTrace();
}
stmt = null;
}
if(conn!=null){
try{
conn.close();
}catch(SQLException e){
e.printStackTrace();
}
conn = null;
}
}
}
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------