基于javaweb+mysql的springboot超市进销存系统设计和实现(java+springboot+ssm+mysql+html+maven)

基于javaweb+mysql的springboot超市进销存系统设计和实现(java+springboot+ssm+mysql+html+maven)

私信源码获取及调试交流

运行环境

Java≥8、MySQL≥5.7

开发工具

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

适用

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

功能说明

基于javaweb的SpringBoot超市进销存系统设计和实现(java+springboot+ssm+mysql+html+maven)

一、项目简述

本系统主要实现的功能有： 用户管理，商品管理，销售管理，进货退货管理，仓库管 理等等功能。

二、项目运行

环境配置： Jdk1.8 + mysql + Eclispe (IntelliJ IDEA,Eclispe,MyEclispe,Sts 都支持)

项目技术： Springboot+ SpringMVC + MyBatis + ThymeLeaf + JavaScript + JQuery + Ajax + maven等等

@Aspect
@Component
public class AspectController {

    @Autowired
    private LogsService logsservice;

    @Pointcut("@annotation(com.it.aspect.SysLog)")
    public void logPointCut() {}

   @Around("logPointCut()")
    public Object aroundLog(ProceedingJoinPoint point) throws Throwable {

       Object proceed = point.proceed();
       saveLog(point);
       return proceed;
    }

    /**
     * 保存日志
     * @param joinPoint
     * @param
     */
    private void saveLog(ProceedingJoinPoint joinPoint) {
        // 获取签名
        MethodSignature signature = (MethodSignature) joinPoint.getSignature();
        Method method = signature.getMethod();
        SysLog sysLog = method.getAnnotation(SysLog.class);
        ServletRequestAttributes attributes = (ServletRequestAttributes) RequestContextHolder.getRequestAttributes();
        HttpServletRequest request = attributes.getRequest();
        String funcName = signature.getName();
        Logs logs = new Logs();
        if(sysLog != null) {
            //注解上的描述
            logs.setType(sysLog.value());
        }
        LoginUserVO user= (LoginUserVO) SecurityUtils.getSubject().getPrincipal();
        if (null!=user) {
            logs.setLtime(new Date());

     * @param id
     * @param number
     * @param remark
     * @return
     */
    @SysLog("退货添加操作")
    @RequestMapping("addOutport")
    public Result addOutport(Integer id, Integer number, String remark, HttpSession session) {
        try {
            outportService.addOutport(id, number, remark,session);
            return Result.success(true, "200", "添加成功！");
        } catch (Exception e) {
            e.printStackTrace();
            return Result.error(false, null, "添加失败！");
        }

    }

    /**
     * 退货查询
     *
     * @param
     * @return
     */
    @SysLog("退货查询操作")
    @RequestMapping("/outportList")
    public DataGridViewResult outportList(OutportVO outportVO) {

        //创建分页信息    参数1 当前页  参数2 每页显示条数
        IPage<Outport> page = new Page<>(outportVO.getPage(), outportVO.getLimit());
        QueryWrapper<Outport> queryWrapper = new QueryWrapper<>();
        queryWrapper.eq(outportVO.getProviderid() != null && outportVO.getProviderid() != 0, "providerid", outportVO.getProviderid());
        queryWrapper.eq(outportVO.getGoodsid() != null && outportVO.getGoodsid() != 0, "goodsid", outportVO.getGoodsid());
        queryWrapper.ge(outportVO.getStartTime() != null, "outputtime", outportVO.getStartTime());
        queryWrapper.le(outportVO.getEndTime() != null, "outputtime", outportVO.getEndTime());

        queryWrapper.orderByDesc("outputtime");

        IPage<Outport> outportIPage = outportService.page(page, queryWrapper);

        List<Outport> records = outportIPage.getRecords();

        for (Outport outport : records) {
            Provider provider = providerService.getById(outport.getProviderid());

            if (null != provider) {
                outport.setProvidername(provider.getProvidername());
            }
            Goods goods = goodsService.getById(outport.getGoodsid());
            if (null != goods) {

    }

    /**
     * 修改类别信息
     * @param category
     * @return
     */
    @SysLog("类别修改操作")
    @PostMapping("/updatecategory")
    public Result updateCategory(Category category){

        boolean bool = categoryService.updateById(category);
        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 = categoryService.removeById(id);
        if(bool){
            return Result.success(true,"200","删除成功！");
        }
        return Result.error(false,null,"删除失败！");
    }
}

    /**
     * 登录页面跳转到后台首页
     * @return
     */
    @RequestMapping("/index")
    public String toIndex(){
        return "system/home/index";
    }

    /**
     * 登出  用的是shiro默认的logout
     * @param session
     * @return
     */
    @RequestMapping("/logout")
    public String logout(HttpSession session) {
        Subject subject = SecurityUtils.getSubject();
        subject.logout();
        return "redirect:login";
    }

    /**
     *跳转到首页工作台
     */
    @RequestMapping("/toDes")
    public String toDesktop(){
        return "system/home/desktopManager";
    }

    /**
     * 跳转到日志管理页面
     *
     */
    @RequestMapping("/toLog")
    public String toLog(){
        return "system/log/logsManager";
    }

    /**
     * 跳转到供应商管理页面
     *
     */
    @RequestMapping("/toProvider")
    public String toProvider(){
        return "system/provider/providerManager";
    }

    /**

            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 = inportService.removeById(id);
        if (bool) {
            return Result.success(true, "200", "删除成功！");
        }
        return Result.error(false, null, "删除失败！");
    }

    /**
     * 修改进货信息
     *
     * @param inport
     * @return
     */
    @SysLog("进货修改操作")
    @PostMapping("/updateinport")
    public Result updateGoods(Inport inport, HttpSession session) {

        User user = (User) session.getAttribute("username");
        inport.setOperateperson(user.getUname());
        inport.setInptime(new Date());
        boolean bool = inportService.updateById(inport);
        if (bool) {
            return Result.success(true, "200", "修改成功！");
        }
        return Result.error(false, null, "修改失败！");
    }

}

     */
    @SysLog("退货查询操作")
    @RequestMapping("/outportList")
    public DataGridViewResult outportList(OutportVO outportVO) {

        //创建分页信息    参数1 当前页  参数2 每页显示条数
        IPage<Outport> page = new Page<>(outportVO.getPage(), outportVO.getLimit());
        QueryWrapper<Outport> queryWrapper = new QueryWrapper<>();
        queryWrapper.eq(outportVO.getProviderid() != null && outportVO.getProviderid() != 0, "providerid", outportVO.getProviderid());
        queryWrapper.eq(outportVO.getGoodsid() != null && outportVO.getGoodsid() != 0, "goodsid", outportVO.getGoodsid());
        queryWrapper.ge(outportVO.getStartTime() != null, "outputtime", outportVO.getStartTime());
        queryWrapper.le(outportVO.getEndTime() != null, "outputtime", outportVO.getEndTime());

        queryWrapper.orderByDesc("outputtime");

        IPage<Outport> outportIPage = outportService.page(page, queryWrapper);

        List<Outport> records = outportIPage.getRecords();

        for (Outport outport : records) {
            Provider provider = providerService.getById(outport.getProviderid());

            if (null != provider) {
                outport.setProvidername(provider.getProvidername());
            }
            Goods goods = goodsService.getById(outport.getGoodsid());
            if (null != goods) {
                outport.setGoodsname(goods.getGname());
                outport.setGnumbering(goods.getGnumbering());
            }
        }
        return new DataGridViewResult(outportIPage.getTotal(), records);

    }

}

    @Autowired
    private OutportService outportService;

    @Autowired
    private GoodsService goodsService;

    @Autowired
    private InportService inportService;

    @Autowired
    private ProviderService providerService;

    /**
     * 添加退货信息
     *
     * @param id
     * @param number
     * @param remark
     * @return
     */
    @SysLog("退货添加操作")
    @RequestMapping("addOutport")
    public Result addOutport(Integer id, Integer number, String remark, HttpSession session) {
        try {
            outportService.addOutport(id, number, remark,session);
            return Result.success(true, "200", "添加成功！");
        } catch (Exception e) {
            e.printStackTrace();
            return Result.error(false, null, "添加失败！");
        }

    }

    /**
     * 退货查询
     *
     * @param
     * @return
     */
    @SysLog("退货查询操作")
    @RequestMapping("/outportList")

            //记录日志（姓名、操作时间、登陆ip、操作、操作类型）
            logsservice.save(logs);
        }
    }

}

/**
 * <p>
 *  服务实现类
 * </p>
 *
 */
@Service
@Transactional
public class OutportServiceImpl extends ServiceImpl<OutportMapper, Outport> implements OutportService {

        ServletRequestAttributes attributes = (ServletRequestAttributes) RequestContextHolder.getRequestAttributes();
        HttpServletRequest request = attributes.getRequest();
        String funcName = signature.getName();
        Logs logs = new Logs();
        if(sysLog != null) {
            //注解上的描述
            logs.setType(sysLog.value());
        }
        LoginUserVO user= (LoginUserVO) SecurityUtils.getSubject().getPrincipal();
        if (null!=user) {
            logs.setLtime(new Date());
            logs.setUname(user.getUser().getUsername());
            logs.setIp(request.getRemoteAddr());
            logs.setContent("执行的方法：" + funcName);
            //记录日志（姓名、操作时间、登陆ip、操作、操作类型）
            logsservice.save(logs);
        }
    }

}

/**
 * <p>

        }
        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;
                    }

     *
     * @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);

    }
}

@RestController
@RequestMapping("/report")

    /**
     * 跳转到用户管理页面
     * @return
     */
    @RequestMapping("/toUser")
    public String toUser() {
        return "system/user/userManager";
    }

    /**
     * 跳转到商品管理页面
     * @return
     */
    @RequestMapping("/toGoods")
    public String toGoods() {
        return "system/goods/goodsManager";
    }

    /**
     * 跳转到进货管理页面
     * @return
     */
    @RequestMapping("/toInport")
    public String toInport() {
        return "system/inport/inportManager";
    }

    /**
     * 跳转到退货管理页面
     * @return
     */
    @RequestMapping("/toOutport")
    public String toOutport() {
        return "system/outport/outportManager";
    }

    /**
     * 跳转到商品销售管理页面
     * @return
     */
    @RequestMapping("/toSale")
    public String toSale() {
        return "system/sale/saleManager";
    }

    /**
     * 跳转到权限管理页面
     * @return
     */
    @RequestMapping("/toPermission")
    public String toPermission() {
        return "system/permission/permissionManager";
    }
    /**
     * 跳转到权限管理页面-left
     * @return
     */
    @RequestMapping("/toPermissionLeft")
    public String toPermissionLeft() {
        return "system/permission/left";
    }
    /**
     * 跳转到权限管理页面-right
     * @return
     */
    @RequestMapping("/toPermissionRight")
    public String toPermissionRight() {
        return "system/permission/right";
    }

    /**
     * 跳转到角色管理页面
     * @return
     */
    @RequestMapping("/toRole")
    public String toRole() {
        return "system/role/roleManager";
    }

    /**
     * 跳转到用户管理页面
     * @return
     */
    @RequestMapping("/toUser")
    public String toUser() {
        return "system/user/userManager";
    }

    /**
     * 跳转到商品管理页面
     * @return
     */
    @RequestMapping("/toGoods")

    /**
     * 得到登陆验证码
     * @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());
    }

    /**

        }
        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) {

/**
 * <p>
 *  前端控制器
 * </p>
 *
 */
@RestController
@RequestMapping("/permission")
public class PermissionController {

    @Autowired
    private PermissionService permissionService;

    /**
     * 菜单列表
     * @param permissionVO
     * @return
     */
    @RequestMapping("/permissionList")
    public DataGridViewResult permissionList(PermissionVO permissionVO){

    @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,"添加失败！");
    }