<select id="findPage" parameterType="RequestBean" resultType="Sap">
select a.id, a.conname, a.conmax,
a.server, a.client, a.username, a.password, a.language, a.sysno, a.appid,
b.name as appName, b.id as appId
from haf_sap as a join haf_app as b on a.appid = b.id
<where>
<include refid="where_clause"/>
</where>
</select><resultMap id="sapMap" type="Sap">
<id property="id" column="id"/>
<result property="conname" column="conname"/>
<result property="conmax" column="conmax"/>
<result property="server" column="server"/> <result property="client" column="client"/>
<result property="username" column="username"/>
<result property="password" column="password"/> <result property="language" column="language"/>
<result property="sysno" column="sysno"/>
<result property="appId" column="appid"/>
<association property="app" column="appid" javaType="App">
<id property="id" column="appId" />
<result property="name" column="appName" />
<!--
<result property="code" column="code" />
<result property="des" column="des" />-->
</association> </resultMap>现在的问题是,组合成的sql语句执行是有结果的(这个语句我是通过log4jdbc打印出来的),但findPage返回的对象里面<result property="conname" column="conname"/>
<result property="conmax" column="conmax"/>
<result property="server" column="server"/> <result property="client" column="client"/>
<result property="username" column="username"/>
<result property="password" column="password"/> <result property="language" column="language"/>
<result property="sysno" column="sysno"/>
<result property="appId" column="appid"/>这些都有对应的值,只是<association property="app" column="appid" javaType="App">
<id property="id" column="appId" />
<result property="name" column="appName" />
<!--
<result property="code" column="code" />
<result property="des" column="des" />-->
</association>
对应的对象app是null
请问如何解决,,谢谢!
select a.id, a.conname, a.conmax,
a.server, a.client, a.username, a.password, a.language, a.sysno, a.appid,
b.name as appName, b.id as appId
from haf_sap as a join haf_app as b on a.appid = b.id
<where>
<include refid="where_clause"/>
</where>
</select><resultMap id="sapMap" type="Sap">
<id property="id" column="id"/>
<result property="conname" column="conname"/>
<result property="conmax" column="conmax"/>
<result property="server" column="server"/> <result property="client" column="client"/>
<result property="username" column="username"/>
<result property="password" column="password"/> <result property="language" column="language"/>
<result property="sysno" column="sysno"/>
<result property="appId" column="appid"/>
<association property="app" column="appid" javaType="App">
<id property="id" column="appId" />
<result property="name" column="appName" />
<!--
<result property="code" column="code" />
<result property="des" column="des" />-->
</association> </resultMap>现在的问题是,组合成的sql语句执行是有结果的(这个语句我是通过log4jdbc打印出来的),但findPage返回的对象里面<result property="conname" column="conname"/>
<result property="conmax" column="conmax"/>
<result property="server" column="server"/> <result property="client" column="client"/>
<result property="username" column="username"/>
<result property="password" column="password"/> <result property="language" column="language"/>
<result property="sysno" column="sysno"/>
<result property="appId" column="appid"/>这些都有对应的值,只是<association property="app" column="appid" javaType="App">
<id property="id" column="appId" />
<result property="name" column="appName" />
<!--
<result property="code" column="code" />
<result property="des" column="des" />-->
</association>
对应的对象app是null
请问如何解决,,谢谢!
解决方案 »
- struts2框架问题
- Ckeditor_Ckfinder 插件上传图片问题
- hibernate是否适合在分布式环境中使用?
- java中如何判断远程linux目录下的某个文件存在
- Hibernate怎么动态修改hbm.xml中table的名字?
- 招聘手机游戏开发及策划
- 一个非常不错的开源项目网站
- 为什么我按下在JColorChooser中按确定以后没有效果呢?
- jms出现receive time out异常,在线等候--马上给分
- [Ant API求助]XSLTProcess的NullPointerException问题
- 请问如何在action中获取struts.xml文件中定义的常量值
- myeclipse配置多个weblogic域
association是做子查询用的
Sap 是对应 一个 app (你看看配置),这样的情况是需要用collection吗?