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任选其一 这里不在说明