Orders类
public class Orders{
private int id;
private int userId;
private int number;
private Date createtime;
private String note;
//set... get...
自定义的OrdersCustom类,继承Orders
public class OrdersCustom extends Orders{
private String username;
private String address;
//set... get...
接口
public interface IOrdersDao {
//查询订单关联查询用户信息
public List<OrdersCustom> findOrdersUser() throws Exception;
}
mapper.xml
<select id="findOrdersUser" resultType="com.energyfuture.ssm.po.OrdersCustom" >
select
orders.*,user.*
from user,orders
where user.id = orders.user_id
</select>
测试
public class OrdersMapperTest {
private SqlSessionFactory sqlSessionFactory = null;
@Before
public void setUp() throws Exception {
String resource = "SqlMapConfig.xml";
InputStream inputStream=Resources.getResourceAsStream(resource);
//创建回话工厂，传入mybatis的配置文件信息
sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
}
@Test
public void findOrdersUserTest(){
SqlSession session = sqlSessionFactory.openSession();
try {
IOrdersDao mapper = session.getMapper(IOrdersDao.class);
List<OrdersCustom> list = mapper.findOrdersUser();
System.out.println(list);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
if(session != null){
session.close();
}
}
}
}
按理说OrdersCustom继承了Orders,查询出来的结果不是应该包含Orders里面的属性吗,但是为什么查询的list是:
[address=台湾市, username=周一]
并没有查询到Orders里面的属性?
