Java源码社

基于javaweb的JSP+Servlet田径运动会管理系统(java+mysql+jsp)

更新于

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

122123220309

132123220309

152123220309

162123220309

172123220309

基于javaweb的JSP+Servlet田径运动会管理系统(java+mysql+jsp)

管理员：运动员、报名信息、赛事、检录信息等管理

用户：报名参赛

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
2024001111	123456——管理员
2024006464	123456
2024006465	123456
2024006466	123456
2024006467	123456
2024006862	123456
2024007462	123456
2024016465	123456
2024006452	123456
2024006472	123456
2024006492	123456
2024006402	123456
2024006450	123456
2024006162	123456
2024006262	123456
2024034462	123456
2024005462	123456
2024003462	123456
2024008462	123456
2024009462	123456
2024016462	123456
2024026462	123456
2024036462	123456
2024046462	123456
2024056462	123456
2024066462	123456
2024006468	123456
2024006469	123456

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
        super.doGet(req, resp);
    }
}



/**
 * @Description:
 */
@WebServlet("/addCompetition")
public class AddCompetition extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        super.doPost(req, resp);
    }

    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        String name = request.getParameter("name");
        String type = request.getParameter("type");
        String proType = request.getParameter("proType");
        String rules = request.getParameter("rules");
        CompetitionsDao dao = new CompetitionsDao();
        boolean b = dao.insert(name,type,proType,rules);
        if(b){
            response.sendRedirect("/home?admin=1");
            System.out.println("成功");
        }else {
            response.sendRedirect("/home?admin=1");
            System.out.println("失败");
        }
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35

/**
 * @Description:
 */
@WebServlet("/logout")
public class LogoutServlet extends HttpServlet {

    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        String sno = ValidToken.validToken(this, (String) request.getSession().getAttribute("token"));
        if(sno == null){
            response.sendRedirect("http://localhost:8080/login");
        }
        ServletContext context = this.getServletContext();
        List<LoginObj> list = (List) context.getAttribute("loginUser");
        HttpSession session = request.getSession();
        session.removeAttribute("loginError1");
        session.removeAttribute("loginError2");
        for(int i=0;i<list.size();i++){
            if(list.get(i).getSno().equals(sno)){
                list.remove(i);
            }
        }
        request.getRequestDispatcher("/login.jsp").forward(request,response);
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        super.doGet(req, resp);
    }
}



1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
}



/**
 * @Description:
 */
@WebServlet("/allCheckIn")
public class CheckInListServlet extends HttpServlet {

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        super.doGet(req, resp);
    }

    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        String sno = ValidToken.validToken(this, (String) request.getSession().getAttribute("token"));
        if(sno == null){
            response.sendRedirect("http://localhost:8080/login");
        }
        CheckInService service = new CheckInService();
        List<CheckInsDto> list = service.getCheckInList();
        HttpSession session = request.getSession();
        session.setAttribute("checkIns",list);
        response.sendRedirect("/checkIns.jsp");
    }
}


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33

/**
 * @Description:
 */
@WebServlet("/playerForCom")
public class PlayerForComServlet extends HttpServlet {

    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        HttpSession session = request.getSession();
        String sno = ValidToken.validToken(this, (String) request.getSession().getAttribute("token"));
        if(sno == null){
            response.sendRedirect("/login");
        }

        int id = Integer.parseInt(request.getParameter("id"));
        CompetitionsDao dao = new CompetitionsDao();
        Competition competition = dao.getCompetition(id);
        GroupComService groupComService = new GroupComService();
        List<CheckInsDto> players = groupComService.getPlayerByComId(id);
        session.setAttribute("competition",competition);
        session.setAttribute("players",players);
        response.sendRedirect("/playerForCom.jsp");
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        super.doGet(req, resp);
    }
}


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
    super.doGet(req, resp);
}

@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    request.setCharacterEncoding("utf-8");
    HttpSession session = request.getSession();

    String sno = ValidToken.validToken(this,
            (String) session.getAttribute("token"));
    if(sno == null){
        request.getRequestDispatcher("/login.jsp").forward(request,response);
    }
    int id = Integer.parseInt(request.getParameter("id"));
    CompetitionService service = new CompetitionService();
    Competition competition = service.getCompetitionById(id);
    session.setAttribute("competition",competition);
    PlayerDao playerDao = new PlayerDao();
    Player playerBySno = playerDao.findPlayerBySno(sno);
    if(playerBySno.getStopRight() == 1){
        response.sendRedirect("/detail?id="
                +competition.getId()
                +"&status="+ BasicConstant.ButtonEnum.BUTTON_ENUM_STOP_RIGHT.getCode()
                +"&alert=2");
    }
    long t1 = competition.getPlayingTime().getTime()-new Date().getTime();
    if(t1 <= 0){
        response.sendRedirect("/detail?id="
                +competition.getId()
                +"&status="+ BasicConstant.ButtonEnum.BUTTON_ENUM_ALL_END.getCode());
    }

    long t2 = competition.getSignTime().getTime()-new Date().getTime();
    if(t2 < 0){
        response.sendRedirect("/detail?id="
                +competition.getId()
                +"&status="+ BasicConstant.ButtonEnum.BUTTON_ENUM_SIGNUP_END.getCode());
    }
    GroupComService groupComService = new GroupComService();
    boolean b = groupComService.signUpCompetition(sno, id);
    if(b){
        response.sendRedirect("/detail?id="
                +competition.getId()
                +"&status="+ BasicConstant.ButtonEnum.BUTTON_ENUM_CANCEL_SIGNUP.getCode()
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
        if(b){
            response.sendRedirect("/detail?id="
                    +competition.getId()
                    +"&status="+ BasicConstant.ButtonEnum.BUTTON_ENUM_CANCEL_SIGNUP.getCode()
                    +"&alert=0");
        }
    }
}



/**
 * @Description:
 */
@WebServlet("/detail")
public class DetailServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        String sno = ValidToken.validToken(this, (String) request.getSession().getAttribute("token"));
        int id = Integer.parseInt(request.getParameter("id"));
        CompetitionService competitionService = new CompetitionService();
        Competition competition = competitionService.getCompetitionById(id);
        HttpSession session = request.getSession();
        DetailCompetitionDto dto = new DetailCompetitionDto();
        dto.setCompetitionName(competition.getCompetitionName())
                .setHost(competition.getHost())
                .setId(competition.getId())
                .setProType(competition.getProType())
                .setProTypeId(competition.getProTypeId())
                .setRules(competition.getRules())
                .setSessionsId(competition.getSessionsId())
                .setStatus(competition.getStatus());

项目链接：
https://javayms.github.io?id=112123220309201dw
https://javayms.pages.dev?id=112123220309201dw