spring3.2.3 mybatis3.2.2 整合，并已经通过测试

梦里梦外; 2022-10-01 09:45 127阅读 0赞

**配置借鉴：**jpetstore 可在mybatis官网找到，以及一篇博客[http://www.cnblogs.com/dennisit/archive/2013/04/10/3012972.html][http_www.cnblogs.com_dennisit_archive_2013_04_10_3012972.html]（按照博客方式未配置成功![疑问][doubt.gif]）

**操作系统**：windows2008R2

**数据库**：SQLSERVER2008R2

**下载地址**：[http://download.csdn.net/detail/yeness/5625619][http_download.csdn.net_detail_yeness_5625619]

**必备包**：可在“下载地址”中找到

**文件结构如下**：

![Center][]

**Spring 配置文件“applicationContext.xml”实现如下：**

<?xml version="1.0" encoding="UTF-8"?>  
  
  
<beans xmlns="http://www.springframework.org/schema/beans"  
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  
xmlns:aop="http://www.springframework.org/schema/aop"  
xmlns:tx="http://www.springframework.org/schema/tx"  
xmlns:jdbc="http://www.springframework.org/schema/jdbc"  
xmlns:context="http://www.springframework.org/schema/context"  
xsi:schemaLocation="  
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd  
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd  
http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-3.0.xsd  
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd  
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd">  
  
  
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">  
<property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"></property>  
<property name="url" value="jdbc:sqlserver://192.168.0.55:1433;databaseName=YQBlog"></property>  
<property name="username" value="sa"></property>  
<property name="password" value="Dx123456"></property>  
</bean>  
  
<bean id="transactionManager"  
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">  
<property name="dataSource" ref="dataSource" />  
</bean>  
  
  
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">  
<property name="dataSource" ref="dataSource" />  
<property name="configLocation" value="classpath:mybatis-config.xml"/>  
  
</bean>  
  
<bean id="userDao" class="org.mybatis.spring.mapper.MapperFactoryBean">  
<property name="mapperInterface" value="com.icreate.dao.UserDao"></property>  
<property name="sqlSessionFactory" ref="sqlSessionFactory"></property>  
</bean>  
  
<bean id="userService" class="com.icreate.services.Impl.UserServiceImpl">  
<property name="userDao" ref="userDao"></property>  
</bean>  
</beans>

**MyBatis.xml配置如下：**

<?xml version="1.0" encoding="UTF-8"?>  
<!DOCTYPE configuration  
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"  
"http://mybatis.org/dtd/mybatis-3-config.dtd">  
<configuration>  
    <mappers>  
        <mapper resource="com/icreate/dao/UserDao.xml"/>  
    </mappers>  
</configuration>

**web.xml配置如下：**

<?xml version="1.0" encoding="UTF-8"?>  
<web-app version="2.5"   
xmlns="http://java.sun.com/xml/ns/javaee"   
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"   
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee   
http://java.sun.com/xml/ns/javaee/web-app\_2\_5.xsd">  
  <context-param>  
        <param-name>contextConfigLocation</param-name>  
              
            <param-value>/config/applicationContext.xml</param-value>  
    </context-param>  
      
      
    <listener>  
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>  
    </listener>  
      
    <welcome-file-list>  
        <welcome-file>index.jsp</welcome-file>  
    </welcome-file-list>  
</web-app>

[http_www.cnblogs.com_dennisit_archive_2013_04_10_3012972.html]: http://www.cnblogs.com/dennisit/archive/2013/04/10/3012972.html
[doubt.gif]: /images/20220118/b24ec53d190b4b9dbb5b815dd20cbb5f.png
[http_download.csdn.net_detail_yeness_5625619]: http://download.csdn.net/detail/yeness/5625619
[Center]: /images/20220118/2b86d7d143f64924853412c3b9bba97b.png