coding++:mybatis 嵌套查询子查询column传多个参数描述
mybatis 嵌套查询子查询column传多个参数如下:
2、代码示例 备注:注意,相同颜色的单词都是有关联的
<resultMap id="blogResult" type="Blog"> <association property="author" column="{id=author_id,likename=author_name}" javaType="Author" select="selectAuthor"/> </resultMap> <select id="selectBlog" resultMap="blogResult" parameterType="java.lang.String"> SELECT author_id,author_name FROM BLOG WHERE ID = #{id} </select> <select id="selectAuthor" resultType="Author" parameterType="java.util.HashMap">
SELECT * FROM AUTHOR WHERE 1=1 <if test="id != null and id != '' "> and ID = #{id} </if> <if test="likename != null and likename != '' "> and name like CONCAT('%',#{likename},'%') </if> </select>