51,396
社区成员




SELECT
A.*,B.*,C1.*,C2.*
FROM
A
LEFT JOIN B ON A.ID = B.ID
LEFT JOIN C AS C1 ON A.ID = C1.ID
LEFT JOIN C AS C2 ON B.NAME = C2.NAME
@SuppressWarnings("PMD.UnusedPrivateField")
@Getter
@Setter
public class Entity implements Serializable {
private AEntity A;
private BEntity B;
private List<CEntity> C1;
private List<CEntity> C2;
}
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="xx.xx.xxx.MybatisMapper">
<resultMap id="resultMap_XXXXXXXXX"
type="xx.xx.xxx.Entity "
autoMapping="true" >
<association property="A" resultMap="xx.xx.resultMap_AEntity" />
<association property="B" resultMap="xx.xx.resultMap_BEntity" />
<collection property="C1" resultMap="xx.xx.resultMap_C1Entity" />
<collection property="C2" resultMap="xx.xx.resultMap_C2Entity" />
</resultMap>
<select id="select_result" resultOrdered="true"
resultMap="resultMap_XXXXXXXXX"
parameterType="xx.xx.xxx.MybatisParameter"
fetchSize="500">
SELECT
A.*,B.*,C1.*,C2.*
FROM
A
LEFT JOIN B ON A.ID = B.ID
LEFT JOIN C AS C1 ON A.ID = C1.ID
LEFT JOIN C AS C2 ON B.NAME = C2.NAME
</select>
</mapper>