private String toImportExcel() {
DistrictDao districtDao = new DistrictDao();
List list = null;
try {
list = districtDao.loadAll();
} catch (RuntimeException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
districtDao.close();
}
request.setAttribute("list", list);
return "/config/macconfig/importexcel.jsp";
}
/**
* 查询所有的方法
*
* @return
*/
private String list() {
String where = getWhere();
String jsp = "/config/macconfig/list.jsp";
MacconfigDao dao = new MacconfigDao();
setTarget(jsp);
list(dao, where);
DistrictDao districtDao = new DistrictDao();
List districtList = null;
try {
districtList = districtDao.loadAll();
} catch (RuntimeException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
districtDao.close();
Hashtable hashtable = new Hashtable();
List list = (List) request.getAttribute("list");
if (list != null && list.size() > 0) {
for (int i = 0; i < list.size(); i++) {
Macconfig macconfig = (Macconfig) list.get(i);
if (districtList != null && districtList.size() > 0) {
for (int j = 0; j < districtList.size(); j++) {
DistrictConfig districtConfig = (DistrictConfig) districtList.get(j);
if (macconfig.getDiscrictid() == districtConfig.getId()) {
hashtable.put(macconfig.getId(), districtConfig);
}
}
}
}
}
request.setAttribute("hashtable", hashtable);
request.setAttribute("districtList", districtList);
return jsp;
}