基于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(StringUtils.isEmpty(password)){
return AjaxResult.errorInstance("请填写密码");
if(!password.equals(rePassword)){
return AjaxResult.errorInstance("两次密码不一致");
// 根据管理员的id来修改当前的账户密码
User user = new User();
user.setId(id);
user = userService.selectOne(user);// 以对象来查询
if(!user.getPassword().equals(oldPassword)){
return AjaxResult.errorInstance("旧密码错误");
* @param resp
* @return
*/
@RequestMapping(value = "userManager.do", method = RequestMethod.GET)
public ModelAndView loginSubmit(HttpServletRequest req, HttpServletResponse resp) {
List<User> userList = userService.selectList();
req.setAttribute("userList", userList);
Map<String,Object> params=new HashMap<String,Object>();
PageInfo<User> pageInfo = userService.search(1, 20, params);
return new ModelAndView("user/list");
* @param userId
* @param request
* @return
*/
/**
* 显示用户页面的用户的当前的所有项目
* @param id
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/showScore.do")
* @param request
* @return
*/
/**
* 显示用户页面的用户的当前的所有项目
* @param id
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/showScore.do")
Admin admin = (Admin) request.getSession().getAttribute("adminUser");
adminScore.setAdminId(admin.getId());
List<AdminScore> AdminScoreList = adminScoreService.selectList(adminScore);
modelAndView.addObject("AdminScoreList", AdminScoreList);
return modelAndView;
/**
* 账号的登出
* @param
* @param
* @return
*/
@RequestMapping(value = "logout.do")
@RequestMapping(value = "logout.do")
public ModelAndView logout(HttpServletRequest request, HttpServletResponse response) {
//销毁账户数据
request.getSession().invalidate();
ModelAndView modelAndView = new ModelAndView("adminUser/login");
return modelAndView;
/**
* @param req
* @param resp
* @return
*/
@RequestMapping(value = "evaluate.do", method = RequestMethod.GET)
public ModelAndView evaluate(HttpServletRequest req, HttpServletResponse resp) {
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){
if(!byMobile.getId().equals(user.getId())){
return AjaxResult.errorInstance("该手机号已存在");
if( userService.editUser(user)<=0){
return AjaxResult.successInstance("编辑运动员信息成功");
/**
* 搜索运动员
* @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");
*/
@RequestMapping("delete.do")
public @ResponseBody AjaxResult deleted(Long id) {
if (id == 0) {
return AjaxResult.errorInstance("删除成员失败");
} else {
userService.delete(id);
return AjaxResult.successInstance("删除成功");
@RequestMapping(value = "/register.do", method = RequestMethod.GET)
public ModelAndView registerPage(User user) {
ModelAndView modelAndView = new ModelAndView("register");
return modelAndView;
public AjaxResult addSubmit(Project project)
if(CommonUtils.isEmpty(project.getName())){
return AjaxResult.errorInstance("请填写比赛项目名称");
if(CommonUtils.isEmpty(project.getDescription())){
return AjaxResult.errorInstance("请填写比赛描述");
if(CommonUtils.isEmpty(project.getLocation())){
return AjaxResult.errorInstance("请填写比赛地址");
if(CommonUtils.isEmpty(project.getCountry())){
return AjaxResult.errorInstance("请填写承办方");
if(project.getBegintime()==null){
* @param request
* @param response
* @return
*/
@RequestMapping("/showscore.do")
public ModelAndView showscore(HttpServletRequest request, HttpServletResponse response) {
ModelAndView modelAndView = new ModelAndView("/adminUser/listscore");
//需要projectid
UserScore userScore = new UserScore();
String name = request.getParameter("project");
Project project = new Project();
project.setName(name);
@RequestMapping(value="add.do",method=RequestMethod.POST)
public AjaxResult addSubmit(Project project)
if(CommonUtils.isEmpty(project.getName())){
return AjaxResult.errorInstance("请填写比赛项目名称");
if(CommonUtils.isEmpty(project.getDescription())){
return AjaxResult.errorInstance("请填写比赛描述");
if(CommonUtils.isEmpty(project.getLocation())){
return AjaxResult.errorInstance("请填写比赛地址");
if(CommonUtils.isEmpty(project.getCountry())){
return AjaxResult.errorInstance("请填写承办方");
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;
/**
* @return
*/
@RequestMapping(value="verify.do",method=RequestMethod.GET)
public ModelAndView verify()
* 密码修改提交
* @param resp
* @param req
* @return
*/
@ResponseBody
@RequestMapping("resetPassword.do")
public AjaxResult updatePasswordSubmit(
@RequestParam(name = "password") String password, Long id, HttpServletResponse resp,
HttpServletRequest req,@RequestParam(name = "oldPassword")String oldPassword,@RequestParam(name = "repassword")String rePassword) {
if(StringUtils.isEmpty(oldPassword)){
return AjaxResult.errorInstance("请填写旧密码");
* 密码修改提交
* @param resp
* @param req
* @return
*/
@RequestMapping("resetPassword.do")
public @ResponseBody AjaxResult updatePasswordSubmit( @RequestParam(name = "password") String password, Long id, HttpServletResponse resp,
HttpServletRequest req,@RequestParam(name = "oldPassword")String oldPassword,@RequestParam(name = "repassword")String rePassword) {
if(StringUtils.isEmpty(oldPassword)){
return AjaxResult.errorInstance("请填写旧密码");
if(StringUtils.isEmpty(rePassword)){
return AjaxResult.errorInstance("请填写确认密码");
if(StringUtils.isEmpty(password)){
return AjaxResult.errorInstance("请填写密码");
@RequestMapping("delete.do")
public @ResponseBody AjaxResult deleted(Long id) {
if (id == 0) {
return AjaxResult.errorInstance("删除成员失败");
} else {
userService.delete(id);
return AjaxResult.successInstance("删除成功");
@RequestMapping(value = "/register.do", method = RequestMethod.GET)
public ModelAndView registerPage(User user) {
ModelAndView modelAndView = new ModelAndView("register");
return modelAndView;
@RequestMapping(value = "/reg.do", method = RequestMethod.GET)
@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
private ProjectService projectService;
@RequestMapping("/list.do")
@Autowired
private UserService userService;
@RequestMapping(value = "list.do", method = RequestMethod.GET)
public ModelAndView list() {
return new ModelAndView("user/list");
/**
* show线上当前所有的成员
* @param req
* @param resp
* @return
*/
@RequestMapping(value = "userManager.do", method = RequestMethod.GET)