熟悉SpringMVC+ibatis的达人来看下，不熟悉的也来看下！

Question

哎，熟悉springMVC+ibatis的好人帮下忙，弄不明白！公司给我们新人一个作业就是用这两个东西做个登录！帮个忙吧！我的IDE是MyEclipse6.5,还有就是自己加了
commons-dbcp.jar和commons-pool-1.3.jar，还有个就是ibatis-2.3.0.677.jar，我把spring的配置文件和ibatis-sqlmap-config.xml就放在了
src路径下，其他没了。文件头部分是自己生成，没道理不标准呀！在线等，6点就下班了，救救我，我住那暂时不能联网
*************************************************
spring的配置文件，spring2.5
************************************************
<?xml version="1.0" encoding="UTF-8"?>
<beans
xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd"><bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"        
        destroy-method="close">       
    <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />       
    <property name="url" value="jdbc:oracle:thin:@localhost:1521:XE" />       
    <property name="username" value="system" />       
    <property name="password" value="tiger" />       
</bean>
<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
        <property name="configLocation">
            <value>ibatis-sqlmap-config.xml</value>
        </property>
</bean> 
************无关的都省略了
</beans>
*********************************************
ibatis的配置文件
**********************************************<?xml version="1.0" encoding="UTF-8"?>
<sqlMapConfig>  
    <settings maxRequests="256" maxSessions="64" maxTransactions="16"  
        enhancementEnabled="true" />  
    <sqlMap resource="com/csii/bean/po/sqlmap_user.xml"></sqlMap>  
</sqlMapConfig> ***********************************************************************
            sqlmap_user.xml         映射了我自己建的一个表tuser
***********************************************************************
<?xml version="1.0" encoding="UTF-8"?>
<sqlMap namespace="User">  
       
    <typeAlias alias="User" type="com.csii.bean.User" />  
    <cacheModel id="user-cache" type="OSCACHE">  
        <flushInterval hours="24" />  
        <flushOnExecute statement="queryAll" />  
        <property name="size" value="1000" />  
    </cacheModel>  
    <select id="queryAll" resultClass="User" cacheModel="user-cache">  
        select id,password,name,account,balance from tuser   
    </select>  
  
    <select id="queryById" parameterClass="java.lang.String"  
        resultClass="User">  
        select id,password,name,account,balance from tuser where id=#id#   
    </select>  
    <insert id="insertNewUser" parameterClass="com.csii.bean.User">
      insert into tuser(id, password,name,account,balance)values( #id#,#password#,#name#,#account#,#balance#);
    </insert>
    <update id="updateBalance" parameterClass="com.csii.bean.User">  
        update tuser set balance = #balance# 
    </update>  
  
</sqlMap>  
****************************************************
    解析spring的配置文件报错了，代码如下，异常在后面
****************************************************
public class CheckLogin {
public boolean isLegal(String id,String password){
ApplicationContext ac=new ClassPathXmlApplicationContext("applicationContext.xml");
UserServiceImp userServiceImp=(UserServiceImp)ac.getBean("userServiceTarget");
User user=userServiceImp.getUserById(id);
if(user.getPassword().equals(password))return true;
else return false;
}
}
********************************
异常信息
********************************
org.xml.sax.SAXParseException: Document root element "sqlMapConfig", must match DOCTYPE root "null".
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source)
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.rootElementSpecified(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.handleStartElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.startElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$ContentDispatcher.scanRootElementHook(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Unknown Source)
at com.ibatis.common.xml.NodeletParser.createDocument(NodeletParser.java:189)
at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:59)
at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:106)
at com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientBuilder.java:90)
at org.springframework.orm.ibatis.SqlMapClientFactoryBean.buildSqlMapClient(SqlMapClientFactoryBean.java:326)
at org.springframework.orm.ibatis.SqlMapClientFactoryBean.afterPropertiesSet(SqlMapClientFactoryBean.java:280)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1367)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1333)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:471)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:220)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:423)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:729)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:381)
at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83)
at com.csii.bean.CheckLogin.isLegal(CheckLogin.java:11)
at com.csii.controller.Login.handleRequest(Login.java:19)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)

Answer 1

你们公司还用springMVC啊 不错啊  做好了 分享出来挖

Answer 2

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE sqlMapConfig     PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"     "http://www.ibatis.com/dtd/sql-map-config-2.dtd"><sqlMapConfig>   
  <settings maxRequests="256" maxSessions="64" maxTransactions="16"   
  enhancementEnabled="true" />   
  <sqlMap resource="com/csii/bean/po/sqlmap_user.xml"></sqlMap>   
</sqlMapConfig>