【MyBatis嵌套查询】MyBatis使用‘association’标签实现嵌套查询

public class testDto{

	private Integer id;
	private String name;
	private List childList;

	public static class Child{
        private Integer id;
	    private String name;
 }
 
}

‘select’为嵌套查询的SQL的ID名称
‘column’为要带入的某列的值

        SELECT id,name FROM test

 

        SELECT id,name FROM test
        WHERe parent_id=#{id}