Hello,
Thank you very much.
I think there are still better methods of doing it,
like JSP-Tags etc
Regards
Arun
> ----------
> From: [Aruniima
> Chakrabarti][SMTP:[EMAIL PROTECTED]]
> Reply To: A mailing list for discussion about Sun Microsystem's Java
> Servlet API Technology.
> Sent: Wednesday, April 24, 2002 6:10 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Pagination in JSP
>
> Hi Arun,
> This can be done using JavaScript. You can get the desired set of
> records from the database & display those records using JavaScript
> functions.
> I am enclosing the code below for a program which allows you to display
> data
> from the database, one record at a time. & allows the user to move back &
> forth the records. Also, delete, modify, add records to the database.
>
> Regards,
> aruniima
>
>
> <jsp:include page="../menuadmin.htm"/>
> <jsp:useBean id="usr" class="classes.db.User"/>
>
> <%
> String recs[][]=user.retrieveAll();
> %>
> <html>
> <head>
> <script>
> var NO_OF_RECS
> var CURR_REC_NO=0
> var recs=new Array(<%=recs.length%>)
> var id
> for(var i=0;i<recs.length;i++)
> recs[i]=new Array(<%=recs[0].length%>)
>
> <%
> for(int i=0;i<recs.length;i++){
> for(int j=0; j < recs[i].length ; j++){
> %>
> recs[<%=i%>][<%=j%>]
> ="<%=recs[i][j]%>"
> <%
> }
> }
> %>
>
> NO_OF_RECS=recs.length
> id=recs[0][0]
> function assign(){
> document.frm.userID.value=recs[CURR_REC_NO][0]
> document.frm.userName.value=recs[CURR_REC_NO][1]
>
> document.frm.userPassword.value=recs[CURR_REC_NO][2]
> document.frm.userType.value=recs[CURR_REC_NO][3]
> }
>
>
> function moveFirst(){
> CURR_REC_NO=0
> id=recs[CURR_REC_NO][0]
> assign()
> }
>
> function movePrev(){
> CURR_REC_NO--
> if(CURR_REC_NO==-1)
> CURR_REC_NO=0
> id=recs[CURR_REC_NO][0]
> assign()
> }
>
> function moveNext(){
> CURR_REC_NO++
> if(CURR_REC_NO==NO_OF_RECS)
> CURR_REC_NO--
> id=recs[CURR_REC_NO][0]
> assign()
> }
>
> function moveLast(){
> CURR_REC_NO=NO_OF_RECS-1
> id=recs[CURR_REC_NO][0]
> assign()
> }
>
>
> function showusermod(){
> window.location="showusermod.jsp?id=" + id
> }
>
> function userdel(){
> if(confirm("Are you sure you want to delete this
> record")){
> window.location="del.jsp?id=" + id
> }
> }
> </script>
> </head>
>
> <body onLoad="assign()">
> <center>
> <b> Administration for Users </b><br>
> <form name=frm>
> <table>
> <tr>
> <td>
> UserId:
> </td>
> <td>
> <input type=text
> name="userID" onKeyDown="return false">
> </td>
> </tr>
> <tr>
> <td>
> UserName:
> </td>
> <td>
> <input type=text
> name="userName" onKeyDown="return false">
> </td>
> </tr>
> <tr>
> <td>
> User Password:
> </td>
> <td>
> <input type=text
> name="userPassword" onKeyDown="return false">
> </td>
> </tr>
> <tr>
> <td>
> User Type:
> </td>
> <td>
> <input type=text
> name="userType" onKeyDown="return false">
> </td>
> </tr>
> </table>
>
> <table>
> <tr>
> <td><input type=button value="<<"
> onClick="moveFirst()"></td>
> <td><input type=button value=" < "
> onClick="movePrev()"></td>
> <td><input type=button value=" > "
> onClick="moveNext()"></td>
> <td><input type=button value=">>"
> onClick="moveLast()"></td>
> </tr>
> </table>
>
>
> <table>
> <tr>
> <td><input type=button value="Add"
> name="addbutton" onClick="window.location='showuseradd.jsp'"></td>
> <td><input type=button
> value="Modify" onClick="showusermod()"></td>
> <td><input type=button
> value="Delete" onClick="userdel()"></td>
> <td><input type=button
> value="Close"
> onClick="window.close()"></td>
>
> </tr>
> </table>
> <input type=hidden name="hid">
>
> </form>
> </center>
>
> </body>
> </html>
>
>
>
> -----Original Message-----
> From: Arunkumar_N [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 24, 2002 3:54 PM
> To: [EMAIL PROTECTED]
> Subject: Pagination in JSP
>
> Hello,
> Is there any logic to display 10 records at a time,where data is
> obtained dynamically from Database
> & a button to navigate back & forth in JSP.
>
> Please look into this
>
> Regards
> Arun
>
> **************************************************************************
> This email (including any attachments) is intended for the sole use of the
> intended recipient/s and may contain material that is CONFIDENTIAL AND
> PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying
> or
> distribution or forwarding of any or all of the contents in this message
> is
> STRICTLY PROHIBITED. If you are not the intended recipient, please contact
> the sender by email and delete all copies; your cooperation in this regard
> is appreciated.
> **************************************************************************
>
> __________________________________________________________________________
> _
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
> --------------------------------------------------------------------------
> --
>
> This message contains privileged and confidential information and is
> intended only for the individual named. If you are not the intended
> recepient you should not disseminate, distribute, store, print, copy or
> deliver this message. Please notify the sender immediately by e-mail if
> you
> have received this e-mail by mistake and immediately delete this e-mail
> from
> your system.
>
>
> E-mail transmission cannot be guaranteed to be secure or error-free as
> information could be intercepted, corrupted, lost, destroyed, arrive late
> or
> incomplete, or contain viruses. The sender therefore does not accept
> liability for any errors or omissions in the contents of this message
> which
> arise as a result of e-mail transmission. If verification is required
> please request a hard-copy version.
>
>
> --------------------------------------------------------------------------
>
> __________________________________________________________________________
> _
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
**************************************************************************
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
distribution or forwarding of any or all of the contents in this message is
STRICTLY PROHIBITED. If you are not the intended recipient, please contact
the sender by email and delete all copies; your cooperation in this regard
is appreciated.
**************************************************************************
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
