mybatis的sql语句理解

返回类型为HashMap. 则select 后的字段为hashmap的key(起别名的，则别名为key.比如ZU_NAME22),hashmap的value值为select后字段查出来的字段对应表里的值。如下图的符合条件的值。

2.关于select语句起别名

1）u.NAME起别名ZU_NAME，查询结果的hashmap的key为别名ZU_NAME.

查询结果：返回List<HashMap<String, Object>>类型：[{FEN_PEI_STATE=已分配, ZU_NAME=clj摩卓租户, CREATE_TIME=2018-01-06 16:16:09.0, FEN_JI_HAO=8079},{FEN_PEI_STATE=已分配, ZU_NAME=1219摩卓租户2, CREATE_TIME=2017-11-01 00:00:00.0, FEN_JI_HAO=8076}]

2）u.NAME不起别名，查询结果的hashmap的key为NAME

查询结果：返回List<HashMap<String, Object>>类型：[{FEN_PEI_STATE=已分配, CREATE_TIME=2018-01-06 16:16:09.0, FEN_JI_HAO=8079, NAME=clj摩卓租户}, {FEN_PEI_STATE=已分配, CREATE_TIME=2017-12-13 14:15:57.0, FEN_JI_HAO=8078, NAME=clj摩卓租户}, {FEN_PEI_STATE=已分配, CREATE_TIME=2017-11-29 18:34:42.0, FEN_JI_HAO=8082, NAME=clj摩卓租户}, {CREATE_TIME=2017-11-02 00:00:00.0, FEN_JI_HAO=8077, NAME=1219摩卓租户2}, {FEN_PEI_STATE=已分配, CREATE_TIME=2017-11-01 00:00:00.0, FEN_JI_HAO=8076, NAME=1219摩卓租户2}]

3）case **  when ** then ** end 语法起别名和不起别名结果。建议这种一定要起别名 

case f.FEN_PEI_STATE 起别名FEN_PEI_STATE，则查询结果的hashmap的key为FEN_PEI_STATE

查询结果：返回List<HashMap<String, Object>>类型：[{FEN_PEI_STATE=已分配, CREATE_TIME=2018-01-06 16:16:09.0, FEN_JI_HAO=8079, NAME=clj摩卓租户}, {FEN_PEI_STATE=已分配, CREATE_TIME=2017-12-13 14:15:57.0, FEN_JI_HAO=8078, NAME=clj摩卓租户}, {FEN_PEI_STATE=已分配, CREATE_TIME=2017-11-29 18:34:42.0, FEN_JI_HAO=8082, NAME=clj摩卓租户}, {CREATE_TIME=2017-11-02 00:00:00.0, FEN_JI_HAO=8077, NAME=1219摩卓租户2}, {FEN_PEI_STATE=已分配, CREATE_TIME=2017-11-01 00:00:00.0, FEN_JI_HAO=8076, NAME=1219摩卓租户2}]

4）case **  when ** then ** end 语法不起别名

查询结果：返回List<HashMap<String, Object>>类型：[{case f={FEN_PEI_STATE when 0 then
"未分配" when 1 then "已分配" end=已分配}, CREATE_TIME=2018-01-06 16:16:09.0, FEN_JI_HAO=8079, NAME=clj摩卓租户}, {case f={FEN_PEI_STATE when 0 then
"未分配" when 1 then "已分配" end=已分配}, CREATE_TIME=2017-12-13 14:15:57.0, FEN_JI_HAO=8078, NAME=clj摩卓租户}, {case f={FEN_PEI_STATE when 0 then
"未分配" when 1 then "已分配" end=已分配}, CREATE_TIME=2017-11-29 18:34:42.0, FEN_JI_HAO=8082, NAME=clj摩卓租户}, {CREATE_TIME=2017-11-02 00:00:00.0, FEN_JI_HAO=8077, NAME=1219摩卓租户2}, {case f={FEN_PEI_STATE when 0 then

"未分配" when 1 then "已分配" end=已分配}, CREATE_TIME=2017-11-01 00:00:00.0, FEN_JI_HAO=8076, NAME=1219摩卓租户2}]

区别：

起别名：[{FEN_PEI_STATE=已分配, CREATE_TIME=2018-01-06 16:16:09.0, FEN_JI_HAO=8079, NAME=clj摩卓租户}]

不起别名：[{case f={FEN_PEI_STATE when 0 then "未分配" when 1 then "已分配" end=已分配}, CREATE_TIME=2018-01-06 16:16:09.0, FEN_JI_HAO=8079, NAME=clj摩卓租户}]