op_user.java

JSP_在线教学系统,本系统采用三层结构设计

          cs.setstart_end(rs.getString(6));
          cs.setcourse_tech(rs.getString(7));
          cs.setcourse_credit(rs.getString(8));
          cs.setcourse_site(rs.getString(9));
          cs.setcourse_note(rs.getString(10));
          al.add(cs);
       }
       return al;
     }catch(Exception e){System.out.println(e.getMessage());return null;}

     }
     /**
      * 管理员查询用，管理员可以按课程编号，课程名称，任课教师查询课程信息
      * @param course_code
      * @param course_name
      * @param course_tech
      * @return
      */
  public ArrayList getAllCourseQuery(String course_code,String course_name,String course_tech)
    {
    Connection conn=null;
    Statement st=null;
    ResultSet rs=null;
    ArrayList al=new ArrayList();
    String sql ="select * from t_course where id>0 ";
    if(course_code!=null&&!course_code.equals(""))
      sql+=" and course_code ='"+course_code+"'";
    if(course_name!=null&&!course_name.equals(""))
      sql+=" and course_name like '%"+course_name+"%'";
    if(course_tech!=null&&!course_tech.equals(""))
      sql+=" and course_tech ='"+course_tech+"'";
    try{
      DataBase ds = new DataBase();
      conn = ds.conn;
      st = conn.createStatement();
      rs = st.executeQuery(sql);
      while (rs.next()) {
        course cs=new course();
         cs.setId(rs.getInt(1));
         cs.setCourse_code(rs.getString(2));
         cs.setcourse_name(rs.getString(3));
         cs.setcollege(rs.getString(4));
         cs.setcourse_time(rs.getString(5));
         cs.setstart_end(rs.getString(6));
         cs.setcourse_tech(rs.getString(7));
         cs.setcourse_credit(rs.getString(8));
         cs.setcourse_site(rs.getString(9));
         cs.setcourse_note(rs.getString(10));
         al.add(cs);
      }
      return al;
    }catch(Exception e){System.out.println(e.getMessage());return null;}

    }
    /**
     * 添加一门新课程
     * @param cs
     * @return
     */
     public boolean addCourse(course cs)
     {
       Connection conn = null;
       Statement st = null;
       String sql =
           "insert into t_course(id,course_code,course_name,college,course_time,start_end,course_tech,course_credit,course_site,course_note)values(" +
           " '"+cs.getId()+"',"+
           " '"+cs.getCourse_code()+"',"+
           " '"+grad.util.DataFormate.toGb(cs.getcourse_name())+"',"+
           " '"+grad.util.DataFormate.toGb(cs.getcollege())+"',"+
           " '"+grad.util.DataFormate.toGb(cs.getcourse_time())+"',"+
           " '"+grad.util.DataFormate.toGb(cs.getstart_end())+"',"+
           " '"+grad.util.DataFormate.toGb(cs.getcourse_tech())+"',"+
           " '"+cs.getcourse_credit()+"',"+
           " '"+grad.util.DataFormate.toGb(cs.getcourse_site())+"',"+
           " '"+grad.util.DataFormate.toGb(cs.getcourse_note())+"')";
         user us=new user();
         us.setId(cs.getId());
         us.setAccount(cs.getCourse_code());
         us.setPassword(cs.getCourse_code());
         us.setType(2);
         us.setName(cs.getcourse_tech());
         us.setCollege(cs.getcollege());
         this.addUser(us);
       System.out.println(sql);
       try {
         DataBase ds = new DataBase();
         conn = ds.conn;
         st = conn.createStatement();
         st.executeUpdate(sql);
          return true;
       }
       catch (Exception e) {
         System.out.println(e.getMessage());
         return false;
       }
     }
     /**
      * 更新课程信息
      * @param cs-课程对象
      * @return
      */
     public boolean updateCourse(course cs)
     {
       Connection conn = null;
       Statement st = null;
       String sql =
           " update t_course "+
           "  course_name= '"+(cs.getcourse_name())+"',"+
           "  college='"+(cs.getcollege())+"',"+
           "  course_time= '"+(cs.getcourse_time())+"',"+
           "  start_end='"+(cs.getstart_end())+"',"+
           "  course_tech= '"+(cs.getcourse_tech())+"',"+
           "  course_credit='"+cs.getcourse_credit()+"',"+
           "  course_site='"+(cs.getcourse_site())+"'"+
           " where course_code='"+cs.getCourse_code()+"'";
       System.out.println(sql);
       try {
         DataBase ds = new DataBase();
         conn = ds.conn;
         st = conn.createStatement();
         st.executeUpdate(sql);
          return true;
       }
       catch (Exception e) {
         System.out.println(e.getMessage());
         return false;
       }
     }
     /**
      * 添加选课记录
      * @param couserid－课程编号
      * @param userid－学生编号
      * @return
      */
     public boolean addXk(String couserid,String userid)
        {
          Connection conn = null;
          Statement st = null;
          String sql =
              "insert into xk_record(course_id,user_code,date)values(" +
               " '"+couserid+"',"+
                " '"+userid+"',"+
                " getdate())";
          System.out.println(sql);
          try {
            DataBase ds = new DataBase();
            conn = ds.conn;
            st = conn.createStatement();
            st.executeUpdate(sql);
             return true;
          }
          catch (Exception e) {
            System.out.println(e.getMessage());
            return false;
          }
        }
        /**
         * 管理员添加学生时，先判断数据库中该学生记录是否已经存在
         * @param userid
         * @return
         */
   public boolean isStuExist(String userid)
   {
     Connection conn=null;
    Statement st=null;
    ResultSet rs=null;
    ArrayList al=new ArrayList();
    course cs=new course();
    String sql ="select * from t_user where account='"+userid+"'";
    try{
      DataBase ds = new DataBase();
      conn = ds.conn;
      st = conn.createStatement();
      rs = st.executeQuery(sql);
      if(rs.next())return true;else return false;
    }
          catch (Exception e) {
            System.out.println(e.getMessage());
            return false;
          }
        }
        /**
         * 管理员添加课程时，先看课程是否已经存在
         * @param courseid
         * @return
         */
   public boolean isCourseExist(String courseid)
   {
     Connection conn=null;
     Statement st=null;
     ResultSet rs=null;
     ArrayList al=new ArrayList();
     course cs=new course();
     String sql ="select * from t_course where course_code='"+courseid+"'";
     try{
      DataBase ds = new DataBase();
      conn = ds.conn;
      st = conn.createStatement();
      rs = st.executeQuery(sql);
      if(rs.next())return true;else return false;
       }
        catch (Exception e) {
        System.out.println(e.getMessage());
        return false;
      }

   }
   /**
    * 删除用户信息
    * @param userid
    * @param type
    */
   public void delUser(String userid,String type)
  {
    Connection conn=null;
    Statement st=null;
    ResultSet rs=null;
    if(userid==null)userid="";
    course cs=new course();
    String sql ="delete from t_user where account='"+userid.trim()+"'";
    try{
     DataBase ds = new DataBase();
     conn = ds.conn;
     st = conn.createStatement();
     System.out.println(sql);
      st.executeUpdate(sql);
      if(type.equals("T"))this.delXk(userid,"T");
      if(type.equals("S"))this.delXk(userid,"S");

      }
       catch (Exception e) {
       System.out.println(e.getMessage());
       return ;
     }

  }
  /**
   * 删除选课记录
   * @param cORuid
   * @param type
   */
  public void delXk(String cORuid,String type)
   {
     Connection conn=null;
     Statement st=null;
     ResultSet rs=null;
     String sql="";
     course cs=new course();
     if(type.equals("T"))
      sql ="delete * from xk_record where course_id='"+cORuid+"'";
      if(type.equals("S"))
       sql ="delete * from xk_record where user_code='"+cORuid+"'";
     try{
      DataBase ds = new DataBase();
      conn = ds.conn;
      st = conn.createStatement();
      System.out.println(sql);
       st.executeUpdate(sql);
       }
        catch (Exception e) {
        System.out.println(e.getMessage());
        return ;
      }
   }
   /**
    * 删除课程
    * @param courseid
    */
  public void delCourse(String courseid)
   {
     Connection conn=null;
     Statement st=null;
     ResultSet rs=null;
     if(courseid==null)courseid="";
     course cs=new course();
     String sql ="delete * from t_course where course_code='"+courseid.trim()+"'";
     try{
      DataBase ds = new DataBase();
      conn = ds.conn;
      st = conn.createStatement();
       st.executeUpdate(sql);
       System.out.println(sql);
       this.delUser(courseid,"T");
       }
        catch (Exception e) {
        System.out.println(e.getMessage());
        return ;
      }

   }
   /**
    * 管理员添加选课记录时，先看选课记录是否已经存在
    * @param stuid
    * @param courseid
    * @return
    */
   public boolean isXkExist(String stuid,String courseid)
     {
       Connection conn=null;
       Statement st=null;
       ResultSet rs=null;
       ArrayList al=new ArrayList();
       course cs=new course();
       String sql ="select * from xk_record where stu_code='"+stuid+"'"+
                    " and course_code ='"+courseid+"'";
       try{
        DataBase ds = new DataBase();
        conn = ds.conn;
        st = conn.createStatement();
        rs = st.executeQuery(sql);
        if(rs.next())return true;else return false;
         }
          catch (Exception e) {
          System.out.println(e.getMessage());
          return false;
        }

     }

}