Java-JDBC-工具类

阿࿆杰࿆ 2020-10-26 11:23:12

/*
*导入数据库需要加载的驱动包
*不是原创根据原作者所改https://me.csdn.net/weixin_42404323?ref=miniprofile
*/
public class jdbcUtil {
/*
* 静态驱动加载 mysql驱动包
* */
static {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}

/*
* 创建连接对象
*/
public static Connection getConnection() throws SQLException {
String url="jdbc:mysql://localhost:3306/stuDB?useUnicode=true&characterEncoding=utf8";//链接地址
String user="root";//用户名
String password="123456";//密码
return DriverManager.getConnection(url, user, password);
}

/*
* 关闭增删改操作的连接对象
*/
public static void Close(Connection coon,PreparedStatement stmt) {
if (stmt!=null) {
try {
stmt.close();
coon.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
/*
* 关闭读取连接对象
*/
public static void Close(Connection coon,PreparedStatement stmt,ResultSet rs) {
if (rs!=null) {
try {
rs.close();
stmt.close();
coon.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
/*
* 增删改操作的方法
* String sql 执行增删改的SQL语句
* Object[] parems 操作参数
*/
public static int NonQuery(String sql,Object[] parems) {
Connection coon = null;
PreparedStatement stmt = null;
int rowCount = 0;
try {
coon = getConnection();
stmt = coon.prepareStatement(sql);
if (parems!=null&&parems.length>0) {
for (int i = 0; i < parems.length; i++) {
stmt.setObject(i+1, parems[i]);
}
}
rowCount = stmt.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
Close(coon,stmt);
}
return rowCount;
}

/*
* 泛型查询
* String sql 执行增删改的SQL语句
* Object[] parems 操作参数
* RowsMapper<T> rm 自定义泛型类字段读取接口 --获取实体类信息
*/
public static<T> ArrayList<T> GenericQeruy(String sql,Object[] parems,RowsMapper<T> rm){
Connection coon = null;
PreparedStatement stmt = null;
ResultSet rs = null;
ArrayList<T> list = new ArrayList<T>();
try {
coon = getConnection();
stmt = coon.prepareStatement(sql);
if (parems!=null&&parems.length>0) {
for (int i = 0; i < parems.length; i++) {
stmt.setObject(i+1, parems[i]);
}
}
rs = stmt.executeQuery();
while(rs.next()) {
T t = rm.getEntity(rs);
list.add(t);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
Close(coon, stmt, rs);
}
return list;
}
}

...全文