mybatis省了60s,直接mapper上面加@select注解即可, @Select("select g.*, sg.stock_count, sg.start_date, sg.end_date, sg.seckill_price, sg.version from sk_ goods_seckill sg left join sk_goods g on sg.goods_id = g.id") public List<GoodsVo> listGoodsVo();