deleteStudent.jsp 代码如下
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
Connection con=dbconn.getConnection();
Statement stmt=con.createStatement();
%>
请选择要删除学生的学号:
<%
String sql="select * from t_student";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
String SNo=rs.getString("stuno");
%>
deleteStudentCheck.jsp 代码如下:
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
%>
该学生记录已经被删除!
运行之后显示已删除,可是再去查看学生信息就是那个数据还在,各位大神给看看是哪里有问题
//String sql="delete from t_student where stuno="+id;
//stmt.executeUpdate(sql);
因为你这两句注释掉了呀...
单步调试你就知道了,delete的sql语句就没运行