PDF con BD MySQL

<%@page import="java.servlet.*,
        javax.servlet.http.*,
        java.io.*,
        java.util.*,
        com.itextpdf.text.pdf.*,
        com.itextpdf.text.*,java.sql.*"
%>

<%
response.setContentType("application/pdf");
Document document = new Document();
try{
    ByteArrayOutputStream buffer = new ByteArrayOutputStream();
    PdfWriter.getInstance(document, buffer);
    document.open();
       PdfPTable table=new PdfPTable(2);
       table.addCell("First Name");
       table.addCell("Last Name");
       Class.forName("com.mysql.jdbc.Driver");
       Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/trydb", "root", "root");
       Statement st=con.createStatement();
       ResultSet rs=st.executeQuery("Select * from trytable");
       while(rs.next()){

       table.addCell(rs.getString("fname"));
       table.addCell(rs.getString("lname"));
       }

    document.add(table);   
    document.close();

    DataOutput dataOutput = new DataOutputStream(response.getOutputStream());
    byte[] bytes = buffer.toByteArray();
    response.setContentLength(bytes.length);
    for(int i = 0; i < bytes.length; i++)
    {
        dataOutput.writeByte(bytes[i]);
    }

}catch(DocumentException e){
    e.printStackTrace();
}

%>

/* Database : trydb 

create table trytable (fname varchar(10), lname varchar(10));  */

-------------------------------------------------------------

Dando formato:

http://shashikantvaidyamydiscovery.blogspot.mx/2012/11/how-to-create-simple-report-in-jsp-with.html

Todo en clases:
http://gonzasilve.wordpress.com/2011/04/10/como-generar-un-pdf-con-datos-de-una-tabla-mysql-con-ayuda-de-itext-2/