springboot中为持久层mapper.xml添加驼峰命名

1.在resources下添加mybatis-config.xml:

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>

    <settings>
<!--        &lt;!&ndash; 开启mybatis日志输出，使用system进行控制台输出&ndash;&gt;-->
        <setting name="logImpl" value="STDOUT_LOGGING"/>
        <!-- 开启驼峰自动映射，实现数据库列名和属性名匹配 -->
        <setting name="mapUnderscoreToCamelCase" value="true"/>
    </settings>

<!--    <mappers>-->
<!--        <mapper resource="mapper/TeacherMapper.xml"/>-->
<!--    </mappers>-->

</configuration>

2.在application.properties中添加：

mybatis.config-location=classpath:mybatis-config.xml

3.修改mybatis配置类：

package com.example.config;

import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.io.ClassPathResource;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;

import javax.sql.DataSource;

@Configuration
@MapperScan("com.example.mapper") // 指定Mapper接口所在的包
public class MybatisConfig {

    @Bean
    public SqlSessionFactory sqlSessionFactory(DataSource dataSource) throws Exception {
        SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
        sessionFactory.setDataSource(dataSource);
        // 可以通过sessionFactory.setConfigLocation()等方法来配置MyBatis
        // 例如，加载自定义的MyBatis配置文件
         sessionFactory.setConfigLocation(new ClassPathResource("mybatis-config.xml"));
        // 但在这个例子中，我们直接使用了Spring Boot的自动配置
        return sessionFactory.getObject();
    }


}