java连接mysql删除操作

来源：互联网发布：网络兼职招聘网站编辑：程序博客网时间：2024/05/18 03:24

public void deleteStudent(int sid){DBConnection db=new DBConnection();PreparedStatement preStmt=null;try {preStmt=db.getConn().prepareStatement("delete from student where sid=?");preStmt.setInt(1, sid);preStmt.executeUpdate();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}

//对应的jsp页面代码

<table border="1"><tr><td>编号</td><td>姓名</td><td>地址</td><td>爱好</td><td>更新</td><td>删除</td></tr><%//%内部只能识别java代码ArrayList<Student> students = (ArrayList) request.getAttribute("students");if (students != null) {for (int i = 0; i < students.size(); i++) {%><tr><td><%=students.get(i).getSid()%></td><td><%=students.get(i).getSname()%></td><td><%=students.get(i).getSaddress()%></td><td><%=students.get(i).getSlikes()%></td><td>更新</td><td><a href="/t31/servlet/StudentSer?sid=<%=students.get(i).getSid()%>&status=deleteStudent">删除</a></td></tr><%}}%></table>

0 0