下面给大家介绍下mybatis结果生成键值对的实例代码,具体内容如下所示:
在实际应用中我们经常会遇到这样的情况,需要给下拉框赋值,这个时候就需要键值对了,具体使用方法如下
1,在maper.xml文件中定义结果类型(resultType)定义为hashmap,如下所示
1
2
3
|
<select id= "selectSuperUnitInfo" resultType= "hashmap" > SELECT unit_id ,unit_name from unit_info </select> |
2,在对应的mapper类中用List<Map<String,String>>来接受这个类型,如下所示
1
|
public List<Map<String,String>> selectSuperUnitInfo(); |
其实最强大的莫过于resultMap类型了,这个可以在mapper.xml文件中自定义扩展类型,然后在包中添加这个类型即可,真是强大
下面给大家补充下MyBatis返回Map键值对数据
1
2
3
4
|
List<Map<String, String>> getMtypeList(); <select id= "getMtypeList" resultType= "java.util.HashMap" > select code,`name` from jk_control_measure </select> |
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
[DEBUG] 2016 - 08 - 29 17 : 50 : 09 :==> Executing: select code,`name` from jk_control_measure [DEBUG] 2016 - 08 - 29 17 : 50 : 09 :==> Parameters: [DEBUG] 2016 - 08 - 29 17 : 50 : 10 :<== Columns: code, name [DEBUG] 2016 - 08 - 29 17 : 50 : 10 :<== Row: one, 地面冲洗 [DEBUG] 2016 - 08 - 29 17 : 50 : 10 :<== Row: two, 边界围挡 [DEBUG] 2016 - 08 - 29 17 : 50 : 10 :<== Row: three, 垃圾覆盖 [DEBUG] 2016 - 08 - 29 17 : 50 : 10 :<== Row: four, 裸地覆盖 [DEBUG] 2016 - 08 - 29 17 : 50 : 10 :<== Row: five, 洒水降尘 [DEBUG] 2016 - 08 - 29 17 : 50 : 10 :<== Row: six, 车辆冲洗 [DEBUG] 2016 - 08 - 29 17 : 50 : 10 :<== Row: seven, 建筑渣土 [DEBUG] 2016 - 08 - 29 17 : 50 : 10 :<== Row: eight, 车辆冒装 [DEBUG] 2016 - 08 - 29 17 : 50 : 10 :<== Row: nine, 扬尘覆盖 [DEBUG] 2016 - 08 - 29 17 : 50 : 10 :<== Row: ten, 车辆撒漏 [DEBUG] 2016 - 08 - 29 17 : 50 : 10 :<== Row: eleven, 车辆黑烟 [DEBUG] 2016 - 08 - 29 17 : 50 : 10 :<== Row: twelve, 道路积尘<br> |
1
2
3
4
5
6
7
8
9
10
11
12
13
|
[{ "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语句中的列名使用大写会怎样呢?自己测试一下吧!如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对服务器之家网站的支持!