mybatis與spring整合ssm01

qq_50957390發表於2020-10-20

mybatis與spring整合

其實就是將SqlSessionFactory的建立交給spring管理

1. 新增相關依賴

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

    <groupId>com.zking</groupId>
    <artifactId>ssm1</artifactId>
    <version>1.0-SNAPSHOT</version>
    <packaging>war</packaging>

    <name>ssm1 Maven Webapp</name>
    <!-- FIXME change it to the project's website -->
    <url>http://www.example.com</url>

    <properties>
        <spring.version>5.0.2.RELEASE</spring.version>
        <maven.compiler.source>1.8</maven.compiler.source>
        <maven.compiler.target>1.8</maven.compiler.target>
    </properties>

    <dependencies>
        <!-- ********************** spring依賴 ********************** -->
        <!--1)spring核心依賴-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-core</artifactId>
            <version>${spring.version}</version>
        </dependency>
        
        <!--spring ioc依賴 -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-beans</artifactId>
            <version>${spring.version}</version>
        </dependency>
        
        <!--spring 擴充套件依賴 -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>${spring.version}</version>
        </dependency>
        
        <!--2)spring dao層依賴-->
        <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>
        
        <!--3)aop相關依賴 -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-aspects</artifactId>
            <version>${spring.version}</version>
        </dependency>
        
        <!--4)spring web相關依賴 -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-web</artifactId>
            <version>${spring.version}</version>
        </dependency>
        
        <!--5) spring test相關依賴 -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>${spring.version}</version>
        </dependency>
        
        <!--6)springMVC框架-->
        <dependency>
	        <groupId>org.springframework</groupId>
	        <artifactId>spring- webmvc</artifactId>
	        <version>${spring.version}</version>
        </dependency>


        <!-- ********************** junit 單元測試依賴 ********************** -->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>

        <!-- ********************** Java Servlet API  ********************** -->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>4.0.0</version>
            <scope>provided</scope>
        </dependency>

        <!-- ********************** Mybatis依賴 ********************** -->
        <!--1) mybatis核心 -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.5</version>
        </dependency>
        
        <!--2) Mybatis分頁外掛-->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper</artifactId>
            <version>5.1.2</version>
        </dependency>
        
        <!--3) spring整合mybatis -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>1.3.1</version>
        </dependency>

        <!-- ********************** Mysql JDBC驅動 ********************** -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.44</version>
        </dependency>

        <!--dbcp2連線池依賴-->
        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-dbcp2</artifactId>
            <version>2.1.1</version>
        </dependency>
        
        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-pool2</artifactId>
            <version>2.4.3</version>
        </dependency>

        <!-- **********************  日誌 配置  ********************** -->
        <!--記得修改mybatis.cfg.xml新增如下內容-->
        <!--<setting name="logImpl" value="LOG4J2"/>-->
        
        <!--核心log4j2jar包-->
        <dependency>
            <groupId>org.apache.logging.log4j</groupId>
            <artifactId>log4j-core</artifactId>
            <version>2.9.1</version>
        </dependency>
        
        <dependency>
            <groupId>org.apache.logging.log4j</groupId>
            <artifactId>log4j-api</artifactId>
            <version>2.9.1</version>
        </dependency>
        
        <!--web工程需要包含log4j-web，非 web工程不需要-->
        <dependency>
            <groupId>org.apache.logging.log4j</groupId>
            <artifactId>log4j-web</artifactId>
            <version>2.9.1</version>
        </dependency>
    </dependencies>

    <build>
        <finalName>ssm1</finalName>
        <resources>
            <!--解決mybatis-generator-maven-plugin執行時沒有將XxxMapper.xml檔案放入target資料夾的問題-->
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.xml</include>
                </includes>
            </resource>
            <!--解決mybatis-generator-maven-plugin執行時沒有將jdbc.properites檔案放入target資料夾的問題-->
            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>jdbc.properties</include>
                    <include>*.xml</include>
                </includes>
            </resource>
        </resources>

        <pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
            <plugins>
                <plugin>
                    <groupId>org.mybatis.generator</groupId>
                    <artifactId>mybatis-
                        generator-maven-plugin</artifactId>
                    <version>1.3.2</version>
                    <dependencies>
                        <!--使用Mybatis-generator外掛不能使用太高版本的mysql驅動-->
                        <dependency>
                            <groupId>mysql</groupId>
                            <artifactId>mysql-connector-java</artifactId>
                            <version>5.1.44</version>
                        </dependency>
                    </dependencies>
                    <configuration>
                        <overwrite>true</overwrite>
                    </configuration>
                </plugin>
            </plugins>
        </pluginManagement>
    </build>
</project>

1.2 spring整合mybatis
     <dependency>
           <groupId>org.mybatis</groupId>
           <artifactId>mybatis-spring</artifactId>
           <version>1.3.1</version>
     </dependency>

1.3 新增dbcp2連線池依賴
    <dependency>
           <groupId>org.apache.commons</groupId>
           <artifactId>commons-dbcp2</artifactId>
           <version>2.1.1</version>
     </dependency>
     <dependency>
           <groupId>org.apache.commons</groupId>
           <artifactId>commons-pool2</artifactId>
           <version>2.4.3</version>
     </dependency>

2. 建立spring配置檔案spring.xml，並進行相關配置

註解式開發
引入外接jdbc配置檔案
dbcp2資料庫連線池配置
spring和MyBatis整合
註解式事務配置開始 <tx:annotation-driven transaction-manager=“transactionManager”/>

3. 註解式開發
@Repository 倉庫一般存在於dao層
@Service 服務的意思
@Constroller 控制層

@Component 萬能註解，如果你再類上面加了這個註解，它表示這一個主鍵它交給spring管理
@Scope 範圍的意思，就是表示範圍多列模式和單列模式

@Autowired
@Resource
注1：各個註解的作用請參考資料“註解式開發”

@Transactional
注2：個人感覺註解式事務比以前的宣告式事務更加麻煩，要寫的東西更多

4. Spring Test+JUnit完美組合
4.1 在工程的pom檔案中增加spring-test的依賴

<dependency>
     <groupId>org.springframework</groupId>
     <artifactId>spring-test</artifactId>
     <version>${spring.version}</version>
</dependency>

4.2 建立BaseTestCase,並在該類上加上兩個註解：
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations={“classpath:spring.xml”})

4.3 使用idea的junit外掛(JUnitGenerator V2.0)生成測試用例，
注1：還需要修改相關配置，詳情參考資料：“IDEA Junit4配置.mht”
注2：快捷鍵，Ctrl + Shift + T

4.4 在執行單元測試時,為了避免產生髒資料,可將測試單元設定成事務回滾
@Rollback(value = true|false)//true回滾事務，false提交事務
@Transactional(transactionManager = “transactionManager”)

5. 修改分頁程式碼：
使用AOP程式設計解決分頁程式碼重複的問題
注1：AOP註解式開發詳情見資料“Spring如何實現AOP環繞通知.mht”
注2：AOP分頁實現“PageBeanAsp“

MAVEN指令：mybatis-generator:generate -e

實體類類的ToString&&set&&get的註解方法外掛

<dependency>
      <groupId>org.projectlombok</groupId>
      <artifactId>lombok</artifactId>
      <version>1.18.0</version>
      <scope>provided</scope>
</dependency>

Mybatis與Spring整合
2018-09-11
MyBatisSpring
spring：spring與mybatis的整合
2020-10-19
SpringMyBatis
Spring同時整合JPA與Mybatis
2020-08-11
SpringMyBatis
mybatis整合spring
2019-01-19
MyBatisSpring
Spring 整合 MyBatis
2020-06-30
SpringMyBatis
Spring整合MyBatis
2020-12-25
SpringMyBatis
MyBatis(九) 整合Spring、整合SpringMVC
2018-07-18
MyBatisSpringMVC
Spring整合Mybatis plus
2018-08-30
SpringMyBatis
Spring整合JUnit，Mybatis
2024-04-07
SpringMyBatis
Spring Boot 整合 MyBatis
2022-05-13
Spring BootMyBatis
Mybatis與Spring整合時都做了什麼？
2019-08-02
MyBatisSpring
深入淺出MyBatis：MyBatis與Spring整合及實用場景
2018-03-31
MyBatisSpring
SSM整合（Spring、SpringMVC、Mybatis）
2024-04-11
SSMSpringMVCMyBatis
SSM——Spring整合SpringMVC,MyBatis
2020-11-22
SSMSpringMVCMyBatis
SSM(SpringMVC + Spring + Mybatis)整合
2018-03-27
SSMSpringMVCMyBatis
spring整合mybatis（idea版）
2020-12-08
SpringMyBatisIdea
Spring框架（五）實戰Spring整合Mybatis
2020-12-17
Spring框架MyBatis
Mybatis外掛擴充套件以及與Spring整合原理
2020-07-09
MyBatis套件Spring
Mybatis 的使用（整合Spring、SpringBoot）
2018-06-08
MyBatisSpring Boot
Spring整合Mybatis方式二 - SqlSessionTemplate
2024-03-27
SpringMyBatisSQLSession
Spring Boot —— 整合 MyBatis-Plus
2024-05-20
Spring BootMyBatis
Spring+SpringMVC+MyBatis框架整合
2020-04-05
SpringMVCMyBatis框架
Spring筆記(四)整合Mybatis
2020-11-30
Spring筆記MyBatis
Spring+SpringMVC+MyBatis的整合
2020-11-27
SpringMVCMyBatis
JAVA學習Spring整合Mybatis
2020-11-26
JavaSpringMyBatis
Spring boot學習（三） Spring boot整合mybatis
2019-01-17
Spring BootMyBatis
MyBatis和Spring整合的奧祕
2020-07-07
MyBatisSpring
Shiro和Spring MVC、Mybatis整合教程
2019-02-02
SpringMVCMyBatis
【Spring Boot】快速整合Mybatis-Plus
2023-02-07
Spring BootMyBatis
Mybatis整合Spring（ssm整合待續）-day04
2020-10-04
MyBatisSpringSSM
Spring Boot整合MyBatis實現通用Mapper
2018-08-22
Spring BootMyBatisAPP
Spring Boot（六）整合 MyBatis 操作 MySQL 8
2018-09-12
Spring BootMyBatisMySql
小代學Spring Boot之整合MyBatis
2019-07-19
Spring BootMyBatis
深入原始碼理解Spring整合MyBatis原理
2021-07-29
原始碼SpringMyBatis
Spring Boot系列（三）：Spring Boot整合Mybatis原始碼解析
2020-08-20
Spring BootMyBatis原始碼
Spring Boot 整合 MyBatis和 SQL Server實踐
2018-12-17
Spring BootMyBatisSQLServer
Spring+SpringMVC+MyBatis+easyUI整合最佳化
2021-09-09
SpringMVCMyBatisUI
Spring boot學習（五）Spring boot整合Mybatis Generator以及PageHelper
2019-01-20
Spring BootMyBatis

mybatis與spring整合ssm01

mybatis與spring整合

相關文章