0
0

Java项目:进销存管理系统(java+Jsp+Ssm+Mysql)

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

进销存的功能有：

供应商管理、商品管理、进货管理、库存盘点、进货退货管理、销售管理、销售退货管理、销售统计分析等功能。其中商品除了可以单个添加外，还支持批量从excel文件中导入。

用户管理控制层：

  2. /**
  3.  * <p>
  4.  * 前端控制器
  5.  * </p>
  6.  */
  7. @RestController
  8. @RequestMapping("/user")
  9. public class UserController {
  11.     @Autowired
  12.     private UserService userService;
  14.     @Autowired
  15.     private RoleService roleService;
  17.     /**
  18.      * 登录
  19.      *
  20.      * @param username 用户名
  21.      * @param password 密码
  22.      * @param request
  23.      * @return
  24.      */
  26.     @SysLog("登陆操作")
  27.     @PostMapping("/login")
  28.     public Result login(String username, String password, HttpServletRequest request) {
  29.         try {
  30.             //获取当前登录主体对象
  31.             Subject subject = SecurityUtils.getSubject();
  32.             UsernamePasswordToken token = new UsernamePasswordToken(username, password);
  33.             subject.login(token);
  34.             LoginUserVO userDTO = (LoginUserVO) subject.getPrincipal();
  35.             request.getSession().setAttribute("username", userDTO.getUser());
  36.             return Result.success(true, "200", "登录成功");
  37.         } catch (UnknownAccountException e) {
  38.             e.printStackTrace();
  39.             return Result.error(false, "400", "登录失败,用户名不存在");
  40.         }catch (IncorrectCredentialsException e) {
  41.             e.printStackTrace();
  42.             return Result.error(false, "400", "登录失败,密码错误");
  43.         }catch (AuthenticationException e) {
  44.             e.printStackTrace();
  45.             return Result.error(false, "400", "登录失败,账户禁用");
  46.         }
  47.     }
  49.     /**
  50.      * 得到登陆验证码
  51.      * @param response
  52.      * @param session
  53.      * @throws IOException
  54.      */
  55.     @RequestMapping("/getCode")
  56.     public void getCode(HttpServletResponse response, HttpSession session) throws IOException {
  57.         //定义图形验证码的长和宽
  58.         LineCaptcha lineCaptcha = CaptchaUtil.createLineCaptcha(116, 36,4,5);
  59.         session.setAttribute("code",lineCaptcha.getCode());
  60.         try {
  61.             ServletOutputStream outputStream = response.getOutputStream();
  62.             lineCaptcha.write(outputStream);
  63.             outputStream.close();
  64.         } catch (IOException e) {
  65.             e.printStackTrace();
  66.         }
  67.     }
  69.     /**
  70.      * 查询所有用户信息
  71.      *
  72.      * @param userVO
  73.      * @return
  74.      */
  75.     @SysLog("用户查询操作")
  76.     @RequestMapping("/userList")
  77.     public DataGridViewResult userList(UserVO userVO) {
  78.         //分页构造函数
  79.         IPage<User> page = new Page<>(userVO.getPage(), userVO.getLimit());
  80.         QueryWrapper<User> queryWrapper = new QueryWrapper<>();
  81.         queryWrapper.like(!StringUtils.isEmpty(userVO.getUsername()), "username", userVO.getUsername());
  82.         queryWrapper.like(!StringUtils.isEmpty(userVO.getUname()), "uname", userVO.getUname());
  83.         /**
  84.          * 翻页查询
  85.          * @param page         翻页对象
  86.          * @param queryWrapper 实体对象封装操作类
  87.          */
  88.         IPage<User> userIPage = userService.page(page, queryWrapper);
  89.         return new DataGridViewResult(userIPage.getTotal(), userIPage.getRecords());
  90.     }
  92.     /**
  93.      * 添加用户信息
  94.      *
  95.      * @param user
  96.      * @return
  97.      */
  98.     @SysLog("用户添加操作")
  99.     @PostMapping("/adduser")
  100.     public Result addRole(User user) {
  102.         user.setUcreatetime(new Date());
  103.         String salt = UUIDUtil.randomUUID();
  104.         user.setPassword(PasswordUtil.md5("000000", salt, 2));
  105.         user.setSalt(salt);
  106.         user.setType(1);
  107.         boolean bool = userService.save(user);
  109.         try {
  110.             if (bool) {
  111.                 return Result.success(true, "200", "添加成功！");
  112.             }
  113.         } catch (Exception e) {
  114.             e.printStackTrace();
  115.         }
  116.         return Result.error(false, null, "添加失败！");
  117.     }
  119.     /**
  120.      * 校验用户名是否存在
  121.      *
  122.      * @param username
  123.      * @return
  124.      */
  126.     @RequestMapping("/checkUserName")
  127.     public String checkUserName(String username) {
  128.         Map<String, Object> map = new HashMap<>();
  129.         try {
  130.             QueryWrapper<User> queryWrapper = new QueryWrapper<>();
  131.             queryWrapper.eq("username", username);
  132.             User user = userService.getOne(queryWrapper);
  133.             if (user != null) {
  134.                 map.put("exist", true);
  135.                 map.put("message", "用户名已存在");
  136.             } else {
  137.                 map.put("exist", false);
  138.                 map.put("message", "用户名可以使用");
  139.             }
  140.         } catch (Exception e) {
  141.             e.printStackTrace();
  142.         }
  143.         return JSON.toJSONString(map);
  144.     }
  146.     /**
  147.      * 修改用户信息
  148.      *
  149.      * @param user
  150.      * @return
  151.      */
  152.     @SysLog("用户修改操作")
  153.     @PostMapping("/updateuser")
  154.     public Result updateUser(User user) {
  156.         boolean bool = userService.updateById(user);
  157.         try {
  158.             if (bool) {
  159.                 return Result.success(true, "200", "修改成功！");
  160.             }
  161.         } catch (Exception e) {
  162.             e.printStackTrace();
  163.         }
  164.         return Result.error(false, null, "修改失败！");
  165.     }
  167.     /**
  168.      * 删除单条数据
  169.      *
  170.      * @param id
  171.      * @return
  172.      */
  173.     @SysLog("用户删除操作")
  174.     @RequestMapping("/deleteOne")
  175.     public Result deleteOne(int id) {
  176.         boolean bool = userService.removeById(id);
  177.         try {
  178.             if (bool) {
  179.                 return Result.success(true, "200", "删除成功！");
  180.             }
  181.         } catch (Exception e) {
  182.             e.printStackTrace();
  183.         }
  184.         return Result.error(false, null, "删除失败！");
  185.     }
  187.     /**
  188.      * 重置密码
  189.      *
  190.      * @param id
  191.      * @return
  192.      */
  193.     @SysLog("用户修改操作")
  194.     @PostMapping("/resetPwd")
  195.     public Result resetPwd(int id) {
  197.         User user = new User();
  198.         String salt = UUIDUtil.randomUUID();
  199.         user.setUid(id);
  200.         user.setPassword(PasswordUtil.md5("000000", salt, 2));
  201.         user.setSalt(salt);
  202.         boolean bool = userService.updateById(user);
  204.         try {
  205.             if (bool) {
  206.                 return Result.success(true, "200", "重置成功！");
  207.             }
  208.         } catch (Exception e) {
  209.             e.printStackTrace();
  210.         }
  211.         return Result.error(false, null, "重置失败！");
  212.     }
  214.     /**
  215.      * 根据id查询当前用户拥有的角色
  216.      *
  217.      * @param id
  218.      * @return
  219.      */
  220.     @RequestMapping("/initRoleByUserId")
  221.     public DataGridViewResult initRoleByUserId(int id) {
  222.         List<Map<String, Object>> mapList = null;
  223.         try {
  224.             //查询所有角色列表
  225.             mapList = roleService.listMaps();
  226.             //根据用户id查询用户拥有的角色
  227.             Set<Integer> roleIdList = userService.findRoleByUserId(id);
  228.             for (Map<String, Object> map : mapList) {
  229.                 //定义标记 默认不选中
  230.                 boolean flag = false;
  231.                 int roleId = (int) map.get("roleid");
  232.                 for (Integer rid : roleIdList) {
  233.                     if (rid == roleId) {
  234.                         flag = true;
  235.                         break;
  236.                     }
  237.                 }
  238.                 map.put("LAY_CHECKED", flag);
  239.             }
  240.         } catch (Exception e) {
  241.             e.printStackTrace();
  242.         }
  243.         return new DataGridViewResult(Long.valueOf(mapList.size()), mapList);
  245.     }
  247.     /**
  248.      * 为用户分配角色
  249.      *
  250.      * @param roleids
  251.      * @param userid
  252.      * @return
  253.      */
  254.     @SysLog("用户添加操作")
  255.     @RequestMapping("/saveUserRole")
  256.     public Result saveUserRole(String roleids, int userid) {
  258.         try {
  259.             if (userService.saveUserRole(userid, roleids)) {
  260.                 return Result.success(true, null, "分配成功");
  261.             }
  263.         } catch (Exception e) {
  264.             e.printStackTrace();
  265.         }
  266.         return Result.error(false, null, "分配失败");
  268.     }
  270.     /**
  271.      * 修改密码
  272.      *
  273.      * @param newPassWord1
  274.      * @param newPassWord2
  275.      * @return
  276.      */
  277.     @RequestMapping("/updateUserPassWord")
  278.     public Result updateUserPassWord(String newPassWord1, String newPassWord2,HttpSession session) {
  279.         User sessionUser = (User) session.getAttribute("username");
  281.         if (newPassWord1.equals(newPassWord2)){
  282.             User user = new User();
  283.             String salt = UUIDUtil.randomUUID();
  284.             user.setUid(sessionUser.getUid());
  285.             user.setPassword(PasswordUtil.md5(newPassWord1, salt, 2));
  286.             user.setSalt(salt);
  287.             boolean bool = userService.updateById(user);
  288.             if (bool){
  289.                 return Result.success(true,null,"修改成功");
  290.             }else {
  291.                 return Result.error(false,null,"修改失败!");
  292.             }
  293.         }else {
  294.             return Result.error(false,null,"修改失败，两次密码不一致!");
  295.         }
  297.     }
  299. }

角色管理控制层：

  1. /**
  2.  * <p>
  3.  * 前端控制器
  4.  * </p>
  5.  *
  6.  */
  7. @RestController
  8. @RequestMapping("/role")
  9. public class RoleController {
  11.     @Autowired
  12.     private RoleService roleService;
  14.     @Autowired
  15.     private PermissionService permissionService;
  17.     /**
  18.      * 查询所有角色信息
  19.      * @param roleVO
  20.      * @return
  21.      */
  22.     @SysLog("角色查询操作")
  23.     @RequestMapping("/roleList")
  24.     public DataGridViewResult roleList(RoleVO roleVO) {
  25.         //分页构造函数
  26.         IPage<Role> page = new Page<>(roleVO.getPage(), roleVO.getLimit());
  27.         QueryWrapper<Role> queryWrapper = new QueryWrapper<>();
  28.         queryWrapper.like(!StringUtils.isEmpty(roleVO.getRolename()), "rolename", roleVO.getRolename());
  29.         /**
  30.          * 翻页查询
  31.          *
  32.          * @param page         翻页对象
  33.          * @param queryWrapper 实体对象封装操作类 {@link com.baomidou.mybatisplus.core.conditions.query.QueryWrapper}
  34.          */
  35.         IPage<Role> roleIPage = roleService.page(page, queryWrapper);
  36.         return new DataGridViewResult(roleIPage.getTotal(), roleIPage.getRecords());
  37.     }
  39.     /**
  40.      * 添加角色信息
  41.      *
  42.      * @param role
  43.      * @return
  44.      */
  45.     @SysLog("角色添加操作")
  46.     @PostMapping("/addrole")
  47.     public Result addRole(Role role) {
  48.         boolean bool = roleService.save(role);
  49.         try {
  50.             if (bool) {
  51.                 return Result.success(true, "200", "添加成功！");
  52.             }
  53.         } catch (Exception e) {
  54.             e.printStackTrace();
  55.         }
  56.         return Result.error(false, null, "添加失败！");
  57.     }
  59.     /**
  60.      * 修改角色信息
  61.      *
  62.      * @param role
  63.      * @return
  64.      */
  65.     @SysLog("角色修改操作")
  66.     @PostMapping("/updaterole")
  67.     public Result updateRole(Role role) {
  68.         boolean bool = roleService.updateById(role);
  69.         try {
  70.             if (bool) {
  71.                 return Result.success(true, "200", "修改成功！");
  72.             }
  73.         } catch (Exception e) {
  74.             e.printStackTrace();
  75.         }
  76.         return Result.error(false, null, "修改失败！");
  77.     }
  79.     /**
  80.      * 删除单条数据
  81.      *
  82.      * @param id
  83.      * @return
  84.      */
  85.     @SysLog("角色删除操作")
  86.     @RequestMapping("/deleteOne")
  87.     public Result deleteOne(int id) {
  88.         boolean bool = roleService.removeById(id);
  89.         try {
  90.             if (bool) {
  91.                 return Result.success(true, "200", "删除成功！");
  92.             }
  93.         } catch (Exception e) {
  94.             e.printStackTrace();
  95.         }
  96.         return Result.error(false, null, "删除失败！");
  97.     }
  99.     /**
  100.      * 初始化权限菜单树
  101.      *
  102.      * @param roleId
  103.      * @return
  104.      */
  105.     @RequestMapping("/initPermissionByRoleId")
  106.     public DataGridViewResult initPermissionByRoleId(int roleId) {
  107.         //创建条件构造器对象
  108.         QueryWrapper<Permission> queryWrapper = new QueryWrapper<>();
  109.         List<Permission> permissionList = permissionService.list();
  110.         List<Integer> currentPermissionIds = permissionService.findRolePermissionIdByRoleId(roleId);
  111.         //保存角色拥有的菜单
  112.         List<Permission> currentPermissions = new ArrayList<>();
  113.         if (currentPermissionIds != null && currentPermissionIds.size() > 0) {
  114.             queryWrapper.in("id", currentPermissionIds);
  115.             currentPermissions = permissionService.list(queryWrapper);
  116.         }
  117.         List<TreeNode> treeNodes = new ArrayList<>();
  118.         for (Permission p1 : permissionList) {
  119.             //定义变量标记是否选中
  120.             String checkArr = "0";
  121.             for (Permission p2 : currentPermissions) {
  122.                 if (p1.getId().equals(p2.getId())) {
  123.                     checkArr = "1";
  124.                     break;
  125.                 }
  126.             }
  127.             Boolean spread = p1.getSpread() == 1 ? true : false;
  128.             treeNodes.add(new TreeNode(p1.getId(), p1.getPid(), p1.getTitle(), spread, checkArr));
  129.         }
  130.         return new DataGridViewResult(treeNodes);
  131.     }
  133.     /**
  134.      * 保存分配权限关系方法
  135.      *
  136.      * @param roleid
  137.      * @param ids
  138.      * @return
  139.      */
  140.     @SysLog("角色添加操作")
  141.     @RequestMapping("/saveRolePermission")
  142.     public Result saveRolePermission(int roleid, String ids) {
  144.         try {
  145.             if (roleService.saveRolePermission(roleid, ids)) {
  146.                 return Result.success(true, null, "分配成功");
  147.             }
  149.         } catch (Exception e) {
  150.             e.printStackTrace();
  151.         }
  152.         return Result.error(false, null, "分配失败");
  154.     }
  155. }

商品管理控制层：

  1. @RestController
  2. @RequestMapping("/goods")
  3. public class GoodsController {
  5.     @Autowired
  6.     private GoodsService goodsService;
  8.     @Autowired
  9.     private ProviderService providerService;
  11.     @Autowired
  12.     private CategoryService categoryService;
  14.     /**
  15.      * 商品模糊查询
  16.      *
  17.      * @param
  18.      * @return
  19.      */
  20.     @SysLog("商品查询操作")
  21.     @RequestMapping("/goodsList")
  22.     public DataGridViewResult goodsList(GoodsVO goodsVO) {
  23.         //创建分页信息    参数1 当前页  参数2 每页显示条数
  24.         IPage<Goods> page = new Page<>(goodsVO.getPage(), goodsVO.getLimit());
  25.         QueryWrapper<Goods> queryWrapper = new QueryWrapper<>();
  26.         queryWrapper.eq(goodsVO.getProviderid() != null && goodsVO.getProviderid() != 0, "providerid", goodsVO.getProviderid());
  27.         queryWrapper.like(!StringUtils.isEmpty(goodsVO.getGname()), "gname", goodsVO.getGname());
  28.         IPage<Goods> goodsIPage = goodsService.page(page, queryWrapper);
  29.         List<Goods> records = goodsIPage.getRecords();
  30.         for (Goods goods : records) {
  31.             Provider provider = providerService.getById(goods.getProviderid());
  32.             if (null != provider) {
  33.                 goods.setProvidername(provider.getProvidername());
  34.             }
  35.         }
  36.         return new DataGridViewResult(goodsIPage.getTotal(), records);
  37.     }
  39.     /**
  40.      * 添加商品信息
  41.      *
  42.      * @param goods
  43.      * @return
  44.      */
  45.     @SysLog("商品添加操作")
  46.     @PostMapping("/addgoods")
  47.     public Result addGoods(Goods goods) {
  48.         String id = RandomStringUtils.randomAlphanumeric(8);
  49.         if (goods.getGoodsimg()!=null&&goods.getGoodsimg().endsWith("_temp")){
  50.             String newName = AppFileUtils.renameFile(goods.getGoodsimg());
  51.             goods.setGoodsimg(newName);
  52.         }
  53.         goods.setGnumbering(id);
  54.         boolean bool = goodsService.save(goods);
  55.         if (bool) {
  56.             return Result.success(true, "200", "添加成功！");
  57.         }
  58.         return Result.error(false, null, "添加失败！");
  59.     }
  61.     /**
  62.      * 修改商品信息
  63.      *
  64.      * @param goods
  65.      * @return
  66.      */
  67.     @SysLog("商品修改操作")
  68.     @PostMapping("/updategoods")
  69.     public Result updateGoods(Goods goods) {
  70.         //商品图片不是默认图片
  71.         if (!(goods.getGoodsimg()!=null&&goods.getGoodsimg().equals(Constast.DEFAULT_IMG))){
  72.             if (goods.getGoodsimg().endsWith("_temp")){
  73.                 String newName = AppFileUtils.renameFile(goods.getGoodsimg());
  74.                 goods.setGoodsimg(newName);
  75.                 //删除原先的图片
  76.                 String oldPath = goodsService.getById(goods.getGid()).getGoodsimg();
  77.                 AppFileUtils.removeFileByPath(oldPath);
  78.             }
  79.         }
  80.         boolean bool = goodsService.updateById(goods);
  81.         if (bool) {
  82.             return Result.success(true, "200", "修改成功！");
  83.         }
  84.         return Result.error(false, null, "修改失败！");
  85.     }
  87.     /**
  88.      * 删除单条数据
  89.      *
  90.      * @param id
  91.      * @return
  92.      */
  93.     @SysLog("商品删除操作")
  94.     @RequestMapping("/deleteOne")
  95.     public Result deleteOne(int id) {
  97.         boolean bool = goodsService.removeById(id);
  98.         if (bool) {
  99.             return Result.success(true, "200", "删除成功！");
  100.         }
  101.         return Result.error(false, null, "删除失败！");
  102.     }
  104.     /**
  105.      * 根据id查询当前商品拥有的类别
  106.      *
  107.      * @param id
  108.      * @return
  109.      */
  110.     @RequestMapping("/initGoodsByCategoryId")
  111.     public DataGridViewResult initGoodsByCategoryId(int id) {
  112.         List<Map<String, Object>> mapList = null;
  113.         try {
  114.             //查询所有类别列表
  115.             mapList = categoryService.listMaps();
  116.             //根据商品id查询商品拥有的类别
  117.             Set<Integer> cateIdList = categoryService.findGoodsByCategoryId(id);
  118.             for (Map<String, Object> map : mapList) {
  119.                 //定义标记 默认不选中
  120.                 boolean flag = false;
  121.                 int cateId = (int) map.get("cateid");
  122.                 for (Integer cid : cateIdList) {
  123.                     if (cid == cateId) {
  124.                         flag = true;
  125.                         break;
  126.                     }
  127.                 }
  128.                 map.put("LAY_CHECKED", flag);
  129.             }
  130.         } catch (Exception e) {
  131.             e.printStackTrace();
  132.         }
  133.         return new DataGridViewResult(Long.valueOf(mapList.size()), mapList);
  135.     }
  137.     /**
  138.      * 根据商品id加载商品信息
  139.      * @param goodsid
  140.      * @return
  141.      */
  142.     @GetMapping("/loadGoodsById")
  143.     public DataGridViewResult loadGoodsById(int goodsid) {
  145.         QueryWrapper<Goods> goodsQueryWrapper = new QueryWrapper<>();
  146.         goodsQueryWrapper.eq(goodsid != 0, "gid", goodsid);
  147.         Goods goods = goodsService.getById(goodsid);
  149.         return new DataGridViewResult(goods);
  151.     }
  153.     /**
  154.      * 为商品分配类别
  155.      *
  156.      * @param categoryids
  157.      * @param goodsid
  158.      * @return
  159.      */
  160.     @SysLog("类别添加操作")
  161.     @RequestMapping("/saveGoodsCategory")
  162.     public Result saveGoodsCategory(String categoryids, int goodsid) {
  164.         try {
  165.             if (goodsService.saveGoodsCategory(goodsid, categoryids)) {
  166.                 return Result.success(true, null, "分配成功");
  167.             }
  169.         } catch (Exception e) {
  170.             e.printStackTrace();
  171.         }
  172.         return Result.error(false, null, "分配失败");
  174.     }
  176.     /**
  177.      * 加载下拉框
  178.      *
  179.      * @return
  180.      */
  181.     @RequestMapping("/loadAllGoods")
  182.     public DataGridViewResult loadAllGoods() {
  183.         QueryWrapper<Goods> queryWrapper = new QueryWrapper<>();
  184.         List<Goods> list = goodsService.list(queryWrapper);
  185.         return new DataGridViewResult(list);
  187.     }
  189.     /**
  190.      * 根据供应商查商品下拉框
  191.      *
  192.      * @param providerid
  193.      * @return
  194.      */
  195.     @RequestMapping("/loadGoodsByProvidreId")
  196.     public DataGridViewResult loadGoodsByProvidreId(Integer providerid) {
  197.         QueryWrapper<Goods> goodsQueryWrapper = new QueryWrapper<>();
  198.         goodsQueryWrapper.eq(providerid != null, "providerid", providerid);
  199.         List<Goods> list = goodsService.list(goodsQueryWrapper);
  200.         for (Goods goods : list) {
  201.             Provider provider = providerService.getById(goods.getProviderid());
  202.             if (null != provider) {
  203.                 goods.setProvidername(provider.getProvidername());
  204.             }
  206.         }
  207.         return new DataGridViewResult(list);
  209.     }
  210. }

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

标签： java mysql Jsp
本文转载自: https://blog.csdn.net/yuyecsdn/article/details/122357921
版权归原作者 pastclouds 所有， 如有侵权，请联系我们删除。
登录后发布评论

“Java项目:进销存管理系统(java+Jsp+Ssm+Mysql)”的评论:

还没有评论
关于作者
...
overfit同步小助手
文章同步
相关阅读

网络安全法-网络运行安全

使用selenium/drissionpage时如何阻止chrome自动跳转http到https

docker desktop 里部署的Open WebUI 管理员密码忘记了的处理方法

在ubuntu20.04中搭建onsite比赛运行环境

利用开源的低代码表单设计器FcDesigner高效管理和渲染复杂表单结构

Kafka学习笔记

【前端】浏览器输入url到页面呈现发生了什么？