exportexcel.jsp

java开发的办公系统 1.系统管理 (地区管理,部门管理,菜单管理,用户管理,角色管理,权限) 2.工作流管理 (流程类别,流程) 3.字典管理 (国家,省份,城市,公共数据字典) 4.项目

<%@ include file="../../include/configuration.jsp"%>
<%@ include file="../../include/authorizemanager.jsp"%>
<%@ page import="com.vere.form.item.*"%>
<%@ page import="com.vere.form.bean.*"%>
<%@ page contentType="text/html; charset=gb2312" %>
<%
	ParameterUtils.setCharacterEncoding(request);
	String status=ParameterUtils.getString(request,"status");
	SessionFactory sessionFactory=(SessionFactory)session.getAttribute("sessionFactory");
	Form_columnBean form_columnBean=new Form_columnBean();
	List listColumn=form_columnBean.findD_Column(sessionFactory.getForm_table_id());
	Form_dictionaryBean form_dictionaryBean=new Form_dictionaryBean();
	Form_tableBean form_tableBean=new Form_tableBean();
	
	String message="";

		ArrayList fieldList=new ArrayList();
		//权限字段
		Form_columnItem fieldItem=new Form_columnItem();
		
		
		for(int i=0;i<listColumn.size();i++)
		{
			Form_columnItem form_columnItem=(Form_columnItem)listColumn.get(i);
			fieldItem=new Form_columnItem();
			fieldItem.setField_english_name(form_columnItem.getField_english_name());
			fieldItem.setField_value(ParameterUtils.getString(request,form_columnItem.getField_english_name()));
			fieldItem.setField_value_min(ParameterUtils.getString(request,form_columnItem.getField_english_name()+"_min"));
			fieldItem.setField_value_max(ParameterUtils.getString(request,form_columnItem.getField_english_name()+"_max"));
			fieldItem.setField_value_type(ParameterUtils.getString(request,form_columnItem.getField_english_name()+"_type"));
			fieldItem.setField_sign(ParameterUtils.getString(request,form_columnItem.getField_english_name()+"_sign"));
			fieldItem.setField_sign_min(ParameterUtils.getString(request,form_columnItem.getField_english_name()+"_sign_min"));
			fieldItem.setField_sign_max(ParameterUtils.getString(request,form_columnItem.getField_english_name()+"_sign_max"));
			fieldItem.setField_type(form_columnItem.getField_type());
			fieldItem.setCom_type(form_columnItem.getCom_type());
			fieldList.add(fieldItem);
		}
		List list=form_columnBean.export(sessionFactory.getForm_table_id(),fieldList);
		//ArrayList listColumn=(ArrayList)list.get(0);//列
		ArrayList tablesList=(ArrayList)list.get(1);//表
		String table_chinese_name=list.get(2).toString();//表中文名
		String FileName=table_chinese_name+".xls";//导出csv文件名
		
		response.reset(); // Reset the response
		response.setContentType("application/octet-stream;charset=GB2312"); // the encoding of this example is GB2312 
		response.setHeader("Content-Disposition","attachment; filename=\"" + FileName + "\"");
		response.addHeader("progma","no-cache");
		response.addHeader("Expires","0");
%>
<%
										StringBuffer exportBuffer=new StringBuffer();
										//头部标题
										exportBuffer.append("编号");
										for(int i=0;i<listColumn.size();i++)
										{
											Form_columnItem item=(Form_columnItem)listColumn.get(i);
											exportBuffer.append("\t"+item.getField_chinese_name());
										}
										exportBuffer.append("\n");
										//数据
										for(int i=0;i<tablesList.size()-1;i++)
										{
											ArrayList rowList=(ArrayList)tablesList.get(i);//行
											exportBuffer.append((i+1));
											for(int j=0;j<rowList.size();j++)
											{
												if(j!=0)
												{
													Form_columnItem item=(Form_columnItem)listColumn.get(j-1);//j-1 多了id字段
													exportBuffer.append("\t"+rowList.get(j));
												}
											}
											exportBuffer.append("\n");
										}
										out.write(exportBuffer.toString().trim());
%>