今天才发现oracle中通过查询过程使用的别名是否使用双引号引起来的区别。
第一种:
SELECT t.XNXQ_ID as "semesterId", t.XNXQ as "semester", t.XN as "semesterYear"
FROM T_SJZY_XNXQXX t
ORDER BY t.XNXQ ASC
上面是有引号的情况下通过接口请求到的结果是对象的属性是小写字母:
{"code":200,"data":[{"semester":"2017-2018-1","semesterId":"1039820725681954816","semesterYear":"2017-2018"},{"semester":"2017-2018-2","semesterId":"1039820823275020288","semesterYear":"2017-2018"}]}
第二种情况:
SELECT t.XNXQ_ID as semesterId, t.XNXQ as semester, t.XN as semesterYear
FROM T_SJZY_XNXQXX t
ORDER BY t.XNXQ ASC
没有引号的情况下通过请求到的结果是对象的属性是大写字母:
{"code":200,"data":[{"SEMETER":"2017-2018-1","SEMETERID":"1039820725681954816","SEMESTERYEAR":"2017-2018"},{"SEMETER":"2017-2018-2","SEMETERID":"1039820823275020288","SEMESTERYEAR":"2017-2018"}]}