mybatis学习笔记(10): spring整合mybatis

àì夳堔傛蜴生んèń 2022-05-21 09:04 146阅读 0赞

添加依赖:

<dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.11</version>
        <scope>test</scope>
    </dependency>
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.4.1</version>
    </dependency>
    
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.37</version>
    </dependency>
    
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis-spring</artifactId>
        <version>1.3.0</version>
    </dependency>
    
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>${spring.version}</version>
    </dependency>
    
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-webmvc</artifactId>
        <version>${spring.version}</version>
    </dependency>
    
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-orm</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-tx</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-jdbc</artifactId>
        <version>${spring.version}</version>
    </dependency>
    
    <dependency>
        <groupId>com.mchange</groupId>
        <artifactId>c3p0</artifactId>
        <version>0.9.5.2</version>
    </dependency>
    <dependency>
        <groupId>org.apache.taglibs</groupId>
        <artifactId>taglibs-standard-spec</artifactId>
        <version>1.2.5</version>
    </dependency>
    <dependency>
        <groupId>org.apache.taglibs</groupId>
        <artifactId>taglibs-standard-impl</artifactId>
        <version>1.2.5</version>
    </dependency>

所有的jar：  
![这里写图片描述][70]

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:context="http://www.springframework.org/schema/context" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:mybatis-spring="http://mybatis.org/schema/mybatis-spring" 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.xsd http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring-1.2.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd">
    
        <context:component-scan base-package="com.ssm">
            <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller" />
        </context:component-scan>
    
        <context:property-placeholder location="classpath*:db.properties" />
        
        <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
            <property name="driverClass" value="${dev_driver}"></property>
            <property name="jdbcUrl" value="${dev_url}"></property>
            <property name="user" value="${dev_username}"></property>
            <property name="password" value="${dev_password}"></property>
        </bean>
    
        
        <bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
            <property name="dataSource" ref="dataSource"></property>
            
            <property name="configLocation" value="classpath:mybatis-config.xml"></property>
            
            <property name="mapperLocations" value="classpath:mybatis/mapper/*.xml"></property>
            
            <property name="typeAliasesPackage" value="com.ssm.domain"></property>
        </bean>
    
        
        
        <mybatis-spring:scan base-package="com.ssm.mapper"/>
    
         
       
    
    
        
        <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            <property name="dataSource" ref="dataSource"></property>
        </bean>
    
        
        <tx:annotation-driven transaction-manager="transactionManager" />
    </beans>

整合思路:  
将数据源配置交给spring容器管理  
将Mapper代理对象的生成交给spring容器管理  
将事务控制交给容器管理

Mapper 接口文件:

public interface EmployeeMapper {
    
        public List<Employee> getEmps ();
    }

Mapper XML文件：

<mapper namespace="com.ssm.mapper.EmployeeMapper">
        
        <select id="getEmps" resultType="com.ssm.domain.Employee">
            select * from tbl_employee
        </select>
    </mapper>

spring容器会根据Mapper XML文件创建代理类，并将之注册到容器内。

测试：

@Test
    public void testssm(){
        ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml");
        EmployeeMapper mapper = ac.getBean(EmployeeMapper.class);
        List<Employee> emps = mapper.getEmps();
        for (Employee emp : emps) {
            System.out.println(emp);
        }
    }

[70]: /images/20220521/a392e1d2cf454188a9a20a7bab059929.png