package com.info.serviceimpl;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.util.Date;
import javax.imageio.stream.FileImageInputStream;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.struts2.ServletActionContext;
import com.info.model.Base;
import com.info.model.Education;
import com.info.model.Job;
import com.info.model.Other;
import com.info.model.Remark;
import com.info.service.BaseService;
import com.info.service.EducationService;
import com.info.service.GenerateExcelService;
import com.info.service.JobService;
import com.info.service.OtherService;
import com.info.service.RemarkService;
import com.info.util.DateTimeUtil;
public class GenerateExcelServiceImpl implements GenerateExcelService {
private BaseService baseService;
private EducationService educationService;
private JobService jobService;
private OtherService otherService;
private RemarkService remarkService;
private Base base;
private Education education;
private Job job;
private Other other;
private Remark remark;
public void setBaseService(BaseService baseService) {
this.baseService = baseService;
}
public void setEducationService(EducationService educationService) {
this.educationService = educationService;
}
public void setJobService(JobService jobService) {
this.jobService = jobService;
}
public void setOtherService(OtherService otherService) {
this.otherService = otherService;
}
public void setRemarkService(RemarkService remarkService) {
this.remarkService = remarkService;
}
public static String toUtf8String(String s) {
StringBuffer sb = new StringBuffer();
for (int i = 0; i < s.length(); i++) {
char c = s.charAt(i);
if (c >= 0 && c <= 255) {
sb.append(c);
} else {
byte[] b;
try {
b = Character.toString(c).getBytes("utf-8");
} catch (Exception ex) {
System.out.println(ex);
b = new byte[0];
}
for (int j = 0; j < b.length; j++) {
int k = b[j];
if (k < 0)
k += 256;
sb.append("%" + Integer.toHexString(k).toUpperCase());
}
}
}
return sb.toString();
}
public InputStream getInputStream(int id) {
DateTimeUtil dtu = new DateTimeUtil();
base = baseService.findBase(id);
education = educationService.findEdu(id);
job = jobService.findJob(id);
other = otherService.findOther(id);
remark = remarkService.findRemark(id);
System.out.println("base:" + base);
System.out.println("education:" + education);
System.out.println("job:" + job);
System.out.println("other:" + other);
System.out.println("remark:" + remark);
String sex = null;
String marry = null;
String retire = null;
if (base.getSex() == null) {
sex = "保密";
} else {
if (base.getSex() == 0) {
sex = "男";
} else {
sex = "女";
}
}
if (base.getMarry() == null) {
marry = "未知";
} else {
if (base.getMarry() == 0) {
marry = "已婚";
} else {
marry = "未婚";
}
}
if (job.getRetire() == null) {
retire = "未知";
} else {
if (job.getRetire() == 0) {
retire = "是";
} else {
retire = "否";
}
}
HSSFWorkbook hw = new HSSFWorkbook();
HSSFSheet sheet = hw.createSheet("sheet1");
HSSFRow row = sheet.createRow(0);
HSSFCell cell = row.createCell((short) 0);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue(this.toUtf8String("档案编号："));
cell = row.createCell((short) 1);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("姓名：");
cell = row.createCell((short) 2);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("曾用名：");
cell = row.createCell((short) 3);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("性别：");
cell = row.createCell((short) 4);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("婚否：");
cell = row.createCell((short) 5);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("出生日期：");
cell = row.createCell((short) 6);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("身份证号：");
cell = row.createCell((short) 7);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("民族：");
cell = row.createCell((short) 8);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("籍贯：");
cell = row.createCell((short) 9);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("现居地：");
cell = row.createCell((short) 10);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("加入组织时间：");
cell = row.createCell((short) 11);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("学历：");
cell = row.createCell((short) 12);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("毕业时间：");
cell = row.createCell((short) 13);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("毕业院校：");
cell = row.createCell((short) 14);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("学历：");
cell = row.createCell((short) 15);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("毕业时间：");
cell = row.createCell((short) 16);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("毕业院校：");
cell = row.createCell((short) 17);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("继续教育：");
cell = row.createCell((short) 18);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("退休");
cell = row.createCell((short) 19);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("编制：");
cell = row.createCell((short) 20);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("上岗时间：");
cell = row.createCell((short) 21);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("工龄：");
cell = row.createCell((short) 22);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("职称");
cell = row.createCell((short) 23);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("受职时间：");
cell = row.createCell((short) 24);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("奖励记录：");
cell = row.createCell((short) 25);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("发表论文：");
cell = row.createCell((short) 26);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("爱好");
cell = row.createCell((short) 27);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("备注：");
row = sheet.createRow(1);
cell = row.createCell((short) 0);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue(base.getArchiveId());
cell = row.createCell((short) 1);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue(base.getName());
cell = row.createCell((short) 2);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue(base.getOldname());
cell = row.createCell((short) 3);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue(sex);
cell = row.createCell((short) 4);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue(marry);
cell = row.createCell((short) 5);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue(dtu.convertToStr(base.getBirth()));
cell = row.createCell((short) 6);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue(base.getCardId());
cell = r
Struts2+Hiberntate+Spring档案管理系统,数据库和包完整 （300个子文件） 
GenerateExcelServiceImpl.class 11KB BaseAction.class 9KB AdminActioin.class 6KB Base.class 6KB PersonInfoAction.class 6KB Experience.class 5KB SearchAction.class 5KB BaseDaoImpl.class 4KB Society.class 4KB SearchDaoImpl$1find.class 4KB SearchDaoImpl$2find.class 4KB AdminDaoImpl.class 3KB Job.class 3KB SpeciaAction.class 3KB Education.class 3KB GenerateExcelAction.class 3KB DataAction.class 2KB RemarkAction.class 2KB EducationAction.class 2KB AdminServiceImpl.class 2KB BaseServiceImpl.class 2KB IPTimeStamp.class 2KB JobAction.class 2KB OtherAction.class 2KB BaseDao.class 2KB Other.class 2KB CodeServlet.class 2KB AdminDaoImpl$1findCallback.class 2KB BaseDaoImpl$1findCallback.class 1KB BackUtil.class 1KB Admin.class 1KB SearchDaoImpl.class 1KB Remark.class 1KB DataDaoImpl.class 1KB SearchServiceImpl.class 1KB ExperienceDaoImpl.class 1KB RemarkDaoImpl.class 1KB EducationDaoImpl.class 1KB SocietyDaoImpl.class 1KB OtherDaoImpl.class 1KB EducationServiceImpl.class 1KB DateTimeUtil.class 1KB JobDaoImpl.class 1KB ExperienceServiceImpl.class 1KB SocietyServiceImpl.class 989B RemarkServiceImpl.class 974B OtherServiceImpl.class 952B JobServiceImpl.class 938B AdminService.class 648B AdminDao.class 636B BaseService.class 467B BaseDao.class 459B SearchService.class 427B SearchDao.class 413B SocietyService.class 253B ExperienceService.class 252B EducationService.class 250B RemarkService.class 247B SocietyDao.class 241B ExperienceDao.class 241B EducationDao.class 238B RemarkDao.class 235B OtherService.class 234B OtherDao.class 222B JobService.class 222B JobDao.class 210B GenerateExcelService.class 190B DataDao.class 151B .classpath 7KB org.eclipse.wst.common.component 462B org.eclipse.wst.jsdt.ui.superType.container 49B main.css 3KB body.Fix 3KB Head.Fix 54B
ERROR.GIF 58KB admin_left_bg.gif 57KB login_bg2.gif 42KB login_botton.gif 4KB LOGO.GIF 3KB ico.gif 2KB loading.gif 2KB admin_top_menu_arr1.gif 2KB admin_top_menu_arr.gif 2KB admin_left_c_pic.gif 2KB admin_top_menu_r.gif 1KB admin_top_menu_l.gif 1KB login_bg0.gif 854B admin_left_menu.gif 780B side_3.gif 634B side_1.gif 633B icon_space.gif 596B td_bg.gif 580B login_ico.gif 554B admin_mid_ico_l.gif 402B admin_mid_ico_r.gif 402B admin_ico_enter.gif 353B reg_yesok.gif 345B index_icon_user_2.gif 342B admin_left_c_ico.gif 335B login_text.gif 270B共 300 条
- 1
- 2
- 3
资源评论
yongweb
- 粉丝: 33
- 资源: 163
最新资源
- 1Cr18Ni9Ti钢板焊接接头冷弯开裂的试验研究.pdf
- 1Cr18Ni9Ti钎焊接头组织和性能影响研究 - .pdf
- 2.25 Cr-1 Mo钢制加氢反应器的焊接裂纹（二）-对焊接裂纹性质的试验研究.pdf
- 1Crl8Ni9Ti不锈钢复合管系的焊接 - .pdf
- 2.25Cr-1Mo-0.25V低合金钢用焊接材料的检验 - .pdf
- 2.25-1Mo钢焊后产生焊接裂纹的原因分析及其返修措施.pdf
- 2.25 Cr-1 Mo钢制加氢反应器的焊接裂纹（一）-在制过程中出现的焊接裂纹.pdf
- 2.25Cr-1Mo-0.25V钢焊接材料的再热裂纹敏感性试验方法探讨.pdf
- 2A12厚板铝合金搅拌摩擦焊接头组织性能研究 - .pdf
- 2万立立式液氢高压容器的焊接研制.pdf
- 2A14铝合金法兰焊接裂纹修复.pdf
- 3.5%Ni钢焊接接头的低温韧性研究三──熔敷金属碳含量等因素的影响.pdf
- 3.5%Ni钢焊接技术的最近进展.pdf
- 3.5%Ni钢焊接接头低温韧性的研究二──焊后热处理母材及焊材的影响.pdf
- 3.5%Ni钢焊接接头低温韧性的研究一──线能量层间温度的影响.pdf
- 3.5Ni钢低温设备的制造和焊接.pdf
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
