基于javaweb+mysql的ssm+maven学生综合素质评价系统(java+ssm+thymeleaf+html+layui+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SSM+Maven学生综合素质评价系统(java+ssm+thymeleaf+html+layui+mysql)
项目介绍
基于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版本;
技术栈
- 后端:SSM(Spring SpringMVC MyBatis) 2. 前端:thymeleaf和layui
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven; 若为maven项目,导入成功后请执行maven clean;maven install命令,配置tomcat; 3. 将项目中jdbc.properties配置文件中的数据库配置改为自己的配置 4. 运行项目,在浏览器中输入http://localhost:8080/ 登录; 注意项目路径必须配置为/,否则会出错;
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);
zhcj.setZxfjd(df.format(zxfjd));
}
if (zhcjService.upZhcj(zhcj) != 0)
setLog.setlod(httpServletRequest, "学生" + 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(grade) * stbl));
else if (kname.equals("德育")) {
newzhcj.setZhcj(String.valueOf(Double.parseDouble(grade) * dybl));
newzhcj.setYscj(String.valueOf(Double.parseDouble(grade) * dybl));
} else if (kname.equals("体育")) {
newzhcj.setZhcj(String.valueOf(Double.parseDouble(grade) * tybl));
newzhcj.setYscj(String.valueOf(Double.parseDouble(grade) * 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 kecheng = kechengService.getKechengById(kid);
String knamestr = "已删除该课程";
if (kecheng!=null) {
knamestr = kecheng.getKname();
dkxf = kecheng.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;
}
}
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) {
}
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")
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();
}
}
}
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();
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) {// 性别
@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;
}
grade1.setXfjd(df.format(jtxfjd));
}
if (gradeService.insertGrade(grade1) != 0) {
setLog.setlod(httpServletRequest, "成功创建课程id为" + sskid + "的成绩", 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(grade) * stbl));
else if (kname.equals("德育")) {
zhcj.setZhcj(String.valueOf(Double.parseDouble(zhcj.getZhcj()) + Double.parseDouble(grade) * dybl));
zhcj.setYscj(String.valueOf(Double.parseDouble(zhcj.getYscj()) + Double.parseDouble(grade) * dybl));
} else if (kname.equals("体育")) {
zhcj.setZhcj(String.valueOf(Double.parseDouble(zhcj.getZhcj()) + Double.parseDouble(grade) * tybl));
zhcj.setYscj(String.valueOf(Double.parseDouble(zhcj.getYscj()) + Double.parseDouble(grade) * 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 kecheng = kechengService.getKechengById(kid);
String knamestr = "已删除该课程";
if (kecheng!=null) {
knamestr = kecheng.getKname();
dkxf = kecheng.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;//总学分
}
}
}
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();
if (Double.parseDouble(grade)>=60)
jtxfjd = (Double.parseDouble(grade)-50)/10;
else jtxfjd=0;
grade1.setXfjd(df.format(jtxfjd));
}
if (gradeService.insertGrade(grade1) != 0) {
setLog.setlod(httpServletRequest, "成功创建课程id为" + sskid + "的成绩", 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(grade) * stbl));
else if (kname.equals("德育")) {
zhcj.setZhcj(String.valueOf(Double.parseDouble(zhcj.getZhcj()) + Double.parseDouble(grade) * dybl));
zhcj.setYscj(String.valueOf(Double.parseDouble(zhcj.getYscj()) + Double.parseDouble(grade) * dybl));
} else if (kname.equals("体育")) {
zhcj.setZhcj(String.valueOf(Double.parseDouble(zhcj.getZhcj()) + Double.parseDouble(grade) * tybl));
zhcj.setYscj(String.valueOf(Double.parseDouble(zhcj.getYscj()) + Double.parseDouble(grade) * 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 kecheng = kechengService.getKechengById(kid);
String knamestr = "已删除该课程";
if (kecheng!=null) {
knamestr = kecheng.getKname();
dkxf = kecheng.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("已删除该课程")){
}
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();
@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);
}
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(httpServletRequest, "学生" + st + "的综合成绩已创建", logService);
}
return true;
} else
return false;
}
/*添加菜单*/
@RequestMapping("Insertcdgl")
public boolean Insertcdgl(@RequestParam(value = "menuname") String menuname,
@RequestParam(value = "menulink") String menulink,
@RequestParam(value = "fdm") String fdm,
HttpServletRequest httpServletRequest) {
Menu menu = new Menu();
if (menuname != "")
menu.setMenulink(menulink);
menu.setMenuname(menuname);
if (fdm != "")
menu.setFdm(fdm);
if (menuService.insertSelective(menu) != 0) {
setLog.setlod(httpServletRequest, "添加名字为" + menuname + "的菜单", logService);
return true;
} else
return false;
}
}
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;
}
/*查询个人信息*/
}
// 更新数据
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();
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);
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;
}