基于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
- 实体类:Lombok
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件;
- 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven;
若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行;
- 将项目中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();