Mybatis学习第18节 -- 嵌套查询显示信息列表

在查询过程中根据过程中的结果进行其他查询,最后进行组装

 

接口

List<Shop> getShopListOrderByName();

测试

@Test
public void testGetShopByTitleContainSharp() {
    String template = "查询结果: %s";
    SqlSession session = MyBatisUtil.getSqlSession();
    ShopMapper mapper = session.getMapper(ShopMapper.class);
    System.out.printf(template, mapper.getShopByTitleContainSharp("%%"));
    session.close();
}

映射文件

照旧

结果

查询结果: [Shop{id=1, ownerId=1, area=Area{id=3, name='长治学院', priority=2, createTime=null, lastEditTime=null}, categoryId=14, name='new 正式店铺名称', desc='测试描述', addr='正式地址', phone='13810524086', image='/upload/item/shop/1/2017091621545314507.jpg', priority=10, createTime=2017-08-03, lastEditTime=2017-09-16, enableStatus=0, advice='审核中'}, Shop{id=28, ownerId=1, area=Area{id=2, name='东苑', priority=1, createTime=Fri Dec 28 20:16:43 CST 2018, lastEditTime=Fri Dec 28 20:16:47 CST 2018}, categoryId=22, name='小黄人主题奶茶店', desc='不接受预订，请直接来店里进行消费', addr='位于东苑2号', phone='13810524086', image='/upload/images/item/shop/28/2017092601041469991.png', priority=50, createTime=2017-09-26, lastEditTime=2017-09-26, enableStatus=1, advice='null'}, Shop{id=29, ownerId=1, area=Area{id=3, name='长治学院', priority=2, createTime=null, lastEditTime=null}, categoryId=22, name='暴漫奶茶店', desc='过来喝喝就知道啦，你是我的奶茶', addr='西苑1号', phone='1211334565', image='/upload/images/item/shop/29/2017092601054939287.jpg', priority=40, createTime=2017-09-26, lastEditTime=2017-09-26, enableStatus=1, advice='null'}, Shop{id=30, ownerId=1, area=Area{id=2, name='东苑', priority=1, createTime=Fri Dec 28 20:16:43 CST 2018, lastEditTime=Fri Dec 28 20:16:47 CST 2018}, categoryId=20, name='彪哥大排档', desc='敢说不好吃吗', addr='东苑1号', phone='13628763625', image='/upload/images/item/shop/30/2017092601063878278.jpg', priority=30, createTime=2017-09-26, lastEditTime=2017-09-26, enableStatus=1, advice='null'}, Shop{id=31, ownerId=1, area=Area{id=2, name='东苑', priority=1, createTime=Fri Dec 28 20:16:43 CST 2018, lastEditTime=Fri Dec 28 20:16:47 CST 2018}, categoryId=20, name='威哥大排档', desc='干掉彪哥大排档', addr='东苑南路', phone='126554437261', image='/upload/images/item/shop/31/2017092601072177572.jpg', priority=20, createTime=2017-09-26, lastEditTime=2017-09-26, enableStatus=1, advice='null'}, Shop{id=32, ownerId=1, area=Area{id=2, name='东苑', priority=1, createTime=Fri Dec 28 20:16:43 CST 2018, lastEditTime=Fri Dec 28 20:16:47 CST 2018}, categoryId=22, name='你是我的奶茶', desc='奶茶店再次来袭', addr='东苑六路', phone='13652384615', image='/upload/images/item/shop/32/2017092601081463136.jpg', priority=10, createTime=2017-09-26, lastEditTime=2017-09-26, enableStatus=1, advice='null'}, Shop{id=35, ownerId=8, area=Area{id=2, name='东苑', priority=1, createTime=Fri Dec 28 20:16:43 CST 2018, lastEditTime=Fri Dec 28 20:16:47 CST 2018}, categoryId=22, name='奶茶来了', desc='奶茶来了', addr='西苑7路', phone='null', image='null', priority=0, createTime=null, lastEditTime=null, enableStatus=0, advice='null'}, Shop{id=38, ownerId=1, area=Area{id=2, name='东苑', priority=1, createTime=Fri Dec 28 20:16:43 CST 2018, lastEditTime=Fri Dec 28 20:16:47 CST 2018}, categoryId=10, name='杰克的小屋', desc='欢迎你哦', addr='etc test', phone='etc test', image='etc test', priority=null, createTime=2018-06-02, lastEditTime=null, enableStatus=1, advice='审核中-'}]

<wiz_tmp_tag class="wiz-block-scroll">

 

总结

查询单个记录和查询多条记录的区别不大