kecheng_add.jsp

jsp+mssql 实现考勤的基本功能 包括签到 签离 请假 销假 批假等功能

<%@ page contentType="text/html;charset=GBK" %>
<%@ page 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;
  int result=0;
  String sql="";
  String kecheng_id="";
  String kecheng_name="";
  String college_id=null;
  String status="";
 %>
 
 <% 
      request.setCharacterEncoding("GBK");
      kecheng_id=request.getParameter("kecheng_id");
      kecheng_name=request.getParameter("kecheng_name");
      college_id=request.getParameter("college_id");
      sql="select * from kecheng where kecheng_id='"+kecheng_id+"'";
      rs=conn.executeQuery(sql);
      if(rs.next()){
  %>
     <jsp:forward page="kc_manager.jsp">
        <jsp:param name="errmsg" value="课程代号以存在,请重新输入!"/>
     </jsp:forward>
  <% 
      }else{
        if(!college_id.equals("")){
           sql="insert into kecheng values('"+kecheng_id+"'";
           sql+=",'"+kecheng_name+"'";
           sql+=",'"+college_id+"')";
           result=conn.executeUpdate(sql);
           conn.close();
        }else{
           sql="insert into kecheng(kecheng_id,kecheng_name) values('"+kecheng_id+"'";
           sql+=",'"+kecheng_name+"')";
           result=conn.executeUpdate(sql);
           conn.close();
        }
  %>
     <jsp:forward page="kc_manager.jsp">
        <jsp:param name="errmsg" value="课程添加成功!"/>
     </jsp:forward>
  <%
       }
     conn.close();
  %>