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 block
e.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>