Mybatis自动映射驼峰命名_免手动映射两种方案
Mybatis自动映射驼峰命名_免手动映射两种方案
1.修改Mybatis-config.xml文件增加(ssm)
<?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>
<setting name="mapUnderscoreToCamelCase" value="true"/>
<setting name="defaultStatementTimeout" value="3000" />
</settings>
</configuration>
2.在boot项目增加配置类
@Configuration
public class MyBatisConfig {
@Bean
public ConfigurationCustomizer configurationCustomizer(){
return new ConfigurationCustomizer(){
@Override
public void customize(Configuration configuration) {
configuration.setMapUnderscoreToCamelCase(true);
}
};
}
}
在后续mapper中就不需要手动映射了。
注意的是:
必须实体类和表字段对应.
例如:
userId — user_id
userName — user_name