year_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 year_id="";
  String year_name="";
  String year_start="";
  String year_end="";
 %>
 
 <% 
   request.setCharacterEncoding("GBK");
   id=request.getParameter("id");
   year_id=request.getParameter("year_id");
   year_name=request.getParameter("year_name");
   year_start=request.getParameter("year_start");
   year_end=request.getParameter("year_end");
   sql="select year_id from year where year_id='"+year_id+"' and id !='"+id+"'";
   rs=conn.executeQuery(sql);
   if(rs.next()){
 %>
   <jsp:forward page="year_detial.jsp">
     <jsp:param name="id" value="<%=id%>"/>
     <jsp:param name="msg" value="学年代号已存在，学年修改失败！"/>
   </jsp:forward>
 <% 
   }else{
     sql="update year set year_id='"+year_id+"',year_name='"+year_name+"',year_start='"+year_start+"',year_end='"+year_end+"' where id='"+id+"'";
     conn.executeUpdate(sql);
     response.sendRedirect("year_manager_m.jsp");
   }
   conn.close();
  %>