springboot秒杀课程学习整理1-4

1）商品模型设计

      （应该是先设计商品的model，然后才是数据库表）

      模型字段（id,title,price(double),stock(库存),description,sales,imgUrl）

      创建表   item(id,title,price,description,sales,imgUrl)

                    item_stock(id,stock,item_id)

2)  使用mybatis-generator生成dataObject及dao文件

     【1】 这里需要修改pom文件里的插件配置，将overwrite改成false不允许覆盖（否则之前修改的文件都        会被覆盖掉）

     【2】修改mybatis_generator.xml文件，将原来已经生成过的注释掉新增生成的表的配置

     【3】执行mybatis-generator命令

3)  生成的Mapping文件插入数据不会返回id

    可以在该方法加上一下几个属性

useGeneratedKeys="true" keyColumn="SUBJECT_ID" keyProperty="subjectId"

4）存中文进入数据库是会乱码

      新建数据库时要设置字符集，然后连接数据库的链接添加useUnicode=true&characterEncoding=utf8

5）获取商品列表实现

      在itemMapping的xml文件里添加sql查询语句，这里暂时不支持分页，后续补上

<select id="listItem" resultMap="BaseResultMap">
    select
    <include refid="Base_Column_List" />
    from item order by sales DESC;
  </select>

itemService

package com.miaoshaproject.service;

import com.miaoshaproject.error.BusinessException;
import com.miaoshaproject.service.model.ItemModel;

import java.util.List;

public interface ItemService {
    //创建商品
    ItemModel createItem(ItemModel itemModel) throws BusinessException;

    //商品列表浏览
    List<ItemModel> listItem();
    //商品详情预览
    ItemModel getItemById(Integer id);
}

   itemServiceImpl

package com.miaoshaproject.service.impl;

import com.miaoshaproject.dao.ItemDOMapper;
import com.miaoshaproject.dao.StockDOMapper;
import com.miaoshaproject.dataobject.ItemDO;
import com.miaoshaproject.dataobject.StockDO;
import com.miaoshaproject.error.BusinessException;
import com.miaoshaproject.error.EmBusinessError;
import com.miaoshaproject.service.ItemService;
import com.miaoshaproject.service.model.ItemModel;
import com.miaoshaproject.validator.ValidationResult;
import com.miaoshaproject.validator.ValidatorImpl;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.math.BigDecimal;
import java.util.List;
import java.util.stream.Collectors;

@Service
public class ItemServiceImpl implements ItemService {
    @Autowired
    private ValidatorImpl validator;
    @Autowired
    private ItemDOMapper itemDOMapper;
    @Autowired
    private StockDOMapper stockDOMapper;
    @Override
    @Transactional //?不懂
    public ItemModel createItem(ItemModel itemModel) throws BusinessException {
        ValidationResult result=validator.validate(itemModel);
        if(result.isHasError()){
            throw new BusinessException(EmBusinessError.PARAMTER_VALIDATION_ERROR,result.getErrMsg());
        }
        ItemDO itemDO=this.convertItemDOFromItemModel(itemModel);
        itemDOMapper.insertSelective(itemDO);
        itemModel.setId(itemDO.getId());
        StockDO stockDO=this.convertItemStockFromItemModel(itemModel);
        stockDOMapper.insertSelective(stockDO);
        return this.getItemById(itemModel.getId());
    }

    @Override
    public List<ItemModel> listItem() {
        List<ItemDO> itemDOList =itemDOMapper.listItem();
        List<ItemModel> itemModelList= itemDOList.stream().map(itemDO ->{
            StockDO stockDO = stockDOMapper.selectByItemId(itemDO.getId());
            ItemModel itemModel=this.converItemModelFromItemDO(itemDO,stockDO);
            return itemModel;
        }).collect(Collectors.toList());
        return itemModelList;
    }

    @Override
    public ItemModel getItemById(Integer id) {
        ItemDO itemDO=itemDOMapper.selectByPrimaryKey(id);
        if(itemDO == null){
            return null;
        }
        StockDO stockDO=stockDOMapper.selectByItemId(itemDO.getId());
        ItemModel itemModel=this.converItemModelFromItemDO(itemDO,stockDO);
        return itemModel;
    }

    public ItemDO convertItemDOFromItemModel(ItemModel itemModel){
        if(itemModel==null){
            return null;
        };
        ItemDO itemDO=new ItemDO();
        BeanUtils.copyProperties(itemModel,itemDO);
        itemDO.setPrice(itemModel.getPrice().doubleValue());
        return itemDO;
    }
    public StockDO convertItemStockFromItemModel(ItemModel itemModel){
        StockDO stockDO=new StockDO();
        stockDO.setItemId(itemModel.getId());
        stockDO.setStock(itemModel.getStock());

        return stockDO;
    }
    public ItemModel converItemModelFromItemDO(ItemDO itemDO,StockDO stockDO){
        ItemModel itemModel=new ItemModel();
        BeanUtils.copyProperties(itemDO,itemModel);
        itemModel.setPrice(new BigDecimal(itemDO.getPrice()));
        itemModel.setStock(stockDO.getStock());
        return itemModel;
    }

}

  itemController

package com.miaoshaproject.controller;

import com.miaoshaproject.controller.viewobject.ItemVO;
import com.miaoshaproject.error.BusinessException;
import com.miaoshaproject.response.CommonReturnType;
import com.miaoshaproject.service.impl.ItemServiceImpl;
import com.miaoshaproject.service.model.ItemModel;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.math.BigDecimal;
import java.util.List;
import java.util.stream.Collectors;

@RestController
@RequestMapping("/item")
@CrossOrigin(allowCredentials = "true",allowedHeaders = "*")
public class ItemController extends BaseController{
    @Autowired
    private ItemServiceImpl itemService;

    //创建商品的controller
    @RequestMapping(value="add",method = {RequestMethod.POST},consumes = {CONTENT_TYPE_FORMED})
    public CommonReturnType createItem(@RequestParam(name="title")String title,
                                       @RequestParam(name="description")String description,
                                       @RequestParam(name="price") BigDecimal price,
                                       @RequestParam(name="stock")Integer stock,
                                       @RequestParam(name="imgUrl")String imgUrl
                                       ) throws BusinessException {
        //疯转service请求用来创建商品
        ItemModel itemModel=new ItemModel();
        itemModel.setTitle(title);
        itemModel.setDescription(description);
        itemModel.setPrice(price);
        itemModel.setStock(stock);
        itemModel.setImgUrl(imgUrl);
        ItemModel itemModelForReturn = itemService.createItem(itemModel);
        ItemVO itemVO=this.convertItemVOFromItemModel(itemModelForReturn);
        return CommonReturnType.create(itemVO);
    }
    //商品详情
    @RequestMapping(value="detail",method = {RequestMethod.GET})
    @ResponseBody
    public CommonReturnType getItem(@RequestParam(name="id")Integer id){
        ItemModel itemModel=itemService.getItemById(id);
        ItemVO itemVO=convertItemVOFromItemModel(itemModel);

        return CommonReturnType.create(itemVO);
    }
    //商品列表
    @RequestMapping(value="list",method = {RequestMethod.GET})
    @ResponseBody
    public CommonReturnType getList(){
        List<ItemModel> itemModelList = itemService.listItem();
        List<ItemVO> itemVOList = itemModelList.stream().map(itemModel->{
            ItemVO itemVO=this.convertItemVOFromItemModel(itemModel);
            return itemVO;
        }).collect(Collectors.toList());
        return CommonReturnType.create(itemVOList);
    }

    public ItemVO convertItemVOFromItemModel(ItemModel itemModel){
        ItemVO itemVO=new ItemVO();
        if(itemModel == null){
            return null;
        }
        BeanUtils.copyProperties(itemModel,itemVO);
        return itemVO;

    }
}