Java项目：ssm学生综合素质评价系统

作者主页：夜未央5788

 简介：Java领域优质创作者、Java项目、学习资料、技术互助

文末获取源码

项目介绍

基于SSM的学生综合素质评价系统设计与实现，系统共分三种角色，包括管理员、教师、学生；
管理员主要功能包括：
权限中心：用户组权限控制、用户组信息管理；
系统设置：菜单管理、系统日志、成绩比例修改；
信息管理：教师信息管理、学生信息管理、课程信息管理、班级信息管理、学期信息管理、状态信息管理、用户账号管理；
教师主要功能包括：
活动管理：活动记录管理；
信息维护：个人信息修改、学生信息管理；
综合评测：综合成绩管理、学生异议处理、学生成绩分析；
成绩管理：学生成绩管理；
学生主要功能包括：
学生个人信息：个人信息修改；
信息查询：活动记录查询、成绩查询、综合成绩查询；

异议申报：学生异议申报；

环境需要

1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。

2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA;
3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可
4.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS；
5.是否Maven项目: 是；查看源码目录中是否包含pom.xml；若包含，则为maven项目，否则为非maven项目 

6.数据库：MySql 5.7版本；

技术栈

1. 后端：SSM(Spring SpringMVC MyBatis)

2. 前端：thymeleaf和layui

使用说明

1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；
2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;
若为maven项目，导入成功后请执行maven clean;maven install命令，配置tomcat;
3. 将项目中jdbc.properties配置文件中的数据库配置改为自己的配置
4. 运行项目，在浏览器中输入http://localhost:8080/ 登录; 
注意项目路径必须配置为/，否则会出错；

运行截图

代码相关

修改控制器

@RestController
public class upController {
    @Autowired
    private GroupinfoService groupinfoService;
    @Autowired
    private LogService logService;
    @Autowired
    private MenuService menuService;
    @Autowired
    private TeacherService teacherService;
    @Autowired
    private StudentService studentService;
    @Autowired
    private KechengService kechengService;
    @Autowired
    private ClassesService classesService;
    @Autowired
    private SemesterService semesterService;
    @Autowired
    private ZhuangtaiService zhuangtaiService;
    @Autowired
    private UsersService usersService;
    @Autowired
    private ActivityService activityService;
    @Autowired
    private GradeService gradeService;
    @Autowired
    private ZhcjService zhcjService;
    @Autowired
    private ImportUtilService importUtilService;
    @Autowired
    private KcblService kcblService;
 
    //修改权限信息
    @RequestMapping("/upyhzqxgl")
    public boolean upyhzqxgl(@RequestParam(value = "id") String id,
                             @RequestParam(value = "checked") String checked,
                             HttpServletRequest httpServletRequest) {
        String ids[] = id.split("_");
        int fcdid=Integer.parseInt(ids[0]);
        int zid = Integer.parseInt(ids[2]);
        String info="增加";
        Groupinfo groupinfo = groupinfoService.getGroupinfoById(zid);
        if (groupinfo != null) {
            String qx = groupinfo.getQx();
            String qxs[] = {};
            if (qx!=null) {
                qxs = qx.split(",");
            }
            if (checked.equals("true"))
            //增加
            {  info="增加";
                String aaaa= Arrays.toString(qxs);
                if (aaaa.length()>2)
                    qx+=","+fcdid;
                else
                    qx=String.valueOf(fcdid);
            }
            if (checked.equals("false"))
            //减少
            {
                qx="";
                info="减少";
                int tem = 0;
                int i;
                for(i = 0; i
                    if(Integer.parseInt(qxs[i])==fcdid){
                        tem = i;
                    }
                }
                for (i = 0;i
                {
                    if (i==tem)
                        continue;
                    qx+=qxs[i]+",";
                }
                if (qx.length()>1)
                    qx = qx.substring(0, qx.length() -1);
            }
            groupinfo.setQx(qx);
            if (groupinfoService.upGroupinfo(groupinfo) != 0) {
                setLog.setlod(httpServletRequest, "修改了id为" + zid + "用户组的权限," + info + "权限id" + fcdid,logService);
                return true;
            }
            return false;
        }
        return false;
    }
 
    /*管理员修改教师信息*/
    @RequestMapping("/upjsxxgl")
    public boolean upjsxxgl(@RequestParam(value = "id") int id,
                            @RequestParam(value = "field") String field,
                            @RequestParam(value = "updateValue") String updateValue,
                            HttpServletRequest httpServletRequest) {
        Teacher teacher = teacherService.getTeacherById(id);
        if (teacher != null) {
            if (field.equals("tname"))
                teacher.setTname(updateValue);
            if (field.equals("tsex"))
                teacher.setTsex(updateValue);
            if (field.equals("tzc"))
                teacher.setTzc(updateValue);
            if (field.equals("tphone"))
                teacher.setTphone(updateValue);
            if (teacherService.upTeacher(teacher) != 0) {
                setLog.setlod(httpServletRequest, "修改了id为" + id + "的教师" + field + "为" + updateValue,logService);
                return true;
            }
            return false;
        }
        return false;
    }
 
    /*修改班级信息*/
    @RequestMapping("/upbjxxgl")
    public boolean upbjxxgl(@RequestParam(value = "id") int id,
                            @RequestParam(value = "field") String field,
                            @RequestParam(value = "updateValue") String updateValue,
                            HttpServletRequest httpServletRequest) {
        Classes classes = classesService.getClassesById(id);
        if (classes != null) {
            if (field.equals("bj"))
                classes.setBj(updateValue);
            if (field.equals("xy"))
                classes.setXy(updateValue);
            if (field.equals("zy"))
                classes.setZy(updateValue);
            if (field.equals("nj"))
                classes.setNj(updateValue);
            if (classesService.upClasses(classes) != 0) {
                setLog.setlod(httpServletRequest, "修改了id为" + id + "的班级" + field + "为" + updateValue,logService);
                return true;
            }
            return false;
        }
        return false;
    }
 
    /*修改学期信息*/
    @RequestMapping("/upxqxxgl")
    public boolean upxqxxgl(@RequestParam(value = "id") int id,
                            @RequestParam(value = "field") String field,
                            @RequestParam(value = "updateValue") String updateValue,
                            HttpServletRequest httpServletRequest) {
        Semester semester = semesterService.getSemesterById(id);
        if (semester != null) {
            if (field.equals("xq"))
                semester.setXq(updateValue);
            if (field.equals("year"))
                semester.setYear(updateValue);
            if (semesterService.upSemester(semester) != 0) {
                setLog.setlod(httpServletRequest, "修改了id为" + id + "的学期" + field + "为" + updateValue,logService);
                return true;
            }
            return false;
        }
        return false;
    }
 
    /*修改状态信息*/
    @RequestMapping("/upztxxgl")
    public boolean upztxxgl(@RequestParam(value = "id") int id,
                            @RequestParam(value = "field") String field,
                            @RequestParam(value = "updateValue") String updateValue,
                            HttpServletRequest httpServletRequest) {
        Zhuangtai zhuangtai = zhuangtaiService.getZhuangtaiById(id);
        if (zhuangtai != null) {
                zhuangtai.setZtname(updateValue);
            if (zhuangtaiService.upZhuangtai(zhuangtai) != 0) {
                setLog.setlod(httpServletRequest, "修改了id为" + id + "的状态" + field + "为" + updateValue,logService);
                return true;
            }
            return false;
        }
        return false;
    }
 
    /*修改课程信息*/
    @RequestMapping("/upkcxxgl")
    public boolean upkcxxgl(@RequestParam(value = "id") int id,
                            @RequestParam(value = "field") String field,
                            @RequestParam(value = "updateValue") String updateValue,
                            HttpServletRequest httpServletRequest) {
        Kecheng kecheng = kechengService.getKechengById(id);
        if (kecheng != null) {
            if (field.equals("kname"))
                kecheng.setKname(updateValue);
            if (field.equals("zxs"))
                kecheng.setZxs(Integer.parseInt(updateValue));
            if (field.equals("xf"))
                kecheng.setXf(Integer.parseInt(updateValue));
            if (kechengService.upKecheng(kecheng) != 0) {
                setLog.setlod(httpServletRequest, "修改了id为" + id + "的课程" + field + "为" + updateValue,logService);
                return true;
            }
            return false;
        }
        return false;
    }
 
    /*重置用户密码*/
    @RequestMapping("/inituser")
    public boolean inituser(@RequestParam int id, HttpServletRequest httpServletRequest) {
        Users users = usersService.selectByPrimaryKey(id);
        if (users != null) {
            users.setUpassword(UtilPacket.Md5MD5String("123456"));
            if (usersService.updateByPrimaryKeySelective(users) != 0) {
                setLog.setlod(httpServletRequest, "重置了" + id + "用户的密码",logService);
                return true;
            }
        }
        return false;
    }
 
     /*教师管理员更改学生信息*/
    @RequestMapping("/upxsxxgl")
    public boolean upxsxxgl(@RequestParam(value = "id") int id,
                            @RequestParam(value = "field") String field,
                            @RequestParam(value = "updateValue") String updateValue,
                            HttpServletRequest httpServletRequest) {
        Student student = studentService.getStudentById(id);
        if (student != null) {
            if (field.equals("sname"))
                student.setSname(updateValue);
            if (field.equals("ssex"))
                student.setSsex(updateValue);
            if (field.equals("sphone"))
                student.setSphone(updateValue);
            if (studentService.upStudent(student) != 0) {
                setLog.setlod(httpServletRequest, "修改了id为" + id + "的学生" + field + "为" + updateValue,logService);
                return true;
            }
            return false;
        }
        return false;
    }
 
    /*重新核算学生成绩*/
    @RequestMapping("/upxsyycl")
    public boolean upxsyycl(@RequestParam(value = "id") int id,
                            HttpServletRequest httpServletRequest) {
        List kcbls = kcblService.getkcbllist();
        double dybl = 0.3;
        double tybl = 0.1;
        double stbl = 1;
        double zhbl = 0.6;
        DecimalFormat df = new DecimalFormat("#.00");
        if (kcbls!=null){
            for(Kcbl kcbl:kcbls){
                String bl = kcbl.getBl();
                String name = kcbl.getKname();
                if (name.equals("德育")){
                    dybl = Double.parseDouble(bl);
                }
                if (name.equals("体育")){
                    tybl = Double.parseDouble(bl);
                }
                if (name.equals("素拓")){
                    stbl = Double.parseDouble(bl);
                }
                if (name.equals("综合成绩学分绩点")){
                    zhbl = Double.parseDouble(bl);
                }
            }
        }
        Zhcj zhcj = zhcjService.getZhcjByid(id);
        if (zhcj != null) {
            int sssid = zhcj.getSssid();
            int ssuid = zhcj.getSsuid();
            Map paramMap = new HashMap();
            paramMap.put("sssid",sssid);
            paramMap.put("st",ssuid);
            List grades = gradeService.getGradeList(paramMap);
            if (grades!=null){
                double xfjd = 0;
                double st = 0;
                double dy = 0;
                double ty = 0;
                double zcj=0;
                double zxf=0;
                int dkxf=0;
                double zxfjd=0;
                for (Grade grade:grades){
                    int sskid = grade.getSskid();
                    Kecheng kecheng = kechengService.getKechengById(sskid);
                    String kname = "已删除该课程";
                    if (kecheng!=null) {
                        kname = kecheng.getKname();
                        dkxf = kecheng.getXf();
                    }
                    if (kname.equals("素拓")) {
                        st = Double.parseDouble(grade.getGrade())* stbl;
                    }else if (kname.equals("德育")) {
                        dy = Double.parseDouble(grade.getGrade())*dybl;
                    }else if (kname.equals("体育")) {
                        ty = Double.parseDouble(grade.getGrade())*tybl;
                    }else if (kname.equals("已删除该课程")){
                        continue;
                    }
                    else {
                        zcj=zcj+Double.parseDouble(grade.getGrade())*dkxf;
                        zxf=zxf+dkxf;
                        if (zxf!=0)
                            zxfjd=zcj/zxf;
                    }
                }
                String xfjdstr = String.valueOf(df.format(zxfjd));
                String yscjstr = String.valueOf(df.format(zxfjd*zhbl+dy*dybl+ty*tybl));
                String zhcjstr = String.valueOf(df.format(zxfjd*zhbl+dy*dybl+ty*tybl+st*stbl));
                zhcj.setZxfjd(xfjdstr);
                zhcj.setYscj(yscjstr);
                zhcj.setZhcj(zhcjstr);
                zhcj.setSszid(1);
            }
            if (zhcjService.upZhcj(zhcj) != 0) {
                setLog.setlod(httpServletRequest, "重新核算了id为" + id + "成绩",logService);
                return true;
            }
            return false;
        }
        return false;
    }
 
    /*学生确认成绩*/
    @RequestMapping("/qrcj")
    public boolean qrcj(@RequestParam(value = "id") int id,
                            HttpServletRequest httpServletRequest) {
        Zhcj zhcj = zhcjService.getZhcjByid(id);
        if (zhcj != null) {
            zhcj.setSszid(3);
            if (zhcjService.upZhcj(zhcj) != 0) {
                setLog.setlod(httpServletRequest, "确认了id为" + id + "的成绩",logService);
                return true;
            }
            return false;
        }
        return false;
    }
 
    /*学生对综合成绩提出异议*/
    @RequestMapping("/tcyy")
    public boolean tcyy(@RequestParam(value = "id") int id,
                        HttpServletRequest httpServletRequest) {
        Zhcj zhcj = zhcjService.getZhcjByid(id);
        if (zhcj != null) {
            zhcj.setSszid(2);
            if (zhcjService.upZhcj(zhcj) != 0) {
                setLog.setlod(httpServletRequest, "id为" + id + "的成绩提出了异议",logService);
                return true;
            }
            return false;
        }
        return false;
    }
 
    /*学生修改个人信息*/
    @RequestMapping("/upgrxxxgxs")
    public boolean upgrxxxgxs(@RequestParam(value = "id") int id,
                            @RequestParam(value = "field") String field,
                            @RequestParam(value = "updateValue") String updateValue,
                            HttpServletRequest httpServletRequest) {
        Student student = studentService.getStudentById(id);
            //System.out.println(student);
        if (student != null) {
            if (field.equals("sname"))
                student.setSname(updateValue);
            if (field.equals("ssex"))
                student.setSsex(updateValue);
            if (field.equals("sphone"))
                student.setSphone(updateValue);
            if (studentService.upStudent(student) != 0) {
                setLog.setlod(httpServletRequest, "修改了id为" + id + "的学生" + field + "为" + updateValue,logService);
                return true;
            }
            return false;
        }
        return false;
    }
 
    /*修改学生成绩*/
    @RequestMapping("/upxscjgl")
    public boolean upxscjgl(@RequestParam(value = "id") int id,
                              @RequestParam(value = "field") String field,
                              @RequestParam(value = "updateValue") String updateValue,
                              HttpServletRequest httpServletRequest) {
        Grade grade = gradeService.getGradeById(id);
        if (grade != null) {
            int kid = grade.getSskid();
            if (field.equals("grade")) {
                grade.setGrade(updateValue);
                int xf = kechengService.getKechengById(kid).getXf();
                if(Double.parseDouble(updateValue)>=60){
                    double xfjd = (Integer.parseInt(updateValue)-50)/10;
                        grade.setXfjd(String.valueOf(xfjd));
                    }
               else{
                    grade.setXfjd(String.valueOf(0));
                }
            }
            if (gradeService.upGrade(grade) != 0) {
                setLog.setlod(httpServletRequest, "修改了id为" + id + "的成绩" + field + "为" + updateValue,logService);
                return true;
            }
            return false;
        }
        return false;
    }
    /*修改活动信息*/
    @RequestMapping("/uphdjlgl")
    public boolean uphdjlgl(@RequestParam(value = "id") int id,
                            @RequestParam(value = "field") String field,
                            @RequestParam(value = "updateValue") String updateValue,
                            HttpServletRequest httpServletRequest) {
        Activity activity = activityService.getActivityById(id);
        if (activity != null) {
            if (field.equals("aname"))
                activity.setAname(updateValue);
            if (field.equals("axx"))
                activity.setAxx(updateValue);
            if (field.equals("add"))
                activity.setAdd(updateValue);
            if (field.equals("alx"))
                activity.setAlx(updateValue);
            if (activityService.upActivity(activity) != 0) {
                setLog.setlod(httpServletRequest, "修改了id为" + id + "的活动" + field + "为" + updateValue,logService);
                return true;
            }
            return false;
        }
        return false;
    }
    /*修改密码*/
    @RequestMapping("/setnewpassword")
    public Map setnewpassword(@RequestParam String newpass,
                            @RequestParam String newpass2,
                            HttpServletRequest httpServletRequest) {
        HttpSession session = httpServletRequest.getSession();
        Users users = (Users) session.getAttribute("islogin");
        Map map = new HashMap();
        int code = 2;
        String msg="请先登录！";
        if (users != null) {
            setLog.setlod(httpServletRequest, users.getUsername()+"用户正在修改密码操作",logService);
           if(newpass.equals(newpass2))
           {
               String md5newpass = UtilPacket.Md5MD5String(newpass);
               if (md5newpass.equals(users.getUpassword())){
                   code=1;
                   msg="新密码与旧密码相同，请重新输入！";
               }
               else {
                   users.setUpassword(md5newpass);
                   if(usersService.updateByPrimaryKeySelective(users)>0){
                       code=0;
                       msg="密码修改成功,请重新登录！";
                       session.invalidate();
                   }
               }
           }
           else {
               code=3;
               msg="两次输入密码不相同，请重新输入！";
           }
        }
        map.put("code",code);
        map.put("msg",msg);
        return map;
    }
 
    /*修改教师信息*/
    @RequestMapping("/upgrxxxg")
    public boolean upgrxxxg(@RequestParam(value = "id") int id,
                            @RequestParam(value = "field") String field,
                            @RequestParam(value = "updateValue") String updateValue,
                            HttpServletRequest httpServletRequest) {
        Teacher teacher = teacherService.getTeacherById(id);
        if (teacher != null) {
            if (field.equals("tname"))
                teacher.setTname(updateValue);
            if (field.equals("tsex"))
                teacher.setTsex(updateValue);
            if (field.equals("tphone"))
                teacher.setTphone(updateValue);
            if (teacherService.upTeacher(teacher) != 0) {
                setLog.setlod(httpServletRequest, "修改了id为" + id + "的教师" + field + "为" + updateValue,logService);
                return true;
            }
            return false;
        }
        return false;
    }
 
    /*修改用户组信息*/
    @RequestMapping("/upyhzxxgl")
    public boolean upyhzxxgl(@RequestParam(value = "id") int id,
                             @RequestParam(value = "field") String field,
                             @RequestParam(value = "updateValue") String updateValue,
                             HttpServletRequest httpServletRequest) {
        Groupinfo groupinfo = groupinfoService.getGroupinfoById(id);
        if (groupinfo != null) {
            groupinfo.setGroupname(updateValue);
            if (groupinfoService.upGroupinfo(groupinfo) != 0) {
                setLog.setlod(httpServletRequest, "修改了id为" + id + "组信息的名称为" + updateValue,logService);
                return true;
            }
            return false;
        }
        return false;
    }
 
    /*修改课程比例*/
    @RequestMapping("/upkcbl")
    public boolean upkcbl(@RequestParam(value = "id") int id,
                             @RequestParam(value = "field") String field,
                             @RequestParam(value = "updateValue") String updateValue,
                             HttpServletRequest httpServletRequest) {
        Kcbl kcbl = kcblService.getkcbibyid(id);
        if (kcbl != null) {
            kcbl.setBl(updateValue);
            if (kcblService.upkcbl(kcbl) != 0) {
                setLog.setlod(httpServletRequest, "修改了id为" + id + "的课程比例为" + updateValue,logService);
                return true;
            }
            return false;
        }
        return false;
    }
 
    /*修改菜单信息*/
    @RequestMapping("/upcdgl")
    public boolean upcdgl(@RequestParam(value = "id") int id,
                          @RequestParam(value = "field") String field,
                          @RequestParam(value = "updateValue") String updateValue,
                          HttpServletRequest httpServletRequest) {
        Menu menu = menuService.selectByPrimaryKey(id);
        if (menu != null) {
            if (field.equals("menuname"))
                menu.setMenuname(updateValue);
            if (field.equals("menulink"))
                menu.setMenulink(updateValue);
            if (menuService.updateByPrimaryKeySelective(menu) != 0) {
                setLog.setlod(httpServletRequest, "修改了" + id + "菜单的" + field + "为" + updateValue,logService);
                return true;
            }
            return false;
        }
        return false;
    }
 
    /**
     * excel导入学生数据
     * */
    @RequestMapping("/importXS")
    @ResponseBody
    public JSONObject importDataXS(@RequestParam MultipartFile file, HttpServletRequest request) {
        String message = "";
        List beanList = null;
        List spjList = null;
        try {
            // 解析excel
            spjList = importUtilService.loadCcsbFromExcel(file.getInputStream(), 1);
 
        } catch (Exception e) {
            e.printStackTrace();
            message = "解析数据出错，请检查数据。";
        }
 
        if (spjList == null || spjList.size() == 0) {
            message = "没有解析到数据，导入0条数据。";
        }
 
        // 更新数据
        if (spjList != null && spjList.size() > 0) {
            int count = 0;
            String errorXh = "";
            beanList = parseListXS(spjList);
            List list = new ArrayList();
            for (int i = 0; i < beanList.size(); i++) {
                Map beanMap = (Map) beanList.get(i);
                int errCnt = (int)beanMap.get("err");
                if (errCnt != 1) {
                    list.add(beanMap);
                    count++;
                } else if ("".equals(errorXh)) {
                    errorXh = errorXh + (i + 1);
                } else {
                    errorXh = errorXh + "," + (i + 1);
                }
                if (count == beanList.size()) {
                    message = "导入成功，导入" + count + "条数据。";
                } else {
                    message = "导入失败，请检查第" + errorXh + "条数据。";
                }
            }
            if ("".equals(errorXh)) {
                //保存需求上报数据
                for (int m = 0; m < list.size(); m++) {
                    Map bean_tmp = (Map) list.get(m);
                    int xuehao = (int)Double.parseDouble((String) bean_tmp.get("xuehao"));
                    Student student = studentService.getStudentByIdcard(xuehao);
                    if (student==null) {
                        Student student_temp = new Student();
                        student_temp.setSsex((String) bean_tmp.get("ssex"));
                        student_temp.setXuehao(xuehao);
                        student_temp.setSphone((String) bean_tmp.get("sphone"));
                        student_temp.setSscid((int)Double.parseDouble((String) bean_tmp.get("sscid")));
                        String datetimestr = (String) bean_tmp.get("scsny");
                        String datamin[] = datetimestr.split("-");
                        Date date = new Date(Integer.parseInt(datamin[0])-1900,Integer.parseInt(datamin[1]),Integer.parseInt(datamin[2]));
                        student_temp.setScsny(date);
                        student_temp.setSname((String) bean_tmp.get("sname"));
                        int i = studentService.insertStudent(student_temp);
                        if (i!=0) {
                            setLog.setlod(request, "导入了学号为" + xuehao + "的学生数据", logService);
                            Users users = new Users();
                            users.setUpassword(UtilPacket.Md5MD5String("123456"));
                            users.setUsername(String.valueOf(xuehao));
                            users.setGroupid(3);
                            users.setRegtime(new Date(new Date().getTime()));
                            if (usersService.insertSelective(users)!=0){
                                setLog.setlod(request, "创建了用户名为" + xuehao + "的学生用户账号", logService);
                            }
                        }
                    }
                    else
                        continue;
                }
            }
        }
        Map map = new HashMap();
        map.put("message", message);
        JSONObject json = new JSONObject(map);
        return json;
    }
 
    public List parseListXS(List src) {
        List rslt = new ArrayList();
        for (int i = 0; i < src.size(); i++) {
            Map rowMap = (Map) src.get(i);
            if (rowMap != null) {
                Map bean = parseOneRowXS(rowMap);
                rslt.add(bean);
            }
        }
        return rslt;
    }
 
    /*获取Excel表格中具体值*/
    private Map parseOneRowXS(Map rowMap) {
        Map resMap = new HashMap();
        resMap.put("err", 0);
        if (rowMap == null) {
            return null;
        }
        for (int j = 0; j <= rowMap.size(); j++) {
            String contentStr = (String) rowMap.get(j);
            if (contentStr == null || contentStr.trim().length() == 0 || "null".equals(contentStr)) {
                //只判断非空字段
                if (j == 0) {
                    resMap.put("err", 1);
                }
                if (j == 1) {
                    resMap.put("err", 1);
                }
                if (j == 2) {
                    resMap.put("err", 1);
                }
                if (j == 3) {
                    resMap.put("err", 1);
                }
                if (j == 4) {
                    resMap.put("err", 1);
                }
                if (j == 5) {
                    resMap.put("err", 1);
                }
                continue;
            }
            contentStr = contentStr.trim();
            System.out.println(j + "=" + contentStr);
            if (j == 0) {// 学号
                resMap.put("xuehao", contentStr);
            }
            if (j == 1) {// 姓名
                resMap.put("sname", contentStr);
            }
            if (j == 2) {// 出生日期
                resMap.put("scsny", contentStr);
            }
            if (j == 3) {// 电话
                resMap.put("sphone", contentStr);
            }
            if (j == 4) {// 所属班级编号
                resMap.put("sscid", contentStr);
            }
            if (j == 5) {// 性别
                resMap.put("ssex", contentStr);
            }
        }
        return resMap;
    }
 
    /**
     * excel导入教师数据
     * */
    @RequestMapping("/importJS")
    @ResponseBody
    public JSONObject importDataJS(@RequestParam MultipartFile file, HttpServletRequest request) {
        String message = "";
        List beanList = null;
        List spjList = null;
        try {
            // 解析excel
            spjList = importUtilService.loadCcsbFromExcel(file.getInputStream(), 1);
 
        } catch (Exception e) {
            e.printStackTrace();
            message = "解析数据出错，请检查数据。";
        }
 
        if (spjList == null || spjList.size() == 0) {
            message = "没有解析到数据，导入0条数据。";
        }
 
        // 更新数据
        if (spjList != null && spjList.size() > 0) {
            int count = 0;
            String errorXh = "";
            beanList = parseListJS(spjList);
            List list = new ArrayList();
            for (int i = 0; i < beanList.size(); i++) {
                Map beanMap = (Map) beanList.get(i);
                int errCnt = (int)beanMap.get("err");
                if (errCnt != 1) {
                    list.add(beanMap);
                    count++;
                } else if ("".equals(errorXh)) {
                    errorXh = errorXh + (i + 1);
                } else {
                    errorXh = errorXh + "," + (i + 1);
                }
                if (count == beanList.size()) {
                    message = "导入成功，导入" + count + "条数据。";
                } else {
                    message = "导入失败，请检查第" + errorXh + "条数据。";
                }
            }
            if ("".equals(errorXh)) {
                //保存需求上报数据
                for (int m = 0; m < list.size(); m++) {
                    Map bean_tmp = (Map) list.get(m);
                    int idcard = (int)Double.parseDouble((String) bean_tmp.get("tcard"));
                    Teacher teacher = teacherService.getTeacherBytcard(idcard);
                    if (teacher==null) {
                        Teacher teacher_temp = new Teacher();
                        teacher_temp.setTsex((String) bean_tmp.get("tsex"));
                        teacher_temp.setTcard(idcard);
                        teacher_temp.setTphone((String) bean_tmp.get("tphone"));
                        teacher_temp.setTzc((String) bean_tmp.get("tzc"));
                        String datetimestr = (String) bean_tmp.get("tbirth");
                        String datamin[] = datetimestr.split("-");
                        Date date = new Date(Integer.parseInt(datamin[0])-1900,Integer.parseInt(datamin[1]),Integer.parseInt(datamin[2]));
                        teacher_temp.setTbirth(date);
                        teacher_temp.setTname((String) bean_tmp.get("tname"));
                        int i = teacherService.insertTeacher(teacher_temp);
                        if (i!=0) {
                            setLog.setlod(request, "导入了工号为" + idcard + "的教师数据", logService);
                            Users users = new Users();
                            users.setUpassword(UtilPacket.Md5MD5String("123456"));
                            users.setUsername(String.valueOf(idcard));
                            users.setGroupid(2);
                            users.setRegtime(new Date(new Date().getTime()));
                            if (usersService.insertSelective(users)!=0){
                                setLog.setlod(request, "创建了用户名为" + idcard + "的教师用户账号", logService);
                            }
                        }
                    }
                    else
                        continue;
                }
            }
        }
        Map map = new HashMap();
        map.put("message", message);
        JSONObject json = new JSONObject(map);
        return json;
    }
 
    public List parseListJS(List src) {
        List rslt = new ArrayList();
        for (int i = 0; i < src.size(); i++) {
            Map rowMap = (Map) src.get(i);
            if (rowMap != null) {
                Map bean = parseOneRowJS(rowMap);
                rslt.add(bean);
            }
        }
        return rslt;
    }
 
    private Map parseOneRowJS(Map rowMap) {
        Map resMap = new HashMap();
        resMap.put("err", 0);
        if (rowMap == null) {
            return null;
        }
        for (int j = 0; j <= rowMap.size(); j++) {
            String contentStr = (String) rowMap.get(j);
            if (contentStr == null || contentStr.trim().length() == 0 || "null".equals(contentStr)) {
                //只判断非空字段
                if (j == 0) {
                    resMap.put("err", 1);
                }
                if (j == 1) {
                    resMap.put("err", 1);
                }
                if (j == 2) {
                    resMap.put("err", 1);
                }
                if (j == 3) {
                    resMap.put("err", 1);
                }
                if (j == 4) {
                    resMap.put("err", 1);
                }
                if (j == 5) {
                    resMap.put("err", 1);
                }
                continue;
            }
            contentStr = contentStr.trim();
            System.out.println(j + "=" + contentStr);
            if (j == 0) {// 工号
                resMap.put("tcard", contentStr);
            }
            if (j == 1) {// 姓名
                resMap.put("tname", contentStr);
            }
            if (j == 2) {// 出生日期
                resMap.put("tbirth", contentStr);
            }
            if (j == 3) {// 电话
                resMap.put("tphone", contentStr);
            }
            if (j == 4) {// 职称
                resMap.put("tzc", contentStr);
            }
            if (j == 5) {// 性别
                resMap.put("tsex", contentStr);
            }
        }
        return resMap;
    }
 
    /**
     * excel导入成绩数据
     * */
    @RequestMapping("/importCJ")
    @ResponseBody
    public JSONObject importDataCJ(@RequestParam MultipartFile file, HttpServletRequest request) {
        List kcbls = kcblService.getkcbllist();
        double dybl = 0.3;
        double tybl = 0.1;
        double stbl = 1;
        double zhbl = 0.6;
        DecimalFormat df = new DecimalFormat("#.00");
        if (kcbls!=null){
            for(Kcbl kcbl:kcbls){
                String bl = kcbl.getBl();
                String name = kcbl.getKname();
                if (name.equals("德育")){
                    dybl = Double.parseDouble(bl);
                }
                if (name.equals("体育")){
                    tybl = Double.parseDouble(bl);
                }
                if (name.equals("素拓")){
                    stbl = Double.parseDouble(bl);
                }
                if (name.equals("综合成绩学分绩点")){
                    zhbl = Double.parseDouble(bl);
                }
            }
        }
        String message = "";
        List beanList = null;
        List spjList = null;
        try {
            // 解析excel
            spjList = importUtilService.loadCcsbFromExcel(file.getInputStream(), 1);
 
        } catch (Exception e) {
            e.printStackTrace();
            message = "解析数据出错，请检查数据。";
        }
 
        if (spjList == null || spjList.size() == 0) {
            message = "没有解析到数据，导入0条数据。";
        }
 
        // 更新数据
        if (spjList != null && spjList.size() > 0) {
            int count = 0;
            String errorXh = "";
            beanList = parseListCJ(spjList);
            List list = new ArrayList();
            for (int i = 0; i < beanList.size(); i++) {
                Map beanMap = (Map) beanList.get(i);
                int errCnt = (int)beanMap.get("err");
                if (errCnt != 1) {
                    list.add(beanMap);
                    count++;
                } else if ("".equals(errorXh)) {
                    errorXh = errorXh + (i + 1);
                } else {
                    errorXh = errorXh + "," + (i + 1);
                }
                if (count == beanList.size()) {
                    message = "导入成功，导入" + count + "条数据。";
                } else {
                    message = "导入失败，请检查第" + errorXh + "条数据。";
                }
            }
            if ("".equals(errorXh)) {
                //保存需求上报数据
                for (int m = 0; m < list.size(); m++) {
                    Map bean_tmp = (Map) list.get(m);
                    int sskid = (int)Double.parseDouble((String) bean_tmp.get("sskid"));
                    int sssid = (int)Double.parseDouble((String) bean_tmp.get("sssid"));
                    int st = (int)Double.parseDouble((String) bean_tmp.get("st"));
                    double gradeduo = Double.parseDouble((String) bean_tmp.get("grade"));
                    Kecheng kecheng = kechengService.getKechengById(sskid);
                    if (kecheng==null)
                        continue;
                    int xf = kecheng.getXf();
                    String xfjd;
                    if(gradeduo>=60)
                     xfjd = String.valueOf((gradeduo-50)/10);
                    else xfjd=String.valueOf(0);
                    String kname = kecheng.getKname();
                    Grade grade = gradeService.getGradeByKandS(bean_tmp);
                    if (grade==null) {
                        Grade grade_temp = new Grade();
                        grade_temp.setSskid(sskid);
                        grade_temp.setSssid(sssid);
                        grade_temp.setSt(st);
                        String gradestr = (String) bean_tmp.get("grade");
                        grade_temp.setKhfs((String) bean_tmp.get("khfs"));
                        grade_temp.setKsxz((String) bean_tmp.get("ksxz"));
                        grade_temp.setGrade(gradestr);
                        grade_temp.setXfjd(xfjd);
                        if (!kname.equals("素拓")||!kname.equals("德育")||!kname.equals("体育"))
                            grade_temp.setXfjd(xfjd);
                        if (gradeService.insertGrade(grade_temp)!=0)
                            setLog.setlod(request, "导入了课程号为"+sskid+"，学期编号为"+sssid+"，学生编号为"+st+"的成绩",logService);
                        //开始判断是否有该学生本学期综合成绩记录
                        Map sinfomap = new HashMap();
                        sinfomap.put("ssuid",st);
                        sinfomap.put("st",st);
                        sinfomap.put("sssid",sssid);
                        List grades = gradeService.getGradeList(sinfomap);
                        Zhcj zhcj = zhcjService.getZhcjByuands(sinfomap);
                        //以下为存在此学生成绩的情况进行更新
                        if (zhcj!=null) {
                            if (kname.equals("素拓"))
                                zhcj.setZhcj(String.valueOf(Double.parseDouble(zhcj.getZhcj()) + Double.parseDouble(gradestr) * stbl));
                            else if (kname.equals("德育")) {
                                zhcj.setZhcj(String.valueOf(Double.parseDouble(zhcj.getZhcj()) + Double.parseDouble(gradestr) * dybl));
                                zhcj.setYscj(String.valueOf(Double.parseDouble(zhcj.getYscj()) + Double.parseDouble(gradestr) * dybl));
                            } else if (kname.equals("体育")) {
                                zhcj.setZhcj(String.valueOf(Double.parseDouble(zhcj.getZhcj()) + Double.parseDouble(gradestr) * tybl));
                                zhcj.setYscj(String.valueOf(Double.parseDouble(zhcj.getYscj()) + Double.parseDouble(gradestr) * tybl));
                            } else {
                                double stcj=0;
                                double dycj=0;
                                double tycj=0;
                                double zcj=0;
                                double zxf=0;
                                int dkxf=0;
                                if (grades!=null){
                                    for (Grade grade2:grades){
                                        int kid = grade2.getSskid();
                                        Kecheng kecheng2 = kechengService.getKechengById(kid);
                                        String knamestr = "已删除该课程";
                                        if (kecheng2!=null) {
                                            knamestr = kecheng2.getKname();
                                            dkxf = kecheng2.getXf();
                                        if (knamestr.equals("素拓")){
                                            stcj = Double.parseDouble(grade2.getGrade());
                                        }
                                        if (knamestr.equals("德育")){
                                            dycj = Double.parseDouble(grade2.getGrade());
                                        }
                                        if (knamestr.equals("体育")){
                                            tycj = Double.parseDouble(grade2.getGrade());
                                        }
                                        if (knamestr.equals("已删除该课程")){
                                            continue;
                                        }
                                         zcj=zcj+Double.parseDouble(grade2.getGrade())*dkxf;
                                            zxf=zxf+dkxf;
                                        }
                                    }
                                }
                                double zxfjd=0;
                                if (zxf!=0)
                                    zxfjd=zcj/zxf;
                                zhcj.setZhcj(df.format(zxfjd*zhbl+dycj*dybl+tycj*tybl+stcj*stbl));
                                zhcj.setYscj(df.format(zxfjd*zhbl+dycj*dybl+tycj*tybl));
                                zhcj.setZxfjd(df.format(zxfjd));
                            }
                            if (zhcjService.upZhcj(zhcj) != 0)
                                setLog.setlod(request, "学生" + st + "的综合成绩已更新", logService);
                        }
                        //如果没有此学生则创建
                        else {
                            Zhcj newzhcj = new Zhcj();
                            newzhcj.setSssid(sssid);
                            newzhcj.setSsuid(st);
                            newzhcj.setSszid(1);
                            if (kname.equals("素拓"))
                                newzhcj.setZhcj(String.valueOf(Double.parseDouble(gradestr) * stbl));
                            else if (kname.equals("德育")) {
                                newzhcj.setZhcj(String.valueOf(Double.parseDouble(gradestr) * dybl));
                                newzhcj.setYscj(String.valueOf(Double.parseDouble(gradestr) * dybl));
                            } else if (kname.equals("体育")) {
                                newzhcj.setZhcj(String.valueOf(Double.parseDouble(gradestr) * tybl));
                                newzhcj.setYscj(String.valueOf(Double.parseDouble(gradestr) * tybl));
                            } else {
                                double stcj=0;
                                double dycj=0;
                                double tycj=0;
                                double zcj=0;
                                double zxf=0;
                                int dkxf=0;
                                if (grades!=null){
                                    for (Grade grade2:grades){
                                        int kid = grade2.getSskid();
                                        Kecheng kecheng2 = kechengService.getKechengById(kid);
                                        String knamestr = "已删除该课程";
                                        if (kecheng2!=null) {
                                            knamestr = kecheng2.getKname();
                                            dkxf = kecheng2.getXf();
                                        if (knamestr.equals("素拓")){
                                            stcj = Double.parseDouble(grade2.getGrade());
                                        }
                                        else if (knamestr.equals("德育")){
                                            dycj = Double.parseDouble(grade2.getGrade());
                                        }
                                        else if (knamestr.equals("体育")){
                                            tycj = Double.parseDouble(grade2.getGrade());
                                        }
                                        else if (knamestr.equals("已删除该课程")){
                                            continue;
                                        }
                                        else {
                                            zcj=zcj+Double.parseDouble(grade2.getGrade())*dkxf;
                                            zxf=zxf+dkxf;
                                        }
                                        }
                                    }
                                }
                                double zxfjd=0;
                                if (zxf!=0)
                                    zxfjd=zcj/zxf;
                                newzhcj.setZhcj(df.format(zxfjd*zhbl+dycj*dybl+tycj*tybl+stcj*stbl));
                                newzhcj.setYscj(df.format(zxfjd*zhbl+dycj*dybl+tycj*tybl));
                                newzhcj.setZxfjd(df.format(zxfjd));
                            }
                            if (zhcjService.insertZhcj(newzhcj)!=0)
                                setLog.setlod(request, "学生" + st + "的综合成绩已创建", logService);
                        }
                        }
                       else
                           continue;
                    }
                }
            }
 
        Map map = new HashMap();
        map.put("message", message);
        JSONObject json = new JSONObject(map);
        return json;
    }
 
    public List parseListCJ(List src) {
        List rslt = new ArrayList();
        for (int i = 0; i < src.size(); i++) {
            Map rowMap = (Map) src.get(i);
            if (rowMap != null) {
                Map bean = parseOneRowCJ(rowMap);
                rslt.add(bean);
            }
        }
        return rslt;
    }
 
    private Map parseOneRowCJ(Map rowMap) {
        Map resMap = new HashMap();
        resMap.put("err", 0);
        if (rowMap == null) {
            return null;
        }
        for (int j = 0; j <= rowMap.size(); j++) {
            String contentStr = (String) rowMap.get(j);
            if (contentStr == null || contentStr.trim().length() == 0 || "null".equals(contentStr)) {
                //只判断非空字段
                if (j == 0) {
                    resMap.put("err", 1);
                }
                if (j == 1) {
                    resMap.put("err", 1);
                }
                if (j == 2) {
                    resMap.put("err", 1);
                }
                if (j == 3) {
                    resMap.put("err", 1);
                }
                if (j == 4) {
                    resMap.put("err", 1);
                }
                if (j == 5) {
                    resMap.put("err", 1);
                }
                continue;
            }
            contentStr = contentStr.trim();
            System.out.println(j + "=" + contentStr);
            if (j == 0) {// 所属课程编号
                resMap.put("sskid", contentStr);
            }
            if (j == 1) {// 所属学期编号
                resMap.put("sssid", contentStr);
            }
            if (j == 2) {// 考核方式
                resMap.put("khfs", contentStr);
            }
            if (j == 3) {// 考试性质
                resMap.put("ksxz", contentStr);
            }
            if (j == 4) {// 所属学生编号
                resMap.put("st", contentStr);
            }
            if (j == 5) {// 分数
                resMap.put("grade", contentStr);
            }
        }
        return resMap;
    }
}

 选择控制器

@RestController
public class selectController {
    @Autowired
    private GroupinfoService groupinfoService;
    @Autowired
    private MenuService menuService;
    @Autowired
    private LogService logService;
    @Autowired
    private UsersService usersService;
    @Autowired
    private TeacherService teacherService;
    @Autowired
    private StudentService studentService;
    @Autowired
    private ClassesService classesService;
    @Autowired
    private KechengService kechengService;
    @Autowired
    private SemesterService semesterService;
    @Autowired
    private ZhuangtaiService zhuangtaiService;
    @Autowired
    private ActivityService activityService;
    @Autowired
    private GradeService gradeService;
    @Autowired
    private ZhcjService zhcjService;
    @Autowired
    private KcblService kcblService;
 
    /*用户组权限查询*/
    @RequestMapping("/selectyhzqxgl")
    public JSONObject selectyhzqxgl(HttpServletRequest httpServletRequest) {
        Map paramMap = new HashMap();
        List groupinfos = groupinfoService.getGroupinfoList(paramMap);
        List> list = new ArrayList<>();
        if (groupinfos != null) {
            for (Groupinfo groupinfo : groupinfos) {
                int id = groupinfo.getId();
                String qx = groupinfo.getQx();
                String groupname = groupinfo.getGroupname();
                String qxs[] ={};
                Map map = new HashMap();
                //管理员、教师、学生
                map.put("id", id+"_a");
                map.put("field", id+"_a");
                map.put("title", groupname);
                if (qx!=null)
                    qxs = qx.split(",");
                Map child = selectfcd(httpServletRequest);
                List childdatas = (List) child.get("data");
                List childsmap = new ArrayList();
                for (int i = 0 ;i
                    boolean sfxz = false;
                    Map childmap = (Map)childdatas.get(i);
                    int childid = Integer.parseInt(String.valueOf(childmap.get("id")));
                    String aaaa= Arrays.toString(qxs);
                    if (aaaa.length()>2&&qxs!=null) {
                        for (String qxbsstr : qxs) {
                            if (Integer.parseInt(qxbsstr) == childid) {
                                sfxz = true;
                                break;
                            }
                        }
                    }
                    //信息管理、成绩管理等父菜单
                    String childmenuname = String.valueOf(childmap.get("menuname"));
                    childmap.put("id",childid+"_b_"+id);
                    childmap.put("title",childmenuname);
                    childmap.put("checked",sfxz);
                    childmap.put("field",childid+"_b_"+id);
                    childsmap.add(childmap);
                }
                map.put("children",childsmap);
                list.add(map);
            }
        }
        Map map1 = new HashMap<>();
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了全部权限节点数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*查询用户账号*/
    @RequestMapping("/selectyhz")
    public JSONObject selectyhz(HttpServletRequest httpServletRequest) {
        Map paramMap = new HashMap();
        List groupinfos = groupinfoService.getGroupinfoList(paramMap);
        List> list = new ArrayList<>();
        if (groupinfos != null) {
            for (Groupinfo groupinfo : groupinfos) {
                int id = groupinfo.getId();
                String gstr = groupinfo.getGroupname();
                Map map = new HashMap();
                map.put("id", id);
                map.put("gstr", gstr);
                list.add(map);
            }
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了用户组列表数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*查询所有父菜单*/
    @RequestMapping("/selectfcd")
    public Map selectfcd(HttpServletRequest httpServletRequest) {
        List menus = menuService.getfdmmenuList();
        List> list = new ArrayList<>();
        if (menus != null) {
            for (Menu menu : menus) {
                int id = menu.getId();
                String menuname = menu.getMenuname();
                Map map = new HashMap();
                map.put("id", id);
                map.put("menuname", menuname);
                list.add(map);
            }
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了父菜单信息数据",logService);
        return map1;
    }
 
    /*管理员查看教师信息*/
    @RequestMapping("/selectjsxxgl")
    public JSONObject selectjsxxgl(@RequestParam(required = false)String tname,@RequestParam(required = false) String tcard, HttpServletRequest httpServletRequest) {
        Map requestparamMap = new HashMap();
        if (tname!=null&&!tname.equals(""))
            requestparamMap.put("tname","%"+tname+"%");
        if (tcard!=null&&!tcard.equals(""))
            requestparamMap.put("tcard","%"+tcard+"%");
        List teachers = teacherService.getTeacherList(requestparamMap);
        List> list = new ArrayList<>();
        if (teachers != null) {
            for (Teacher teacher : teachers) {
                int id = teacher.getId();
                String tnamestr = teacher.getTname();
                String tsex = teacher.getTsex();
                Date date = teacher.getTbirth();
                String tbirth = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日";
                int tcardstr = teacher.getTcard();
                String tphone = teacher.getTphone();
                String tzc = teacher.getTzc();
                Map map = new HashMap();
                map.put("id", id);
                map.put("tname", tnamestr);
                map.put("tsex", tsex);
                map.put("tbirth", tbirth);
                map.put("tcard", tcardstr);
                map.put("tphone", tphone);
                map.put("tzc", tzc);
                list.add(map);
            }
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了教师信息数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*查询活动信息*/
    @RequestMapping("/selecthdjlgl")
    public JSONObject selecthdjlgl(@RequestParam(required = false)String aname, HttpServletRequest httpServletRequest,@RequestParam int limit,@RequestParam int page) {
        HttpSession session = httpServletRequest.getSession();
        Users users = (Users) session.getAttribute("islogin");
        List stulist = new ArrayList<>();
        page = page-1;
        int start = page*limit;
        int end = (page+1)*limit-1;
        Map requestparamMap = new HashMap();
        List> list = new ArrayList<>();
        if (aname!=null&&!aname.equals(""))
            requestparamMap.put("aname","%"+aname+"%");
         List activities = activityService.getActivityList(requestparamMap);
        if (activities != null) {
            int i = 0;
            for (Activity activity : activities) {
                if (i>=start&&i<=end) {
                    int id = activity.getId();
                    String add = activity.getAdd();
                    String alx = activity.getAlx();
                    Date date = activity.getAdate();
                    String adate = String.valueOf(date.getYear() + 1900) + "年" + String.valueOf(date.getMonth() + 1) + "月" + String.valueOf(date.getDate()) + "日";
                    int ssuid = activity.getSsuid();
                    String username = studentService.getStudentById(ssuid).getSname();
                    String anamestr = activity.getAname();
                    String axx = activity.getAxx();
                    Map map = new HashMap();
                    map.put("id", id);
                    map.put("aname", anamestr);
                    map.put("axx", axx);
                    map.put("ssuid", username);
                    map.put("adate", adate);
                    map.put("add", add);
                    map.put("alx", alx);
                    list.add(map);
                }
                i++;
            }
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", activities.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了活动信息数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
  /*  @RequestMapping("/selecthdjlgl")
    public JSONObject selecthdjlgl(@RequestParam(required = false)String aname, HttpServletRequest httpServletRequest) {
        HttpSession session = httpServletRequest.getSession();
        Users users = (Users) session.getAttribute("islogin");
        List bjidlist = new ArrayList<>();
        List stulist = new ArrayList<>();
      if (users.getGroupid()==2) {
            String username = users.getUsername();
            Teacher teacher = teacherService.getTeacherBytcard(Integer.parseInt(username));
            if (teacher!=null){
                int tid = teacher.getId();
                Map classmap = new HashMap();
                classmap.put("tid",tid);
                List classess = classesService.getClassesList(classmap);
                if (classess!=null){
                    for (Classes classes:classess){
                        int bid = classes.getId();
                       bjidlist.add(bid);
                    }
                    if (bjidlist.size()>0) {
                        Map stumap = new HashMap();
                        stumap.put("list", bjidlist);
                        List students = studentService.getStudentList(stumap);
                        if (students!=null){
                            for (Student student:students){
                                stulist.add(student.getId());
                            }
                        }
                   }
                }
            }
        }
        Map requestparamMap = new HashMap();
        List> list = new ArrayList<>();
        if (aname!=null&&!aname.equals(""))
            requestparamMap.put("aname","%"+aname+"%");
        if (stulist.size()>0) {
            requestparamMap.put("list", stulist);
            List activities = activityService.getActivityList(requestparamMap);
            if (activities != null) {
                for (Activity activity : activities) {
                    int id = activity.getId();
                    String add = activity.getAdd();
                    String alx = activity.getAlx();
                    Date date = activity.getAdate();
                    String adate = String.valueOf(date.getYear() + 1900) + "年" + String.valueOf(date.getMonth() + 1) + "月" + String.valueOf(date.getDate()) + "日";
                    int ssuid = activity.getSsuid();
                    String username = studentService.getStudentById(ssuid).getSname();
                    String anamestr = activity.getAname();
                    String axx = activity.getAxx();
                    Map map = new HashMap();
                    map.put("id", id);
                    map.put("aname", anamestr);
                    map.put("axx", axx);
                    map.put("ssuid", username);
                    map.put("adate", adate);
                    map.put("add", add);
                    map.put("alx", alx);
                    list.add(map);
                }
            }
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了活动信息数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
*/
 
    /*活动记录查询*/
    @RequestMapping("/selecthdjlcx")
    public JSONObject selecthdjlcx(HttpServletRequest httpServletRequest,@RequestParam int page,@RequestParam int limit) {
        HttpSession session = httpServletRequest.getSession();
        Users users = (Users) session.getAttribute("islogin");
        String sid = users.getUsername();
        Student student=studentService.getStudentByIdcard(Integer.parseInt(sid));
        int stuid = student.getId();
        List activities = activityService.getActivityByStudent(stuid);
        List> list = new ArrayList<>();
        page = page-1;
        int start = page*limit;
        int end = (page+1)*limit-1;
        int i = 0;
        if (activities != null) {
            for (Activity activity : activities) {
                if (i>=start&&i<=end) {
                    int id = activity.getId();
                    String add = activity.getAdd();
                    String alx = activity.getAlx();
                    Date date = activity.getAdate();
                    String adate = String.valueOf(date.getYear() + 1900) + "年" + String.valueOf(date.getMonth() + 1) + "月" + String.valueOf(date.getDate()) + "日";
                    int ssuid = activity.getSsuid();
                    String username = studentService.getStudentById(ssuid).getSname();
                    String anamestr = activity.getAname();
                    String axx = activity.getAxx();
                    Map map = new HashMap();
                    map.put("id", id);
                    map.put("aname", anamestr);
                    map.put("axx", axx);
                    map.put("ssuid", username);
                    map.put("adate", adate);
                    map.put("add", add);
                    map.put("alx", alx);
                    list.add(map);
                }
            }
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", activities.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了学号为"+sid+"的活动信息数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*查询个人信息*/
    @RequestMapping("/selectgrxxxg")
    public JSONObject selectgrxxxg(HttpServletRequest httpServletRequest) {
        HttpSession session = httpServletRequest.getSession();
        Users users = (Users) session.getAttribute("islogin");
        String tcard = users.getUsername();
        Teacher teacher = teacherService.getTeacherBytcard(Integer.parseInt(tcard));
        List> list = new ArrayList<>();
        if (teacher != null) {
                int id = teacher.getId();
                String tnamestr = teacher.getTname();
                String tsex = teacher.getTsex();
                Date date = teacher.getTbirth();
                String tbirth = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日";
                int tcardstr = teacher.getTcard();
                String tphone = teacher.getTphone();
                String tzc = teacher.getTzc();
                Map map = new HashMap();
                map.put("id", id);
                map.put("tname", tnamestr);
                map.put("tsex", tsex);
                map.put("tbirth", tbirth);
                map.put("tcard", tcardstr);
                map.put("tphone", tphone);
                map.put("tzc", tzc);
                list.add(map);
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了"+tcard+"教师信息数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*显示课程信息*/
    @RequestMapping("/selectkcxxgl")
    public JSONObject selectkcxxgl(@RequestParam(required = false)String kname, HttpServletRequest httpServletRequest) {
        Map requestparamMap = new HashMap();
        if (kname!=null&&!kname.equals(""))
            requestparamMap.put("kname","%"+kname+"%");
        List kechengs = kechengService.getKechengList(requestparamMap);
        List> list = new ArrayList<>();
        if (kechengs != null) {
            for (Kecheng kecheng : kechengs) {
                int id = kecheng.getId();
                String kclx = kecheng.getKclx();
                String kcsx = kecheng.getKcsx();
                String kcxz = kecheng.getKcxz();
                String knamestr = kecheng.getKname();
                String teacher = teacherService.getTeacherById(Integer.parseInt(kecheng.getTeacher())).getTname();
                int xf = kecheng.getXf();
                int zxs = kecheng.getZxs();
                Map map = new HashMap();
                map.put("id", id);
                map.put("kclx", kclx);
                map.put("kcsx", kcsx);
                map.put("kcxz", kcxz);
                map.put("kname", knamestr);
                map.put("teacher", teacher);
                map.put("xf", xf);
                map.put("zxs", zxs);
                list.add(map);
            }
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了课程信息数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*查看课程信息*/
    @RequestMapping("/selectkc")
    public JSONObject selectkc(HttpServletRequest httpServletRequest) {
        Map requestparamMap = new HashMap();
        List kechengs = kechengService.getKechengList(requestparamMap);
        List> list = new ArrayList<>();
        if (kechengs != null) {
            for (Kecheng kecheng : kechengs) {
                int id = kecheng.getId();
                String knamestr = kecheng.getKname();
                Map map = new HashMap();
                map.put("id", id);
                map.put("kname", knamestr);
                list.add(map);
            }
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了课程列表数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*查看班级信息*/
    @RequestMapping("/selectbjxxgl")
    public JSONObject selectbjxxgl(@RequestParam(required = false)String bj, HttpServletRequest httpServletRequest) {
        Map requestparamMap = new HashMap();
        if (bj!=null&&!bj.equals(""))
            requestparamMap.put("bj","%"+bj+"%");
        List classess = classesService.getClassesList(requestparamMap);
        List> list = new ArrayList<>();
        if (classess != null) {
            for (Classes classes : classess) {
                int id = classes.getId();
                String bjstr = classes.getBj();
                String zy = classes.getZy();
                String nj = classes.getNj();
                String xy = classes.getXy();
                String teacher = teacherService.getTeacherById(classes.getSstid()).getTname();
                Map map = new HashMap();
                map.put("id", id);
                map.put("bj", bjstr);
                map.put("zy", zy);
                map.put("nj", nj);
                map.put("xy", xy);
                map.put("teacher", teacher);
                list.add(map);
            }
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了班级信息数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*查询学期信息*/
    @RequestMapping("/selectxqxxgl")
    public JSONObject selectxqxxgl(@RequestParam(required = false)String xq, HttpServletRequest httpServletRequest) {
        Map requestparamMap = new HashMap();
        if (xq!=null&&!xq.equals(""))
            requestparamMap.put("xq","%"+xq+"%");
        List semesters = semesterService.getSemesterList(requestparamMap);
        List> list = new ArrayList<>();
        if (semesters != null) {
            for (Semester semester : semesters) {
                int id = semester.getId();
                String xqstr = semester.getXq();
                String year = semester.getYear();
                Map map = new HashMap();
                map.put("id", id);
                map.put("xq", xqstr);
                map.put("year", year);
                list.add(map);
            }
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了学期信息数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*查询学期信息*/
    @RequestMapping("/selectxq")
    public JSONObject selectxq(HttpServletRequest httpServletRequest) {
        Map requestparamMap = new HashMap();
        List semesters = semesterService.getSemesterList(requestparamMap);
        List> list = new ArrayList<>();
        if (semesters != null) {
            for (Semester semester : semesters) {
                int id = semester.getId();
                String xqstr = semester.getXq();
                String year = semester.getYear();
                Map map = new HashMap();
                map.put("id", id);
                map.put("xq", xqstr);
                map.put("year", year);
                list.add(map);
            }
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了学期列表数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*教师下综合成绩管理*/
    @RequestMapping("/selectzhcjgl")
    public JSONObject selectzhcjgl(@RequestParam(required = false) String name, @RequestParam(required = false) String sidstr,HttpServletRequest httpServletRequest) {
        HttpSession session = httpServletRequest.getSession();
        Users users = (Users) session.getAttribute("islogin");
        List> list = new ArrayList<>();
        List sids = new ArrayList<>();
        if (users!=null&&users.getGroupid()==2){
            String username = users.getUsername();
            Teacher teacher = teacherService.getTeacherBytcard(Integer.parseInt(username));
            if (teacher!=null) {
                Map cmap = new HashMap();
                cmap.put("tid", teacher.getId());
                List classess = classesService.getClassesList(cmap);
                if (classess!=null){
                    for (Classes classes :classess ){
                        List cid = new ArrayList<>();
                        int cidtemp = classes.getId();
                        cid.add(cidtemp);
                        if (cid.size()>0){
                            Map smap = new HashMap();
                            smap.put("list",cid);
                            List students = studentService.getStudentList(smap);
                            if (students!=null){
                                for (Student student : students){
                                    int sid = student.getId();
                                    sids.add(sid);
                                }
                            }
                        }
                    }
                }
            }
        }
        Map requestparamMap = new HashMap();
        if (name!=null && !name.equals(""))
        requestparamMap.put("name","%"+name+"%");
        if (sidstr!=null && !sidstr.equals(""))
            requestparamMap.put("sid",sidstr);
        if (sids.size()>0){
            requestparamMap.put("list",sids);
            List zhcjs = zhcjService.getZhcjglList(requestparamMap);
            if (zhcjs != null) {
                for (Zhcj zhcj : zhcjs) {
                    int id = zhcj.getId();
                    int ssuid = zhcj.getSsuid();
                    String username = studentService.getStudentById(ssuid).getSname();
                    int sssid = zhcj.getSssid();
                    String xq = semesterService.getSemesterById(sssid).getYear()+"--"+semesterService.getSemesterById(sssid).getXq();
                    int ztid = zhcj.getSszid();
                    String ztname = zhuangtaiService.getZhuangtaiById(ztid).getZtname();
                    String zxfjd = zhcj.getZxfjd();
                    String zhcjstr = zhcj.getZhcj();
                    String yscj = zhcj.getYscj();
                    Map map = new HashMap();
                    map.put("id", id);
                    map.put("username", username);
                    map.put("xq", xq);
                    map.put("ztname", ztname);
                    map.put("zxfjd", zxfjd);
                    map.put("zhcj", zhcjstr);
                    map.put("yscj", yscj);
                    list.add(map);
                }
            }
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了综合成绩信息数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*成绩分析查询综合成绩*/
    @RequestMapping("/selectzhcjglrender")
    public JSONObject selectzhcjglrender(@RequestParam String sidstr,@RequestParam String cidstr,HttpServletRequest httpServletRequest) {
        HttpSession session = httpServletRequest.getSession();
        Users users = (Users) session.getAttribute("islogin");
        List> list = new ArrayList<>();
        List sids = new ArrayList<>();
        Map requestparamMap = new HashMap();
        List students = studentService.getStudentByClasses(Integer.parseInt(cidstr));
        if (students!=null){
            for (Student student:students){
                sids.add(student.getId());
            }
        }
        if (sidstr!=null && !sidstr.equals(""))
            requestparamMap.put("sid",sidstr);
        Map renderdata = new HashMap();
        if (sids.size()>0){
            requestparamMap.put("list",sids);
            List zhcjs = zhcjService.getZhcjglList(requestparamMap);
            int anum=0;
            int bnum=0;
            int cnum=0;
            int dnum=0;
            int fnum=0;
            if (zhcjs != null) {
                for (Zhcj zhcj : zhcjs) {
                    int id = zhcj.getId();
                    int ssuid = zhcj.getSsuid();
                    String username = studentService.getStudentById(ssuid).getSname();
                    int sssid = zhcj.getSssid();
                    String xq = semesterService.getSemesterById(sssid).getYear()+"--"+semesterService.getSemesterById(sssid).getXq();
                    int ztid = zhcj.getSszid();
                    String ztname = zhuangtaiService.getZhuangtaiById(ztid).getZtname();
                    String zxfjd = zhcj.getZxfjd();
                    String zhcjstr = zhcj.getZhcj();
                    String yscj = zhcj.getYscj();
                    if (Double.parseDouble(zhcj.getZhcj())>=0&&Double.parseDouble(zhcj.getZhcj())<60)
                        anum++;
                    else if (Double.parseDouble(zhcj.getZhcj())<70)
                        bnum++;
                    else if (Double.parseDouble(zhcj.getZhcj())<80)
                        cnum++;
                    else if (Double.parseDouble(zhcj.getZhcj())<90)
                        dnum++;
                    else
                        fnum++;
                    Map map = new HashMap();
                    map.put("id", id);
                    map.put("username", username);
                    map.put("xq", xq);
                    map.put("ztname", ztname);
                    map.put("zxfjd", zxfjd);
                    map.put("zhcj", zhcjstr);
                    map.put("yscj", yscj);
                    list.add(map);
                }
                String [] names= new String[]{classesService.getClassesById(Integer.parseInt(cidstr)).getBj(),"0--60分","60--70分","70--80分","80--90分","90--100分"};
                int [] nums = new int[]{0,anum,bnum,cnum,dnum,fnum};
                for (int t=0;t<6;t++){
                    Map renderdatatemp = new HashMap();
                    renderdatatemp.put("name",names[t]);
                    renderdatatemp.put("num",nums[t]);
                    renderdata.put("renderdata"+t,renderdatatemp);
                }
            }
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        map1.put("render",renderdata);
        setLog.setlod(httpServletRequest, "查询了综合成绩信息数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*用户输入密码与数据库中原密码比较*/
    @RequestMapping("/getoldpass")
    public JSONObject getoldpass(@RequestParam(value = "oldpass")String oldpass,
                                         HttpServletRequest httpServletRequest) {
        HttpSession session = httpServletRequest.getSession();
        oldpass = UtilPacket.Md5MD5String(oldpass);
        int code = 500;
        String msg= "账号服务器错误！";
        Users users = (Users)session.getAttribute("islogin");
        String upass = users.getUpassword();
        if (upass.equals(oldpass)){
            code = 0;
            msg = "验证成功";
        }
        else {
            code = 1;
            msg = "原密码错误！";
        }
        Map map = new HashMap<>();
        map.put("success",true);
        map.put("code",code);
        map.put("msg",msg);
        JSONObject json = new JSONObject(map);
        return json;
    }
 
    /*学生查询综合成绩*/
    @RequestMapping("/selectzhcjcx")
    public JSONObject selectzhcjcx(HttpServletRequest httpServletRequest) {
        HttpSession session = httpServletRequest.getSession();
        List> list = new ArrayList<>();
        Users users = (Users) session.getAttribute("islogin");
        if(users!=null && users.getGroupid()==3) {
            Student student = studentService.getStudentByIdcard(Integer.parseInt(users.getUsername()));
            if (student != null) {
               int sid = student.getId();
                Map requestparamMap = new HashMap();
               requestparamMap.put("ssuid",sid);
                List zhcjs = zhcjService.getZhcjList(requestparamMap);
                if (zhcjs != null) {
                    for (Zhcj zhcj : zhcjs) {
                        int id = zhcj.getId();
                        int ssuid = zhcj.getSsuid();
                        String username = studentService.getStudentById(ssuid).getSname();
                        int sssid = zhcj.getSssid();
                        String xq = semesterService.getSemesterById(sssid).getYear() + "--" + semesterService.getSemesterById(sssid).getXq();
                        int ztid = zhcj.getSszid();
                        String ztname = zhuangtaiService.getZhuangtaiById(ztid).getZtname();
                        String zxfjd = zhcj.getZxfjd();
                        String zhcjstr = zhcj.getZhcj();
                        String yscj = zhcj.getYscj();
                        Map map = new HashMap();
                        map.put("id", id);
                        map.put("username", username);
                        map.put("xq", xq);
                        map.put("ztname", ztname);
                        map.put("zxfjd", zxfjd);
                        map.put("zhcj", zhcjstr);
                        map.put("yscj", yscj);
                        list.add(map);
                    }
                }
            }
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了学号为"+users.getUsername()+"的综合成绩信息数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*学生查询综合成绩并异议申报*/
    @RequestMapping("/selectxsyysb")
    public JSONObject selectxsyysb(HttpServletRequest httpServletRequest) {
        HttpSession session = httpServletRequest.getSession();
        List> list = new ArrayList<>();
        Users users = (Users) session.getAttribute("islogin");
        if (users!=null&&users.getGroupid()==3){
        Student student = studentService.getStudentByIdcard(Integer.parseInt(users.getUsername()));
        if (student!=null){
            int sid = student.getId();
            Map requestparamMap = new HashMap();
            requestparamMap.put("ztid",1);
            requestparamMap.put("ssuid",sid);
            List zhcjs = zhcjService.getZhcjList(requestparamMap);
            if (zhcjs != null) {
                for (Zhcj zhcj : zhcjs) {
                    int id = zhcj.getId();
                    int ssuid = zhcj.getSsuid();
                    String username = studentService.getStudentById(ssuid).getSname();
                    int sssid = zhcj.getSssid();
                    String xq = semesterService.getSemesterById(sssid).getYear()+"--"+semesterService.getSemesterById(sssid).getXq();
                    int ztid = zhcj.getSszid();
                    String ztname = zhuangtaiService.getZhuangtaiById(ztid).getZtname();
                    String zxfjd = zhcj.getZxfjd();
                    String zhcjstr = zhcj.getZhcj();
                    String yscj = zhcj.getYscj();
                    Map map = new HashMap();
                    map.put("id", id);
                    map.put("username", username);
                    map.put("xq", xq);
                    map.put("ztname", ztname);
                    map.put("zxfjd", zxfjd);
                    map.put("zhcj", zhcjstr);
                    map.put("yscj", yscj);
                    list.add(map);
                }
            }
             }
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了有异议的综合成绩信息数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*教师查询学生异议申报*/
    @RequestMapping("/selectxsyycl")
    public JSONObject selectxsyycl(HttpServletRequest httpServletRequest) {
        HttpSession session = httpServletRequest.getSession();
        Users users = (Users) session.getAttribute("islogin");
        List> list = new ArrayList<>();
        List sids = new ArrayList<>();
        if (users!=null&&users.getGroupid()==2){
            String username = users.getUsername();
            Teacher teacher = teacherService.getTeacherBytcard(Integer.parseInt(username));
            if (teacher!=null) {
                Map cmap = new HashMap();
                cmap.put("tid", teacher.getId());
                List classess = classesService.getClassesList(cmap);
                if (classess!=null){
                    for (Classes classes :classess ){
                        List cid = new ArrayList<>();
                        int cidtemp = classes.getId();
                        cid.add(cidtemp);
                        if (cid.size()>0){
                            Map smap = new HashMap();
                            smap.put("list",cid);
                            List students = studentService.getStudentList(smap);
                            if (students!=null){
                                for (Student student : students){
                                    int sid = student.getId();
                                    sids.add(sid);
                                }
                            }
                        }
                    }
                }
            }
        }
        if (sids.size()>0){
            Map requestparamMap = new HashMap();
            requestparamMap.put("ztid",2);
            requestparamMap.put("list",sids);
            List zhcjs = zhcjService.getZhcjList(requestparamMap);
            if (zhcjs != null) {
                for (Zhcj zhcj : zhcjs) {
                    int id = zhcj.getId();
                    int ssuid = zhcj.getSsuid();
                    String username = studentService.getStudentById(ssuid).getSname();
                    int sssid = zhcj.getSssid();
                    String xq = semesterService.getSemesterById(sssid).getYear()+"--"+semesterService.getSemesterById(sssid).getXq();
                    int ztid = zhcj.getSszid();
                    String ztname = zhuangtaiService.getZhuangtaiById(ztid).getZtname();
                    String zxfjd = zhcj.getZxfjd();
                    String zhcjstr = zhcj.getZhcj();
                    String yscj = zhcj.getYscj();
                    Map map = new HashMap();
                    map.put("id", id);
                    map.put("username", username);
                    map.put("xq", xq);
                    map.put("ztname", ztname);
                    map.put("zxfjd", zxfjd);
                    map.put("zhcj", zhcjstr);
                    map.put("yscj", yscj);
                    list.add(map);
                }
            }
        }
 
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了有异议的综合成绩信息数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*查询状态信息*/
    @RequestMapping("/selectztxxgl")
    public JSONObject selectztxxgl(@RequestParam(required = false)String ztname, HttpServletRequest httpServletRequest) {
        Map requestparamMap = new HashMap();
        if (ztname!=null&&!ztname.equals(""))
            requestparamMap.put("ztname","%"+ztname+"%");
        List zhuangtais = zhuangtaiService.getZhuangtaiList(requestparamMap);
        List> list = new ArrayList<>();
        if (zhuangtais != null) {
            for (Zhuangtai zhuangtai : zhuangtais) {
                int id = zhuangtai.getId();
                String ztnamestr = zhuangtai.getZtname();
                Map map = new HashMap();
                map.put("id", id);
                map.put("ztname", ztnamestr);
                list.add(map);
            }
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了状态信息数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*查询用户账号*/
    @RequestMapping("/selectyhzhgl")
    public JSONObject selectyhzhgl(@RequestParam(required = false)String username,HttpServletRequest httpServletRequest) {
        Map requestparamMap = new HashMap();
        if (username!=null&&!username.equals(""))
            requestparamMap.put("username","%"+username+"%");
        List userss = usersService.getuserList(requestparamMap);
        List> list = new ArrayList<>();
        if (userss != null) {
            for (Users users : userss) {
                int id = users.getId();
                String usernamestr = users.getUsername();
                int gid = users.getGroupid();
                String groupstr = groupinfoService.getGroupinfoById(gid).getGroupname();
                Date date = users.getRegtime();
                String hour = date.getHours()>9?String.valueOf(date.getHours()):0+String.valueOf(date.getHours());
                String minute = date.getMinutes()>9?String.valueOf(date.getMinutes()):0+String.valueOf(date.getMinutes());
                String second = date.getSeconds()>9?String.valueOf(date.getSeconds()):0+String.valueOf(date.getSeconds());
                String regtime = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日--"+hour+":"+minute+":"+second;
                Map map = new HashMap();
                map.put("id", id);
                map.put("username", usernamestr);
                map.put("groupstr", groupstr);
                map.put("regtime", regtime);
                list.add(map);
            }
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了用户信息数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*管理员查询学生信息*/
    @RequestMapping("/selectxsxxgl")
    public JSONObject selectxsxxgl(@RequestParam(required = false)String sname,@RequestParam(required = false) String idcard, HttpServletRequest httpServletRequest) {
        Map requestparamMap = new HashMap();
        if (sname!=null&&!sname.equals(""))
            requestparamMap.put("sname","%"+sname+"%");
        if (idcard!=null&&!idcard.equals(""))
            requestparamMap.put("idcard","%"+idcard+"%");
        List students = studentService.getStudentList(requestparamMap);
        List> list = new ArrayList<>();
        if (students != null) {
            for (Student student : students) {
                int id = student.getId();
                String snamestr = student.getSname();
                int xuehao = student.getXuehao();
                String ssex = student.getSsex();
                Date date = student.getScsny();
                String scsny = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日";
                int bid = student.getSscid();
                Classes classes = classesService.getClassesById(bid);
                String ssbj = classes.getBj();
                String sszy = classes.getZy();
                String sphone = student.getSphone();
                Map map = new HashMap();
                map.put("id", id);
                map.put("sname", snamestr);
                map.put("xuehao", xuehao);
                map.put("ssex", ssex);
                map.put("sszy", sszy);
                map.put("ssbj", ssbj);
                map.put("scsny", scsny);
                map.put("sphone", sphone);
                list.add(map);
            }
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了学生信息数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*教师查询学生信息*/
    @RequestMapping("/selectxsxxgljs")
    public JSONObject selectxsxxgljs(@RequestParam(required = false)String sname,@RequestParam(required = false) String idcard, HttpServletRequest httpServletRequest) {
        HttpSession session = httpServletRequest.getSession();
        Users users = (Users) session.getAttribute("islogin");
        List bjidlist = new ArrayList<>();
        if (users.getGroupid()==2) {
            String username = users.getUsername();
            Teacher teacher = teacherService.getTeacherBytcard(Integer.parseInt(username));
            if (teacher!=null){
                int tid = teacher.getId();
                Map classmap = new HashMap();
                classmap.put("tid",tid);
                List classess = classesService.getClassesList(classmap);
                if (classess!=null){
                    for (Classes classes:classess){
                        int bid = classes.getId();
                        bjidlist.add(bid);
                    }
                }
            }
        }
        List> list = new ArrayList<>();
        Map requestparamMap = new HashMap();
        if (sname!=null&&!sname.equals(""))
            requestparamMap.put("sname","%"+sname+"%");
        if (idcard!=null&&!idcard.equals(""))
            requestparamMap.put("idcard","%"+idcard+"%");
        if (bjidlist.size()>0) {
            requestparamMap.put("list", bjidlist);
            List students = studentService.getStudentList(requestparamMap);
            if (students != null) {
                for (Student student : students) {
                    int id = student.getId();
                    String snamestr = student.getSname();
                    int xuehao = student.getXuehao();
                    String ssex = student.getSsex();
                    Date date = student.getScsny();
                    String scsny = String.valueOf(date.getYear() + 1900) + "年" + String.valueOf(date.getMonth() + 1) + "月" + String.valueOf(date.getDate()) + "日";
                    int bid = student.getSscid();
                    Classes classes = classesService.getClassesById(bid);
                    String ssbj = classes.getBj();
                    String sszy = classes.getZy();
                    String sphone = student.getSphone();
                    Map map = new HashMap();
                    map.put("id", id);
                    map.put("sname", snamestr);
                    map.put("xuehao", xuehao);
                    map.put("ssex", ssex);
                    map.put("sszy", sszy);
                    map.put("ssbj", ssbj);
                    map.put("scsny", scsny);
                    map.put("sphone", sphone);
                    list.add(map);
                }
            }
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了学生信息数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*学生修改个人信息*/
    @RequestMapping("/selectgrxxxgxs")
    public JSONObject selectgrxxxgxs(HttpServletRequest httpServletRequest) {
        HttpSession session = httpServletRequest.getSession();
        Users users = (Users) session.getAttribute("islogin");
        String sid = users.getUsername();
        Student student = studentService.getStudentByIdcard(Integer.parseInt(sid));
        List> list = new ArrayList<>();
        if (student != null) {
                int id = student.getId();
                String snamestr = student.getSname();
                int xuehao = student.getXuehao();
                String ssex = student.getSsex();
                Date date = student.getScsny();
                String scsny = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日";
                int bid = student.getSscid();
                Classes classes = classesService.getClassesById(bid);
                String ssbj = classes.getBj();
                String sszy = classes.getZy();
                String sphone = student.getSphone();
                Map map = new HashMap();
                map.put("id", id);
                map.put("sname", snamestr);
                map.put("xuehao", xuehao);
                map.put("ssex", ssex);
                map.put("sszy", sszy);
                map.put("ssbj", ssbj);
                map.put("scsny", scsny);
                map.put("sphone", sphone);
                list.add(map);
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了"+sid+"学生信息数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*学生成绩管理*/
    @RequestMapping("/selectxscjgl")
    public JSONObject selectxscjgl(HttpServletRequest httpServletRequest,@RequestParam(required = false) String idcard,@RequestParam(required = false) Integer kid,@RequestParam(required = false) Integer sid) {
        HttpSession session = httpServletRequest.getSession();
        Users users = (Users) session.getAttribute("islogin");
        int isnull = 0;
        Map requestparamMap = new HashMap();
        if (idcard != null && !idcard.equals("")) {
            Student studentpa = studentService.getStudentByIdcard(Integer.parseInt(idcard));
            if (studentpa!=null){
                requestparamMap.put("st",studentpa.getId());
            }
            else {
                isnull=1;
            }
        }
        requestparamMap.put("sskid",kid);
        requestparamMap.put("sssid",sid);
        List> list = new ArrayList<>();
        if (users!=null&&isnull!=1){
            if (users.getGroupid()==2){
               String tusername = users.getUsername();
               Teacher teacher = teacherService.getTeacherBytcard(Integer.parseInt(tusername));
               if (teacher!=null){
                   int tid = teacher.getId();
                   Map cmap = new HashMap();
                   cmap.put("tid",tid);
                   List classess = classesService.getClassesList(cmap);
                   List cid = new ArrayList<>();
                   if (classess!=null){
                       for (Classes classes:classess){
                           cid.add(classes.getId());
                       }
                   }
                   List sids = new ArrayList<>();
                   Map smap = new HashMap();
                   if (cid.size()>0) {
                       smap.put("list", cid);
                       List slist = studentService.getStudentList(smap);
                       if (slist!=null){
                           for (Student student:slist){
                               sids.add(student.getId());
                           }
                       }
                   }
                   if (sids.size()>0){
                       requestparamMap.put("list",sids);
                       List grades = gradeService.getGradeList(requestparamMap);
                       if (grades != null) {
                           for (Grade grade : grades) {
                               int id = grade.getId();
                               int sidstr = grade.getSt();
                               String st = studentService.getStudentById(sidstr).getSname();
                               int kidstr = grade.getSskid();
                               String sskid = kechengService.getKechengById(kidstr).getKname();
                               int seid = grade.getSssid();
                               String sssid = semesterService.getSemesterById(seid).getYear()+"--"+semesterService.getSemesterById(seid).getXq();
                               String gradestr = grade.getGrade();
                               int xf = kechengService.getKechengById(kidstr).getXf();
                               int zxs = kechengService.getKechengById(kidstr).getZxs();
                               String khfs = grade.getKhfs();
                               String ksxz = grade.getKsxz();
                               String xfjd = grade.getXfjd();
                               DecimalFormat df = new DecimalFormat("#.00");
                               Map map = new HashMap();
                               map.put("id", id);
                               map.put("st", st);
                               map.put("sskid", sskid);
                               map.put("sssid", sssid);
                               map.put("grade", gradestr);
                               map.put("xf", xf);
                               map.put("zxs", zxs);
                               map.put("khfs", khfs);
                               map.put("ksxz", ksxz);
                               map.put("xfjd", df.format(Double.parseDouble(xfjd)));
                               list.add(map);
                           }
                       }
                   }
               }
            }
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了学生成绩数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*学生查询成绩*/
    @RequestMapping("/selectcjcx")
    public JSONObject selectcjcx(HttpServletRequest httpServletRequest) {
        HttpSession session = httpServletRequest.getSession();
        Users users = (Users) session.getAttribute("islogin");
        Student student = studentService.getStudentByIdcard(Integer.parseInt(users.getUsername()));
        Map requestparamMap = new HashMap();
        requestparamMap.put("st", student.getId());
        List grades = gradeService.getGradeList(requestparamMap);
        List> list = new ArrayList<>();
        if (grades != null) {
            for (Grade grade : grades) {
                int id = grade.getId();
                int sid = grade.getSt();
                String st = studentService.getStudentById(sid).getSname();
                int kid = grade.getSskid();
                String sskid = kechengService.getKechengById(kid).getKname();
                int seid = grade.getSssid();
                String sssid = semesterService.getSemesterById(seid).getYear()+"--"+semesterService.getSemesterById(seid).getXq();
                String gradestr = grade.getGrade();
                int xf = kechengService.getKechengById(kid).getXf();
                int zxs = kechengService.getKechengById(kid).getZxs();
                String khfs = grade.getKhfs();
                String ksxz = grade.getKsxz();
                String xfjd = grade.getXfjd();
                Map map = new HashMap();
                map.put("id", id);
                map.put("st", st);
                map.put("sskid", sskid);
                map.put("sssid", sssid);
                map.put("grade", gradestr);
                map.put("xf", xf);
                map.put("zxs", zxs);
                map.put("khfs", khfs);
                map.put("ksxz", ksxz);
                map.put("xfjd", xfjd);
                list.add(map);
            }
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了学生成绩数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*查看课程比例*/
    @RequestMapping("/selectkcbl")
    public JSONObject selectkcbl(HttpServletRequest httpServletRequest) {
        List kcbls = kcblService.getkcbllist();
        List> list = new ArrayList<>();
        if (kcbls != null) {
            for (Kcbl kcbl : kcbls) {
                int id = kcbl.getId();
                String kname = kcbl.getKname();
                String bl = kcbl.getBl();
                Map map = new HashMap();
                map.put("id", id);
                map.put("kname", kname);
                map.put("bl", bl);
                list.add(map);
            }
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了课程比例数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*推荐学生学号*/
    @RequestMapping("/selectxslast")
    public JSONObject selectxslast(HttpServletRequest httpServletRequest) {
        Student student = studentService.getStudentBylast();
        List> list = new ArrayList<>();
        int idcard = student.getXuehao();
        Map map = new HashMap();
        map.put("idcard", idcard+1);
        list.add(map);
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了最后一条学生数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*查询班级列表*/
    @RequestMapping("/selectbj")
    public JSONObject selectbj(HttpServletRequest httpServletRequest) {
        Map requestparamMap = new HashMap();
        Users users = (Users) httpServletRequest.getSession().getAttribute("islogin");
        if (users!=null&&users.getGroupid()==2){
            Teacher teacher = teacherService.getTeacherBytcard(Integer.parseInt(users.getUsername()));
            if (teacher!=null){
                int tid = teacher.getId();
                requestparamMap.put("tid",tid);
            }
        }
        List classess = classesService.getClassesList(requestparamMap);
        List> list = new ArrayList<>();
        if (classess != null) {
            for (Classes classes : classess) {
                int id = classes.getId();
                String bname = classes.getBj();
                Map map = new HashMap();
                map.put("id", id);
                map.put("bname", bname);
                list.add(map);
            }
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了班级列表数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*查询学生*/
    @RequestMapping("/selectxs")
    public JSONObject selectxs(HttpServletRequest httpServletRequest) {
        HttpSession session = httpServletRequest.getSession();
        Users users = (Users) session.getAttribute("islogin");
        List> list = new ArrayList<>();
        List sids = new ArrayList<>();
        if (users!=null&&users.getGroupid()==2){
            String username = users.getUsername();
            Teacher teacher = teacherService.getTeacherBytcard(Integer.parseInt(username));
            if (teacher!=null) {
                Map cmap = new HashMap();
                cmap.put("tid", teacher.getId());
                List classess = classesService.getClassesList(cmap);
                if (classess!=null){
                    for (Classes classes :classess ){
                        List cid = new ArrayList<>();
                        int cidtemp = classes.getId();
                        cid.add(cidtemp);
                        if (cid.size()>0){
                            Map smap = new HashMap();
                            smap.put("list",cid);
                            List students = studentService.getStudentList(smap);
                            if (students!=null){
                                for (Student student : students){
                                    int sid = student.getId();
                                    sids.add(sid);
                                }
                            }
                        }
                    }
                }
            }
        }
        if (sids.size()>0){
            Map requestparamMap = new HashMap();
            requestparamMap.put("list2",sids);
            List students = studentService.getStudentList(requestparamMap);
            if (students != null) {
                for (Student student : students) {
                    int id = student.getId();
                    String sname = student.getSname();
                    int xuehao = student.getXuehao();
                    Map map = new HashMap();
                    map.put("id", id);
                    map.put("sname", sname);
                    map.put("xuehao", xuehao);
                    list.add(map);
                }
            }
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了学生列表数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*查看教师*/
    @RequestMapping("/selectjs")
    public JSONObject selectjs(HttpServletRequest httpServletRequest) {
        Map requestparamMap = new HashMap();
        List teachers = teacherService.getTeacherList(requestparamMap);
        List> list = new ArrayList<>();
        if (teachers != null) {
            for (Teacher teacher : teachers) {
                int id = teacher.getId();
                String tname = teacher.getTname();
                Map map = new HashMap();
                map.put("id", id);
                map.put("tname", tname);
                list.add(map);
            }
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了教师列表数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*查询教师工号*/
    @RequestMapping("/selectjslast")
    public JSONObject selectjslast(HttpServletRequest httpServletRequest) {
        Teacher teacher = teacherService.getteacherlast();
        List> list = new ArrayList<>();
        int idcard = teacher.getTcard();
        Map map = new HashMap();
        map.put("idcard", idcard+1);
        list.add(map);
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了最后一条教师数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*查看系统日志*/
    @RequestMapping("/selectxtrzgl")
    public Map selectxtrzgl(HttpServletRequest httpServletRequest, @RequestParam(value = "page") int page,@RequestParam(value = "limit") int limit) {
        page = page-1;
        int start = page*limit;
        int end = (page+1)*limit-1;
        List logs = logService.getlogList();
        int datacount = logs.size();
        int i = 0;
        List> list = new ArrayList<>();
        if (logs != null) {
            for (Log log : logs) {
                if (i>=start&&i<=end){
                    int id = log.getId();
                    String cz = log.getCz();
                    int czr = log.getCzr();
                    Date date = log.getTime();
                    String hour = date.getHours()>9?String.valueOf(date.getHours()):0+String.valueOf(date.getHours());
                    String minute = date.getMinutes()>9?String.valueOf(date.getMinutes()):0+String.valueOf(date.getMinutes());
                    String second = date.getSeconds()>9?String.valueOf(date.getSeconds()):0+String.valueOf(date.getSeconds());
                    String timestr = String.valueOf(date.getYear()+1900)+"年"+String.valueOf(date.getMonth()+1)+"月"+String.valueOf(date.getDate())+"日--"+hour+":"+minute+":"+second;
                    String czrstr=usersService.selectByPrimaryKey(czr).getUsername();
                    Map map = new HashMap();
                    map.put("id", id);
                    map.put("cz", cz);
                    map.put("czr", czrstr);
                    map.put("time", timestr);
                    list.add(map);
                }
                i++;
            }
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", datacount);
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了全部系统日志信息数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*查询父菜单*/
    @RequestMapping("/selectfcd2")
    public JSONObject selectfcd2(HttpServletRequest httpServletRequest) {
        List menus = menuService.getfdmmenuList();
        List> list = new ArrayList<>();
        if (menus != null) {
            for (Menu menu : menus) {
                int id = menu.getId();
                String menuname = menu.getMenuname();
                Map map = new HashMap();
                map.put("id", id);
                map.put("menuname", menuname);
                list.add(map);
            }
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了父菜单信息数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*查看用户组信息*/
    @RequestMapping("/selectyhzxxgl")
    public JSONObject selectyhzxxgl(@RequestParam(required = false) String name, HttpServletRequest httpServletRequest) {
        Map paramMap = new HashMap();
        if (name!=null && !name.equals(""))
            paramMap.put("name","%"+name+"%");
        List groupinfos = groupinfoService.getGroupinfoList(paramMap);
        List> list = new ArrayList<>();
        if (groupinfos != null) {
            for (Groupinfo groupinfo : groupinfos) {
                int id = groupinfo.getId();
                String qx = groupinfo.getQx();
                String groupname = groupinfo.getGroupname();
                Map map = new HashMap();
                map.put("id", id);
                map.put("qx", qx);
                map.put("groupname", groupname);
                list.add(map);
            }
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了全部用户组信息数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
    /*查询菜单*/
    @RequestMapping("/selectcdgl")
    public JSONObject selectcdgl(HttpServletRequest httpServletRequest) {
        List menus = menuService.getmenuList();
        List> list = new ArrayList<>();
        if (menus != null) {
            for (Menu menu : menus) {
                int id = menu.getId();
                String fdm = null;
                if(menu.getFdm()!=null&&menu.getFdm()!="") {
                    fdm = menuService.selectByPrimaryKey(Integer.parseInt(menu.getFdm())).getMenuname();
                }
                String menulink = menu.getMenulink();
                String menuname = menu.getMenuname();
                Map map = new HashMap();
                map.put("id", id);
                map.put("fdm", fdm);
                map.put("menulink", menulink);
                map.put("menuname", menuname);
                list.add(map);
            }
        }
        Map map1 = new HashMap<>();
        map1.put("code", 0);
        map1.put("msg", "ok");
        map1.put("count", list.size());
        map1.put("data", list);
        setLog.setlod(httpServletRequest, "查询了全部菜单信息数据",logService);
        JSONObject json = new JSONObject(map1);
        return json;
    }
 
}