Mybatis Link（Mybatis Plus X）通过自定义注解方式，注入基础CRUD，一对一，一对多连表查询方法（2）

最新推荐文章于 2024-03-09 00:00:00 发布
置顶 最新推荐文章于 2024-03-09 00:00:00 发布
阅读量2k 收藏 8
点赞数 3
分类专栏： MyBatis MyBatis-X 文章标签： MyBatis MyBatis Plus MyBatis-X 注解连表查询 mapper注解
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/ssyujay/article/details/88730921
版权

三. MyBatis Link 一对一，一对多连表查询配置，解析，结果展示

    本节通过一对一，一对多等连表查询进行注解配置，注解解析结果，以及查询结果进行展示。由于每张表生成的基础CRUD都是一样，且不需要进行手动配置，继而不在此处进行分析。    

    为了便于测试，先创建5张测试表，分别为t_test_a，t_test_b，t_test_c，t_test_d，t_test_e，下面将在TestADao中进行注解配置。

/**
 * <p>
 * 测试A
 * </p>
 *
 * @author yuyi (1060771195@qq.com)
 */
@Data
public class TestADto implements Serializable {
    private static final long serialVersionUID = 1L;

    protected TestAVo testAVo2;
    protected TestAVo testAVo;
    protected TestBVo testBVo;
    protected TestCVo testCVo;
    protected TestDVo testDVo;
    protected List<TestBDto> testBList;
    protected List<TestCDto> testCList;

}
/**
 * <p>
 * 测试A Mapper 接口
 * </p>
 *
 * @author yuyi (1060771195@qq.com)
 * @since 2019-03-20
 */
@Mapper
public interface TestADao extends BaseDao<TestAVo, TestADto> {

    /**
     * t_test_a 与 t_test_a 一对一连表查询
     * 由于两个表相同，所以必须给其中一个表设置表名，且该别名必须跟TestADto对象中得属性名对应，如：rightAlias = "testAVo2"
     * leftClass默认为TestAVo.class， 如果leftClass为TestAVo.class, 可以默认省略
     * leftColumn或者rightColumn都不写，默认为该表主键
     */
    @Link(  print = false, 
            ones = { @OneToOne(leftColumn = "a_id", rightClass = TestAVo.class, rightAlias = "testAVo2") })
    List<TestADto> listTestAATestA(@Param(Constants.WRAPPER) Wrapper<TestAVo> wrapper);
    
    /**
     * t_test_a 与   t_test_c 一对一连表查询
     */
    @Link(  print = false, 
            ones = { @OneToOne(leftColumn = "c_id", rightClass = TestCVo.class) })
    List<TestADto> listTestAATestC(@Param(Constants.WRAPPER) Wrapper<TestAVo> wrapper);
    
    /**
     * t_test_a 与   t_test_b 一对一连表查询
     */
    @Link(  print = false, 
            ones = { @OneToOne(rightClass = TestBVo.class, rightColumn = "a_id") })
    List<TestADto> listTestAATestB(@Param(Constants.WRAPPER) Wrapper<TestAVo> wrapper);
    
    /**
     * t_test_a 与  t_test_b, t_test_a 与  t_test_c 多表查询
     */
    @Link(  print = false, 
            ones = { @OneToOne(leftColumn = "b_id", rightClass = TestBVo.class),
                     @OneToOne(leftColumn = "c_id", rightClass = TestCVo.class)})
    List<TestADto> listTestAATestBATestC(@Param(Constants.WRAPPER) Wrapper<TestAVo> wrapper);
    
    /**
     * t_test_a 与  t_test_b, t_test_b 与  t_test_c, t_test_a 与  t_test_d 多表查询
     */
    @Link(  print = false, 
            ones = { @OneToOne(leftColumn = "b_id", rightClass = TestBVo.class),
                     @OneToOne(leftClass = TestBVo.class, leftColumn = "c_id", rightClass = TestCVo.class),
                     @OneToOne(rightClass = TestDVo.class, rightColumn = "a_id")})
    List<TestADto> listTestAATestBATestCATestD(@Param(Constants.WRAPPER) Wrapper<TestAVo> wrapper);
    
    /**
     * t_test_a 左连接 t_test_b
     */
    @Link(  print = false, 
            ones = { @OneToOne(leftColumn = "b_id", rightClass = TestBVo.class, joinType = JoinType.LEFT, onArgName = "abOn") })
    List<TestADto> listTestALtTestB(@Param(Constants.WRAPPER) Wrapper<TestAVo> wrapper);
    
    /**
     * t_test_a 左连接 t_test_b, t_test_a 左连接 t_test_c  
     */
    @Link(  print = false, 
            ones = { @OneToOne(leftColumn = "b_id", rightClass = TestBVo.class, joinType = JoinType.LEFT, onArgName = "abOn"), 
                     @OneToOne(leftColumn = "c_id", rightClass = TestCVo.class, joinType = JoinType.LEFT, onArgName = "acOn")})
    List<TestADto> listTestALtTestBLtTestC(@Param(Constants.WRAPPER) Wrapper<TestAVo> wrapper);
    
    /**
     * t_test_a 右连接 t_test_c
     */
    @Link(  print = false, 
            ones = { @OneToOne(leftColumn = "b_id", rightClass = TestCVo.class, joinType = JoinType.RIGHT, onArgName = "acOn") })
    List<TestADto> listTestARtTestC(@Param(Constants.WRAPPER) Wrapper<TestAVo> wrapper);
    
    /**
     * t_test_a 一对多 t_test_b
     * 如果t_test_b对应得rightClass 为约定得  TestBVo.class, 可以缺省
     * 由于TestADto中对应得属性List<TestBDto> testBList 这种类型property 对应的是该属性属性名
     */
    @Link(  print = false, 
            manys = { @OneToMany(leftColumn = "b_id", rightClass = TestBVo.class, ofTypeClass = TestBDto.class, property = "testBList") })
    List<TestADto> listTestAWTestB(@Param(Constants.WRAPPER) Wrapper<TestAVo> wrapper);
    
    /**
    * t_test_a 一对多 t_test_b, t_test_a 一对多 t_test_c
    */
   @Link(  print = false, printRm = true,
           manys = { @OneToMany(leftColumn = "b_id", rightClass = TestBVo.class, ofTypeClass = TestBDto.class, property = "testBList"),
                     @OneToMany(leftColumn = "c_id", rightClass = TestCVo.class, ofTypeClass = TestCDto.class, property = "testCList")})
   List<TestADto> listTestAWTestBWTestC(@Param(Constants.WRAPPER) Wrapper<TestAVo> wrapper);
    
    /**
     * t_test_a 一对一  t_test_b, t_test_a 一对多 t_test_b
     */
    @Link(  print = false, printRm = false,
            ones = { @OneToOne(leftColumn = "b_id", rightClass = TestBVo.class)},
            manys = { @OneToMany(leftClass = TestAVo.class, leftColumn = "b_id", rightClass = TestBVo.class, ofTypeClass = TestBDto.class, property = "testBList") })
    List<TestADto> listTestAATestBWTestB(@Param(Constants.WRAPPER) Wrapper<TestAVo> wrapper);
    
    /**
     * t_test_a 一对一  t_test_b, t_test_a 一对多 t_test_b, 多表中 t_test_b 一对一 t_test_c
     */
    @Link(  print = false, 
            ones = { @OneToOne(leftColumn = "b_id", rightClass = TestBVo.class)},
            manys = { @OneToMany(leftClass = TestAVo.class, leftColumn = "b_id", rightClass = TestBVo.class, ofTypeClass = TestBDto.class, property = "testBList", 
            ones = { @OneToOne(leftColumn = "c_id", rightClass = TestCVo.class)} )})
    List<TestADto> listTestAATestBWTestBATestC(@Param(Constants.WRAPPER) Wrapper<TestAVo> wrapper);
    
    /**
     * t_test_a 与   t_test_b 一对一分页连表查询
     */
    @Link(  print = false, 
            ones = { @OneToOne(rightClass = TestBVo.class, rightColumn = "a_id") })
    IPage<TestADto> pageTestAATestB(IPage<TestADto> page, @Param(Constants.WRAPPER) Wrapper<TestAVo> wrapper);
    
    /**
     * t_test_a 与   t_test_b 连表行数查询
     */
    @Link(  print = false, 
            ones = { @OneToOne(rightClass = TestBVo.class, rightColumn = "a_id") })
    Integer countTestAATestB(@Param(Constants.WRAPPER) Wrapper<TestAVo> wrapper);
    
}

  下面将对TestADao中关键注解进行解析结果展示和查询结果展示

/**
     * t_test_a 与 t_test_a 一对一连表查询
     * 由于两个表相同，所以必须给其中一个表设置表名，且该别名必须跟TestADto对象中得属性名对应，如：rightAlias = "testAVo2"
     * leftClass默认为TestAVo.class， 如果leftClass为TestAVo.class, 可以默认省略
     * leftColumn或者rightColumn都不写，默认为该表主键
     */
    @Link(  print = false, 
            ones = { @OneToOne(leftColumn = "a_id", rightClass = TestAVo.class, 
            rightAlias = "testAVo2") })
    List<TestADto> listTestAATestA(@Param(Constants.WRAPPER) Wrapper<TestAVo> wrapper);
<resultMap id="yui.bss.test.dao.TestADao.listTestAATestA-ResultMap" type="class yui.bss.test.dto.TestADto">
    <result property="testAVo.id" column="t_test_a__id" jdbcType="class java.lang.Long"/>
    <result property="testAVo.cId" column="t_test_a__c_id" jdbcType="class java.lang.Long"/>
    <result property="testAVo.bId" column="t_test_a__b_id" jdbcType="class java.lang.Long"/>
    <result property="testAVo.aId" column="t_test_a__a_id" jdbcType="class java.lang.Long"/>
    <result property="testAVo.crtTm" column="t_test_a__crt_tm" jdbcType="class java.util.Date"/>
    <result property="testAVo.crtBy" column="t_test_a__crt_by" jdbcType="class java.lang.String"/>
    <result property="testAVo.updTm" column="t_test_a__upd_tm" jdbcType="class java.util.Date"/>
    <result property="testAVo.updBy" column="t_test_a__upd_by" jdbcType="class java.lang.String"/>
    <result property="testAVo.editFlag" column="t_test_a__edit_flag" jdbcType="class java.lang.Integer"/>
    <result property="testAVo.tntId" column="t_test_a__tnt_id" jdbcType="class java.lang.Long"/>
    <result property="testAVo2.id" column="testAVo2__id" jdbcType="class java.lang.Long"/>
    <result property="testAVo2.cId" column="testAVo2__cId" jdbcType="class java.lang.Long"/>
    <result property="testAVo2.bId" column="testAVo2__bId" jdbcType="class java.lang.Long"/>
    <result property="testAVo2.aId" column="testAVo2__aId" jdbcType="class java.lang.Long"/>
    <result property="testAVo2.crtTm" column="testAVo2__crtTm" jdbcType="class java.util.Date"/>
    <result property="testAVo2.crtBy" column="testAVo2__crtBy" jdbcType="class java.lang.String"/>
    <result property="testAVo2.updTm" column="testAVo2__updTm" jdbcType="class java.util.Date"/>
    <result property="testAVo2.updBy" column="testAVo2__updBy" jdbcType="class java.lang.String"/>
    <result property="testAVo2.editFlag" column="testAVo2__editFlag" jdbcType="class java.lang.Integer"/>
    <result property="testAVo2.tntId" column="testAVo2__tntId" jdbcType="class java.lang.Long"/>
</resultMap>
<script>
SELECT <choose>
<when test="ew != null and ew.sqlSelect != null">
${ew.sqlSelect}
</when>
<otherwise> t_test_a.`id` t_test_a__id , t_test_a.`c_id` t_test_a__c_id , t_test_a.`b_id` t_test_a__b_id , t_test_a.`a_id` t_test_a__a_id , t_test_a.`crt_tm` t_test_a__crt_tm , t_test_a.`crt_by` t_test_a__crt_by , t_test_a.`upd_tm` t_test_a__upd_tm , t_test_a.`upd_by` t_test_a__upd_by , t_test_a.`edit_flag` t_test_a__edit_flag , t_test_a.`tnt_id` t_test_a__tnt_id , testAVo2.`id` testAVo2__id , testAVo2.`c_id` testAVo2__c_id , testAVo2.`b_id` testAVo2__b_id , testAVo2.`a_id` testAVo2__a_id , testAVo2.`crt_tm` testAVo2__crt_tm , testAVo2.`crt_by` testAVo2__crt_by , testAVo2.`upd_tm` testAVo2__upd_tm , testAVo2.`upd_by` testAVo2__upd_by , testAVo2.`edit_flag` testAVo2__edit_flag , testAVo2.`tnt_id` testAVo2__tnt_id </otherwise>
</choose> FROM t_test_a t_test_a INNER JOIN t_test_a testAVo2 <trim prefix="WHERE" prefixOverrides="AND|OR">
 AND t_test_a.edit_flag=0 AND testAVo2.edit_flag=0 and t_test_a.a_id=testAVo2.id
<if test="ew != null">
<if test="ew.id != null">
 AND t_test_a.id = ${ew.id}
</if>
<if test="ew.sqlSegment != null and ew.sqlSegment != '' and ew.nonEmptyOfWhere">
 AND ${ew.sqlSegment}
</if>
<if test="ew.sqlSegment != null and ew.sqlSegment != '' and ew.emptyOfWhere">
 ${ew.sqlSegment}
</if>
</if>
</trim>
</script>
{
  "code": 0,
  "data": {
    "list": [
      {
        "testAVo2": {
          "crtTm": null,
          "crtBy": null,
          "updTm": null,
          "updBy": null,
          "editFlag": null,
          "tntId": null,
          "id": 1,
          "cid": null,
          "aid": null,
          "bid": null
        },
        "testAVo": {
          "crtTm": null,
          "crtBy": null,
          "updTm": null,
          "updBy": null,
          "editFlag": 0,
          "tntId": null,
          "id": 2,
          "cid": 1,
          "aid": 1,
          "bid": 1
        },
        "testBVo": null,
        "testCVo": null,
        "testDVo": null,
        "testBList": null,
        "testCList": null
      }
    ]
  }
}
/**
     * t_test_a 与   t_test_c 一对一连表查询
     */
    @Link(  print = true, printRm = true,
            ones = { @OneToOne(leftColumn = "c_id", rightClass = TestCVo.class) })
    List<TestADto> listTestAATestC(@Param(Constants.WRAPPER) Wrapper<TestAVo> wrapper);
<resultMap id="yui.bss.test.dao.TestADao.listTestAATestC-ResultMap" type="class yui.bss.test.dto.TestADto">
    <result property="testAVo.id" column="t_test_a__id" jdbcType="class java.lang.Long"/>
    <result property="testAVo.cId" column="t_test_a__c_id" jdbcType="class java.lang.Long"/>
    <result property="testAVo.bId" column="t_test_a__b_id" jdbcType="class java.lang.Long"/>
    <result property="testAVo.aId" column="t_test_a__a_id" jdbcType="class java.lang.Long"/>
    <result property="testAVo.crtTm" column="t_test_a__crt_tm" jdbcType="class java.util.Date"/>
    <result property="testAVo.crtBy" column="t_test_a__crt_by" jdbcType="class java.lang.String"/>
    <result property="testAVo.updTm" column="t_test_a__upd_tm" jdbcType="class java.util.Date"/>
    <result property="testAVo.updBy" column="t_test_a__upd_by" jdbcType="class java.lang.String"/>
    <result property="testAVo.editFlag" column="t_test_a__edit_flag" jdbcType="class java.lang.Integer"/>
    <result property="testAVo.tntId" column="t_test_a__tnt_id" jdbcType="class java.lang.Long"/>
    <result property="testCVo.id" column="t_test_c__id" jdbcType="class java.lang.Long"/>
    <result property="testCVo.aId" column="t_test_c__a_id" jdbcType="class java.lang.Long"/>
    <result property="testCVo.bId" column="t_test_c__b_id" jdbcType="class java.lang.Long"/>
    <result property="testCVo.cId" column="t_test_c__c_id" jdbcType="class java.lang.Long"/>
    <result property="testCVo.crtTm" column="t_test_c__crt_tm" jdbcType="class java.util.Date"/>
    <result property="testCVo.crtBy" column="t_test_c__crt_by" jdbcType="class java.lang.String"/>
    <result property="testCVo.updTm" column="t_test_c__upd_tm" jdbcType="class java.util.Date"/>
    <result property="testCVo.updBy" column="t_test_c__upd_by" jdbcType="class java.lang.String"/>
    <result property="testCVo.editFlag" column="t_test_c__edit_flag" jdbcType="class java.lang.Integer"/>
    <result property="testCVo.tntId" column="t_test_c__tnt_id" jdbcType="class java.lang.Long"/>
</resultMap>
<script>
SELECT <choose>
<when test="ew != null and ew.sqlSelect != null">
${ew.sqlSelect}
</when>
<otherwise> t_test_a.`id` t_test_a__id , t_test_a.`c_id` t_test_a__c_id , t_test_a.`b_id` t_test_a__b_id , t_test_a.`a_id` t_test_a__a_id , t_test_a.`crt_tm` t_test_a__crt_tm , t_test_a.`crt_by` t_test_a__crt_by , t_test_a.`upd_tm` t_test_a__upd_tm , t_test_a.`upd_by` t_test_a__upd_by , t_test_a.`edit_flag` t_test_a__edit_flag , t_test_a.`tnt_id` t_test_a__tnt_id , t_test_c.`id` t_test_c__id , t_test_c.`a_id` t_test_c__a_id , t_test_c.`b_id` t_test_c__b_id , t_test_c.`c_id` t_test_c__c_id , t_test_c.`crt_tm` t_test_c__crt_tm , t_test_c.`crt_by` t_test_c__crt_by , t_test_c.`upd_tm` t_test_c__upd_tm , t_test_c.`upd_by` t_test_c__upd_by , t_test_c.`edit_flag` t_test_c__edit_flag , t_test_c.`tnt_id` t_test_c__tnt_id </otherwise>
</choose> FROM t_test_a t_test_a INNER JOIN t_test_c t_test_c <trim prefix="WHERE" prefixOverrides="AND|OR">
 AND t_test_a.edit_flag=0 AND t_test_c.edit_flag=0 and t_test_a.c_id=t_test_c.id
<if test="ew != null">
<if test="ew.id != null">
 AND t_test_a.id = ${ew.id}
</if>
<if test="ew.sqlSegment != null and ew.sqlSegment != '' and ew.nonEmptyOfWhere">
 AND ${ew.sqlSegment}
</if>
<if test="ew.sqlSegment != null and ew.sqlSegment != '' and ew.emptyOfWhere">
 ${ew.sqlSegment}
</if>
</if>
</trim>
</script>
{
  "code": 0,
  "data": {
    "list": [
      {
        "testAVo2": null,
        "testAVo": {
          "crtTm": "2017-11-07 15:17:11",
          "crtBy": null,
          "updTm": "2018-12-18 02:30:11",
          "updBy": "admin",
          "editFlag": 0,
          "tntId": null,
          "id": 1,
          "cid": 1,
          "aid": null,
          "bid": 1
        },
        "testBVo": null,
        "testCVo": {
          "crtTm": "2017-11-07 15:17:11",
          "crtBy": null,
          "updTm": "2018-12-18 02:30:11",
          "updBy": "admin",
          "editFlag": 0,
          "tntId": null,
          "id": 1,
          "cid": 1,
          "aid": 1,
          "bid": 1
        },
        "testDVo": null,
        "testBList": null,
        "testCList": null
      },
      {
        "testAVo2": null,
        "testAVo": {
          "crtTm": null,
          "crtBy": null,
          "updTm": null,
          "updBy": null,
          "editFlag": 0,
          "tntId": null,
          "id": 2,
          "cid": 1,
          "aid": 1,
          "bid": 1
        },
        "testBVo": null,
        "testCVo": {
          "crtTm": "2017-11-07 15:17:11",
          "crtBy": null,
          "updTm": "2018-12-18 02:30:11",
          "updBy": "admin",
          "editFlag": 0,
          "tntId": null,
          "id": 1,
          "cid": 1,
          "aid": 1,
          "bid": 1
        },
        "testDVo": null,
        "testBList": null,
        "testCList": null
      }
    ]
  }
}
/**
     * t_test_a 与   t_test_b 一对一连表查询
     */
    @Link(  print = true, printRm = true,
            ones = { @OneToOne(rightClass = TestBVo.class, rightColumn = "a_id") })
    List<TestADto> listTestAATestB(@Param(Constants.WRAPPER) Wrapper<TestAVo> wrapper);
<script>
SELECT <choose>
<when test="ew != null and ew.sqlSelect != null">
${ew.sqlSelect}
</when>
<otherwise> t_test_a.`id` t_test_a__id , t_test_a.`c_id` t_test_a__c_id , t_test_a.`b_id` t_test_a__b_id , t_test_a.`a_id` t_test_a__a_id , t_test_a.`crt_tm` t_test_a__crt_tm , t_test_a.`crt_by` t_test_a__crt_by , t_test_a.`upd_tm` t_test_a__upd_tm , t_test_a.`upd_by` t_test_a__upd_by , t_test_a.`edit_flag` t_test_a__edit_flag , t_test_a.`tnt_id` t_test_a__tnt_id , t_test_b.`id` t_test_b__id , t_test_b.`a_id` t_test_b__a_id , t_test_b.`c_id` t_test_b__c_id , t_test_b.`crt_tm` t_test_b__crt_tm , t_test_b.`crt_by` t_test_b__crt_by , t_test_b.`upd_tm` t_test_b__upd_tm , t_test_b.`upd_by` t_test_b__upd_by , t_test_b.`edit_flag` t_test_b__edit_flag , t_test_b.`tnt_id` t_test_b__tnt_id </otherwise>
</choose> FROM t_test_a t_test_a INNER JOIN t_test_b t_test_b <trim prefix="WHERE" prefixOverrides="AND|OR">
 AND t_test_a.edit_flag=0 AND t_test_b.edit_flag=0 and t_test_a.id=t_test_b.a_id
<if test="ew != null">
<if test="ew.id != null">
 AND t_test_a.id = ${ew.id}
</if>
<if test="ew.sqlSegment != null and ew.sqlSegment != '' and ew.nonEmptyOfWhere">
 AND ${ew.sqlSegment}
</if>
<if test="ew.sqlSegment != null and ew.sqlSegment != '' and ew.emptyOfWhere">
 ${ew.sqlSegment}
</if>
</if>
</trim>
</script>
/**
     * t_test_a 与  t_test_b, t_test_a 与  t_test_c 多表查询
     */
    @Link(  print = true, printRm = true,
            ones = { @OneToOne(leftColumn = "b_id", rightClass = TestBVo.class),
                     @OneToOne(leftColumn = "c_id", rightClass = TestCVo.class)})
    List<TestADto> listTestAATestBATestC(@Param(Constants.WRAPPER) Wrapper<TestAVo> wrapper);
<script>
SELECT <choose>
<when test="ew != null and ew.sqlSelect != null">
${ew.sqlSelect}
</when>
<otherwise> t_test_a.`id` t_test_a__id , t_test_a.`c_id` t_test_a__c_id , t_test_a.`b_id` t_test_a__b_id , t_test_a.`a_id` t_test_a__a_id , t_test_a.`crt_tm` t_test_a__crt_tm , t_test_a.`crt_by` t_test_a__crt_by , t_test_a.`upd_tm` t_test_a__upd_tm , t_test_a.`upd_by` t_test_a__upd_by , t_test_a.`edit_flag` t_test_a__edit_flag , t_test_a.`tnt_id` t_test_a__tnt_id , t_test_b.`id` t_test_b__id , t_test_b.`a_id` t_test_b__a_id , t_test_b.`c_id` t_test_b__c_id , t_test_b.`crt_tm` t_test_b__crt_tm , t_test_b.`crt_by` t_test_b__crt_by , t_test_b.`upd_tm` t_test_b__upd_tm , t_test_b.`upd_by` t_test_b__upd_by , t_test_b.`edit_flag` t_test_b__edit_flag , t_test_b.`tnt_id` t_test_b__tnt_id , t_test_c.`id` t_test_c__id , t_test_c.`a_id` t_test_c__a_id , t_test_c.`b_id` t_test_c__b_id , t_test_c.`c_id` t_test_c__c_id , t_test_c.`crt_tm` t_test_c__crt_tm , t_test_c.`crt_by` t_test_c__crt_by , t_test_c.`upd_tm` t_test_c__upd_tm , t_test_c.`upd_by` t_test_c__upd_by , t_test_c.`edit_flag` t_test_c__edit_flag , t_test_c.`tnt_id` t_test_c__tnt_id </otherwise>
</choose> FROM t_test_a t_test_a INNER JOIN t_test_b t_test_b INNER JOIN t_test_c t_test_c <trim prefix="WHERE" prefixOverrides="AND|OR">
 AND t_test_a.edit_flag=0 AND t_test_b.edit_flag=0 and t_test_a.b_id=t_test_b.id AND t_test_c.edit_flag=0 and t_test_a.c_id=t_test_c.id
<if test="ew != null">
<if test="ew.id != null">
 AND t_test_a.id = ${ew.id}
</if>
<if test="ew.sqlSegment != null and ew.sqlSegment != '' and ew.nonEmptyOfWhere">
 AND ${ew.sqlSegment}
</if>
<if test="ew.sqlSegment != null and ew.sqlSegment != '' and ew.emptyOfWhere">
 ${ew.sqlSegment}
</if>
</if>
</trim>
</script>
/**
     * t_test_a 与  t_test_b, t_test_b 与  t_test_c, t_test_a 与  t_test_d 多表查询
     */
    @Link(  print = true, printRm = true,
            ones = { @OneToOne(leftColumn = "b_id", rightClass = TestBVo.class),
                     @OneToOne(leftClass = TestBVo.class, leftColumn = "c_id", rightClass = TestCVo.class),
                     @OneToOne(rightClass = TestDVo.class, rightColumn = "a_id")})
    List<TestADto> listTestAATestBATestCATestD(@Param(Constants.WRAPPER) Wrapper<TestAVo> wrapper);
<script>
SELECT <choose>
<when test="ew != null and ew.sqlSelect != null">
${ew.sqlSelect}
</when>
<otherwise> t_test_a.`id` t_test_a__id , t_test_a.`c_id` t_test_a__c_id , t_test_a.`b_id` t_test_a__b_id , t_test_a.`a_id` t_test_a__a_id , t_test_a.`crt_tm` t_test_a__crt_tm , t_test_a.`crt_by` t_test_a__crt_by , t_test_a.`upd_tm` t_test_a__upd_tm , t_test_a.`upd_by` t_test_a__upd_by , t_test_a.`edit_flag` t_test_a__edit_flag , t_test_a.`tnt_id` t_test_a__tnt_id , t_test_b.`id` t_test_b__id , t_test_b.`a_id` t_test_b__a_id , t_test_b.`c_id` t_test_b__c_id , t_test_b.`crt_tm` t_test_b__crt_tm , t_test_b.`crt_by` t_test_b__crt_by , t_test_b.`upd_tm` t_test_b__upd_tm , t_test_b.`upd_by` t_test_b__upd_by , t_test_b.`edit_flag` t_test_b__edit_flag , t_test_b.`tnt_id` t_test_b__tnt_id , t_test_c.`id` t_test_c__id , t_test_c.`a_id` t_test_c__a_id , t_test_c.`b_id` t_test_c__b_id , t_test_c.`c_id` t_test_c__c_id , t_test_c.`crt_tm` t_test_c__crt_tm , t_test_c.`crt_by` t_test_c__crt_by , t_test_c.`upd_tm` t_test_c__upd_tm , t_test_c.`upd_by` t_test_c__upd_by , t_test_c.`edit_flag` t_test_c__edit_flag , t_test_c.`tnt_id` t_test_c__tnt_id , t_test_d.`id` t_test_d__id , t_test_d.`a_id` t_test_d__a_id , t_test_d.`crt_tm` t_test_d__crt_tm , t_test_d.`crt_by` t_test_d__crt_by , t_test_d.`upd_tm` t_test_d__upd_tm , t_test_d.`upd_by` t_test_d__upd_by , t_test_d.`edit_flag` t_test_d__edit_flag , t_test_d.`tnt_id` t_test_d__tnt_id </otherwise>
</choose> FROM t_test_a t_test_a INNER JOIN t_test_b t_test_b INNER JOIN t_test_c t_test_c INNER JOIN t_test_d t_test_d <trim prefix="WHERE" prefixOverrides="AND|OR">
 AND t_test_a.edit_flag=0 AND t_test_b.edit_flag=0 and t_test_a.b_id=t_test_b.id AND t_test_c.edit_flag=0 and t_test_b.c_id=t_test_c.id AND t_test_d.edit_flag=0 and t_test_a.id=t_test_d.a_id
<if test="ew != null">
<if test="ew.id != null">
 AND t_test_a.id = ${ew.id}
</if>
<if test="ew.sqlSegment != null and ew.sqlSegment != '' and ew.nonEmptyOfWhere">
 AND ${ew.sqlSegment}
</if>
<if test="ew.sqlSegment != null and ew.sqlSegment != '' and ew.emptyOfWhere">
 ${ew.sqlSegment}
</if>
</if>
</trim>
</script>
/**
     * t_test_a 左连接 t_test_b
     */
    @Link(  print = true, printRm = true,
            ones = { @OneToOne(leftColumn = "b_id", rightClass = TestBVo.class, joinType = JoinType.LEFT, onArgName = "abOn") })
    List<TestADto> listTestALtTestB(@Param(Constants.WRAPPER) Wrapper<TestAVo> wrapper);
<script>
SELECT <choose>
<when test="ew != null and ew.sqlSelect != null">
${ew.sqlSelect}
</when>
<otherwise> t_test_a.`id` t_test_a__id , t_test_a.`c_id` t_test_a__c_id , t_test_a.`b_id` t_test_a__b_id , t_test_a.`a_id` t_test_a__a_id , t_test_a.`crt_tm` t_test_a__crt_tm , t_test_a.`crt_by` t_test_a__crt_by , t_test_a.`upd_tm` t_test_a__upd_tm , t_test_a.`upd_by` t_test_a__upd_by , t_test_a.`edit_flag` t_test_a__edit_flag , t_test_a.`tnt_id` t_test_a__tnt_id , t_test_b.`id` t_test_b__id , t_test_b.`a_id` t_test_b__a_id , t_test_b.`c_id` t_test_b__c_id , t_test_b.`crt_tm` t_test_b__crt_tm , t_test_b.`crt_by` t_test_b__crt_by , t_test_b.`upd_tm` t_test_b__upd_tm , t_test_b.`upd_by` t_test_b__upd_by , t_test_b.`edit_flag` t_test_b__edit_flag , t_test_b.`tnt_id` t_test_b__tnt_id </otherwise>
</choose> FROM t_test_a t_test_a LEFT JOIN t_test_b t_test_b on t_test_a.b_id=t_test_b.id AND t_test_b.edit_flag=0 <if test="ew != null and ew.sqlOnMap != null and ew.sqlOnMap.abOn != null and ew.sqlOnMap.abOn != ''">
 AND ${ew.sqlOnMap.abOn}
</if> <trim prefix="WHERE" prefixOverrides="AND|OR">
 AND t_test_a.edit_flag=0
<if test="ew != null">
<if test="ew.id != null">
 AND t_test_a.id = ${ew.id}
</if>
<if test="ew.sqlSegment != null and ew.sqlSegment != '' and ew.nonEmptyOfWhere">
 AND ${ew.sqlSegment}
</if>
<if test="ew.sqlSegment != null and ew.sqlSegment != '' and ew.emptyOfWhere">
 ${ew.sqlSegment}
</if>
</if>
</trim>
</script>
/**
     * t_test_a 左连接 t_test_b, t_test_a 左连接 t_test_c  
     */
    @Link(  print = true, printRm = true,
            ones = { @OneToOne(leftColumn = "b_id", rightClass = TestBVo.class, joinType = JoinType.LEFT, onArgName = "abOn"), 
                     @OneToOne(leftColumn = "c_id", rightClass = TestCVo.class, joinType = JoinType.LEFT, onArgName = "acOn")})
    List<TestADto> listTestALtTestBLtTestC(@Param(Constants.WRAPPER) Wrapper<TestAVo> wrapper);
<script>
SELECT <choose>
<when test="ew != null and ew.sqlSelect != null">
${ew.sqlSelect}
</when>
<otherwise> t_test_a.`id` t_test_a__id , t_test_a.`c_id` t_test_a__c_id , t_test_a.`b_id` t_test_a__b_id , t_test_a.`a_id` t_test_a__a_id , t_test_a.`crt_tm` t_test_a__crt_tm , t_test_a.`crt_by` t_test_a__crt_by , t_test_a.`upd_tm` t_test_a__upd_tm , t_test_a.`upd_by` t_test_a__upd_by , t_test_a.`edit_flag` t_test_a__edit_flag , t_test_a.`tnt_id` t_test_a__tnt_id , t_test_b.`id` t_test_b__id , t_test_b.`a_id` t_test_b__a_id , t_test_b.`c_id` t_test_b__c_id , t_test_b.`crt_tm` t_test_b__crt_tm , t_test_b.`crt_by` t_test_b__crt_by , t_test_b.`upd_tm` t_test_b__upd_tm , t_test_b.`upd_by` t_test_b__upd_by , t_test_b.`edit_flag` t_test_b__edit_flag , t_test_b.`tnt_id` t_test_b__tnt_id , t_test_c.`id` t_test_c__id , t_test_c.`a_id` t_test_c__a_id , t_test_c.`b_id` t_test_c__b_id , t_test_c.`c_id` t_test_c__c_id , t_test_c.`crt_tm` t_test_c__crt_tm , t_test_c.`crt_by` t_test_c__crt_by , t_test_c.`upd_tm` t_test_c__upd_tm , t_test_c.`upd_by` t_test_c__upd_by , t_test_c.`edit_flag` t_test_c__edit_flag , t_test_c.`tnt_id` t_test_c__tnt_id </otherwise>
</choose> FROM t_test_a t_test_a LEFT JOIN t_test_b t_test_b on t_test_a.b_id=t_test_b.id AND t_test_b.edit_flag=0 <if test="ew != null and ew.sqlOnMap != null and ew.sqlOnMap.abOn != null and ew.sqlOnMap.abOn != ''">
 AND ${ew.sqlOnMap.abOn}
</if> LEFT JOIN t_test_c t_test_c on t_test_a.c_id=t_test_c.id AND t_test_c.edit_flag=0 <if test="ew != null and ew.sqlOnMap != null and ew.sqlOnMap.acOn != null and ew.sqlOnMap.acOn != ''">
 AND ${ew.sqlOnMap.acOn}
</if> <trim prefix="WHERE" prefixOverrides="AND|OR">
 AND t_test_a.edit_flag=0
<if test="ew != null">
<if test="ew.id != null">
 AND t_test_a.id = ${ew.id}
</if>
<if test="ew.sqlSegment != null and ew.sqlSegment != '' and ew.nonEmptyOfWhere">
 AND ${ew.sqlSegment}
</if>
<if test="ew.sqlSegment != null and ew.sqlSegment != '' and ew.emptyOfWhere">
 ${ew.sqlSegment}
</if>
</if>
</trim>
</script>
/**
     * t_test_a 右连接 t_test_c
     */
    @Link(  print = true, printRm = true,
            ones = { @OneToOne(leftColumn = "b_id", rightClass = TestCVo.class, joinType = JoinType.RIGHT, onArgName = "acOn") })
    List<TestADto> listTestARtTestC(@Param(Constants.WRAPPER) Wrapper<TestAVo> wrapper);
<script>
SELECT <choose>
<when test="ew != null and ew.sqlSelect != null">
${ew.sqlSelect}
</when>
<otherwise> t_test_a.`id` t_test_a__id , t_test_a.`c_id` t_test_a__c_id , t_test_a.`b_id` t_test_a__b_id , t_test_a.`a_id` t_test_a__a_id , t_test_a.`crt_tm` t_test_a__crt_tm , t_test_a.`crt_by` t_test_a__crt_by , t_test_a.`upd_tm` t_test_a__upd_tm , t_test_a.`upd_by` t_test_a__upd_by , t_test_a.`edit_flag` t_test_a__edit_flag , t_test_a.`tnt_id` t_test_a__tnt_id , t_test_c.`id` t_test_c__id , t_test_c.`a_id` t_test_c__a_id , t_test_c.`b_id` t_test_c__b_id , t_test_c.`c_id` t_test_c__c_id , t_test_c.`crt_tm` t_test_c__crt_tm , t_test_c.`crt_by` t_test_c__crt_by , t_test_c.`upd_tm` t_test_c__upd_tm , t_test_c.`upd_by` t_test_c__upd_by , t_test_c.`edit_flag` t_test_c__edit_flag , t_test_c.`tnt_id` t_test_c__tnt_id </otherwise>
</choose> FROM t_test_a t_test_a RIGHT JOIN t_test_c t_test_c on t_test_a.b_id=t_test_c.id AND t_test_a.edit_flag=0 <if test="ew != null and ew.sqlOnMap != null and ew.sqlOnMap.acOn != null and ew.sqlOnMap.acOn != ''">
 AND ${ew.sqlOnMap.acOn}
</if> <trim prefix="WHERE" prefixOverrides="AND|OR">
 AND t_test_c.edit_flag=0
<if test="ew != null">
<if test="ew.id != null">
 AND t_test_a.id = ${ew.id}
</if>
<if test="ew.sqlSegment != null and ew.sqlSegment != '' and ew.nonEmptyOfWhere">
 AND ${ew.sqlSegment}
</if>
<if test="ew.sqlSegment != null and ew.sqlSegment != '' and ew.emptyOfWhere">
 ${ew.sqlSegment}
</if>
</if>
</trim>
</script>
/**
     * t_test_a 一对多 t_test_b
     * 如果t_test_b对应得rightClass 为约定得  TestBVo.class, 可以缺省
     * 由于TestADto中对应得属性List<TestBDto> testBList 这种类型property 对应的是该属性属性名
     */
    @Link(  print = true, printRm = true,
            manys = { @OneToMany(leftColumn = "b_id", rightClass = TestBVo.class, ofTypeClass = TestBDto.class, property = "testBList") })
    List<TestADto> listTestAWTestB(@Param(Constants.WRAPPER) Wrapper<TestAVo> wrapper);
<resultMap id="yui.bss.test.dao.TestADao.listTestAWTestB-ResultMap" type="class yui.bss.test.dto.TestADto">
    <result property="testAVo.id" column="t_test_a__id" jdbcType="class java.lang.Long"/>
    <result property="testAVo.cId" column="t_test_a__c_id" jdbcType="class java.lang.Long"/>
    <result property="testAVo.bId" column="t_test_a__b_id" jdbcType="class java.lang.Long"/>
    <result property="testAVo.aId" column="t_test_a__a_id" jdbcType="class java.lang.Long"/>
    <result property="testAVo.crtTm" column="t_test_a__crt_tm" jdbcType="class java.util.Date"/>
    <result property="testAVo.crtBy" column="t_test_a__crt_by" jdbcType="class java.lang.String"/>
    <result property="testAVo.updTm" column="t_test_a__upd_tm" jdbcType="class java.util.Date"/>
    <result property="testAVo.updBy" column="t_test_a__upd_by" jdbcType="class java.lang.String"/>
    <result property="testAVo.editFlag" column="t_test_a__edit_flag" jdbcType="class java.lang.Integer"/>
    <result property="testAVo.tntId" column="t_test_a__tnt_id" jdbcType="class java.lang.Long"/>
    <collection property="testBList" column="t_test_a__b_id" ofType="interface java.util.List" select="yui.bss.test.dao.TestADao._listTestAWTestB_testBList"/>
</resultMap>
<resultMap id="yui.bss.test.dao.TestADao._listTestAWTestB_testBList-ResultMap" type="class yui.bss.test.dto.TestBDto">
    <result property="testBVo.id" column="t_test_b__id" jdbcType="class java.lang.Long"/>
    <result property="testBVo.aId" column="t_test_b__a_id" jdbcType="class java.lang.Long"/>
    <result property="testBVo.cId" column="t_test_b__c_id" jdbcType="class java.lang.Long"/>
    <result property="testBVo.crtTm" column="t_test_b__crt_tm" jdbcType="class java.util.Date"/>
    <result property="testBVo.crtBy" column="t_test_b__crt_by" jdbcType="class java.lang.String"/>
    <result property="testBVo.updTm" column="t_test_b__upd_tm" jdbcType="class java.util.Date"/>
    <result property="testBVo.updBy" column="t_test_b__upd_by" jdbcType="class java.lang.String"/>
    <result property="testBVo.editFlag" column="t_test_b__edit_flag" jdbcType="class java.lang.Integer"/>
    <result property="testBVo.tntId" column="t_test_b__tnt_id" jdbcType="class java.lang.Long"/>
</resultMap>
<script>
SELECT <choose>
<when test="ew != null and ew.sqlSelect != null">
${ew.sqlSelect}
</when>
<otherwise> t_test_a.`id` t_test_a__id , t_test_a.`c_id` t_test_a__c_id , t_test_a.`b_id` t_test_a__b_id , t_test_a.`a_id` t_test_a__a_id , t_test_a.`crt_tm` t_test_a__crt_tm , t_test_a.`crt_by` t_test_a__crt_by , t_test_a.`upd_tm` t_test_a__upd_tm , t_test_a.`upd_by` t_test_a__upd_by , t_test_a.`edit_flag` t_test_a__edit_flag , t_test_a.`tnt_id` t_test_a__tnt_id </otherwise>
</choose> FROM t_test_a t_test_a <trim prefix="WHERE" prefixOverrides="AND|OR">
 AND t_test_a.edit_flag=0
<if test="ew != null">
<if test="ew.id != null">
 AND t_test_a.id = ${ew.id}
</if>
<if test="ew.sqlSegment != null and ew.sqlSegment != '' and ew.nonEmptyOfWhere">
 AND ${ew.sqlSegment}
</if>
<if test="ew.sqlSegment != null and ew.sqlSegment != '' and ew.emptyOfWhere">
 ${ew.sqlSegment}
</if>
</if>
</trim>
</script>
<script>
SELECT  t_test_b.`id` t_test_b__id , t_test_b.`a_id` t_test_b__a_id , t_test_b.`c_id` t_test_b__c_id , t_test_b.`crt_tm` t_test_b__crt_tm , t_test_b.`crt_by` t_test_b__crt_by , t_test_b.`upd_tm` t_test_b__upd_tm , t_test_b.`upd_by` t_test_b__upd_by , t_test_b.`edit_flag` t_test_b__edit_flag , t_test_b.`tnt_id` t_test_b__tnt_id  FROM t_test_b t_test_b <trim prefix="WHERE" prefixOverrides="AND|OR">
 AND t_test_b.edit_flag=0 and t_test_b.id = #{t_test_a__b_id}
{
  "code": 0,
  "data": {
    "list": [
      {
        "testAVo2": null,
        "testAVo": {
          "crtTm": "2017-11-07 15:17:11",
          "crtBy": null,
          "updTm": "2018-12-18 02:30:11",
          "updBy": "admin",
          "editFlag": 0,
          "tntId": null,
          "id": 1,
          "cid": 1,
          "aid": null,
          "bid": 1
        },
        "testBVo": null,
        "testCVo": null,
        "testDVo": null,
        "testBList": [
          {
            "testBVo": {
              "crtTm": "2017-11-07 15:17:11",
              "crtBy": null,
              "updTm": "2018-12-18 02:30:11",
              "updBy": "admin",
              "editFlag": 0,
              "tntId": null,
              "id": 1,
              "cid": 1,
              "aid": 1
            },
            "testCVo": null
          }
        ],
        "testCList": null
      },
      {
        "testAVo2": null,
        "testAVo": {
          "crtTm": null,
          "crtBy": null,
          "updTm": null,
          "updBy": null,
          "editFlag": 0,
          "tntId": null,
          "id": 2,
          "cid": 1,
          "aid": 1,
          "bid": 1
        },
        "testBVo": null,
        "testCVo": null,
        "testDVo": null,
        "testBList": [
          {
            "testBVo": {
              "crtTm": "2017-11-07 15:17:11",
              "crtBy": null,
              "updTm": "2018-12-18 02:30:11",
              "updBy": "admin",
              "editFlag": 0,
              "tntId": null,
              "id": 1,
              "cid": 1,
              "aid": 1
            },
            "testCVo": null
          }
        ],
        "testCList": null
      }
    ]
  }
}
/**
    * t_test_a 一对多 t_test_b, t_test_a 一对多 t_test_c
    */
   @Link(  print = true, printRm = true, 
           manys = { @OneToMany(leftColumn = "b_id", rightClass = TestBVo.class, ofTypeClass = TestBDto.class, property = "testBList"),
                     @OneToMany(leftColumn = "c_id", rightClass = TestCVo.class, ofTypeClass = TestCDto.class, property = "testCList")})
   List<TestADto> listTestAWTestBWTestC(@Param(Constants.WRAPPER) Wrapper<TestAVo> wrapper);
<script>
SELECT <choose>
<when test="ew != null and ew.sqlSelect != null">
${ew.sqlSelect}
</when>
<otherwise> t_test_a.`id` t_test_a__id , t_test_a.`c_id` t_test_a__c_id , t_test_a.`b_id` t_test_a__b_id , t_test_a.`a_id` t_test_a__a_id , t_test_a.`crt_tm` t_test_a__crt_tm , t_test_a.`crt_by` t_test_a__crt_by , t_test_a.`upd_tm` t_test_a__upd_tm , t_test_a.`upd_by` t_test_a__upd_by , t_test_a.`edit_flag` t_test_a__edit_flag , t_test_a.`tnt_id` t_test_a__tnt_id </otherwise>
</choose> FROM t_test_a t_test_a <trim prefix="WHERE" prefixOverrides="AND|OR">
 AND t_test_a.edit_flag=0
<if test="ew != null">
<if test="ew.id != null">
 AND t_test_a.id = ${ew.id}
</if>
<if test="ew.sqlSegment != null and ew.sqlSegment != '' and ew.nonEmptyOfWhere">
 AND ${ew.sqlSegment}
</if>
<if test="ew.sqlSegment != null and ew.sqlSegment != '' and ew.emptyOfWhere">
 ${ew.sqlSegment}
</if>
</if>
</trim>
</script>
<script>
SELECT  t_test_b.`id` t_test_b__id , t_test_b.`a_id` t_test_b__a_id , t_test_b.`c_id` t_test_b__c_id , t_test_b.`crt_tm` t_test_b__crt_tm , t_test_b.`crt_by` t_test_b__crt_by , t_test_b.`upd_tm` t_test_b__upd_tm , t_test_b.`upd_by` t_test_b__upd_by , t_test_b.`edit_flag` t_test_b__edit_flag , t_test_b.`tnt_id` t_test_b__tnt_id  FROM t_test_b t_test_b <trim prefix="WHERE" prefixOverrides="AND|OR">
 AND t_test_b.edit_flag=0 and t_test_b.id = #{t_test_a__b_id}

</trim>
</script>

<script>
SELECT  t_test_c.`id` t_test_c__id , t_test_c.`a_id` t_test_c__a_id , t_test_c.`b_id` t_test_c__b_id , t_test_c.`c_id` t_test_c__c_id , t_test_c.`crt_tm` t_test_c__crt_tm , t_test_c.`crt_by` t_test_c__crt_by , t_test_c.`upd_tm` t_test_c__upd_tm , t_test_c.`upd_by` t_test_c__upd_by , t_test_c.`edit_flag` t_test_c__edit_flag , t_test_c.`tnt_id` t_test_c__tnt_id  FROM t_test_c t_test_c <trim prefix="WHERE" prefixOverrides="AND|OR">
 AND t_test_c.edit_flag=0 and t_test_c.id = #{t_test_a__c_id}
{
  "code": 0,
  "data": {
    "list": [
      {
        "testAVo2": null,
        "testAVo": {
          "crtTm": "2017-11-07 15:17:11",
          "crtBy": null,
          "updTm": "2018-12-18 02:30:11",
          "updBy": "admin",
          "editFlag": 0,
          "tntId": null,
          "id": 1,
          "cid": 1,
          "aid": null,
          "bid": 1
        },
        "testBVo": null,
        "testCVo": null,
        "testDVo": null,
        "testBList": [
          {
            "testBVo": {
              "crtTm": "2017-11-07 15:17:11",
              "crtBy": null,
              "updTm": "2018-12-18 02:30:11",
              "updBy": "admin",
              "editFlag": 0,
              "tntId": null,
              "id": 1,
              "cid": 1,
              "aid": 1
            },
            "testCVo": null
          }
        ],
        "testCList": [
          {
            "testCVo": {
              "crtTm": "2017-11-07 15:17:11",
              "crtBy": null,
              "updTm": "2018-12-18 02:30:11",
              "updBy": "admin",
              "editFlag": 0,
              "tntId": null,
              "id": 1,
              "cid": 1,
              "aid": 1,
              "bid": 1
            }
          }
        ]
      },
      {
        "testAVo2": null,
        "testAVo": {
          "crtTm": null,
          "crtBy": null,
          "updTm": null,
          "updBy": null,
          "editFlag": 0,
          "tntId": null,
          "id": 2,
          "cid": 1,
          "aid": 1,
          "bid": 1
        },
        "testBVo": null,
        "testCVo": null,
        "testDVo": null,
        "testBList": [
          {
            "testBVo": {
              "crtTm": "2017-11-07 15:17:11",
              "crtBy": null,
              "updTm": "2018-12-18 02:30:11",
              "updBy": "admin",
              "editFlag": 0,
              "tntId": null,
              "id": 1,
              "cid": 1,
              "aid": 1
            },
            "testCVo": null
          }
        ],
        "testCList": [
          {
            "testCVo": {
              "crtTm": "2017-11-07 15:17:11",
              "crtBy": null,
              "updTm": "2018-12-18 02:30:11",
              "updBy": "admin",
              "editFlag": 0,
              "tntId": null,
              "id": 1,
              "cid": 1,
              "aid": 1,
              "bid": 1
            }
          }
        ]
      }
    ]
  }
}
/**
     * t_test_a 一对一  t_test_b, t_test_a 一对多 t_test_b
     */
    @Link(  print = true, printRm = true,
            ones = { @OneToOne(leftColumn = "b_id", rightClass = TestBVo.class)},
            manys = { @OneToMany(leftClass = TestAVo.class, leftColumn = "b_id", rightClass = TestBVo.class, ofTypeClass = TestBDto.class, property = "testBList") })
    List<TestADto> listTestAATestBWTestB(@Param(Constants.WRAPPER) Wrapper<TestAVo> wrapper);
<script>
SELECT <choose>
<when test="ew != null and ew.sqlSelect != null">
${ew.sqlSelect}
</when>
<otherwise> t_test_a.`id` t_test_a__id , t_test_a.`c_id` t_test_a__c_id , t_test_a.`b_id` t_test_a__b_id , t_test_a.`a_id` t_test_a__a_id , t_test_a.`crt_tm` t_test_a__crt_tm , t_test_a.`crt_by` t_test_a__crt_by , t_test_a.`upd_tm` t_test_a__upd_tm , t_test_a.`upd_by` t_test_a__upd_by , t_test_a.`edit_flag` t_test_a__edit_flag , t_test_a.`tnt_id` t_test_a__tnt_id , t_test_b.`id` t_test_b__id , t_test_b.`a_id` t_test_b__a_id , t_test_b.`c_id` t_test_b__c_id , t_test_b.`crt_tm` t_test_b__crt_tm , t_test_b.`crt_by` t_test_b__crt_by , t_test_b.`upd_tm` t_test_b__upd_tm , t_test_b.`upd_by` t_test_b__upd_by , t_test_b.`edit_flag` t_test_b__edit_flag , t_test_b.`tnt_id` t_test_b__tnt_id </otherwise>
</choose> FROM t_test_a t_test_a INNER JOIN t_test_b t_test_b <trim prefix="WHERE" prefixOverrides="AND|OR">
 AND t_test_a.edit_flag=0 AND t_test_b.edit_flag=0 and t_test_a.b_id=t_test_b.id
<if test="ew != null">
<if test="ew.id != null">
 AND t_test_a.id = ${ew.id}
</if>
<if test="ew.sqlSegment != null and ew.sqlSegment != '' and ew.nonEmptyOfWhere">
 AND ${ew.sqlSegment}
</if>
<if test="ew.sqlSegment != null and ew.sqlSegment != '' and ew.emptyOfWhere">
 ${ew.sqlSegment}
</if>
</if>
</trim>
</script>

<script>
SELECT  t_test_b.`id` t_test_b__id , t_test_b.`a_id` t_test_b__a_id , t_test_b.`c_id` t_test_b__c_id , t_test_b.`crt_tm` t_test_b__crt_tm , t_test_b.`crt_by` t_test_b__crt_by , t_test_b.`upd_tm` t_test_b__upd_tm , t_test_b.`upd_by` t_test_b__upd_by , t_test_b.`edit_flag` t_test_b__edit_flag , t_test_b.`tnt_id` t_test_b__tnt_id  FROM t_test_b t_test_b <trim prefix="WHERE" prefixOverrides="AND|OR">
 AND t_test_b.edit_flag=0 and t_test_b.id = #{t_test_a__b_id}

</trim>
</script>
/**
     * t_test_a 一对一  t_test_b, t_test_a 一对多 t_test_b, 多表中 t_test_b 一对一 t_test_c
     */
    @Link(  print = true, printRm = true,
            ones = { @OneToOne(leftColumn = "b_id", rightClass = TestBVo.class)},
            manys = { @OneToMany(leftClass = TestAVo.class, leftColumn = "b_id", rightClass = TestBVo.class, ofTypeClass = TestBDto.class, property = "testBList", 
            ones = { @OneToOne(leftColumn = "c_id", rightClass = TestCVo.class)} )})
    List<TestADto> listTestAATestBWTestBATestC(@Param(Constants.WRAPPER) Wrapper<TestAVo> wrapper);
<script>
SELECT <choose>
<when test="ew != null and ew.sqlSelect != null">
${ew.sqlSelect}
</when>
<otherwise> t_test_a.`id` t_test_a__id , t_test_a.`c_id` t_test_a__c_id , t_test_a.`b_id` t_test_a__b_id , t_test_a.`a_id` t_test_a__a_id , t_test_a.`crt_tm` t_test_a__crt_tm , t_test_a.`crt_by` t_test_a__crt_by , t_test_a.`upd_tm` t_test_a__upd_tm , t_test_a.`upd_by` t_test_a__upd_by , t_test_a.`edit_flag` t_test_a__edit_flag , t_test_a.`tnt_id` t_test_a__tnt_id , t_test_b.`id` t_test_b__id , t_test_b.`a_id` t_test_b__a_id , t_test_b.`c_id` t_test_b__c_id , t_test_b.`crt_tm` t_test_b__crt_tm , t_test_b.`crt_by` t_test_b__crt_by , t_test_b.`upd_tm` t_test_b__upd_tm , t_test_b.`upd_by` t_test_b__upd_by , t_test_b.`edit_flag` t_test_b__edit_flag , t_test_b.`tnt_id` t_test_b__tnt_id </otherwise>
</choose> FROM t_test_a t_test_a INNER JOIN t_test_b t_test_b <trim prefix="WHERE" prefixOverrides="AND|OR">
 AND t_test_a.edit_flag=0 AND t_test_b.edit_flag=0 and t_test_a.b_id=t_test_b.id
<if test="ew != null">
<if test="ew.id != null">
 AND t_test_a.id = ${ew.id}
</if>
<if test="ew.sqlSegment != null and ew.sqlSegment != '' and ew.nonEmptyOfWhere">
 AND ${ew.sqlSegment}
</if>
<if test="ew.sqlSegment != null and ew.sqlSegment != '' and ew.emptyOfWhere">
 ${ew.sqlSegment}
</if>
</if>
</trim>
</script>

<script>
SELECT  t_test_b.`id` t_test_b__id , t_test_b.`a_id` t_test_b__a_id , t_test_b.`c_id` t_test_b__c_id , t_test_b.`crt_tm` t_test_b__crt_tm , t_test_b.`crt_by` t_test_b__crt_by , t_test_b.`upd_tm` t_test_b__upd_tm , t_test_b.`upd_by` t_test_b__upd_by , t_test_b.`edit_flag` t_test_b__edit_flag , t_test_b.`tnt_id` t_test_b__tnt_id , t_test_c.`id` t_test_c__id , t_test_c.`a_id` t_test_c__a_id , t_test_c.`b_id` t_test_c__b_id , t_test_c.`c_id` t_test_c__c_id , t_test_c.`crt_tm` t_test_c__crt_tm , t_test_c.`crt_by` t_test_c__crt_by , t_test_c.`upd_tm` t_test_c__upd_tm , t_test_c.`upd_by` t_test_c__upd_by , t_test_c.`edit_flag` t_test_c__edit_flag , t_test_c.`tnt_id` t_test_c__tnt_id  FROM t_test_b t_test_b INNER JOIN t_test_c t_test_c <trim prefix="WHERE" prefixOverrides="AND|OR">
 AND t_test_b.edit_flag=0 and t_test_b.id = #{t_test_a__b_id}
 AND t_test_c.edit_flag=0 and t_test_b.c_id=t_test_c.id
</trim>
</script>
{
  "code": 0,
  "data": {
    "list": [
      {
        "testAVo2": null,
        "testAVo": {
          "crtTm": "2017-11-07 15:17:11",
          "crtBy": null,
          "updTm": "2018-12-18 02:30:11",
          "updBy": "admin",
          "editFlag": 0,
          "tntId": null,
          "id": 1,
          "cid": 1,
          "aid": null,
          "bid": 1
        },
        "testBVo": {
          "crtTm": "2017-11-07 15:17:11",
          "crtBy": null,
          "updTm": "2018-12-18 02:30:11",
          "updBy": "admin",
          "editFlag": 0,
          "tntId": null,
          "id": 1,
          "cid": 1,
          "aid": 1
        },
        "testCVo": null,
        "testDVo": null,
        "testBList": [
          {
            "testBVo": {
              "crtTm": "2017-11-07 15:17:11",
              "crtBy": null,
              "updTm": "2018-12-18 02:30:11",
              "updBy": "admin",
              "editFlag": 0,
              "tntId": null,
              "id": 1,
              "cid": 1,
              "aid": 1
            },
            "testCVo": {
              "crtTm": "2017-11-07 15:17:11",
              "crtBy": null,
              "updTm": "2018-12-18 02:30:11",
              "updBy": "admin",
              "editFlag": 0,
              "tntId": null,
              "id": 1,
              "cid": 1,
              "aid": 1,
              "bid": 1
            }
          }
        ],
        "testCList": null
      },
      {
        "testAVo2": null,
        "testAVo": {
          "crtTm": null,
          "crtBy": null,
          "updTm": null,
          "updBy": null,
          "editFlag": 0,
          "tntId": null,
          "id": 2,
          "cid": 1,
          "aid": 1,
          "bid": 1
        },
        "testBVo": {
          "crtTm": "2017-11-07 15:17:11",
          "crtBy": null,
          "updTm": "2018-12-18 02:30:11",
          "updBy": "admin",
          "editFlag": 0,
          "tntId": null,
          "id": 1,
          "cid": 1,
          "aid": 1
        },
        "testCVo": null,
        "testDVo": null,
        "testBList": [
          {
            "testBVo": {
              "crtTm": "2017-11-07 15:17:11",
              "crtBy": null,
              "updTm": "2018-12-18 02:30:11",
              "updBy": "admin",
              "editFlag": 0,
              "tntId": null,
              "id": 1,
              "cid": 1,
              "aid": 1
            },
            "testCVo": {
              "crtTm": "2017-11-07 15:17:11",
              "crtBy": null,
              "updTm": "2018-12-18 02:30:11",
              "updBy": "admin",
              "editFlag": 0,
              "tntId": null,
              "id": 1,
              "cid": 1,
              "aid": 1,
              "bid": 1
            }
          }
        ],
        "testCList": null
      }
    ]
  }
}
/**
     * t_test_a 与   t_test_b 一对一分页连表查询
     */
    @Link(  print = true, printRm = true,
            ones = { @OneToOne(rightClass = TestBVo.class, rightColumn = "a_id") })
    IPage<TestADto> pageTestAATestB(IPage<TestADto> page, @Param(Constants.WRAPPER) Wrapper<TestAVo> wrapper);
<script>
SELECT <choose>
<when test="ew != null and ew.sqlSelect != null">
${ew.sqlSelect}
</when>
<otherwise> t_test_a.`id` t_test_a__id , t_test_a.`c_id` t_test_a__c_id , t_test_a.`b_id` t_test_a__b_id , t_test_a.`a_id` t_test_a__a_id , t_test_a.`crt_tm` t_test_a__crt_tm , t_test_a.`crt_by` t_test_a__crt_by , t_test_a.`upd_tm` t_test_a__upd_tm , t_test_a.`upd_by` t_test_a__upd_by , t_test_a.`edit_flag` t_test_a__edit_flag , t_test_a.`tnt_id` t_test_a__tnt_id , t_test_b.`id` t_test_b__id , t_test_b.`a_id` t_test_b__a_id , t_test_b.`c_id` t_test_b__c_id , t_test_b.`crt_tm` t_test_b__crt_tm , t_test_b.`crt_by` t_test_b__crt_by , t_test_b.`upd_tm` t_test_b__upd_tm , t_test_b.`upd_by` t_test_b__upd_by , t_test_b.`edit_flag` t_test_b__edit_flag , t_test_b.`tnt_id` t_test_b__tnt_id </otherwise>
</choose> FROM t_test_a t_test_a INNER JOIN t_test_b t_test_b <trim prefix="WHERE" prefixOverrides="AND|OR">
 AND t_test_a.edit_flag=0 AND t_test_b.edit_flag=0 and t_test_a.id=t_test_b.a_id
<if test="ew != null">
<if test="ew.id != null">
 AND t_test_a.id = ${ew.id}
</if>
<if test="ew.sqlSegment != null and ew.sqlSegment != '' and ew.nonEmptyOfWhere">
 AND ${ew.sqlSegment}
</if>
<if test="ew.sqlSegment != null and ew.sqlSegment != '' and ew.emptyOfWhere">
 ${ew.sqlSegment}
</if>
</if>
</trim>
</script>
{
  "code": 0,
  "data": {
    "list": [
      {
        "testAVo2": null,
        "testAVo": {
          "crtTm": "2017-11-07 15:17:11",
          "crtBy": null,
          "updTm": "2018-12-18 02:30:11",
          "updBy": "admin",
          "editFlag": 0,
          "tntId": null,
          "id": 1,
          "cid": 1,
          "aid": null,
          "bid": 1
        },
        "testBVo": {
          "crtTm": "2017-11-07 15:17:11",
          "crtBy": null,
          "updTm": "2018-12-18 02:30:11",
          "updBy": "admin",
          "editFlag": 0,
          "tntId": null,
          "id": 1,
          "cid": 1,
          "aid": 1
        },
        "testCVo": null,
        "testDVo": null,
        "testBList": null,
        "testCList": null
      }
    ]
  },
  "page": {
    "total": 1,
    "pageSize": 10,
    "pageNum": 1
  }
}
/**
     * t_test_a 与   t_test_b 连表行数查询
     */
    @Link(  print = true, printRm = true,
            ones = { @OneToOne(rightClass = TestBVo.class, rightColumn = "a_id") })
    Integer countTestAATestB(@Param(Constants.WRAPPER) Wrapper<TestAVo> wrapper);
<script>
SELECT COUNT(1) FROM t_test_a t_test_a INNER JOIN t_test_b t_test_b <trim prefix="WHERE" prefixOverrides="AND|OR">
 AND t_test_a.edit_flag=0 AND t_test_b.edit_flag=0 and t_test_a.id=t_test_b.a_id
<if test="ew != null">
<if test="ew.sqlSegment != null and ew.sqlSegment != '' and ew.nonEmptyOfWhere">
 AND ${ew.sqlSegment}
</if>
<if test="ew.sqlSegment != null and ew.sqlSegment != '' and ew.emptyOfWhere">
 ${ew.sqlSegment}
</if>
</if>
</trim>
</script>
{
  "code": 0,
  "data": 1
}

easy4use
关注
  • 3
    点赞
  • 踩
  • 8
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Spring boot整合Mybatis实现级联一对多CRUD操作的完整步骤
08-25
主要给大家介绍了关于Spring boot整合Mybatis实现级联一对多CRUD操作的相关资料，文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值，需要的朋友们下面来一起学习学习吧
springboot 集成mybatis-plus，报Error evaluating expression ‘ew != null and !ew.emptyOfWhere‘. 原因之一
chenqunjian的博客
12-22 7961
报错信息： ERROR - 2020-12-14 21:01:39,317 - cn.com.bjfanuc.controller.SysMessageController - >>>>>>>>>>> URL: /sysmsg/getUnReadMsgCount, throw Exception => {} org.mybatis.spring.MyBatisSystemException: nested exception is o
Mybatis-Plus查询或更新报错
abde630154071的博客
07-02 5768
报错 Error evaluating expression 'ew != null and ew.sqlFirst != null'.Cause : org.apache.ibatis.ognl.OgnlException : sqlFirst 原因 QueryWrapper不能作为更新条件构造器 QueryChainWrapper不能作为查询条件构造器 错误用法: list(query ) 正确用法:query.list(); QueryChainWrapper<ReceiveMessage&g
Error evaluating expression ‘ew.sqlSegment != null and ew.sqlSegment != ‘‘ and ew.nonEmptyOfWhere‘.
最新发布
qq_71654538的博客
03-09 478
这里是mybatis plus的版本问题，我这里是将其版本从3.4.3换成3.4.2就解决了。
mybatis plus中的${ew.sqlSegment}，${ew.sqlSelect}，${ew.customSqlSegment}使用
m0_60721514的博客
03-08 1万+
ew是mapper方法里的@Param(Constants.WRAPPER) Wrapper queryWrapper对象 首先判断ew.emptyOfWhere是否存在where条件，有的话再拼接上去，ew.customSqlSegment是WHERE + sql语句 没有where的时候加上 == false 使用${ew.sqlSegment} 如果是连表查询且查询条件是连表的字段则需在service层拼接查询条件时字段前指定别名 最佳例子1 mapper.xml <select id="ta
修改Mybatisplus2.x源码来对多数据库关键字的兼容处理
zhu1361的专栏
04-07 1095
接上文，因为是对已有系统进行改造，所以会存在关键字的问题，但是如果修改字段工作量缺失太大，但是用到mybatisplus自带的方法又无法避免，想到去修改源码文件来实现，下面上内容 mybatisplus的sql注入器为AutoSqlInjector文件位于com.baomidou.mybatisplus.mapper中，那我们在项目根目录下建立相同路径的文件 然后对其生成sql的方法进行改造： injectInsertOneSql、sqlSelectColumns、sqlSelectObjsCo
Springboot启动异常 OgnlException: sqlSelect [java.lang.NoSuchMethodError
jiangzhongwei_的博客
12-20 537
我预感我的问题就是这个，在pom这里，这里如果没有这个依赖分析的tab，那可能是需要下载一个插件maven helper, 时间久远有点忘了。还有个情况是，之前项目运行打包都是可以的，但是今天linux上打包运行报错了，这种情况大概率也是版本不匹配导致的，之前一直正常或许是强缓存吧。因为我这里已经改好了，所以会看到只有一个，当时是看到有两个，一个1.0，一个4.7版本的，我把这两个都排除掉了，参考如下。这种语法问题，日志里会明确的告诉你，是值为空了，或者某属性不存在了，所以和我的问题应该不一样。
mybatis一对多查询功能
08-31
主要介绍了mybatis一对多查询功能,非常不错，具有参考借鉴价值，需要的朋友可以参考下
mybatis 一对一、一对多和多对多查询实例代码
08-27
主要介绍了mybatis 一对一、一对多和多对多查询的实例代码，非常不错，具有一定的参考借鉴价值,需要的朋友可以参考下
mybatis递归 一对多的实现方法示例
08-27
mybatis递归 一对多的实现方法示例
通过Mybatis实现单表内一对多的数据展示示例代码
10-19
最近做项目遇到这样的需求要求将表中的数据,按照一级二级分类返回给前端json数据，下面通过本文给大家分享通过Mybatis实现单表内一对多的数据展示示例代码，感兴趣的朋友参考下吧
Error evaluating解决xpression ‘ew.sqlSegment != null and ew.sqlSegment != ‘‘ and ew.nonEmptyOfWhere‘.
热门推荐
w3x3g的博客
09-28 2万+
（看文章之前要排除，自身的代码bug，本文是在本身代码没问题的基础上，依赖包版本过低导致的） 先上错误和描述，使用的mybatisplus插件，开始用的是3.1.1版本，然后本地运行项目没有问题，之前将项目打包成war包，也没问题，可以在服务器上正常运行。 但是要求，将项目打包成jar包，本地没有问题，使用项目分离的形式进行打包，并且在服务器上运行的时候，在使用到lambda表达式的代码报错，如下： org.mybatis.spring.MyBatisSystemException: nested exc
MybatisPlus BaseMapper 实现对数据库增删改查源码解析
m0_71777195的博客
02-01 2083
MybatisPlus 是一款在 Mybatis 基础上进行的增强 orm 框架，可以实现不写 sql 就完成数据库相关的操作。接下来就对其源码一探究竟，看看他到底是如何实现的。
Springboot整合SSMP报错分析
CJPSR的博客
05-11 2275
本文主要介绍了在Springboot中整合SSMP的一些报错分析~
MyBatis-plus一对一和一对多动态查询案例
hq.zheng的博客
04-01 627
XML相关配置，其中一对一使用association。其中一对多使用collection。一、一对一和一对多混合案例。
springboot整合mybatis-plus报错(版本原因)
qq_51560486的博客
03-19 2832
在pom.xml文件中修改整合包版本，修改为3.4.2就不报错了
使用mybaisplus时使用LambdaQueryWrapper进行条件查询发生evaluating expression异常处理
weixin_50567326的博客
03-24 1717
使用LambdaQueryWrapper进行条件查询发生evaluating expression异常
MybatisPlus多表连接查询 支持一对一、一对对、多对多查询
m0_62396648的博客
04-26 4382
MybatisPlus多表连接查询 支持一对一、一对对、多对多查询 一、序言 （一）背景内容 软件应用技术架构中DAO层最常见的选型组件为MyBatis，熟悉MyBatis的朋友都清楚，曾几何时MyBatis是多么的风光，使用XML文件解决了复杂的数据库访问的难题。时至今日，曾经的屠龙者终成恶龙，以XML文件为基础的数据库访问技术变得臃肿、复杂，维护难度直线上升。 MybatisPlus对常见的数据库访问进行了封装，访问数据库大大减少了XML文件的依赖，开发者从臃肿的XML文件中获得了较大限..
mybatis-plus的一对多注解
03-16
Mybatis-Plus的一对多注解是@OneToMany，用于在实体类中定义一对多关系。该注解需要指定多方实体类的类型和多方实体类在一方实体类中的属性名。同时，需要在多方实体类中定义一方实体类的属性，并使用@ManyToOne注解标注。这样，Mybatis-Plus就能够自动完成一对多关系的映射。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值