the values which are in the data table of database test.now i got the values are displaying on the jsp page but the values are displaying many times please help me in this regard i will give u the code which i have written and please refer the corrections and send me as soon as possible please help me iam waiting for ur reply. <%

Class.forName("org.gjt.mm.mysql.Driver"); System.out.println("Driver class is loaded..."); Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/contract","root",""); System.out.println("Connection is established....");
System.out.println("PreparedStatement object is created...");

     Statement statement=null;

try { statement=connection.createStatement(); statement.execute("Select dstsignatory,designation from tbl_generalinformation"); ResultSet resset = statement.getResultSet(); while(resset.next()) {%> DST Signatory: <%=resset.getString("dstsignatory")%> Designation: <%=resset.getString("designation")%>

        <% }
         resset.close();

    }
     catch (SQLException e)
     {
          e.printStackTrace();


     }
     finally
     {
         if(statement!=null)
         {
             try
             {
                statement.close();
             }
             catch (SQLException e)
             {
                 e.printStackTrace();


             }
         }
         if(connection != null)
         {
             try
             {
                connection.close();
             }
             catch (SQLException e)
             {
                 e.printStackTrace();

             }
         }
     }

%>

here my database is Contract and my table name is tbl_generalinformation lease help me soon. thanks for ur replys