ibatis的一个很奇怪的问题
我用ibatis查询一个表内容
参数文件如下:
<statement id="getPageFunction" resultClass="java.util.HashMap" parameterClass="java.lang.String" cacheModel="functioninfoformCache">
<![CDATA[SELECT * FROM BS_FUNCTION WHERE FUN_ID = #FUN_ID#
]]>
</statement>
我通过fun_id(主键)对bs_function表进行查询,返回结果一直为空,我换成其他的列查询,例如
<statement id="getPageFunction" resultClass="java.util.HashMap" parameterClass="java.lang.String" cacheModel="functioninfoformCache">
<![CDATA[SELECT * FROM BS_FUNCTION WHERE module_id = #fddddddd#
]]>
</statement>
这样查询就没有问题
真是怪事了,我采用toad运行一下sql语句,是没有问题的。
后台输出如下:
[QDPORT JAVA PLATFORM] 2006-06-27 19:39:23 - Created connection 5825185.
[QDPORT JAVA PLATFORM] 2006-06-27 19:39:23 - {conn-100000} Connection
[QDPORT JAVA PLATFORM] 2006-06-27 19:39:23 - {pstm-100001} PreparedStatement: SELECT * FROM BS_FUNCTION WHERE FUN_ID = ?
[QDPORT JAVA PLATFORM] 2006-06-27 19:39:23 - {pstm-100001} Parameters: [retire_tech_engage]
[QDPORT JAVA PLATFORM] 2006-06-27 19:39:23 - {pstm-100001} Types: [java.lang.String]
[QDPORT JAVA PLATFORM] 2006-06-27 19:39:23 - {rset-100002} ResultSet
[QDPORT JAVA PLATFORM] 2006-06-27 19:39:23 - Returned connection 5825185 to pool.
通过察看这个输出,参数应该是进行赋值的,怎么前台就是输出一个null值呢?
我前台程序如下:
try {
java.io.Reader reader = com.ibatis.common.resources.Resources.getResourceAsReader ("sql-map-config.xml");
sqlMap = com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(reader);
out.println(sqlMap.queryForObject("PageFunction.getPageFunction", "retire_tech_engage"));
} catch (Exception e) {
//sqlMap.endTransaction();
e.printStackTrace();
}
真是郁闷啊,哪位大虾给我一个帮助???????????????