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

小鱼儿 2022-07-15 04:19 188阅读 0赞

本人的项目下载地址：[http://download.csdn.net/detail/xinghuo0007/9670577][http_download.csdn.net_detail_xinghuo0007_9670577]  
方法三：  
**sping.xml;配置文件：**

**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">
    
    
        
        <context:property-placeholder location="classpath:jdbc.properties"/>
    
        <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
            
            <property name="url" value="${url}"/>
            <property name="username" value ="root"/>
            <property name="password" value="123456"/>
        </bean>
    
        
        <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配置文件**

**jdbc.properties**

driverClassName=com.mysql.jdbc.Driver
    username=root
    password=123456
    initialSize=1
    maxActive=20
    maxIdle=2
    minIdle=1
    url=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][http_nirvana1988.iteye.com_blog_971246]

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

<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>  
    
       
     <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”>

[http_download.csdn.net_detail_xinghuo0007_9670577]: http://download.csdn.net/detail/xinghuo0007/9670577
[http_nirvana1988.iteye.com_blog_971246]: http://nirvana1988.iteye.com/blog/971246