java连接mysql删除操作

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>