part 1: 原始版
public class JDBCUtil {
/**
* 获取连接操作
* @return
* @throws Exception
*/
public static Connection getConnection() throws Exception {
// 获取数据库四要素:读取配置文件
InputStream in = ClassLoader.getSystemClassLoader().getResourceAsStream("jdbc.properties");
Properties pros = new Properties();
pros.load(in);
String driverClass = pros.getProperty("driverClass");
String url = pros.getProperty("url");
String user = pros.getProperty("user");
String password = pros.getProperty("password");
Class.forName(driverClass);
return DriverManager.getConnection(url, user, password);
}
/**
* 关闭资源的操作
* @param conn
* @param ps
*/
public static void closeResource(Connection conn,PreparedStatement ps){
try {
if(ps != null)
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
try {
if(conn != null)
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void closeResource(Connection conn, PreparedStatement ps, ResultSet rs){
try {
if(ps != null)
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
try {
if(conn != null)
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
try {
if(rs != null)
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
url=jdbc:mysql://localhost:13306/test?rewriteBatchedStatements=true
user=root
password=root
driverClass=com.mysql.jdbc.Driver
public abstract class BaseDAO {
// 通用的增删改操作----Version 2.0
public int update(Connection conn, String sql, Object ...args) {//sql中的占位符的个数与args参数的个数一致
PreparedStatement ps = null;
try {
ps = conn.prepareStatement(sql);
for (int i = 0; i < args.length; i++) {
ps.setObject(i + 1,args[i]);
}
int i = ps.executeUpdate();
return i;
} catch (Exception e) {
e.printStackTrace();
} finally {
JDBCUtil.closeResource(null,ps);
}
return 0;
}
/**
* 通用的查询操作,用于返回数据表的一条记录,version 2.0 考虑了事务
* @param clazz
* @param sql
* @param args
* @param <T>
* @return
*/
public <T> T getInstance(Connection conn,Class<T> clazz,String sql, Object ...args) {
PreparedStatement ps = null;
ResultSet rs = null;
try {
ps = conn.prepareStatement(sql);
for (int i = 0; i < args.length; i++) {
ps.setObject(i + 1,args[i]);
}
rs = ps.executeQuery();
if(rs.next()){
T t = clazz.newInstance();
ResultSetMetaData metaData = rs.getMetaData();
int columnCount = metaData.getColumnCount();
for (int i = 0; i < columnCount; i++) {
Object columnValue = rs.getObject(i + 1);
String columnLabel = metaData.getColumnLabel(i + 1);
Field field = clazz.getDeclaredField(columnLabel);
field.setAccessible(true);
field.set(t,columnValue);
}
return t;
}
} catch (Exception e) {
e.printStackTrace();
} finally {
JDBCUtil.closeResource(conn,ps,rs);
}
return null;
}
/**
* 返回不同表的多条查询记录
* @param clazz
* @param sql
* @param args
* @param <T>
* @return
*/
public <T> List<T> getInstanceList(Connection conn,Class<T> clazz, String sql, Object ...args){
PreparedStatement ps = null;
ResultSet rs = null;
try {
ps = conn.prepareStatement(sql);
for (int i = 0; i < args.length; i++) {
ps.setObject(i + 1,args[i]);
}
rs = ps.executeQuery();
List<T> list = new ArrayList<>();
while(rs.next()){
T t = clazz.newInstance();
ResultSetMetaData metaData = rs.getMetaData();
int columnCount = metaData.getColumnCount();
for (int i = 0; i < columnCount; i++) {
Object columnValue = rs.getObject(i + 1);
String columnLabel = metaData.getColumnLabel(i + 1);
Field field = clazz.getDeclaredField(columnLabel);
field.setAccessible(true);
field.set(t,columnValue);
}
list.add(t);
}
return list;
} catch (Exception e) {
e.printStackTrace();
} finally {
JDBCUtil.closeResource(null,ps,rs);
}
return null;
}
// 用于查询通用值的查询方法
public <E> E getValue(Connection conn,String sql,Object...args) {
PreparedStatement ps = null;
ResultSet rs = null;
try {
ps = conn.prepareStatement(sql);
for (in