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">
学生信息删除
/jsp:useBean
<%
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">
数据处理页面
/jsp:useBean
/jsp:useBean
<%
//DBConnectionManager dbconn=new DBConnectionManager();
//Connection con=dbconn.getConnection();
//Statement stmt=con.createStatement();
String id=request.getParameter("id");
byte b[]=id.getBytes("iso-8859-1");
id=new String(b,"utf-8");
//String sql="delete from t_student where stuno="+id;
//stmt.executeUpdate(sql);
%>
删除学生信息
该学生记录已经被删除!
运行之后显示已删除,可是再去查看学生信息就是那个数据还在,各位大神给看看是哪里有问题