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

运行环境

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

开发工具

后端:eclipse/idea/myeclipse/sts等均可配置运行
前端:WebStorm/VSCode/HBuilderX等均可

❗没学过node.js的不要搞前后端分离项目

适用

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

功能说明

131924220701

141924220701

151924220701

161924220701

171924220701

181924220701

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

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

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

前端,技术涉及vue、vuex、element
后端,技术涉及springboot、mybatis-plus

登录:
admin 123456 超级管理员-老王
manager 123456 管理员-小张
emp 123456 普通帐号-二狗

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
    //查询
@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();
}
}


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48


/**
* <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();
}
//查询
@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);
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36


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);
// }
// 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();
}
}


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
    @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);

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();
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
 */
@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);
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
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();
}
//修改
@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){


项目链接:
https://javayms.github.io?id=121924220701201kv
https://javayms.pages.dev?id=121924220701201kv