Mybatis结果生成键值对的实例代码
下面给大家介绍下mybatis结果生成键值对的实例代码，具体内容如下所示：
在实际应用中我们经常会遇到这样的情况，需要给下拉框赋值，这个时候就需要键值对了，具体使用方法如下
1，在maper.xml文件中定义结果类型(resultType)定义为hashmap,如下所示
<selectid="selectSuperUnitInfo"resultType="hashmap"> SELECTunit_id,unit_namefromunit_info </select>
2，在对应的mapper类中用List<Map<String,String>>来接受这个类型，如下所示
publicList<Map<String,String>>selectSuperUnitInfo();
其实最强大的莫过于resultMap类型了，这个可以在mapper.xml文件中自定义扩展类型，然后在包中添加这个类型即可，真是强大
下面给大家补充下MyBatis返回Map键值对数据
List<Map<String,String>>getMtypeList(); <selectid="getMtypeList"resultType="java.util.HashMap"> selectcode,`name`fromjk_control_measure </select>
[DEBUG]2016-08-2917:50:09:==>Executing:selectcode,`name`fromjk_control_measure [DEBUG]2016-08-2917:50:09:==>Parameters: [DEBUG]2016-08-2917:50:10:<==Columns:code,name [DEBUG]2016-08-2917:50:10:<==Row:one,地面冲洗 [DEBUG]2016-08-2917:50:10:<==Row:two,边界围挡 [DEBUG]2016-08-2917:50:10:<==Row:three,垃圾覆盖 [DEBUG]2016-08-2917:50:10:<==Row:four,裸地覆盖 [DEBUG]2016-08-2917:50:10:<==Row:five,洒水降尘 [DEBUG]2016-08-2917:50:10:<==Row:six,车辆冲洗 [DEBUG]2016-08-2917:50:10:<==Row:seven,建筑渣土 [DEBUG]2016-08-2917:50:10:<==Row:eight,车辆冒装 [DEBUG]2016-08-2917:50:10:<==Row:nine,扬尘覆盖 [DEBUG]2016-08-2917:50:10:<==Row:ten,车辆撒漏 [DEBUG]2016-08-2917:50:10:<==Row:eleven,车辆黑烟 [DEBUG]2016-08-2917:50:10:<==Row:twelve,道路积尘
[{"NAME":"地面冲洗","name":"地面冲洗","code":"one","CODE":"one"},
{"NAME":"边界围挡","name":"边界围挡","code":"two","CODE":"two"},
{"NAME":"垃圾覆盖","name":"垃圾覆盖","code":"three","CODE":"three"},
{"NAME":"裸地覆盖","name":"裸地覆盖","code":"four","CODE":"four"},
{"NAME":"洒水降尘","name":"洒水降尘","code":"five","CODE":"five"},
{"NAME":"车辆冲洗","name":"车辆冲洗","code":"six","CODE":"six"},
{"NAME":"建筑渣土","name":"建筑渣土","code":"seven","CODE":"seven"},
{"NAME":"车辆冒装","name":"车辆冒装","code":"eight","CODE":"eight"},
{"NAME":"扬尘覆盖","name":"扬尘覆盖","code":"nine","CODE":"nine"},
{"NAME":"车辆撒漏","name":"车辆撒漏","code":"ten","CODE":"ten"},
{"NAME":"车辆黑烟","name":"车辆黑烟","code":"eleven","CODE":"eleven"},
{"NAME":"道路积尘","name":"道路积尘","code":"twelve","CODE":"twelve"}
]
返回的结果带有大写与小写的key
如果在sql语句中的列名使用大写会怎样呢？自己测试一下吧！如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对毛票票网站的支持！