|
楼主 |
发表于 2018-8-14 10:34:26
|
显示全部楼层
list为非空判断过了,还是报同样的错。- public static List<List<String>> personFn(String XJYWH) {
- try {
- String sql = "Select a.PERSONID from SPQKB a where a.YWH ='" + XJYWH + "' ";
- System.out.println(sql);
- Table table = SQL.select(sql, null, "/app/business/oa/holidayManager/backleave/data", null);
- Iterator<Row> rows = table.iterator();
- List<List<String>> list1 = new ArrayList<List<String>>();
- while (rows.hasNext()) {
- Row row = rows.next();
- List<String> list2 = new ArrayList<String>();
- if(row.getString("PERSONID")!=""){
- list2.add(row.getString("PERSONID"));
- }
- if(list2.size()>=1 && list2.toString()!= ""){
- list1.add(list2);
- }
- };
- return list1;
- } catch (Exception e) {
- e.printStackTrace();
- return null;
- };
- }
复制代码 |
|