student_update.jsp

网上考试系统文件版

<%@ page contentType="text/html;charset=GBK" import="java.sql.*" %>
<jsp:useBean id="Operate" scope="page" class="todb.Operate"/>
<%
ResultSet rs = null; 

String studentid=new String(request.getParameter("stuid").getBytes("ISO8859_1"));
String studentnum=new String(request.getParameter("stunum").getBytes("ISO8859_1"));
String studentname=new String(request.getParameter("stuname").getBytes("ISO8859_1"));
String studentpermit=new String(request.getParameter("stupermit").getBytes("ISO8859_1"));
String studentdept=new String(request.getParameter("studept").getBytes("ISO8859_1"));
String studentclass=new String(request.getParameter("stuclass").getBytes("ISO8859_1"));
String studentscore=new String(request.getParameter("stuscore").getBytes("ISO8859_1"));

Operate.executeUpdate("update student set student_num='"+studentnum+"',student_name='"+studentname+"',student_permit='"+studentpermit+"',student_dept='"+studentdept+"',student_class='"+studentclass+"',student_score='"+studentscore+"' where ID="+studentid+""); 
out.println("Modify is OK!");

response.sendRedirect("student.jsp");                     
%>