ibatis参数传进去了,但是查询没有结果。求解????

飞翔的小云云 2012-09-27 03:54:51
<sqlMap namespace="TByh">
<typeAlias alias="TByh" type="cn.com.lcarbo.meterbase.bo.UserMeter" />
<resultMap id="abatorgenerated_TByhResult" class="TByh">
<result column="YHBH" property="yhbh" />
<result column="RLZ" property="rlz" jdbcType="VARCHAR" />
<result column="XQ" property="xq" jdbcType="VARCHAR" />
<result column="LH" property="lh" jdbcType="VARCHAR" />
<result column="DYH" property="dyh" jdbcType="VARCHAR" />
<result column="CS" property="cs" jdbcType="NUMBER"/>
<result column="SH" property="sh" jdbcType="VARCHAR" />
<result column="YHBM" property="yhbm" jdbcType="VARCHAR" />
<result column="HTBH" property="htbh" jdbcType="VARCHAR" />
<result column="GXMC" property="gxmc" jdbcType="VARCHAR" />
<result column="RYMC" property="rymc" jdbcType="VARCHAR" />
<result column="YHKH" property="yhkh" jdbcType="VARCHAR" />
<result column="HH" property="hh" jdbcType="VARCHAR" />
<result column="JMFL" property="jmfl" jdbcType="VARCHAR" />
<result column="ZHXM" property="zhxm" jdbcType="VARCHAR" />
<result column="DWMC" property="dwmc" jdbcType="VARCHAR" />
<result column="JTDH" property="jtdh" jdbcType="VARCHAR" />
<result column="SJHM" property="sjhm" jdbcType="VARCHAR" />
<result column="SFY" property="sfy" jdbcType="VARCHAR" />
<result column="KSGNRQ" property="ksgnrq" jdbcType="DATE" />
<result column="RWRQ" property="rwrq" jdbcType="DATE" />
<result column="KZFS" property="kzfs" jdbcType="VARCHAR" />
<result column="XTXS" property="xtxs" jdbcType="VARCHAR" />
<result column="SFTSYH" property="sftsyh" jdbcType="VARCHAR" />
<result column="SFYHCX" property="sfyhcx" jdbcType="VARCHAR" />
<result column="SFYHSF" property="sfyhsf" jdbcType="VARCHAR" />
<result column="ZKCS" property="zkcs"/>
<result column="BZ" property="bz" jdbcType="VARCHAR" />
<result column="CZY" property="czy" jdbcType="VARCHAR" />
<result column="LRSJ" property="lrsj" jdbcType="DATE" />
<result column="KFSF" property="kfsf" jdbcType="VARCHAR" />
<result column="BKSFYY" property="bksfyy" jdbcType="VARCHAR" />
<result column="SFZH" property="sfzh" jdbcType="VARCHAR" />
<result column="SFLB" property="sflb" jdbcType="VARCHAR" />
<result column="GNZT" property="gnzt" jdbcType="VARCHAR" />
<result column="SFZK" property="sfzk" jdbcType="VARCHAR" />
<result column="SFDYK" property="sfdyk" jdbcType="VARCHAR" />
<result column="SJXTXS" property="sjxtxs" jdbcType="VARCHAR" />
<result column="KFS" property="kfs" jdbcType="VARCHAR" />
<result column="JSFS" property="jsfs" jdbcType="VARCHAR" />
<result column="HTDQNX" property="htdqnx" jdbcType="VARCHAR" />
<result column="HTQDRQ" property="htqdrq" jdbcType="DATE" />
<result column="HTQDNX" property="htqdnx" jdbcType="VARCHAR" />
<result column="TGDH" property="tgdh" jdbcType="VARCHAR" />
<result column="HFDH" property="hfdh" jdbcType="VARCHAR" />
<result column="TGHFJL" property="tghfjl" jdbcType="VARCHAR" />
<result column="JLBZT" property="jlbzt" jdbcType="VARCHAR" />
<result column="CQR" property="cqr" jdbcType="VARCHAR" />
<result column="ZLR" property="zlr" jdbcType="VARCHAR" />
<result column="CQRDH" property="cqrdh" jdbcType="VARCHAR" />
<result column="ZLRDH" property="zlrdh" jdbcType="VARCHAR" />
<result column="LXDH3" property="lxdh3" jdbcType="VARCHAR" />
<result column="LXDH4" property="lxdh4" jdbcType="VARCHAR" />
<result column="BXYHLB" property="bxyhlb" jdbcType="VARCHAR" />
<result column="DZ" property="dz" jdbcType="VARCHAR" />
<result column="FGS" property="fgs" jdbcType="VARCHAR" />
<result column="SFZT" property="sfzt" jdbcType="VARCHAR" />
<result column="SFMJ" property="sfmj" nullValue="0.0" />
<result column="RLZPINYIN" property="rlzpinyin" />
<result column="XQPINYIN" property="xqpinyin" />
<result column="fuwz" property="lxjjb.a" />
<result column="jzlx" property="lxjjb.b" />
</resultMap>


传进去的参数为:
Parameters: [20, 1, YHBH, ASC]


就是没有结果,怎么办?
...全文
126 1 打赏 收藏 转发到动态 举报
写回复
用AI写文章
1 条回复
切换为时间正序
请发表友善的回复…
发表回复
  • 打赏
  • 举报
回复
<result column="fuwz" property="lxjjb.a" />
<result column="jzlx" property="lxjjb.b" />
这样写确定是对的?

51,410

社区成员

发帖
与我相关
我的任务
社区描述
Java相关技术讨论
javaspring bootspring cloud 技术论坛(原bbs)
社区管理员
  • Java相关社区
  • 小虚竹
  • 谙忆
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧