各位大侠,帮忙看看这个问题怎么解决?2010-09-11 13:26:32,671 ERROR (org.apache.struts2.dispatcher.Dispatcher:341) - Could not execute action
com.ibatis.sqlmap.client.SqlMapException: There is no statement named 2 in this SqlMap.
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.getMappedStatement(SqlMapExecutorDelegate.java:292)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:556)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:540)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:110)
at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:88)
at org.dhf.bbw.admin.usermanage.admin.dao.UserDAOImp.getUserByID(UserDAOImp.java:47)
at org.dhf.bbw.admin.usermanage.admin.action.AdminUserEdit.execute(AdminUserEdit.java:24)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)在网上搜了很多,但是都觉得不了说明:映射文件有加入到sqlmap-config.xml中,而且路径什么的都对!如下:<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
  <sqlMap resource="org/dhf/bbw/admin/usermanage/admin/bean/User.xml"/>
</sqlMapConfig>User.xml内容如下:【调用的是getUserByID】<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap namespace="User"> <typeAlias alias="User" type="org.dhf.bbw.admin.usermanage.admin.bean.User"/>

<resultMap id="UserResult" class="User">
<result property="user_id" column="user_id"/>
<result property="user_no" column="user_no"/>
<result property="user_accounts" column="user_accounts"/>
<result property="user_pwd" column="user_pwd"/>
<result property="user_name" column="user_name"/>
<result property="user_phone" column="user_phone"/>
<result property="user_email" column="user_email"/>
<result property="user_description" column="user_description"/>
<result property="user_enterDate" column="user_enterDate"/>
<result property="user_auditDate" column="user_auditDate"/>
<result property="user_modifyDate" column="user_modifyDate"/>
<result property="user_auditor" column="user_auditor" select="getUserByID"/>
<result property="user_state" column="user_state"/>
</resultMap>

<select id="getAllUser" resultMap="UserResult">
select * from BBW_USER
</select>

<select id="getUserByID" parameterClass="int" resultMap="UserResult">
select * from BBW_USER where user_id = #value#
</select>

</sqlMap>
麻烦各位高手赐教,非常感谢!~~