国产亚洲中文在线字幕,亚洲日韩精品无码AV海量,666精品国产精品亚洲

自己封裝的poi,itext報表導出代碼

頁面代碼：

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<%@ page contentType="text/html; charset=utf-8" isELIgnored="false"%>

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>

String path = request.getContextPath();

<html>

<head>

function export_report(type,title){

var tableHeader="";

var tableBody="";

//獲取表格信息

$("#tableResult tr").each(function(i,_tr){

$(_tr).children().each(function(k,_td){

if(i==0){

tableHeader+=$.trim($(_td).text())+",";

}else{

tableBody+=$.trim($(_td).text())+"##";

}

});

if(i>0){

tableBody+="@@";

}

});

if(tableHeader==""){

alert("表頭未初始化！");

return false;

}

if(tableBody==""){

alert("表格體沒內容！");

return false;

}

$("#report_title").val(title);

$("#report_type").val(type);

$("#report_tableHeader").val(tableHeader);

$("#report_tableBody").val(tableBody);

$("#report_form").submit();

}

</script>

</head>

<body>

<c:if test="${list==null||empty list}" var="val">

<center><font color='red' size=3>對不起,沒有你要查詢的記錄!!!</font></center>

</c:if>

<c:if test="${!val}">

<thead>

<td height="28" align="center" class="td_LTBG">戶籍所在地</td>

<td height="28" align="center" class="td_LTBG">公民身份證號碼</td>

</tr>

</thead>

<c:forEach items="${list}" var="naturalPerson">

<tr>

</tr>

</c:forEach>

</table>

</div>

<tr>

<a id="expor_pdf" onclick="return export_report('pdf','自然人基本信息');" style="cursor: pointer;">導出PDF</a> |

<a id="expor_excel" onclick="return export_report('excel','自然人基本信息');" style="cursor: pointer;">導出Excel</a>

</span>

共<font color="red" size="2">${page.rowCounts}</font>條  

當前<font color="red" size="2">${page.currPageNum}</font>/<font color="red" size="2">${page.pageCount}</font>頁 

<c:if test="${page.currPageNum==1}">

</c:if>

<c:if test="${page.currPageNum!=1}">

</c:if>

<c:if test="${page.currPageNum>1}">

</c:if>

<c:if test="${page.currPageNum<=1}">上一頁</c:if> 

<c:if test="${page.currPageNum<page.pageCount}">

</c:if>

<c:if test="${page.currPageNum>=page.pageCount}">下一頁</c:if> 

<c:if test="${page.currPageNum==page.pageCount}">

</c:if>

<c:if test="${page.currPageNum!=page.pageCount}">

</c:if>

轉到 <select name="pageNum" id="pageNum" class="input_text_page_width" onchange="goPagesForSelect('naturalPerson','/naturalPersonAction',$('#pageNum')[0].value)">

<c:forEach var="varName" begin="1" end="${page.pageCount}" step="1">

<c:if test="${varName==page.currPageNum}">

<option value="${varName}" selected>${varName}</option>

</c:if>

<c:if test="${varName!=page.currPageNum}">

<option value="${varName}">${varName}</option>

</c:if>

</c:forEach>

</select>

</td>

</tr>

</table>

</c:if>

</form>

<form action="<%=path%>/exportServlet" method="post" id="report_form">

</form>

</body>

</html>

后臺代碼：

package com.future.util;

import java.awt.Color;

import java.io.BufferedInputStream;

import java.io.BufferedOutputStream;

import java.io.ByteArrayInputStream;

import java.io.ByteArrayOutputStream;

import java.io.IOException;

import java.io.InputStream;

import javax.servlet.ServletException;

import javax.servlet.ServletOutputStream;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

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 com.lowagie.text.Cell;

import com.lowagie.text.Document;

import com.lowagie.text.DocumentException;

import com.lowagie.text.Element;

import com.lowagie.text.Font;

import com.lowagie.text.HeaderFooter;

import com.lowagie.text.PageSize;

import com.lowagie.text.Paragraph;

import com.lowagie.text.Phrase;

import com.lowagie.text.Table;

import com.lowagie.text.pdf.BaseFont;

import com.lowagie.text.pdf.PdfWriter;

/**

* 功能描述:此servlet用于將當前頁面表格內容導出到pdf和excel<br>

* 參數說明:

* String type 為導出類型

* String title 報表中title

* String tableHeader 頁面中表格的表頭

* String tableBody 表格內容

* 注解:其中頁面數據是以特殊字符分隔傳遞過來的

* 逗號(,)用來連接表頭,后臺用逗號來解析頁面傳遞過來的表頭

* @@用來分隔一條數據,后臺用@@來解析每條數據

* ##用來分隔單元格,后臺用##來解析每條數據對應的單元格

* 創建時間:2010-07-01

* @author sxyx2008

* @version 1.0.0

@SuppressWarnings("serial")

public class ExportServlet extends HttpServlet {

@Override

protected void service(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

request.setCharacterEncoding("utf-8");

response.reset();

//導出類型

String type=request.getParameter("type");

//報表標題

String title=request.getParameter("title");

//表頭

String tableHeader=request.getParameter("tableHeader");

//表格內容

String tableBody=request.getParameter("tableBody");

//文件名

String fileName="";

if("pdf".equals(type)){

try {

exportToPdf(title,tableHeader,tableBody,response);

} catch (Exception e) {

e.printStackTrace();

}

}else if("excel".equals(type)){

fileName = new String(new String((title + ".xls").getBytes(),"ISO-8859-1"));

response.setContentType("application/vnd.ms-excel;charset=utf-8");

response.setHeader("Content-Disposition", "attachment;filename="+ fileName);

InputStream inputStream=exportToExcel(title, tableHeader,tableBody);

ServletOutputStream out = response.getOutputStream();

BufferedInputStream bis = null;

BufferedOutputStream bos = null;

try {

bis = new BufferedInputStream(inputStream);

bos = new BufferedOutputStream(out);

byte[] buff = new byte[2048];

int bytesRead;

while (-1 != (bytesRead = bis.read(buff, 0, buff.length))) {

bos.write(buff, 0, bytesRead);

}

} catch (final IOException e) {

throw e;

} finally {

if (bis != null)

bis.close();

if (bos != null)

bos.close();

}

/**

* 導出到excel表格

private InputStream exportToExcel(String title,String tableHeader,String tableBody) {

// 創建工作表

HSSFWorkbook wb = new HSSFWorkbook();

// 創建第一個工作區

HSSFSheet sheet = wb.createSheet(title);

// 創建標題行

HSSFRow row = sheet.createRow(0);

// 獲取表頭

String[] header = tableHeader.split(",");

// 分隔每一行記錄

String[] content = tableBody.split("@@");

// 創建表頭

HSSFCell cell = null;

for (int i = 0; i < header.length; i++) {

cell = row.createCell(i);

cell.setCellValue(header[i]);

}

//循環每條記錄

for (int i = 0; i < content.length; i++) {

row = sheet.createRow(i + 1);

//取出每個單元格的值

String[] value=content[i].split("##");

for (int j = 0; j < value.length; j++) {

cell = row.createCell(j);

cell.setCellValue(value[j]);

}

ByteArrayOutputStream os = new ByteArrayOutputStream();

try {

wb.write(os);

} catch (IOException e) {

e.printStackTrace();

}

byte[] contents = os.toByteArray();

InputStream is = new ByteArrayInputStream(contents);

return is;

}

/**

* 導出到pdf

private void exportToPdf(String title,String tableHeader,String tableBody,HttpServletResponse response) throws Exception{

Document doc=new Document(PageSize.A4,50,50,50,50);

ByteArrayOutputStream byteArrayOutputStream=new ByteArrayOutputStream();

PdfWriter writer=PdfWriter.getInstance(doc,byteArrayOutputStream);

doc.addCreationDate();

HeaderFooter footer=new HeaderFooter(new Phrase(), true);

//設置頁腳是否有邊框

//0表示無

//1上邊框

//2下邊框

//3上下邊框都有默認都有

footer.setBorder(0);

//footer.setBorder(1);

//footer.setBorder(2);

//footer.setBorder(3);

footer.setAlignment(Element.ALIGN_CENTER);

doc.setFooter(footer);

doc.open();

// 獲取表頭

String[] header = tableHeader.split(",");

// 分隔每一行記錄

String[] content = tableBody.split("@@");

//根據傳遞進來的表頭創建pdf的表頭

Paragraph paragraph=new Paragraph(title,ChineseFont());

paragraph.setAlignment(Element.ALIGN_CENTER);

doc.add(paragraph);

Table table=new Table(header.length);

table.setWidth(100);

table.setBorder(1);

for (int i = 0; i < header.length; i++) {

Cell cell=new Cell(new Phrase(header[i],ChineseFont()));

cell.setHorizontalAlignment(Element.ALIGN_CENTER);

cell.setVerticalAlignment(Element.ALIGN_CENTER);

cell.setHeader(true);

cell.setBackgroundColor(new Color(231,231,231));

table.addCell(cell);

}

table.endHeaders();

//循環每條記錄

for (int i = 0; i < content.length; i++) {

Cell cell=null;

//取出每個單元格的值

String[] value=content[i].split("##");

for (int j = 0; j < value.length; j++) {

cell = new Cell(new Phrase(value[j],ChineseFont()));

cell.setHorizontalAlignment(Element.ALIGN_CENTER);

cell.setVerticalAlignment(Element.ALIGN_CENTER);

table.addCell(cell);

}

doc.add(table);

doc.close();

writer.close();

String fileName = new String(new String((title + ".pdf").getBytes(),"ISO-8859-1"));

response.setContentType("application/pdf;charset=utf-8");

response.setHeader("Content-Disposition", "attachment;filename="+ fileName);

ServletOutputStream outputStream=response.getOutputStream();

byteArrayOutputStream.writeTo(outputStream);

outputStream.flush();

outputStream.close();

}

/**

* pdf中文字體設置

* @return

public static Font ChineseFont()

{

BaseFont baseFont=null;

try {

baseFont=BaseFont.createFont("STSong-Light","UniGB-UCS2-H", true);

} catch (DocumentException e) {

e.printStackTrace();

} catch (IOException e) {

e.printStackTrace();

}

Font chineseFont=new Font(baseFont,8,Font.BOLD,Color.BLACK);

return chineseFont;

}

posted on 2010-07-01 18:07 雪山飛鵠閱讀(2385) 評論(0) 編輯收藏所屬分類: javase

新用戶注冊刷新評論列表


只有注冊用戶登錄后才能發表評論。




網站導航: 博客園 IT新聞 Chat2DB C++博客博問管理
相關文章: 使用Ant構建web項目從編譯到測試生成測試報告打包郵件發送遠程下載tomcat 部署運行一條龍服務之ant腳本 jboss上部署應用的一處錯誤 JBOSS只能用localhost或127.0.0.1訪問的解決辦法 Java之冒泡排序輕松使用xmlpull創建xml 輕松使用sax解析xml 輕松使用dom解析xml 輕松使用dom創建xml quartz cron expression HttpClient請求Https協議

雪山飛鵠

公告

常用鏈接

留言簿(18)

隨筆分類(222)

隨筆檔案(214)

文章檔案(1)

收藏夾(67)

我的鏈接

搜索

最新評論

閱讀排行榜

評論排行榜