Mybatis与Spring的整合

╰半夏微凉° 2024-03-24 21:37 51阅读 0赞

## 1.Spring与mybatis集成 ##

### 1.pom依赖 ###

<?xml version="1.0" encoding="UTF-8"?>
    <project xmlns="http://maven.apache.org/POM/4.0.0"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>
        <parent>
            <groupId>org.example</groupId>
            <artifactId>sptingIoc</artifactId>
            <version>1.0-SNAPSHOT</version>
        </parent>
    
        <artifactId>xzs.ssm</artifactId>
    
        <properties>
            <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
            <maven.compiler.source>1.8</maven.compiler.source>
            <maven.compiler.target>1.8</maven.compiler.target>
            <maven.compiler.plugin.version>3.7.0</maven.compiler.plugin.version>
    
            
            
            <spring.version>5.0.2.RELEASE</spring.version>
            
            <mybatis.version>3.4.5</mybatis.version>
            
            <mysql.version>5.1.44</mysql.version>
            
            <pagehelper.version>5.1.2</pagehelper.version>
            
            <mybatis.spring.version>1.3.1</mybatis.spring.version>
            
            <commons.dbcp2.version>2.1.1</commons.dbcp2.version>
            <commons.pool2.version>2.4.3</commons.pool2.version>
            
            <log4j2.version>2.9.1</log4j2.version>
            
            <junit.version>4.12</junit.version>
            <servlet.version>4.0.0</servlet.version>
            <lombok.version>1.18.2</lombok.version>
        </properties>
    
    
        <dependencies>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context</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-aspects</artifactId>
                <version>${spring.version}</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-web</artifactId>
                <version>${spring.version}</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-test</artifactId>
                <version>${spring.version}</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>${mybatis.version}</version>
            </dependency>
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>${mysql.version}</version>
            </dependency>
            
            <dependency>
                <groupId>com.github.pagehelper</groupId>
                <artifactId>pagehelper</artifactId>
                <version>${pagehelper.version}</version>
            </dependency>
            
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis-spring</artifactId>
                <version>${mybatis.spring.version}</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.apache.commons</groupId>
                <artifactId>commons-dbcp2</artifactId>
                <version>${commons.dbcp2.version}</version>
            </dependency>
            <dependency>
                <groupId>org.apache.commons</groupId>
                <artifactId>commons-pool2</artifactId>
                <version>${commons.pool2.version}</version>
            </dependency>
    
            
            
            <dependency>
                <groupId>org.apache.logging.log4j</groupId>
                <artifactId>log4j-core</artifactId>
                <version>${log4j2.version}</version>
            </dependency>
            <dependency>
                <groupId>org.apache.logging.log4j</groupId>
                <artifactId>log4j-api</artifactId>
                <version>${log4j2.version}</version>
            </dependency>
            
            <dependency>
                <groupId>org.apache.logging.log4j</groupId>
                <artifactId>log4j-web</artifactId>
                <version>${log4j2.version}</version>
            </dependency>
    
            
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>${junit.version}</version>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>javax.servlet-api</artifactId>
                <version>${servlet.version}</version>
                <scope>provided</scope>
            </dependency>
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
                <version>${lombok.version}</version>
                <scope>provided</scope>
            </dependency>
    
        </dependencies>
       <build> <resources>
           
           <resource>
               <directory>src/main/java</directory>
               <includes>
                   <include>**/*.xml</include>
               </includes>
           </resource>
           
           <resource>
               <directory>src/main/resources</directory>
               <includes>
                   <include>jdbc.properties</include>
                   <include>*.xml</include>
               </includes>
           </resource>
       </resources>
           <plugins>
               <plugin>
                   <groupId>org.apache.maven.plugins</groupId>
                   <artifactId>maven-compiler-plugin</artifactId>
                   <version>${maven.compiler.plugin.version}</version>
                   <configuration>
                       <source>${maven.compiler.source}</source>
                       <target>${maven.compiler.target}</target>
                       <encoding>${project.build.sourceEncoding}</encoding>
                   </configuration>
               </plugin>
               <plugin>
                   <groupId>org.mybatis.generator</groupId>
                   <artifactId>mybatis-generator-maven-plugin</artifactId>
                   <version>1.3.2</version>
                   <dependencies>
                       
                       <dependency>
                           <groupId>mysql</groupId>
                           <artifactId>mysql-connector-java</artifactId>
                           <version>${mysql.version}</version>
                       </dependency>
                   </dependencies>
                   <configuration>
                       <overwrite>true</overwrite>
                   </configuration>
               </plugin>
           </plugins>
       </build>
    </project>

2.配置文件

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
            "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd" >
    <generatorConfiguration>
        
        <properties resource="jdbc.properties"/>
     
        
        <classPathEntry
                location="D:\\zking App\\mvn_repository\\mysql\\mysql-connector-java\\5.1.44\\mysql-connector-java-5.1.44.jar"/>
     
        
        <context id="infoGuardian">
            
            <commentGenerator>
                <property name="suppressAllComments" value="true"/>
                <property name="suppressDate" value="true"/> 
            </commentGenerator>
     
            
            <jdbcConnection driverClass="${jdbc.driver}"
                            connectionURL="${jdbc.url}" userId="${jdbc.username}" password="${jdbc.password}"/>
     
            
            <javaTypeResolver>
                
                <property name="forceBigDecimals" value="false"/>
            </javaTypeResolver>
     
            
            
            
            <javaModelGenerator targetProject="src/main/java" targetPackage="com.tgq.model">
                
                <property name="enableSubPackages" value="false"/>
                
                <property name="constructorBased" value="true"/>
                
                <property name="trimStrings" value="false"/>
                
                <property name="immutable" value="false"/>
            </javaModelGenerator>
     
            
            <sqlMapGenerator targetProject="src/main/java" targetPackage="com.tgq.mapper">
                
                <property name="enableSubPackages" value="false"/>
            </sqlMapGenerator>
     
            
            
            
            
            <javaClientGenerator targetProject="src/main/java" targetPackage="com.tgq.mapper" type="XMLMAPPER">
                
                <property name="enableSubPackages" value="false"/>
            </javaClientGenerator>
     
            
            
            
            
            
            
            
            
            
            
            
            
            
     
            <table schema="" tableName="t_mvc_Book" domainObjectName="Book"
                   enableCountByExample="false" enableDeleteByExample="false"
                   enableSelectByExample="false" enableUpdateByExample="false">
                
                
                
                
            </table>
     
        </context>
    </generatorConfiguration>

#### 配置文件 ####

#### generatorConfig.xml ####

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
            "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd" >
    <generatorConfiguration>
        
        <properties resource="jdbc.properties"/>
     
        
        <classPathEntry
                location="D:\\zking App\\mvn_repository\\mysql\\mysql-connector-java\\5.1.44\\mysql-connector-java-5.1.44.jar"/>
     
        
        <context id="infoGuardian">
            
            <commentGenerator>
                <property name="suppressAllComments" value="true"/>
                <property name="suppressDate" value="true"/> 
            </commentGenerator>
     
            
            <jdbcConnection driverClass="${jdbc.driver}"
                            connectionURL="${jdbc.url}" userId="${jdbc.username}" password="${jdbc.password}"/>
     
            
            <javaTypeResolver>
                
                <property name="forceBigDecimals" value="false"/>
            </javaTypeResolver>
     
            
            
            
            <javaModelGenerator targetProject="src/main/java" targetPackage="com.tgq.model">
                
                <property name="enableSubPackages" value="false"/>
                
                <property name="constructorBased" value="true"/>
                
                <property name="trimStrings" value="false"/>
                
                <property name="immutable" value="false"/>
            </javaModelGenerator>
     
            
            <sqlMapGenerator targetProject="src/main/java" targetPackage="com.xzs.mapper">
                
                <property name="enableSubPackages" value="false"/>
            </sqlMapGenerator>
     
            
            
            
            
            <javaClientGenerator targetProject="src/main/java" targetPackage="com.tgq.mapper" type="XMLMAPPER">
                
                <property name="enableSubPackages" value="false"/>
            </javaClientGenerator>
     
            
            
            
            
            
            
            
            
            
            
            
            
            
     
            <table schema="" tableName="t_mvc_Book" domainObjectName="Book"
                   enableCountByExample="false" enableDeleteByExample="false"
                   enableSelectByExample="false" enableUpdateByExample="false">
                
                
                
                
            </table>
     
        </context>
    </generatorConfiguration>

这里为本地路径的Mysql jar包，，是需要更改的，路径赋值后也需要再加上**\\**

<classPathEntry
                location="D:\\zking App\\mvn_repository\\mysql\\mysql-connector-java\\5.1.44\\mysql-connector-java-5.1.44.jar"/>

jdbc.properties

jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost:3306/mybatis_ssm?useUnicode=true&characterEncoding=UTF-8
    jdbc.username=root
    jdbc.password=123456

log4j2.xml

<?xml version="1.0" encoding="UTF-8"?>
     
    
    <Configuration status="WARN" monitorInterval="30">
        <Properties>
            
            <Property name="LOG_HOME">/root/workspace/lucenedemo/logs</Property>
            <property name="ERROR_LOG_FILE_NAME">/root/workspace/lucenedemo/logs/error</property>
            <property name="WARN_LOG_FILE_NAME">/root/workspace/lucenedemo/logs/warn</property>
            <property name="PATTERN">%d{yyyy-MM-dd HH:mm:ss.SSS} [%t-%L] %-5level %logger{36} - %msg%n</property>
        </Properties>
     
        <Appenders>
            
            <Console name="Console" target="SYSTEM_OUT">
                
                <ThresholdFilter level="trace" onMatch="ACCEPT"
                                 onMismatch="DENY" />
                
                
                <PatternLayout pattern="${PATTERN}" />
            </Console>
     
            
            
            <File name="log" fileName="logs/test.log" append="false">
                <PatternLayout
                        pattern="%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n" />
            </File>
            
            <RollingFile name="RollingFileInfo" fileName="${LOG_HOME}/info.log"
                         filePattern="${LOG_HOME}/$${date:yyyy-MM}/info-%d{yyyy-MM-dd}-%i.log">
                
                <ThresholdFilter level="info" onMatch="ACCEPT"
                                 onMismatch="DENY" />
                <PatternLayout
                        pattern="%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n" />
                <Policies>
                    
                    
                    
                    <TimeBasedTriggeringPolicy interval="1"
                                               modulate="true" />
                    
                    
                </Policies>
            </RollingFile>
     
            <RollingFile name="RollingFileWarn" fileName="${WARN_LOG_FILE_NAME}/warn.log"
                         filePattern="${WARN_LOG_FILE_NAME}/$${date:yyyy-MM}/warn-%d{yyyy-MM-dd}-%i.log">
                <ThresholdFilter level="warn" onMatch="ACCEPT"
                                 onMismatch="DENY" />
                <PatternLayout
                        pattern="%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n" />
                <Policies>
                    <TimeBasedTriggeringPolicy />
                    <SizeBasedTriggeringPolicy size="2 kB" />
                </Policies>
                
                <DefaultRolloverStrategy max="20" />
            </RollingFile>
     
            <RollingFile name="RollingFileError" fileName="${ERROR_LOG_FILE_NAME}/error.log"
                         filePattern="${ERROR_LOG_FILE_NAME}/$${date:yyyy-MM}/error-%d{yyyy-MM-dd-HH-mm}-%i.log">
                <ThresholdFilter level="error" onMatch="ACCEPT"
                                 onMismatch="DENY" />
                <PatternLayout
                        pattern="%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n" />
                <Policies>
                    
                    <TimeBasedTriggeringPolicy interval="1"
                                               modulate="true" />
                    
                </Policies>
            </RollingFile>
     
        </Appenders>
     
        
        <Loggers>
            
            <logger name="org.springframework" level="INFO"></logger>
            <logger name="org.mybatis" level="INFO"></logger>
     
            
            <logger name="org.springframework" level="ERROR" />
            <logger name="org.hibernate" level="ERROR" />
            <logger name="org.apache.struts2" level="ERROR" />
            <logger name="com.opensymphony.xwork2" level="ERROR" />
            <logger name="org.jboss" level="ERROR" />
     
     
            
            <root level="all">
                <appender-ref ref="Console" />
                <appender-ref ref="RollingFileInfo" />
                <appender-ref ref="RollingFileWarn" />
                <appender-ref ref="RollingFileError" />
            </root>
     
        </Loggers>
     
    </Configuration>

#### spring-mybatis.xml ####

1.  扫描所有JavaBean，将对应的组件加载到spring的上下文
2.  配置session连接工厂
3.  配置mapper扫描接口
4.  配置事务管理器
5.  配置aop自动代理

> **注意自己的包名路径，如果不更改后面测试会报错**
> 
>     <?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:tx="http://www.springframework.org/schema/tx"
>            xmlns:aop="http://www.springframework.org/schema/aop"
>            xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">
>         
>         
>         <context:annotation-config/>
>         
>         <context:component-scan base-package="com.tgq"/>
>      
>         <context:property-placeholder location="classpath:jdbc.properties"/>
>      
>         <bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource"
>               destroy-method="close">
>             <property name="driverClassName" value="${jdbc.driver}"/>
>             <property name="url" value="${jdbc.url}"/>
>             <property name="username" value="${jdbc.username}"/>
>             <property name="password" value="${jdbc.password}"/>
>             
>             <property name="initialSize" value="10"/>
>             
>             <property name="maxTotal" value="100"/>
>             
>             <property name="maxIdle" value="50"/>
>             
>             <property name="minIdle" value="10"/>
>             
>             
>             <property name="maxWaitMillis" value="-1"/>
>         </bean>
>      
>         
>         
>         <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
>             
>             <property name="dataSource" ref="dataSource"/>
>             
>             <property name="mapperLocations" value="classpath*:com/tgq/**/mapper/*.xml"/>
>             
>             <property name="typeAliasesPackage" value="com/javaxl/ssm/**/model"/>
>             
>             <property name="plugins">
>                 <array>
>                     <bean class="com.github.pagehelper.PageInterceptor">
>                         <property name="properties">
>                             <value>
>                                 helperDialect=mysql
>                             </value>
>                         </property>
>                     </bean>
>                 </array>
>             </property>
>         </bean>
>      
>         
>         
>         <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
>             
>             
>             <property name="basePackage" value="com/tgq/**/mapper"/>
>             <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
>         </bean>
>      
>         <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
>             <property name="dataSource" ref="dataSource"/>
>         </bean>
>         <tx:annotation-driven transaction-manager="transactionManager"/>
>         <aop:aspectj-autoproxy/>
>     </beans>

spring-context.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"
>            xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">
>      
>      
>         
>         <import resource="classpath:spring-mybatis.xml"></import>
>      
>      
>      
>     </beans>

#### 生成model、mapper ####

选中对应的项目，依次选中生成

![f38911e5f104462a954863f2eccfc651.png][]

![400c9a9172bb4b83b56975d024cac11e.png][]

> 我们在生成的实体类上面添加**@Repository**，**@Repository**就相当于**<bean id="BookMapper" class="com.tgq.mapper.BookMapper"/>**

![cc84517541264950b2c1a2e6a7c6583f.png][]

#### 3、整合测试 ####

> #### 1、建立**Bookbiz**、**BookBizImpl** ####
> 
> 一个接口和一个接口实现类
> 
> ![88f70530f836446a8aa3dabdf0539621.png][]
> 
> 把我们的生成的BookMapper里面的方法复制到我们新建的BookBiz里面
> 
> ![4ddd6e8218b348c3bfc40f775614eebb.png][]
> 
> ![61440e548d9442589ed895c5b8a8a4a4.png][]
> 
>     package com.xzs.Biz;
>     
>     import com.xzs.model.Book;
>     
>     public interface BookBiz {
>         int deleteByPrimaryKey(Integer bid);
>     
>         int insert(Book record);
>     
>         int insertSelective(Book record);
>     
>         Book selectByPrimaryKey(Integer bid);
>     
>         int updateByPrimaryKeySelective(Book record);
>     
>         int updateByPrimaryKey(Book record);
>     }
> 
>     package com.xzs.Biz.impl;
>     
>     import com.xzs.Biz.BookBiz;
>     import com.xzs.mapper.BookMapper;
>     import com.xzs.model.Book;
>     import org.junit.jupiter.api.Test;
>     
>     public class BookBizImpl implements BookBiz {
>         private BookMapper Bookbiz;
>         @Override
>         public int deleteByPrimaryKey(Integer bid) {
>             return Bookbiz.deleteByPrimaryKey(bid);
>         }
>     
>         @Override
>         public int insert(Book record) {
>             return Bookbiz.insert(record);
>         }
>     
>         @Override
>         public int insertSelective(Book record) {
>             return Bookbiz.insertSelective(record);
>         }
>     
>         @Override
>         public Book selectByPrimaryKey(Integer bid) {
>             return Bookbiz.selectByPrimaryKey(bid);
>         }
>     
>         @Override
>         public int updateByPrimaryKeySelective(Book record) {
>             return Bookbiz.updateByPrimaryKeySelective(record);
>         }
>     
>         @Override
>         public int updateByPrimaryKey(Book record) {
>             return Bookbiz.updateByPrimaryKey(record);
>         }
>     
>     
>     }

2、创建测试类

> 创建**BookBizImpl**测试类
> 
>     package com.xzs.Biz.impl;
>     
>     import com.xzs.Biz.BookBiz;
>     import org.junit.Test;
>     import org.junit.runner.RunWith;
>     import org.springframework.test.context.ContextConfiguration;
>     import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
>     
>     import java.beans.ConstructorProperties;
>     
>     import static org.junit.Assert.*;
>     @RunWith(SpringJUnit4ClassRunner.class)
>     @ContextConfiguration(locations = {"classpath:spring-context.xml"})
>     public class BookBizImplTest {
>         private BookBiz bookBiz;
>     
>         @Test
>         public void deleteByPrimaryKey() {
>         }
>     
>         @Test
>         public void insert() {
>         }
>     
>         @Test
>         public void insertSelective() {
>         }
>     
>         @Test
>         public void selectByPrimaryKey() {
>             System.out.println(this.bookBiz.selectByPrimaryKey(25));
>         }
>     
>         @Test
>         public void updateByPrimaryKeySelective() {
>         }
>     
>         @Test
>         public void updateByPrimaryKey() {
>         }
>     }

结果：

![1afd67da485f435684012341060b546c.png][]

[f38911e5f104462a954863f2eccfc651.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/13/dae271c125574f259346b43275a9dfd5.png
[400c9a9172bb4b83b56975d024cac11e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/13/df283333fe624bb7b28d47eca46b71e3.png
[cc84517541264950b2c1a2e6a7c6583f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/13/e68500183cab4e8e81c7a52bfcdba528.png
[88f70530f836446a8aa3dabdf0539621.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/13/8a21df0f58564b1eba49eddc8a6d0db1.png
[4ddd6e8218b348c3bfc40f775614eebb.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/13/f2fbfbeaa840473ca7b3ce4ec7f30c6a.png
[61440e548d9442589ed895c5b8a8a4a4.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/13/aa1ab2497aed4b888aafd72a6d3c16ff.png
[1afd67da485f435684012341060b546c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/13/4dc8c41a4f2d4ce4851aca714eddba91.png