ibatis xml 配置问题
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap namespace="User">
<typeAlias alias="UserObject" type="com.lin.ibatis.domain.User" />
<resultMap id="userResult" class="UserObject">
<result property="userName" column="l_userName" jdbcType="VARCHAR2" />
<result property="password" column="l_password" jdbcType="VARCHAR2" />
<result property="name" column="l_name" jdbcType="VARCHAR2" />
</resultMap>
<select id="getUser" resultMap="UserMap">
<![CDATA[
select
l_username,
l_password,
l_name
from login
where l_username = #value#
]]>
</select>
</sqlMap>
xml 文件为如上内容时,无异常,可正确取出login中的信息。
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap namespace="User">
<typeAlias alias="UserObject" type="com.lin.ibatis.domain.User" />
<resultMap id="userResult" class="UserObject">
<result property="userName" column="l_userName" jdbcType="VARCHAR2" />
<result property="password" column="l_password" jdbcType="VARCHAR2" />
<result property="name" column="l_name" jdbcType="VARCHAR2" />
</resultMap>
<select id="getUser" resultMap="UserMap">
<![CDATA[
select
l_username,
l_password,
l_name
from login
where l_username = #value#
]]>
</select>
<statement id="getCnt" resultClass="java.lang.Integer">
select count(*) from login
</statement>
</sqlMap>
如上,增加了<statement></statement>后,SqlMapClientBuilder.buildSqlMapClient(reader)都无法通过,这是什么原因?
<statement id="getCnt" resultClass="java.lang.Integer">
select count(*) from login
</statement>
这些在java application中能正常取出数据,但到struts和tomcat中便报错?