File Upload And download JSP Urgent

View Answers

September 8, 2008 at 4:42 PM

Hi Ragavendran,

i am sending code of file download in jsp. Plz implement this code.

<%@ page import="java.sql.*,java.io.*,java.util.*" %>

<HTML>

<HEAD>

<TITLE>file download in jsp</TITLE>

</HEAD>

<BODY>

<br><br>

<table align="center" border="1" width="400px" cellspacing="0" cellpadding="0" bgcolor="bluelight">

<tr>

<td colspan=2 align="center"><font color="red"><b>File download</b></font></td>

</tr>

<tr><td colspan=2> </td></tr>

<%
Connection con = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String userName ="amar";
String password="amar123";

try{

Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,password);

Statement stmt=con.createStatement();

String strQuery = "select id from FileUpload";

ResultSet rs = stmt.executeQuery(strQuery);

int sno=0;

while(rs.next())

{

sno++;

%>

<tr>

<td><b><%=sno%></b></td>

<td align="center"><a href="fileShow.jsp?imgid=<%=rs.getString(1)%>"><a href="fileShow.jsp?imgid=<%=rs.getString(1)%>">Click on link for file Download</a></td>

</tr>

<%

}

rs.close();

con.close();

stmt.close();

}

catch(Exception e){

System.out.println("SQl connot Execute: " +e.getMessage());

}

%>

</table>

</BODY>

</HTML>

September 8, 2008 at 4:44 PM

<%@ page import="java.sql.*,java.io.*,java.util.*" %>

<%

String connectionURL = "jdbc:mysql://192.168.10.211:3306/amar";;

if(request.getParameter("imgid")!=null && request.getParameter("imgid")!="")

{

int id = Integer.parseInt(request.getParameter("imgid"));

String filename = "fileShow"+id+".java";
System.out.println("id " + id);

Connection con=null;

try{

Class.forName("com.mysql.jdbc.Driver").newInstance();

con=DriverManager.getConnection(connectionURL,"amar","amar123");

Statement st1=con.createStatement();

String strQuery = "select filename from FileUpload where id="+id;

ResultSet rs1 = st1.executeQuery(strQuery);

String imgLen="";
System.out.println("strQuery " + strQuery);

if(rs1.next()){

imgLen = rs1.getString(1);

}

rs1 = st1.executeQuery(strQuery);

if(rs1.next()){

int len = imgLen.length();

byte [] rb = new byte[len];

InputStream readImg = rs1.getBinaryStream(1);

int index=readImg.read(rb, 0, len);

st1.close();

response.reset();

response.setContentType("text/html");

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

response.getOutputStream().write(rb,0,len);

response.getOutputStream().flush();

}

}

catch (Exception e){

e.printStackTrace();

}

}

%>

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

Read for more information.

http://www.roseindia.net/jsp/fileupload.shtml

Thanks.

Amardeep.

File Upload And download JSP Urgent

Questions by Category