请问老师这里没有数据 数据库有信息

同学你好，这里对比同学的代码，并没有什么问题。问一下同学新增一条数据是点击页面中的如下的新增添加数据，还是从数据库中直接插入的数据。

如果是从数据库直接插入的数据，建议同学点击页面中的新增，增加一条数据再试试。

另外问一下同学在没有增加积分之前可以显示商品吗？如果可以，建议同学清空缓存再试试。

祝：学习愉快~

@Controller

@RequestMapping("/shopadmin")

public class ProductManagementController {

@Autowired

private ProductService productService;

@Autowired

private ProductCategoryService productCategoryService;

// 支持上传商品详情图的最大数量

private static final int IMAGEMAXCOUNT = 6;

/**

* 通过店铺id获取该店铺下的商品列表

*

* @param request

* @return

*/

@RequestMapping(value = "/getproductlistbyshop", method = RequestMethod.GET)

@ResponseBody

private Map<String, Object> getProductListByShop(HttpServletRequest request) {

Map<String, Object> modelMap = new HashMap<String, Object>();

// 获取前台传过来的页码

int pageIndex = HttpServletRequestUtil.getInt(request, "pageIndex");

// 获取前台传过来的每页要求返回的商品数上限

int pageSize = HttpServletRequestUtil.getInt(request, "pageSize");

// 从当前session中获取店铺信息，主要是获取shopId

Shop currentShop = (Shop) request.getSession().getAttribute("currentShop");

// 空值判断

if ((pageIndex > -1) && (pageSize > -1) && (currentShop != null) && (currentShop.getShopId() != null)) {

// 获取传入的需要检索的条件，包括是否需要从某个商品类别以及模糊查找商品名去筛选某个店铺下的商品列表

// 筛选的条件可以进行排列组合

long productCategoryId = HttpServletRequestUtil.getLong(request, "productCategoryId");

String productName = HttpServletRequestUtil.getString(request, "productName");

Product productCondition = compactProductCondition(currentShop.getShopId(), productCategoryId, productName);

// 传入查询条件以及分页信息进行查询，返回相应商品列表以及总数

ProductExecution pe = productService.getProductList(productCondition, pageIndex, pageSize);

modelMap.put("productList", pe.getProductList());

modelMap.put("count", pe.getCount());

modelMap.put("success", true);

} else {

modelMap.put("success", false);

modelMap.put("errMsg", "empty pageSize or pageIndex or shopId");

}

return modelMap;

}

/**

* 通过商品id获取商品信息

*

* @param productId

* @return

*/

@RequestMapping(value = "/getproductbyid", method = RequestMethod.GET)

@ResponseBody

private Map<String, Object> getProductById(@RequestParam Long productId) {

Map<String, Object> modelMap = new HashMap<String, Object>();

// 非空判断

if (productId > -1) {

// 获取商品信息

Product product = productService.getProductById(productId);

// 获取该店铺下的商品类别列表

List<ProductCategory> productCategoryList = productCategoryService

.getProductCategoryList(product.getShop().getShopId());

modelMap.put("product", product);

modelMap.put("productCategoryList", productCategoryList);

modelMap.put("success", true);

} else {

modelMap.put("success", false);

modelMap.put("errMsg", "empty productId");

}

return modelMap;

}

@RequestMapping(value = "/addproduct", method = RequestMethod.POST)

@ResponseBody

private Map<String, Object> addProduct(HttpServletRequest request) {

Map<String, Object> modelMap = new HashMap<String, Object>();

// 验证码校验

if (!CodeUtil.checkVerifyCode(request)) {

modelMap.put("success", false);

modelMap.put("errMsg", "输入了错误的验证码");

return modelMap;

}

// 接收前端参数的变量的初始化，包括商品，缩略图，详情图列表实体类

ObjectMapper mapper = new ObjectMapper();

Product product = null;

ImageHolder thumbnail = null;

List<ImageHolder> productImgList = new ArrayList<ImageHolder>();

CommonsMultipartResolver multipartResolver = new CommonsMultipartResolver(

request.getSession().getServletContext());

try {

// 若请求中存在文件流，则取出相关的文件（包括缩略图和详情图）

if (multipartResolver.isMultipart(request)) {

thumbnail = handleImage(request, thumbnail, productImgList);

} else {

modelMap.put("success", false);

modelMap.put("errMsg", "上传图片不能为空");

return modelMap;

}

} catch (Exception e) {

modelMap.put("success", false);

modelMap.put("errMsg", e.toString());

return modelMap;

}

try {

String productStr = HttpServletRequestUtil.getString(request, "productStr");

// 尝试获取前端传过来的表单string流并将其转换成Product实体类

product = mapper.readValue(productStr, Product.class);

} catch (Exception e) {

modelMap.put("success", false);

modelMap.put("errMsg", e.toString());

return modelMap;

}

// 若Product信息，缩略图以及详情图列表为非空，则开始进行商品添加操作

if (product != null && thumbnail != null && productImgList.size() > 0) {

try {

// 从session中获取当前店铺的Id并赋值给product，减少对前端数据的依赖

Shop currentShop = (Shop) request.getSession().getAttribute("currentShop");

product.setShop(currentShop);

// 执行添加操作

ProductExecution pe = productService.addProduct(product, thumbnail, productImgList);

if (pe.getState() == ProductStateEnum.SUCCESS.getState()) {

modelMap.put("success", true);

} else {

modelMap.put("success", false);

modelMap.put("errMsg", pe.getStateInfo());

}

} catch (ProductOperationException e) {

modelMap.put("success", false);

modelMap.put("errMsg", e.toString());

return modelMap;

}

} else {

modelMap.put("success", false);

modelMap.put("errMsg", "请输入商品信息");

}

return modelMap;

}

private ImageHolder handleImage(HttpServletRequest request, ImageHolder thumbnail, List<ImageHolder> productImgList)

throws IOException {

MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;

// 取出缩略图并构建ImageHolder对象

CommonsMultipartFile thumbnailFile = (CommonsMultipartFile) multipartRequest.getFile("thumbnail");

if (thumbnailFile != null) {

thumbnail = new ImageHolder(thumbnailFile.getOriginalFilename(), thumbnailFile.getInputStream());

}

// 取出详情图列表并构建List<ImageHolder>列表对象，最多支持六张图片上传

for (int i = 0; i < IMAGEMAXCOUNT; i++) {

CommonsMultipartFile productImgFile = (CommonsMultipartFile) multipartRequest.getFile("productImg" + i);

if (productImgFile != null) {

// 若取出的第i个详情图片文件流不为空，则将其加入详情图列表

ImageHolder productImg = new ImageHolder(productImgFile.getOriginalFilename(),

productImgFile.getInputStream());

productImgList.add(productImg);

} else {

// 若取出的第i个详情图片文件流为空，则终止循环

break;

}

}

return thumbnail;

}

/**

* 商品编辑

*

* @param request

* @return

*/

@RequestMapping(value = "/modifyproduct", method = RequestMethod.POST)

@ResponseBody

private Map<String, Object> modifyProduct(HttpServletRequest request) {

Map<String, Object> modelMap = new HashMap<String, Object>();

// 是商品编辑时候调用还是上下架操作的时候调用

// 若为前者则进行验证码判断，后者则跳过验证码判断

boolean statusChange = HttpServletRequestUtil.getBoolean(request, "statusChange");

// 验证码判断

if (!statusChange && !CodeUtil.checkVerifyCode(request)) {

modelMap.put("success", false);

modelMap.put("errMsg", "输入了错误的验证码");

return modelMap;

}

// 接收前端参数的变量的初始化，包括商品，缩略图，详情图列表实体类

ObjectMapper mapper = new ObjectMapper();

Product product = null;

ImageHolder thumbnail = null;

List<ImageHolder> productImgList = new ArrayList<ImageHolder>();

CommonsMultipartResolver multipartResolver = new CommonsMultipartResolver(

request.getSession().getServletContext());

// 若请求中存在文件流，则取出相关的文件（包括缩略图和详情图）

try {

if (multipartResolver.isMultipart(request)) {

thumbnail = handleImage(request, thumbnail, productImgList);

}

} catch (Exception e) {

modelMap.put("success", false);

modelMap.put("errMsg", e.toString());

return modelMap;

}

try {

String productStr = HttpServletRequestUtil.getString(request, "productStr");

// 尝试获取前端传过来的表单string流并将其转换成Product实体类

product = mapper.readValue(productStr, Product.class);

} catch (Exception e) {

modelMap.put("success", false);

modelMap.put("errMsg", e.toString());

return modelMap;

}

// 非空判断

if (product != null) {

try {

// 从session中获取当前店铺的Id并赋值给product，减少对前端数据的依赖

Shop currentShop = (Shop) request.getSession().getAttribute("currentShop");

product.setShop(currentShop);

// 开始进行商品信息变更操作

ProductExecution pe = productService.modifyProduct(product, thumbnail, productImgList);

if (pe.getState() == ProductStateEnum.SUCCESS.getState()) {

modelMap.put("success", true);

} else {

modelMap.put("success", false);

modelMap.put("errMsg", pe.getStateInfo());

}

} catch (RuntimeException e) {

modelMap.put("success", false);

modelMap.put("errMsg", e.toString());

return modelMap;

}

} else {

modelMap.put("success", false);

modelMap.put("errMsg", "请输入商品信息");

}

return modelMap;

}