基于javaweb+mysql的springboot校园运动会管理系统(java+springboot+vue+elementui+mysql)

基于javaweb+mysql的springboot校园运动会管理系统(java+springboot+vue+elementui+mysql)

运行环境

Java≥8、MySQL≥5.7、Node.js≥10

开发工具

后端：eclipse/idea/myeclipse/sts等均可配置运行

前端：WebStorm/VSCode/HBuilderX等均可

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

基于javaweb+mysql的SpringBoot校园运动会管理系统(java+springboot+vue+elementui+mysql)

环境需要

1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA; 3.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS； 4.数据库：MySql 5.7/8.0版本均可； 5.是否Maven项目：是；

技术栈

1.后端：SpringBoot+Mybaits 2.前端：Vue +ElementUI +HTML+CSS+JS

使用说明

项目运行： 1. 使用Navicat或者其它工具，在mysql中创建对应sql文件名称的数据库，并导入项目的sql文件； 2. 使用IDEA/Eclipse/MyEclipse导入项目，导入成功后请执行maven clean;maven install命令，然后运行； 3. 将项目中application.yml配置文件中的数据库配置改为自己的配置;

if(CommonUtils.isEmpty(project.getCountry())){

return AjaxResult.errorInstance("请填写承办方");

if(project.getBegintime()==null){

return AjaxResult.errorInstance("请填写比赛时间");

if(projectService.insert(project)<=0){

return AjaxResult.errorInstance("添加比赛失败");

return AjaxResult.successInstance("添加比赛项目成功");

/**

* 比赛项目编辑操作

* @return

*/

if (CommonUtils.isEmpty(user.getName()) ){

return AjaxResult.errorInstance("请填写名称");

if (CommonUtils.isEmpty(user.getPhone()) ){

return AjaxResult.errorInstance("请填写手机号");

if (CommonUtils.isEmpty(user.getPassword()) ){

return AjaxResult.errorInstance("请填写密码");

if (CommonUtils.isEmpty(user.getPassword()) ){

return AjaxResult.errorInstance("请填写队伍");

User byMobile = userService.findByMobile(user.getPhone());

if(byMobile!=null){

return AjaxResult.errorInstance("该手机号已存在");

if(userService.insert(user)<=0){

String name=request.getParameter("project");

Project project = new Project();

project.setName(name);

project=projectService.selectOne(project);

List<User> userList=projectUserSerivce.selectSecondListByFirstId(project.getId());

modelAndView.addObject("userList",userList);

List<Project> projectList=projectService.selectList();

modelAndView.addObject("projectList", projectList);

modelAndView.addObject("name",name);

request.setAttribute("projectId", project.getId());

return modelAndView;

*/

@RequestMapping(value = "login.do", method = RequestMethod.POST)

public ModelAndView login(String name, String password,String type,HttpServletRequest request) {

if("1".equals(type)){

//表示运动员

ModelAndView modelAndView = new ModelAndView();//跳转

User user = userService.checkPassword(name, password);

if (user != null) {

request.getSession().setAttribute("user", user);

request.getSession().setAttribute("name",user.getName());

modelAndView.setViewName("redirect:/");

/**

* 搜索运动员

* @param name

* @return

*/

@RequestMapping(value = "serach.do", method = RequestMethod.GET)

public ModelAndView serach(String name,HttpServletRequest request) {

User user = new User();

if(!"".equals(name)){

user.setName(name);

ModelAndView modelAndView = new ModelAndView("user/list");

List<User> userList = userService.selectList(user);

比赛项目controller: 

/**

* 比赛项目controller

*/

@Controller

@RequestMapping("/project")

public class ProjectController {

@Autowired

private ProjectUserSerivce projectUserSerivce;

@InitBinder

protected void initBinder(WebDataBinder binder) {

SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");

binder.registerCustomEditor(Date.class, new CustomDateEditor(dateFormat, true));

@Autowired

}else{

//表示管理员

Admin adminUser = adminService.checkPassword(name, password);

if (adminUser != null) {

//成功后保存账号session全局保存

ModelAndView modelAndView = new ModelAndView("redirect:/");

request.getSession().setAttribute("adminUser", adminUser);

request.getSession().setAttribute("name",adminUser.getName());

return modelAndView;

}else{

ModelAndView modelAndView = new ModelAndView("adminUser/login");

if(StringUtils.isEmpty(password)){

return AjaxResult.errorInstance("请填写密码");

if(!password.equals(rePassword)){

return AjaxResult.errorInstance("两次密码不一致");

//根据管理员的id来修改当前的账户密码

Admin admin = new Admin();

admin.setId(id);

admin = adminService.selectOne(admin);//以对象来查询

if(!admin.getPassword().equals(oldPassword)){

return AjaxResult.errorInstance("旧密码错误");

//修改密码并提交

/**

* 账号的登出

* @param

* @param

* @return

*/

@RequestMapping(value = "logout.do")

public ModelAndView logout(HttpServletRequest request, HttpServletResponse response) {

//销毁账户数据

request.getSession().invalidate();

//表示管理员

Admin adminUser = adminService.checkPassword(name, password);

if (adminUser != null) {

//成功后保存账号session全局保存

ModelAndView modelAndView = new ModelAndView("redirect:/");

request.getSession().setAttribute("adminUser", adminUser);

request.getSession().setAttribute("name",adminUser.getName());

return modelAndView;

}else{

ModelAndView modelAndView = new ModelAndView("adminUser/login");

modelAndView.addObject("message", "账号密码错误");

if (CommonUtils.isEmpty(user.getPassword()) ){

return AjaxResult.errorInstance("请填写密码");

if (CommonUtils.isEmpty(user.getPassword()) ){

return AjaxResult.errorInstance("请填写队伍");

User byMobile = userService.findByMobile(user.getPhone());

if(byMobile!=null){

return AjaxResult.errorInstance("该手机号已存在");

if(userService.insert(user)<=0){

return AjaxResult.errorInstance("添加运动员失败");

return AjaxResult.successInstance("添加运动员成功");

/**

UserScore userScore = new UserScore();

userScore.setUserId(id);

List<Project> projectList = userScoreService.selectProject(userScore);

modelAndView.addObject("projectList", projectList);

return modelAndView;

/**

* 转到密码修改页面

* @param resp

* @param req

* @return

*/

* @param response

* @return

*/

@RequestMapping("/showscore.do")

public ModelAndView showscore(HttpServletRequest request,HttpServletResponse response)

ModelAndView modelAndView = new ModelAndView("/project/score");

String name=request.getParameter("project");

Project project = new Project();

project.setName(name);

project=projectService.selectOne(project);

List<User> userList=projectUserSerivce.selectSecondListByFirstId(project.getId());

modelAndView.addObject("userList",userList);

savePathFile.mkdir();

String filename = new Date().getTime()+"."+suffix;

try {

//将文件保存至指定目录

photo.transferTo(new File(savePath+filename));

}catch (Exception e) {

// TODO Auto-generated catch block

ret.put("type", "error");

ret.put("msg", "保存文件异常！");

e.printStackTrace();

return ret;

ret.put("type", "success");

ret.put("msg", "图片上传成功！");

*/

@RequestMapping(value = "/addscore.do")

public ModelAndView addscore(Long projectId, Long userId, HttpServletRequest request) {

User user = new User();

user.setId(userId);

user = userService.selectOne(user);

ModelAndView modelAndView = new ModelAndView("/score/addscore");

modelAndView.addObject("user", user);

modelAndView.addObject("projectId", projectId);

return modelAndView;

/**

* 提交用户的评分

* @param id

return modelAndView;

/**

* 裁判员列表

* @return

*/

@GetMapping("/edit.do")

public ModelAndView edit(@RequestParam(name="id")Long id) {

ModelAndView modelAndView = new ModelAndView();

modelAndView.setViewName("/adminUser/edit");

Admin admin = adminService.selectOne(id);

modelAndView.addObject("admin",admin);

return modelAndView;

/**

* @param request

* @param response

* @return

*/

@RequestMapping(value = "/addScoreSubmit.do")

public @ResponseBody AjaxResult addScoreSubmit(Long projectId, Long adminId, Long id, HttpServletRequest request,

HttpServletResponse response) {

// 检查admin

UserScore userScore = new UserScore();

try {

Long score = (long) Integer.parseInt(request.getParameter("score"));

userService.insert(user);

ModelAndView modelAndView = new ModelAndView("registerSuccess");

return modelAndView;

@RequestMapping(value = "/message.do")

public ModelAndView message() {

ModelAndView modelAndView = new ModelAndView("Message");

return modelAndView;

/**

* 添加一名成员成绩

*/

@RequestMapping(value = "/addscore.do")