JavaWeb学习笔记-mybatis-18-一对一使用resultType

resultType
sql

select orders.*,user.username,user.sex,user.adress from orders,user where order.user_id = user.id

pojo
将上面的结果集创建对应pojo

public class Orders {
    private Integer id;
    private Integer userId;
    private Date createtime;
    private String note;

    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 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;
    }
}

原始Orders.java不能映射全部字段，需要创建新的pojo，创建一个pojo继承包含查询字段较多的pojo

//order订单扩展类
public class OrderCustom extends Orders{
    //添加用户信息
    private  String username;
    private String sex;
    private String address;

    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 String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }
}

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">
<!--使用mappper代理方法，namespace有重要特殊作用-->
<mapper namespace="com.sws.mapper.OrdersMapper">
    <!--查询订单关联用户信息-->
    <select id="findOrdersUser" resultType="com.sws.entity.OrderCustom">
        select orders.*,user.username,user.sex,user.address from orders,user where orders.user_id = user.id
    </select>
</mapper>

public interface OrdersMapper {
    //查询订单关联查询用户信息
    public List<OrderCustom> findOrdersUser() throws Exception;
 }

配置文件配置自动扫描

<mappers>
    <package name="mapper"/>
</mappers>