javascript pagination

I have a html page and in that i was fetch data from database dynamically
for make listings.

Then how can i give facility of pagination to my listing
I was search on google but every example is for static data.

please help me for that issue.

[Please do not bump your posts]

This is something that should be handled on the server.

Hi,

Here, i retrieve data from database and also perform sorting.

<%@ page import="java.sql.Connection"
         import="java.sql.DriverManager"
         import="java.sql.ResultSet"
         import="java.sql.Statement"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
    "http://www.w3.org/TR/html4/loose.dtd">

<head>
        <style type="text/css">
            .pg-normal {
                color: black;
                font-weight: normal;
                text-decoration: none;
                cursor: pointer;
            }
            .pg-selected {
                color: black;
                font-weight: bold;
                text-decoration: underline;
                cursor: pointer;
            }
            .header
            {
                background-color:gray;
            }
        </style>
        <script type="text/javascript" src="paging.js"></script>
    </head>

<body>
        <form action="" method="get" enctype="application/x-www-form-urlencoded">
            <%
            Connection conn = null;

String driverName = "com.mysql.jdbc.Driver";          // DataBase Connection coding
            Class.forName(driverName).newInstance();

String url = "jdbc:mysql://localhost:3306/TrainingDB"; 
            String sqlUserName = "admin";
            String sqlPassword = "admin123";
            conn = (Connection) DriverManager.getConnection(url, sqlUserName, sqlPassword);

ResultSet rs;
            Statement stmnt = (Statement) conn.createStatement();
            String userDetailsQuery = "select * from eswar_tbl_users";          //Select all values from table
            rs = stmnt.executeQuery(userDetailsQuery);

%>
            <table id="results" border="1" cellpadding="5" cellspacing="5" >
                <tr>
                    <th class="header">UserName</th>
                    <th class="header">Phone No</th>
                </tr>

<%
            String userName = "";
            String phoneNo = "";
            while (rs.next())                                               // Get One by one
            {
                userName = rs.getString("username");                                   
                phoneNo = rs.getString("phoneno");
                %>
                <tr>
                    <td> <% out.println(userName);%>  </td>           //Print one by one
                    <td> <% out.println(phoneNo);%>  </td>
                </tr>
                <%
            }
                %>
            </table>
            <div id="pageNavPosition"></div>
        </form>
        <script type="text/javascript">

var pager = new Pager('results', 5);
            pager.init();
            pager.showPageNav('pager', 'pageNavPosition');
            pager.showPage(1);

</script>
    </body>
</html>

And also downlaod the script ( (paging.js) ) here :
http://en.newinstance.it/2006/09/27/client-side-html-table-pagination-with-javascript/

This script can handle pagination process.

The solution given by Eswara is full of bad practices and anti-patterns. Take it with a grain of salt.

Why have you posted a JSP solution (and one using really poor practices) for a JavaScript question?

[Edit: Ah, Gregg beat me by a few minutes!]