sql += " where" + sqlWhere;
}
List<Map<String, Object>> mapList = findForJdbc(sql, dataGrid.getPage(), dataGrid.getRows());
List list = new ArrayList();
JeecgJdbcEntity obj = null;
for(Map<String,Object> m:mapList){
try {
obj = new JeecgJdbcEntity();
obj.setId((String)m.get("id"));
obj.setUserName((String)m.get("user_name"));
obj.setDepId((String)m.get("departname"));
String sex = (String)m.get("sex");
if (sex == null) {
obj.setSex("");
} else if (sex.equals("0")) {
obj.setSex("男");
} else {
obj.setSex("女");
}
obj.setAge((Integer)m.get("age"));
Date birthday = (Date)m.get("birthday");
if (birthday != null) {
obj.setBirthday(birthday);
}
obj.setEmail((String)m.get("email"));
obj.setMobilePhone((String)m.get("mobile_phone"));
list.add(obj);
} catch (Exception e) {
e.printStackTrace();
}
}