MyBatis的嵌套查询的关联/收藏不起作用

问题描述

我想测试出的MyBatis的用户，结果地图部分手册。
MyBatis的版本：MyBatis的-3.1.0

I am trying to test out Mybatis's user manual with the result map section.Mybatis version : mybatis-3.1.0

<setting name="lazyLoadingEnabled" value="false" />


<resultMap id="blogMap" type="blog">
<constructor>
    <idArg column="id" javaType="_long" />
    <arg column="title" javaType="String" />
</constructor>
<association property="author" javaType="author" column = "author_id"           select = "getAuthor"/>
</resultMap>

<select id="getBlog" parameterType="Long" resultMap="blogMap">
    select
    b.id,
    b.title
    from
    blog b
    where b.id = #{id}
</select>

<select id="getAuthor" parameterType="Long" resultType="author">
    select
    a.id ,
    a.username,
    a.password
    from author a
where a.id = #{id}
</select>

我的Java类：

My Java classes :

public class Blog {
private long id;
private String title;

private Author author;
private List<Post> posts;
      //getter, setters and the constructor

public class Author {
private long id;
private String username;
private String password;
private String email;
private String bio;
private String favouriteSection;

最后，我的测试模块

Finally, my test Module

   BlogMapperInterface bm = context.getBean("blogMapper",BlogMapperInterface.class);
   Blog b = bm.getBlog(1);

调试堆栈跟踪

[10/05/12 06:45:19:019 SGT] DEBUG datasource.DataSourceUtils: Fetching JDBC Connection from DataSource
[10/05/12 06:45:19:019 SGT] DEBUG BlogMapperInterface.getBlog: ooo Using Connection        [jdbc:oracle:thin:@*, UserName=*, Oracle JDBC driver]
[10/05/12 06:45:19:019 SGT] DEBUG BlogMapperInterface.getBlog: ==>  Preparing: select b.id, b.title from blog b where b.id = ?
[10/05/12 06:45:19:019 SGT] DEBUG BlogMapperInterface.getBlog: ==> Parameters: 1(Long)
[10/05/12 06:45:19:019 SGT] DEBUG BlogMapperInterface.getBlog: <==    Columns: ID, TITLE
[10/05/12 06:45:19:019 SGT] DEBUG BlogMapperInterface.getBlog: <==        Row: 1, first blog
[10/05/12 06:45:19:019 SGT] DEBUG datasource.DataSourceUtils: Returning JDBC Connection to DataSource

为什么getAuthor不会被调用？应该不是，每当我打电话getBlog（）？它被调用

Why the getAuthor is not invoked? Shouldn't it be invoked whenever I call getBlog()?

推荐答案

由于没有在结果的AUTHOR_ID列从getBlog。

Because there is not an author_id column in the result got from getBlog.

尝试：

 select
    b.id,
    b.title,
    b.author_id
    from
    blog b
    where b.id = #{id}

这篇关于MyBatis的嵌套查询的关联/收藏不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！