mybatis中mapUnderscoreToCamelCase的使用

时间:2023-01-29 20:01:45

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>
<setting name="mapUnderscoreToCamelCase" value="true" />
</settings>
</configuration>


开始以为配置了这个文件就可以了,搞了半天还是没生效,不能转驼峰,然后查了下configuration初始化时它的值也为true,说明初始化是正确,后来才知道原因出在mapper文件


 

<?xml version="1.0" encoding="UTF-8" ?>  
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="menu.mysql">
<select id="selectMenu" resultType="org.me.menu.Menu">
select MENU_ID, MENU_NAME, PARENT_ID, URL, TITLE, LEAF, ORDER_SEQ
from mysql.MENU
order by ORDER_SEQ
</select>
</mapper>



 开始我配置成resultType="hashMap"是可以返回结果,但是结果是没有自动转成驼峰,要真正存在一个与它对应的驼峰Bean与它对应才生效,resultType="org.me.menu.Menu"