mybatis 注解查询一对多，一对一 - 码农知识堂

mybatis 注解查询一对多，一对一
```
 @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 findJccsByJcsId(@Param("jcsId") String jcsId);
```
@Select：查询语句，相当于mapper中