在前面的基础上完善了一下代码
新增了工具类,添加了几个方法以优化代码
实现
util包
DbHelper代码
这次工具类新增一个更新(增删改)的方法
package xyz.jrkang.util;
import java.sql.*;
/**
* Created by IntelliJ IDEA.
*
* @Date:2020/10/10
* @Time:20:06
* @Author:jiangrunkang
*/
public class DbHelper {
// 1.加载驱动
private static String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
private static String url = "jdbc:sqlserver://127.0.0.1:1433;databaseName=school";
private static String user = "sa";
private static String pwd = "123";
// 2.获取连接
public static Connection getConn() {
Connection conn = null;
try {
Class.forName(driver);
conn = DriverManager.getConnection(url, user, pwd);
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}
return conn;
}
// 3.资源的关闭
public static void close(Connection conn, PreparedStatement ps, ResultSet rs) {
try {
if (conn != null) {
conn.close();
}
if (ps != null) {
ps.close();
}
if (rs != null) {
rs.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
// 4.更新的调用
public static int update(String sql, Object[] objs) {
Connection conn = getConn();
PreparedStatement ps = null;
int count = 0;
try {
ps = conn.prepareStatement(sql);
for (int i = 0; i < objs.length; i++) {
ps.setObject(i + 1, objs[i]);
}
count = ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
close(conn, ps, null);
return count;
}
}
}
bean(model)包
User代码
package xyz.jrkang.bean;
/**
* Created by IntelliJ IDEA.
*
* @Date:2020/10/10
* @Time:20:42
* @Author:jiangrunkang
*/
public class User {
private Integer id;
private String userName;
private String pwd;
private Integer age;
private String sex;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd;
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this