直接上图吧
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>
<!DOCTYPE sqlMap
PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd">
一般xml放在src下面吧?通过classpath找到文件
的位置没弄清楚吧