mybatis之resultMap实现一对一查询

1、pojo类

package com.js.mybatis.po;
/**
 * 用户po类
 * 单独使用mybatis时，mapper.xml中的OGNL表达式通过getter()方法来读取pojo类的属性值
 * 当mybatis和spring整合时，spring通过反射来读取pojo类的属性值
 */
import java.util.Date;

public class User {
	@Override
	public String toString() {
		return "User [id=" + id + ", username=" + username + ", sex=" + sex
				+ ", birthday=" + birthday + ", address=" + address + "]";
	}
	private int id;
	private String username;
	private String sex;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public String getSex() {
		return sex;
	}
	public void setSex(String sex) {
		this.sex = sex;
	}
	public Date getBirthday() {
		return birthday;
	}
	public void setBirthday(Date birthday) {
		this.birthday = birthday;
	}
	public String getAddress() {
		return address;
	}
	public void setAddress(String address) {
		this.address = address;
	}
	private Date birthday;
	private String address;
}

package com.js.mybatis.po;

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

public class Orders implements Serializable {
    /**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	private Integer id;

    private Integer userId;

    private String number;

    private Date createtime;

    private String note;
    
    /**
     * 关联的用户信息
     */
    private User user;
   
    public User getUser() {
		return user;
	}

	@Override
	public String toString() {
		return "Orders [id=" + id + ", userId=" + userId + ", number=" + number
				+ ", createtime=" + createtime + ", note=" + note + ", user="
				+ user + "]";
	}

	public void setUser(User user) {
		this.user = user;
	}

	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 String getNumber() {
        return number;
    }

    public void setNumber(String number) {
        this.number = number == null ? null : number.trim();
    }

    public Date getCreatetime() {
        return createtime;
    }

    public void setCreatetime(Date createtime) {
        this.createtime = createtime;
    }

    public String getNote() {
        return note;
    }

    public void setNote(String note) {
        this.note = note == null ? null : note.trim();
    }   
    
}

2、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="com.js.mybatis.mapper.OrdersMapperCustome">
	<!-- 一对一查询使用resultType来完成
		查询订单关联查询用户信息
	 -->
	 <select id="findOrderUserList" resultType="orderCustom">
	 	SELECT orders.*,user.username,user.sex FROM orders,USER WHERE orders.user_id = user.id 
	 </select>
	 
<!-- ______________________________________________________________________________________________________ -->	 
	 
	 <!-- 一对一查询使用resultMap来完成
		查询订单关联查询用户信息
	 -->
	 <resultMap type="orders" id="orderUserResultMap">
	 	<!-- id：订单关联用户查询的唯一标识 -->
	 	<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:用于对关联信息映射到单个pojo
	 		property:要将关联信息映射到orders的哪个属性中
	 		javaType:关联信息映射到orders的那个属性的类型
	 	 -->
	 	<association property="user" javaType="user">
	 		<!-- id:关联信息的唯一标识 -->
	 		<!-- property:要映射到user的哪个属性中-->
	 		<id column="user_id" property="id"/>
	 		<result column="username" property="username"/>
	 		<result column="sex" property="sex"/>
	 	</association>
	 </resultMap>
	 
	 <select id="findOrderUserListResultMap" resultMap="orderUserResultMap">
	 	SELECT orders.*,user.username,user.sex FROM orders,USER WHERE orders.user_id = user.id 
	 </select>
</mapper>

3、mapper.java

package com.js.mybatis.mapper;

import java.util.List;

import com.js.mybatis.po.OrderCustom;
import com.js.mybatis.po.Orders;

public interface OrdersMapperCustome {
	public List<OrderCustom> findOrderUserList()throws Exception;
	public List<Orders> findOrderUserListResultMap() throws Exception;
}