mybatis 注解查询一对多，一对一

最新推荐文章于 2023-09-09 15:38:14 发布

HDXxiazai

最新推荐文章于 2023-09-09 15:38:14 发布

阅读量305

点赞数

分类专栏：开发文章标签： mybatis mybatis注解 mybatis Results mybatis一对多 mybatis一对一

本文链接：https://blog.csdn.net/HDXxiazai/article/details/126141696

版权

开发专栏收录该内容

59 篇文章 4 订阅

订阅专栏

 @Results({
    @Result(property = "jccsList", javaType= IwellFlJccsBo.class, 
    many =@Many(select="com.dcoit.dcoit_process_casebase.mapper.findJccsByJcsId"), 
    column = "jcsid")
  })
    @Select({"select a.JCSID,a.JCSMC,a.BJXS1,a.BJXS2,a.JCSLB,a.ZDYXSJ,b.GZID" 
      + " from IWELL_FL_JCS a join IWELL_FL_GZ b on a.GZID = b.GZID "
      +"and b.QYBZ = a.QYBZ "  
      + " where a.QYBZ = 'Y' and a.JCSID = #{jcsId} "})
    IwellFlJcsBo findJcsJccsRelationByJcsId(@Param("jcsId") String jcsId);



    @Select(value = "select a.CSZTID,a.CSZTQZ,a.JCCSLB,a.JKYZID,b.JKYZLB,b.JKYZMC " 
    + "  from IWELL_FL_JCCS a" +
      "  join IWELL_FL_JKYZ_CD b on a.JKYZID = b.JKYZID and b.QYBZ = a.QYBZ " +
      "  join IWELL_FL_JKCS c on a.CSID = c.CSID " +
      "  where a.QYBZ = 'Y' and a.JCSID = #{jcsId}")
    List<IwellFlJccsBo> findJccsByJcsId(@Param("jcsId") String jcsId);

@Select：查询语句，相当于mapper中<select> 标签
@Results：返回结果相当于mapper中<resultMap>标签
@Result：映射标签，相当于mapper中<result>标签

 @Result(column="GZMC",property="gzmc",jdbcType="VARCHAR") 
 相当于：
 <result column="GZMC" jdbcType="VARCHAR" property="gzmc"/>

 主键：
 @Result(column="id",property="id",jdbcType="JdbcType.Integer,id=true")

一对多关系：

@Result(property = "jccsList", javaType= IwellFlJccsBo.class, 
 many =@Many(select="com.dcoit.dcoit_process_casebase.mapper.findJccsByJcsId"), 
 column = "jcsid")

相当于：
  <collection property="jccsList"         
      ofType="com.dcoit.dcoit_process_casebase.mapper.findJccsByJcsId"
      select="findJccsByJcsId" column="jcsid">

一对一关系：
@Result(property = "jccsList", javaType= IwellFlJccsBo.class, 
 one =@one(select="com.dcoit.dcoit_process_casebase.mapper.findJccsByJcsId"), 
 column = "jcsid")