基于javaweb的家政服务系统(java+springboot+bootstrap+echarts+mysql)

基于javaweb的家政服务系统(java+springboot+bootstrap+echarts+mysql)

运行环境

Java≥8、MySQL≥5.7

开发工具

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

适用

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

功能说明

基于javaweb+SpringBoot的家政服务系统(java+SpringBoot+Bootstrap+ECharts+maven+mysql)

项目介绍

本项目为后管系统，主要功能包括： 1. 用户的注册、登录、退出系统 2. 用户的搜索功能 3. 家政人员上传资料、身份认证和资格认证 4. 消费者发布预约、查看预约、确认预约、评价订单、删除订单、修改个人资料 5. 家政人员修改个人资料、申请预约、接受订单、取消订单、完成订单 6. 管理员对用户管理、认证管理和系统的量化查看

环境需要

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 8.0版本；

6.是否Maven项目：是；

技术栈

前端 1. UI界面:Bootstrap 2. 弹窗:Sweetalert 3. Js事件:jQuery/ajax 4. 可视化报表:ECharts 5. 下拉框:Bootstrap-Select 后端 1. 服务层:SpringBoot 2. 持久层:Mybatis 3. 分页:Pagehelper 4. 连接池:c3p0

5. 实体类:Lombok

使用说明

1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；

2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;

若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行；

3. 将项目中application.yml配置文件中的数据库配置改为自己的配置; 4. 运行项目，在浏览器中输入http://localhost:8081/ 登录 消费者登录账号/密码：18796283605/123456 家政人员登录账号/密码：18860425033/123456 管理员账号/密码：18796283601/123456

用户管理控制层：

//定义为控制器

@Controller

// 设置路径

@RequestMapping(value = “/users”, produces = “text/plain;charset=utf-8”)

public class UsersController extends BaseController {

// 注入Service 由于标签的存在 所以不需要getter setter

@Autowired

@Resource

private UsersService usersService;

// 准备添加数据

@RequestMapping(“/createUsers”)

public String createUsers() {

return “admin/addusers”;

// 添加数据

@RequestMapping(“/addUsers”)

public String addUsers(Users users) {

this.usersService.insertUsers(users);

return “redirect:/users/createUsers”;

// 通过主键删除数据

@RequestMapping(“/deleteUsers”)

public String deleteUsers(String id) {

this.usersService.deleteUsers(id);

return “redirect:/users/getAllUsers”;

// 批量删除数据

@RequestMapping(“/deleteUsersByIds”)

public String deleteUsersByIds() {

String[] ids = this.getRequest().getParameterValues(“usersid”);

for (String usersid : ids) {

this.usersService.deleteUsers(usersid);

return “redirect:/users/getAllUsers”;

// 更新数据

@RequestMapping(“/updateUsers”)

public String updateUsers(Users users) {

this.usersService.updateUsers(users);

return “redirect:/users/getAllUsers”;

// 显示全部数据

@RequestMapping(“/getAllUsers”)

public String getAllUsers(String number) {

List usersList = this.usersService.getAllUsers();

PageHelper.getPage(usersList, “users”, null, null, 10, number, this.getRequest(), null);

return “admin/listusers”;

// 按条件查询数据 (模糊查询)

@RequestMapping(“/queryUsersByCond”)

public String queryUsersByCond(String cond, String name, String number) {

Users users = new Users();

if (cond != null) {

if (“username”.equals(cond)) {

users.setUsername(name);

if (“password”.equals(cond)) {

users.setPassword(name);

if (“realname”.equals(cond)) {

users.setRealname(name);

if (“sex”.equals(cond)) {

users.setSex(name);

if (“birthday”.equals(cond)) {

users.setBirthday(name);

if (“contact”.equals(cond)) {

users.setContact(name);

if (“regdate”.equals(cond)) {

users.setRegdate(name);

List nameList = new ArrayList();

List valueList = new ArrayList();

nameList.add(cond);

valueList.add(name);

PageHelper.getPage(this.usersService.getUsersByLike(users), “users”, nameList, valueList, 10, number, this.getRequest(), “query”);

name = null;

cond = null;

return “admin/queryusers”;

// 按主键查询数据

@RequestMapping(“/getUsersById”)

public String getUsersById(String id) {

Users users = this.usersService.getUsersById(id);

this.getRequest().setAttribute(“users”, users);

return “admin/editusers”;

public UsersService getUsersService() {

return usersService;

public void setUsersService(UsersService usersService) {

this.usersService = usersService;

订单管理控制层：

//定义为控制器

@Controller

// 设置路径

@RequestMapping(value = “/orders”, produces = “text/plain;charset=utf-8”)

public class OrdersController extends BaseController {

// 注入Service 由于标签的存在 所以不需要getter setter

@Autowired

@Resource

private OrdersService ordersService;

@Autowired

@Resource

private UsersService usersService;

// 准备添加数据

@RequestMapping(“/createOrders”)

public String createOrders() {

List usersList = this.usersService.getAllUsers();

this.getRequest().setAttribute(“usersList”, usersList);

return “admin/addorders”;

// 添加数据

@RequestMapping(“/addOrders”)

public String addOrders(Orders orders) {

this.ordersService.insertOrders(orders);

return “redirect:/orders/createOrders”;

// 通过主键删除数据

@RequestMapping(“/deleteOrders”)

public String deleteOrders(String id) {

this.ordersService.deleteOrders(id);

return “redirect:/orders/getAllOrders”;

// 批量删除数据

@RequestMapping(“/deleteOrdersByIds”)

public String deleteOrdersByIds() {

String[] ids = this.getRequest().getParameterValues(“ordersid”);

for (String ordersid : ids) {

this.ordersService.deleteOrders(ordersid);

return “redirect:/orders/getAllOrders”;

// 更新数据

@RequestMapping(“/updateOrders”)

public String updateOrders(Orders orders) {

this.ordersService.updateOrders(orders);

return “redirect:/orders/getAllOrders”;

// 显示全部数据

@RequestMapping(“/getAllOrders”)

public String getAllOrders(String number) {

List ordersList = this.ordersService.getAllOrders();

PageHelper.getPage(ordersList, “orders”, null, null, 10, number, this.getRequest(), null);

return “admin/listorders”;

// 按条件查询数据 (模糊查询)

@RequestMapping(“/queryOrdersByCond”)

public String queryOrdersByCond(String cond, String name, String number) {

Orders orders = new Orders();

if (cond != null) {

if (“ordercode”.equals(cond)) {

orders.setOrdercode(name);

if (“usersid”.equals(cond)) {

orders.setUsersid(name);

if (“total”.equals(cond)) {

orders.setTotal(name);

if (“addtime”.equals(cond)) {

orders.setAddtime(name);

if (“status”.equals(cond)) {

orders.setStatus(name);

if (“address”.equals(cond)) {

orders.setAddress(name);

if (“contact”.equals(cond)) {

orders.setContact(name);

if (“workdate”.equals(cond)) {

orders.setWorkdate(name);

if (“worktime”.equals(cond)) {

orders.setWorktime(name);

List nameList = new ArrayList();

List valueList = new ArrayList();

nameList.add(cond);

valueList.add(name);

PageHelper.getPage(this.ordersService.getOrdersByLike(orders), “orders”, nameList, valueList, 10, number, this.getRequest(), “query”);

name = null;

cond = null;

return “admin/queryorders”;

// 按主键查询数据

@RequestMapping(“/getOrdersById”)

public String getOrdersById(String id) {

Orders orders = this.ordersService.getOrdersById(id);

this.getRequest().setAttribute(“orders”, orders);

List usersList = this.usersService.getAllUsers();

this.getRequest().setAttribute(“usersList”, usersList);

return “admin/editorders”;

public OrdersService getOrdersService() {

return ordersService;

public void setOrdersService(OrdersService ordersService) {

this.ordersService = ordersService;

数据图形显示控制层：

//定义为控制器

@Controller

// 设置路径

@RequestMapping(value = “/chart”, produces = “text/plain;charset=utf-8”)

public class ChartController extends BaseController {

@Autowired

@Resource

private OrdersService ordersService;

@Autowired

@Resource

private CateService cateService;

@Autowired

@Resource

private GoodsService goodsService;

@Autowired

@Resource

private TopicService topicService;

@RequestMapping(“/chartline”)

@ResponseBody

public String chartline() throws JSONException {

String start = this.getRequest().getParameter(“start”);

String end = this.getRequest().getParameter(“end”);

long days = VeDate.getDays(end, start) + 1;

JSONArray count = new JSONArray();

JSONArray day = new JSONArray(); // 存放名称

for (int i = 0; i < days; i++) {

String nxtDay = VeDate.getNextDay(start, “” + i);

double total = 0;

Orders orders = new Orders();

orders.setAddtime(nxtDay);

List list = this.ordersService.getOrdersByCond(orders);

for (Orders b : list) {

total += Double.parseDouble(b.getTotal());

count.put(total);

day.put(nxtDay);

JSONObject json = new JSONObject();

json.put(“count”, count.toString());

json.put(“days”, day.toString().replaceAll(“”", “”));

return json.toString();

@RequestMapping(“/chartpie”)

@ResponseBody

public String chartpie() throws JSONException {

JSONArray count = new JSONArray();

JSONArray name = new JSONArray(); // 存放名称

List goodsList = this.goodsService.getAllGoods();

for (Goods goods : goodsList) {

name.put(goods.getGoodsname());

count.put(Integer.parseInt(goods.getSellnum()));

JSONObject json = new JSONObject();

json.put(“count”, count.toString());

json.put(“names”, name.toString().replaceAll(“”", “”));

return json.toString();

@RequestMapping(“/chartBar”)

@ResponseBody

public String chartBar() throws JSONException {

JSONArray name = new JSONArray();

JSONArray count = new JSONArray();

List cateList = this.cateService.getAllCate();

for (Cate cate : cateList) {

name.put(cate.getCatename());

int sum1 = 0;

int sum2 = 0;

int sum3 = 0;

int sum4 = 0;

int sum5 = 0;

Topic t = new Topic();

t.setCateid(cate.getCateid());

List list = this.topicService.getTopicBar(t);

for (Topic x : list) {

if (Integer.parseInt(x.getNum()) == 1) {

sum1++;

if (Integer.parseInt(x.getNum()) == 2) {

sum2++;

if (Integer.parseInt(x.getNum()) == 3) {

sum3++;

if (Integer.parseInt(x.getNum()) == 4) {

sum4++;

if (Integer.parseInt(x.getNum()) == 5) {

sum5++;

String sum = “” + sum1 + “;” + sum2 + “;” + sum3 + “;” + sum4 + “;” + sum5;

System.out.println(sum);

count.put(sum);

JSONObject json = new JSONObject();

json.put(“count”, count.toString().replaceAll(“”", “”));

json.put(“names”, name.toString().replaceAll(“”", “”));

return json.toString();

---