java 数据库到excel_java从数据库中将数据导入到excel中

(www.aimeiba.org/blog韩威编辑)在看之前，需要准备jxl.jar,   mysql 的驱动包， log4j的jar包

sql.properties  将此文件放入src目录下

select.excel=select * from employee   是sql.properties文件中的内容

开始正文

index.jsp

response.setContentType("text/html");

response.setCharacterEncoding("utf-8");

List list =ImportExcel.getList("select.excel"); //从数据库得到数据

OutputStream os = response.getOutputStream();//取出输出流

response.reset(); //空输出流

response.setHeader("Content-disposition","attachment; filename=fine.xls");//设定输出文件头

response.setContentType("application/msexcel");//定义输出类型

WritableWorkbook wbook = Workbook.createWorkbook(os);//建立excel文件

String title="报表";

WritableSheet  wsheet =wbook.createSheet(title,0) ;//sheet名称

//设置excel标题

WritableFont font = new WritableFont(WritableFont.ARIAL, 16,WritableFont.BOLD,

false,UnderlineStyle.NO_UNDERLINE,jxl.write.Colour.BLACK);

WritableCellFormat wcfFC = new WritableCellFormat(font);

try {

wcfFC.setBackground(jxl.write.Colour.AQUA);

wsheet.addCell(new Label(1,0,title,wcfFC));

font = new

WritableFont(WritableFont.ARIAL,14,WritableFont.BOLD,false,UnderlineStyle.NO_UNDERLINE,jxl.write.Colour.BLACK);

wcfFC = new WritableCellFormat(font);

//开始生成主体内容

String sheetTitle[] = new String[]{"员工编号","员工姓名","员工所在部门","员工性别","员工职位"};

for(int j=0;j

wsheet.addCell(new Label(j,0,sheetTitle[j]));

}

for(int i=0;i

Employee employee = (Employee)list.get(i);

wsheet.addCell(new Label(0,i+1,employee.getEmployeeId()+""));//员工编号

wsheet.addCell(new Label(1,i+1,employee.getEmployeeName()));//员工姓名

wsheet.addCell(new Label(2,i+1,employee.getEmployeeDepartment()));//员工所在部门

wsheet.addCell(new Label(3,i+1,employee.getEmployeeSex()));//员工性别

wsheet.addCell(new Label(4,i+1,employee.getEmployeePosition()));//员工职位

}

wbook.write();//写