基于javaweb+mysql的ssm+maven学生管理系统(java+ssm+js+jsp+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SSM+Maven学生管理系统(java+ssm+js+jsp+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版本;
技术栈
- 后端:Spring+SpringMVC+Mybatis 2. 前端:HTML+CSS+JavaScript+jsp
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven;若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中application.yml配置文件中的数据库配置改为自己的配置; 4. 运行项目,输入localhost:8080/ 登录
/**
* 学生信息管理Controller类
*/
@Controller
@RequestMapping("/student")
public class StudentController {
@Resource
private StudentService studentService;
@Resource
private ScoreService scoreService;
@Autowired
private static final Logger log = Logger.getLogger(StudentController.class);// 日志文件
/**
* 获取学院列表Controller
*/
@RequestMapping(value = "/getDepartmentList", method = RequestMethod.POST)
@ResponseBody
public JSONArray getDepartmentList() {
List<Map<String, Object>> list = studentService.getDepartmentList();
if (list.size() > 0) {
JSONArray jsonArray = JSONArray.fromObject(list);
return jsonArray;
}
return null;
}
/**
* 获取专业列表Controller
*/
@RequestMapping(value = "/getMajorList", method = RequestMethod.POST)
@ResponseBody
public JSONArray getMajorList(String departmentKey) {
List<Map<String, Object>> list = studentService.getMajorList(departmentKey);
if (list.size() > 0) {
JSONArray jsonArray = JSONArray.fromObject(list);
return jsonArray;
}
return null;
}
/**
/**
* 获取专业列表Controller
*/
@RequestMapping(value = "/getMajorList", method = RequestMethod.POST)
@ResponseBody
public JSONArray getMajorList(String departmentKey) {
List<Map<String, Object>> list = studentService.getMajorList(departmentKey);
if (list.size() > 0) {
JSONArray jsonArray = JSONArray.fromObject(list);
return jsonArray;
}
return null;
}
/**
* 获取班级列表Controller
*/
@RequestMapping(value = "/getClassList", method = RequestMethod.POST)
@ResponseBody
public JSONArray getClassList(String majorKey) {
List<Map<String, Object>> list = studentService.getClassList(majorKey);
if (list.size() > 0) {
JSONArray jsonArray = JSONArray.fromObject(list);
return jsonArray;
}
return null;
}
/**
* 获取学生列表Controller
*/
@RequestMapping(value = "/getStudentList", method = RequestMethod.POST)
@ResponseBody
public JSONArray getStudentList(String classKey) {
List<Map<String, Object>> list = studentService.getStudentList(classKey);
if (list.size() > 0) {
JSONArray jsonArray = JSONArray.fromObject(list);
return jsonArray;
}
}
/**
* 添加学生信息
*
* @return
* @throws Exception
*/
@RequestMapping(value = "addSave", method = RequestMethod.POST)
@ResponseBody
public Result save(@RequestBody Student student) throws Exception {
int resultTotal;
resultTotal = studentService.addStudent(student);
if (resultTotal > 0) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult("FAIL");
}
}
/**
* 修改学生信息
*
* @return
* @throws Exception
*/
@RequestMapping(value = "updateSave", method = RequestMethod.POST)
@ResponseBody
public Result updateSave(@RequestBody Student student) throws Exception {
int resultTotal;
resultTotal = studentService.updateStudent(student);
if (resultTotal > 0) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult("FAIL");
}
}
/**
* 删除
*
* @param pkids
* @return
* @throws Exception
*/
@RequestMapping(value = "/delete/{pkids}", method = RequestMethod.DELETE)
@RequestParam(value = "courseName",required = false) String courseName,
@RequestParam(value = "majorName",required = false) String majorName,
@RequestParam(value = "department_name",required = false) String department_name,
@RequestParam(value = "className",required = false) String className,
@RequestParam(value = "user_name",required = false) String user_name
) throws Exception {
boolean flag = false;
Map<String, Object> map = new HashMap<>();
if(xm == null) {
map.put("where", "where 1 = 1");
}else if(xm != null){
flag = true;
map.put("where", "where xm like '%"+xm+"%'");
}
if(teacherName == null&&flag == false) {
map.put("where", "where 1 = 1");
}else if(teacherName != null){
flag = true;
map.put("where", "where teacherName like '%"+teacherName+"%'");
}
if(courseName == null&&flag == false) {
map.put("where", "where 1 = 1");
}else if(courseName != null){
flag = true;
map.put("where", "where courseName like '%"+courseName+"%'");
}
if(majorName == null&&flag == false) {
map.put("where", "where 1 = 1");
}else if(majorName != null){
flag = true;
map.put("where", "where majorName like '%"+majorName+"%'");
}
if(department_name == null&&flag == false) {
map.put("where", "where 1 = 1");
}else if(department_name != null){
flag = true;
map.put("where", "where department_name like '%"+department_name+"%'");
}
if(className == null&&flag == false) {
map.put("where", "where 1 = 1");
}else if(className != null){
flag = true;
map.put("where", "where className like '%"+className+"%'");
}
if(user_name == null&&flag == false) {
map.put("where", "where 1 = 1");
}else if(user_name != null){
flag = true;
}
/**
* 修改课程信息
*
* @return
* @throws Exception
*/
@RequestMapping(value = "updateSave", method = RequestMethod.POST)
@ResponseBody
public Result updateSave(@RequestBody Course course) throws Exception {
int resultTotal;
resultTotal = courseService.updateCourse(course);
if (resultTotal > 0) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult("FAIL");
}
}
/**
* 获取课程列表Controller
*/
@RequestMapping(value = "/getCourseList", method = RequestMethod.POST)
@ResponseBody
public JSONArray getCourseList(String classKey) {
List<Map<String, Object>> list = courseService.getCourseList(classKey);
if (list.size() > 0) {
JSONArray jsonArray = JSONArray.fromObject(list);
return jsonArray;
}
return null;
}
/**
* 删除
*
* @param pkids
* @return
* @throws Exception
*/
@RequestMapping(value = "/delete/{pkids}", method = RequestMethod.DELETE)
@ResponseBody
public Result delete(@PathVariable(value = "pkids") String pkids) throws Exception {
String[] pkidArr = pkids.split(",");
courseService.delete(pkidArr);
return ResultGenerator.genSuccessResult();
}
/**
* 删除班级信息
*
* @return
* @throws Exception
*/
@RequestMapping(value = "updateMajor", method = RequestMethod.POST)
@ResponseBody
public Result updateMajor(@RequestBody Major major) throws Exception {
int resultTotal;
resultTotal = baseDataService.updateMajor(major);
if (resultTotal > 0) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult("FAIL");
}
}
/**
* 删除专业信息
*
* @param pkids
* @return
* @throws Exception
*/
@RequestMapping(value = "/deleteMajor/{pkids}", method = RequestMethod.DELETE)
@ResponseBody
public Result deleteMajor(@PathVariable(value = "pkids") String pkids) throws Exception {
String[] pkidArr = pkids.split(",");
baseDataService.deleteMajor(pkidArr);
return ResultGenerator.genSuccessResult();
}
/**
* 添加班级信息
*
* @return
* @throws Exception
*/
@RequestMapping(value = "addClass", method = RequestMethod.POST)
@ResponseBody
public Result addClass(@RequestBody Class cls) throws Exception {
int resultTotal;
resultTotal = baseDataService.addClass(cls);
if (resultTotal > 0) {
return ResultGenerator.genSuccessResult();
} else {
@RequestMapping(value = "/cookie", method = RequestMethod.POST)
@ResponseBody
public Result login(User user) {
try {
String MD5pwd = MD5Util.MD5Encode(user.getPassword(), "UTF-8");
user.setPassword(MD5pwd);
} catch (Exception e) {
user.setPassword("");
}
User resultUser = userService.login(user);
log.info("request: user/login , user: " + user.toString());
if (resultUser == null) {
return ResultGenerator.genFailResult("账号或密码错误,请重新登录!");
} else {
resultUser.setPassword("PASSWORD");
Map data = new HashMap();
data.put("currentUser", resultUser);
return ResultGenerator.genSuccessResult(data);
}
}
/*
*添加用户
*/
@RequestMapping(value = "addSave", method = RequestMethod.POST)
@ResponseBody
public Result save(@RequestBody User user) throws Exception {
int resultTotal;
String MD5pwd = MD5Util.MD5Encode(user.getPassword(), "UTF-8");
user.setPassword(MD5pwd);
resultTotal = userService.addUser(user);
if (resultTotal > 0) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult("FAIL");
}
}
/*
* @Description 修改用户
* @param [user]
* @return com.wq.common.Result
* @throws
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult("FAIL");
}
}
/**
* 修改课程信息
*
* @return
* @throws Exception
*/
@RequestMapping(value = "updateSave", method = RequestMethod.POST)
@ResponseBody
public Result updateSave(@RequestBody Course course) throws Exception {
int resultTotal;
resultTotal = courseService.updateCourse(course);
if (resultTotal > 0) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult("FAIL");
}
}
/**
* 获取课程列表Controller
*/
@RequestMapping(value = "/getCourseList", method = RequestMethod.POST)
@ResponseBody
public JSONArray getCourseList(String classKey) {
List<Map<String, Object>> list = courseService.getCourseList(classKey);
if (list.size() > 0) {
JSONArray jsonArray = JSONArray.fromObject(list);
return jsonArray;
}
return null;
}
/**
* 删除
*
* @param pkids
* @return
* @throws Exception
*/
@RequestMapping(value = "/delete/{pkids}", method = RequestMethod.DELETE)
@ResponseBody
public Result delete(@PathVariable(value = "pkids") String pkids) throws Exception {
String[] pkidArr = pkids.split(",");
courseService.delete(pkidArr);
return ResultGenerator.genSuccessResult();
}
/**
/**
* 删除
*
* @param pkids
* @return
* @throws Exception
*/
@RequestMapping(value = "/delete/{pkids}", method = RequestMethod.DELETE)
@ResponseBody
public Result delete(@PathVariable(value = "pkids") String pkids) throws Exception {
String[] pkidArr = pkids.split(",");
teacherService.delete(pkidArr);
return ResultGenerator.genSuccessResult();
}
/**
* 获取老师列表Controller
*/
@RequestMapping(value = "/getTeacherList", method = RequestMethod.POST)
@ResponseBody
public JSONArray getTeacherList() {
List<Map<String, Object>> list = teacherService.getTeacherList();
if (list.size() > 0) {
JSONArray jsonArray = JSONArray.fromObject(list);
return jsonArray;
}
return null;
}
}
/**
* 教师信息管理Controller类
*/
@Controller
@RequestMapping("/teacher")
public class TeacherController {
@Resource
private TeacherService teacherService;
/**
* 添加教师信息
*
* @return
* @throws Exception
*/
@RequestMapping(value = "addSave", method = RequestMethod.POST)
@ResponseBody
public Result addSave(@RequestBody Teacher teacher) throws Exception {
int resultTotal;
resultTotal = teacherService.addTeacher(teacher);
if (resultTotal > 0) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult("FAIL");
}
}
/**
* 修改教师信息
*
* @return
* @throws Exception
*/
@RequestMapping(value = "updateSave", method = RequestMethod.POST)
@ResponseBody
public Result deleteMajor(@PathVariable(value = "pkids") String pkids) throws Exception {
String[] pkidArr = pkids.split(",");
baseDataService.deleteMajor(pkidArr);
return ResultGenerator.genSuccessResult();
}
/**
* 添加班级信息
*
* @return
* @throws Exception
*/
@RequestMapping(value = "addClass", method = RequestMethod.POST)
@ResponseBody
public Result addClass(@RequestBody Class cls) throws Exception {
int resultTotal;
resultTotal = baseDataService.addClass(cls);
if (resultTotal > 0) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult("FAIL");
}
}
/**
* 修改班级信息
*
* @return
* @throws Exception
*/
@RequestMapping(value = "updateClass", method = RequestMethod.POST)
@ResponseBody
public Result updateClass(@RequestBody Class cls) throws Exception {
int resultTotal;
resultTotal = baseDataService.updateClass(cls);
if (resultTotal > 0) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult("FAIL");
}
}
/**
* 删除班级信息
return ResultGenerator.genSuccessResult();
}
/**
* 添加学生成绩
*
* @return
* @throws Exception
*/
@RequestMapping(value = "addScore", method = RequestMethod.POST)
@ResponseBody
public Result addScore(@RequestBody Score score) throws Exception {
int resultTotal;
resultTotal = scoreService.addScore(score);
if (resultTotal > 0) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult("FAIL");
}
}
/**
* 修改学生成绩
*
* @return
* @throws Exception
*/
@RequestMapping(value = "updateScore", method = RequestMethod.POST)
@ResponseBody
public Result updateScore(@RequestBody Score score) throws Exception {
int resultTotal;
resultTotal = scoreService.updateScore(score);
if (resultTotal > 0) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult("FAIL");
}
}
/**
* 删除
*
* @param pkids
* @return
* @throws Exception
*/
/**
* 获取老师列表Controller
*/
@RequestMapping(value = "/getTeacherList", method = RequestMethod.POST)
@ResponseBody
public JSONArray getTeacherList() {
List<Map<String, Object>> list = teacherService.getTeacherList();
if (list.size() > 0) {
JSONArray jsonArray = JSONArray.fromObject(list);
return jsonArray;
}
return null;
}
}
/**
* 列表查询工具类
*
* @ClassName DataGridUtil
**/
public class DataGridUtil {
@Resource
private BaseMapper baseMapper;
@Resource
private CommonService service;
public void selectDataGrid(HttpServletResponse response, Map<String, Object> dataMap) throws Exception {
String page = (dataMap.get("page") == null ? 1 : dataMap.get("page")) + "";//起始页
String rows = (dataMap.get("rows") == null ? 10 : dataMap.get("rows")) + "";//每页条数
String table = dataMap.get("table") + "";//表名
String where = dataMap.get("where") + "";
PageBean pageBean = new PageBean(Integer.parseInt(page), Integer.parseInt(rows));
Map<String, Object> map = new HashMap<>();
map.put("start", pageBean.getStart());
map.put("size", pageBean.getPageSize());
}else if(xm != null){
flag = true;
map.put("where", "where xm like '%"+xm+"%'");
}
if(teacherName == null&&flag == false) {
map.put("where", "where 1 = 1");
}else if(teacherName != null){
flag = true;
map.put("where", "where teacherName like '%"+teacherName+"%'");
}
if(courseName == null&&flag == false) {
map.put("where", "where 1 = 1");
}else if(courseName != null){
flag = true;
map.put("where", "where courseName like '%"+courseName+"%'");
}
if(majorName == null&&flag == false) {
map.put("where", "where 1 = 1");
}else if(majorName != null){
flag = true;
map.put("where", "where majorName like '%"+majorName+"%'");
}
if(department_name == null&&flag == false) {
map.put("where", "where 1 = 1");
}else if(department_name != null){
flag = true;
map.put("where", "where department_name like '%"+department_name+"%'");
}
if(className == null&&flag == false) {
map.put("where", "where 1 = 1");
}else if(className != null){
flag = true;
map.put("where", "where className like '%"+className+"%'");
}
if(user_name == null&&flag == false) {
map.put("where", "where 1 = 1");
}else if(user_name != null){
flag = true;
map.put("where", "where user_name like '%"+user_name+"%'");
}
map.put("page", page);
*/
@RequestMapping(value = "/cookie", method = RequestMethod.POST)
@ResponseBody
public Result login(User user) {
try {
String MD5pwd = MD5Util.MD5Encode(user.getPassword(), "UTF-8");
user.setPassword(MD5pwd);
} catch (Exception e) {
user.setPassword("");
}
User resultUser = userService.login(user);
log.info("request: user/login , user: " + user.toString());
if (resultUser == null) {
return ResultGenerator.genFailResult("账号或密码错误,请重新登录!");
} else {
resultUser.setPassword("PASSWORD");
Map data = new HashMap();
data.put("currentUser", resultUser);
return ResultGenerator.genSuccessResult(data);
}
}
/*
*添加用户
*/
@RequestMapping(value = "addSave", method = RequestMethod.POST)
@ResponseBody
public Result save(@RequestBody User user) throws Exception {
int resultTotal;
String MD5pwd = MD5Util.MD5Encode(user.getPassword(), "UTF-8");
user.setPassword(MD5pwd);
resultTotal = userService.addUser(user);
if (resultTotal > 0) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult("FAIL");
}
}
/*
* @Description 修改用户
* @param [user]
* @return com.wq.common.Result
* @throws
*/
@RequestMapping(value = "updateSave", method = RequestMethod.POST)
@ResponseBody
public Result update(@RequestBody User user) throws Exception {
@ResponseBody
public Result addSave(@RequestBody Course course) throws Exception {
int resultTotal;
resultTotal = courseService.addCourse(course);
if (resultTotal > 0) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult("FAIL");
}
}
/**
* 修改课程信息
*
* @return
* @throws Exception
*/
@RequestMapping(value = "updateSave", method = RequestMethod.POST)
@ResponseBody
public Result updateSave(@RequestBody Course course) throws Exception {
int resultTotal;
resultTotal = courseService.updateCourse(course);
if (resultTotal > 0) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult("FAIL");
}
}
/**
* 获取课程列表Controller
*/
@RequestMapping(value = "/getCourseList", method = RequestMethod.POST)
@ResponseBody
public JSONArray getCourseList(String classKey) {
List<Map<String, Object>> list = courseService.getCourseList(classKey);
if (list.size() > 0) {
JSONArray jsonArray = JSONArray.fromObject(list);
return jsonArray;
}
return null;
}
/**
* 删除
*
* @param pkids
* @return
* @throws Exception
*/
@RequestMapping(value = "/delete/{pkids}", method = RequestMethod.DELETE)
@ResponseBody
public Result delete(@PathVariable(value = "pkids") String pkids) throws Exception {
String[] pkidArr = pkids.split(",");
@ResponseBody
public Result updateSave(@RequestBody Teacher teacher) throws Exception {
int resultTotal;
resultTotal = teacherService.updateTeacher(teacher);
if (resultTotal > 0) {
return ResultGenerator.genSuccessResult();
} else {
return ResultGenerator.genFailResult("FAIL");
}
}
/**
* 删除
*
* @param pkids
* @return
* @throws Exception
*/
@RequestMapping(value = "/delete/{pkids}", method = RequestMethod.DELETE)
@ResponseBody
public Result delete(@PathVariable(value = "pkids") String pkids) throws Exception {
String[] pkidArr = pkids.split(",");
teacherService.delete(pkidArr);
return ResultGenerator.genSuccessResult();
}
/**
* 获取老师列表Controller
*/
@RequestMapping(value = "/getTeacherList", method = RequestMethod.POST)
@ResponseBody
public JSONArray getTeacherList() {
List<Map<String, Object>> list = teacherService.getTeacherList();
if (list.size() > 0) {
JSONArray jsonArray = JSONArray.fromObject(list);
return jsonArray;
}
return null;
}
}