ibatis 联表查询结果集取值问题
igyhi 2008-11-25 04:07:30 table:
t1:person
id name age
1 kaka 24
2 lala 26
t2:car
id uid brand
1 1 bmw
2 1 benz
3 2 honda
==================
bean:CarDAO
int id
int uid
String name
String brand
==================
sqlmap:
<select id="CarDAO.getInfo" parameterClass="String" resultClass="CarDAO">
<![CDATA[
select car.id,uid,name,brand
from person,car
where person.id=car.uid and $value$
]]>
</select>
===================
运行的查询是: select car.id,uid,name,brand from person,car where person.id=car.uid and car.id=2
把这个ibatis生成的查询直接用数据库sql查看下,结果是
2 1 kaka benz
结果取得了kaka这个联表数据
但是,用这个CarDAO获得的数据
dao.getName()
没有name属性值,为"",是什么原因?