【Java】通过JSONObject获取数据库查询结果

DB操作

public List QueryLoginYHXX(String yhzh) {List listYHXX = null;String sql = "SELECT * FROM YHZH LEFT JOIN JGYHXX ON YHZH.YHBH = JGYHXX.YHBH LEFT JOIN JGBM ON JGBM.JGBM = JGYHXX.JGBM WHERE YHZH = '"+yhzh+"'";System.out.println(sql);try {listYHXX = conn.queryForList(sql);} catch (DataAccessException e) {// TODO Auto-generated catch blocke.printStackTrace();}return listYHXX;}

调用查询语句，通过JSONObject获取某一字段的值

//根据用户账号获取用户姓名，角色，所属部门等信息List YHXX = dao1.QueryLoginYHXX(userName);JSONArray jsonArray = JSONArray.fromObject(YHXX);System.out.println(jsonArray.toString());JSONObject object = (JSONObject)jsonArray.opt(0);String userYHXM = object.getString("XM");String userBMMC = object.getString("JGMC");String userBMBH = object.getString("JGBM");