pagination in JSP

View Answers

November 17, 2008 at 7:01 AM

Hi friend,

<%@ page language="java" import="java.sql.*;"%>

<html>

<head>

<style>

A:hover {

text-decoration: none;

font-family:arial;

font-size:12px;

color: #000000;

BORDER: none;

}

A {

text-decoration: underline;

font-family:arial;

font-size:12px;

color: #000000;

BORDER: none;

}

</style>

</head>

<body>

<br><br><br>

<%

int offset=0;

int ofset = 0;

if(request.getParameter("offset")!=null) {

offset= Integer.parseInt(request.getParameter("offset").toString());

}

int total_count = 0;

int total_page = 0;

int per_page = 10;

String name="";

if(offset>1){

ofset = offset*per_page-per_page;

}

System.out.println("ofset" + ofset);

System.out.println("MySQL Connect Example.");

Connection conn = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String userName ="amar";
String password="amar123";

String color = "#F9EBB3";

try {

Class.forName(driver);
conn = DriverManager.getConnection(url+db,userName,password);

Statement stcount = conn.createStatement();

String strQuerycount = "select count(*) from Userdetail ";

ResultSet rscount = stcount.executeQuery(strQuerycount);

if(rscount.next()){

total_count=rscount.getInt(1);

}

if(total_count%per_page==0){

total_page = total_count/per_page;

}

else{
total_page = total_count/per_page+1;
}

// System.out.println("total_page" + total_page);

Statement st = conn.createStatement();

String strQuery = "select * from Userdetail limit "+ofset+","+per_page;

// out.println(strQuery);

ResultSet rs = st.executeQuery(strQuery);

// out.println("offset " + offset);

int count=0;

if(offset>1)

// count=offset*per_page-per_page;

%>

<br><br><br>

<table width="900px" align="center" style="border:1px solid #000000;" >

<tr>

<td colspan=8 align="center" style="background-color:ffeeff"><b>Display Page</b></td>

</tr>

<tr style="background-color:efefef;">

<td><b>SNo</b></td>

<td><b>User Id</b></td>
<td><b>User Name</b></td>
<td><b>LastName</b></td>
<td><center><b>E-mail</b></center></td>
<td><b>Date Of Birth</b></td>
<td><b>Country</b></td>
<td><b>State</b></td>

</tr>

<%
while(rs.next()){
if((count%2)==0){
color = "#eeffee";
}
else{
color = "#F9EBB3";
}
count++;
%>

November 17, 2008 at 7:03 AM

<tr style="background-color:<%=color%>;">

<td><%=count%></td>

<td><%=rs.getInt(1)%></td>
<td><%=rs.getString(2)%></td>
<td><%=rs.getString(3)%></td>
<td><%=rs.getString(4)%></td>
<td><%=rs.getString(5)%></td>
<td><%=rs.getString(6)%></td>
<td><%=rs.getString(7)%></td>

</tr>
<%
}
%>
</table>
<br><br>
<table width="100px" align="center" border=0><tr>
<%
if(count==0){
%>
<tr style="background-color:<%=color%>;">
<td colspan=8 align="center">No Record</td>
</tr>
<%
}
System.out.println("Connected to the database");
conn.close();
rs.close();
System.out.println("Disconnected from database");

}
catch (Exception e){

e.printStackTrace();

}

if(offset>1) {
int previous = offset-1;
System.out.println("previous>>>>>>>>> " + previous);

%>
<td>
<a href="viewTransAction.jsp?offset=<%=previous%>">Previous</a></td>

<%
}

if(total_page>0){

for(int i=1;i<=total_page;i++) {

if(request.getParameter("offset")==null) {
offset=1;
}
if(i==offset) {
%>
<td>
<%=i%>

</td>

<%
}
else{ %>
<td>
<a href="viewTransAction.jsp?offset=<%=i%>"><%=i%></a></td>
<%
}
}}
if(offset<total_page){
int next = offset+1;
%>
<td>
<a href="viewTransAction.jsp?offset=<%=next%>">Next</a></td>
<%
}

%>
</tr>
</table>
</body>
</html>
---------------------

Visit for more information.

http://www.roseindia.net/jsp/

Thanks.

Amardeep