基于javaweb+mysql的springboot学生学科竞赛管理系统设计和实现(java+springboot+ssm+maven+html)

基于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("上级菜单不能为空");
		}

请添加图片描述

请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值