QuestionAsk Questions?
Ragavendran.R
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>
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.
<%
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.
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
