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

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

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

基于javaweb+mysql的篮球队球员管理系统(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+javascriipt+jQuery

使用说明

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

用户管理控制层：

@Controller

public class UserinfoController

@Autowired

private UserinfoService userinfoService;

@RequestMapping(value=“/userinfoList”)

public String userinfoList(HttpServletRequest request) throws Exception

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”;

@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 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=“/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”;

球员管理控制层：

@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 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”;

@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”;

---