02 MyBatis & Druid

转载

mob604756fc093d 2021-04-05 16:56:00

文章标签 sql spring mysql xml java 文章分类 代码人生

MyBatis

MyBatis 是灵活的 SQL 映射, 不想 Hibrnate 是纯的 ORM, 个人还是比较写 SQL 语句, 不喜欢纯的 ORM.

首先引入 Maven 依赖.

　　<groupId>org.mybatis.spring.boot</groupId>

　　<artifactId>mybatis-spring-boot-starter</artifactId>

</dependency>

　　<groupId>mysql</groupId>

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

</dependency>

添加 mybatis 配置, 包括 DAO, Model, XML映射文件.

在 config 包下边创建一个 MybatisConfig.java

package com.example.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;

@Configuration
@MapperScan("com.example.demo.**.dao") // 扫描DAO
public class MybatisConfig {

    @Autowired
    private javax.sql.DataSource dataSource;

    @Bean
    public SqlSessionFactory sqlSessionFactory() throws Exception {
        SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
        sessionFactory.setDataSource(dataSource);
        sessionFactory.setTypeAliasesPackage("com.example.demo.**.model");

        PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
        sessionFactory.setMapperLocations(resolver.getResources("classpath*:**/sqlmap/*.xml"));

        return sessionFactory.getObject();
    }
}