Mybatis-SpringBoot內建/配置

sql語句在java檔案中，隻需配置一處

(1)在啟動類上寫@MapperScan("包的全限定名")，例如@MapperScan("com.fm.fmone.dao")
然後在這個包下的類檔案寫sql語句，例如
@Select("SELECT * FROM 表 WHERE id=#{id}")
@Results({ @Result(property = "userName", column = "user_name"),
    @Result(property = "userSex", column = "user_sex") })
public List<UserEntity> findUser(String id);      

1.在啟動類上寫@MapperScan("包的全限定名")，
2.在application.properties檔案中寫mybatis.mapperLocations=classpath:com/fm/fmone/mapper/*.xml
（注意：我的sql xml檔案都在com.fm.fmone.mapper包下）      

#下劃線轉駝峰
mybatis.configuration.map-underscore-to-camel-case=true      

<configuration>
    <!-- 全局配置 -->
    <settings>
       <!-- 下劃線轉駝峰 -->
        <setting name="mapUnderscoreToCamelCase" value="true"/>
    </settings>
</configuration>