JDBC对数据库增删改的封装

private static final String CLASS_FORNAME = "com.mysql.jdbc.Driver";
private static final String URL = "jdbc:mysql://127.0.0.1:3306/test";
private static final String USER = "ROOT";
private static final String PASSWORD = "123456";

static{
    try {
        Class.forName(CLASS_FORNAME);
    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    }
}

public static Connection getConn(){
    try {
        return DriverManager.getConnection(URL,USER,PASSWORD);
    } catch (SQLException e) {
        e.printStackTrace();
    }
    return null;
}

public static void close(Connection conn, Statement ps, ResultSet rs){
    try {
        conn.close();
        ps.close();
        rs.close();
    } catch (SQLException e) {
        e.printStackTrace();
    }
}
public static boolean update(String sql,Object...obj){
    Connection conn = getConn();
    PreparedStatement ps = null;
    try{
        ps =conn.prepareStatement(sql);
        if (Objects.nonNull(obj)) {
            for (int i = 0; i < obj.length; i++) {
                ps.setObject(i+1,obj[i]);
            }
        }
        int b = ps.executeUpdate();
        return b >0;
    } catch (SQLException e) {
        e.printStackTrace();
    }finally {
        close(conn,ps,null);
    }
    return false;
}

思路:将JDBC操作数据库的步骤中不能修改的数据设为常量,然后将获取数据库对象和关闭资源设为方法,将更新操作设为方法,即增删改操作,sql为我们要更新的操作,然后后面数组为传入的条件,首先判断数组是否为空,如果数据不为空在进行