解决mybatis一对多关联查询多条数据只显示一条的问题_java

 select
 u.*,p.id as pid,p.user_id,p.name,p.icon,p.vsersion,p.tags,p.description,p.create_time
 as bcreate_time,p.update_time as bupdate_time,p.del_flag from t_user u
 LEFT
 JOIN t_plugin p ON u.id=p.user_id and u.del_flag=0 and
 p.del_flag=0 WHERE
 u.user_name LIKE CONCAT('%',#{name},'%') OR
 u.nick_name LIKE
 CONCAT('%',#{name},'%')
 

 
 
 
 
 
 
 
 
 
 
 
 
 
 

 
 
 SELECT id,user_id ,number,createtime,note FROM orders
 

public class OrderMapperTest {
 
 SqlSessionFactory factory = null;
 private OrderMapper orderMapper = null;

 @Before
 public void testInit() {
  // 1. 创建SqlSessionFactoryBuilder对象
  SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
  // 2. 加载SqlMapConfig.xml配置文件
  // /20181013_mybatis/config/SqlMapConfig.xml
  InputStream in = MyBatisTest.class.getResourceAsStream("/SqlMapConfig.xml");
  // 3. 创建SqlSessionFactory对象
  factory = builder.build(in);

 }
    @Test
 public void testqueryAll() {
  SqlSession session = factory.openSession();
  OrderMapper orderMapper = session.getMapper(OrderMapper.class);
  List orders = orderMapper.queryAll();
  System.out.println(orders);
 }
 }