查询结果用Object数组接收并返回前端获取和展示,很多时候是封装的方法直接用实体类接收和返回,当所查询出的值包含不只一个实体类的属性值时,返回某个实体类不满足要求,或者不需要此实体类属性太多,返回整个实体类效率太低,这时用Object[]接收最莱斯:
String codename = receiveData.getParam("codename".toUpperCase()); String sql = "select itemvalue,itemtext from code_items where codeid = (select codeid from code_main where codename = '"; sql += codename; sql += "') order by itemvalue"; List<Object[]> objlist = service.getResultListNative(sql); List<JSONObject> list =