获取所有秒杀商品数据接口实现

package com.java1234.miaosha.controller;

import com.java1234.miaosha.entity.MiaoShaGoods;
import com.java1234.miaosha.entity.R;
import com.java1234.miaosha.service.IMiaoShaGoodsService;
import com.java1234.miaosha.vo.MiaoShaGoodsVo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * 秒杀商品控制器
 */
@RestController
@RequestMapping("/miaoShaGoods")
public class MiaoShaGoodsController {

    @Autowired
    private IMiaoShaGoodsService miaoShaGoodsService;

    /**
     * 查询所有秒杀商品
     * @return
     */
    @RequestMapping("/findAll")
    public R findAll(){
        List<MiaoShaGoodsVo> miaoShaGoodsList = miaoShaGoodsService.listAll();
        Map<String,Object> map=new HashMap<>();
        map.put("data",miaoShaGoodsList);
        return R.ok(map);
    }
}

package com.java1234.miaosha.entity;

import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.databind.annotation.JsonSerialize;
import lombok.Data;

import java.io.Serializable;
import java.util.Date;

/**
 * 秒杀商品实体
 * @author java1234_小锋
 * @site www.java1234.com
 * @company Java知识分享网
 * @create 2020-11-17 10:57
 */
@TableName("t_goods_miaosha")
@Data
public class MiaoShaGoods implements Serializable {

    private Integer id; // 编号

    @TableField(select = false)
    private Goods goods; // 关联商品

    private double price; // 秒杀价格

    private Integer stock; // 库存数量

    @JsonSerialize(using=CustomDateTimeSerializer.class)
    private Date startTime; // 秒杀开始时间

    @JsonSerialize(using=CustomDateTimeSerializer.class)
    private Date endTime; // 秒杀结束时间




}

package com.java1234.miaosha.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.java1234.miaosha.entity.MiaoShaGoods;
import com.java1234.miaosha.vo.MiaoShaGoodsVo;

import java.util.List;

/**
 * 秒杀商品Mapper接口
 */
public interface MiaoShaGoodsMapper extends BaseMapper<MiaoShaGoods> {

    /**
     * 查询所有秒杀商品
     * @return
     */
    public List<MiaoShaGoodsVo> listAll();
}

package com.java1234.miaosha.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.java1234.miaosha.entity.MiaoShaGoods;
import com.java1234.miaosha.vo.MiaoShaGoodsVo;

import java.util.List;

/**
 * 秒杀商品service接口
 */
public interface IMiaoShaGoodsService extends IService<MiaoShaGoods> {

    /**
     * 查询所有秒杀商品
     * @return
     */
    public List<MiaoShaGoodsVo> listAll();
}

package com.java1234.miaosha.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.java1234.miaosha.entity.MiaoShaGoods;
import com.java1234.miaosha.mapper.MiaoShaGoodsMapper;
import com.java1234.miaosha.service.IMiaoShaGoodsService;
import com.java1234.miaosha.vo.MiaoShaGoodsVo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * 秒杀商品service实现类
 */
@Service("miaoshaGoodsService")
public class MiaoShaGoodsServiceImpl extends ServiceImpl<MiaoShaGoodsMapper, MiaoShaGoods> implements IMiaoShaGoodsService {

    @Autowired
    private MiaoShaGoodsMapper miaoShaGoodsMapper;

    @Override
    public List<MiaoShaGoodsVo> listAll() {
        return miaoShaGoodsMapper.listAll();
    }
}

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.java1234.miaosha.mapper.MiaoShaGoodsMapper">

    <resultMap type="com.java1234.miaosha.vo.MiaoShaGoodsVo" id="MiaoShaGoodsResult">
        <association property="goods" column="goods_id" select="com.java1234.miaosha.mapper.GoodsMapper.findById"></association>
    </resultMap>

    <select id="listAll" resultMap="MiaoShaGoodsResult">
        select * from t_goods_miaosha
    </select>

</mapper>