基于javaweb+mysql的ssm高校学籍管理系统(java+ssm+bootstrap+jsp+html+easyui+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SSM高校学籍管理系统(java+ssm+bootstrap+jsp+html+easyui+mysql)
项目介绍
本项目分为管理员角色与学生两种角色; 管理员主要功能包括: 权限管理:用户管理、角色管理、菜单管理; 学生管理:成绩管理、学生信息管理、学籍管理、奖惩管理; 修改密码等; 学生主要功能包括: 学生管理:成绩管理、学生信息管理、学籍管理、奖惩管理;
环境需要
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.数据库:MySql 5.7版本; 6.是否Maven项目: 否;查看源码目录中是否包含pom.xml;若包含,则为maven项目,否则为非maven项目
技术栈
- 后端:spring springmvc mybatis 2. 前端:JSP+Html+css+javascript+bootstrap+jQuery+easyUI
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven; 若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中applicationContext.xml配置文件中的数据库配置改为自己的配置; 4. 运行项目,在浏览器中输入http://localhost:8080/ 登录
public class StudentController {
@Resource
private StudentService studentService;
@Resource
private RewardService rewardService;
@Resource
private GradeService gradeService;
@ResponseBody
@RequestMapping("/studentList.do")
public String studentList(HttpServletRequest request){
String page = request.getParameter("page");
String rows = request.getParameter("rows");
Student stu = null;
String s_stuNo=request.getParameter("s_stuNo");
if(StringUtil.isNotEmpty(s_stuNo)){
stu = new Student();
stu.setStudentNo(s_stuNo);
}
PageBean pageBean = null;
if (page!=null&&rows!=null) {
pageBean=new PageBean(Integer.parseInt(page), Integer.parseInt(rows));
}
JSONArray jsonArray = studentService.getStudentList(stu, pageBean);
int total = studentService.getStudentCount(stu);
JSONObject result=new JSONObject();
result.put("rows", jsonArray);
result.put("total", total);
System.out.println("list.do result:"+result);
return result.toString();
}
@ResponseBody
@RequestMapping("/getStudentListByState.do")
public String getStudentListByState(HttpServletRequest request){
String page = request.getParameter("page");
@Resource
private UserService userService;
@Resource
private AuthService authService;
@Resource
private RoleService roleService;
@RequestMapping("/main.do")
public String main(HttpServletRequest request){
HttpSession session=request.getSession();
if(session.getAttribute("user")!=null){
return "main";
}else{
String userName = request.getParameter("userName");
String password = request.getParameter("password");
User user = new User();
user.setUserName(userName);
user.setPassword(password);
User u=userService.getUser(user);
if(u!=null){
session.setAttribute("user", u);
return "main";
}
}
request.setAttribute("error", "用户名或密码错误!");
return "/login";
}
@RequestMapping("/login.do")
public String login(){
// return "main";
return "/login";
}
@ResponseBody
@RequestMapping("/getMenu.do")
public String getMenu(HttpServletRequest request){
HttpSession session = request.getSession();
String parentId=request.getParameter("parentId");
User user =(User) session.getAttribute("user");
User u = userService.getUser(user);
String authIds = roleService.getAuthIds(u.getRoleId());
// String authIds = roleService.getAuthIds(1);
JSONArray jsonArray=authService.getAuthMenu(Integer.parseInt(parentId), authIds);
return jsonArray.toString();
}
public String getAuthMenu(HttpServletRequest request){
String parentId=request.getParameter("parentId");
String roleId=request.getParameter("roleId");
String str ="";
String authIds = roleService.getAuthIds(Integer.parseInt(roleId));
JSONArray jsonArray=authService.getAuthMenu(Integer.parseInt(parentId), authIds);
str=jsonArray.toString();
return str;
}
@ResponseBody
@RequestMapping("/getTreeGridAuthMenu.do")
public String getTreeGridAuthMenu(HttpServletRequest request){
String parentId = request.getParameter("parentId");
System.out.println(parentId);
JSONArray jsonArray=authService.getTreeGridAuthMenu(Integer.parseInt(parentId));
return jsonArray.toString();
}
@ResponseBody
@RequestMapping("/getCheckedAuthMenu.do")
public String getCheckedsAuthMenu(HttpServletRequest request){
String parentId=request.getParameter("parentId");
String roleId=request.getParameter("roleId");
HttpSession session = request.getSession();
User user =(User) session.getAttribute("user");
Integer id = null;
if(user!=null){
id = user.getRoleId();
}
String authIds = "";
if(id==1){
Integer roleIntValue = Integer.parseInt(roleId);
// if(id !=roleIntValue){
authIds = roleService.getAuthIds(roleIntValue);
// }
}else{
authIds = null;
}
JSONArray jsonArray = new JSONArray();
try {
jsonArray = authService.getCheckedAuthMenus(Integer.parseInt(parentId), authIds);
} catch (NullPointerException e) {
// TODO: handle exception
return null;
}
return jsonArray.toString();
}
}
JSONArray jsonArray = roleService.getRoleList(role, pageBean);
int total = roleService.getRoleListCount(role);
JSONObject result=new JSONObject();
result.put("rows", jsonArray);
result.put("total", total);
System.out.println("role/roleList.do:"+result);
return result.toString();
}
@ResponseBody
@RequestMapping("/comBoList.do")
public String getComBoList(HttpServletRequest request){
JSONArray jsonArray=new JSONArray();
JSONObject jsonObject=new JSONObject();
jsonObject.put("roleId", "");
jsonObject.put("roleName", "请选择...");
jsonArray.add(jsonObject);
jsonArray.addAll(roleService.getRoleList(null, null));
System.out.println("role/comBoList.do:"+jsonArray);
return jsonArray.toString();
}
@ResponseBody
@RequestMapping("/save.do")
public String saveRole(HttpServletRequest request){
String roleName=request.getParameter("roleName");
String roleDescription=request.getParameter("roleDescription");
String roleId=request.getParameter("roleId");
// Role role=new Role(roleName, roleDescription);
Role role = new Role();
role.setRoleName(roleName);
role.setRoleDescription(roleDescription);
if (StringUtil.isNotEmpty(roleId)) {
role.setRoleId(Integer.parseInt(roleId));
}
JSONObject result = new JSONObject();
int saveNums = 0;
if (StringUtil.isNotEmpty(roleId)) {
saveNums = roleService.roleUpdate(role);
} else {
saveNums = roleService.roleAdd(role);
}
if (saveNums > 0) {
result.put("success", true);
} else {
result.put("success", true);
result.put("errorMsg", "保存失败");
}
return result.toString();
}
@Controller
@RequestMapping("/role")
public class RoleController {
@Resource
private RoleService roleService;
@Resource
private UserService userService;
@ResponseBody
@RequestMapping("/rolelist.do")
public String getRoleList(HttpServletRequest request){
String page = request.getParameter("page");
String rows = request.getParameter("rows");
PageBean pageBean = null;
if (page!=null&&rows!=null) {
pageBean=new PageBean(Integer.parseInt(page), Integer.parseInt(rows));
}
String s_roleName=request.getParameter("s_roleName");
Role role = null;
if(StringUtil.isNotEmpty(s_roleName)){
role =new Role();
role.setRoleName(s_roleName);
}
JSONArray jsonArray = roleService.getRoleList(role, pageBean);
int total = roleService.getRoleListCount(role);
JSONObject result=new JSONObject();
result.put("rows", jsonArray);
result.put("total", total);
System.out.println("role/roleList.do:"+result);
return result.toString();
}
@ResponseBody
@RequestMapping("/comBoList.do")
public String getComBoList(HttpServletRequest request){
JSONArray jsonArray=new JSONArray();
JSONObject jsonObject=new JSONObject();
jsonObject.put("roleId", "");
jsonObject.put("roleName", "请选择...");
jsonArray.add(jsonObject);
@Controller
@RequestMapping("/user")
public class UserController {
@Resource
private UserService userService;
@ResponseBody
@RequestMapping("/userlist.do")
public String userList(HttpServletRequest request){
String page = request.getParameter("page");
String rows = request.getParameter("rows");
User user = null;
String s_userName=request.getParameter("s_userName");
String s_roleId=request.getParameter("s_roleId");
if(StringUtil.isNotEmpty(s_userName)||StringUtil.isNotEmpty(s_roleId)){
user = new User();
}
if(StringUtil.isNotEmpty(s_userName)){
user.setUserName(s_userName);
}
if(StringUtil.isNotEmpty(s_roleId)){
user.setRoleId(Integer.parseInt(s_roleId));
}
PageBean pageBean = null;
}
@RequestMapping("/update.do")
public String gradeUpdate(HttpServletRequest request){
String id = request.getParameter("id");
String studentNo = request.getParameter("studentNo");
String score = request.getParameter("score");
return null;
}
}
package com.java.controller;
@Controller
@RequestMapping("/role")
public class RoleController {
@Resource
private RoleService roleService;
@Resource
private UserService userService;
@ResponseBody
@RequestMapping("/rolelist.do")
public String getRoleList(HttpServletRequest request){
String page = request.getParameter("page");
String rows = request.getParameter("rows");
}
result.put("success", true);
return result.toString();
}
}
}
}
@RequestMapping("/update.do")
public String gradeUpdate(HttpServletRequest request){
String id = request.getParameter("id");
String studentNo = request.getParameter("studentNo");
String score = request.getParameter("score");
return null;
}
}
package com.java.controller;
@Controller
@RequestMapping("/role")
public class RoleController {
@Resource
private RoleService roleService;
@Resource
private UserService userService;
private UserService userService;
@Resource
private AuthService authService;
@Resource
private RoleService roleService;
@RequestMapping("/main.do")
public String main(HttpServletRequest request){
HttpSession session=request.getSession();
if(session.getAttribute("user")!=null){
return "main";
}else{
String userName = request.getParameter("userName");
String password = request.getParameter("password");
User user = new User();
user.setUserName(userName);
user.setPassword(password);
User u=userService.getUser(user);
if(u!=null){
session.setAttribute("user", u);
return "main";
}
}
request.setAttribute("error", "用户名或密码错误!");
return "/login";
}
@RequestMapping("/login.do")
public String login(){
// return "main";
return "/login";
}
@ResponseBody
@RequestMapping("/getMenu.do")
public String getMenu(HttpServletRequest request){
HttpSession session = request.getSession();
String parentId=request.getParameter("parentId");
User user =(User) session.getAttribute("user");
User u = userService.getUser(user);
String authIds = roleService.getAuthIds(u.getRoleId());
// String authIds = roleService.getAuthIds(1);
JSONArray jsonArray=authService.getAuthMenu(Integer.parseInt(parentId), authIds);
return jsonArray.toString();
}
@ResponseBody
@RequestMapping("/getAuthMenu.do")
PageBean pageBean = null;
if (page!=null&&rows!=null) {
pageBean=new PageBean(Integer.parseInt(page), Integer.parseInt(rows));
}
JSONArray jsonArray=studentService.getStudentListByState(state, pageBean);
int total = studentService.getStudentListByStateCount(state);
JSONObject result=new JSONObject();
result.put("rows", jsonArray);
result.put("total", total);
System.out.println("list.do result:"+result);
return result.toString();
}
@ResponseBody
@RequestMapping("/save.do")
public String save(HttpServletRequest request){
String id = request.getParameter("id");
String studentName = request.getParameter("studentName");
String studentNo = request.getParameter("studentNo");
String sex = request.getParameter("sex");
String deptNo = request.getParameter("deptNo");
String deptName = request.getParameter("deptName");
String IdCard = request.getParameter("IdCard");
String address = request.getParameter("address");
String postcode = request.getParameter("postcode");
Student stu = new Student();
stu.setStudentName(studentName);
stu.setStudentNo(studentNo);
stu.setSex(sex);
stu.setDeptNo(deptNo);
stu.setIdCard(IdCard);
stu.setAddress(address);
stu.setPostcode(postcode);
int saveNums = 0;
JSONObject result=new JSONObject();
if(StringUtil.isEmpty(id)){
if(studentService.existStudentWithStudentNo(studentNo)){
saveNums = -1;
}else{
//后期可以使用回滚防止添加一半出现错误
saveNums=studentService.studentAdd(stu);
Reward r = new Reward();
r.setStudentNo(studentNo);
r.setDeptNo(deptNo);
rewardService.rewardAdd(r);
}
}else{
stu.setId(id);
saveNums = studentService.studentUpdate(stu);
}
if(saveNums==-1){
result.put("success", true);
}
@RequestMapping("/update.do")
public String gradeUpdate(HttpServletRequest request){
String id = request.getParameter("id");
String studentNo = request.getParameter("studentNo");
String score = request.getParameter("score");
return null;
}
}
package com.java.controller;
@Controller
@RequestMapping("/role")
public class RoleController {
@Resource
private RoleService roleService;
@Resource
private UserService userService;
@ResponseBody
@RequestMapping("/rolelist.do")
public String getRoleList(HttpServletRequest request){
String page = request.getParameter("page");
String rows = request.getParameter("rows");
PageBean pageBean = null;
if (page!=null&&rows!=null) {
pageBean=new PageBean(Integer.parseInt(page), Integer.parseInt(rows));
}
JSONObject result=new JSONObject();
int saveNums=0;
if(StringUtil.isNotEmpty(userId)){
saveNums=userService.updateUser(user);
}else{
if(userService.testExitUser(userName)!=null){
saveNums=-1;
}else{
saveNums=userService.addUser(user);
}
}
if(saveNums==-1){
result.put("success", true);
result.put("errorMsg", "此用户名已经存在");
}else if(saveNums==0){
result.put("success", true);
result.put("errorMsg", "保存失败");
}else{
result.put("success", true);
}
return result.toString();
}
@ResponseBody
@RequestMapping("/modifyPassword.do")
public String modifyPassword(HttpServletRequest request){
String id =request.getParameter("userId");
String newPassword=request.getParameter("newPassword");
User user = new User();
user.setId(Integer.parseInt(id));
user.setPassword(newPassword);
int updateNum=userService.modifyPassword(user);
JSONObject result=new JSONObject();
if(updateNum>0){
result.put("success", "true");
request.getSession().invalidate();
}else{
result.put("success", "true");
result.put("errorMsg", "修改密码失败!");
}
return result.toString();
}
@ResponseBody
@RequestMapping("/deleteUser.do")
public String deleteUser(HttpServletRequest request){
String delIds=request.getParameter("delIds");
System.out.println(delIds);
Integer code =userService.deleteUser(delIds);
JSONObject result=new JSONObject();
String page = request.getParameter("page");
String rows = request.getParameter("rows");
String studentNo = request.getParameter("s_studentNo");
PageBean pageBean = null;
if (page!=null&&rows!=null) {
pageBean=new PageBean(Integer.parseInt(page), Integer.parseInt(rows));
}
Reward reward = null;
if(StringUtil.isNotEmpty(studentNo)){
reward = new Reward();
reward.setStudentNo(studentNo);
}
JSONArray jsonArray = rewardService.getRewardList(pageBean,reward);
int total = rewardService.getRewardListCount();
JSONObject result=new JSONObject();
result.put("rows", jsonArray);
result.put("total", total);
return result.toString();
}
@ResponseBody
@RequestMapping("/save.do")
public String save(HttpServletRequest request){
String id = request.getParameter("id");
String rewardInfo = request.getParameter("rewardInfo");
int code=rewardService.rewardUpdate(Integer.parseInt(id), rewardInfo);
System.out.println(code);
JSONObject result=new JSONObject();
if(code>0){
result.put("success", true);
}else{
result.put("success", true);
result.put("errorMsg", "保存失败");
}
return result.toString();
}
}
package com.java.controller;
@Controller
}
JSONObject result=new JSONObject();
int saveNums=0;
if(StringUtil.isNotEmpty(userId)){
saveNums=userService.updateUser(user);
}else{
if(userService.testExitUser(userName)!=null){
saveNums=-1;
}else{
saveNums=userService.addUser(user);
}
}
if(saveNums==-1){
result.put("success", true);
result.put("errorMsg", "此用户名已经存在");
}else if(saveNums==0){
result.put("success", true);
result.put("errorMsg", "保存失败");
}else{
result.put("success", true);
}
return result.toString();
}
@ResponseBody
@RequestMapping("/modifyPassword.do")
public String modifyPassword(HttpServletRequest request){
String id =request.getParameter("userId");
String newPassword=request.getParameter("newPassword");
User user = new User();
user.setId(Integer.parseInt(id));
user.setPassword(newPassword);
int updateNum=userService.modifyPassword(user);
JSONObject result=new JSONObject();
if(updateNum>0){
result.put("success", "true");
request.getSession().invalidate();
}else{
result.put("success", "true");
result.put("errorMsg", "修改密码失败!");
}
return result.toString();
@RequestMapping("/update.do")
public String gradeUpdate(HttpServletRequest request){
String id = request.getParameter("id");
String studentNo = request.getParameter("studentNo");
String score = request.getParameter("score");
return null;
}
}
package com.java.controller;
@Controller
@RequestMapping("/role")
public class RoleController {
@Resource
private RoleService roleService;
@Resource
private UserService userService;
@ResponseBody
@RequestMapping("/rolelist.do")
public String getRoleList(HttpServletRequest request){
String roleName=request.getParameter("roleName");
String roleDescription=request.getParameter("roleDescription");
String roleId=request.getParameter("roleId");
// Role role=new Role(roleName, roleDescription);
Role role = new Role();
role.setRoleName(roleName);
role.setRoleDescription(roleDescription);
if (StringUtil.isNotEmpty(roleId)) {
role.setRoleId(Integer.parseInt(roleId));
}
JSONObject result = new JSONObject();
int saveNums = 0;
if (StringUtil.isNotEmpty(roleId)) {
saveNums = roleService.roleUpdate(role);
} else {
saveNums = roleService.roleAdd(role);
}
if (saveNums > 0) {
result.put("success", true);
} else {
result.put("success", true);
result.put("errorMsg", "保存失败");
}
return result.toString();
}
@ResponseBody
@RequestMapping("/roleDelete.do")
public String roleDelete(HttpServletRequest request){
String delIds = request.getParameter("delIds");
JSONObject result = new JSONObject();
String str[] = delIds.split(",");
for (int i = 0; i < str.length; i++) {
boolean f = userService.existUserWithRoleId(str[i]);
if (!f) {
result.put("errorIndex", i);
result.put("errorMsg", "角色下面有用户,不能删除!");
return result.toString();
}
}
int delNums = roleService.roleDelete(delIds);
if (delNums > 0) {
result.put("success", true);
result.put("delNums", delNums);
} else {
if (StringUtil.isNotEmpty(authId)) {
saveNums = authService.authUpdate(auth);
} else {
isLeaf = authService.isLeaf(Integer.parseInt(parentId));
if (!isLeaf) {
saveNums = authService.authAdd(auth);
saveNums = authService.updateStateByAuthId("closed",Integer.parseInt(parentId));
} else {
saveNums = authService.authAdd(auth);
}
}
if (saveNums > 0) {
result.put("success", true);
} else {
result.put("success", true);
result.put("errorMsg", "保存失败");
}
return result.toString();
}
@ResponseBody
@RequestMapping("/authdelete.do")
public String authDelete(HttpServletRequest request){
String authId=request.getParameter("authId");
String parentId = request.getParameter("parentId");
int sonNum = -1;
JSONObject result = new JSONObject();
if (authService.isLeaf(Integer.parseInt(authId))) {
result.put("errorMsg", "该菜单节点有子节点,不能删除!");
} else {
int delNums = 0;
sonNum = authService.getAuthCountByParentId(Integer.parseInt(parentId));
if (sonNum == 1) {
delNums = authService.authDelete(Integer.parseInt(authId));
authService.updateStateByAuthId("open", Integer.parseInt(parentId));
} else {
delNums = authService.authDelete(Integer.parseInt(authId));
}
if (delNums > 0) {
result.put("success", true);
} else {
result.put("errorMsg", "删除失败");
}
}
return result.toString();
}
public class LoginController {
@Resource
private UserService userService;
@Resource
private AuthService authService;
@Resource
private RoleService roleService;
@RequestMapping("/main.do")
public String main(HttpServletRequest request){
HttpSession session=request.getSession();
if(session.getAttribute("user")!=null){
return "main";
}else{
String userName = request.getParameter("userName");
String password = request.getParameter("password");
User user = new User();
user.setUserName(userName);
user.setPassword(password);
User u=userService.getUser(user);
if(u!=null){
session.setAttribute("user", u);
return "main";
}
}
request.setAttribute("error", "用户名或密码错误!");
return "/login";
}
@RequestMapping("/login.do")
public String login(){
// return "main";
return "/login";
}
@ResponseBody
@RequestMapping("/getMenu.do")
public String getMenu(HttpServletRequest request){
HttpSession session = request.getSession();
String parentId=request.getParameter("parentId");
User user =(User) session.getAttribute("user");
User u = userService.getUser(user);
String authIds = roleService.getAuthIds(u.getRoleId());
// String authIds = roleService.getAuthIds(1);
JSONArray jsonArray=authService.getAuthMenu(Integer.parseInt(parentId), authIds);
return jsonArray.toString();
}
g.setSubjectId(3);
g.setStudentNo(studentNo);
g.setScore(Integer.parseInt(sport));
gradeService.addGrade(g);
}
if(StringUtil.isNotEmpty(political)){
Grade g = new Grade();
g.setSubjectId(4);
g.setStudentNo(studentNo);
g.setScore(Integer.parseInt(political));
gradeService.addGrade(g);
}
int mathScore = Integer.parseInt(math);
int englishScore = Integer.parseInt(english);
int sportScore = Integer.parseInt(sport);
int politicalScore = Integer.parseInt(political);
Student s = new Student();
if(mathScore<60||englishScore<60||sportScore<60||politicalScore<60){
s.setStudentNo(studentNo);
s.setState("1");
studentService.studentUpdateState(s);
}else{
s.setStudentNo(studentNo);
s.setState("2");
studentService.studentUpdateState(s);
}
result.put("success", true);
return result.toString();
}
}
}
}
@RequestMapping("/update.do")
public String gradeUpdate(HttpServletRequest request){
String id = request.getParameter("id");
String studentNo = request.getParameter("studentNo");
String score = request.getParameter("score");
return null;
}
}
package com.java.controller;
}
}
}
@RequestMapping("/update.do")
public String gradeUpdate(HttpServletRequest request){
String id = request.getParameter("id");
String studentNo = request.getParameter("studentNo");
String score = request.getParameter("score");
return null;
}
}
package com.java.controller;
@Controller
@RequestMapping("/role")
public class RoleController {
@Resource
private RoleService roleService;
@Resource
private UserService userService;
JSONObject result = new JSONObject();
if(StringUtil.isNotEmpty(id)){
Grade g = new Grade();
g.setSubjectId(Integer.parseInt(id));
g.setScore(Integer.parseInt(score));
g.setStudentNo(studentNo);
gradeService.gradeUpdate(g);
List<Grade> gradeList=gradeService.getGradeListByScore(studentNo);
boolean isTrue = true;
for(Grade gr:gradeList){
if(gr.getScore()<60){
isTrue = false;
}
}
Student s = new Student();
if(isTrue){
s.setStudentNo(studentNo);
s.setState("2");
studentService.studentUpdateState(s);
}else{
s.setStudentNo(studentNo);
s.setState("1");
studentService.studentUpdateState(s);
}
result.put("success", true);
return result.toString();
}else{
if(!studentService.existStudentWithStudentNo(studentNo)){
result.put("success", true);
result.put("errorMsg", "无此学生,添加成绩失败");
return result.toString();
}else{
if(gradeService.exitGrade(studentNo)){
result.put("success", true);
result.put("errorMsg", "此学生已有成绩,无法添加,请选择修改");
return result.toString();
}else{
if(StringUtil.isNotEmpty(math)){
Grade g = new Grade();
g.setSubjectId(1);
@Controller
@RequestMapping("/user")
public class UserController {
@Resource
private UserService userService;
@ResponseBody
@RequestMapping("/userlist.do")
public String userList(HttpServletRequest request){
String page = request.getParameter("page");
String rows = request.getParameter("rows");
User user = null;
String s_userName=request.getParameter("s_userName");
String s_roleId=request.getParameter("s_roleId");
if(StringUtil.isNotEmpty(s_userName)||StringUtil.isNotEmpty(s_roleId)){
user = new User();
}
if(StringUtil.isNotEmpty(s_userName)){
user.setUserName(s_userName);
}
if(StringUtil.isNotEmpty(s_roleId)){
user.setRoleId(Integer.parseInt(s_roleId));
}
public String getTreeGridAuthMenu(HttpServletRequest request){
String parentId = request.getParameter("parentId");
System.out.println(parentId);
JSONArray jsonArray=authService.getTreeGridAuthMenu(Integer.parseInt(parentId));
return jsonArray.toString();
}
@ResponseBody
@RequestMapping("/getCheckedAuthMenu.do")
public String getCheckedsAuthMenu(HttpServletRequest request){
String parentId=request.getParameter("parentId");
String roleId=request.getParameter("roleId");
HttpSession session = request.getSession();
User user =(User) session.getAttribute("user");
Integer id = null;
if(user!=null){
id = user.getRoleId();
}
String authIds = "";
if(id==1){
Integer roleIntValue = Integer.parseInt(roleId);
// if(id !=roleIntValue){
authIds = roleService.getAuthIds(roleIntValue);
// }
}else{
authIds = null;
}
JSONArray jsonArray = new JSONArray();
try {
jsonArray = authService.getCheckedAuthMenus(Integer.parseInt(parentId), authIds);
} catch (NullPointerException e) {
// TODO: handle exception
return null;
}
return jsonArray.toString();
}
@ResponseBody
@RequestMapping("/authsave.do")
public String authSave(HttpServletRequest request){
String authId = request.getParameter("authId");
@Controller
@RequestMapping("/grade")
public class GradeController {
@Resource
private GradeService gradeService;
@Resource
private StudentService studentService;
@ResponseBody
@RequestMapping("/getGrade.do")
public String getGrade(HttpServletRequest request){
String studentNo = request.getParameter("studentNo");
if(StringUtil.isNotEmpty(studentNo)){
JSONArray json=gradeService.getGradeList(studentNo);
return json.toString();
}else{
return null;
}
}
@ResponseBody
@RequestMapping("/save.do")
public String save(HttpServletRequest request){
String studentNo = request.getParameter("studentNo");
String score = request.getParameter("score");
String id = request.getParameter("id");
String math = request.getParameter("math");
String english = request.getParameter("english");
String sport = request.getParameter("sport");
return result.toString();
}
@ResponseBody
@RequestMapping("/save.do")
public String save(HttpServletRequest request){
String id = request.getParameter("id");
String studentName = request.getParameter("studentName");
String studentNo = request.getParameter("studentNo");
String sex = request.getParameter("sex");
String deptNo = request.getParameter("deptNo");
String deptName = request.getParameter("deptName");
String IdCard = request.getParameter("IdCard");
String address = request.getParameter("address");
String postcode = request.getParameter("postcode");
Student stu = new Student();
stu.setStudentName(studentName);
stu.setStudentNo(studentNo);
stu.setSex(sex);
stu.setDeptNo(deptNo);
stu.setIdCard(IdCard);
stu.setAddress(address);
stu.setPostcode(postcode);
int saveNums = 0;
JSONObject result=new JSONObject();
if(StringUtil.isEmpty(id)){
if(studentService.existStudentWithStudentNo(studentNo)){
saveNums = -1;
}else{
//后期可以使用回滚防止添加一半出现错误
saveNums=studentService.studentAdd(stu);
Reward r = new Reward();
r.setStudentNo(studentNo);
r.setDeptNo(deptNo);
rewardService.rewardAdd(r);
}
}else{
stu.setId(id);
saveNums = studentService.studentUpdate(stu);
}
if(saveNums==-1){
result.put("success", true);
result.put("errorMsg", "此用户名已经存在");
}else if(saveNums==0){
result.put("success", true);
result.put("errorMsg", "保存失败");
}else{
result.put("success", true);
}
return result.toString();
}
return result.toString();
}
}
int delNums = roleService.roleDelete(delIds);
if (delNums > 0) {
result.put("success", true);
result.put("delNums", delNums);
} else {
result.put("errorMsg", "删除失败");
}
return result.toString();
}
@ResponseBody
@RequestMapping("/roleAuth.do")
public String roleAuth(HttpServletRequest request){
String roleId=request.getParameter("roleId");
String authIds=request.getParameter("authIds");
Role role = new Role();
role.setRoleId(Integer.parseInt(roleId));
role.setAuthIds(authIds);
JSONObject result = new JSONObject();
int updateNums = roleService.roleAuthIdsUpdate(role);
if (updateNums > 0) {
result.put("success", true);
} else {
result.put("errorMsg", "授权失败");
}
return result.toString();
}
}
package com.java.controller;