mybatis返回map键值对_MyBatis 返回Map<String,Object>类型

SELECT t1.MEDICAL_ID AS medicalId,

ADDRESS AS address,

DATE_START AS dateStart,

DATE_END AS dateEnd,

TIME_START AS timeStart,

TIME_END AS timeEnd,

AMBULANCE_NUM AS ambulanceNum,

NAME AS name,

PHONE AS phone

FROM PM.T_MEETING_MEDICAL t1,PM.T_MEETING_MEDICAL_DOCTOR t2

t1.MEDICAL_ID = t2.MEDICAL_ID

AND ADDRESS = #{address}

AND DATE_START = #{dateStart}

AND DATE_END = #{dateEnd}

AND MEETING_ID = #{meetingId}

ORDER BY t1.ADDRESS,t1.DATE_START

public List> exportAll(MeetingMedicalVo meetingMedicalVo);

//接口

//这个摘自http://www.cnblogs.com/TheoryDance/p/5818977.html

MyBatis返回Map键值对数据

List> getMtypeList();

select code,`name` from jk_control_measure

复制代码

[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, 道路积尘

复制代码

复制代码

[

{"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语句中的列名使用大写会怎样呢？自己测试一下吧！

时间： 07-01