同样的在DAO里面的 增加方法函数 里面复制这块代码粘贴到 更新方法函数里面
Connection conn = DBUtil.getConnection();
String sql = ""+
"insert into students"+
"(user_name,age,phone,"+
"create_user,create_date,update_user,update_date,isdel)"+
"values("+
"?,?,?,?,current_date,?,current_date,?)";//占位符
java.sql.PreparedStatement ptmt = conn.prepareStatement(sql);
//编译sql语句
ptmt.setString(1, STU.getUser_name());
ptmt.setInt(2, STU.getAge());
ptmt.setString(3, STU.getPhone());
ptmt.setString(4, STU.getCreate_user());
ptmt.setString(5, STU.getUpdate_user());
ptmt.setInt(6, STU.getIsdel());
ptmt.execute();//真正执行
修改sql语句
String sql = ""+
" update into students "+
" set user_name=?, age=?, phone=?, "+
" update_user=?, update_date=current_date, isdel=? "+
" where id=? ";
增加getID()
ptmt.setInt(6, STU.getId());
主函数抛出SQLException异常
具体代码如下
//改(更新)
public void updateStudents(students STU) throws SQLException {
Connection conn = DBUtil.getConnection();
String sql = ""+
" update into students "+
" set user_name=?, age=?, phone=?, "+
" update_user=?, update_date=current_date, isdel=? "+
" where id=? ";
java.sql.PreparedStatement ptmt = conn.prepareStatement(sql);
//编译sql语句
ptmt.setString(1, STU.getUser_name());
ptmt.setInt(2, STU.getAge());
ptmt.setString(3, STU.getPhone());
ptmt.setString(4, STU.getUpdate_user());
ptmt.setInt(6, STU.getIsdel());
ptmt.setInt(6, STU.getId());
ptmt.execute();//真正执行
}
继续删除操作
同样的修改sql语句
String sql = ""+
" delete from students "+
" where id=? ";
主函数抛出SQLException异常
具体代码如下
//删
public void delStudents(Integer id) throws SQLException {
Connection conn = DBUtil.getConnection();
String sql = ""+
" delete from students "+
" where id=? ";
java.sql.PreparedStatement ptmt = conn.prepareStatement(sql);
//编译sql语句
ptmt.setInt(1, id);
ptmt.execute();//真正执行
}
注意
查询数据库中的信息时 | 导入java.sql.date |
---|---|
修改数据中的信息时 | 导入java.util.date,需要转换成sql类型 |
在action里面进行测试
项目jar包连接
链接:https://pan.baidu.com/s/1dKOtOGI_1NTE423e8uslbA
提取码:dprl