JSP 使用删除操作,删除不了,求大神帮忙看看!
stuinfo.jsp
~~省略了连数据库
while(res.next()){%>
<tr>
<td><label ><%=res.getString("sno") %></label></td>
<td><label ><%=res.getString("sname") %></label></td>
<td><label ><%=res.getString("ssex") %></label></td>
<td><label ><%=res.getInt("sage")%></label></td>
<td><label ><%=res.getString("sdept")%></label></td>
<td><a href="delete.jsp?num=<%=res.getString("sno")%>" onclick="return confirm('是否删除?')"><input type="button" value="删除"/></a></td> </tr> <% } %>
delete.jsp
<%
request.setCharacterEncoding("utf-8");
String id=request.getParameter("num");
~~~ 省略了连数据库
Statement state=conn.createStatement();
String sql="delete from student where sno='"+id+"'";
state.executeUpdate(sql);
state.close();
conn.close();
response.sendRedirect("stuinfo.jsp"); %>