需求：一個用戶可以有多個賬戶，查詢用戶時實現賬戶的延遲加載

1、用戶實體類

package com.yl.bean;import java.io.Serializable;import java.sql.Date;import java.util.List;/** * 用戶實體類 */public class User implements Serializable { private Integer id;//id private String username;//用戶名 private Date birthday;//生日 private String sex;//性別 private String address;//地址 private List<Account> accountList;//用戶所擁有的賬戶 public User() { } public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public Date getBirthday() { return birthday; } public void setBirthday(Date birthday) { this.birthday = birthday; } public String getSex() { return sex; } public void setSex(String sex) { this.sex = sex; } public String getAddress() { return address; } public void setAddress(String address) { this.address = address; } public List<Account> getAccountList() { return accountList; } public void setAccountList(List<Account> accountList) { this.accountList = accountList; } @Override public String toString() { return 'User{' +'id=' + id +', username=’' + username + ’’’ +', birthday=' + birthday +', sex=’' + sex + ’’’ +', address=’' + address + ’’’ +’}’; }}

2、賬戶實體類

package com.yl.bean;import java.io.Serializable;/** * 賬戶實體類 */public class Account implements Serializable { private Integer id;//賬戶id private Integer uid;//用戶id private Double money;//余額 private User user;//賬戶所屬用戶 public Account() { } public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public Integer getUid() { return uid; } public void setUid(Integer uid) { this.uid = uid; } public Double getMoney() { return money; } public void setMoney(Double money) { this.money = money; } public User getUser() { return user; } public void setUser(User user) { this.user = user; } @Override public String toString() { return 'Account{' +'id=' + id +', uid=' + uid +', money=' + money +’}’; }}

3、用戶持久層接口

package com.yl.dao;import com.yl.bean.User;import java.util.List;/** * 用戶持久層接口 */public interface IUserDao { /** * 查詢所有用戶 */ List<User> queryAll(); /** * 根據id查詢用戶 */ User queryById(int id);}

4、賬戶持久層接口

package com.yl.dao;import com.yl.bean.Account;import com.yl.bean.User;import java.util.List;/** * 賬戶持久層接口 */public interface IAccountDao { /** * 查詢所有賬戶 */ List<Account> queryAll(); /** * 根據用戶id查詢賬戶 */ List<Account> queryByUid(int uid);}

5、全局配置文件

<?xml version='1.0' encoding='UTF-8'?><!DOCTYPE configuration PUBLIC '-//mybatis.org//DTD Config 3.0//EN' 'http://mybatis.org/dtd/mybatis-3-config.dtd'><configuration> <settings> <!--開啟延遲加載--> <setting name='lazyLoadingEnabled' value='true'/> <setting name='aggressiveLazyLoading' value='false'/> </settings> <!--配置別名--> <typeAliases> <package name='com.yl.bean'/> </typeAliases> <!--配置mybatis環境--> <environments default='mysql'> <!--配置mysql環境--> <environment id='mysql'> <!--事務類型--> <transactionManager type='JDBC'></transactionManager> <!--數據源--> <dataSource type='POOLED'><property name='driver' value='com.mysql.cj.jdbc.Driver'/><property name='url' value='jdbc:mysql://localhost:3306/mybatis?characterEncoding=utf8&amp;serverTimezone=GMT%2B8'/><property name='username' value='root'/><property name='password' value='123456'/> </dataSource> </environment> </environments> <!--指定映射配置文件位置--> <mappers> <mapper resource='IUserDao.xml'></mapper> <mapper resource='IAccountDao.xml'></mapper> </mappers></configuration>

6、用戶映射配置文件

<?xml version='1.0' encoding='UTF-8'?><!DOCTYPE mapper PUBLIC '-//mybatis.org//DTD Mapper 3.0//EN' 'http://mybatis.org/dtd/mybatis-3-mapper.dtd'><mapper namespace='com.yl.dao.IUserDao'> <!--配置用戶實體類和數據庫的對應信息--> <resultMap type='com.yl.bean.User'> <id property='id' column='id'></id> <result property='username' column='username'></result> <result property='birthday' column='birthday'></result> <result property='sex' column='sex'></result> <result property='address' column='address'></result> <!--根據id查詢賬戶--> <collection property='accountList' ofType='com.yl.bean.Account' select='com.yl.dao.IAccountDao.queryByUid' column='id'></collection> </resultMap> <!--查詢所有用戶--> <select resultMap='userMap'> SELECT * FROM USER </select> <!--根據id查詢用戶--> <select resultType='user' parameterType='int'> select * from user where id=#{id} </select></mapper>

7、賬戶映射配置文件

<?xml version='1.0' encoding='UTF-8'?><!DOCTYPE mapper PUBLIC '-//mybatis.org//DTD Mapper 3.0//EN' 'http://mybatis.org/dtd/mybatis-3-mapper.dtd'><mapper namespace='com.yl.dao.IAccountDao'> <!--配置Account屬性對應數據庫信息--> <resultMap type='account'> <id property='id' column='id'></id> <result property='uid' column='uid'></result> <result property='money' column='money'></result> <!--通過id查詢用戶--> <association property='user' column='uid' javaType='user' select='com.yl.dao.IUserDao.queryById'></association> </resultMap> <!--查詢所有賬戶--> <select resultMap='accountUserMap'> SELECT * FROM account </select> <!--根據用戶id查詢賬戶--> <select resultType='account' parameterType='int'> select * from account where uid=#{uid} </select></mapper>

以上就是本文的全部內容，希望對大家的學習有所幫助，也希望大家多多支持好吧啦網。