2023.11.6每日总结

  * 返回参数类型为 wangzhan.Pd_stu[] ,储存所有符合条件的 wangzhan.Pd_stu
     * */
    //    sql="select stu_id from student where stu_id like ? and stu_name like ? and stu_sex like ? and stu_class like ? and stu_major like ? and stu_faculty like ?";
    public Pd_P_assignment[] P_assignment_DimQuery(String id,String name,String time_deadline,String lesson_id,String teacher_id,String content,String type) throws Exception
    {
        String sql="select as_id from publish_assignment where as_id like ? and as_name like ? and as_time_deadline like ? and as_lesson_id like ? " +
                "and as_teacher_id like ? and as_content like ? and as_type like ?";
        PreparedStatement pre = connect.prepareStatement(sql,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
        pre.setString(1,"%"+id+"%");
        pre.setString(2,"%"+name+"%");
        pre.setString(3,"%"+time_deadline+"%");
        pre.setString(4,"%"+lesson_id+"%");
        pre.setString(5,"%"+teacher_id+"%");
        pre.setString(6,"%"+content+"%");
        pre.setString(7,"%"+type+"%");
        ResultSet rs = pre.executeQuery();
        rs.last();
        int rowCount=rs.getRow();
        rs.beforeFirst();
        Pd_P_assignment[] pdStus = new Pd_P_assignment[rowCount];
        int i=0;
        while(rs.next())
        {
            pdStus[i]=P_assignment_query(rs.getInt(1)+"");
            i++;
        }
        return pdStus;
    }
    public Pd_P_assignment[] P_assignment_DimQueryType(String type) throws Exception
    {
        return P_assignment_DimQuery("","","","","","",type);
    }
    /* submit assignment query
     * 提交作业查询，将提交作业信息从数据库中查询出来，返回Pd_S_assignment
     * 输入参数为：提交作业的序号，即id(String)
     * 若有记录，则返回Pd_S_assignment，若无记录，则返回null
     * Pd_S_assignment包含所有 提交作业 的信息，int id,String student_id,String time,String pu_ass_id,String content,Blob file
     * */
    public Pd_S_assignment S_assignment_query(String id) throws Exception
    {
        String sql="select * from submit_assignment where as_id = ?";
        PreparedStatement pre = connect.prepareStatement(sql);
        pre.setString(1,id);
        ResultSet rs = pre.executeQuery();
        Pd_S_assignment pdd = new Pd_S_assignment();
        while(rs.next())
        {
            pdd.setId(rs.getInt(1));
            pdd.setStudent_id(rs.getString(2));
            pdd.setTime(rs.getString(3));
            pdd.setPu_ass_id(rs.getString(4));
            pdd.setContent(rs.getString(5));
            pdd.setFile(rs.getBlob(6));
            pdd.setState(rs.getString(7));
            pdd.setScore(rs.getInt(8));
            pdd.setPu_name(rs.getString(9));
            pdd.setLesson_name(rs.getString(10));
            pdd.setStudent_name(rs.getString(11));
        }
        pre.close();
        if(pdd.getId()!=0)
            return pdd;
        else
            return null;
    }
    /* submit assignment Dim Query
     * 提交作业信息模糊查询，输入序号，名称，截止时间，所属课程id，所属老师id，文字信息中的一项或多项，实现模糊查询，6项都不输入则为全部显示
     * 输入参数：序号id(String)，学生学号student_id(String)，时间time(String)，所属发布作业id pu_ass_id(String)，文字信息content(String)
     * 返回参数类型为 wangzhan.Pd_stu[] ,储存所有符合条件的 wangzhan.Pd_stu
     * */
    public Pd_S_assignment[] S_assignment_DimQuery(String id,String student_id,String time,String pu_ass_id,String content,String state,String pu_name,String lesson_name,String student_name) throws Exception
    {
        if(!(pu_name!=null)) pu_name="";
        if(!(lesson_name!=null)) lesson_name="";
        if(!(student_name!=null)) student_name="";

        String sql="select as_id from submit_assignment where as_id like ? and as_student_id like ? and as_time like ? and as_pu_ass_id like ? and as_content like ? and as_score like ?" +
                " and as_pu_name like ? and as_lesson_name like ? and as_student_name like ?";
        PreparedStatement pre = connect.prepareStatement(sql,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
        pre.setString(1,"%"+id+"%");
        pre.setString(2,"%"+student_id+"%");
        pre.setString(3,"%"+time+"%");
        pre.setString(4,"%"+pu_ass_id+"%");
        pre.setString(5,"%"+content+"%");
        pre.setString(6,"%"+state+"%");
        pre.setString(7,"%"+pu_name+"%");
        pre.setString(8,"%"+lesson_name+"%");
        pre.setString(9,"%"+student_name+"%");
        ResultSet rs = pre.executeQuery();
        rs.last();
        int rowCount=rs.getRow();
        rs.beforeFirst();
        Pd_S_assignment[] pdStus = new Pd_S_assignment[rowCount];
        int i=0;
        while(rs.next())
        {
            pdStus[i]=S_assignment_query(rs.getInt(1)+"");
            i++;
        }
        return pdStus;
    }