Mybatis中表与表之间的关系分为一下4类：
1）一对一
2）一对多
3）多对一
4）多对多
用户表user：记录了购买商品的用户信息。
订单表orders：记录了用户所创建的订单（购买商品的订单）。
订单明细表orderdetail：记录了订单的详细信息即购买商品的信息。
商品表items：记录商品信息。
先分析数据级别之间有关系的表之间的业务关系：
user —-> orders：一个用户可以创建多个订单，一对多
orders —-> user：一个订单只由一个用户创建，一对一
orders —-> orderdetail：一个订单可以包括 多个订单明细，因为一个订单可以购买多个商品，每个商品的购买信息在orderdetail记录，一对多关系。
orderdetail —-> orders：一个订单明细只能包括在一个订单中，一对一
orderdetail —-> itesms：一个订单明细只对应一个商品信息，一对一
items —-> orderdetail:一个商品可以包括在多个订单明细 ，一对多
/*
Navicat MySQL Data TransferSource Server : mysql1
Source Server Version : 50712
Source Host : localhost:3306
Source Database : relationTarget Server Type : MYSQL
Target Server Version : 50712
File Encoding : 65001Date: 2019-03-24 15:57:05
*/SET FOREIGN_KEY_CHECKS=0;-- ----------------------------
-- Table structure for items
-- ----------------------------
DROP TABLE IF EXISTS `items`;
CREATE TABLE `items` (`items_id` int(11) NOT NULL AUTO_INCREMENT,`name` varchar(64) DEFAULT NULL,`price` double(10,2) DEFAULT NULL,`detail` varchar(255) DEFAULT NULL,`pic` varchar(255) DEFAULT NULL,`createtime` date DEFAULT NULL,PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of items
-- ----------------------------
INSERT INTO `items` VALUES ('1', '巧克力', '28.00', '黑巧克力', 'pic url', '2019-01-01');
INSERT INTO `items` VALUES ('2', '运动袜', '35.00', '运动袜', 'pic url', '2019-01-01');
INSERT INTO `items` VALUES ('3', '高跟鞋', '890.00', '高跟鞋', 'pic url', '2019-01-01');-- ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (`id` int(11) NOT NULL AUTO_INCREMENT,`user_id` int(11) DEFAULT NULL,`number` int(11) DEFAULT NULL,`createtime` date DEFAULT NULL,PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of orders
-- ----------------------------
INSERT INTO `orders` VALUES ('1', '1', '2', '2019-03-24');
INSERT INTO `orders` VALUES ('2', '2', '1', '2019-03-22');
INSERT INTO `orders` VALUES ('3', '2', '2', '2019-03-24');-- ----------------------------
-- Table structure for ordersdetail
-- ----------------------------
DROP TABLE IF EXISTS `ordersdetail`;
CREATE TABLE `ordersdetail` (`ordersdetail_id` int(11) NOT NULL AUTO_INCREMENT,`items_id` int(11) DEFAULT NULL,`items_num` int(11) DEFAULT NULL,`orders_id` int(11) DEFAULT NULL,PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of ordersdetail
-- ----------------------------
INSERT INTO `ordersdetail` VALUES ('1', '1', '1', '1');
INSERT INTO `ordersdetail` VALUES ('2', '2', '1', '1');
INSERT INTO `ordersdetail` VALUES ('3', '1', '1', '2');
INSERT INTO `ordersdetail` VALUES ('4', '2', '1', '3');
INSERT INTO `ordersdetail` VALUES ('5', '3', '1', '3');-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (`id` int(11) NOT NULL AUTO_INCREMENT,`username` varchar(32) DEFAULT NULL,`birthday` date DEFAULT NULL,`address` varchar(255) DEFAULT NULL,`gender` varchar(4) DEFAULT NULL,PRIMARY KEY (`id`),UNIQUE KEY `idx_username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'zhangsan', '1999-10-01', '北京市海淀区海淀黄庄', '男');
INSERT INTO `user` VALUES ('2', 'lili', '1989-02-02', '北京市朝阳区大运村', '女'); 第一步：创建demo maven项目：
填写Group Id、Artifact Id、Packaging选择为pom：
此时项目值包含mybatie-study
然后，创建maven module-------选中mybatie-study maven项目，然后右键-》弹出菜单，菜单中选择New->选择
在弹出New窗口中选择Maven->Maven Module
填写Maven Module名称
点击finish完成Maven Module创建。
第二步：在Maven Module项目mybatis-relation下/src/main/resources目录下，创建l文件
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE generatorConfiguration PUBLIC "-//mybatis//DTD MyBatis Generator Configuration 1.0//EN" ".dtd" >
<generatorConfiguration><!-- jdbc连接库jar包路径 --><classPathEntry location="D:IDEmavenrepositorymysqlmysql-connector-java5.1.38mysql-connector-java-5.1.38.jar" /><!-- eclipse tool配置 Location = E:Javaapache-maven-3.2.3binmvn.bat Working Direction = ${workspace_loc:/linetoy-common} Arguments = mybatis-generator:generate --><context id="DB2Tables" targetRuntime="MyBatis3"><!-- 去掉注释，一般都会去掉，那个注释真的不敢让人恭维 --><commentGenerator><property name="suppressAllComments" value="true" /></commentGenerator><!-- jdbc连接配置 --><jdbcConnection driverClass=&#sql.jdbc.Driver"connectionURL="jdbc:mysql://localhost:3306/relation?characterEncoding=UTF-8" userId="root"password="root"></jdbcConnection><!-- 数字字段是否强制使用BigDecimal类 --><javaTypeResolver><property name="forceBigDecimals" value="false" /></javaTypeResolver><!-- entity创建后放在那个项目的哪个包路径上 --><javaModelGenerator targetPackage="del"targetProject="D:gitspringboot_learn01mybatie-studymybatis-relationsrcmainjava"><property name="enableSubPackages" value="true" /><property name="trimStrings" value="true" /></javaModelGenerator> <!-- dao创建后放在那个项目的哪个包路径上 --><sqlMapGenerator targetPackage="batis01.dao"targetProject="D:gitspringboot_learn01mybatie-studymybatis-relationsrcmainjava"><property name="enableSubPackages" value="true" /></sqlMapGenerator><!-- dao的.xml描述sql文件创建后放在那个项目的哪个包路径上 --><javaClientGenerator type="XMLMAPPER"targetPackage="batis01.dao"targetProject="D:gitspringboot_learn01mybatie-studymybatis-relationsrcmainjava"><property name="enableSubPackages" value="true" /></javaClientGenerator><!-- 要生成的表配置，可以多个 tableName：表名 domainObjectName：指定类名 --><table tableName="orders" domainObjectName="Orders"enableCountByExample="false" enableUpdateByExample="false"enableDeleteByExample="false" enableSelectByExample="false"selectByExampleQueryId="false"><generatedKey column="id" sqlStatement="Mysql" identity="true" /></table></context>
</generatorConfiguration> 该配置文件用来配置生成mybatis代码规则，以及代码生成目录，将要生成代码的table配置。
第三步：在Maven Module项目mybatis-relation中l中引入依赖包：
<project xmlns=".0.0" xmlns:xsi=""xsi:schemaLocation=".0.0 .0.0.xsd"><modelVersion>4.0.0</modelVersion><parent><groupId>batis01</groupId><artifactId>mybatie-study</artifactId><version>0.0.1-SNAPSHOT</version></parent><groupId>lation</groupId><artifactId>mybatis-relation</artifactId><dependencies><!-- 配置mybatis的开发包 --><dependency><groupId&batis</groupId><artifactId>mybatis</artifactId><version>3.4.1</version></dependency><!-- 配置mysql支持包 --><!-- --><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>5.1.38</version></dependency> <!-- 日志 slf4j是规范/接口 日志实现:log4j,logback,common-logging 这里使用:slf4j + log4j --><dependency><groupId>org.slf4j</groupId><artifactId>slf4j-log4j12</artifactId><version>1.7.2</version></dependency><!-- .ator/mybatis-generator-core --><dependency><groupId&ator</groupId><artifactId>mybatis-generator-core</artifactId><version>1.3.5</version></dependency></dependencies><build><defaultGoal>compile</defaultGoal><finalName>mybatis-plugin</finalName><plugins><plugin><groupId>org.apache.maven.plugins</groupId><artifactId>maven-surefire-plugin</artifactId><version>2.1</version><configuration><skip>true</skip></configuration></plugin><plugin><groupId&ator</groupId><artifactId>mybatis-generator-maven-plugin</artifactId><version>1.3.5</version><configuration> <configurationFile>${basedir}/src/main/l</configurationFile><verbose>true</verbose><overwrite>true</overwrite></configuration></plugin></plugins></build>
</project> 第四步：选中Maven Module项目右键运行生成mybatis代码：
在弹出窗口中，Global参数中填写“mybatis-generator:generate”，并运行
执行日志：
Apache Maven 3.3.9 (bb52d8502b132ec0a5a3f4c09453c07478323dc5; 2015-11-11T00:41:47+08:00)
Maven home: D:Java_Studyapache-maven-3.3.9
Java version: 1.8.0_161, vendor: Oracle Corporation
Java home: C:Program FilesJavajdk1.8.0_161jre
Default locale: zh_CN, platform encoding: GBK
OS name: "windows 7", version: "6.1", arch: "amd64", family: "dos"
[DEBUG] Created new class realm maven.api
[DEBUG] Importing foreign packages into class realm maven.api
。。。。。。
[DEBUG] Populating class realm maven.api
[INFO] Error stacktraces are turned on.
[DEBUG] Reading global settings from D:Java_Studyapache-maven-3.3.9l
[DEBUG] Reading user settings from D:Java_Studyapache-maven-3.3.9l
[DEBUG] Reading global toolchains from D:Java_Studyapache-maven-3.3.9l
[DEBUG] Reading user toolchains from C:UsersAdministrator.l
[DEBUG] Using local repository at D:IDEmavenrepository
[DEBUG] Using manager EnhancedLocalRepositoryManager with priority 10.0 for D:IDEmavenrepository
[INFO] Scanning
[DEBUG] Using mirror nexus-aliyun () for central ().
[DEBUG] Extension realms for project lation:mybatis-relation:jar:0.0.1-SNAPSHOT: (none)
[DEBUG] Looking up lifecyle mappings for packaging jar from , parent: null]
[DEBUG] Extension realms for project batis01:mybatie-study:pom:0.0.1-SNAPSHOT: (none)
[DEBUG] Looking up lifecyle mappings for packaging pom from , parent: null]
[DEBUG] Resolving plugin prefix mybatis-generator from [org.apache.maven.plugins, jo]
[DEBUG] Using mirror nexus-aliyun () for snapshots ().
[DEBUG] Resolved plugin prefix mybatis-generator ator:mybatis-generator-maven-plugin from POM lation:mybatis-relation:jar:0.0.1-SNAPSHOT
[DEBUG] === REACTOR BUILD PLAN ================================================
[DEBUG] Project: lation:mybatis-relation:jar:0.0.1-SNAPSHOT
[DEBUG] Tasks: [mybatis-generator:generate]
[DEBUG] Style: Regular
[DEBUG] =======================================================================
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] Building mybatis-relation 0.0.1-SNAPSHOT
[INFO] ------------------------------------------------------------------------
[DEBUG] Resolving plugin prefix mybatis-generator from [org.apache.maven.plugins, jo]
[DEBUG] Resolved plugin prefix mybatis-generator ator:mybatis-generator-maven-plugin from POM lation:mybatis-relation:jar:0.0.1-SNAPSHOT
[DEBUG] Lifecycle default -> [validate, initialize, generate-sources, process-sources, generate-resources, process-resources, compile, process-classes, generate-test-sources, process-test-sources, generate-test-resources, process-test-resources, test-compile, process-test-classes, test, prepare-package, package, pre-integration-test, integration-test, post-integration-test, verify, install, deploy]
[DEBUG] Lifecycle clean -> [pre-clean, clean, post-clean]
[DEBUG] Lifecycle site -> [pre-site, site, post-site, site-deploy]
[DEBUG] === PROJECT BUILD PLAN ================================================
[DEBUG] Project: lation:mybatis-relation:0.0.1-SNAPSHOT
[DEBUG] Dependencies (collect): []
[DEBUG] Dependencies (resolve): []
[DEBUG] Repositories (dependencies): [nexus-aliyun (, default, releases)]
[DEBUG] Repositories (plugins) : [nexus-aliyun (, default, releases)]
[DEBUG] -----------------------------------------------------------------------
[DEBUG] Goal: ator:mybatis-generator-maven-plugin:1.3.5:generate (default-cli)
[DEBUG] Style: Regular
[DEBUG] Configuration: <?xml version="1.0" encoding="UTF-8"?>
<configuration><configurationFile default-value="${project.basedir}/src/main/l">D:gitspringboot_learn01mybatie-studymybatis-relation/src/main/l</configurationFile><contexts>${ts}</contexts><jdbcDriver>${ator.jdbcDriver}</jdbcDriver><jdbcPassword>${ator.jdbcPassword}</jdbcPassword><jdbcURL>${ator.jdbcURL}</jdbcURL><jdbcUserId>${ator.jdbcUserId}</jdbcUserId><outputDirectory default-value="${project.build.directory}/generated-sources/mybatis-generator">${ator.outputDirectory}</outputDirectory><overwrite default-value="false">true</overwrite><project>${project}</project><skip default-value="false">${ator.skip}</skip><sqlScript>${ator.sqlScript}</sqlScript><tableNames>${ator.tableNames}</tableNames><verbose default-value="false">true</verbose>
</configuration>
[DEBUG] =======================================================================
[INFO]
[INFO] --- mybatis-generator-maven-plugin:1.3.5:generate (default-cli) @ mybatis-relation ---
[DEBUG] Using mirror nexus-aliyun () for apache.snapshots ().
[DEBUG] Using mirror nexus-aliyun () for sonatype-nexus-snapshots ().
[DEBUG] Using mirror nexus-aliyun () for repository.jboss ().
[DEBUG] Using mirror nexus-aliyun () for snapshots.jboss ().
[DEBUG] Using mirror nexus-aliyun () for oss.sonatype/jboss-snapshots ().
[DEBUG] Dependency collection stats: {ConflictMarker.analyzeTime=1, ConflictMarker.markTime=0, deCount=17, aphTime=0, psortTime=1, flictIdCount=14, flictIdCycleCount=0, alTime=2, flictItemCount=17, llectTime=739, ansformTime=5}
[DEBUG] ator:mybatis-generator-maven-plugin:jar:1.3.5:
。。。。。。
[DEBUG] Configuring ator:mybatis-generator-maven-plugin:1.3.5:generate from plugin realm ClassRealm[plugin&ator:mybatis-generator-maven-plugin:1.3.5, parent: sun.misc.Launcher$AppClassLoader@33909752]
[DEBUG] Configuring mojo &#ator:mybatis-generator-maven-plugin:1.3.5:generate' with basic configurator -->
[DEBUG] (f) configurationFile = D:gitspringboot_learn01mybatie-studymybatis-relationsrcmainl
[DEBUG] (f) outputDirectory = D:gitspringboot_learn01mybatie-studymybatis-relationtargetgenerated-sourcesmybatis-generator
[DEBUG] (f) overwrite = true
[DEBUG] (f) project = MavenProject: lation:mybatis-relation:0.0.1-SNAPSHOT @ D:gitspringboot_learn01mybatie-studyl
[DEBUG] (f) skip = false
[DEBUG] (f) verbose = true
[DEBUG] -- end configuration --
[INFO] Connecting to the Database
Sun Mar 24 14:42:43 CST 2019 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
[INFO] Introspecting table orders
[DEBUG] Retrieving column information for table "orders"
[DEBUG] Found column "id", data type 4, in table &#ders"
[DEBUG] Found column "user_id", data type 4, in table &#ders"
[DEBUG] Found column "number", data type 4, in table &#ders"
[DEBUG] Found column "createtime", data type 91, in table &#ders"
[INFO] Generating Record class for table orders
[INFO] Generating Mapper Interface for table orders
[INFO] Generating SQL Map for table orders
[INFO] Saving l
[INFO] Saving file Orders.java
[INFO] Saving file OrdersMapper.java
[WARNING] Existing file D:gitspringboot_learn01mybatie-studymybatis-relationsrcmainjavacomdxmybatis01modelOrders.java was overwritten
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 1.499 s
[INFO] Finished at: 2019-03-24T14:42:44+08:00
[INFO] Final Memory: 19M/491M
[INFO] ------------------------------------------------------------------------ 刷新项目，此时可以发现项目中已经包含了新的代码生成：
实例：查询订单信息，关联查询创建订单的用户信息。
SELECT orders.*,user.der,user.address FROM orders,USER WHERE orders.user_id = user.id
主查询表：orders
关联查询表：user
联结查询：内联结
1、SQL语句的书写要领：先确定查询的主表，在确定查询的关联表，关联查询是使用内联结还是外联结。
2、POVO扩展类创建。(这是由于关联查询出来的信息是多张表的综合字段，所以我们可以根据POJO创建我们的扩展类)
3、l和Mapper.java的代理编写
4、进行测试
在Maven Module项目mybatis-relation下src/main/resources下创建l
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE configuration PUBLIC "-//mybatis//DTD Config 3.0//EN" ".dtd"> <configuration><settings><setting name="cacheEnabled" value="true"/></settings><typeAliases><!-- <typeAlias type="dule.News" alias="News"/> --></typeAliases><environments default="development"> <!-- 配置数据源的相关信息 --><environment id="development"><transactionManager type="jdbc" /> <!-- 使用JDBC方式管理 --><dataSource type="POOLED"> <!-- 设置数据源类型，此时为POOLED --><property name="driver" value=&#sql.jdbc.Driver" /><property name="url" value="jdbc:mysql://localhost:3306/relation" /><!-- 设置数据库连接的用户名和密码 --><property name="username" value="root" /><property name="password" value="root" /> </dataSource> </environment></environments><mappers><mapper resource="com/dx/mybatis01/l"></mapper></mappers> </configuration>
在dule下创建module：
Order.java
package del;import java.util.Date;
import java.util.List;public class Orders {private Integer id;private Integer userId;private Integer number;private Date createtime; // 用户信息private User user; //商品信息存放集合private List<OrdersDetail> orderdetails; public User getUser() {return user;}public void setUser(User user) {this.user = user;}public List<OrdersDetail> getOrderdetails() {return orderdetails;}public void setOrderdetails(List<OrdersDetail> orderdetails) {derdetails = orderdetails;}public Integer getId() {return id;}public void setId(Integer id) {this.id = id;}public Integer getUserId() {return userId;}public void setUserId(Integer userId) {this.userId = userId;}public Integer getNumber() {return number;}public void setNumber(Integer number) {this.number = number;}public Date getCreatetime() {return createtime;}public void setCreatetime(Date createtime) {atetime = createtime;}
} View Code OrdersExtends.java
package del;public class OrdersExtends extends Orders{private String username;private String gender;private String address;......
} 在batis01.dao下创建mapper和l：
OrdersExtendsMapper.java
package batis01.dao;import java.util.List;import del.OrdersExtends;public interface OrdersExtendsMapper {List<OrdersExtends> findOrderAndUser();
} <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis//DTD Mapper 3.0//EN" ".dtd"> <mapper namespace="batis01.dao.OrdersExtendsMapper"><select id="findOrderAndUser" resultType="del.OrdersExtends">SELECT orders.*,user.der,user.address FROM orders,USER WHERE orders.user_id = user.id</select> </mapper>
测试类：
import java.io.IOException;
import java.io.InputStream;
import java.util.List;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 batis01.dao.OrdersExtendsMapper;
import del.OrdersExtends;public class OrdersExtendsTest {private SqlSessionFactory sqlSessionFactory = null;private SqlSession session = null;@Beforepublic void Init() throws IOException {// 加载总配置文件，转化为流String resource = "l";InputStream inputStream = ResourceAsStream(resource);// 创建sqlSessionFactorysqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);session = sqlSessionFactory.openSession();}@Afterpublic void destory() {this.session.close();}@Testpublic void test() {OrdersExtendsMapper ordersExtendsMapper = Mapper(OrdersExtendsMapper.class);List<OrdersExtends> list = ordersExtendsMapper.findOrderAndUser();for (OrdersExtends o : list) {// getUserid没有和数据库对应，所以无法获取默认为nullSystem.out.Id() + ":" + o.getUserId() + ":" + o.getUsername() + ":" + o.getAddress());}}
} 输出：
1:null:zhangsan:北京市海淀区海淀黄庄 2:null:lili:北京市朝阳区大运村 3:null:lili:北京市朝阳区大运村
注意：上述测试代码中，由于userid没有和数据库中的字段进行对应(user_id)，所以会造成数据映射不成功而默认为null。
项目代码结构如下：
思路：利用 ResultMap 有点类似于Hibernate中POJO类中的设置。将我们对应的属性关联到类中。
1、使用resultMap将查询结果中的订单信息映射到Orders对象中，
2、在orders类中添加User属性，将关联查询出来的用户信息映射到orders对象中的user属性中。
Order.java
public class Orders {private Integer id;private Integer userId;private Integer number;private Date createtime; // 用户信息private User user; ......
} OrderMapper和Mapper xml如下：
OrderMapper.java
package batis01.dao;import java.util.List;import del.Orders;public interface OrdersMapper { List<Orders> findOrderAndUserResultMap();
} <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis//DTD Mapper 3.0//EN" ".dtd"> <mapper namespace="batis01.dao.OrdersMapper"><!-- 订单查询关联用户的查询 --><resultMap type="del.Orders" id="OrderUserResultMap"><!-- 配置映射的订单信息 --><id column="id" property="id"/><result column="user_id" property="userId"/> <result column="number" property="number"/><result column="createtime" property="createtime"/><result column="note" property="note"/><!-- 配置关联的用户信息association:用来映射关联查询单个对象的信息property ：将关联信息映射到Order的哪个属性中去javaType 映射到那个java类中--><association property="user" javaType="del.User"><!-- id 关联查询用户的唯一标识 ，外键 column 指定唯一标识用户信息的字段，property表示类中属性 --><id column="id" property="id"/> <result column="username" property="username"/><result column="gender" property="gender"/><result column="address" property="address"/></association></resultMap><select id="findOrderAndUserResultMap" resultMap="OrderUserResultMap">SELECT orders.*,user.der,user.address FROM orders,USER WHERE orders.user_id = user.id</select> </mapper>
测试类：
import java.io.IOException;
import java.io.InputStream;
import java.util.List;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 batis01.dao.OrdersMapper;
import del.Orders;public class OrdersMapperTest {private SqlSessionFactory sqlSessionFactory = null;private SqlSession session = null;@Beforepublic void Init() throws IOException {// 加载总配置文件，转化为流String resource = "l";InputStream inputStream = ResourceAsStream(resource);// 创建sqlSessionFactorysqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);session = sqlSessionFactory.openSession();}@Afterpublic void destory() {this.session.close();}@Testpublic void test() {OrdersMapper ordersExtendsMapper = Mapper(OrdersMapper.class);List<Orders> list = ordersExtendsMapper.findOrderAndUserResultMap();for (Orders o : list) {System.out.Id() + ":" + o.getUserId() + ":" + o.getUser().getUsername() + ":" + o.getUser().getAddress());}}
} 测试打印信息：
1:1:zhangsan:北京市海淀区海淀黄庄 2:2:lili:北京市朝阳区大运村 3:2:lili:北京市朝阳区大运村
说明：
利用 ResultMap，我们可以利用其中的association 属性将外键关联的相关类进行映射。这也是使用ResultMap 的便利之一。ResultType和ResultMap实现一对一查询比较
1、resultType：使用resultType实现较为简单，如果pojo中没有包括查询出来的列名，需要增加列名对应的属性，即可完成映射。如果没有查询结果的特殊要求建议使用resultType。
2、resultMap：需要单独定义resultMap，实现有点麻烦，如果对查询结果有特殊的要求，使用resultMap可以完成将关联查询映射pojo的属性中。
3、resultMap可以实现延迟加载，resultType无法实现延迟加载。
实例：查询订单及订单明细的信息。
SELECTt10.id,t10.user_id,t10.atetime,t11.der,t11.dersdetail_id,t12.items_id,t12.items_ders_idFROM orders t10inner join USER t11 on t10.user_id=t11.idleft outer join ordersdetail t12 on t10.id&#ders_id
主查询表：orders
确定关联查询表：orderdetail
联结查询：内联结
利用resultType将上边的 查询结果映射到pojo中，订单信息的就是重复。而我们对于对orders映射不能出现重复记录。所以我们这里只能利用ResultMap。
POJO类
// POJO类public class User {private int id;private String username;private Date birthday;private String address;private String gender;}public class Orders {private User user;private int id;private int userId;private String number;private Date createtime;private String note;private List<OrdersDetail> orderdetails; // 一对多关系设置
}public class OrdersDetail {private int id;private int ordersId;private int itemsId;private int itemsNum;} OrdersMapper.java
package batis01.dao;import java.util.List;import del.Orders;public interface OrdersMapper {// 查询订单(关联用户)订单明细public List<Orders> findOrderAndDetailResultMap();
} <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis//DTD Mapper 3.0//EN" ".dtd"> <mapper namespace="batis01.dao.OrdersMapper"><resultMap type="del.Orders" id="OrderAndDetailResultMap"><!-- 配置映射的订单信息 --><id column="id" property="id" /><result column="user_id" property="userId" /><result column="number" property="number" /><result column="createtime" property="createtime" /><!-- 配置关联的用户信息 association:用来映射关联查询单个对象的信息 一对多的逆向使用 property ：将关联信息映射到Order的哪个属性中去 javaType 映射到那个java类中 --><association property="user" javaType="del.User"><!-- id 关联查询用户的唯一标识 ，外键 column 指定唯一标识用户信息的列 --><id column="id" property="id" /><result column="username" property="username" /><result column="gender" property="gender" /><result column="address" property="address" /></association><!-- 订单明细信息 一个订单包含多条明细，要使用collection进行映射 一对多使用 配置在一的一方添加属性 collection：对关联查询的多条记录映射到集合对象中去 property: 将关联查询出来的多条记录映射到类中的那个属性中 list ofType : 指定映射到集合属性中的pojo类，list的泛型 --><collection property="orderdetails" ofType="del.OrdersDetail"><!-- id 订单明细唯一标识 --><id column="ordersdetail_id" property="id" /><result column="items_id" property="itemsId" /><result column="items_num" property="itemsNum" /><result column="orders_id" property="ordersId" /></collection></resultMap><select id="findOrderAndDetailResultMap" resultMap="OrderAndDetailResultMap">SELECTt10.id,t10.user_id,t10.atetime,t11.der,t11.dersdetail_id,t12.items_id,t12.items_ders_idFROM orders t10inner join USER t11 on t10.user_id=t11.idleft outer join ordersdetail t12 on t10.id&#ders_id</select> </mapper>
或者
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis//DTD Mapper 3.0//EN" ".dtd"> <mapper namespace="batis01.dao.OrdersMapper"><resultMap id="BaseResultMap" type="del.Orders"><id column="id" jdbcType="INTEGER" property="id" /><result column="user_id" jdbcType="INTEGER" property="userId" /><result column="number" jdbcType="INTEGER" property="number" /><result column="createtime" jdbcType="DATE" property="createtime" /></resultMap><sql id="Base_Column_List">id, user_id, number, createtime</sql><!-- 订单查询关联用户的查询 --><resultMap type="del.Orders" id="OrderUserResultMap"extends="BaseResultMap"><!-- 配置关联的用户信息 association:用来映射关联查询单个对象的信息 property ：将关联信息映射到Order的哪个属性中去 javaType 映射到那个java类中 --><association property="user" javaType="del.User"><!-- id 关联查询用户的唯一标识 ，外键 column 指定唯一标识用户信息的字段，property表示类中属性 --><id column="id" property="id" /><result column="username" property="username" /><result column="gender" property="gender" /><result column="address" property="address" /></association></resultMap><resultMap type="del.Orders" id="OrderAndDetailResultMap"extends="OrderUserResultMap"><!-- 订单明细信息 一个订单包含多条明细，要使用collection进行映射 一对多使用 配置在一的一方添加属性 collection：对关联查询的多条记录映射到集合对象中去 property: 将关联查询出来的多条记录映射到类中的那个属性中 list ofType : 指定映射到集合属性中的pojo类，list的泛型 --><collection property="orderdetails" ofType="del.OrdersDetail"><!-- id 订单明细唯一标识 --><id column="ordersdetail_id" property="id" /><result column="items_id" property="itemsId" /><result column="items_num" property="itemsNum" /><result column="orders_id" property="ordersId" /></collection></resultMap><select id="findOrderAndDetailResultMap" resultMap="OrderAndDetailResultMap">SELECTt10.id,t10.user_id,t10.atetime,t11.der,t11.dersdetail_id,t12.items_id,t12.items_ders_idFROM orders t10inner join USER t11 on t10.user_id=t11.idleft outer join ordersdetail t12 on t10.id&#ders_id</select> </mapper>
测试代码：
import java.io.IOException;
import java.io.InputStream;
import java.util.List;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 batis01.dao.OrdersMapper;
import del.Orders;
import del.OrdersDetail;public class OrdersMapperTest {private SqlSessionFactory sqlSessionFactory = null;private SqlSession session = null;@Beforepublic void Init() throws IOException {// 加载总配置文件，转化为流String resource = "l";InputStream inputStream = ResourceAsStream(resource);// 创建sqlSessionFactorysqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);session = sqlSessionFactory.openSession();}@Afterpublic void destory() {this.session.close();}@Testpublic void test() {OrdersMapper ordersExtendsMapper = Mapper(OrdersMapper.class);List<Orders> list = ordersExtendsMapper.findOrderAndDetailResultMap();for (Orders o : list) {System.out.Id() + ":" + o.getUserId() + ":" + o.getUser().getUsername() + ":"+ o.getUser().getAddress() + ":o.getOrderdetails().size()=" + o.getOrderdetails().size());for (OrdersDetail od : o.getOrderdetails()) {System.out.println("------" + od.getId() + ":" + od.getItemsId() + ":" + od.getItemsNum()+ ":" + od.getOrdersId());}}}
} 添加log4j.properties配置，设置打印执行sql，在Maven Module项目mybatis-relation中src/main/resources下添加log4j.properties
打印执行结果：
