返回类型为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摩卓租户}]