[Java知识库]Spring集成Mybatis

Spring集成Mybatis的核心是将SqlSessionFactory交由Spring管理，并由Spring来管理dao接口的代理实现

搭建流程

导入jar包

导入Mybatis的jar包

		<!--mybatis-->
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
			<version>3.4.2</version>
		</dependency>

导入Mysql的jar包

    	<!-- mysql-connector-java -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>8.0.16</version>
		</dependency>

导入Spring集合Mybtis的插件包

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

导入Spring以及相关的jar包：

       <!-- spring-context -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>5.2.2.RELEASE</version>
        </dependency>

        <!-- spring-jdbc -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.2.2.RELEASE</version>
        </dependency>
		
		<!-- spring-aop -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-aspects</artifactId>
			<version>5.2.2.RELEASE</version>
		</dependency>

加入阿里的数据源

        <!-- 阿里数据源 -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.10</version>
        </dependency>

配置sqlSessionFactory和指定生成接口的对象

<?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
        https://www.springframework.org/schema/beans/spring-beans.xsd">
        
    <!-- spring管理生成SqlSessionFactory,读取mybatis各项配置配置-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!--导入德鲁伊的数据包-->
        <property name="dataSource" ref="druidDataSource"></property>
        <!--读取Mybatis的配置文件-->
        <property name="configLocation" value="classpath:mybatis-config.xml"></property>
        <!--添加映射文件的路径，*是模糊匹配的意思-->
        <property name="mapperLocations" value="classpath:mapper/*Mapper.xml"></property>
    </bean>
    <!--生成指定包下面的接口代理对象-->
    <bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <!--配置放接口的包的名字-->
        <property name="basePackage" value="com.wang.ssm.dao"></property> 
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
    </bean>
</beans>

实例：
Spring的配置文件：

<?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:aop="http://www.springframework.org/schema/aop"
    xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:mvc="http://www.springframework.org/schema/mvc"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
        https://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/aop
        http://www.springframework.org/schema/aop/spring-aop.xsd
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx.xsd
        http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc.xsd">

    <!--开启Spring的注解扫描功能-->
    <context:component-scan base-package="com.wang.ssm"></context:component-scan>

    <!--导入db的配置文件-->
    <import resource="db.xml"></import>

    <import resource="spring_mybatis.xml"></import>
   
</beans>

Spring的配置文件中引用了db和spring_mybatis的xml配置文件

db.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:aop="http://www.springframework.org/schema/aop"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
        https://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/aop
        http://www.springframework.org/schema/aop/spring-aop.xsd
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx.xsd
        http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc.xsd">

<!--读取属性文件-->
    <context:property-placeholder location="config.properties"></context:property-placeholder>
    <!--创建阿里的数据库连接管理对象-->
    <bean id="druidDataSource" class="com.alibaba.druid.pool.DruidDataSource">
        <property name="driverClassName" value="${driverClassName}"></property>
        <property name="url" value="${url}"></property>
        <property name="username" value="${ume}"></property>
        <property name="password" value="${pwd}"></property>
        <property name="initialSize" value="${initialSize}"></property>
        <property name="maxActive" value="${maxActive}"></property>
    </bean>
    <!--创建Spring事务管理类-->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="druidDataSource"></property>
    </bean>

    <!--开启Spring事务注解-->
    <tx:annotation-driven transaction-manager="transactionManager"></tx:annotation-driven>

</beans>

db.xml的配置文件中中读取了config.properties的配置文件
config.properties主要写的是对数据库信息的整理，方便修改。

config.properties的配置文件：

driverClassName=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/demo?characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai
ume=root
pwd=wasd
initialSize=5
maxActive=15

spring_mybatis的配置文件：

<?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
        https://www.springframework.org/schema/beans/spring-beans.xsd">
        
    <!-- spring管理生成SqlSessionFactory,读取mybatis各项配置配置-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!--导入德鲁伊的数据包-->
        <property name="dataSource" ref="druidDataSource"></property>
        <!--读取Mybatis的配置文件-->
        <property name="configLocation" value="classpath:mybatis-config.xml"></property>
        <!--添加映射文件的路径，*是模糊匹配的意思-->
        <property name="mapperLocations" value="classpath:mapper/*Mapper.xml"></property>
    </bean>
    <!--生成指定包下面的接口代理对象-->
    <bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <!--配置放接口的包的名字-->
        <property name="basePackage" value="com.wang.ssm.dao"></property>
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
    </bean>
</beans>

spring_mybatis引用了mybatis的配置文件中的数据

mybatis的位置文件：

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
    PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
    "http://mybatis.org/dtd/mybatis-3-config.dtd">
<!--
  mybatis核心配置文件
-->
<configuration>

	<!--全局配置-->
	<settings>
		<!--配置日志实现  使用log4j   添加log4j日志组件 导入jar包  配置属性文件-->
		<setting name="logImpl" value="LOG4J"/>
		<!--是否开启驼峰命名自动映射，即从经典数据库列名 A_COLUMN 映射到经典 Java 属性名 aColumn。-->
		<setting name="mapUnderscoreToCamelCase" value="true"/>
		<!--<setting name="lazyLoadingEnabled" value="true"/>-->
		<!--lazyLoadTriggerMethods 指定哪些方法触发延迟加载-->
		<setting name="lazyLoadTriggerMethods" value=""/>
		<!--开启全局二级缓存配置-->
		<setting name="cacheEnabled" value="true"/>
	</settings>

</configuration>

路径关系图：

Mybatis向数据库发送消息的语句：

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
 <!--namespace="某个接口的名称"-->
<mapper namespace="com.wang.ssm.dao.AdminDao">

    <insert id="saveAdmin">
        insert into admin(account,password)values('admin','111')
    </insert>

</mapper>

java接口调用xml向数据库发送数据：

package com.wang.ssm.dao;

import org.springframework.stereotype.Repository;

@Repository//在这里不加也是可以的，已经已经在配置文件中配置扫描了。
public interface AdminDao {

    void saveAdmin();
}

对数据处理层的处理

package com.wang.ssm.service;

import com.wang.ssm.dao.AdminDao;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

@Service(value = "adminService")
public class AdminService {

    @Autowired
    AdminDao adminDao;

    @Transactional
    public void saveAdmin(){
        adminDao.saveAdmin();
    }
}

测试类：

package com.wang.ssm.test;

import com.wang.ssm.service.AdminService;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

public class Test {
    public static void main(String[] args) {
        ApplicationContext applicationContext = new ClassPathXmlApplicationContext("Spring.xml");
        AdminService adminService = applicationContext.getBean("adminService", AdminService.class);
        adminService.saveAdmin();
    }
}

能够成功执行，并给数据库输进数据

上一篇：>>> Spring对事物的管理