基于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+mysql的SpringBoot超市进销存系统设计和实现(java+springboot+ssm+mysql+html+maven)

一、项目简述

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

二、项目运行

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

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

        //分页构造函数
        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
    @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";
    }

    /**
     * 跳转到客户管理页面
     * @return
     */
    @RequestMapping("/toCustomer")
    public String toCustomer(){
        return "system/customer/customerManager";
    }

    /**
     * 跳转到商品类别管理页面
     * @return
     */
    @RequestMapping("/toCategory")
    public String toCategory(){
        return "system/category/categoryManager";
    }

    /**

    }

    /**
     * 退货查询
     *
     * @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) {
                outport.setGoodsname(goods.getGname());
                outport.setGnumbering(goods.getGnumbering());
            }
        }
        return new DataGridViewResult(outportIPage.getTotal(), records);

    }

}

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

    /**
     *
     * 加载下拉框
     * @return
     */
    @RequestMapping("/loadAllProvider")
    public DataGridViewResult loadAllProvider(){
        QueryWrapper<Provider> queryWrapper = new QueryWrapper<>();
        List<Provider> list = providerService.list(queryWrapper);
        return new DataGridViewResult(list);

    }

}


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

    @Resource
    private InportMapper inportMapper;

    @Resource
    private GoodsMapper goodsMapper;

    /**
     * 自定义退货方法
     * @param id
     * @param number
     * @param remark
     */
    @Override
    public void addOutport(Integer id, Integer number, String remark, HttpSession session) {
        User user = (User) session.getAttribute("username");
        //进货信息查询
        Inport inport = inportMapper.selectById(id);
        //查询商品信息
        Goods goods = goodsMapper.selectById(inport.getGoodsid());
        if (goods.getGquantity()>=number){
            //更新库存
            goods.setGquantity(goods.getGquantity()-number);
     * @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);
            }
     * @param number
     * @param remark
     */
    @Override
    public void addOutport(Integer id, Integer number, String remark, HttpSession session) {
        User user = (User) session.getAttribute("username");
        //进货信息查询
        Inport inport = inportMapper.selectById(id);
        //查询商品信息
        Goods goods = goodsMapper.selectById(inport.getGoodsid());
        if (goods.getGquantity()>=number){
            //更新库存
            goods.setGquantity(goods.getGquantity()-number);
            goodsMapper.updateById(goods);
            //添加退货单信息
            Outport outport = new Outport();
            outport.setGoodsid(goods.getGid());
            outport.setOutputtime(new Date());
            outport.setRemark(remark);
            outport.setOperateperson(user.getUname());
            outport.setOutprice(inport.getInpprice()*number);
            outport.setProviderid(inport.getProviderid());
            outport.setNumber(number);
            baseMapper.insert(outport);
        }else {

        }

    }
}

     * 类别批量删除
     * @param ids
     * @return
     */
    @SysLog("类别删除操作")
    @RequestMapping("/deleteList")
    public Result deleteList(String ids) {
        //将字符串拆分成数组
        String[] idsStr = ids.split(",");
        List<String> list = Arrays.asList(idsStr);
        boolean bool = categoryService.removeByIds(list);
        if(bool){
            return Result.success(true,"200","删除成功!");
        }
        return Result.error(false,null,"删除失败!");
    }

    /**
     * 添加类别信息
     * @param category
     * @return
     */
    @SysLog("类别添加操作")
    @PostMapping("/addcategory")
    public Result addCategory(Category category){
        boolean bool = categoryService.save(category);
        if(bool){
            return Result.success(true,"200","添加成功!");
        }
        return Result.error(false,null,"添加失败!");
    }

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

        boolean bool = categoryService.updateById(category);
        if(bool){
            return Result.success(true,"200","修改成功!");
        }

    /**
     * 删除单条数据
     *
     * @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("123456", 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, "重置失败!");
    }

    public Result addProvider(Provider provider, HttpSession session){
        User user = (User) session.getAttribute("username");
        provider.setOpername(user.getUname());
        boolean bool = providerService.save(provider);
        if(bool){
            return Result.success(true,"200","添加成功!");
        }
        return Result.error(false,null,"添加失败!");
    }

    /**
     * 修改供应商信息
     * @param provider
     * @return
     */
    @SysLog("供应商修改操作")
    @PostMapping("/updateprovider")
    public Result updateProvider(Provider provider){

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

    }

}

@Controller
public class JumpController {

    @Autowired
    private UserService userService;

    @Autowired
    private RoleService roleService;

    /**
     * 登录
     *
     * @param username 用户名
     * @param password 密码
     * @param request
     * @return
     */

    @SysLog("登录操作")
    @PostMapping("/login")
    public Result login(String username, String password, String code,HttpServletRequest request) {
        try {

            if (!(request.getSession().getAttribute("code")+"").equalsIgnoreCase(code+"")) {
                return Result.error(false, "400", "登录失败,验证码错误");
            }

            //获取当前登录主体对象
            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
}

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

    @Autowired
    private ProviderService providerService;

    /**
     * 供应商模糊查询
     * @param
     * @return
     */
    @SysLog("供应商查询操作")
    @RequestMapping("/providerList")
    public DataGridViewResult providerList(ProviderVO providerVO) {

        //创建分页信息    参数1 当前页  参数2 每页显示条数
        IPage<Provider> page = new Page<>(providerVO.getPage(), providerVO.getLimit());
            logsservice.save(logs);
        }
    }

}

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

    @Resource
    private InportMapper inportMapper;

    @Resource
    private GoodsMapper goodsMapper;

    /**
     * 自定义退货方法
     * @param id
            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);
        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);

请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值