需求：一個(gè)用戶(hù)可以有多個(gè)賬戶(hù)，查詢(xún)用戶(hù)時(shí)實(shí)現(xiàn)賬戶(hù)的延遲加載

1、用戶(hù)實(shí)體類(lèi)

package com.yl.bean;import java.io.Serializable;import java.sql.Date;import java.util.List;/** * 用戶(hù)實(shí)體類(lèi) */public class User implements Serializable { private Integer id;//id private String username;//用戶(hù)名 private Date birthday;//生日 private String sex;//性別 private String address;//地址 private List<Account> accountList;//用戶(hù)所擁有的賬戶(hù) 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、賬戶(hù)實(shí)體類(lèi)

package com.yl.bean;import java.io.Serializable;/** * 賬戶(hù)實(shí)體類(lèi) */public class Account implements Serializable { private Integer id;//賬戶(hù)id private Integer uid;//用戶(hù)id private Double money;//余額 private User user;//賬戶(hù)所屬用戶(hù) 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、用戶(hù)持久層接口

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

4、賬戶(hù)持久層接口

package com.yl.dao;import com.yl.bean.Account;import com.yl.bean.User;import java.util.List;/** * 賬戶(hù)持久層接口 */public interface IAccountDao { /** * 查詢(xún)所有賬戶(hù) */ List<Account> queryAll(); /** * 根據(jù)用戶(hù)id查詢(xún)賬戶(hù) */ 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> <!--開(kāi)啟延遲加載--> <setting name='lazyLoadingEnabled' value='true'/> <setting name='aggressiveLazyLoading' value='false'/> </settings> <!--配置別名--> <typeAliases> <package name='com.yl.bean'/> </typeAliases> <!--配置mybatis環(huán)境--> <environments default='mysql'> <!--配置mysql環(huán)境--> <environment id='mysql'> <!--事務(wù)類(lèi)型--> <transactionManager type='JDBC'></transactionManager> <!--數(shù)據(jù)源--> <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、用戶(hù)映射配置文件

<?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'> <!--配置用戶(hù)實(shí)體類(lèi)和數(shù)據(jù)庫(kù)的對(duì)應(yīng)信息--> <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> <!--根據(jù)id查詢(xún)賬戶(hù)--> <collection property='accountList' ofType='com.yl.bean.Account' select='com.yl.dao.IAccountDao.queryByUid' column='id'></collection> </resultMap> <!--查詢(xún)所有用戶(hù)--> <select resultMap='userMap'> SELECT * FROM USER </select> <!--根據(jù)id查詢(xún)用戶(hù)--> <select resultType='user' parameterType='int'> select * from user where id=#{id} </select></mapper>

7、賬戶(hù)映射配置文件

<?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屬性對(duì)應(yīng)數(shù)據(jù)庫(kù)信息--> <resultMap type='account'> <id property='id' column='id'></id> <result property='uid' column='uid'></result> <result property='money' column='money'></result> <!--通過(guò)id查詢(xún)用戶(hù)--> <association property='user' column='uid' javaType='user' select='com.yl.dao.IUserDao.queryById'></association> </resultMap> <!--查詢(xún)所有賬戶(hù)--> <select resultMap='accountUserMap'> SELECT * FROM account </select> <!--根據(jù)用戶(hù)id查詢(xún)賬戶(hù)--> <select resultType='account' parameterType='int'> select * from account where uid=#{uid} </select></mapper>

以上就是本文的全部?jī)?nèi)容，希望對(duì)大家的學(xué)習(xí)有所幫助，也希望大家多多支持好吧啦網(wǎng)。