java导入导出pdf文档实践

1:mysql数据库存储pdf流字段为:filed name:filestream type:MEDIUMBLOB

2:导入pdf文件到mysql 数据库

private void doWrite() ... {
try...{

if(newFile("D:/Sun.pdf").exists())...{
FileInputStreamfis=newFileInputStream(newFile(
"D:/Sun.pdf"));
PreparedStatementpstmt=cnn
.prepareStatement("insertintotb(filestream)values(?)");
pstmt.setBinaryStream(1,fis,1024);
pstmt.execute();
}
}catch(Exceptione)...{
e.printStackTrace();
}
}

3:从mysql数据库读取pdf流到网页客户端显示

private void doRead(HttpServletRequestrequest,HttpServletResponseresponse) ... {
try...{
ByteArrayOutputStreamba=newByteArrayOutputStream();
Statementstmt=cnn.createStatement();
ResultSetrs=stmt.executeQuery("selectfilestreamfromtbwhereid=1");
rs.next();
InputStreamis=rs.getBinaryStream(1);
intc;
while((c=is.read())!=-1)
ba.write(c);
Documentdocument=newDocument(PageSize.A4,36,36,36,36);
PdfWriterwriter=PdfWriter.getInstance(document,ba);
//document.close();
response.setContentType("application/pdf");
response.setContentLength(ba.size());
ServletOutputStreamout=response.getOutputStream();
ba.writeTo(out);
out.flush();
}catch(Exceptione)...{
e.printStackTrace();
}
}

4:下载jar包：itext-2.0.6.jar iTextAsian.jar(此包是解决中文乱码用)

5:完整源码

import java.io.BufferedInputStream;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.lowagie.text.Document;
import com.lowagie.text.DocumentException;
import com.lowagie.text.PageSize;
import com.lowagie.text.Paragraph;
import com.lowagie.text.pdf.PdfWriter;

public class PDFGenerateServlet extends HttpServlet ... {
privateConnectioncnn=null;

publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)
throwsIOException,ServletException...{

try...{
InitConnection();
Strings=request.getParameter("method");
if(s.equals("w"))...{
doWrite();
}
if(s.equals("r"))...{
doRead(request,response);
}
/**//*
*Statementstmt=cnn.createStatement();ResultSetrs=
*stmt.executeQuery("");InputStreamis=rs.getBinaryStream("");
*intc;while((c=is.read())!=1)ba.write(c);//ba=new
*ByteArrayOutputStream(rs.getBlob(""));PdfWriterwriter=
*PdfWriter.getInstance(document,ba);document.open();
*document.add(newParagraph("HelloWorld"));
*/

}catch(Exceptione)...{

}

}

publicvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)
throwsIOException,ServletException...{
doGet(request,response);
}

privatevoiddoWrite()...{
try...{

if(newFile("D:/Sun.pdf").exists())...{
FileInputStreamfis=newFileInputStream(newFile(
"D:/Sun.pdf"));
PreparedStatementpstmt=cnn
.prepareStatement("insertintotb(filestream)values(?)");
pstmt.setBinaryStream(1,fis,1024);
pstmt.execute();
}
}catch(Exceptione)...{
e.printStackTrace();
}
}

privatevoiddoRead(HttpServletRequestrequest,HttpServletResponseresponse)...{
try...{
ByteArrayOutputStreamba=newByteArrayOutputStream();
Statementstmt=cnn.createStatement();
ResultSetrs=stmt.executeQuery("selectfilestreamfromtbwhereid=1");
rs.next();
InputStreamis=rs.getBinaryStream(1);
intc;
while((c=is.read())!=-1)
ba.write(c);
Documentdocument=newDocument(PageSize.A4,36,36,36,36);
PdfWriterwriter=PdfWriter.getInstance(document,ba);
//document.close();
response.setContentType("application/pdf");
response.setContentLength(ba.size());
ServletOutputStreamout=response.getOutputStream();
ba.writeTo(out);
out.flush();
}catch(Exceptione)...{
e.printStackTrace();
}
}

privatevoidInitConnection()...{
try...{
Class.forName("com.mysql.jdbc.Driver");
cnn=DriverManager.getConnection(
"jdbc:mysql://localhost:3306/jms","root","aastocks");

}catch(Exceptione)...{

}
}
}