mybatis中mysql递归查询多级_Mybatis + mysql 实现两级级联的查询

”，我们在一的mapper.xml中，用collection定义多的一个集合即可。

property --->对应实体类中，多的那个子类，list

ofType--->对应子类的试题类型

column---->父类传递给子类查询的外键

select----> 子类查询的方法

1.定义父类+子类的实体类

packagecom.imocc.mall.pojo;importlombok.Data;importjava.util.List;/***@authorwy*/@Datapublic classProvince {privateInteger id;privateString provinceid;privateString province;private Listlist;

@OverridepublicString toString() {return "Province{" +

"id=" + id +

", provinceid=‘" + provinceid + ‘\‘‘ +

", province=‘" + province + ‘\‘‘ +

", list=" + list +

‘}‘;

}

}

packagecom.imocc.mall.pojo;importlombok.Data;

@Datapublic classCity {privateInteger id;privateString cityid;privateString city;privateString father;

}

2.mapper类

2. mapperxml文件

3. 测试

JDBC Connection [HikariProxyConnection@1532915766wrapping com.mysql.cj.jdbc.ConnectionImpl@62dbe64e] will not be managed by Spring==> Preparing: select * from hat_province where provinceID =?

==> Parameters: 110000(String)<==Columns: id, provinceID, province<== Row: 1, 110000, 北京市====> Preparing: select id, cityID, city, father from hat_city where father = ?

====> Parameters: 110000(String)<====Columns: id, cityID, city, father<==== Row: 1, 110100, 市辖区, 110000

<==== Row: 2, 110200, 县, 110000

<==== Total: 2

<== Total: 1Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@8f2098e]

Province{id=1, provinceid=‘110000‘, province=‘北京市‘, list=[City(id=1, cityid=110100, city=市辖区, father=110000), City(id=2, cityid=110200, city=县, father=110000)]}

Mybatis + mysql 实现两级级联的查询

标签：mysq   ==   app   package   color   类型   情况   block   思想

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：https://www.cnblogs.com/Edward-Wang/p/12080365.html