作者主页:夜未央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<qxs.length; i++){
if(Integer.parseInt(qxs[i])==fcdid){
tem = i;
}
}
for (i = 0;i<qxs.length;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<Kcbl> 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<Grade> 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<Kcbl> 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<Grade> 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<Groupinfo> groupinfos = groupinfoService.getGroupinfoList(paramMap);
List<Map<String, Object>> 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<childdatas.size();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<String, Object> 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<Groupinfo> groupinfos = groupinfoService.getGroupinfoList(paramMap);
List<Map<String, Object>> 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<String, Object> 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<String, Object> selectfcd(HttpServletRequest httpServletRequest) {
List<Menu> menus = menuService.getfdmmenuList();
List<Map<String, Object>> 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<String, Object> 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<Teacher> teachers = teacherService.getTeacherList(requestparamMap);
List<Map<String, Object>> 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<String, Object> 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<Integer> stulist = new ArrayList<>();
page = page-1;
int start = page*limit;
int end = (page+1)*limit-1;
Map requestparamMap = new HashMap();
List<Map<String, Object>> list = new ArrayList<>();
if (aname!=null&&!aname.equals(""))
requestparamMap.put("aname","%"+aname+"%");
List<Activity> 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<String, Object> 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<Integer> bjidlist = new ArrayList<>();
List<Integer> 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<Classes> 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<Student> students = studentService.getStudentList(stumap);
if (students!=null){
for (Student student:students){
stulist.add(student.getId());
}
}
}
}
}
}
Map requestparamMap = new HashMap();
List<Map<String, Object>> list = new ArrayList<>();
if (aname!=null&&!aname.equals(""))
requestparamMap.put("aname","%"+aname+"%");
if (stulist.size()>0) {
requestparamMap.put("list", stulist);
List<Activity> 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<String, Object> 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<Activity> activities = activityService.getActivityByStudent(stuid);
List<Map<String, Object>> 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<String, Object> 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<Map<String, Object>> 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<String, Object> 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<Kecheng> kechengs = kechengService.getKechengList(requestparamMap);
List<Map<String, Object>> 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<String, Object> 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<Kecheng> kechengs = kechengService.getKechengList(requestparamMap);
List<Map<String, Object>> 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<String, Object> 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<Classes> classess = classesService.getClassesList(requestparamMap);
List<Map<String, Object>> 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<String, Object> 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<Semester> semesters = semesterService.getSemesterList(requestparamMap);
List<Map<String, Object>> 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<String, Object> 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<Semester> semesters = semesterService.getSemesterList(requestparamMap);
List<Map<String, Object>> 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<String, Object> 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<Map<String, Object>> list = new ArrayList<>();
List<Integer> 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<Classes> classess = classesService.getClassesList(cmap);
if (classess!=null){
for (Classes classes :classess ){
List<Integer> cid = new ArrayList<>();
int cidtemp = classes.getId();
cid.add(cidtemp);
if (cid.size()>0){
Map smap = new HashMap();
smap.put("list",cid);
List<Student> 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<Zhcj> 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<String, Object> 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<Map<String, Object>> list = new ArrayList<>();
List<Integer> sids = new ArrayList<>();
Map requestparamMap = new HashMap();
List<Student> 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<Zhcj> 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<String, Object> 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<String,Object> 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<Map<String, Object>> 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<Zhcj> 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<String, Object> 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<Map<String, Object>> 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<Zhcj> 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<String, Object> 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<Map<String, Object>> list = new ArrayList<>();
List<Integer> 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<Classes> classess = classesService.getClassesList(cmap);
if (classess!=null){
for (Classes classes :classess ){
List<Integer> cid = new ArrayList<>();
int cidtemp = classes.getId();
cid.add(cidtemp);
if (cid.size()>0){
Map smap = new HashMap();
smap.put("list",cid);
List<Student> 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<Zhcj> 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<String, Object> 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<Zhuangtai> zhuangtais = zhuangtaiService.getZhuangtaiList(requestparamMap);
List<Map<String, Object>> 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<String, Object> 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<Users> userss = usersService.getuserList(requestparamMap);
List<Map<String, Object>> 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<String, Object> 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<Student> students = studentService.getStudentList(requestparamMap);
List<Map<String, Object>> 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<String, Object> 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<Integer> 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<Classes> classess = classesService.getClassesList(classmap);
if (classess!=null){
for (Classes classes:classess){
int bid = classes.getId();
bjidlist.add(bid);
}
}
}
}
List<Map<String, Object>> 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<Student> 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<String, Object> 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<Map<String, Object>> 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<String, Object> 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<Map<String, Object>> 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<Classes> classess = classesService.getClassesList(cmap);
List<Integer> cid = new ArrayList<>();
if (classess!=null){
for (Classes classes:classess){
cid.add(classes.getId());
}
}
List<Integer> sids = new ArrayList<>();
Map smap = new HashMap();
if (cid.size()>0) {
smap.put("list", cid);
List<Student> slist = studentService.getStudentList(smap);
if (slist!=null){
for (Student student:slist){
sids.add(student.getId());
}
}
}
if (sids.size()>0){
requestparamMap.put("list",sids);
List<Grade> 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<String, Object> 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<Grade> grades = gradeService.getGradeList(requestparamMap);
List<Map<String, Object>> 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<String, Object> 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<Kcbl> kcbls = kcblService.getkcbllist();
List<Map<String, Object>> 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<String, Object> 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<Map<String, Object>> list = new ArrayList<>();
int idcard = student.getXuehao();
Map map = new HashMap();
map.put("idcard", idcard+1);
list.add(map);
Map<String, Object> 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<Classes> classess = classesService.getClassesList(requestparamMap);
List<Map<String, Object>> 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<String, Object> 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<Map<String, Object>> list = new ArrayList<>();
List<Integer> 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<Classes> classess = classesService.getClassesList(cmap);
if (classess!=null){
for (Classes classes :classess ){
List<Integer> cid = new ArrayList<>();
int cidtemp = classes.getId();
cid.add(cidtemp);
if (cid.size()>0){
Map smap = new HashMap();
smap.put("list",cid);
List<Student> 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<Student> 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<String, Object> 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<Teacher> teachers = teacherService.getTeacherList(requestparamMap);
List<Map<String, Object>> 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<String, Object> 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<Map<String, Object>> list = new ArrayList<>();
int idcard = teacher.getTcard();
Map map = new HashMap();
map.put("idcard", idcard+1);
list.add(map);
Map<String, Object> 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<String, Object> 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<Log> logs = logService.getlogList();
int datacount = logs.size();
int i = 0;
List<Map<String, Object>> 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<String, Object> 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<Menu> menus = menuService.getfdmmenuList();
List<Map<String, Object>> 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<String, Object> 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<Groupinfo> groupinfos = groupinfoService.getGroupinfoList(paramMap);
List<Map<String, Object>> 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<String, Object> 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<Menu> menus = menuService.getmenuList();
List<Map<String, Object>> 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<String, Object> 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;
}
}
如果也想学习本系统,下面领取。回复:046ssm