导出Ecxl-CSDN博客

本文链接：https://blog.csdn.net/liu_zhongjie/article/details/3979051

<%@ page language="java" pageEncoding="UTF-8"%>
<%@page import="java.util.ArrayList"%>
<%@ taglib uri="http://struts.apache.org/tags-bean" prefix="bean"%>
<%@ taglib uri="http://struts.apache.org/tags-html" prefix="html"%>
<%@ page import="com.yourcompany.struts.action.*"%>
<%@ page import="com.admin.dao.*"%>
<%@ page import="com.admin.daoimple.*"%>
<%@ page import="com.admin.Factory.*"%>
<%@ page import="com.admin.bean.*"%>
<%@ page import="java.util.ArrayList"%>
<%

    User_Manager_DAO pimd= AdminFactory.getUserManagerDAO();

     ArrayList<fnbl_user_bean> list=pimd.getuserlist();
     Time_Num_Bean tnb=pimd.get_user_num();
    int num=0;
%>

<html>
<head>

<style type="text/css">

</style>
<SCRIPT language=javascript src="Images/MyScript.js" type=text/javascript></SCRIPT>
<link rel="stylesheet" href="Images/mycss.css" type="text/css" />
<title>用戶帳號管理</title>

</head>
<body>
<html:form action="/user_show">

   <%
    try{
        response.setContentType("Application/msexcel");
        response.setHeader("Content-Disposition","attachment;filename=trainlist.xls");
        StringBuffer cont=new StringBuffer("");

    cont.append("<html><head><META content=/'text/html; charset=utf-8/' http-equiv=Content-Type></head><body>/r/n");
    cont.append("<table width='80%' border='1'>/r/n");
    cont.append("<tr>/r/n");
    cont.append("<td width='20%' height='19'>用戶名稱</td>/r/n");
    cont.append("<td width='20%' height='19'>所屬網站</td>/r/n");
    cont.append("<td width='20%' height='19'>最後同步時間</td>/r/n");
    cont.append("<td width='20%' height='19'>注冊時間</td>/r/n");
    cont.append("</tr>/r/n");

for(int i=0 ; i<list.size() ; i++){
   fnbl_user_bean fub=list.get(i);

    cont.append("<tr>/r/n");
    cont.append("<td width='20%' height='19'>"+fub.getUSERNAME() +" </td>/r/n");
    cont.append("<td width='20%' height='19'>"+fub.getUrl()       +" </td>/r/n");
    cont.append("<td width='20%' height='19'>"+fub.getTime()   +" </td>/r/n");
    cont.append("<td width='20%' height='19'>"+fub.getLAST_NAME() +" </td>/r/n");
    cont.append("</tr>/r/n");

}

    cont.append("</table>/r/n");
    cont.append("</body></html>/r/n");

    response.getWriter().println(cont.toString());
    response.getWriter().close();

    }catch(Exception e){
    out.println(e.toString());
    }
    %>

</html:form>
</body>
</html>