JDBC封装工具类
1.配置文件(注意配置文件放在src目录下
db.properties
driverName=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/db_exer?useUnicode=true&characterEncoding=UTF-8
username=root
password=root
2.JDBCUtils实现类
JDBCUtils.java
package com.yang.util;
import java.io.IOException;
import java.sql.*;
import java.util.Properties;
/**
* @author WangYang
* @version 1.0
* @create 2020-02-27 9:09
*
* 分装JDBC 工具类
*/
public class JDBCUtils {
private static Properties p;
static {
try {
//加载配置文件
p = new Properties();
p.load(Thread.currentThread().getContextClassLoader().getResourceAsStream("db.properties"));
Class.forName(p.getProperty("driverName"));
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 获取Connection对象
* @return Connection对象
*/
public static Connection getConnection() {
try {
return DriverManager.getConnection(p.getProperty("url"),p.getProperty("username"),p.getProperty("password"));
} catch (SQLException e) {
System.err.println("获取Connection连接失败!");
e.printStackTrace();
}
return null;
}
/**
* 释放资源方法
* @param rs 结果集对象
* @param st 语句对象
* @param conn 连接对象
*/
public static void close(ResultSet rs, Statement st, Connection conn){
if(rs != null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(st != null){
try {
st.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (conn != null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}