ResultSet res=stat.executeQuery("select p_id,p_name,quote from painting");
I'm using the above JSP code to view the photos uploaded. I'm able to successfully upload the photos. The photos are being saved in a drive of my system. Can somebody help me out with this problem as to how i will view the photos uploaded. If i put the code for downloading between the the above lines of code the code does not run properly. I cannot also redirect the upload page to download page since it's a dynamic website and the user views the photos at his will, the constraint of viewing the photo directly after uploading is quiet unfriendly and it will show the photo you just uploaded. We are trying to develop a hyperlink to each image so that the user is able to view all the photos uploaded so far.
Please i'll be extremely thankful if somebody helps me get out of this problem.
April 24, 2010 at 11:26 AM
Have you insert the uploaded file into the database?
Do you want to retrieve all the files?
Please clarify this.
April 24, 2010 at 5:37 PM
no the uploaded file has been saved in a drive of my pc only the name of the file is being saved in the table. The name of the file is exactly the same as that of the photo uploaded.
<%=res.getString(1).toString()%> by using the following lines we extract all the records from the table and display it in tabular form.