Display values form database

Hi

I have a table with the fields id, name and the content(of the file saved as blob in the database). I want to retrieve them in jsp page and show just id and name in a tabular form.(which i am able to do).

Afetr displaying the values, the I should be able to see the full content when I clicks on the name that has been displayed in the table.

I am attaching the code below.

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Download</title>
    </head>
    <body>
        <h4 align="center">Click on the file to view full content</h4>

<table align="center" width="600" style="color:#000000">
    <tr>
    <td width="168"><b>ID</b></td>
    <td width="200"><b>Date</b></td>
    <td width="168"><b>Name</b></td>
    <td width="168"><b>Type</b></td>
    <td width="168"><b>Quarter</b></td>
    </tr>

<% List list = new ArrayList();
          try{

Class.forName("org.apache.derby.jdbc.ClientDriver").newInstance();
              String host = "jdbc:derby://localhost:1527/Task";
              String username = "Task";
              String password = "Task";

Connection conn = DriverManager.getConnection(host, username, password);
              Statement stmt = conn.createStatement();
            
              String sql = "select * from annualreports";
              ResultSet rs = stmt.executeQuery( sql );

while(rs.next()){
     %>
   
    <tr BGCOLOR="#DDF1F9">
    <td width="168"><%out.println(rs.getString("id"));%></td>
    <td width="200"><%out.println(rs.getString("date"));%></td>
    <td width="168"><a href="/imageAndDoc/download1.jsp"><%out.println(rs.getString("name"));%></a></td>
    <td width="168"><%out.println(rs.getString("type"));%></td>
    <td width="168"><%out.println(rs.getString("quarter"));%></td>
    </tr>
    <% }
          }catch(Exception e){
          } 
   %>
  
    </table>
   </body>
</html>

I want the file to be opened when i click on the below name.

a href="/imageAndDoc/download1.jsp"><%out.println(rs.getString("name"));%></a

Please help.

Thanks,
Madhuri

JSP is intended for dynamic display purposes and including business logic/application logic is not in conformance with MVC specifications. You ought to move the database manipulation code to a Servlet/Action class.

Steps
1. From the Action/Servlet instance obtain the Connection, fetch the relevant data and pass it in a suitable Collection class to the JSP.
2. In the JSP iterate through the Collection obtained from above and display the data as required.

Cheers,
Raj.

Hi Raj,

Thanks for the reply. i haven't followed MVC since i just want to check it. Once i get the solution, I would follow MVC.

What you told is for just displaying the values in jsp from database. What i want to do is something different. Please go thrugh my previous post once again.

I have id, name and conetent fields. I can display id and name (in table) in jsp by having a servlet(action) and DAO(java class). When i click on any of the name displayed, i want its content(i.e the file) to be shown.

How can i do that? Any idea?

Thanks,
Madhuri

Madhuri,

Show the Name as a link for each row in the table. On click of the link call the 'Action' to display the detail in a new page alternatively you could also use Javascript to show a new window popup. Pass the parameters in the Query String. You should be able to display them in the popup.

Cheers,
Raj.