源代码:service实现类:
String select_sql = "select cguid,(case isrz when 1 then 'PASS' when 0 then 'FAIL' end) as smrzzt from t_jb_user where mobile=?";
List<Map<String,Object>> list = ydbsDaoI.findList(select_sql, new Object[]{phoneno});//将查询得到的结果取出
String cguid = list.get(0).get("cguid")==null?"":list.get(0).get("cguid").toString();
String smrzzt = list.get(0).get("smrzzt