学习记录--mybatis 代理方法实现

POJO类代码（两个表Orders，User的联合查询）

package com.xie.domain;

/**
 * 
 * 映射查询 的结果（数据库语句查询出来的全部字段）
 * 继承较多的POJO类
 *
 */
public class OrdersCustom extends Orders{

private String userName;
private String sex;
private String addess;
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 getAddess() {
return addess;
    }
public void setAddess(String addess) {
this.addess = addess;
    }
@Override
public String toString() {
return "OrderCustom [userName=" + userName + ", sex=" + sex + ", addess=" + addess + ", getuserName()="
                + getuserName() + ", getSex()=" + getSex() + ", getAddess()=" + getAddess() + ", getId()=" + getId()
                + ", getUser_id()=" + getUser_id() + ", getNumber()=" + getNumber() + ", getCreateTime()="
                + getCreateTime() + ", getNote()=" + getNote() + ", getClass()=" + getClass() + ", hashCode()="
                + hashCode() + ", toString()=" + super.toString() + "]";
    }

}

接口OrderMapperCustom代码：

package com.xie.mapping;

import java.util.List;

import com.xie.domain.OrdersCustom;

public interface OrdersMapperCustom {

public List<OrdersCustom> findOrderUser() throws Exception;
}

conf.xml代码

<?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>

<!-- 引用数据库配置文件 -->
<properties resource="db.properties"/>

<environments default="development">
<environment id="development">
<transactionManager type="JDBC" />
<!-- 配置数据库连接信息 -->
<dataSource type="POOLED">
<property name="driver" value="${driver}" />
<property name="url" value="${url}" />
<property name="username" value="${username}" />
<property name="password" value="${password}" />
</dataSource>
</environment>
</environments>

<mappers>
<mapper resource="com/xie/mapping/OrdersMapperCustom.xml"/>
</mappers>

</configuration>

测试类代码：

String resource = "conf.xml";
        InputStream is = Resources.getResourceAsStream(resource);
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is);
        SqlSession sqlSession=factory.openSession();
        OrdersMapperCustom orderMapperCustom=sqlSession.getMapper(OrdersMapperCustom.class);
        List<OrdersCustom> list=orderMapperCustom.findOrderUser();
        System.out.println(list);
        sqlSession.close();