增删改的通用方法
/**
* 增删改的通用方法
*
* @param sql
* @param objects
* @return
*/
public static int executeUpdate(String sql, Object... objects) {
int result = 0;
Connection conn = null;
PreparedStatement psmt = null;
try {
conn = getConnection();
psmt = conn.prepareStatement(sql);
if (objects != null) {
for (int i = 0; i < objects.length; i++) {
psmt.setObject(i + 1, objects[i]); // 下标从1开始的
}
}
result = psmt.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally {
close(conn, psmt, null);
}
return result;
}
查询的通用方法
/**
* 查询的通用方法
*
* @param sql
* @param rsHandler
* @param objects
* @return
*/
public static Object executeQuery(String sql, IResultSetUtil rsHandler,
Object... objects) {
Connection connection = null;
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
try {
connection = getConnection();
preparedStatement = connection.prepareStatement(sql);
if (objects != null) {
for (int i = 0; i < objects.length; i++) {
preparedStatement.setObject(i + 1, objects[i]);
}
}
resultSet = preparedStatement.executeQuery();
return rsHandler.doHandler(resultSet);
} catch (Exception e) {
e.printStackTrace();
} finally {
close(connection, preparedStatement, resultSet);
}
return null;
}
查询单个字段值的通用方法
/**
* 查询单个字段值的通用方法
*
* @param sql
* @param objects
* @return
*/
public static Object executeQuery(String sql, Object... objects) {
return executeQuery(sql, new IResultSetUtil() {
@Override
public Object doHandler(ResultSet rs) throws SQLException {
Object object = null;
if (rs.next()) {
object = rs.getObject(1);
}
return object;
}
}, objects);
}