I have embedded the following code in my JSP page.

  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  Connection myConn = DriverManager.getConnection("jdbc:odbc:photodb");

  Statement stmt = myConn.createStatement();
  ResultSet myResultSet = stmt.executeQuery("select * from photo where
ROLLNO=1");

So each time I click on next or previous the ROLLNO should increase/decrease
accordingly.


----- Original Message -----
From: "Virginia Rejas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 29, 2001 3:40 PM
Subject: Re: displaying data in sets


> How do you display the first set of data from your database?
>
> ----- Original Message -----
> From: S. Jyotinarayan <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, March 29, 2001 7:41 AM
> Subject: displaying data in sets
>
>
> > I want to display data from my database by sets on an internet browser.
I
> > have displayed the first set of data from the database. I am using JSP
and
> > the JDBC-ODBC architecture to connect to the MS Access database.
> > How could I now on the same page with 'next' and 'previous' buttons for
> > example browse through the rest of the records in the database.
> > Thanx in advance.
> > Jyotinarayan.
> >
> >
>
===========================================================================
> > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
> DIGEST".
> > Some relevant FAQs on JSP/Servlets can be found at:
> >
> >  http://java.sun.com/products/jsp/faq.html
> >  http://www.esperanto.org.nz/jsp/jspfaq.html
> >  http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> >  http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> >
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
>  http://java.sun.com/products/jsp/faq.html
>  http://www.esperanto.org.nz/jsp/jspfaq.html
>  http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>  http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Reply via email to