<%
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:newdsn","sa","master");
Statement stat=con.createStatement();
ResultSet res=stat.executeQuery("select p_id,p_name,quote from painting");
while(res.next())
{
%>
<tr><td><%=res.getString(1).toString()%></td>
<%
String pnt=res.getString(2).toString();
%>
<td><a href="<%=pnt%>.html"><%=pnt%></a></td>
<td><%=res.getString(3).toString()%></td>
</tr>
<%
}
}
catch(Exception ex)
{
ex.printStackTrace();
}
%>

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.