基于javaweb+mysql的jsp+servlet活动管理系统(java+jsp+bootstrap+servlet+mysql)

基于javaweb+mysql的jsp+servlet活动管理系统(java+jsp+bootstrap+servlet+mysql)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

基于javaweb+mysql的JSP+Servlet活动管理系统(java+jsp+bootstrap+servlet+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项目：否；

技术栈

JSP+CSS+jQuery+bootstrap+mysql+servlet

使用说明

1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven; 若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行； 3. 将项目中src/utils/DBUtil.java配置文件中的数据库配置改为自己的配置; 4. 运行项目，输入localhost:8080/jsp_huodong_fabusys/ 登录 注：tomcat中配置项目路径必须为jsp_huodong_fabusys，否则会有异常； 用户账号/密码：user/123456 管理员账号/密码：admin/admin

@ResponseBody

@RequestMapping("/updateUserInfo")

public String updateUserInfo(Integer id,String account,Integer sex,Integer age,String name,String pwd,String tel,String address){

userService.updateUserInfo(id,account,sex,age,name,pwd,tel,address);

return "true";

系统管理控制层： 

@Controller

@RequestMapping("/sys")

public class SysController {

@Resource

private IUserService userService;

session.setAttribute("findTeachList",findUserList);

return "sys/teachTable";

@RequestMapping("/apparatusTable")

public String apparatusTable(HttpSession session){

List<Map<String, Object>> findUserList=userService.apparatusTable();

session.setAttribute("findApparatusList",findUserList);

return "sys/apparatusTable";

@RequestMapping("/exit")

public String exit(HttpSession session){

session.invalidate();

admin=userService.adminLogin(admin.getName(),admin.getPwd());

if(admin!=null){

session.setAttribute("lastLoginTime", admin.getLastlogintime());

session.setAttribute("account", "123");

userService.setTime(df.format(new Date()));

return "true";

}else{

return "false";

@RequestMapping("/ForwardAdmin")

public String loginForward(HttpSession session){

List<Map<String, Object>> countUserList=userService.countUser();

public String userTable(HttpSession session){

List<Map<String, Object>> findUserList=userService.findUser();

session.setAttribute("findUserList",findUserList);

return "sys/userTable";

@RequestMapping("/teachTable")

public String teachTable(HttpSession session){

List<Map<String, Object>> findUserList=userService.teachTable();

session.setAttribute("findTeachList",findUserList);

return "sys/teachTable";

@RequestMapping("/apparatusTable")

public String apparatusTable(HttpSession session){

List<Map<String, Object>> findUserList=userService.apparatusTable();

String account=(String) session.getAttribute("account");

List<Map<String,Object>> list = userService.findUserByAccount(account);

session.setAttribute("userInfo", JSON.toJSON(list));

return "user/index";

@RequestMapping("/classTable")

public String classTable(HttpSession session){

List<Map<String,Object>> list = userService.findClass();

session.setAttribute("classInfo", JSON.toJSON(list));

return "user/classTable";

@RequestMapping("/teachList")

return "true";

else{

return "false";

@RequestMapping("/Forward")

public String loginForward(){

return "user/index";

@RequestMapping("/exit")

public String exit(HttpSession session){

session.invalidate();

return "login";

list.add(account);

list.add(sex);

list.add(age);

list.add(name);

list.add(pwd);

list.add(tel);

list.add(address);

session.setAttribute("upList", list);

return "sys/upUser";

@RequestMapping("/upTeach")

public String upTeach(Integer id,String tname,Integer cid,String ttel,String taddress,HttpSession session){

List list=new ArrayList();

list.add(id);

@RequestMapping("/classTable")

public String classTable(HttpSession session){

List<Map<String,Object>> list = userService.findClass();

session.setAttribute("classInfo", JSON.toJSON(list));

return "user/classTable";

@RequestMapping("/teachList")

public String teachList(HttpSession session){

return "user/teachList";

@ResponseBody

@RequestMapping("/selectTeach")

session.setAttribute("countUser",countUserList);

List<Map<String, Object>> countTeachList=userService.countTeach();

session.setAttribute("countTeach",countTeachList);

List<Map<String, Object>> countApparatusList=userService.countApparatus();

session.setAttribute("countApparatus",countApparatusList);

return "sys/main";

@RequestMapping("/userTable")

public String userTable(HttpSession session){

List<Map<String, Object>> findUserList=userService.findUser();

session.setAttribute("findUserList",findUserList);

return "sys/userTable";

@RequestMapping("/teachTable")

public String teachTable(HttpSession session){

session.invalidate();

return "login";

@RequestMapping("/myInfo")

public String myInfo(HttpSession session){

String account=(String) session.getAttribute("account");

List<Map<String,Object>> list = userService.findUserByAccount(account);

session.setAttribute("userInfo", JSON.toJSON(list));

return "user/index";

@RequestMapping("/classTable")

public String classTable(HttpSession session){

List<Map<String,Object>> list = userService.findClass();

session.setAttribute("classInfo", JSON.toJSON(list));

@Resource

private IUserService userService;

SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

@ResponseBody

@RequestMapping("/loginAdmin")

public String toIndex(Admin	admin,HttpSession session){

admin=userService.adminLogin(admin.getName(),admin.getPwd());

if(admin!=null){

session.setAttribute("lastLoginTime", admin.getLastlogintime());

session.setAttribute("account", "123");

return "sys/upTeach";

@ResponseBody

@RequestMapping("/registerUser")

public String registerUser(User user){

List<User> id=userService.findAccount(user.getAccount());

if(id.size()!=0){

return "false";

userService.registerUser(user);

return "true";

@RequestMapping("/addUser")

public String addUser(){

return "sys/addUser";

@RequestMapping("/addTeach")

session.setAttribute("userInfo", JSON.toJSON(list));

return "user/index";

@RequestMapping("/classTable")

public String classTable(HttpSession session){

List<Map<String,Object>> list = userService.findClass();

session.setAttribute("classInfo", JSON.toJSON(list));

return "user/classTable";

@RequestMapping("/teachList")

public String teachList(HttpSession session){

return "user/teachList";

@ResponseBody

@RequestMapping("/selectTeach")

public String selectTeach(HttpSession session,Integer id){

userService.delApp(id);

return "true";

@RequestMapping("/upUser")

public String upUser(Integer id,String account,Integer sex,Integer age,String name,String pwd,String tel,String address,HttpSession session){

List list=new ArrayList();

list.add(id);

list.add(account);

list.add(sex);

list.add(age);

list.add(name);

list.add(pwd);

public String toIndex(User user,HttpSession session){

String account=user.getAccount();

user=userService.userLogin(user.getAccount(),user.getPwd());

if(user!=null){

List<Map<String,Object>> list = userService.findUserByAccount(account);

session.setAttribute("userInfo", JSON.toJSON(list));

session.setAttribute("account", account);

return "true";

else{

return "false";

@RequestMapping("/Forward")

@RequestMapping("/user")

public class UserController {

@Resource

private IUserService userService;

@ResponseBody

@RequestMapping("/login")

public String toIndex(User user,HttpSession session){

String account=user.getAccount();

user=userService.userLogin(user.getAccount(),user.getPwd());

if(user!=null){

List<Map<String,Object>> list = userService.findUserByAccount(account);

session.setAttribute("userInfo", JSON.toJSON(list));

public class UserController {

@Resource

private IUserService userService;

@ResponseBody

@RequestMapping("/login")

public String toIndex(User user,HttpSession session){

String account=user.getAccount();

user=userService.userLogin(user.getAccount(),user.getPwd());

if(user!=null){

List<Map<String,Object>> list = userService.findUserByAccount(account);

public List<User> getSex(){

List<User> list=userService.getSex();

return list;

@ResponseBody

@RequestMapping("/delUser")

public String delUser(Integer id){

userService.delUser(id);

return "true";

@ResponseBody

@RequestMapping("/delTeach")

public String delTeach(Integer id){

userService.delTeach(id);

return "true";