基于javaweb的SSM篮球队球员管理系统(java+ssm+jsp+jquery+mysql)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

480023502402

490023502402

500023502402

510023502402

520023502402

530023502402

540023502402

基于javaweb的SSM篮球队球员管理系统(java+ssm+jsp+jquery+mysql)

项目介绍

本项目分为管理员与用户两种角色; 管理员角色包含以下功能: 管理员登录,添加管理员,修改密码,球队管理,球员管理,球员数据管理,查看球迷信息等功能。

用户角色包含以下功能: 用户登录与注册,修改个人信息,查看球队,球员查看,球员数据查看等功能。

环境需要

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

技术栈

  1. 后端:Spring+SpringMVC+Mbytes 2. 前端:JSP+css+javascript+jQuery

使用说明

  1. 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven; 若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中db.properties配置文件中的数据库配置改为自己的配置; 4. 运行项目,在浏览器中输入localhost:8080/

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
	qiuyuan.setName(name);
List<Qiuyuan> qiuyuanList=qiuyuanService.queryQiuyuanList(qiuyuan);
if(qiuyuanList!=null && qiuyuanList.size()>0){
for (Qiuyuan qiuyuan2 : qiuyuanList) {
qiuyuan2.setQiudui(qiuduiService.queryQiuduiById(qiuyuan2.getQd()));
}
}
request.setAttribute("qiuyuanList", qiuyuanList);
return "/admin/qiuyuan/qiuyuan_list.jsp";
}


@RequestMapping(value="/toqiuyuanAdd")
public String toqiuyuanAdd(HttpServletRequest request) throws Exception
{
List qiuduiList=qiuduiService.queryQiuduiList(new Qiudui());
request.setAttribute("qiuduiList", qiuduiList);
return "/admin/qiuyuan/qiuyuan_add.jsp";
}


@RequestMapping(value="/qiuyuanAdd")
public String qiuyuanAdd(Qiuyuan qiuyuan,HttpServletRequest request) throws Exception
{
qiuyuanService.insertQiuyuan(qiuyuan);
request.setAttribute("message","操作成功");
request.setAttribute("path","qiuyuanList.action");
return "common/succeed.jsp";
}
@RequestMapping(value="/qiuyuanDel")
public String qiuyuanDel(HttpServletRequest request) throws Exception
{
int id = Integer.parseInt(request.getParameter("id"));

qiuyuanService.deleteQiuyuan(id);
request.setAttribute("message","操作成功");
request.setAttribute("path","qiuyuanList.action");

return "common/succeed.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
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
@RequestMapping(value="/toqiuyuandataAdd")
public String toqiuyuandataAdd(HttpServletRequest request) throws Exception
{
Qiuyuan qiuyuan = new Qiuyuan();
List<Qiuyuan> qiuyuanList=qiuyuanService.queryQiuyuanList(qiuyuan);
request.setAttribute("qiuyuanList", qiuyuanList);
return "/admin/qiuyuandata/qiuyuandata_add.jsp";
}


@RequestMapping(value="/qiuyuandataAdd")
public String qiuyuandataAdd(Qiuyuandata qiuyuandata,HttpServletRequest request) throws Exception
{
qiuyuandataService.insertQiuyuandata(qiuyuandata);
request.setAttribute("message","操作成功");
request.setAttribute("path","qiuyuandataList.action");
return "common/succeed.jsp";
}
@RequestMapping(value="/qiuyuandataDel")
public String qiuyuandataDel(HttpServletRequest request) throws Exception
{
int id = Integer.parseInt(request.getParameter("id"));

qiuyuandataService.deleteQiuyuandata(id);
request.setAttribute("message","操作成功");
request.setAttribute("path","qiuyuandataList.action");

return "common/succeed.jsp";
}

@RequestMapping(value="/qiuyuandataEditPre")
public String qiuyuandataEditPre(HttpServletRequest request) throws Exception
{
int id = Integer.parseInt(request.getParameter("id"));
Qiuyuandata qiuyuandata=qiuyuandataService.queryQiuyuandataById(id);
request.setAttribute("qiuyuandata", qiuyuandata);
Qiuyuan qiuyuan = new Qiuyuan();
List<Qiuyuan> qiuyuanList=qiuyuanService.queryQiuyuanList(qiuyuan);
request.setAttribute("qiuyuanList", qiuyuanList);
return "/admin/qiuyuandata/qiuyuandata_edit.jsp";
}

@RequestMapping(value="/qiuyuandataEdit")
public String qiuyuandataEdit(Qiuyuandata qiuyuandata,HttpServletRequest request) throws Exception
{
qiuyuandataService.updateQiuyuandata(qiuyuandata);
request.setAttribute("message","操作成功");
request.setAttribute("path","qiuyuandataList.action");
return "common/succeed.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
34
35
36
37
38
39
40
41
42


@Service
public class loginService
{
@Autowired
private TAdminService tAdminService;
@Autowired
private UserinfoService userinfoService;
public String login(String userName,String userPw,int userType) throws Exception
{
System.out.println("userType"+userType);
try
{
Thread.sleep(700);
} catch (InterruptedException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}

String result="no";

if(userType==0){
TAdmin admin = new TAdmin();
admin.setUserName(userName);
admin.setUserPw(userPw);

List adminList=tAdminService.queryTAdminList(admin);
if(adminList.size()==0)
{
result="no";
}
else
{
WebContext ctx = WebContextFactory.get();
HttpSession session=ctx.getSession();
TAdmin adminUser=(TAdmin)adminList.get(0);
session.setAttribute("userType", "0");
session.setAttribute("admin", adminUser);
result="yes";
}
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

@RequestMapping(value="/qiuyuanEdit")
public String qiuyuanEdit(Qiuyuan qiuyuan,HttpServletRequest request) throws Exception
{
qiuyuanService.updateQiuyuan(qiuyuan);
request.setAttribute("message","操作成功");
request.setAttribute("path","qiuyuanList.action");
return "common/succeed.jsp";
}




}
package com.service;




@Service
public class loginService
{
@Autowired
private TAdminService tAdminService;
@Autowired
private UserinfoService userinfoService;
public String login(String userName,String userPw,int userType) throws Exception
{
System.out.println("userType"+userType);
try
{
Thread.sleep(700);
} catch (InterruptedException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}

String result="no";

if(userType==0){
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
		List qiuduiList=qiuduiService.queryQiuduiList(qiudui);
request.setAttribute("qiuduiList", qiuduiList);
return "/admin/qiudui/qiudui_list.jsp";
}

@RequestMapping(value="/qiuduiAdd")
public String qiuduiAdd(Qiudui qiudui,HttpServletRequest request) throws Exception
{
qiuduiService.insertQiudui(qiudui);
request.setAttribute("message","操作成功");
request.setAttribute("path","qiuduiList.action");
return "common/succeed.jsp";
}
@RequestMapping(value="/qiuduiDel")
public String qiuduiDel(HttpServletRequest request) throws Exception
{
int id = Integer.parseInt(request.getParameter("id"));

qiuduiService.deleteQiudui(id);
request.setAttribute("message","操作成功");
request.setAttribute("path","qiuduiList.action");

return "common/succeed.jsp";
}

@RequestMapping(value="/qiuduiEditPre")
public String qiuduiEditPre(HttpServletRequest request) throws Exception
{
int id = Integer.parseInt(request.getParameter("id"));
Qiudui qiudui=qiuduiService.queryQiuduiById(id);
request.setAttribute("qiudui", qiudui);
return "/admin/qiudui/qiudui_edit.jsp";
}

@RequestMapping(value="/qiuduiEdit")
public String qiuduiEdit(Qiudui qiudui,HttpServletRequest request) throws Exception
{
qiuduiService.updateQiudui(qiudui);
request.setAttribute("message","操作成功");
request.setAttribute("path","qiuduiList.action");
return "common/succeed.jsp";
}
}
package com.controller;
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
45
46
47
48
49
50


@Autowired
private QiuyuanService qiuyuanService;
@Autowired
private QiuduiService qiuduiService;

@RequestMapping(value="/qiuyuanList")
public String qiuyuanList(HttpServletRequest request) throws Exception
{

String name = request.getParameter("name");
Qiuyuan qiuyuan = new Qiuyuan();
qiuyuan.setName(name);
List<Qiuyuan> qiuyuanList=qiuyuanService.queryQiuyuanList(qiuyuan);
if(qiuyuanList!=null && qiuyuanList.size()>0){
for (Qiuyuan qiuyuan2 : qiuyuanList) {
qiuyuan2.setQiudui(qiuduiService.queryQiuduiById(qiuyuan2.getQd()));
}
}
request.setAttribute("qiuyuanList", qiuyuanList);
return "/admin/qiuyuan/qiuyuan_list.jsp";
}


@RequestMapping(value="/toqiuyuanAdd")
public String toqiuyuanAdd(HttpServletRequest request) throws Exception
{
List qiuduiList=qiuduiService.queryQiuduiList(new Qiudui());
request.setAttribute("qiuduiList", qiuduiList);
return "/admin/qiuyuan/qiuyuan_add.jsp";
}


@RequestMapping(value="/qiuyuanAdd")
public String qiuyuanAdd(Qiuyuan qiuyuan,HttpServletRequest request) throws Exception
{
qiuyuanService.insertQiuyuan(qiuyuan);
request.setAttribute("message","操作成功");
request.setAttribute("path","qiuyuanList.action");
return "common/succeed.jsp";
}
@RequestMapping(value="/qiuyuanDel")
public String qiuyuanDel(HttpServletRequest request) throws Exception
{
int id = Integer.parseInt(request.getParameter("id"));

qiuyuanService.deleteQiuyuan(id);
request.setAttribute("message","操作成功");
request.setAttribute("path","qiuyuanList.action");


项目链接:
https://javayms.github.io?id=591122532008200rq
https://javayms.pages.dev?id=591122532008200rq