QuestionAsk Questions?
harini
1.how to do paging or pagination in jsp using servlets?
I have a 20 records ,i have to show them in 2 pages like pages 1 2...
i done this but i m geting starting 10 records correctly but i m unable to get a next 10 records it is showing a starting 10 records only please help me to get a correct values...
I m sending my jsp code also please help me sir.....
//Pagination.jsp
<%@ page import="com.antares.servlet.EmployeeControllerServlet"
contentType="text/html; charset=ISO-8859-1"%>
<%@ page import="java.util.*"%>
<%@ page import="com.antares.DAO.*"%>
<%@ page import="com.antares.*"%>
<%@page import="java.util.Iterator"%>
<%@page import="com.antares.DTO.Employee"%>
<%@ page import="java.util.*,java.sql.*,sun.jdbc.*"%>
<%
int intEmpId = 0, intEmpPhoneNo = 0;
String strFstName = null, strLstName = null, strEmpAdd = null, strEmailId = null, strStatus = null;
ArrayList<Employee> arlEmp = null;
String startIndexString = request.getParameter("startIndex");
String strValue=request.getParameter("value");
if (strValue == null) {
strValue = "0";
}
int value = Integer.parseInt(strValue);
System.out.println("Starting index is "+value);
if (startIndexString == null) {
startIndexString = "1";
}
int startIndex = Integer.parseInt(startIndexString);
System.out.println("Starting index is "+startIndex);
%>
<html>
<head>
<title>Pagination</title>
</head>
<body bgcolor="#ffffee" text="blue">
<h3>The Following Are List Of Employees...</h3>
<form target="_top" name="viewForm" method="post">
<%
int numPages = 0;
%> <%
String columnName = "", strInitialVal = null;
int count = 0;
int totalCols = 0;
int increment = 0;
int numRows =0;
final int numRecordsPerPage = 5;
int initial = 0;
int temp = 0,k=0;
System.out.println("initial value is " + initial);
%>
<table border="2" align="center" width="100%">
<tr>
<td>Index</td>
<td>EmpId</td>
<td>FirstName</td>
<td>LastName</td>
<td>Address</td>
<td>PhoneNumber</td>
<td>EmailId</td>
<td>Status</td>
</tr>
<%
System.out.println("initial value is " + initial);
if (session.getAttribute("employeeDataBase") != null) {
arlEmp = (ArrayList) session
.getAttribute("employeeDataBase");
}
numRows = arlEmp.size();
System.out.println(" total no. of records : " + numRows);
System.out.println(" Num of Records per page : "
+ numRecordsPerPage + "\n");
numPages = numRows / numRecordsPerPage;
System.out.println(" \n no. of pages before if Statement : "
+ numPages);
int remain = numRows % numRecordsPerPage;
if (remain != 0) {
numPages = numPages + 1;
}
System.out.println(" \n no. of pages after if Statement : "
+ numPages);
startIndex = numRecordsPerPage;
if ((numRecordsPerPage) <= numRows) {
increment = numRecordsPerPage;
System.out
.println(" \n 1. no. of pages (increment)in if condition is : "
+ increment);
} else {
if (remain == 0) {
increment = numRecordsPerPage;
System.out
.println(" \n 2 no. of (increment) pages in if condition is : "
+ increment);
} else {
startIndex = remain;
increment = remain;
}
}
System.out.println("ArrayList size is "+arlEmp.size());
System.out.println(".........value of first array list is "+arlEmp.get(1));
temp=value+numRecordsPerPage;
k=value;
if (arlEmp != null && arlEmp.size() > 0 && value<arlEmp.size()) {
Iterator<Employee> iter = arlEmp.iterator();
while (iter.hasNext() && initial < numRecordsPerPage) {
if(arlEmp.get(k)!=arlEmp.get(temp)){
Employee empDTO = (Employee) iter.next();
intEmpId = empDTO.getIntEmpid();
strFstName = empDTO.getEmp_fristName();
strLstName = empDTO.getEmp_lastName();
strEmpAdd = empDTO.getEmp_address();
intEmpPhoneNo = empDTO.getEmp_phone();
strEmailId = empDTO.getEmp_email();
strStatus = empDTO.getEmp_status();
System.out.println();
value++;
k++;
System.out.println("initial value is= " + initial);
%>
<tr>
<td><%=value%></td>
<td><%=intEmpId%></td>
<td><%=strFstName%></td>
<td><%=strLstName%></td>
<td><%=strEmpAdd%></td>
<td><%=intEmpPhoneNo%></td>
<td><%=strEmailId%></td>
<td><%=strStatus%></td>
</tr>
<%
initial++;
}
}
}
temp = initial;
System.out.println("Initial value is: " + initial);
%>
<%
for (count = startIndex; count < increment; count++) {
%><tr>
<%
for (int i = 1; i <= totalCols; i++) {
%><td><%=arlEmp.get(count - 1)%></td>
<%
System.out.println("**** " + arlEmp.get(count - 1));
}
System.out.println("out of inner for loop..");
System.out.println("**** " + arlEmp.get(count - 1));
%>
</tr>
<%
}
System.out.println("out of outer for loop..");
%>
</table>
<br>
<br>
<br>
<table width="100%">
<tr>
Displaying Records:
<%
startIndex = numRecordsPerPage;
if (numRecordsPerPage < numRows) {
%>
<%=(value - increment)+1%>
-
<%=value%>
<%
} else {
%>
<%=value%>
<%=-numRows%>
<%
}
%>
<%
for (int i = 1; i < numPages; i++) {
if (i==value) {
System.out.println("page value is "+i);
//startIndex--;
System.out.println("Initial value is " + initial);
}
else{
%>
<a href="Pagination.jsp?value=<%=value%>"><%=i%> </a>
<%
}
}
increment = numRecordsPerPage;
startIndex = numRecordsPerPage;
if (numRecordsPerPage<=numRows) {
%>
<a href="Pagination.jsp?value=<%=value%>">Next</a>
<%
}
%>
</tr>
<a href="Pagination.jsp">Previous</a>
</table>
<br>
<br>
<a href='../html/login.html'>
<h3>Click Here To Go Home Page</h3>
</a> <br>
</form>
</body>
</html>
thanks in advance
Regards
harini
I have a 20 records ,i have to show them in 2 pages like pages 1 2...
i done this but i m geting starting 10 records correctly but i m unable to get a next 10 records it is showing a starting 10 records only please help me to get a correct values...
I m sending my jsp code also please help me sir.....
//Pagination.jsp
<%@ page import="com.antares.servlet.EmployeeControllerServlet"
contentType="text/html; charset=ISO-8859-1"%>
<%@ page import="java.util.*"%>
<%@ page import="com.antares.DAO.*"%>
<%@ page import="com.antares.*"%>
<%@page import="java.util.Iterator"%>
<%@page import="com.antares.DTO.Employee"%>
<%@ page import="java.util.*,java.sql.*,sun.jdbc.*"%>
<%
int intEmpId = 0, intEmpPhoneNo = 0;
String strFstName = null, strLstName = null, strEmpAdd = null, strEmailId = null, strStatus = null;
ArrayList<Employee> arlEmp = null;
String startIndexString = request.getParameter("startIndex");
String strValue=request.getParameter("value");
if (strValue == null) {
strValue = "0";
}
int value = Integer.parseInt(strValue);
System.out.println("Starting index is "+value);
if (startIndexString == null) {
startIndexString = "1";
}
int startIndex = Integer.parseInt(startIndexString);
System.out.println("Starting index is "+startIndex);
%>
<html>
<head>
<title>Pagination</title>
</head>
<body bgcolor="#ffffee" text="blue">
<h3>The Following Are List Of Employees...</h3>
<form target="_top" name="viewForm" method="post">
<%
int numPages = 0;
%> <%
String columnName = "", strInitialVal = null;
int count = 0;
int totalCols = 0;
int increment = 0;
int numRows =0;
final int numRecordsPerPage = 5;
int initial = 0;
int temp = 0,k=0;
System.out.println("initial value is " + initial);
%>
<table border="2" align="center" width="100%">
<tr>
<td>Index</td>
<td>EmpId</td>
<td>FirstName</td>
<td>LastName</td>
<td>Address</td>
<td>PhoneNumber</td>
<td>EmailId</td>
<td>Status</td>
</tr>
<%
System.out.println("initial value is " + initial);
if (session.getAttribute("employeeDataBase") != null) {
arlEmp = (ArrayList) session
.getAttribute("employeeDataBase");
}
numRows = arlEmp.size();
System.out.println(" total no. of records : " + numRows);
System.out.println(" Num of Records per page : "
+ numRecordsPerPage + "\n");
numPages = numRows / numRecordsPerPage;
System.out.println(" \n no. of pages before if Statement : "
+ numPages);
int remain = numRows % numRecordsPerPage;
if (remain != 0) {
numPages = numPages + 1;
}
System.out.println(" \n no. of pages after if Statement : "
+ numPages);
startIndex = numRecordsPerPage;
if ((numRecordsPerPage) <= numRows) {
increment = numRecordsPerPage;
System.out
.println(" \n 1. no. of pages (increment)in if condition is : "
+ increment);
} else {
if (remain == 0) {
increment = numRecordsPerPage;
System.out
.println(" \n 2 no. of (increment) pages in if condition is : "
+ increment);
} else {
startIndex = remain;
increment = remain;
}
}
System.out.println("ArrayList size is "+arlEmp.size());
System.out.println(".........value of first array list is "+arlEmp.get(1));
temp=value+numRecordsPerPage;
k=value;
if (arlEmp != null && arlEmp.size() > 0 && value<arlEmp.size()) {
Iterator<Employee> iter = arlEmp.iterator();
while (iter.hasNext() && initial < numRecordsPerPage) {
if(arlEmp.get(k)!=arlEmp.get(temp)){
Employee empDTO = (Employee) iter.next();
intEmpId = empDTO.getIntEmpid();
strFstName = empDTO.getEmp_fristName();
strLstName = empDTO.getEmp_lastName();
strEmpAdd = empDTO.getEmp_address();
intEmpPhoneNo = empDTO.getEmp_phone();
strEmailId = empDTO.getEmp_email();
strStatus = empDTO.getEmp_status();
System.out.println();
value++;
k++;
System.out.println("initial value is= " + initial);
%>
<tr>
<td><%=value%></td>
<td><%=intEmpId%></td>
<td><%=strFstName%></td>
<td><%=strLstName%></td>
<td><%=strEmpAdd%></td>
<td><%=intEmpPhoneNo%></td>
<td><%=strEmailId%></td>
<td><%=strStatus%></td>
</tr>
<%
initial++;
}
}
}
temp = initial;
System.out.println("Initial value is: " + initial);
%>
<%
for (count = startIndex; count < increment; count++) {
%><tr>
<%
for (int i = 1; i <= totalCols; i++) {
%><td><%=arlEmp.get(count - 1)%></td>
<%
System.out.println("**** " + arlEmp.get(count - 1));
}
System.out.println("out of inner for loop..");
System.out.println("**** " + arlEmp.get(count - 1));
%>
</tr>
<%
}
System.out.println("out of outer for loop..");
%>
</table>
<br>
<br>
<br>
<table width="100%">
<tr>
Displaying Records:
<%
startIndex = numRecordsPerPage;
if (numRecordsPerPage < numRows) {
%>
<%=(value - increment)+1%>
-
<%=value%>
<%
} else {
%>
<%=value%>
<%=-numRows%>
<%
}
%>
<%
for (int i = 1; i < numPages; i++) {
if (i==value) {
System.out.println("page value is "+i);
//startIndex--;
System.out.println("Initial value is " + initial);
}
else{
%>
<a href="Pagination.jsp?value=<%=value%>"><%=i%> </a>
<%
}
}
increment = numRecordsPerPage;
startIndex = numRecordsPerPage;
if (numRecordsPerPage<=numRows) {
%>
<a href="Pagination.jsp?value=<%=value%>">Next</a>
<%
}
%>
</tr>
<a href="Pagination.jsp">Previous</a>
</table>
<br>
<br>
<a href='../html/login.html'>
<h3>Click Here To Go Home Page</h3>
</a> <br>
</form>
</body>
</html>
thanks in advance
Regards
harini
View Answers
April 1, 2010 at 11:13 AM
Hi Friend,
We are sending you our code.
<%@ page language="java" %>
<%@ page import="java.sql.*" %>
<%!
public int nullIntconvert(String str){
int num=0;
if(str==null) {
str="0";
}
else if((str.trim()).equals("null")) {
str="0";
}
else if(str.equals("")) {
str="0";
}
try{
num=Integer.parseInt(str);
}
catch(Exception e) { }
return num;
}
%>
<%
Connection conn = null;
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root";, "root");
ResultSet rs1 = null;
ResultSet rs2 = null;
PreparedStatement ps1=null;
PreparedStatement ps2=null;
int showRows=10;
int totalRecords=10;
int totalRows=nullIntconvert(request.getParameter("totalRows"));
int totalPages=nullIntconvert(request.getParameter("totalPages"));
int iPageNo=nullIntconvert(request.getParameter("iPageNo"));
int cPageNo=nullIntconvert(request.getParameter("cPageNo"));
int startResult=0;
int endResult=0;
if(iPageNo==0){
iPageNo=0;
}
else{
iPageNo=Math.abs((iPageNo-1)*showRows);
}
String query1="SELECT SQL_CALC_FOUND_ROWS * FROM student limit "+iPageNo+","+showRows+"";
ps1=conn.prepareStatement(query1);
rs1=ps1.executeQuery();
String query2="SELECT FOUND_ROWS() as cnt";
ps2=conn.prepareStatement(query2);
rs2=ps2.executeQuery();
if(rs2.next()) {
totalRows=rs2.getInt("cnt");
System.out.println(totalRows);
}
%>
<html>
<h3>Pagination of JSP page</h3>
<body>
<form>
<input type="hidden" name="iPageNo" value="<%=iPageNo%>">
<input type="hidden" name="cPageNo" value="<%=cPageNo%>">
<input type="hidden" name="showRows" value="<%=showRows%>">
<table width="100%" cellpadding="0" cellspacing="0" border="1" >
<tr>
<td>Roll No</td>
<td>Name</td>
<td>Marks</td>
<td>Grade</td>
</tr>
<%
while(rs1.next()){
%>
<tr>
<td><%=rs1.getInt("rollNo")%></td>
<td><%=rs1.getString("name")%></td>
<td><%=rs1.getInt("marks")%></td>
<td><%=rs1.getString("grade")%></td>
</tr>
<%
}
%>
<%
try{
if(totalRows<(iPageNo+showRows)) {
endResult=totalRows;
}
else{
endResult=(iPageNo+showRows);
}
startResult=(iPageNo+1);
totalPages=((int)(Math.ceil((double)totalRows/showRows)));
}
catch(Exception e){
e.printStackTrace();
}
%>
<tr>
<td colspan="3">
<div>
We are sending you our code.
<%@ page language="java" %>
<%@ page import="java.sql.*" %>
<%!
public int nullIntconvert(String str){
int num=0;
if(str==null) {
str="0";
}
else if((str.trim()).equals("null")) {
str="0";
}
else if(str.equals("")) {
str="0";
}
try{
num=Integer.parseInt(str);
}
catch(Exception e) { }
return num;
}
%>
<%
Connection conn = null;
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root";, "root");
ResultSet rs1 = null;
ResultSet rs2 = null;
PreparedStatement ps1=null;
PreparedStatement ps2=null;
int showRows=10;
int totalRecords=10;
int totalRows=nullIntconvert(request.getParameter("totalRows"));
int totalPages=nullIntconvert(request.getParameter("totalPages"));
int iPageNo=nullIntconvert(request.getParameter("iPageNo"));
int cPageNo=nullIntconvert(request.getParameter("cPageNo"));
int startResult=0;
int endResult=0;
if(iPageNo==0){
iPageNo=0;
}
else{
iPageNo=Math.abs((iPageNo-1)*showRows);
}
String query1="SELECT SQL_CALC_FOUND_ROWS * FROM student limit "+iPageNo+","+showRows+"";
ps1=conn.prepareStatement(query1);
rs1=ps1.executeQuery();
String query2="SELECT FOUND_ROWS() as cnt";
ps2=conn.prepareStatement(query2);
rs2=ps2.executeQuery();
if(rs2.next()) {
totalRows=rs2.getInt("cnt");
System.out.println(totalRows);
}
%>
<html>
<h3>Pagination of JSP page</h3>
<body>
<form>
<input type="hidden" name="iPageNo" value="<%=iPageNo%>">
<input type="hidden" name="cPageNo" value="<%=cPageNo%>">
<input type="hidden" name="showRows" value="<%=showRows%>">
<table width="100%" cellpadding="0" cellspacing="0" border="1" >
<tr>
<td>Roll No</td>
<td>Name</td>
<td>Marks</td>
<td>Grade</td>
</tr>
<%
while(rs1.next()){
%>
<tr>
<td><%=rs1.getInt("rollNo")%></td>
<td><%=rs1.getString("name")%></td>
<td><%=rs1.getInt("marks")%></td>
<td><%=rs1.getString("grade")%></td>
</tr>
<%
}
%>
<%
try{
if(totalRows<(iPageNo+showRows)) {
endResult=totalRows;
}
else{
endResult=(iPageNo+showRows);
}
startResult=(iPageNo+1);
totalPages=((int)(Math.ceil((double)totalRows/showRows)));
}
catch(Exception e){
e.printStackTrace();
}
%>
<tr>
<td colspan="3">
<div>
April 1, 2010 at 11:14 AM
continue..
<%
int i=0;
int cPage=0;
if(totalRows!=0) {
cPage=((int)(Math.ceil((double)endResult/(totalRecords*showRows))));
int prePageNo=(cPage*totalRecords)-((totalRecords-1)+totalRecords);
if((cPage*totalRecords)-(totalRecords)>0){
%>
<a href="pagination.jsp?iPageNo=<%=prePageNo%>&cPageNo=<%=prePageNo%>"> << Previous</a>
<%
}
for(i=((cPage*totalRecords)-(totalRecords-1));i<=(cPage*totalRecords);i++){
if(i==((iPageNo/showRows)+1)){%>
<a href="pagination.jsp?iPageNo=<%=i%>" style="cursor:pointer;color: red"><b><%=i%></b></a>
<%
}
else if(i<=totalPages){
%>
<a href="pagination.jsp?iPageNo=<%=i%>"><%=i%></a>
<%
}
}
if(totalPages>totalRecords && i<totalPages){
%>
<a href="pagination.jsp?iPageNo=<%=i%>&cPageNo=<%=i%>"> >> Next</a>
<%
}
}
%>
<b>Rows <%=startResult%>-<%=endResult%>Total Rows<%=totalRows%> </b>
</div>
</td>
</tr>
</table>
</form>
</body>
</html>
<%
try{
if(ps1!=null){
ps1.close();
}
if(rs1!=null){
rs1.close();
}
if(ps2!=null){
ps2.close();
}
if(rs2!=null){
rs2.close();
}
if(conn!=null){
conn.close();
}
}
catch(Exception e)
{
e.printStackTrace();
}
%>
Thanks
<%
int i=0;
int cPage=0;
if(totalRows!=0) {
cPage=((int)(Math.ceil((double)endResult/(totalRecords*showRows))));
int prePageNo=(cPage*totalRecords)-((totalRecords-1)+totalRecords);
if((cPage*totalRecords)-(totalRecords)>0){
%>
<a href="pagination.jsp?iPageNo=<%=prePageNo%>&cPageNo=<%=prePageNo%>"> << Previous</a>
<%
}
for(i=((cPage*totalRecords)-(totalRecords-1));i<=(cPage*totalRecords);i++){
if(i==((iPageNo/showRows)+1)){%>
<a href="pagination.jsp?iPageNo=<%=i%>" style="cursor:pointer;color: red"><b><%=i%></b></a>
<%
}
else if(i<=totalPages){
%>
<a href="pagination.jsp?iPageNo=<%=i%>"><%=i%></a>
<%
}
}
if(totalPages>totalRecords && i<totalPages){
%>
<a href="pagination.jsp?iPageNo=<%=i%>&cPageNo=<%=i%>"> >> Next</a>
<%
}
}
%>
<b>Rows <%=startResult%>-<%=endResult%>Total Rows<%=totalRows%> </b>
</div>
</td>
</tr>
</table>
</form>
</body>
</html>
<%
try{
if(ps1!=null){
ps1.close();
}
if(rs1!=null){
rs1.close();
}
if(ps2!=null){
ps2.close();
}
if(rs2!=null){
rs2.close();
}
if(conn!=null){
conn.close();
}
}
catch(Exception e)
{
e.printStackTrace();
}
%>
Thanks
Related Pages:
- Difference between equals() and == ?
- Assignment operator in java
- Hibernate Video Tutorial
- Conditional operator in java
- jQuery Tutorial For Beginners
- Show pdf's in web browser by using jsp?
- Google says Start Searching India
- Most Effective SEO Tools
- Assigning value to anchor <a></a> tag using custom tag
- java code using while loop
