public List
List
sql = "select * from category ";
if (strWhere != "") {
sql += " where " + strWhere;
}
sql += " order by id Desc ";
Result res = bd.getResultSet(sql, paramsList);
if (res != null && res.getRowCount() > 0) {// 存在数据
list = new ArrayList
for (int i = 0; i < res.getRowCount(); i++) {
// Result的每一行数据以key—value的形式保存(即Map)
Map row = res.getRows()[i];
category model = new category();
model.setid((Integer) row.get("id"));
model.setname((String) row.get("name"));
model.setparentId((Integer) row.get("parentId"));
model.setremark((String) row.get("remark"));
list.add(model);
}
}
return list;
}