直接上图吧
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in class path resource [applicationContext.xml]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse config resource: ServletContext resource [/WEB-INF/sqlMapConfig.xml]; nested exception is com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: java.io.IOException: Could not find resource /WEB-INF/User_sqlMap.xml
applicationContext.xml 部分代码 (sqlMapConfig.xml放在WEB-INF目录下)
<property name="configLocation">
<value>/WEB-INF/sqlMapConfig.xml</value>
</property>
sqlMapConfig.xml<!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-config-2.dtd"><sqlMapConfig>
<settings useStatementNamespaces="true"/>
<sqlMap resource="/WEB-INF/User_sqlMap.xml"/>
</sqlMapConfig>
User_sqlMap.xml
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMapConfig> <typeAlias alias="user" type="com.vo.User"/> <insert id="saveUser" parameterClass="user">
<selectKey keyProperty="id" resultClass="int">
<![CDATA[
select (max(id)+1) as value from z_user
]]>
</selectKey>
<![CDATA[
insert into z_user(name,sex,age,address,phone,email)
values(#name#,#sex#,#age#,#address#,#phone#,#email#)
]]>
</insert>
<delete id="deleteUser" parameterClass="int">
<![CDATA[
delete from z_user where id=#id#
]]>
</delete>
<select id="getAllUsers" resultClass="user">
<![CDATA[
select * from z_user
]]>
</select>
<update id="updateUser" parameterClass="user">
<![CDATA[
update z_user set
name=#name#,
sex=#sex#,
age=#age#,
address=#address#,
phone=#phone#,
email=#email#
where id=#id#
]]>
</update>
<select id="findUserById" parameterClass="int" resultClass="user">
<![CDATA[
select * from z_user where id=#id#
]]>
</select>
</sqlMapConfig>
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in class path resource [applicationContext.xml]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse config resource: ServletContext resource [/WEB-INF/sqlMapConfig.xml]; nested exception is com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'. Cause: java.io.IOException: Could not find resource /WEB-INF/User_sqlMap.xml
applicationContext.xml 部分代码 (sqlMapConfig.xml放在WEB-INF目录下)
<property name="configLocation">
<value>/WEB-INF/sqlMapConfig.xml</value>
</property>
sqlMapConfig.xml<!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-config-2.dtd"><sqlMapConfig>
<settings useStatementNamespaces="true"/>
<sqlMap resource="/WEB-INF/User_sqlMap.xml"/>
</sqlMapConfig>
User_sqlMap.xml
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMapConfig> <typeAlias alias="user" type="com.vo.User"/> <insert id="saveUser" parameterClass="user">
<selectKey keyProperty="id" resultClass="int">
<![CDATA[
select (max(id)+1) as value from z_user
]]>
</selectKey>
<![CDATA[
insert into z_user(name,sex,age,address,phone,email)
values(#name#,#sex#,#age#,#address#,#phone#,#email#)
]]>
</insert>
<delete id="deleteUser" parameterClass="int">
<![CDATA[
delete from z_user where id=#id#
]]>
</delete>
<select id="getAllUsers" resultClass="user">
<![CDATA[
select * from z_user
]]>
</select>
<update id="updateUser" parameterClass="user">
<![CDATA[
update z_user set
name=#name#,
sex=#sex#,
age=#age#,
address=#address#,
phone=#phone#,
email=#email#
where id=#id#
]]>
</update>
<select id="findUserById" parameterClass="int" resultClass="user">
<![CDATA[
select * from z_user where id=#id#
]]>
</select>
</sqlMapConfig>
解决方案 »
- excel2007解析的问题
- Struts1、Spring2、Ibatis整合结果,tomecat能正常启动,但是Spring的依赖注入时候,得不到实体Bean,求解
- spring动态数据源,求解
- 问weblogic下载地址
- Hibernate查询
- 用myeclipse搭建struts+hibernate的问题
- 请问:手动写的bpel流程(简单的,顺序结构)可以直接导入执行引擎吗?能执行吗?
- 大哥们救救我,hibernat中的删除问题
- java 中如何打印数据(即如何将取得的数据放到Execl表格中),求助!!!
- 关于struts中checkbox的用法.
- toad中建oracle数据库加comments
- 按时间统计
<!DOCTYPE sqlMap
PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd">
一般xml放在src下面吧?通过classpath找到文件
的位置没弄清楚吧