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;