mybatis基于注解的关联查询

来源：互联网发布：php实例化是什么意思编辑：程序博客网时间：2024/04/29 07:53

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);}

0 0