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:
- Difference between equals() and == ?
- Assignment operator in java
- Hibernate Video Tutorial
- Conditional operator in java
- jQuery Tutorial For Beginners
- Show pdf's in web browser by using jsp?
- Google says Start Searching India
- Most Effective SEO Tools
- Assigning value to anchor <a></a> tag using custom tag
- java code using while loop
