Mybatis 多对一使用

第一步在映射类 加入要关联的表的关系

package com.itheima.domain;

import java.io.Serializable;
import java.util.Date;
import java.util.List;

public class User implements Serializable {

   private  Integer userid;
   private  String username;
   private String  useraddress;
   private String usersex;
   private Date userbirthday;
   //多对一进行关联的时候需要调用
   private List<Account> accounts;

    public List<Account> getAccounts() {
        return accounts;
    }

    public void setAccounts(List<Account> accounts) {
        this.accounts = accounts;
    }

    public Integer getUserid() {
        return userid;
    }

    public void setUserid(Integer userid) {
        this.userid = userid;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getUseraddress() {
        return useraddress;
    }

    public void setUseraddress(String useraddress) {
        this.useraddress = useraddress;
    }

    public String getUsersex() {
        return usersex;
    }

    public void setUsersex(String usersex) {
        this.usersex = usersex;
    }

    public Date getUserbirthday() {
        return userbirthday;
    }

    public void setUserbirthday(Date userbirthday) {
        this.userbirthday = userbirthday;
    }

    @Override
    public String toString() {
        return "User{" +
                "userid=" + userid +
                ", username='" + username + '\'' +
                ", useraddress='" + useraddress + '\'' +
                ", usersex='" + usersex + '\'' +
                ", userbirthday=" + userbirthday +
                '}';
    }
}

第二步在映射接口封装方法

package com.itheima.dao;

import com.itheima.domain.User;
import org.apache.ibatis.annotations.*;
import org.apache.ibatis.mapping.FetchType;

import java.util.List;

public interface IUserDao {
    /**
     * 查找所有数据
     */
    @Select("select * from User")
    /**
     * 如果映射文件不予数据库对应可以使用一下方法
     */
    @Results(id="userMap",value = {
            @Result(id = true,column = "id",property = "userid"),
            @Result(column = "username",property = "username"),
            @Result(column = "address",property = "useraddress"),
            @Result(column = "sex",property = "usersex"),
            @Result(column = "birthday",property = "userbirthday"),
            //调用语句 多对一方法
            @Result(property = "accounts",column = "id",
                    //调用语句 一对一方法
                    many = @Many(select = "com.itheima.dao.IAccountDao.findAccountByUid",fetchType = FetchType.LAZY)
            )
            })
    List<User> finAll();
    /*
     * 新增方法
     */
    @Insert("insert into user(username,address,sex,birthday) values(#{username},#{address},#{sex},#{birthday})")
    @ResultMap(value = {"userMap"})
    void  saveUser(User user);
    /**
     * 修改方法
     */
    @Update("update user set username=#{username},address=#{address},sex=#{sex},birthday=#{birthday} where id=#{id}")
    @ResultMap(value = {"userMap"})
    void updateUser(User user);

    /**
     * 删除方法
     */

    @Delete("delete from user where id =#{id}")
    @ResultMap(value = {"userMap"})
    void deleteUser(Integer userId);
    /**
     * 查询方法
     * @return
     */
    @Select("select * from User where id =#{id}")
    @ResultMap(value = {"userMap"})
    User findById(Integer userId);

    /**
     * 搜索方法
     */
    //第一种方法
    @Select("select * from User where username like #{username}")
    @ResultMap(value = {"userMap"})
    List<User> FindByNames(String username );
    //第二种方法不需要百分号
    @Select("select * from User where username like '%${values}%'")
    @ResultMap(value = {"userMap"})
    List<User> FindByNameOne(String username );
    /**
     * 查询总用户数
     */
    @Select("select count(*) from User")
    @ResultMap(value = {"userMap"})
    int findTotalUser();


}

第三部在使用的映射接口写法方法

package com.itheima.dao;

import com.itheima.domain.Account;

import org.apache.ibatis.annotations.*;
import org.apache.ibatis.mapping.FetchType;

import java.util.List;

public interface IAccountDao {
    @Select("select * from Account")
    //  一对一使用
    @Results(id = "accountMap",value = {
            @Result(id = true,column = "id",property = "id"),
            @Result(column = "uid",property = "uid"),
            @Result(column = "money",property = "money"),
            @Result(property = "user",column = "uid",
            //调用语句 一对一方法
            one = @One(select = "com.itheima.dao.IUserDao.findById",fetchType = FetchType.EAGER)
            )
    })
    List<Account> finAll();
    //根据用户id 查询用户信息，关联时候使用
    @Select("select * from account where uid = #{userId}")
    List<Account> findAccountByUid(Integer userId);
}

最后一步，调用使用

package com.itheima;

import com.itheima.dao.IAccountDao;
import com.itheima.dao.IUserDao;
import com.itheima.domain.Account;
import com.itheima.domain.User;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;

import java.io.InputStream;
import java.util.List;

public class Accountest {
    private InputStream in;
    private SqlSession sqlSession;
    private IAccountDao AccountDao;

    @Before//用于在测试方法执行之前执行
    public void init()throws Exception{
        //1.读取配置文件，生成字节输入流
        in = Resources.getResourceAsStream("SqlMapConfig.xml");
        //2.获取SqlSessionFactory
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
        //3.获取SqlSession对象
        sqlSession = factory.openSession(true);
        //4.获取dao的代理对象
      AccountDao = sqlSession.getMapper(IAccountDao.class);
    }

    @After//用于在测试方法执行之后执行
    public void destroy()throws Exception{
        //提交事务
        sqlSession.commit();
        //6.释放资源
        sqlSession.close();
        in.close();
    }
    //多对一进行调用
    @Test
    public void findAll(){
        List<Account> accounts = AccountDao.finAll();
        for (Account account : accounts) {
            System.out.println(account);
            System.out.println(account.getUser());
        }


    }
}