基于javaweb+mysql的springboot学生学科竞赛管理系统设计和实现(java+springboot+ssm+maven+html)
运行环境
Java≥8、MySQL≥5.7
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SpringBoot学生学科竞赛管理系统设计和实现(java+springboot+ssm+maven+html)
主要技术、spring、 springmvc、 springboot、 mybatis 、 jquery 、 layUI、md5 、bootstarp.js tomcat、、拦截器等项目 主要功能:登录、用户、菜单管理、角色管理、权限管理、立项申请、报名、结、经费管理、审核、统计等
用户登录:输入账号密码和验证码登录登录、登陆后根据用户权限显示不同菜单、角色灵活控制。
管理后主要功能模块:用户管理、角色管理、承菜管理、权限管理、竞赛报名管理、经费申请和审核管理、项目结题管理、立项申请管理等具体功能
用户管理:用户列表的显示、数据的添加以及删除修改等操作。
角色管理:通过给用户绑定角色、角色控制菜单灵活显示菜单权限功能。用户可以新建多角色
菜单管理:
系统日志监控:aop切面编程实现日志记录操作
业务模块功能;
立项申请:
立项审核:
活动经费预算申请:
立项申请个人赛以及团队赛报名管理:录入报名相关信息字段
项目结题管理:
项目完成之后选择项目进行资金使用统计结题:录入金额
项目结题统计:
代码结构:idea、eclipse直接导入就可运行
}
return ;
}
//按钮
if(menu.getType() == Constant.MenuType.BUTTON.getValue()){
if(parentType != Constant.MenuType.MENU.getValue()){
throw new RRException("上级菜单只能为菜单类型");
}
return ;
}
}
}
/**
* .
*
*
*
*
*/
/**
* XSS过滤处理
*
*/
public class XssHttpServletRequestWrapper extends HttpServletRequestWrapper {
/**
* 没被包装过的HttpServletRequest(特殊场景,需要自己过滤)
*/
HttpServletRequest orgRequest;
/**
/**
* 系统日志,切面处理类
*
*/
@Aspect
@Component
public class SysLogAspect {
@Autowired
private SysLogService sysLogService;
@Pointcut("@annotation(io.renren.common.annotation.SysLog)")
public void logPointCut() {
}
@Around("logPointCut()")
public Object around(ProceedingJoinPoint point) throws Throwable {
long beginTime = System.currentTimeMillis();
//执行方法
Object result = point.proceed();
//执行时长(毫秒)
long time = System.currentTimeMillis() - beginTime;
//保存日志
saveSysLog(point, time);
return result;
}
* 选择部门(添加、修改菜单)
*/
@RequestMapping("/select")
@RequiresPermissions("sys:dept:select")
public R select(){
List<SysDeptEntity> deptList = sysDeptService.queryList(new HashMap<String, Object>());
//添加一级部门
if(getUserId() == Constant.SUPER_ADMIN){
SysDeptEntity root = new SysDeptEntity();
root.setDeptId(0L);
root.setName("一级部门");
root.setParentId(-1L);
root.setOpen(true);
deptList.add(root);
}
return R.ok().put("deptList", deptList);
}
/**
* 上级部门Id(管理员则为0)
*/
@RequestMapping("/info")
@RequiresPermissions("sys:dept:list")
public R info(){
long deptId = 0;
if(getUserId() != Constant.SUPER_ADMIN){
List<SysDeptEntity> deptList = sysDeptService.queryList(new HashMap<String, Object>());
Long parentId = null;
for(SysDeptEntity sysDeptEntity : deptList){
if(parentId == null){
parentId = sysDeptEntity.getParentId();
continue;
}
if(parentId > sysDeptEntity.getParentId().longValue()){
parentId = sysDeptEntity.getParentId();
}
}
deptId = parentId;
}
return R.ok().put("deptId", deptId);
}
/**
* 信息
*/
@RequestMapping("/info/{deptId}")
*/
@ResponseBody
@RequestMapping(value = "/sys/login", method = RequestMethod.POST)
public R login(String username, String password, String captcha) {
String kaptcha = ShiroUtils.getKaptcha(Constants.KAPTCHA_SESSION_KEY);
if(!captcha.equalsIgnoreCase(kaptcha)){
return R.error("验证码不正确");
}
try{
Subject subject = ShiroUtils.getSubject();
UsernamePasswordToken token = new UsernamePasswordToken(username, password);//md5+Jiayan
subject.login(token);
}catch (UnknownAccountException e) {
return R.error(e.getMessage());
}catch (IncorrectCredentialsException e) {
return R.error("账号或密码不正确");
}catch (LockedAccountException e) {
return R.error("账号已被锁定,请联系管理员");
}catch (AuthenticationException e) {
return R.error("账户验证失败");
}
return R.ok();
}
/**
* 退出
*/
@RequestMapping(value = "logout", method = RequestMethod.GET)
public String logout() {
ShiroUtils.logout();
return "redirect:login.html";
}
}
///**
// * .
// *
// *
// *
// *
// */
//
//package io.renren.modules.sys.controller;
//
ImageIO.write(image, "jpg", out);
}
/**
* 登录
*/
@ResponseBody
@RequestMapping(value = "/sys/login", method = RequestMethod.POST)
public R login(String username, String password, String captcha) {
String kaptcha = ShiroUtils.getKaptcha(Constants.KAPTCHA_SESSION_KEY);
if(!captcha.equalsIgnoreCase(kaptcha)){
return R.error("验证码不正确");
}
try{
Subject subject = ShiroUtils.getSubject();
UsernamePasswordToken token = new UsernamePasswordToken(username, password);//md5+Jiayan
subject.login(token);
}catch (UnknownAccountException e) {
return R.error(e.getMessage());
}catch (IncorrectCredentialsException e) {
return R.error("账号或密码不正确");
}catch (LockedAccountException e) {
return R.error("账号已被锁定,请联系管理员");
}catch (AuthenticationException e) {
return R.error("账户验证失败");
}
return R.ok();
}
/**
* 退出
*/
@RequestMapping(value = "logout", method = RequestMethod.GET)
public String logout() {
ShiroUtils.logout();
return "redirect:login.html";
}
}
* 角色信息
*/
@RequestMapping("/info/{roleId}")
@RequiresPermissions("sys:role:info")
public R info(@PathVariable("roleId") Long roleId){
SysRoleEntity role = sysRoleService.getById(roleId);
//查询角色对应的菜单
List<Long> menuIdList = sysRoleMenuService.queryMenuIdList(roleId);
role.setMenuIdList(menuIdList);
//查询角色对应的部门
List<Long> deptIdList = sysRoleDeptService.queryDeptIdList(new Long[]{roleId});
role.setDeptIdList(deptIdList);
return R.ok().put("role", role);
}
/**
* 保存角色
*/
@SysLog("保存角色")
@RequestMapping("/save")
@RequiresPermissions("sys:role:save")
public R save(@RequestBody SysRoleEntity role){
ValidatorUtils.validateEntity(role);
sysRoleService.saveRole(role);
return R.ok();
}
/**
* 修改角色
*/
@SysLog("修改角色")
@RequestMapping("/update")
@RequiresPermissions("sys:role:update")
public R update(@RequestBody SysRoleEntity role){
ValidatorUtils.validateEntity(role);
sysRoleService.update(role);
return R.ok();
}
/**
* 删除角色
*/
@SysLog("删除角色")
@RequestMapping("/delete")
@RequiresPermissions("sys:role:delete")
public R delete(@RequestBody Long[] roleIds){
sysRoleService.deleteBatch(roleIds);
@RestController
@RequestMapping("/sys/personal")
public class PersonalController extends AbstractController {
@Autowired
private PersonalService personalService;
@Autowired
private ClosingService closingService;
@RequestMapping("/list")
public R list(Map<String, Object> params) {
PageUtils page = personalService.queryPage(params);
return R.ok().put("page", page);
}
@RequestMapping("/info/{id}")
public R info(@PathVariable("id") Long id) {
Personal personal = personalService.getById(id);
return R.ok().put("personal", personal);
}
@RequestMapping("/save")
public R save(@RequestBody Personal personal) {
personalService.save(personal);
Closing closing = new Closing();
closing.setBid(personal.getId());
closing.setJtType("个人赛");
closing.setStartTime(new Date());
closing.setTitle(personal.getTitle());
closingService.save(closing);
return R.ok();
}
@RequestMapping("/update")
public R update(@RequestBody Personal personal) {
if (personal.getId() == null) {
save(personal);
} else {
personalService.updateById(personal);
}
return R.ok();
}
@RequiresPermissions("sys:dept:delete")
public R delete(long deptId){
//判断是否有子部门
List<Long> deptList = sysDeptService.queryDetpIdList(deptId);
if(deptList.size() > 0){
return R.error("请先删除子部门");
}
sysDeptService.removeById(deptId);
return R.ok();
}
}
/**
* .
*
*
*
*
*/
/**
* 角色管理
*
*/
@RestController
@RequestMapping("/sys/role")
public class SysRoleController extends AbstractController {
@Autowired
private SysRoleService sysRoleService;
@Autowired
private SysRoleMenuService sysRoleMenuService;
@Autowired
private SysRoleDeptService sysRoleDeptService;
@RestController
@RequestMapping("/sys/expenditure")
public class EexpenditureController extends AbstractController {
@Autowired
private ExpenditureService expenditureService;
@RequestMapping("/list")
public R list(Map<String, Object> params){
PageUtils page = expenditureService.queryPage(params);
return R.ok().put("page", page);
}
@RequestMapping("/info/{id}")
public R info(@PathVariable("id") Long id){
Expenditure expenditure = expenditureService.getById(id);
return R.ok().put("expenditure", expenditure);
}
@RequestMapping("/save")
public R save(@RequestBody Expenditure expenditure){
expenditure.setTotal(expenditure.getZhuche()+expenditure.getRate()+expenditure.getTrain()+expenditure.getGuidance()
+expenditure.getBonus()+expenditure.getOther()+expenditure.getHaocai());
expenditureService.save(expenditure);
return R.ok();
}
@RequestMapping("/update")
public R update(@RequestBody Expenditure expenditure){
if(expenditure.getId() == null){
save(expenditure);
}else{
expenditureService.updateById(expenditure);
}
return R.ok();
}
@RequestMapping("/delete")
public R delete(@RequestBody Long[] ids){
expenditureService.removeByIds(Arrays.asList(ids));
return R.ok();
}
}
// public R update(@RequestBody MCity city){
// //校验类型
// ValidatorUtils.validateEntity(city);
//
// cityService.updateById(city);
//
// return R.ok();
// }
//
// /**
// * 删除
// */
// @RequestMapping("/delete")
// @RequiresPermissions("sys:city:delete")
// public R delete(@RequestBody Long[] ids){
// cityService.removeByIds(Arrays.asList(ids));
//
// return R.ok();
// }
//
//}
@RestController
@RequestMapping("sys/dict")
public class SysDictController {
@Autowired
private SysDictService sysDictService;
@RequestMapping("/list")
@RequiresPermissions("sys:dict:list")
public R list(@RequestParam Map<String, Object> params) {
PageUtils page = sysDictService.queryPage(params);
return R.ok().put("page", page);
}
@RequestMapping("/info/{id}")
// @Autowired
// private MCityService cityService;
//
// /**
// * 列表
// */
// @RequestMapping("/list")
@RequiresPermissions("sys:city:list")
// public R list(@RequestParam Map<String, Object> params){
// PageUtils page = cityService.queryPage(params);
// return R.ok().put("page", page);
// }
//
//
// /**
// * 信息
// */
// @RequestMapping("/info/{id}")
// @RequiresPermissions("sys:city:info")
// public R info(@PathVariable("id") Long id){
// MCity dict = cityService.getById(id);
//
// return R.ok().put("city", dict);
// }
//
// /**
// * 保存
// */
// @RequestMapping("/save")
@RequiresPermissions("sys:city:save")
// public R save(@RequestBody MCity city){
// //校验类型
// ValidatorUtils.validateEntity(city);
//
// cityService.save(city);
//
// return R.ok();
// }
//
// /**
// * 修改
// */
// @RequestMapping("/update")
// @RequiresPermissions("sys:city:update")
// public R update(@RequestBody MCity city){
// //校验类型
// ValidatorUtils.validateEntity(city);
//
public class SysLogAspect {
@Autowired
private SysLogService sysLogService;
@Pointcut("@annotation(io.renren.common.annotation.SysLog)")
public void logPointCut() {
}
@Around("logPointCut()")
public Object around(ProceedingJoinPoint point) throws Throwable {
long beginTime = System.currentTimeMillis();
//执行方法
Object result = point.proceed();
//执行时长(毫秒)
long time = System.currentTimeMillis() - beginTime;
//保存日志
saveSysLog(point, time);
return result;
}
private void saveSysLog(ProceedingJoinPoint joinPoint, long time) {
MethodSignature signature = (MethodSignature) joinPoint.getSignature();
Method method = signature.getMethod();
SysLogEntity sysLog = new SysLogEntity();
SysLog syslog = method.getAnnotation(SysLog.class);
if(syslog != null){
//注解上的描述
sysLog.setOperation(syslog.value());
}
//请求的方法名
String className = joinPoint.getTarget().getClass().getName();
String methodName = signature.getName();
sysLog.setMethod(className + "." + methodName + "()");
//请求的参数
Object[] args = joinPoint.getArgs();
try{
String params = new Gson().toJson(args[0]);
sysLog.setParams(params);
}
@RequestMapping("/save")
public R save(@RequestBody Expenditure expenditure){
expenditure.setTotal(expenditure.getZhuche()+expenditure.getRate()+expenditure.getTrain()+expenditure.getGuidance()
+expenditure.getBonus()+expenditure.getOther()+expenditure.getHaocai());
expenditureService.save(expenditure);
return R.ok();
}
@RequestMapping("/update")
public R update(@RequestBody Expenditure expenditure){
if(expenditure.getId() == null){
save(expenditure);
}else{
expenditureService.updateById(expenditure);
}
return R.ok();
}
@RequestMapping("/delete")
public R delete(@RequestBody Long[] ids){
expenditureService.removeByIds(Arrays.asList(ids));
return R.ok();
}
}
@RestController
@RequestMapping("/sys/apply")
public class ApplyController extends AbstractController {
@Autowired
private ApplyService applyService;
@RequestMapping("/list")
public R list(Map<String, Object> params) {
PageUtils page = applyService.queryPage(params);
return R.ok().put("page", page);
}
@RequestMapping("/info/{id}")
public R info(@PathVariable("id") Long id) {
// public R list(@RequestParam Map<String, Object> params){
// PageUtils page = cityService.queryPage(params);
// return R.ok().put("page", page);
// }
//
//
// /**
// * 信息
// */
// @RequestMapping("/info/{id}")
// @RequiresPermissions("sys:city:info")
// public R info(@PathVariable("id") Long id){
// MCity dict = cityService.getById(id);
//
// return R.ok().put("city", dict);
// }
//
// /**
// * 保存
// */
// @RequestMapping("/save")
@RequiresPermissions("sys:city:save")
// public R save(@RequestBody MCity city){
// //校验类型
// ValidatorUtils.validateEntity(city);
//
// cityService.save(city);
//
// return R.ok();
// }
//
// /**
// * 修改
// */
// @RequestMapping("/update")
// @RequiresPermissions("sys:city:update")
// public R update(@RequestBody MCity city){
// //校验类型
// ValidatorUtils.validateEntity(city);
//
// cityService.updateById(city);
//
// return R.ok();
// }
//
// /**
// * 删除
// */
// @RequestMapping("/delete")
// @RequiresPermissions("sys:city:delete")
// public R delete(@RequestBody Long[] ids){
// cityService.removeByIds(Arrays.asList(ids));
//
// return R.ok();
@RestController
@RequestMapping("/sys/team")
public class TeamController extends AbstractController {
@Autowired
private TeamService teamService;
@Autowired
private ClosingService closingService;
@RequestMapping("/list")
public R list(Map<String, Object> params) {
PageUtils page = teamService.queryPage(params);
return R.ok().put("page", page);
}
@RequestMapping("/info/{id}")
public R info(@PathVariable("id") Long id) {
Team team = teamService.getById(id);
return R.ok().put("team", team);
}
@RequestMapping("/save")
public R save(@RequestBody Team team) {
team.setBmTime(new Date());
teamService.save(team);
Closing closing = new Closing();
closing.setBid(team.getId());
closing.setJtType("团队赛");
closing.setStartTime(new Date());
closing.setTitle(team.getTitle());
closingService.save(closing);
/**
* 系统菜单
*
*/
@RestController
@RequestMapping("/sys/menu")
public class SysMenuController extends AbstractController {
@Autowired
private SysMenuService sysMenuService;
/**
* 导航菜单
*/
@RequestMapping("/nav")
public R nav(){
List<SysMenuEntity> menuList = sysMenuService.getUserMenuList(getUserId());
return R.ok().put("menuList", menuList);
}
/**
* 所有菜单列表
*/
@RequestMapping("/list")
@RequiresPermissions("sys:menu:list")
public List<SysMenuEntity> list(){
List<SysMenuEntity> menuList = sysMenuService.list();
for(SysMenuEntity sysMenuEntity : menuList){
SysMenuEntity parentMenuEntity = sysMenuService.getById(sysMenuEntity.getParentId());
if(parentMenuEntity != null){
sysMenuEntity.setParentName(parentMenuEntity.getName());
}
}
return menuList;
}
verifyForm(menu);
sysMenuService.updateById(menu);
return R.ok();
}
/**
* 删除
*/
@SysLog("删除菜单")
@RequestMapping("/delete")
@RequiresPermissions("sys:menu:delete")
public R delete(long menuId){
if(menuId <= 31){
return R.error("系统菜单,不能删除");
}
//判断是否有子菜单或按钮
List<SysMenuEntity> menuList = sysMenuService.queryListParentId(menuId);
if(menuList.size() > 0){
return R.error("请先删除子菜单或按钮");
}
sysMenuService.delete(menuId);
return R.ok();
}
/**
* 验证参数是否正确
*/
private void verifyForm(SysMenuEntity menu){
if(StringUtils.isBlank(menu.getName())){
throw new RRException("菜单名称不能为空");
}
if(menu.getParentId() == null){
throw new RRException("上级菜单不能为空");
}