失眠网 > Java项目:超市进销存管理系统(java+SpringBoot+Html+Layui+echarts+mysql)

Java项目:超市进销存管理系统(java+SpringBoot+Html+Layui+echarts+mysql)

时间：2018-12-13 13:28:42

源码获取：博客首页 "资源" 里下载！

项目介绍

超市进销存管理系统,分为管理员与普通员工两种角色；

管理员主要功能包括：

员工管理：员工的添加、编辑、删除；

普通员工主要功能包括：

供应商管理：供应商的添加、删除、修改；

商品管理：商品种类管理、商品信息管理；

库存管理；

订单管理；

环境需要

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.是否Maven项目: 是；查看源码目录中是否包含pom.xml；若包含，则为maven项目，否则为非maven项目

6.数据库：MySql 5.7版本；

7.lombok 注：一定要安装，否则会有问题；

技术栈

1. 后端：SpringBoot+Mybatis

2. 前端：Html+jQuery+Layui+echarts

使用说明

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

2.使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;若为maven项目，导入成功后请执行maven clean;maven install命令，配置tomcat，然后运行；

3. 将项目中application.yml配置文件中的数据库配置改为自己的配置;

4. 管理员访问地址：http://localhost:8085/admin

5. 员工访问地址：http://localhost:8085

前端控制器用户控制层：

/*** * 前端控制器* **/@RestController@RequestMapping("/user")public class UserController {@Autowiredprivate UserService userService;@Autowiredprivate RoleService roleService;/*** 登录** @param username 用户名* @param password 密码* @param request* @return*/@SysLog("登陆操作")@PostMapping("/login")public Result login(String username, String password, HttpServletRequest request) {try {//获取当前登录主体对象Subject subject = SecurityUtils.getSubject();UsernamePasswordToken token = new UsernamePasswordToken(username, password);subject.login(token);LoginUserVO userDTO = (LoginUserVO) subject.getPrincipal();request.getSession().setAttribute("username", userDTO.getUser());return Result.success(true, "200", "登录成功");} catch (UnknownAccountException e) {e.printStackTrace();return Result.error(false, "400", "登录失败,用户名不存在");}catch (IncorrectCredentialsException e) {e.printStackTrace();return Result.error(false, "400", "登录失败,密码错误");}catch (AuthenticationException e) {e.printStackTrace();return Result.error(false, "400", "登录失败,账户禁用");}}/*** 得到登陆验证码* @param response* @param session* @throws IOException*/@RequestMapping("/getCode")public void getCode(HttpServletResponse response, HttpSession session) throws IOException {//定义图形验证码的长和宽LineCaptcha lineCaptcha = CaptchaUtil.createLineCaptcha(116, 36,4,5);session.setAttribute("code",lineCaptcha.getCode());try {ServletOutputStream outputStream = response.getOutputStream();lineCaptcha.write(outputStream);outputStream.close();} catch (IOException e) {e.printStackTrace();}}/*** 查询所有用户信息** @param userVO* @return*/@SysLog("用户查询操作")@RequestMapping("/userList")public DataGridViewResult userList(UserVO userVO) {//分页构造函数IPage<User> page = new Page<>(userVO.getPage(), userVO.getLimit());QueryWrapper<User> queryWrapper = new QueryWrapper<>();queryWrapper.like(!StringUtils.isEmpty(userVO.getUsername()), "username", userVO.getUsername());queryWrapper.like(!StringUtils.isEmpty(userVO.getUname()), "uname", userVO.getUname());/*** 翻页查询* @param page 翻页对象* @param queryWrapper 实体对象封装操作类*/IPage<User> userIPage = userService.page(page, queryWrapper);return new DataGridViewResult(userIPage.getTotal(), userIPage.getRecords());}/*** 添加用户信息** @param user* @return*/@SysLog("用户添加操作")@PostMapping("/adduser")public Result addRole(User user) {user.setUcreatetime(new Date());String salt = UUIDUtil.randomUUID();user.setPassword(PasswordUtil.md5("000000", salt, 2));user.setSalt(salt);user.setType(1);boolean bool = userService.save(user);try {if (bool) {return Result.success(true, "200", "添加成功！");}} catch (Exception e) {e.printStackTrace();}return Result.error(false, null, "添加失败！");}/*** 校验用户名是否存在** @param username* @return*/@RequestMapping("/checkUserName")public String checkUserName(String username) {Map<String, Object> map = new HashMap<>();try {QueryWrapper<User> queryWrapper = new QueryWrapper<>();queryWrapper.eq("username", username);User user = userService.getOne(queryWrapper);if (user != null) {map.put("exist", true);map.put("message", "用户名已存在");} else {map.put("exist", false);map.put("message", "用户名可以使用");}} catch (Exception e) {e.printStackTrace();}return JSON.toJSONString(map);}/*** 修改用户信息** @param user* @return*/@SysLog("用户修改操作")@PostMapping("/updateuser")public Result updateUser(User user) {boolean bool = userService.updateById(user);try {if (bool) {return Result.success(true, "200", "修改成功！");}} catch (Exception e) {e.printStackTrace();}return Result.error(false, null, "修改失败！");}/*** 删除单条数据** @param id* @return*/@SysLog("用户删除操作")@RequestMapping("/deleteOne")public Result deleteOne(int id) {boolean bool = userService.removeById(id);try {if (bool) {return Result.success(true, "200", "删除成功！");}} catch (Exception e) {e.printStackTrace();}return Result.error(false, null, "删除失败！");}/*** 重置密码** @param id* @return*/@SysLog("用户修改操作")@PostMapping("/resetPwd")public Result resetPwd(int id) {User user = new User();String salt = UUIDUtil.randomUUID();user.setUid(id);user.setPassword(PasswordUtil.md5("000000", salt, 2));user.setSalt(salt);boolean bool = userService.updateById(user);try {if (bool) {return Result.success(true, "200", "重置成功！");}} catch (Exception e) {e.printStackTrace();}return Result.error(false, null, "重置失败！");}/*** 根据id查询当前用户拥有的角色** @param id* @return*/@RequestMapping("/initRoleByUserId")public DataGridViewResult initRoleByUserId(int id) {List<Map<String, Object>> mapList = null;try {//查询所有角色列表mapList = roleService.listMaps();//根据用户id查询用户拥有的角色Set<Integer> roleIdList = userService.findRoleByUserId(id);for (Map<String, Object> map : mapList) {//定义标记默认不选中boolean flag = false;int roleId = (int) map.get("roleid");for (Integer rid : roleIdList) {if (rid == roleId) {flag = true;break;}}map.put("LAY_CHECKED", flag);}} catch (Exception e) {e.printStackTrace();}return new DataGridViewResult(Long.valueOf(mapList.size()), mapList);}/*** 为用户分配角色** @param roleids* @param userid* @return*/@SysLog("用户添加操作")@RequestMapping("/saveUserRole")public Result saveUserRole(String roleids, int userid) {try {if (userService.saveUserRole(userid, roleids)) {return Result.success(true, null, "分配成功");}} catch (Exception e) {e.printStackTrace();}return Result.error(false, null, "分配失败");}/*** 修改密码** @param newPassWord1* @param newPassWord2* @return*/@RequestMapping("/updateUserPassWord")public Result updateUserPassWord(String newPassWord1, String newPassWord2,HttpSession session) {User sessionUser = (User) session.getAttribute("username");if (newPassWord1.equals(newPassWord2)){User user = new User();String salt = UUIDUtil.randomUUID();user.setUid(sessionUser.getUid());user.setPassword(PasswordUtil.md5(newPassWord1, salt, 2));user.setSalt(salt);boolean bool = userService.updateById(user);if (bool){return Result.success(true,null,"修改成功");}else {return Result.error(false,null,"修改失败!");}}else {return Result.error(false,null,"修改失败，两次密码不一致!");}}}

前端控制器角色控制层：

/*** * 前端控制器* **/@RestController@RequestMapping("/role")public class RoleController {@Autowiredprivate RoleService roleService;@Autowiredprivate PermissionService permissionService;/*** 查询所有角色信息* @param roleVO* @return*/@SysLog("角色查询操作")@RequestMapping("/roleList")public DataGridViewResult roleList(RoleVO roleVO) {//分页构造函数IPage<Role> page = new Page<>(roleVO.getPage(), roleVO.getLimit());QueryWrapper<Role> queryWrapper = new QueryWrapper<>();queryWrapper.like(!StringUtils.isEmpty(roleVO.getRolename()), "rolename", roleVO.getRolename());/*** 翻页查询** @param page 翻页对象* @param queryWrapper 实体对象封装操作类 {@link com.baomidou.mybatisplus.core.conditions.query.QueryWrapper}*/IPage<Role> roleIPage = roleService.page(page, queryWrapper);return new DataGridViewResult(roleIPage.getTotal(), roleIPage.getRecords());}/*** 添加角色信息** @param role* @return*/@SysLog("角色添加操作")@PostMapping("/addrole")public Result addRole(Role role) {boolean bool = roleService.save(role);try {if (bool) {return Result.success(true, "200", "添加成功！");}} catch (Exception e) {e.printStackTrace();}return Result.error(false, null, "添加失败！");}/*** 修改角色信息** @param role* @return*/@SysLog("角色修改操作")@PostMapping("/updaterole")public Result updateRole(Role role) {boolean bool = roleService.updateById(role);try {if (bool) {return Result.success(true, "200", "修改成功！");}} catch (Exception e) {e.printStackTrace();}return Result.error(false, null, "修改失败！");}/*** 删除单条数据** @param id* @return*/@SysLog("角色删除操作")@RequestMapping("/deleteOne")public Result deleteOne(int id) {boolean bool = roleService.removeById(id);try {if (bool) {return Result.success(true, "200", "删除成功！");}} catch (Exception e) {e.printStackTrace();}return Result.error(false, null, "删除失败！");}/*** 初始化权限菜单树** @param roleId* @return*/@RequestMapping("/initPermissionByRoleId")public DataGridViewResult initPermissionByRoleId(int roleId) {//创建条件构造器对象QueryWrapper<Permission> queryWrapper = new QueryWrapper<>();List<Permission> permissionList = permissionService.list();List<Integer> currentPermissionIds = permissionService.findRolePermissionIdByRoleId(roleId);//保存角色拥有的菜单List<Permission> currentPermissions = new ArrayList<>();if (currentPermissionIds != null && currentPermissionIds.size() > 0) {queryWrapper.in("id", currentPermissionIds);currentPermissions = permissionService.list(queryWrapper);}List<TreeNode> treeNodes = new ArrayList<>();for (Permission p1 : permissionList) {//定义变量标记是否选中String checkArr = "0";for (Permission p2 : currentPermissions) {if (p1.getId().equals(p2.getId())) {checkArr = "1";break;}}Boolean spread = p1.getSpread() == 1 ? true : false;treeNodes.add(new TreeNode(p1.getId(), p1.getPid(), p1.getTitle(), spread, checkArr));}return new DataGridViewResult(treeNodes);}/*** 保存分配权限关系方法** @param roleid* @param ids* @return*/@SysLog("角色添加操作")@RequestMapping("/saveRolePermission")public Result saveRolePermission(int roleid, String ids) {try {if (roleService.saveRolePermission(roleid, ids)) {return Result.success(true, null, "分配成功");}} catch (Exception e) {e.printStackTrace();}return Result.error(false, null, "分配失败");}}

前端控制器客户管理：

/*** * 前端控制器* **/@RestController@RequestMapping("/customer")public class CustomerController {@Autowiredprivate CustomerService customerService;/*** 客户模糊查询* @param* @return*/@SysLog("客户查询操作")@RequestMapping("/customerList")public DataGridViewResult customerList(CustomerVO customerVO) {//创建分页信息参数1 当前页参数2 每页显示条数IPage<Customer> page = new Page<>(customerVO.getPage(), customerVO.getLimit());QueryWrapper<Customer> queryWrapper = new QueryWrapper<>();queryWrapper.like(!StringUtils.isEmpty(customerVO.getCustvip()),"custvip", customerVO.getCustvip());IPage<Customer> customerIPage = customerService.page(page, queryWrapper);/*** logsIPage.getTotal() 总条数* logsIPage.getRecords() 分页记录列表*/return new DataGridViewResult(customerIPage.getTotal(),customerIPage.getRecords());}/*** 客户批量删除* @param ids* @return*/@SysLog("客户删除操作")@RequestMapping("/deleteList")public Result deleteList(String ids) {//将字符串拆分成数组String[] idsStr = ids.split(",");List<String> list = Arrays.asList(idsStr);boolean bool = customerService.removeByIds(list);if(bool){return Result.success(true,"200","删除成功！");}return Result.error(false,null,"删除失败！");}/*** 添加客户信息* @param customer* @return*/@SysLog("客户添加操作")@PostMapping("/addcustomer")public Result addCustomer(Customer customer){String id = RandomStringUtils.randomAlphanumeric(10);customer.setCustvip(id);boolean bool = customerService.save(customer);if(bool){return Result.success(true,"200","添加成功！");}return Result.error(false,null,"添加失败！");}/*** 修改客户信息* @param customer* @return*/@SysLog("客户修改操作")@PostMapping("/updatecustomer")public Result updateCustomer(Customer customer){boolean bool = customerService.updateById(customer);if(bool){return Result.success(true,"200","修改成功！");}return Result.error(false,null,"修改失败！");}/*** 删除单条数据* @param id* @return*/@SysLog("客户删除操作")@RequestMapping("/deleteOne")public Result deleteOne(int id) {boolean bool = customerService.removeById(id);if(bool){return Result.success(true,"200","删除成功！");}return Result.error(false,null,"删除失败！");}/**** 加载下拉框* @return*/@RequestMapping("/loadAllCustomer")public DataGridViewResult loadAllCustomer(){QueryWrapper<Customer> queryWrapper = new QueryWrapper<>();List<Customer> list = customerService.list(queryWrapper);return new DataGridViewResult(list);}}

商品管理控制层：

/*** * 前端控制器* **/@RestController@RequestMapping("/goods")public class GoodsController {@Autowiredprivate GoodsService goodsService;@Autowiredprivate ProviderService providerService;@Autowiredprivate CategoryService categoryService;/*** 商品模糊查询** @param* @return*/@SysLog("商品查询操作")@RequestMapping("/goodsList")public DataGridViewResult goodsList(GoodsVO goodsVO) {//创建分页信息参数1 当前页参数2 每页显示条数IPage<Goods> page = new Page<>(goodsVO.getPage(), goodsVO.getLimit());QueryWrapper<Goods> queryWrapper = new QueryWrapper<>();queryWrapper.eq(goodsVO.getProviderid() != null && goodsVO.getProviderid() != 0, "providerid", goodsVO.getProviderid());queryWrapper.like(!StringUtils.isEmpty(goodsVO.getGname()), "gname", goodsVO.getGname());IPage<Goods> goodsIPage = goodsService.page(page, queryWrapper);List<Goods> records = goodsIPage.getRecords();for (Goods goods : records) {Provider provider = providerService.getById(goods.getProviderid());if (null != provider) {goods.setProvidername(provider.getProvidername());}}return new DataGridViewResult(goodsIPage.getTotal(), records);}/*** 添加商品信息** @param goods* @return*/@SysLog("商品添加操作")@PostMapping("/addgoods")public Result addGoods(Goods goods) {String id = RandomStringUtils.randomAlphanumeric(8);if (goods.getGoodsimg()!=null&&goods.getGoodsimg().endsWith("_temp")){String newName = AppFileUtils.renameFile(goods.getGoodsimg());goods.setGoodsimg(newName);}goods.setGnumbering(id);boolean bool = goodsService.save(goods);if (bool) {return Result.success(true, "200", "添加成功！");}return Result.error(false, null, "添加失败！");}/*** 修改商品信息** @param goods* @return*/@SysLog("商品修改操作")@PostMapping("/updategoods")public Result updateGoods(Goods goods) {//商品图片不是默认图片if (!(goods.getGoodsimg()!=null&&goods.getGoodsimg().equals(Constast.DEFAULT_IMG))){if (goods.getGoodsimg().endsWith("_temp")){String newName = AppFileUtils.renameFile(goods.getGoodsimg());goods.setGoodsimg(newName);//删除原先的图片String oldPath = goodsService.getById(goods.getGid()).getGoodsimg();AppFileUtils.removeFileByPath(oldPath);}}boolean bool = goodsService.updateById(goods);if (bool) {return Result.success(true, "200", "修改成功！");}return Result.error(false, null, "修改失败！");}/*** 删除单条数据** @param id* @return*/@SysLog("商品删除操作")@RequestMapping("/deleteOne")public Result deleteOne(int id) {boolean bool = goodsService.removeById(id);if (bool) {return Result.success(true, "200", "删除成功！");}return Result.error(false, null, "删除失败！");}/*** 根据id查询当前商品拥有的类别** @param id* @return*/@RequestMapping("/initGoodsByCategoryId")public DataGridViewResult initGoodsByCategoryId(int id) {List<Map<String, Object>> mapList = null;try {//查询所有类别列表mapList = categoryService.listMaps();//根据商品id查询商品拥有的类别Set<Integer> cateIdList = categoryService.findGoodsByCategoryId(id);for (Map<String, Object> map : mapList) {//定义标记默认不选中boolean flag = false;int cateId = (int) map.get("cateid");for (Integer cid : cateIdList) {if (cid == cateId) {flag = true;break;}}map.put("LAY_CHECKED", flag);}} catch (Exception e) {e.printStackTrace();}return new DataGridViewResult(Long.valueOf(mapList.size()), mapList);}/*** 根据商品id加载商品信息* @param goodsid* @return*/@GetMapping("/loadGoodsById")public DataGridViewResult loadGoodsById(int goodsid) {QueryWrapper<Goods> goodsQueryWrapper = new QueryWrapper<>();goodsQueryWrapper.eq(goodsid != 0, "gid", goodsid);Goods goods = goodsService.getById(goodsid);return new DataGridViewResult(goods);}/*** 为商品分配类别** @param categoryids* @param goodsid* @return*/@SysLog("类别添加操作")@RequestMapping("/saveGoodsCategory")public Result saveGoodsCategory(String categoryids, int goodsid) {try {if (goodsService.saveGoodsCategory(goodsid, categoryids)) {return Result.success(true, null, "分配成功");}} catch (Exception e) {e.printStackTrace();}return Result.error(false, null, "分配失败");}/*** 加载下拉框** @return*/@RequestMapping("/loadAllGoods")public DataGridViewResult loadAllGoods() {QueryWrapper<Goods> queryWrapper = new QueryWrapper<>();List<Goods> list = goodsService.list(queryWrapper);return new DataGridViewResult(list);}/*** 根据供应商查商品下拉框** @param providerid* @return*/@RequestMapping("/loadGoodsByProvidreId")public DataGridViewResult loadGoodsByProvidreId(Integer providerid) {QueryWrapper<Goods> goodsQueryWrapper = new QueryWrapper<>();goodsQueryWrapper.eq(providerid != null, "providerid", providerid);List<Goods> list = goodsService.list(goodsQueryWrapper);for (Goods goods : list) {Provider provider = providerService.getById(goods.getProviderid());if (null != provider) {goods.setProvidername(provider.getProvidername());}}return new DataGridViewResult(list);}}