flex 下载Excel文件 fileReference.download 使用servlet
一、使用fileReference.download 下载Excel文件：
?（1）<s:Button label="匯出2" id="export2" click="download()"/>
?
?（2）private function download():void
???{
????var request:URLRequest = new URLRequest(
?????"http://localhost:8080/test/exportExcel?service=userService&method=exportUsers&args=-%2C2%2C-%2C-");???? //调用ｓｅｒｖｌｅｔ
????
????var fileReference:FileReference = new FileReference();
????fileReference.download(request, "excel.xls");
???}
?
?（3）
public class ExportExcelServlet extends HttpServlet {
?
?protected void doGet(HttpServletRequest request,
???HttpServletResponse response) {
??doPost(request, response);
?}
?protected void doPost(HttpServletRequest request,
???HttpServletResponse response) {
??
??String serviceName = request.getParameter("service");
??String methodName? = request.getParameter("method");
??String arg???????? = request.getParameter("args");
??String[] args = new String[0];
??if(null != arg && arg.length() > 0)
???args = arg.split(",");
??
??Object bean = ApplicationContextUtil.getBean(serviceName);
??ExportData data = null;
??try {
???data = (ExportData)invokeMethod(bean, methodName, Arrays.asList(args));
／／调用ｓｐｒｉｎｇ创建的ｂｅａｎ
??} catch (Exception e) {
???e.printStackTrace();
??}
??
??// 设置返回数据类型
??response.setContentType("application/vnd.ms-excel;charset=UTF-8");
??// 设置返回的文件名
??response.setHeader("Content-Disposition", "attachment;Filename="
????+ "data.xls");
??
??try {
???OutputStream os = response.getOutputStream();
???WritableWorkbook wb = Workbook.createWorkbook(os);
???wb = ExcelUtil.exportExcel(wb, data.getDataList(), data.getFields(), data.getFieldNames());
???wb.write();
???wb.close();
????} catch (IOException e) {
???e.printStackTrace();
??}
??
?}
?
?private Object invokeMethod(Object owner,String methodName,List args) throws Exception{
??
??Class ownerClass = owner.getClass();
??
??Class[] argsClass = new Class[args.size()];
??for(int i = 0; i < args.size(); i++){
???argsClass[i] = args.get(i).getClass();
??}
??
??Method method = ownerClass.getMethod(methodName, argsClass);
??return method.invoke(owner,args.toArray());
?}
?
（４）ｗｅｂ．ｘｍｌ：
?<!-- 数据导出 -->
??? <servlet>
??<servlet-name>ExportExcelServlet</servlet-name>
??<servlet-class>servlet.ExportExcelServlet</servlet-class>
?</servlet>
?
??? <servlet-mapping>?
??????? <servlet-name>ExportExcelServlet</servlet-name>?
??????? <url-pattern>/exportExcel</url-pattern>?
??? </servlet-mapping>
?
?
