Meaningless Drivel is fun!*
The moose likes JSP and the fly likes write pdf files whith servlets Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Java » JSP
Reply locked New topic
Author

write pdf files whith servlets

bruno martins
Greenhorn

Joined: Oct 28, 2003
Posts: 8
hi, i can�t display my pdf file whith this code:
import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.lang.*;
import java.sql.*;
public class testepdf extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {


String driver = "org.gjt.mm.mysql.Driver";
String url = "jdbc:mysql://sb/cmv?user=amd&&password=123";
String n1_ = "";


Connection con1;
Statement sta1;

String sql1 = "SELECT * FROM files";
PrintWriter out = response.getWriter();
response.setContentType("application/pdf");



try {
Class.forName(driver);
con1=DriverManager.getConnection(url);
sta1 = con1.createStatement();

ResultSet rs = sta1.executeQuery(sql1);

response.setHeader("Content-disposition",
"inline; filename=\"Acta.pdf\"");

rs.next();

Blob blob = rs.getBlob(3);

if (blob != null)
{
int iLen = (int)blob.length();
response.setContentLength(iLen);
ByteArrayOutputStream output = new ByteArrayOutputStream(iLen);
output.write(blob.getBytes(1, iLen), 0, iLen);
out.write(output.toString());

}

rs.close();
sta1.close();
con1.close();

}
catch(java.lang.ClassNotFoundException e) {
out.println("ERRO na ClassNotFound: " + e.getMessage());
return;
}

catch(SQLException ex) {
out.println("ERRO na ligacao :" + ex.getMessage());
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request, response);
}
}
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30085
    
149

So you are trying to display the first file in the datbase (even if the query returns more than one) and the file is in the third column in PDF format?
What error are you getting?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60774
    
  65

bruno, please do not cross-post the same question in multiple forums. Please continue any discussion here,
bear


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
 
Consider Paul's rocket mass heater.
 
subject: write pdf files whith servlets
 
Similar Threads
GET Method Working But POST is not
sql error
Accessing method of one application from another
write pdf files whith servlets
Exception while EJB deployement