spring整合mybatis(注解)

1 创建一个maven工程，导入对应对标

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

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

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

<!--druid-->
<dependency>
	<groupId>com.alibaba</groupId>
	<artifactId>druid</artifactId>
	<version>1.1.10</version>
</dependency>

<!--spring操作数据库-->
<dependency>
	<groupId>org.springframework</groupId>
	<artifactId>spring-jdbc</artifactId>
	<version>5.2.10.RELEASE</version>
</dependency>

<!--spring整合mybatis-->
<dependency>
	<groupId>org.mybatis</groupId>
	<artifactId>mybatis-spring</artifactId>
	<version>1.3.0</version>
</dependency>

2 提供spring配置类(SpringConfig)

package cn.qiguai.config;

import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;

@Configuration
@ComponentScan("cn.qiguai")
public class SpringConfig {
}

3 提供jdbc.properties文件(用于提供连接数据源信息)

jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql:///test?useUnicode=true&characterEncoding=utf-8&userSSL=false&serverTimezone=GMT%2B8
jdbc.username=root
jdbc.password=EAdfpXS0988

4 加载properties文件

在SpringConfig类中使用PropertySource注解加载properties文件

5 提供DataSource数据库连接池对象(JdbcConfig)

package cn.qiguai.config;

import com.alibaba.druid.pool.DruidDataSource;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import javax.sql.DataSource;

public class JdbcConfig {
	@Value("${jdbc.driver}")
	private String driver;
	@Value("${jdbc.url}")
	private String url;
	@Value("${jdbc.username}")
	private String username;
	@Value("${jdbc.password}")
	private String password;

	@Bean
	public DataSource dataSource() {
		DruidDataSource dds = new DruidDataSource();

		dds.setDriverClassName(driver);
		dds.setUrl(url);
		dds.setUsername(username);
		dds.setPassword(password);

		return dds;
	}
}

6 创建MybatisConfig类

package cn.qiguai.config;

import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.mapper.MapperScannerConfigurer;
import org.springframework.context.annotation.Bean;
import javax.sql.DataSource;

public class MyBatisConfig {
	@Bean
	public SqlSessionFactoryBean sqlSessionFactoryBean(DataSource ds) {
		SqlSessionFactoryBean ssfb = new SqlSessionFactoryBean();

		ssfb.setDataSource(ds);

		return ssfb;
	}

	@Bean
	public MapperScannerConfigurer mapperScannerConfigurer() {
		MapperScannerConfigurer msc = new MapperScannerConfigurer();

		msc.setBasePackage("cn.qiguai.dao");

		return msc;
	}
}

7 导入配置

在spring配置类中使用Import注解导入JdbcConffig、MybatisConfig