mybatis基于注解的关联查询

mybatis使用注解进行关联查询时,需要使用@results手动配置结果映射

一对一关联查询:使用@one(一对多关联查询:使用@many)

package com.zwk.dao;

import com.zwk.domain.User;
import com.zwk.domain.UserInfo;
import org.apache.ibatis.annotations.*;

import java.util.List;

/**
 * Created by zwk on 16-11-22.
 */
public interface UserInfoDAO {
    //一个user对应一个userinfo
    @Select("select * from test_userinfo where id =#{id}")
    public UserInfo getUserInfoById(@Param("id") String id);

   //select ="com.zwk.dao.UserInfoDAO.getUserInfoById",getUserinfoById方法必须存在
    @Select("select * from test_user u where u.id = #{id}")
    @Results({
            @Result(id = true,property = "id" ,column = "id"),
            @Result(property ="password",column = "password"),
            @Result(property ="userInfo",column="info_id"
           ,one =@One(select ="com.zwk.dao.UserInfoDAO.getUserInfoById"))}
    )
    public User getById(@Param("id") String id);
}