圖片來源網路
為啥寫這篇文章呢，有人可能會說springBoot的mybatis的starter都有了寫這篇文章不是多此一舉嗎？難道是真的嗎？其實我一開始也是使用mybatis的starter的，但是當我需要配置一個讓mybatis可以將執行sql語句打印出來的配置時，難到了我，所以才想和大家分享一下springBoot整合MyBatis的方法，如果大家有更好地方法，歡迎討論。首先看一下項目的目錄結構
工程的目錄結構
SpringBoot整合Mybatis的思路
1.設置數據源DataSource，我們使用@ConfigurationProperties來加載yml裡數據源的配置
2.配置SqlSessionFactory在裡面配置加載的xml配置文件和數據源
3.使用@MapperScan來掃描加載DAO層接口
4.在yml中配置相關參數
5.mybatis與數據庫對應的文件生成可以參照之前寫的還在手寫Mybatis的xml文件，那你就OUT了
代碼實現
1.引入相關jar
org.mybatis.spring.boot mybatis-spring-boot-starter 1.3.2 mysql mysql-connector-java 6.0.6 com.alibaba druid 1.0.29 org.projectlombok lombok 1.16.18
2.定義一個類，繼承DruidDataSource，負責數據源的屬性加載和初始化數據源
//為代碼清晰去除相關引用
@ConfigurationProperties(prefix = DataSourceSettings.PREFIX)
@Data
public class DataSourceSettings extends DruidDataSource {
public static final String PREFIX = "druid.dataSource";
private String mapperLocations;
}
3.設置掃描mapper的路徑和初始化SqlSessionFactoryBean
//為代碼清晰去除相關引用
@Configuration
@MapperScan(basePackages = {"com.example.demo.mapper"})
@EnableConfigurationProperties(DataSourceSettings.class)
public class DataSourceAutoConfiguration {
//DataSourceSettings繼承DruidDataSource,所以也是數據源
@Autowired
DataSourceSettings settings;
//SqlSessionFactoryBean相關配置
@Bean
public SqlSessionFactoryBean sqlSessionFactory(ApplicationContext applicationContext) throws IOException {
SqlSessionFactoryBean sqlSessionFactory = new SqlSessionFactoryBean();
//配置數據源
sqlSessionFactory.setDataSource(settings);
//日誌主要為打印SQL語句
Properties properties = new Properties();
properties.setProperty("logImpl", "STDOUT_LOGGING");
sqlSessionFactory.setConfigurationProperties(properties);
//加載xml的路徑配置
sqlSessionFactory.setMapperLocations(
applicationContext.getResources(settings.getMapperLocations()));
return sqlSessionFactory;
}
//事務管理器配置
@Bean
public DataSourceTransactionManager mybatisTransactionManager() {
DataSourceTransactionManager transactionManager
= new DataSourceTransactionManager();
dataSourceTransactionManager.setDataSource(settings);
return dataSourceTransactionManager;
}
}
4.編寫yml配置
druid: dataSource: driverClassName: com.mysql.cj.jdbc.Driver url: jdbc:mysql://localhost:3306/study?useUnicode=true&characterEncoding=utf-8 username: root password: initialSize: 5 maxActive: 200 minIdle: 5 maxWait: 60000 validationQuery: SELECT 1 FROM DUAL removeAbandoned: true removeAbandonedTimeout: 180 mapperLocations: classpath*:mapper/**/*.xml logging: ##配置sql打印日誌 level: com.example.demo.mapper: DEBUG org.springframework.web: DEBUG java.sql: DEBUG org.mybatis.spring: DEBUG
5.SpringBoot啟動類
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.scheduling.annotation.EnableAsync;
import org.springframework.transaction.annotation.EnableTransactionManagement;
@SpringBootApplication
@EnableTransactionManagement //啟動事務管理
public class DemoApplication {
public static void main(String[] args) {
SpringApplication.run(DemoApplication.class, args);
}
}
效果展示
執行sql的顯示
分享到:
