基于javaweb+mysql的ssm篮球队球员管理系统(java+ssm+jsp+jquery+mysql)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于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项目:否;
技术栈
- 后端:Spring+SpringMVC+Mbytes 2. 前端:JSP+css+javascript+jQuery
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven; 若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中db.properties配置文件中的数据库配置改为自己的配置; 4. 运行项目,在浏览器中输入localhost:8080/
request.setAttribute("path","qiuyuanList.action");
return "common/succeed.jsp";
}
}
@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)
@Controller
public class QiuyuanController
{
@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";
}
@Controller
public class QiuyuanController
{
@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
{
@Controller
public class AdminController {
@Autowired
private TAdminService tAdminService;
@RequestMapping(value="/adminAdd")
public String adminAdd(TAdmin admin,HttpServletRequest request) throws Exception
{
TAdmin query = new TAdmin();
query.setUserName(admin.getUserName());
List list = tAdminService.queryTAdminList(query);
if(list!=null && list.size()>0)
{
request.setAttribute("message","账户已存在");
request.setAttribute("path","admin/admin/adminAdd.jsp");
return "common/succeed.jsp";
}
else
{
tAdminService.insertTAdmin(admin);
request.setAttribute("message","操作成功");
request.setAttribute("path","adminManage.action");
return "common/succeed.jsp";
}
}
@RequestMapping(value="/adminManage")
public String adminManage(HttpServletRequest request)
{
List adminList;
try {
adminList = tAdminService.queryTAdminList(new TAdmin());
request.setAttribute("adminList", adminList);
} catch (Exception e) {
e.printStackTrace();
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";
}
}
if(userType==1){
Userinfo userinfo = new Userinfo();
userinfo.setUname(userName);
userinfo.setPwd(userPw);
List userList=userinfoService.queryUserinfoList(userinfo);
if(userList.size()==0)
{
result="no";
}
else
{
WebContext ctx = WebContextFactory.get();
HttpSession session=ctx.getSession();
Thread.sleep(700);
}
catch (InterruptedException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
WebContext ctx = WebContextFactory.get();
HttpSession session=ctx.getSession();
TAdmin admin=(TAdmin)session.getAttribute("admin");
admin.setUserPw(userPwNew);
tAdminService.updateTAdmin(admin);
session.setAttribute("admin", admin);
return "yes";
}
public String userLogout()
{
try
{
Thread.sleep(700);
}
catch (InterruptedException e)
{
e.printStackTrace();
}
WebContext ctx = WebContextFactory.get();
HttpSession session=ctx.getSession();
session.setAttribute("userType", null);
session.setAttribute("user", null);
return "yes";
}
}
@Controller
public class QiuduiController
{
@Autowired
private QiuduiService qiuduiService;
@RequestMapping(value="/qiuduiList")
public String qiuduiList(HttpServletRequest request) throws Exception
{
Qiudui qiudui = new Qiudui();
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"));
Userinfo userinfo = new Userinfo();
List userinfoList=userinfoService.queryUserinfoList(userinfo);
request.setAttribute("userinfoList", userinfoList);
return "/admin/userinfo/userinfo_list.jsp";
}
@RequestMapping(value="/userinfoAdd")
public String userinfoAdd(Userinfo userinfo,HttpServletRequest request) throws Exception
{
userinfoService.insertUserinfo(userinfo);
request.setAttribute("message","注册成功");
request.setAttribute("path","login.jsp");
return "common/succeed.jsp";
}
@RequestMapping(value="/userinfoDel")
public String userinfoDel(HttpServletRequest request) throws Exception
{
int id = Integer.parseInt(request.getParameter("id"));
String utype = request.getParameter("utype");
userinfoService.deleteUserinfo(id);
request.setAttribute("message","操作成功");
request.setAttribute("path","userinfoList.action?utype=" + utype);
return "common/succeed.jsp";
}
@RequestMapping(value="/userinfoEditPre")
public String userinfoEditPre(HttpServletRequest request) throws Exception
{
int id = Integer.parseInt(request.getParameter("id"));
Userinfo userinfo=userinfoService.queryUserinfoById(id);
request.setAttribute("userinfo", userinfo);
return "/admin/userinfo/userinfo_edit.jsp";
}
@RequestMapping(value="/userinfoView")
public String userinfoView(HttpServletRequest request) throws Exception
{
int id = Integer.parseInt(request.getParameter("id"));
Userinfo userinfo=userinfoService.queryUserinfoById(id);
request.setAttribute("userinfo", userinfo);
return "/admin/userinfo/userinfo_view.jsp";
}
@RequestMapping(value="/userinfoEdit")
public String userinfoEdit(Userinfo userinfo,HttpServletRequest request) throws Exception
{
userinfoService.updateUserinfo(userinfo);
request.setAttribute("message","操作成功");
request.setAttribute("path","userinfoList.action");
return "common/succeed.jsp";
public String qiuyuanEdit(Qiuyuan qiuyuan,HttpServletRequest request) throws Exception
{
qiuyuanService.updateQiuyuan(qiuyuan);
request.setAttribute("message","操作成功");
request.setAttribute("path","qiuyuanList.action");
return "common/succeed.jsp";
}
}
@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)
@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";
}
}
@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();
}
@Controller
public class QiuduiController
{
@Autowired
private QiuduiService qiuduiService;
@RequestMapping(value="/qiuduiList")
public String qiuduiList(HttpServletRequest request) throws Exception
{
Qiudui qiudui = new Qiudui();
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="/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";
}
@RequestMapping(value="/qiuyuanEditPre")
public String qiuyuanEditPre(HttpServletRequest request) throws Exception
{
int id = Integer.parseInt(request.getParameter("id"));
Qiuyuan qiuyuan=qiuyuanService.queryQiuyuanById(id);
request.setAttribute("qiuyuan", qiuyuan);
List qiuduiList=qiuduiService.queryQiuduiList(new Qiudui());
request.setAttribute("qiuduiList", qiuduiList);
return "/admin/qiuyuan/qiuyuan_edit.jsp";
}
@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";
}
}
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";
}
}
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";
}
}
@Controller
public class UserinfoController
{
@Autowired
private UserinfoService userinfoService;
request.setAttribute("message","操作成功");
request.setAttribute("path","userinfoList.action");
return "common/succeed.jsp";
}
@RequestMapping(value="/userinfoUpdate")
public String userinfoUpdate(Userinfo userinfo,HttpServletRequest request) throws Exception
{
userinfoService.updateUserinfo(userinfo);
request.getSession().setAttribute("user", userinfo);
request.setAttribute("message","操作成功");
request.setAttribute("path","admin/userinfo/userinfo_info.jsp");
return "common/succeed.jsp";
}
}
@Controller
public class QiuyuanController
{
@Autowired
private QiuyuanService qiuyuanService;
@Autowired
private QiuduiService qiuduiService;
{
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";
}
}
if(userType==1){
Userinfo userinfo = new Userinfo();
userinfo.setUname(userName);
userinfo.setPwd(userPw);
List userList=userinfoService.queryUserinfoList(userinfo);
if(userList.size()==0)
{
result="no";
}
else
{
WebContext ctx = WebContextFactory.get();
HttpSession session=ctx.getSession();
Userinfo uinfo=(Userinfo)userList.get(0);
session.setAttribute("userType", 1);
session.setAttribute("user", uinfo);
result="yes";
}
}
return result;
}
public String adminPwEdit(String userPwNew) throws Exception
{
System.out.println("DDDD");
try
{
for (Qiuyuandata qiuyuandata2 : qiuyuandataList) {
qiuyuandata2.setQiuyuan(qiuyuanService.queryQiuyuanById(qiuyuandata2.getQy()));
}
}
request.setAttribute("qiuyuandataList", qiuyuandataList);
return "/admin/qiuyuandata/qiuyuandata_list.jsp";
}
@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();
{
e.printStackTrace();
}
WebContext ctx = WebContextFactory.get();
HttpSession session=ctx.getSession();
session.setAttribute("userType", null);
session.setAttribute("user", null);
return "yes";
}
}
@Controller
public class QiuduiController
{
@Autowired
private QiuduiService qiuduiService;
@RequestMapping(value="/qiuduiList")
public String qiuduiList(HttpServletRequest request) throws Exception
{
Qiudui qiudui = new Qiudui();
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
{