springboot - mybatis - 下划线与驼峰自动转换 mapUnderscoreToCamelCase

柔情只为你懂 2023-06-02 05:27 4阅读 0赞

以前都是在mybatis.xml中来配置，但是spring boot不想再用xml配置文件。网上搜寻了好久，才找到设置办法：sessionFactoryBean.getObject().getConfiguration().setMapUnderscoreToCamelCase(true);

db配置文件源码：

package com.vip.qa.vop.config;
    
    import com.alibaba.druid.pool.DruidDataSource;
    import org.apache.ibatis.session.SqlSessionFactory;
    import org.mybatis.spring.SqlSessionFactoryBean;
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.beans.factory.annotation.Qualifier;
    import org.springframework.beans.factory.annotation.Value;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    import org.springframework.context.annotation.Primary;
    import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
    import org.springframework.jdbc.datasource.DataSourceTransactionManager;
    import javax.sql.DataSource;
    import java.util.Properties;
    
    /**
     * Created by danny.yao on 2017/10/25.
     */
    @Configuration
    @MapperScan(basePackages = VOPDataSourceConfig.PACKAGE, sqlSessionFactoryRef = "vopSqlSessionFactory")
    public class VOPDataSourceConfig {
        static final String PACKAGE = "com.vip.qa.vop.mapper.vop";
    
        @Value("${vop.datasource.url}")
        private String dbUrl;
    
        @Value("${vop.datasource.username}")
        private String dbUser;
    
        @Value("${vop.datasource.password}")
        private String dbPassword;
    
        @Value("${vop.datasource.driver-class-name}")
        private String dbDriver;
    
        @Bean(name = "vopDataSource")
        @Qualifier
        @Primary
        public DataSource vopDataSource() {
            DruidDataSource dataSource = new DruidDataSource();
            dataSource.setDriverClassName(dbDriver);
            dataSource.setUrl(dbUrl);
            dataSource.setUsername(dbUser);
            dataSource.setPassword(dbPassword);
            return dataSource;
        }
    
        @Bean(name = "vopSqlSessionFactory")
        @Qualifier
        @Primary
        public SqlSessionFactory vopSqlSessionFactory(@Qualifier("vopDataSource") DataSource scepDataSource) throws Exception {
            final SqlSessionFactoryBean sessionFactoryBean = new SqlSessionFactoryBean();
            sessionFactoryBean.setDataSource(scepDataSource);
    
            PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
            sessionFactoryBean.setMapperLocations(resolver.getResources("classpath:/mybatis/vop/*.xml"));
            sessionFactoryBean.getObject().getConfiguration().setMapUnderscoreToCamelCase(true);
    
            return sessionFactoryBean.getObject();
        }
    
    //    @Bean(name = "vopTransactionManager")
    //    @Qualifier
    //    public DataSourceTransactionManager testDataTransactionManager() {
    //        return new DataSourceTransactionManager(vopDataSource());
    //    }
    
    }

参考：[http://www.cnblogs.com/gods/p/4423422.html][http_www.cnblogs.com_gods_p_4423422.html]

转载于:https://www.cnblogs.com/dannyyao/p/7736246.html

[http_www.cnblogs.com_gods_p_4423422.html]: http://www.cnblogs.com/gods/p/4423422.html