基于javaweb的超市进销存系统设计和实现(java+Springboot+ssm+mysql+jsp+maven)
一、项目简述
本系统主要实现的功能有： 用户管理，商品管理，销售管理，进货退货管理，仓库管 理等等功能。
二、项目运行
环境配置： Jdk1.8 + Tomcat8.5 + mysql + Eclispe (IntelliJ IDEA,Eclispe,MyEclispe,Sts 都支持)
项目技术： Springboot+ SpringMVC + MyBatis + ThymeLeaf + JavaScript + JQuery + Ajax + maven等等
* @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);
goods.setGoodsimg(newName);//删除原先的图片String oldPath = goodsService.getById(goods.getGid()).getGoodsimg();AppFileUtils.removeFileByPath(oldPath);}}boolean bool = goodsService.updateById(goods);if (bool) {return Result.success(true, "200", "修改成功！");}return Result.error(false, null, "修改失败！");}/*** 删除单条数据** @param id* @return*/@SysLog("商品删除操作")
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,"添加失败！");}/**
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);}
}品类信息控制层：/*** <p>* 前端控制器* </p>**/@RestController@RequestMapping("/category")public class CategoryController {@Autowiredprivate CategoryService categoryService;/*** 类别模糊查询* @param* @return
}商品信息控制层：/*** <p>* 前端控制器* </p>**/@RestController@RequestMapping("/goods")public class GoodsController {@Autowiredprivate GoodsService goodsService;@Autowiredprivate ProviderService providerService;@Autowiredprivate CategoryService categoryService;
*/@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);}
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","添加成功！");}
* 根据供应商查商品下拉框** @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);}}
* @param goodsid* @return*/@SysLog("类别添加操作")@RequestMapping("/saveGoodsCategory")public Result saveGoodsCategory(String categoryids, int goodsid) {try {if (goodsService.saveGoodsCategory(goodsid, categoryids)) {return Result.success(true, null, "分配成功");}} catch (Exception e) {e.printStackTrace();
** @return*/@RequestMapping("/loadAllGoods")public DataGridViewResult loadAllGoods() {QueryWrapper<Goods> queryWrapper = new QueryWrapper<>();List<Goods> list = goodsService.list(queryWrapper);return new DataGridViewResult(list);}/*** 根据供应商查商品下拉框*
queryWrapper.eq(goodsVO.getProviderid() != null && goodsVO.getProviderid() != 0, "providerid", goodsVO.getProviderid());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("商品添加操作")
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){
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);}} catch (Exception e) {e.printStackTrace();}return new DataGridViewResult(Long.valueOf(mapList.size()), mapList);}/*** 根据商品id加载商品信息* @param goodsid
* @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","删除成功！");
List<Goods> list = goodsService.list(queryWrapper);return new DataGridViewResult(list);}/*** 根据供应商查商品下拉框** @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());}
}用户信息控制层：/*** <p>* 前端控制器* </p>**/@RestController@RequestMapping("/customer")public class CustomerController {@Autowiredprivate CustomerService customerService;/**
* @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);
@RestController@RequestMapping("/customer")public class CustomerController {@Autowiredprivate CustomerService customerService;/*** 客户模糊查询* @param* @return*/@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 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","修改成功！");}return Result.error(false,null,"修改失败！");}/*** 删除单条数据
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","添加成功！");}
public class CustomerController {@Autowiredprivate CustomerService customerService;/*** 客户模糊查询* @param* @return*/@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());}
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*/@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);}
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,"添加失败！");}/*** 修改客户信息
}return Result.error(false,null,"删除失败！");}}用户信息控制层：/*** <p>* 前端控制器* </p>**/@RestController@RequestMapping("/customer")public class CustomerController {@Autowiredprivate CustomerService customerService;/*** 客户模糊查询* @param* @return*/@SysLog("客户查询操作")
}/*** 修改类别信息* @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);
