stu_update_m.jsp

企业员工考勤系统

<%@ page contentType="text/html;charset=GBK" import="java.sql.*" %>
<%@ page errorPage="/public/errorBusy.jsp" %>
<%@ include file="/public/check_admin.jsp" %>
<jsp:useBean id="conn" scope="page" class="SQLBean.DBConn"/>

<%! 
  ResultSet rs=null;
  String sql="";
  String stu_number="";
  String stu_sex="";
  String stu_name="";
  String class_id="";  
  String id="";
%>
<% 
   request.setCharacterEncoding("GBK");
   stu_name=request.getParameter("stu_name");
   stu_sex=request.getParameter("stu_sex");
   class_id=request.getParameter("class_id");
   id=request.getParameter("id");
   sql="update student set stu_name='"+stu_name+"',stu_sex='"+stu_sex+"' where id='"+id+"'";
   conn.executeUpdate(sql);
   conn.close();
   String url="stu_manager.jsp?class_id="+class_id;
   response.sendRedirect(url);
 %>