04.整合mybatis

1.添加pom依赖

        <!--mybatis依赖-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.2</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

2.MybatisConfig配置类

package com.lvxk.demo.config;

import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;

import javax.sql.DataSource;

/**
 * MybatisConfig
 * Description: <br/>
 * date: 2020/5/5 8:22<br/>
 *
 * @author lvxk<br />
 * @since JDK 1.8
 */
@Configuration
@MapperScan("com.lvxk.demo.dao")
public class MybatisConfig {

    @Autowired
    private DataSource dataSource;

    @Bean
    public SqlSessionFactory sqlSessionFactory()throws Exception{
        SqlSessionFactoryBean sessionFactory =new SqlSessionFactoryBean();
        sessionFactory.setDataSource(dataSource);
        sessionFactory.setTypeAliasesPackage("com.lvxk.demo.model");//设置别名
        PathMatchingResourcePatternResolver resolver = new
                PathMatchingResourcePatternResolver();
        sessionFactory.setMapperLocations(resolver.getResources("classpath*:**/sqlmap/*.xml"));//配置映射扫描路径xml
        return sessionFactory.getObject();
    }
}

3.配置数据源

在application.yml配置连接的数据库信息

server:
  port: 8081

spring:
  application:
    name: demo
  datasource:
    username: root
    password: 123456
    url:jdbc:mysql://192.168.79.135:3307/d_lvxk?characterEncoding=utf8&characterSetResults=utf8&autoReconnect=true&failOverReadOnly=false

4.配置maven打包路径

        <!--打包xml的路径-->
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**sqlmap/*.xmk</include>
                </includes>
                <filtering>false</filtering>
            </resource>
            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.*</include>
                </includes>
                <filtering>true</filtering>
            </resource>
        </resources>

整合tkmybatis 和mybatis plus任选其一 这里不在说明