jxcell
response.setContentType("text/html; charset=utf-8");View m_view = new View();
m_view.read(getServletContext().getRealPath("/modelFiles") + "/examineeinfo.xls");
List ExamineeTypeList = examineeFacade.selectExamineeTypeAll();
for (int j = 0; j < ExamineeTypeList.size(); j++) {
TceExaminees examineeType = (TceExaminees) ExamineeTypeList.get(j);
m_view.setText(0, 5 + j, examineeType.getExamineesTypeName());
}
List remarkList = examineeFacade.selectRemark();
for (int i = 0; i < remarkList.size(); i++) {
TceExaminees remarkTceExaminees = (TceExaminees) remarkList.get(i);
m_view.setText(0, 5 + i + ExamineeTypeList.size(), remarkTceExaminees.getRemarkName());
}
List contactList = examineeFacade.selectContact();
for (int k = 0; k < contactList.size(); k++) {
TceExaminees contactTceExaminees = (TceExaminees) contactList.get(k);
m_view.setText(0, 5 + k + remarkList.size() + ExamineeTypeList.size(), contactTceExaminees.getContactContent());
}
UserInfoVO userInfoVO = (UserInfoVO) session.getAttribute("userInfoVO");
tceExaminees.setDeptId(userInfoVO.getDeptId());
examineeListForPrint = examineeFacade.selectAllExamineeForPrint(tceExaminees);
for (int i = 0; i < examineeListForPrint.size(); i++) {
TceExaminees tceExaminee = (TceExaminees) examineeListForPrint.get(i);
TceExaminees tceExamineesId = new TceExaminees();
tceExamineesId.setId(tceExaminee.getId());
m_view.setText(i + 1, 0, tceExaminee.getName());
if ("0".equals(tceExaminee.getSex())) {
m_view.setText(i + 1, 1, "男");
} else {
m_view.setText(i + 1, 1, "女");
}
m_view.setText(i + 1, 2, tceExaminee.getBirth());
m_view.setText(i + 1, 3, tceExaminee.getUnitFirst() + " " + tceExaminee.getUnitSecond() + " " + tceExaminee.getUnit());
if ("0".equals(tceExaminee.getChecked())) {
m_view.setText(i + 1, 4, "未审核");
} else {
m_view.setText(i + 1, 4, "审核");
}
List oneExamineeTypeForIdList = examineeFacade.selectOneExamineeTypeForId(tceExamineesId);
for (int j = 0; j < ExamineeTypeList.size(); j++) {
TceExaminees examineeType = (TceExaminees) ExamineeTypeList.get(j);
String examineeId = examineeType.getExamineesTypeId();
String str = "";
for (int a = 0; a < oneExamineeTypeForIdList.size(); a++) {
TceExaminees examineeTypeValues = (TceExaminees) oneExamineeTypeForIdList.get(a);
if (examineeId.equals(examineeTypeValues.getExamineesTypeId())) {
str = tceExaminee.getIdentityId();
}
m_view.setText(i + 1, 5 + j, str);
}
}
List remarkListById = examineeFacade.selectRemarkById(tceExamineesId);
for (int j = 0; j < remarkList.size(); j++) {
TceExaminees remarkTceExaminees = (TceExaminees) remarkList.get(j);
String remarkId = remarkTceExaminees.getRemarkId();
String str = "";
for (int k = 0; k < remarkListById.size(); k++) {
TceExaminees remarkValuesExaminees = (TceExaminees) remarkListById.get(k);
if (remarkId.equals(remarkValuesExaminees.getRemarkId())) {
str = str + " " + remarkValuesExaminees.getRemark();
}
}
m_view.setText(i + 1, 5 + j + ExamineeTypeList.size(), str);
}
List contactListById = examineeFacade.selectContactById(tceExamineesId);
for (int j = 0; j < contactList.size(); j++) {
TceExaminees contactTceExaminees = (TceExaminees) contactList.get(j);
String contactId = contactTceExaminees.getContentId();
String str = "";
for (int k = 0; k < contactListById.size(); k++) {
TceExaminees contactValuesExaminees = (TceExaminees) contactListById.get(k);
if (contactId.equals(contactValuesExaminees.getContentId())) {
str = str + " " + contactValuesExaminees.getContent();
}
}
m_view.setText(i + 1, 5 + j + remarkList.size() + ExamineeTypeList.size(), str);
}
}
ServletOutputStream os = null;
try {
String fname = "考生信息";
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-disposition", "inline; filename=" + NormalizeUtil.toUtf8String(fname + ".xls"));
os = response.getOutputStream();
m_view.write(os, View.eFileExcel);
os.flush();
} catch (IOException e) {
e.printStackTrace();
throw e;
} finally {
if (os != null) os.close();
}
return null;
页:
[1]