基于javaweb+mysql的ssm汽车俱乐部管理系统(java+ssm+jsp+mysql)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb的SSM汽车俱乐部管理系统(java+ssm+jsp+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版本;
技术栈
- 后端:Spring+SpringMVC+Mybatis2. 前端:HTML+CSS+JavaScript+jsp
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件;2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven;若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行;3. 将项目中application.yml配置文件中的数据库配置改为自己的配置;4. 运行项目,输入localhost:8080/ 登录
//
//
@Controller
public class MemberController
{
@Autowired
private MemberService memberService;
@Autowired
private EmployeeService employeeService;
@RequestMapping({ "/aa" })
@ResponseBody
public String getIndex(final String index, final HttpSession session) {
System.out.println("index:" + index);
int index2 = Integer.valueOf(index);
if (index2 == 9) {
index2 = 0;
}
else {
index2 %= 2;
}
session.setAttribute("index", (Object)index2);
return "success";
@Controller
public class MemberController
{
@Autowired
private MemberService memberService;
@Autowired
private EmployeeService employeeService;
@RequestMapping({ "/aa" })
@ResponseBody
public String getIndex(final String index, final HttpSession session) {
System.out.println("index:" + index);
int index2 = Integer.valueOf(index);
if (index2 == 9) {
index2 = 0;
}
else {
index2 %= 2;
}
session.setAttribute("index", (Object)index2);
return "success";
}
@RequestMapping({ "/train" })
public String getTrain(final Model model, final HttpSession session) {
final Employee employee = (Employee)session.getAttribute("employee");
final String employeeId = employee.getEmployeeId();
public String report(final Model model) {
System.out.println("getAllService");
final List<AllService> allServices = this.employeeService.getAllService();
model.addAttribute("allServices", (Object)allServices);
return "report";
}
@RequestMapping({ "/toServiceExcel" })
@ResponseBody
public String toExcel() {
final AllServiceExcel serviceExcel = new AllServiceExcel("allServices.xls", "services");
serviceExcel.setColValue(this.employeeService.getAllService());
ExcelUtils.makeExcel(serviceExcel);
return "success";
}
}
//
//
//
@Controller
}
@RequestMapping({ "/remind/delete/{id}" })
@ResponseBody
public String deleteRemind(@PathVariable("id") final String remindId) {
final int i = this.employeeService.deleteRemind(remindId);
if (i != -1) {
System.out.println("successfully delete!!!");
}
return "success";
}
@RequestMapping({ "remind/modify" })
@ResponseBody
public String modifyRemind(final Remind remind) {
System.out.println(remind);
final int i = this.employeeService.modifyRemind(remind);
if (i != -1) {
System.out.println("successfully modify!!!");
}
return "success";
}
@RequestMapping({ "/report" })
public String report(final Model model) {
System.out.println("getAllService");
final List<AllService> allServices = this.employeeService.getAllService();
model.addAttribute("allServices", (Object)allServices);
return "report";
}
@RequestMapping({ "/toServiceExcel" })
@ResponseBody
public String toExcel() {
final AllServiceExcel serviceExcel = new AllServiceExcel("allServices.xls", "services");
serviceExcel.setColValue(this.employeeService.getAllService());
ExcelUtils.makeExcel(serviceExcel);
return "success";
}
}
public String addRescue(final Rescue rescue) {
System.out.println(rescue);
final int i = this.memberService.addRescue(rescue);
if (i != -1) {
System.out.println("success add rescue");
}
return "success";
}
@RequestMapping({ "/rescue/delete/{id}" })
@ResponseBody
public String deleteRescue(@PathVariable("id") final String rescueId) {
final int i = this.memberService.deleteRescue(rescueId);
if (i != -1) {
System.out.println("success");
}
return "success";
}
@RequestMapping({ "/rescue/modify" })
@ResponseBody
public String modifyRescue(final Rescue rescue) {
final int i = this.memberService.modifyRescue(rescue);
if (i != -1) {
System.out.println("success");
}
return "success";
}
@RequestMapping({ "/member" })
public String getAllMember(final Model model) {
final List<Member> memberList = this.memberService.getAllMember();
model.addAttribute("memberList", (Object)memberList);
return "member";
}
@RequestMapping({ "/member/{id}" })
@ResponseBody
public Member getMemberById(@PathVariable("id") final String memberId) {
final Member memberById = this.memberService.getMemberById(memberId);
System.out.println(memberById);
return memberById;
}
@RequestMapping({ "/member/add" })
@ResponseBody
public String addMember(final Member member) {
System.out.println(member);
final int i = this.memberService.addMember(member);
@RequestMapping({ "/logout" })
public String logout(final HttpSession session) {
final Employee employee = null;
session.setAttribute("employee", (Object)employee);
session.setMaxInactiveInterval(0);
return "login";
}
@RequestMapping({ "/index" })
public String index(final HttpServletRequest request, final HttpSession session, final Model model) {
Employee employee = (Employee)session.getAttribute("employee");
if (employee == null) {
final String username = request.getParameter("username");
final String password = request.getParameter("password");
if (username != null && !username.equals("") && password != null && !password.equals("")) {
employee = this.employeeService.login(username, password);
}
if (employee == null) {
System.out.println("\u6ca1\u6709\u5458\u5de5\uff0c\u8fd4\u56de\u767b\u5f55\u754c\u9762");
return "login";
}
session.setAttribute("employee", (Object)employee);
}
final List<TrainTmp> trainList = this.memberService.getAllTrain();
final List<Rescue> rescueList = this.memberService.getAllRescue();
final List<Travel> travelList = this.memberService.getAllTravel();
model.addAttribute("trainList", (Object)trainList);
model.addAttribute("rescueList", (Object)rescueList);
model.addAttribute("travelList", (Object)travelList);
System.out.println("\u627e\u5230\u5458\u5de5\u4e86");
return "index";
}
@RequestMapping({ "/user/modify" })
@ResponseBody
public String modifyUser(final Employee employee, final HttpSession session) {
System.out.println(employee);
final int i = this.employeeService.modifyEmployee(employee);
session.setAttribute("employee", (Object)employee);
if (i != -1) {
System.out.println("successfully modify!!!");
}
return "success";
}
@RequestMapping({ "/userInfo" })
public String getEmployee(final Model model, final HttpSession session) {
final Employee employee = (Employee)session.getAttribute("employee");
public class AdminInterceptor implements HandlerInterceptor
{
public boolean preHandle(final HttpServletRequest httpServletRequest, final HttpServletResponse httpServletResponse, final Object o) throws Exception {
final HttpSession session = httpServletRequest.getSession();
final Employee employee = (Employee)session.getAttribute("employee");
if (!employee.getEmployeePower().equals("1")) {
System.out.println("!!!");
httpServletRequest.getRequestDispatcher("/login").forward((ServletRequest)httpServletRequest, (ServletResponse)httpServletResponse);
return false;
}
return true;
}
public void postHandle(final HttpServletRequest httpServletRequest, final HttpServletResponse httpServletResponse, final Object o, final ModelAndView modelAndView) throws Exception {
}
public void afterCompletion(final HttpServletRequest httpServletRequest, final HttpServletResponse httpServletResponse, final Object o, final Exception e) throws Exception {
}
}
//
//
//
public class AllInterceptor implements HandlerInterceptor
{
public boolean preHandle(final HttpServletRequest httpServletRequest, final HttpServletResponse httpServletResponse, final Object o) throws Exception {
}
@RequestMapping({ "/remind/delete/{id}" })
@ResponseBody
public String deleteRemind(@PathVariable("id") final String remindId) {
final int i = this.employeeService.deleteRemind(remindId);
if (i != -1) {
System.out.println("successfully delete!!!");
}
return "success";
}
@RequestMapping({ "remind/modify" })
@ResponseBody
public String modifyRemind(final Remind remind) {
System.out.println(remind);
final int i = this.employeeService.modifyRemind(remind);
if (i != -1) {
System.out.println("successfully modify!!!");
}
return "success";
}
@RequestMapping({ "/report" })
public String report(final Model model) {
System.out.println("getAllService");
final List<AllService> allServices = this.employeeService.getAllService();
model.addAttribute("allServices", (Object)allServices);
return "report";
}
@RequestMapping({ "/toServiceExcel" })
@ResponseBody
public String toExcel() {
final AllServiceExcel serviceExcel = new AllServiceExcel("allServices.xls", "services");
serviceExcel.setColValue(this.employeeService.getAllService());
ExcelUtils.makeExcel(serviceExcel);
return "success";
}
}
//
//
//
@RequestMapping({ "/travel/add" })
@ResponseBody
public String addTravel(final Travel travel) {
System.out.println(travel);
final int i = this.memberService.addTravel(travel);
if (i != -1) {
System.out.println("success");
}
return "success";
}
@RequestMapping({ "/travel/delete/{id}" })
@ResponseBody
public String modifyTravel(@PathVariable("id") final String travelId) {
final int i = this.memberService.deleteTravel(travelId);
if (i != -1) {
System.out.println("success");
}
return "success";
}
@RequestMapping({ "/travel/modify" })
@ResponseBody
public String modifyTravel(final Travel travel) {
System.out.println(travel);
System.out.println("?????");
final int i = this.memberService.modifyTravel(travel);
if (i != -1) {
System.out.println("success");
}
return "success";
}
@RequestMapping({ "/rescue" })
public String getAllRescue(final Model model) {
final List<Rescue> rescueList = this.memberService.getAllRescue();
final List<Car> carList = this.memberService.getAllCar();
model.addAttribute("rescueList", (Object)rescueList);
model.addAttribute("carList", (Object)carList);
return "rescue";
}
@RequestMapping({ "/rescue/{id}" })
@ResponseBody
public Rescue getRescueByRescueId(@PathVariable("id") final String rescueId) {
System.out.println("rescueId:" + rescueId);
final Rescue rescueByRescueId = this.memberService.getRescueByRescueId(rescueId);
System.out.println(rescueByRescueId);
return rescueByRescueId;
}
@RequestMapping({ "/rescue/add" })
@ResponseBody
public String addRescue(final Rescue rescue) {
System.out.println(rescue);
final int i = this.memberService.addRescue(rescue);
if (i != -1) {
System.out.println("success add rescue");
}
return "success";
}
@RequestMapping({ "/rescue/delete/{id}" })
@ResponseBody
public String deleteRescue(@PathVariable("id") final String rescueId) {
final int i = this.memberService.deleteRescue(rescueId);
if (i != -1) {
System.out.println("success");
}
return "success";
}
@RequestMapping({ "/rescue/modify" })
@ResponseBody
public String modifyRescue(final Rescue rescue) {
final int i = this.memberService.modifyRescue(rescue);
if (i != -1) {
System.out.println("success");
}
return "success";
}
@RequestMapping({ "/member" })
public String getAllMember(final Model model) {
final List<Member> memberList = this.memberService.getAllMember();
model.addAttribute("memberList", (Object)memberList);
return "member";
}
@RequestMapping({ "/member/{id}" })
@ResponseBody
public Member getMemberById(@PathVariable("id") final String memberId) {
final Member memberById = this.memberService.getMemberById(memberId);
public String modifyTravel(final Travel travel) {
System.out.println(travel);
System.out.println("?????");
final int i = this.memberService.modifyTravel(travel);
if (i != -1) {
System.out.println("success");
}
return "success";
}
@RequestMapping({ "/rescue" })
public String getAllRescue(final Model model) {
final List<Rescue> rescueList = this.memberService.getAllRescue();
final List<Car> carList = this.memberService.getAllCar();
model.addAttribute("rescueList", (Object)rescueList);
model.addAttribute("carList", (Object)carList);
return "rescue";
}
@RequestMapping({ "/rescue/{id}" })
@ResponseBody
public Rescue getRescueByRescueId(@PathVariable("id") final String rescueId) {
System.out.println("rescueId:" + rescueId);
final Rescue rescueByRescueId = this.memberService.getRescueByRescueId(rescueId);
System.out.println(rescueByRescueId);
return rescueByRescueId;
}
@RequestMapping({ "/rescue/add" })
@ResponseBody
public String addRescue(final Rescue rescue) {
System.out.println(rescue);
final int i = this.memberService.addRescue(rescue);
if (i != -1) {
System.out.println("success add rescue");
}
return "success";
}
@RequestMapping({ "/rescue/delete/{id}" })
@ResponseBody
public String deleteRescue(@PathVariable("id") final String rescueId) {
final int i = this.memberService.deleteRescue(rescueId);
if (i != -1) {
System.out.println("success");
}
return "success";
@RequestMapping({ "/logout" })
public String logout(final HttpSession session) {
final Employee employee = null;
session.setAttribute("employee", (Object)employee);
session.setMaxInactiveInterval(0);
return "login";
}
@RequestMapping({ "/index" })
public String index(final HttpServletRequest request, final HttpSession session, final Model model) {
Employee employee = (Employee)session.getAttribute("employee");
if (employee == null) {
final String username = request.getParameter("username");
final String password = request.getParameter("password");
if (username != null && !username.equals("") && password != null && !password.equals("")) {
employee = this.employeeService.login(username, password);
}
if (employee == null) {
System.out.println("\u6ca1\u6709\u5458\u5de5\uff0c\u8fd4\u56de\u767b\u5f55\u754c\u9762");
return "login";
}
session.setAttribute("employee", (Object)employee);
}
final List<TrainTmp> trainList = this.memberService.getAllTrain();
final List<Rescue> rescueList = this.memberService.getAllRescue();
final List<Travel> travelList = this.memberService.getAllTravel();
model.addAttribute("trainList", (Object)trainList);
model.addAttribute("rescueList", (Object)rescueList);
model.addAttribute("travelList", (Object)travelList);
System.out.println("\u627e\u5230\u5458\u5de5\u4e86");
return "index";
}
@RequestMapping({ "/user/modify" })
@ResponseBody
public String modifyUser(final Employee employee, final HttpSession session) {
System.out.println(employee);
final int i = this.employeeService.modifyEmployee(employee);
session.setAttribute("employee", (Object)employee);
if (i != -1) {
System.out.println("successfully modify!!!");
}
return "success";
}
@RequestMapping({ "/userInfo" })
@RequestMapping({ "/car/change/{id}" })
@ResponseBody
public String carStatusChange(@PathVariable("id") final String carId) {
System.out.println(carId);
final int i = this.memberService.carStatusChange(carId);
if (i != -1) {
return "success";
}
System.out.println(i);
return "false";
}
}
//
//
//
public class AdminInterceptor implements HandlerInterceptor
{
public boolean preHandle(final HttpServletRequest httpServletRequest, final HttpServletResponse httpServletResponse, final Object o) throws Exception {
final HttpSession session = httpServletRequest.getSession();
final Employee employee = (Employee)session.getAttribute("employee");
if (!employee.getEmployeePower().equals("1")) {
System.out.println("!!!");
httpServletRequest.getRequestDispatcher("/login").forward((ServletRequest)httpServletRequest, (ServletResponse)httpServletResponse);
return false;
}
return true;
}
public void postHandle(final HttpServletRequest httpServletRequest, final HttpServletResponse httpServletResponse, final Object o, final ModelAndView modelAndView) throws Exception {
}
public void afterCompletion(final HttpServletRequest httpServletRequest, final HttpServletResponse httpServletResponse, final Object o, final Exception e) throws Exception {
}
}
//
//
//
@Controller
public class MemberController
{
@Autowired
private MemberService memberService;
@Autowired
private EmployeeService employeeService;
@RequestMapping({ "/aa" })
@ResponseBody
public String getIndex(final String index, final HttpSession session) {
System.out.println("index:" + index);
int index2 = Integer.valueOf(index);
if (index2 == 9) {
index2 = 0;
}
else {
index2 %= 2;
}
session.setAttribute("index", (Object)index2);
return "success";
}
@RequestMapping({ "/train" })
public String getTrain(final Model model, final HttpSession session) {
final Employee employee = (Employee)session.getAttribute("employee");
final String employeeId = employee.getEmployeeId();
final List<Remind> remindList = this.employeeService.getRemindByEmployeeId(employeeId);
model.addAttribute("remindList", (Object)remindList);
return "train";
}
@RequestMapping({ "/train/add" })
public String addTrain(final TrainTmp train) {
System.out.println(train);
final int i = this.memberService.addTrain(train);
if (i != -1) {
System.out.println("success");
}
return "success";
}
@RequestMapping({ "/remind/delete/{id}" })
@ResponseBody
public String deleteRemind(@PathVariable("id") final String remindId) {
final int i = this.employeeService.deleteRemind(remindId);
if (i != -1) {
System.out.println("successfully delete!!!");
}
return "success";
}
@RequestMapping({ "remind/modify" })
@ResponseBody
public String modifyRemind(final Remind remind) {
System.out.println(remind);
final int i = this.employeeService.modifyRemind(remind);
if (i != -1) {
System.out.println("successfully modify!!!");
}
return "success";
}
@RequestMapping({ "/report" })
public String report(final Model model) {
System.out.println("getAllService");
final List<AllService> allServices = this.employeeService.getAllService();
model.addAttribute("allServices", (Object)allServices);
return "report";
}
@RequestMapping({ "/toServiceExcel" })
@ResponseBody
public String toExcel() {
final AllServiceExcel serviceExcel = new AllServiceExcel("allServices.xls", "services");
serviceExcel.setColValue(this.employeeService.getAllService());
ExcelUtils.makeExcel(serviceExcel);
return "success";
}
}
//
//
//
}
return "success";
}
@RequestMapping({ "/remind/delete/{id}" })
@ResponseBody
public String deleteRemind(@PathVariable("id") final String remindId) {
final int i = this.employeeService.deleteRemind(remindId);
if (i != -1) {
System.out.println("successfully delete!!!");
}
return "success";
}
@RequestMapping({ "remind/modify" })
@ResponseBody
public String modifyRemind(final Remind remind) {
System.out.println(remind);
final int i = this.employeeService.modifyRemind(remind);
if (i != -1) {
System.out.println("successfully modify!!!");
}
return "success";
}
@RequestMapping({ "/report" })
public String report(final Model model) {
System.out.println("getAllService");
final List<AllService> allServices = this.employeeService.getAllService();
model.addAttribute("allServices", (Object)allServices);
return "report";
}
@RequestMapping({ "/toServiceExcel" })
@ResponseBody
public String toExcel() {
final AllServiceExcel serviceExcel = new AllServiceExcel("allServices.xls", "services");
serviceExcel.setColValue(this.employeeService.getAllService());
ExcelUtils.makeExcel(serviceExcel);
return "success";
}
}
//
//
//
//
//
//
public class AdminInterceptor implements HandlerInterceptor
{
public boolean preHandle(final HttpServletRequest httpServletRequest, final HttpServletResponse httpServletResponse, final Object o) throws Exception {
final HttpSession session = httpServletRequest.getSession();
final Employee employee = (Employee)session.getAttribute("employee");
if (!employee.getEmployeePower().equals("1")) {
System.out.println("!!!");
httpServletRequest.getRequestDispatcher("/login").forward((ServletRequest)httpServletRequest, (ServletResponse)httpServletResponse);
return false;
}
return true;
}
public void postHandle(final HttpServletRequest httpServletRequest, final HttpServletResponse httpServletResponse, final Object o, final ModelAndView modelAndView) throws Exception {
}
public void afterCompletion(final HttpServletRequest httpServletRequest, final HttpServletResponse httpServletResponse, final Object o, final Exception e) throws Exception {
}
}
//
//
//
public class AllInterceptor implements HandlerInterceptor
{
}
@RequestMapping({ "/travel/modify" })
@ResponseBody
public String modifyTravel(final Travel travel) {
System.out.println(travel);
System.out.println("?????");
final int i = this.memberService.modifyTravel(travel);
if (i != -1) {
System.out.println("success");
}
return "success";
}
@RequestMapping({ "/rescue" })
public String getAllRescue(final Model model) {
final List<Rescue> rescueList = this.memberService.getAllRescue();
final List<Car> carList = this.memberService.getAllCar();
model.addAttribute("rescueList", (Object)rescueList);
model.addAttribute("carList", (Object)carList);
return "rescue";
}
@RequestMapping({ "/rescue/{id}" })
@ResponseBody
public Rescue getRescueByRescueId(@PathVariable("id") final String rescueId) {
System.out.println("rescueId:" + rescueId);
final Rescue rescueByRescueId = this.memberService.getRescueByRescueId(rescueId);
System.out.println(rescueByRescueId);
return rescueByRescueId;
}
@RequestMapping({ "/rescue/add" })
@ResponseBody
public String addRescue(final Rescue rescue) {
System.out.println(rescue);
final int i = this.memberService.addRescue(rescue);
if (i != -1) {
System.out.println("success add rescue");
}
return "success";
}
@RequestMapping({ "/rescue/delete/{id}" })
@ResponseBody
public String deleteRescue(@PathVariable("id") final String rescueId) {
final int i = this.memberService.deleteRescue(rescueId);
if (i != -1) {
System.out.println("success");