学生信息管理系统(SSM+JSP)
学生信息管理系统(SSM+JSP)
1.管理员主要功能有学生管理，课程管理，奖惩管理，综合素质登记，成绩管理。
2.学生主要功能有，修改个人信息，包括首次修改默认密码，学生选课，成绩查看，绩点查询。
3.页面使用Bootstrap框架和EasyUI，后台使用Spring、SpringMVC和MyBatis框架。
4.JDK1.8 tomcat7 idea2017 MySQL5.5
由xpsviewer修改，完善。 （用于课程设计）
1.管理端添加学生请假管理和学生宿舍信息管理。
2.学生端添加学生奖励，处罚记录查看，学生素质分查看，学生住宿信息查看，学生请假。
3.完善登陆检查，防止非法未授权登陆。
4.完善部分输入检查。
5.将项目打包成maven项目，更新spring和spring mvc版本 方便搭建。
6.奖励，处罚，素质添加时间，满足实际需求。
7.添加修改学生，管理员密码功能。
8.增加宿舍片区管理。
9.完善数据库约束设计与触发器，有效减少脏数据。
自带数据库sql和详细搭建说明文档，由于以前不会用git，所有修改提交已经丢失，不能diff每个功能的差异，不过代码可读性尚可。
下载地址 https://github.com/21503882/studentinfo
@Controller
@RequestMapping(value = "/stu/stuManager" ,method = {RequestMethod.POST,RequestMethod.GET})
public class StuManagerController {
@Autowired
private StuManagerService stuManagerService;
/**
*
* 获取管理员的登录状态
* @param
* @param
* @param
*/
@RequestMapping("/getAdminLoginStatus.do")
public void getAdminLoginStatus(HttpServletRequest request, HttpServletResponse response) throws IOException
{
Map<String,Object> result = new HashMap<String,Object>();
if(request.getSession().getAttribute("adminDisplayName")!=null)
{
result.put("code",true);
}
else
{
result.put("code",false);
}
ResponseUtil.returnJson(result,response);
}
/**
* 获取switch开关状态
* @param name
* @param request
* @param response
* @throws IOException
*/
@RequestMapping("/getSwitch.do")
public void getSwitch(String name,HttpServletRequest request, HttpServletResponse response) throws IOException {
Map<String,Object> result = new HashMap<String,Object>();
result = stuManagerService.getSwitch(name);
ResponseUtil.returnJson(result,response);
}
/**
* 修改switch开关状态
* @param name
* @param state
* @param request
* @param response
* @throws IOException
*/
@RequestMapping("/setSwitch.do")
public void getSwitch(String name,boolean state,HttpServletRequest request, HttpServletResponse response) throws IOException {
Map<String,Object> result = new HashMap<String,Object>();
result = stuManagerService.setSwitch(name,state);
ResponseUtil.returnJson(result,response);
}
/**
* 获取全部学生信息
* @param request
* @param response
*/
@RequestMapping(value = "/getAllStu.do",method = {RequestMethod.POST,RequestMethod.GET})
public void getAllStu(String keywords,int page,int rows ,HttpServletRequest request, HttpServletResponse response) throws IOException {
Map<String,Object> data = new HashMap<String,Object>();
data = stuManagerService.getAllstu(keywords,page,rows);
ResponseUtil.returnJson(data, response);
}
/**
* 添加学生
* @param name
* @param idcard
* @param sex
* @param request
* @param response
* @throws IOException
*/
@RequestMapping(value = "/addStudent.do",method = {RequestMethod.POST,RequestMethod.GET})
public void addStudent(String name,String idcard,String sex ,HttpServletRequest request, HttpServletResponse response) throws IOException {
Map<String,Object> data = new HashMap<String,Object>();
data = stuManagerService.addStudent(name,idcard,sex);
ResponseUtil.returnJson(data, response);
}
/**
* 删除学生信息
* @param id
* @param request
* @param response
* @throws IOException
*/
@RequestMapping(value = "/delStudent.do",method = {RequestMethod.POST,RequestMethod.GET})
public void delStudent(String id ,HttpServletRequest request, HttpServletResponse response) throws IOException {
Map<String,Object> data = new HashMap<String,Object>();
data = stuManagerService.delStudent(id);
ResponseUtil.returnJson(data, response);
}
/**
* 多选删除
* @param ids
* @param request
* @param response
* @throws IOException
*/
@RequestMapping(value = "/delMoreStudent.do",method = {RequestMethod.POST,RequestMethod.GET})
public void delMoreStudent(String[] ids,HttpServletRequest request, HttpServletResponse response) throws IOException {
Map<String,Object> data = new HashMap<String,Object>();
data = stuManagerService.delMoreStudent(ids);
ResponseUtil.returnJson(data, response);
}
/**
* 根据学生ID查找学生
* @param id
* @param request
* @param response
* @throws IOException
*/
@RequestMapping(value = "/getStudent.do",method = {RequestMethod.POST,RequestMethod.GET})
public void getStudent(String id,HttpServletRequest request, HttpServletResponse response) throws IOException {
Map<String,Object> data = new HashMap<String,Object>();
data = stuManagerService.getStudent(id);
ResponseUtil.returnJson(data, response);
}
/**
* 修改学生信息
* @param id
* @param name
* @param idcard
* @param sex
* @param phone
* @param qq
* @param email
* @param address
* @param request
* @param response
* @throws IOException
*/
@RequestMapping(value = "/updateStudent.do",method = {RequestMethod.POST,RequestMethod.GET})
public void updateStudent(String id,String name,String idcard,String sex,String phone,String qq,String email,String address,HttpServletRequest request, HttpServletResponse response) throws IOException {
Map<String,Object> data = new HashMap<String,Object>();
data = stuManagerService.updateStudent(name,idcard,sex,phone,qq,email,address,id);
ResponseUtil.returnJson(data, response);
}
/**
* 获取学生下拉列表
* @param request
* @param response
* @throws IOException
*/
@RequestMapping(value = "/getStudentCombox.do",method = {RequestMethod.POST,RequestMethod.GET})
public void getStudentCombox(HttpServletRequest request, HttpServletResponse response) throws IOException {
List<Map<String,Object>> data = new ArrayList<>();
data = stuManagerService.getStudentCombox();
ResponseUtil.returnJson(data, response);
}
/**
* 通过学生id查找学生奖惩信息
* @param id
* @param request
* @param response
* @throws IOException
*/
@RequestMapping(value = "/getStudentReward.do",method = {RequestMethod.POST,RequestMethod.GET})
public void getStudentReward(int id,HttpServletRequest request, HttpServletResponse response) throws IOException {
Map<String,Object> data = new HashMap<String,Object>();
data = stuManagerService.getStudentReward(id);
ResponseUtil.returnJson(data, response);
}
/**
* 添加奖励信息
* @param id
* @param content
* @param request
* @param response
* @throws IOException
*/
@RequestMapping(value = "/addreward.do",method = {RequestMethod.POST,RequestMethod.GET})
public void addreward(int id,String content,String time,HttpServletRequest request, HttpServletResponse response) throws IOException {
Map<String,Object> data = new HashMap<String,Object>();
data = stuManagerService.addreward(id,content,time);
ResponseUtil.returnJson(data, response);
}
/**
* 查找奖励下拉列表
* @param id
* @param request
* @param response
* @throws IOException
*/
@RequestMapping(value = "/getRewardCombobox.do",method = {RequestMethod.POST,RequestMethod.GET})
public void getRewardCombobox(int id,HttpServletRequest request, HttpServletResponse response) throws IOException {
List<Map<String,Object>> data = new ArrayList<>();
data = stuManagerService.getRewardCombobox(id);
ResponseUtil.returnJson(data, response);
}
/**
* 删除奖励信息
* @param id
* @param request
* @param response
* @throws IOException
*/
@RequestMapping(value = "/delReword.do",method = {RequestMethod.POST,RequestMethod.GET})
public void delReword(int id,HttpServletRequest request, HttpServletResponse response) throws IOException {
Map<String,Object> data = new HashMap<String,Object>();
data = stuManagerService.delReword(id);
ResponseUtil.returnJson(data, response);
}
/**
* 新增惩罚
* @param id
* @param content
* @param request
* @param response
* @throws IOException
*/
@RequestMapping(value = "/addPunish.do",method = {RequestMethod.POST,RequestMethod.GET})
public void addPunish(int id,String content,String time,HttpServletRequest request, HttpServletResponse response) throws IOException {
Map<String,Object> data = new HashMap<String,Object>();
data = stuManagerService.addPunish(id,content,time);
ResponseUtil.returnJson(data, response);
}
/**
* 查找惩罚下拉列表
* @param id
* @param request
* @param response
* @throws IOException
*/
@RequestMapping(value = "/getPunishCombobox.do",method = {RequestMethod.POST,RequestMethod.GET})
public void getPunishCombobox(int id,HttpServletRequest request, HttpServletResponse response) throws IOException {
List<Map<String,Object>> data = new ArrayList<>();
data = stuManagerService.getPunishCombobox(id);
ResponseUtil.returnJson(data, response);
}
/**
* 删除惩罚
* @param id
* @param request
* @param response
* @throws IOException
*/
@RequestMapping(value = "/delPunish.do",method = {RequestMethod.POST,RequestMethod.GET})
public void delPunish(int id,HttpServletRequest request, HttpServletResponse response) throws IOException {
Map<String,Object> data = new HashMap<String,Object>();
data = stuManagerService.delPunish(id);
ResponseUtil.returnJson(data, response);
}
/**
* 获得学生素质拓展列表
* @param id
* @param page
* @param rows
* @param keywords
* @param request
* @param response
* @throws IOException
*/
@RequestMapping(value = "/getAllQuality.do",method = {RequestMethod.POST,RequestMethod.GET})
public void getAllQuality(int id,int page,int rows,String keywords,HttpServletRequest request, HttpServletResponse response) throws IOException {
Map<String,Object> data = new HashMap<String,Object>();
data = stuManagerService.getAllQuality(id,page,rows,keywords);
ResponseUtil.returnJson(data, response);
}
/**
* 计算学生素质拓展分总分
* @param id
* @param request
* @param response
* @throws IOException
*/
@RequestMapping(value = "/getCountQuality.do",method = {RequestMethod.POST,RequestMethod.GET})
public void getCountQuality(int id,HttpServletRequest request, HttpServletResponse response) throws IOException {
Map<String,Object> data = new HashMap<String,Object>();
data = stuManagerService.getCountQuality(id);
ResponseUtil.returnJson(data, response);
}
/**
* 删除素质拓展活动
* @param id
* @param request
* @param response
* @throws IOException
*/
@RequestMapping(value = "/delQuality.do",method = {RequestMethod.POST,RequestMethod.GET})
public void delQuality(int id,HttpServletRequest request, HttpServletResponse response) throws IOException {
Map<String,Object> data = new HashMap<String,Object>();
data = stuManagerService.delQuality(id);
ResponseUtil.returnJson(data, response);
}
/**
* 添加学生素质拓展活动
* @param id
* @param name
* @param score
* @param request
* @param response
* @throws IOException
*/
@RequestMapping(value = "/addQulity.do",method = {RequestMethod.POST,RequestMethod.GET})
public void addQulity(int id,String name,float score,String time,HttpServletRequest request, HttpServletResponse response) throws IOException {
Map<String,Object> data = new HashMap<String,Object>();
data = stuManagerService.addQulity(id,name,score,time);
ResponseUtil.returnJson(data, response);
}
@RequestMapping(value = "/checkStuDuplicate.do",method = {RequestMethod.POST,RequestMethod.GET})
public void checkStuDuplicate(String stuName,String stuIdCard,HttpServletRequest request, HttpServletResponse response) throws IOException{
Map<String,Object> result = new HashMap<String,Object>();
if(stuManagerService.checkStuDuplicate(stuName,stuIdCard)!=0)
{
result.put("code",false);
result.put("msg","该学生已经存在!");
}
else
{
result.put("code",true);
}
ResponseUtil.returnJson(result, response);
}
}