基于javaweb+mysql的springboot仓库管理系统出库入库管理(java+springboot+maven+mybatis+elementui+vue+mysql)

本文链接：https://blog.youkuaiyun.com/2301_81060862/article/details/138401295

私信源码获取及调试交流

运行环境

Java≥8、MySQL≥5.7、Node.js≥10

开发工具

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

前端：WebStorm/VSCode/HBuilderX等均可

适用

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

功能说明

基于javaweb的SpringBoot仓库管理系统出库入库管理(java+springboot+maven+mybatis+elementui+vue+mysql)

一个vue+springboot的前后端分离仓库管理系统

适合初学者，可当课程设计、毕业设计

前端，技术涉及vue、vuex、element

后端，技术涉及springboot、mybatis-plus

admin 123456 超级管理员-老王

manager 123456 管理员-小张

emp 123456 普通帐号-二狗

        if(StringUtils.isNotBlank(name) && !"null".equals(name)) {
            lambdaQueryWrapper.like(User::getName, name);
        }
        if(StringUtils.isNotBlank(sex) && !"null".equals(sex)) {
            lambdaQueryWrapper.eq(User::getSex, sex);
        }
        if(StringUtils.isNotBlank(roleId) && !"null".equals(roleId)) {
            lambdaQueryWrapper.eq(User::getRoleId, roleId);
        }
        IPage result = userService.page(page, lambdaQueryWrapper);

        return Result.suc(result.getRecords(), result.getTotal());
    }

}

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

                .eq(User::getPassword,user.getPassword()).list();

        if(list.size()>0){
            User user1 = list.get(0);
            List<Menu> list1 = menuService.lambdaQuery().like(Menu::getMenuRight, user1.getRoleId()).list();
            HashMap<String,Object> hashMap = new HashMap<String,Object>();
            hashMap.put("user",user1);
            hashMap.put("menu",list1);
            return Result.suc(hashMap);
        }
        return Result.fail();
    }
    //修改
    @PostMapping("/mod")
    public boolean mod(@RequestBody User user){
        return userService.updateById(user);
    }
    //新增或修改
    @PostMapping("/saveOrMod")
    public boolean saveOrMod(@RequestBody User user){
        return userService.saveOrUpdate(user);
    }
    //删除
    @GetMapping("/delete")
    public boolean delete(Integer id){
        return userService.removeById(id);
    }
    //删除
    @GetMapping("/del")
    public Result del(Integer id){
        return userService.removeById(id) ? Result.suc() : Result.fail();
    }
    //查询（模糊、匹配）
    @PostMapping("/listP")
    public List<User> listP(@RequestBody User user){
        LambdaQueryWrapper<User> lambdaQueryWrapper = new LambdaQueryWrapper<>();
        if(StringUtils.isNotBlank(user.getName())){
            lambdaQueryWrapper.like(User::getName,user.getName());
        }
        return userService.list(lambdaQueryWrapper);
    }

    @PostMapping("/listPage")
    public List<User> listPage(@RequestBody QueryPageParam queryPageParam){
//        Page<User> page = new Page<>(1,2);
        Page<User> page = new Page<>();
        page.setCurrent(queryPageParam.getPageNum());
        page.setSize(queryPageParam.getPageSize());

        String name = (String) queryPageParam.getParam().get("name");

        LambdaQueryWrapper<User> lambdaQueryWrapper = new LambdaQueryWrapper<>();
        lambdaQueryWrapper.like(User::getName,name);

    //新增
    @PostMapping("/save")
    public Result save(@RequestBody Storage storage){
        return storageService.save(storage)? Result.suc() : Result.fail();
    }
    //更新
    @PostMapping("/update")
    public Result update(@RequestBody Storage storage){
        return storageService.updateById(storage) ? Result.suc() : Result.fail();
    }
    //删除
    @GetMapping("/del")
    public Result del(Integer id){
        return storageService.removeById(id) ? Result.suc() : Result.fail();
    }
    //查询
    @PostMapping("/listPageP")
    public Result listPageP(@RequestBody QueryPageParam queryPageParam){
//        Page<User> page = new Page<>(1,2);
        Page<Storage> page = new Page<>();
        page.setCurrent(queryPageParam.getPageNum());
        page.setSize(queryPageParam.getPageSize());

        String name = (String) queryPageParam.getParam().get("name");
        String remark = (String) queryPageParam.getParam().get("remark");

        LambdaQueryWrapper<Storage> lambdaQueryWrapper = new LambdaQueryWrapper<>();
        if(StringUtils.isNotBlank(name) && !"null".equals(name)) {
            lambdaQueryWrapper.like(Storage::getName, name);
        }
        if(StringUtils.isNotBlank(remark) && !"null".equals(remark)) {
            lambdaQueryWrapper.eq(Storage::getRemark, remark);
        }
        IPage result = storageService.page(page, lambdaQueryWrapper);

        return Result.suc(result.getRecords(), result.getTotal());
    }
    @GetMapping("findByName")
    public Result findByName(String name){
        List<Storage> list = storageService.lambdaQuery().eq(Storage::getName, name).list();
        return list.size()>0 ? Result.suc(list) : Result.fail();

        }
        if(StringUtils.isNotBlank(remark) && !"null".equals(remark)) {
            lambdaQueryWrapper.eq(Storage::getRemark, remark);
        }
        IPage result = storageService.page(page, lambdaQueryWrapper);

        return Result.suc(result.getRecords(), result.getTotal());
    }
    @GetMapping("findByName")
    public Result findByName(String name){
        List<Storage> list = storageService.lambdaQuery().eq(Storage::getName, name).list();
        return list.size()>0 ? Result.suc(list) : Result.fail();
    }
    @GetMapping("list")
    public Result list(){
        List<Storage> list = storageService.list();
        return list.size()>0 ? Result.suc(list) : Result.fail();
    }
}

/**
 * <p>
 *  前端控制器
 * </p>
 *
 */
@RestController
@RequestMapping("/menu")
public class MenuController {
    @Autowired
    private MenuService menuService;
    @GetMapping("list")
    public Result list(@RequestParam String roleId){
        List<Menu> list = menuService.lambdaQuery().like(Menu::getMenuRight, roleId).list();
        return list.size()>0 ? Result.suc(list) : Result.fail();
    }

    public Result list(){
        List<Goodstype> list = goodstypeService.list();
        return list.size()>0 ? Result.suc(list) : Result.fail();
    }
}

/**
 * <p>
 *  前端控制器
 * </p>
 *
 */
@RestController
@RequestMapping("/record")
public class RecordController {
    @Autowired
    private RecordService recordService;
    @Autowired
    private GoodsService goodsService;

    //查询
    @PostMapping("/listPageP")
    public Result listPageP(@RequestBody QueryPageParam queryPageParam){
        Page<Record> page = new Page<>();
        page.setCurrent(queryPageParam.getPageNum());
        page.setSize(queryPageParam.getPageSize());

        String Goodsname = (String) queryPageParam.getParam().get("name");
        String storage =  (String)queryPageParam.getParam().get("storage");
        String goodsType =(String)queryPageParam.getParam().get("goodsType");


/**
 * <p>
 *  前端控制器
 * </p>
 *
 */
@RestController
@RequestMapping("/storage")
public class StorageController {
    @Autowired
    private StorageService storageService;

    //新增或修改
    @PostMapping("/saveOrMod")
    public Result saveOrMod(@RequestBody Storage storage){
        return storageService.saveOrUpdate(storage) ? Result.suc() : Result.fail();
    }
    //新增
    @PostMapping("/save")
    public Result save(@RequestBody Storage storage){
        return storageService.save(storage)? Result.suc() : Result.fail();
    }
    //更新
    @PostMapping("/update")
    public Result update(@RequestBody Storage storage){
        return storageService.updateById(storage) ? Result.suc() : Result.fail();
    }
    //删除
    @GetMapping("/del")
    public Result del(Integer id){
        return storageService.removeById(id) ? Result.suc() : Result.fail();
    }

        return storageService.updateById(storage) ? Result.suc() : Result.fail();
    }
    //删除
    @GetMapping("/del")
    public Result del(Integer id){
        return storageService.removeById(id) ? Result.suc() : Result.fail();
    }
    //查询
    @PostMapping("/listPageP")
    public Result listPageP(@RequestBody QueryPageParam queryPageParam){
//        Page<User> page = new Page<>(1,2);
        Page<Storage> page = new Page<>();
        page.setCurrent(queryPageParam.getPageNum());
        page.setSize(queryPageParam.getPageSize());

        String name = (String) queryPageParam.getParam().get("name");
        String remark = (String) queryPageParam.getParam().get("remark");

        LambdaQueryWrapper<Storage> lambdaQueryWrapper = new LambdaQueryWrapper<>();
        if(StringUtils.isNotBlank(name) && !"null".equals(name)) {
            lambdaQueryWrapper.like(Storage::getName, name);
        }
        if(StringUtils.isNotBlank(remark) && !"null".equals(remark)) {
            lambdaQueryWrapper.eq(Storage::getRemark, remark);
        }
        IPage result = storageService.page(page, lambdaQueryWrapper);

        return Result.suc(result.getRecords(), result.getTotal());
    }
    @GetMapping("findByName")
    public Result findByName(String name){
        List<Storage> list = storageService.lambdaQuery().eq(Storage::getName, name).list();
        return list.size()>0 ? Result.suc(list) : Result.fail();
    }
    @GetMapping("list")
    public Result list(){
        List<Storage> list = storageService.list();
        return list.size()>0 ? Result.suc(list) : Result.fail();
    }
}

//            queryWrapper.like("g1.name",Goodsname);
        }
//        if(StringUtils.isNotBlank(storage) && !"null".equals(storage)) {
//            lambdaQueryWrapper.eq(Goods::getStorage, storage);
//        }
//        if(StringUtils.isNotBlank(goodsType) && !"null".equals(goodsType)) {
//            lambdaQueryWrapper.eq(Goods::getGoodsType, goodsType);
//        }
        IPage result = recordService.pageC(page, queryWrapper);

        return Result.suc(result.getRecords(), result.getTotal());
    }
    //新增
    @PostMapping("/save")
    public Result save(@RequestBody Record record){
        Goods goods = goodsService.getById(record.getGoods());
        Integer n = record.getCount();
        //出库
        if(record.getAction().equals("2")){
            n = -n;
        }
        int i = goods.getCount()+ n;
        goods.setCount(i);
        goods.setRemark(record.getRemark());
        goodsService.updateById(goods);

        return recordService.save(record)? Result.suc() : Result.fail();
    }
}


/**
 * <p>
 *  前端控制器
 * </p>
 *
 */
@RestController
@RequestMapping("/record")
public class RecordController {
    @Autowired
    private RecordService recordService;
    @Autowired
    private GoodsService goodsService;

    //查询
    @PostMapping("/listPageP")
    public Result listPageP(@RequestBody QueryPageParam queryPageParam){
        Page<Record> page = new Page<>();
        page.setCurrent(queryPageParam.getPageNum());
        page.setSize(queryPageParam.getPageSize());

        String Goodsname = (String) queryPageParam.getParam().get("name");
        String storage =  (String)queryPageParam.getParam().get("storage");

            List<Menu> list1 = menuService.lambdaQuery().like(Menu::getMenuRight, user1.getRoleId()).list();
            HashMap<String,Object> hashMap = new HashMap<String,Object>();
            hashMap.put("user",user1);
            hashMap.put("menu",list1);
            return Result.suc(hashMap);
        }
        return Result.fail();
    }
    //修改
    @PostMapping("/mod")
    public boolean mod(@RequestBody User user){
        return userService.updateById(user);
    }
    //新增或修改
    @PostMapping("/saveOrMod")
    public boolean saveOrMod(@RequestBody User user){
        return userService.saveOrUpdate(user);
    }
    //删除
    @GetMapping("/delete")
    public boolean delete(Integer id){
        return userService.removeById(id);
    }
    //删除
    @GetMapping("/del")
    public Result del(Integer id){
        return userService.removeById(id) ? Result.suc() : Result.fail();
    }
    //查询（模糊、匹配）
    @PostMapping("/listP")
    public List<User> listP(@RequestBody User user){
        LambdaQueryWrapper<User> lambdaQueryWrapper = new LambdaQueryWrapper<>();
        if(StringUtils.isNotBlank(user.getName())){
            lambdaQueryWrapper.like(User::getName,user.getName());
        }
        return userService.list(lambdaQueryWrapper);
    }

    @PostMapping("/listPage")
    public List<User> listPage(@RequestBody QueryPageParam queryPageParam){

@RestController
@RequestMapping("/user")
public class UserController {
    @Autowired
    private UserService userService;
    @Autowired
    private MenuService menuService;
    @GetMapping("1")
    public List<User> list(){
        return userService.list();
    }
    @GetMapping("findByNo")
    public Result findByNo(String no){
        List<User> list = userService.lambdaQuery().eq(User::getNo, no).list();
        return list.size()>0 ? Result.suc(list) : Result.fail();
    }
    //新增
    @PostMapping("/save")
    public Result save(@RequestBody User user){
        return userService.save(user)? Result.suc() : Result.fail();
    }
    //更新
    @PostMapping("/update")
    public Result update(@RequestBody User user){
        return userService.updateById(user) ? Result.suc() : Result.fail();
    }
    //登录
    @PostMapping("/login")
    public Result login(@RequestBody User user){
        List<User> list = userService.lambdaQuery()
                .eq(User::getNo,user.getNo())
                .eq(User::getPassword,user.getPassword()).list();

        if(list.size()>0){
            User user1 = list.get(0);
            List<Menu> list1 = menuService.lambdaQuery().like(Menu::getMenuRight, user1.getRoleId()).list();
            HashMap<String,Object> hashMap = new HashMap<String,Object>();
            hashMap.put("user",user1);
            hashMap.put("menu",list1);
            return Result.suc(hashMap);
        }
        return Result.fail();
    }

 *  前端控制器
 * </p>
 *
 */
@RestController
@RequestMapping("/storage")
public class StorageController {
    @Autowired
    private StorageService storageService;

    //新增或修改
    @PostMapping("/saveOrMod")
    public Result saveOrMod(@RequestBody Storage storage){
        return storageService.saveOrUpdate(storage) ? Result.suc() : Result.fail();
    }
    //新增
    @PostMapping("/save")
    public Result save(@RequestBody Storage storage){
        return storageService.save(storage)? Result.suc() : Result.fail();
    }
    //更新
    @PostMapping("/update")
    public Result update(@RequestBody Storage storage){
        return storageService.updateById(storage) ? Result.suc() : Result.fail();
    }
    //删除
    @GetMapping("/del")
    public Result del(Integer id){
        return storageService.removeById(id) ? Result.suc() : Result.fail();
    }
    //查询
    @PostMapping("/listPageP")
    public Result listPageP(@RequestBody QueryPageParam queryPageParam){
//        Page<User> page = new Page<>(1,2);
        Page<Storage> page = new Page<>();
        page.setCurrent(queryPageParam.getPageNum());
        page.setSize(queryPageParam.getPageSize());

        String name = (String) queryPageParam.getParam().get("name");
        String remark = (String) queryPageParam.getParam().get("remark");

        LambdaQueryWrapper<Storage> lambdaQueryWrapper = new LambdaQueryWrapper<>();
        if(StringUtils.isNotBlank(name) && !"null".equals(name)) {
            lambdaQueryWrapper.like(Storage::getName, name);
        }
        if(StringUtils.isNotBlank(remark) && !"null".equals(remark)) {
            lambdaQueryWrapper.eq(Storage::getRemark, remark);
        }
        IPage result = storageService.page(page, lambdaQueryWrapper);

    public Result del(Integer id){
        return goodstypeService.removeById(id) ? Result.suc() : Result.fail();
    }
    //查询
    @PostMapping("/listPageP")
    public Result listPageP(@RequestBody QueryPageParam queryPageParam){
//        Page<User> page = new Page<>(1,2);
        Page<Goodstype> page = new Page<>();
        page.setCurrent(queryPageParam.getPageNum());
        page.setSize(queryPageParam.getPageSize());

        String name = (String) queryPageParam.getParam().get("name");
        String remark = (String) queryPageParam.getParam().get("remark");

        LambdaQueryWrapper<Goodstype> lambdaQueryWrapper = new LambdaQueryWrapper<>();
        if(StringUtils.isNotBlank(name) && !"null".equals(name)) {
            lambdaQueryWrapper.like(Goodstype::getName, name);
        }
        if(StringUtils.isNotBlank(remark) && !"null".equals(remark)) {
            lambdaQueryWrapper.eq(Goodstype::getRemark, remark);
        }
        IPage result = goodstypeService.page(page, lambdaQueryWrapper);

        return Result.suc(result.getRecords(), result.getTotal());
    }
    @GetMapping("findByName")
    public Result findByName(String name){
        List<Goodstype> list = goodstypeService.lambdaQuery().eq(Goodstype::getName, name).list();
        return list.size()>0 ? Result.suc(list) : Result.fail();
    }
    @GetMapping("list")
    public Result list(){
        List<Goodstype> list = goodstypeService.list();
        return list.size()>0 ? Result.suc(list) : Result.fail();
    }
}


/**
 * <p>
 *  前端控制器
 * </p>
 *
 */
@RestController
@RequestMapping("/user")
public class UserController {
    @Autowired
    private UserService userService;
    @Autowired
    private MenuService menuService;
    @GetMapping("1")
    public List<User> list(){
        return userService.list();
    }
    @GetMapping("findByNo")
    public Result findByNo(String no){
        List<User> list = userService.lambdaQuery().eq(User::getNo, no).list();
        return list.size()>0 ? Result.suc(list) : Result.fail();
    }
    //新增
    @PostMapping("/save")
    public Result save(@RequestBody User user){
        return userService.save(user)? Result.suc() : Result.fail();
    }
    //更新
    @PostMapping("/update")
    public Result update(@RequestBody User user){
        return userService.updateById(user) ? Result.suc() : Result.fail();
    }
    //登录

        return goodsService.removeById(id) ? Result.suc() : Result.fail();
    }
    //查询
    @PostMapping("/listPageP")
    public Result listPageP(@RequestBody QueryPageParam queryPageParam){
//        Page<User> page = new Page<>(queryPageParam.getPageNum(),queryPageParam.getPageSize());
        Page<Goods> page = new Page<>();
        page.setCurrent(queryPageParam.getPageNum());
        page.setSize(queryPageParam.getPageSize());

        String Goodsname = (String) queryPageParam.getParam().get("name");
        String storage =  (String)queryPageParam.getParam().get("storage");
        String goodsType =(String)queryPageParam.getParam().get("goodsType");

        QueryWrapper<Goods> queryWrapper = new QueryWrapper<>();
        queryWrapper.apply("g1.storage = s.id and g1.goodstype = g2.id");
        if(StringUtils.isNotBlank(Goodsname) && !"null".equals(Goodsname)) {
            queryWrapper.like("g1.name",Goodsname);
        }
        if(StringUtils.isNotBlank(storage) && !"null".equals(storage)) {
            queryWrapper.eq("s.id",Integer.parseInt(storage));
        }
        if(StringUtils.isNotBlank(goodsType) && !"null".equals(goodsType)) {
            queryWrapper.eq("g2.id",Integer.parseInt(goodsType));
        }
        IPage result = goodsService.pageC(page, queryWrapper);

        return Result.suc(result.getRecords(), result.getTotal());
    }
    @GetMapping("findByName")
    public Result findByName(String name){
        List<Goods> list = goodsService.lambdaQuery().eq(Goods::getName, name).list();
        return list.size()>0 ? Result.suc(list) : Result.fail();
    }
}

        if(StringUtils.isNotBlank(Goodsname) && !"null".equals(Goodsname)) {
//            queryWrapper.like("g1.name",Goodsname);
        }
//        if(StringUtils.isNotBlank(storage) && !"null".equals(storage)) {
//            lambdaQueryWrapper.eq(Goods::getStorage, storage);
//        }
//        if(StringUtils.isNotBlank(goodsType) && !"null".equals(goodsType)) {
//            lambdaQueryWrapper.eq(Goods::getGoodsType, goodsType);
//        }
        IPage result = recordService.pageC(page, queryWrapper);

        return Result.suc(result.getRecords(), result.getTotal());
    }
    //新增
    @PostMapping("/save")
    public Result save(@RequestBody Record record){
        Goods goods = goodsService.getById(record.getGoods());
        Integer n = record.getCount();
        //出库
        if(record.getAction().equals("2")){
            n = -n;
        }
        int i = goods.getCount()+ n;
        goods.setCount(i);
        goods.setRemark(record.getRemark());
        goodsService.updateById(goods);

        return recordService.save(record)? Result.suc() : Result.fail();
    }
}


/**
 * <p>
 *  前端控制器
 * </p>
 *
 */
@RestController
@RequestMapping("/record")
public class RecordController {
    @Autowired
    private RecordService recordService;
    @Autowired
    private GoodsService goodsService;

    //查询
    @PostMapping("/listPageP")
    public Result listPageP(@RequestBody QueryPageParam queryPageParam){
        Page<Record> page = new Page<>();
        page.setCurrent(queryPageParam.getPageNum());
        page.setSize(queryPageParam.getPageSize());

        String Goodsname = (String) queryPageParam.getParam().get("name");
        String storage =  (String)queryPageParam.getParam().get("storage");
        String goodsType =(String)queryPageParam.getParam().get("goodsType");

        QueryWrapper<Record> queryWrapper = new QueryWrapper<>();
        queryWrapper.apply("r.goods=g.id and u.id=r.userId and u1.id=r.adminId and s.id=g.storage and g2.id=g.goodsType");
        if(StringUtils.isNotBlank(Goodsname) && !"null".equals(Goodsname)) {
//            queryWrapper.like("g1.name",Goodsname);
        }
//        if(StringUtils.isNotBlank(storage) && !"null".equals(storage)) {
//            lambdaQueryWrapper.eq(Goods::getStorage, storage);

请添加图片描述