spring整合mybatis方法总结（两种）

本人的项目下载地址：http://download.csdn.net/detail/xinghuo0007/9670577
方法三：
sping.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:context="http://www.springframework.org/schema/context"    xmlns:c="http://www.springframework.org/schema/c"    xmlns:mybatis-spring="http://mybatis.org/schema/mybatis-spring"    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd        http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring-1.2.xsd        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd"><!-- <bean id="stu" class="cn.cupcat.test.Student">    <property name="name" value="zhangsan"></property>    <property name="qq" value="123456"></property></bean> -->    <!-- 自动扫描dao和service包(自动注入) -->    <context:annotation-config />    <context:component-scan base-package="cn.cupcat.service"        use-default-filters="true" />    <!-- 配置spring管理的基础bean -->    <context:component-scan base-package="cn.cupcat.*" >    </context:component-scan></beans>

sping整合mybatis文件：sping-mybaits.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:context="http://www.springframework.org/schema/context"    xmlns:c="http://www.springframework.org/schema/c"    xmlns:mybatis-spring="http://mybatis.org/schema/mybatis-spring"    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd        http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring-1.2.xsd        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd">    <!-- 引入jdbc的基础配置文件 ：jdbc.properties -->    <context:property-placeholder location="classpath:jdbc.properties"/>    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">        <!-- <property name="driver" value="${driverClassName}"/> -->        <property name="url" value="${url}"/>        <property name="username" value ="root"/>        <property name="password" value="123456"/>    </bean>    <!-- 使用spring管理事务 -->    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">        <constructor-arg index="0" ref="dataSource"/>    </bean>    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">        <property name="dataSource" ref="dataSource"/>        <property name="mapperLocations" value="classpath:cn/cupcat/mapper/*.xml"/>     </bean>      <bean id="mapperScannerConfigurer"  class="org.mybatis.spring.mapper.MapperScannerConfigurer">        <property name="basePackage" value="cn.cupcat.dao"/>    </bean>    <bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate" >        <constructor-arg index="0" ref="sqlSessionFactory"/>    </bean></beans>

springmvc.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:mvc="http://www.springframework.org/schema/mvc"    xmlns:context="http://www.springframework.org/schema/context" xmlns:c="http://www.springframework.org/schema/c"    xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd        http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.3.xsd        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd">    <mvc:annotation-driven />    <context:component-scan base-package="cn.cupcat.controller" />    <bean id=""        class="org.springframework.web.servlet.view.InternalResourceViewResolver">        <property name="prefix" value="/WEB-INF/" />        <property name="suffix" value=".jsp" />    </bean></beans>

jdbc.properties

driverClassName=com.mysql.jdbc.Driverusername=rootpassword=123456initialSize=1maxActive=20maxIdle=2minIdle=1url=jdbc\:mysql\://127.0.0.1\:3306/adressbook02?useUnicode\=true&characterEncoding\=UTF-8

log4j.properties

log4j.rootLogger=DEBUG, Console  #Console  log4j.appender.Console=org.apache.log4j.ConsoleAppender  log4j.appender.Console.layout=org.apache.log4j.PatternLayout  log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n  log4j.logger.java.sql.ResultSet=INFO  log4j.logger.org.apache=INFO  log4j.logger.java.sql.Connection=DEBUG  log4j.logger.java.sql.Statement=DEBUG  log4j.logger.java.sql.PreparedStatement=DEBUG  

以上是我自己搭建sping+spingmvc+mybatis的项目的配置文件。

以下是转载人家的配置。

原文链接：http://nirvana1988.iteye.com/blog/971246

1、采用数据映射器（MapperFactoryBean）的方式，不用写mybatis映射文件，采用注解方式提供相应的sql语句和输入参数。
（1）Spring配置文件：
Java代码 收藏代码

 <!--创建jdbc数据源 -->   <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">     <property name="driverClassName" value="${driver}"/>     <property name="url" value="${url}"/>     <property name="username" value="${username}"/>     <property name="password" value="${password}"/>     <property name="initialSize" value="${initialSize}"/>     <property name="maxActive" value="${maxActive}"/>     <property name="maxIdle" value="${maxIdle}"/>     <property name="minIdle" value="${minIdle}"/>   </bean>   <!-- 创建SqlSessionFactory，同时指定数据源-->   <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">    <property name="dataSource" ref="dataSource" />    </bean>    <!--创建数据映射器，数据映射器必须为接口-->   <bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">    <property name="mapperInterface" value="com.xxt.ibatis.dbcp.dao.UserMapper" />    <property name="sqlSessionFactory" ref="sqlSessionFactory" />    </bean>   <bean id="userDaoImpl2" class="com.xxt.ibatis.dbcp.dao.impl.UserDaoImpl2">   <property name="userMapper" ref="userMapper"/>  

（2）数据映射器UserMapper,代码如下:
Java代码 收藏代码
public interface UserMapper {
@Select(“SELECT * FROM user WHERE id = #{userId}”)
User getUser(@Param(“userId”) long id);
}

(3) dao接口类UserDao，代码如下：

Java代码 收藏代码
public interface UserDao {
public User getUserById(User user);
}

(4)dao实现类UserDaoImpl2,，代码如下:
Java代码 收藏代码
public class UserDaoImpl2 implements UserDao {
private UserMapper userMapper;

 public void setUserMapper(UserMapper userMapper) {        this.userMapper = userMapper;    }     public User getUserById(User user) {      return userMapper.getUser(user.getId());    }  

}

2、采用接口org.apache.ibatis.session.SqlSession的实现类org.mybatis.spring.SqlSessionTemplate。
mybatis中, sessionFactory可由SqlSessionFactoryBuilder.来创建。MyBatis-Spring 中，使用了SqlSessionFactoryBean来替代。SqlSessionFactoryBean有一个必须属性dataSource，另外其还有一个通用属性configLocation（用来指定mybatis的xml配置文件路径）。
（1）Spring配置文件：
Xml代码 收藏代码

lt;bean id=”sqlSessionFactory” class=”org.mybatis.spring.SqlSessionFactoryBean”>