Mybatis reultMap实现一对一的映射

在数据库中创建两张简单的表user表和orders表，orders中userId是orders的外键，同时是user表的主键,Pojo对象与数据库的字段一一对应
User.java

package per.czt.ssm.domain;

public class User {
	private Integer id;
	private String username;
	
	private String password;
	private Integer grade;
	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 String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	public Integer getGrade() {
		return grade;
	}
	public void setGrade(Integer grade) {
		this.grade = grade;
	}
	
	
}

Orders.java

package per.czt.ssm.domain;

public class Orders {
	private Integer id;
	private User user;
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public User getUser() {
		return user;
	}
	public void setUser(User user) {
		this.user = user;
	}
	
	
}

我这里把两个都写在一个映射文件去了
Mapper.xml

<?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="per.czt.ssm.domain">

	
	<!--  配置orders和user对应-->
	<resultMap type="per.czt.ssm.domain.Orders" id="Orders">
		<result property="id" column="oid"/>
		<result property="user" column="userId"/>
		<association property="user" javaType="per.czt.ssm.domain.User" >
			<id  property="id" column="uid"/>
		    <result property="username" column="username"/>
	        <result property="password" column="password"/>
		</association>
	
	</resultMap>
	

	<!-- 配置查询语句，这里查询了两个表所有字段 -->
	<select id="searchOrders" parameterType="per.czt.ssm.domain.Orders"
		resultMap="Orders">
		select * from orders,user where orders.userId=user.uid
	</select>
	

</mapper>

在Dao层调用这个查询语句

@Override
	public List<Orders> listAll() {
		
		return this.getSqlSession().selectList("per.czt.ssm.domain.searchOrders", null);
	}
	

在Service层调用dao

@Override
	public List<Orders> listAll() {
		
		return ordersDao.listAll();
	}

在controller调用service，然后通过model设置attribute传递给view层

	@RequestMapping("/listAll")
	public String listAll(Model model)
	{
		System.out.println("OrdersController");
		List<Orders> ordersList=ordersService.listAll();
		for(Orders order:ordersList)
		{
			System.out.println("id:"+order.getId()+" "+"userId:"+order.getUser().getId());
		}
		System.out.println("ordersList.size():"+ordersList.size());
		model.addAttribute(ordersList);
		
		return "/orders/ordersList";
	}

最后在view层显示

<table border="1">
		<thead>
			<tr>
				<th>id</th>
				<th>userId</th>
				<th>username</th>
			
			
			</tr>

		</thead>
		<tbody>
			<c:forEach items="${ordersList }" var="orders">
				<tr>
					<td>${orders.id }</td>
					<td>${orders.user.id}</td>
					<td>${orders.user.username}</td>
					
				</tr>

			</c:forEach>


		</tbody>

	</table>