Spring学习笔记【十六】纯注解Spring+Mybatis编程

纯注解Spring+Mybatis编程

01 基础配置02 Mapper03 Mapper.xml04 使用05 MapperLocations 编码时通配的写法06 耦合问题

6.1 创建配置文件6.2 新建一个类6.3 配置类

连接池SqlSessionFactoryBeanMapperScannerConfigure

@Configuration
@ComponentScan("com.frame.mybatis")
@MapperScan(basePackages = ("com.frame.mybatis"))
public class AppConfig {
    @Bean
    public DruidDataSource dataSource(){
        DruidDataSource dataSource = new DruidDataSource();
        dataSource.setDriverClassName("com.mysql.cj.jdbc.Driver");
        dataSource.setUrl("jdbc:mysql://localhost:3306/chat?serverTimezone=UTC");
        dataSource.setUsername("root");
        dataSource.setPassword("123456");
        return dataSource;
    }
    @Bean
    public SqlSessionFactoryBean sqlSessionFactoryBean(){
        SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
        sqlSessionFactoryBean.setDataSource(dataSource());
        sqlSessionFactoryBean.setTypeAliasesPackage("com.frame.mybatis");
        sqlSessionFactoryBean.setMapperLocations(new ClassPathResource("UserMapper.xml"));
        return sqlSessionFactoryBean;
    }

}

public interface UserMapper {
    public List getAllUser();
}

    
        select * from user
    

ApplicationContext ac = new AnnotationConfigApplicationContext(AppConfig.class);
UserMapper userMapper = (UserMapper) ac.getBean("userMapper");
List allUser = userMapper.getAllUser();

 sqlSessionFactoryBean.setMapperLocations(new ClassPathResource("UserMapper.xml"));

// 参数实际上就是Resource的可变长参数

  public void setMapperLocations(Resource... mapperLocations) {
    this.mapperLocations = mapperLocations;
  }

// 通配的写法
ResourcePatternResolver pattern = new PathMatchingResourcePatternResolver();
Resource[] resources = pattern.getResources("com.frame.mybatis/*Mapper.xml");
sqlSessionFactoryBean.setMapperLocations(resources);

mybatis.driverClassName=com.mysql.cj.jdbc.Driver
mybatis.url=jdbc:mysql://localhost:3306/chat?serverTimezone=UTC
mybatis.username=root
mybatis.password=123456
mybatis.mapperLocations=com.frame.mybatis/*Mapper.xml
mybatis.typeAliasesPackages=com.frame.mybatis

package com.frame.mybatis;

import lombok.Data;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.PropertySource;
import org.springframework.stereotype.Component;

@Component
@PropertySource("mybatis.properties")
@Data
public class MybatisProperties {
    @Value("${mybatis.driverClassName}")
    private String driverClassName;
    @Value("${mybatis.url}")
    private String url;
    @Value("${mybatis.username}")
    private String username;
    @Value("${mybatis.password}")
    private String password;
    @Value("${mybatis.typeAliasesPackages}")
    private String typeAliasesPackages;
    @Value("${mybatis.mapperLocations}")
    private String mapperLocations;
}

@Configuration
@ComponentScan("com.frame.mybatis")
@MapperScan(basePackages = ("com.frame.mybatis"))
@PropertySource("mybatis.properties")
public class AppConfig {
    @Autowired
    private MybatisProperties mybatisProperties;
    @Bean
    public DruidDataSource dataSource(){
        DruidDataSource dataSource = new DruidDataSource();
        dataSource.setDriverClassName(mybatisProperties.getDriverClassName());
        dataSource.setUrl(mybatisProperties.getUrl());
        dataSource.setUsername(mybatisProperties.getUsername());
        dataSource.setPassword(mybatisProperties.getPassword());
        return dataSource;
    }
    @Bean
    public SqlSessionFactoryBean sqlSessionFactoryBean() throws IOException {
        SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
        sqlSessionFactoryBean.setDataSource(dataSource());
        sqlSessionFactoryBean.setTypeAliasesPackage(mybatisProperties.getTypeAliasesPackages());
        ResourcePatternResolver pattern = new PathMatchingResourcePatternResolver();
        Resource[] resources = pattern.getResources(mybatisProperties.getMapperLocations());
        sqlSessionFactoryBean.setMapperLocations(resources);
        return sqlSessionFactoryBean;
    }

}