c_update.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 id="";
   String college_id="";
   String college_name="";
 %>

<% 
   request.setCharacterEncoding("GBK");
   id=request.getParameter("id");
   college_id=request.getParameter("college_id");
   college_name=request.getParameter("college_name");
   sql="select college_id from college where college_id='"+college_id+"' and id !='"+id+"'";
   rs=conn.executeQuery(sql);
   if(rs.next()){
%>
     <jsp:forward page="college_update.jsp">
        <jsp:param name="errmsg" value="院系代号已存在,院系修改失败!"/>
		<jsp:param name="id" value="<%=id%>" />
     </jsp:forward>
<%
  }else{
    sql="update college set college_id='"+college_id+"',college_name='"+college_name+"' where id='"+id+"'";
    conn.executeUpdate(sql);
    conn.close();
 %>
      <jsp:forward page="college_update.jsp">
        <jsp:param name="errmsg" value="院系修改成功!"/>
		<jsp:param name="id" value="<%=id%>" />
     </jsp:forward>
 <%
   }
  conn.close();
 %>