Pagination with condition using servlet or jsp

Home Answers Viewqa JSP-Servlet Pagination with condition using servlet or jsp

veerabhadrarao.balla

Pagination with condition using servlet or jsp
1 Answer(s) 6 months and 11 days ago
Posted in : JSP-Servlet

Hi, Thanks in advance. I have a requirement like this,

In front-end page I have one text box and one submit button, After clicking the submit button that form field value I retrieved using "String name=request.getParameter("name of that text box")", Then I want perform the pagination based on the string value(I mean pagination with condition). My problem is first time five records will come(I mean 5 records per page) after clicking the 2 page that page will be reload that time "name variable will become null" finally result will come null only (Totally matched records i have 25 based on the condition) and I found one problem in that when I am trying to click 2 page onwords that time name variable will become null. How to make it that name variable constant.

View Answers

December 10, 2012 at 3:08 PM

Here is jsp code that retrieves the record from database and show pagination.

paging.jsp:

<%@ 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;
}
%>
<%
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connectionconn = DriverManager.getConnection("jdbc:mysql://localhost:3306/db2admin","root", "root");
 int showRows=5;
int totalRecords=5;
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 db2admin.reg limit "+iPageNo+","+showRows+"";
PreparedStatement ps1=conn.prepareStatement(query1);
ResultSet rs1=ps1.executeQuery();

String query2="SELECT FOUND_ROWS() as cnt";
PreparedStatement ps2=conn.prepareStatement(query2);
ResultSet rs2=ps2.executeQuery();
if(rs2.next()){
totalRows=rs2.getInt("cnt");
}
%>
<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>
<th>USERNAME</th><th>FIRSTNAME</th><th>EMAIL</th><th>COUNTRY</th>
</tr>
<%while(rs1.next()){
%>
<tr><td><%=rs1.getString("USERNAME")%></td>
<td><%=rs1.getString("FIRSTNAME")%></td>
<td><%=rs1.getString("EMAIL")%></td>
<td><%=rs1.getString("COUNTRY")%></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>
<%
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="paging.jsp?iPageNo=<%=prePageNo%>&cPageNo=<%=prePageNo%>">Previous</a>
<%
}
for(i=((cPage*totalRecords)-(totalRecords-1));i<=(cPage*totalRecords);i++){
if(i==((iPageNo/showRows)+1)){%>
<a href="paging.jsp?iPageNo=<%=i%>" style="cursor:pointer;color: red"><b><%=i%></b></a>
<%
}
else if(i<=totalPages){
%>
<a href="paging.jsp?iPageNo=<%=i%>"><%=i%></a>
<%
}
}
if(totalPages>totalRecords && i<totalPages){
%>
<a href="paging.jsp?iPageNo=<%=i%>&cPageNo=<%=i%>">Next</a>
<%
}
}
%>
<b>Rows <%=startResult%> - <%=endResult%> Total Rows <%=totalRows%> </b>
</div></td></tr></table></form></body></html>

Pagination with condition using servlet or jsp
Pagination with condition using servlet or jsp Hi, Thanks... I retrieved using "String name=request.getParameter("name of that text box")", Then I want perform the pagination based on the string value(I mean pagination

pagination
pagination I need to give pagination with where condition (query....... Here is a simple jsp pagination code where we have used mysql database...()) { totalRows=rs2.getInt("cnt"); } %> <html> <h3>Pagination of JSP

Pagination in jsp - JSP-Servlet
Pagination in jsp I need an example of pagination in JSP using display tag

Pagination
Pagination How to create pagination in jsp with EJB using MS SQL

pagination
pagination Simple way for pagination in jsp using java script to display data without send database

Pagination - JSP-Servlet
Pagination I want to display only 10 records but my arraylist contains for example about 100 records... My jsp page should contain 10 records along with the pagination below.... like prev 1 2 3 4 5 next I am using

pagination problem - JSP-Servlet
(),insert() methods using or importing employee class.finally i created a class using servlets in that i called a these methods,to call this servlet i created...pagination problem Thanks sir for posting the answer.But i have 2

pagination
pagination please let me know how to fetch records from database and display them using paging in jsp and struts

Jsp pagination - JSP-Servlet
has to go to the specified servlet and it has to get the next question can u plz tell me the solution Hi friend, For Jsp pagination application...Jsp pagination Iam doing a online exam application for this i need

pagination - JSP-Servlet
friend, Simple pagination in jsp Simple pagination in JSP... Simple pagination in jsp Displaying Records...pagination Hi, could u tell me how i will handle pagination

Pagination
Pagination I want to write one where condition in sql query in pagination concept

how to disable submit button in jsp using servlet when some condition is satisfied
how to disable submit button in jsp using servlet when some condition is satisfied how to disable submit button in jsp using servlet when some condition is satisfied

Pagination
Pagination How to apply pagination in JSP. Please help

pagination
pagination How to set pagination using java script to display data

Pagination
Pagination How to implement pagination in struts using hibernate

dynamic pagination in jsp - JSP-Servlet
dynamic pagination in jsp i am unable to display the data in multiple pages. I am gettting data from the database from the javaBeans to jsp by vectors... but i am unable to displaying them in jsp 15 records per page

pagination
pagination I need to give pagination with where condition (query="select * from qtn where qid='"+replyQuesionId+"'limit "+iPageNo+","+showRows+"" ) like this I want, without where condition it is working but with condition

Paging or pagination - Development process
Paging or pagination 1.how to do paging or pagination in jsp using... to get a correct values... I m sending my jsp code also please help me sir...("Starting index is "+startIndex); %> Pagination The Following

Pagination
Pagination I want to know how to use pagination in jsp. I have a list object from that i want to display 3 questions per page can u help me

Pagination Using Displaytag Lib
Pagination Using Displaytag Lib I am using Struts 1.2 for my web based project. While using display tag lib in jsp for pagination, is there any substitute of using As I dont want to be dependent on any site(s). Please

Pagination
=rs2.getInt("cnt"); } %> Pagination of JSP page Terr_Code Terr_Name

pagination
pagination how can i start pagination in jsp? Hi Friend, Try the following code: <%@ page language="java" %> <%@ page import...;Pagination of JSP page</h3> <body> <form> <input type="hidden

Pagination
Pagination pagination in jsp Hi Friend, Try the following code: <%@ page language="java" %> <%@ page import="java.sql.*" %>...()) { totalRows=rs2.getInt("cnt"); } %> <html> <h3>Pagination of JSP

pagination
;Pagination of JSP page</h3> <body> <form> <input type="hidden... me how to paginate questions without refreshing page Here is a jsp code of pagination. In the given code,we have taken the database table student

Pagination in jsp using oracle and not sql
Pagination in jsp using oracle and not sql I need the code for pagination in jsp using oracle. I already tried it with rownum between instead... Pagination using Mysql database <%@ page language="java" %> <%@ page

Jsp table Pagination
Jsp table Pagination I tried the code already.But I dont want it with SQL.I want it for oracle database because I'm using oracle.So please help me with this issue. Thanks

In pagination how to hilight the links - JSP-Servlet
In pagination how to hilight the links Dear Sir, Thanks for posting the answer,its working fine.Now i want google or others like pagination ,in that if i click on a number only that number color will be changed like

In pagination how to hilight the links - JSP-Servlet
In pagination how to hilight the links Dear Sir, In pagination how to highlight the links or how to change the color of that link when i clickon that particular link....Please help me sir.. Some of the code which i

pagination in JSP - JSP-Interview Questions
pagination in JSP Hi! Everybody.. I am new to JSP. I am doing project using JSP. Everything is OK. When i am displaying the data from ResultSet... --------------------- Visit for more information. http://www.roseindia.net/jsp/ Thanks

jsp pagination
jsp pagination I want to implement pagination on jsp page Each jsp page having some radio buttons, on click of next previous page selected radio buttons are reset. I want to maintain state of selected radio buttons on previous

JSP Pagination
I could possibly use?? JSP Pagination pagination.jsp: <%@ page..."); } %> <html><h3>Pagination of JSP page</h3> <body><...JSP Pagination Hi , I have several JSP's that displays data from

Using Scriplet in JSP - JSP-Servlet
Using Scriplet in JSP Hi, I need to display suitable fields in my jsp but this should be done upon suitable condition becomes true for eg... on } IN HOME JSP ****** home.jsp **** Currently I am directly using

store pagination form fields - Struts
table. here iam using pagination for questions to be displayed to client... approach this task. iam using jstl in jsp to iterate the list object of different...store pagination form fields hi,iam working online exams project

pagination in hibernate with jsp
pagination in hibernate with jsp Hi, plz give me example on pagination . Hi Friend, Visit Here Thanks

jsp - JSP-Servlet
jsp Hi How to inactive button based on checking condition in jsp page(using java code)? With Regards Venkatesan

What's wrong with my pagination code in JSP?
What's wrong with my pagination code in JSP? Dear experts, I've...; print("code sample"); JSP Pagination The given code retrieves...()){ totalRows=rs2.getInt("cnt"); } %> <html><h3>Pagination of JSP

pagination in jsp - JDBC
. Simple pagination in jsp... ------------------ Simple pagination in jsp Simple pagination in JSP Displaying Records

Pagination in java
Pagination in java How to handle pagination when there are records like say in millions in java? Or do we handle this using SQL? I as asked... far good performance then Java pagination. Thanks

Pagination without using database in php
Pagination without using database in php How can I show multiple images in multiple rows with pagination in php

pagination in jsf
pagination in jsf Hi , i am implemeting an online exam system , i have placed my questions as an arraylist in my jsp file within tag , but now i want to paginate these questions based on respective questions by clicking

jsp - JSP-Servlet
jsp i want to make gridview in jsp.... without using jsf.... Hi Friend, Try the following code: Pagination of JSP page... information, visit the following links: http://www.roseindia.net/jsp/data

Hibernate JSP
In this section, you will learn about Hibernate with JSP using simple pagination example

jsf pagination
()) { totalRows=rs2.getInt("cnt"); } %> <html> <h3>Pagination of JSP... on please give any solution . Thanks, Bhuban Here is a jsp code of pagination. In the given code,we have taken the database table student(rollNo,name,marks

servlet code - JSP-Servlet
servlet code how to implement paging or pagination in java code using servlets. Hi Friend, Try the following code: import java.io....=rs2.getInt("cnt"); System.out.println(totalRows); } out.println("Pagination

pagination in hibernate with jsp
pagination in hibernate with jsp Hi, plz give me example on pagination . Hi Friend, We have used MySql database with JSP...>Pagination of JSP page</h3> <body> <form> <input type

JSP Code - JSP-Servlet
JSP Code Hi, I have a problem in limiting the number of row... to display only 10 records per pages in jsp, then how can i achieve this concept... Rai. Hi Friend, Try the following code: Pagination

pagination+dynamic pagesize+hibernate - Struts
pagination+dynamic pagesize+hibernate pagination using hibernate with dynamic page size plzz heilp me

JSP code - JSP-Servlet
JSP code Hi! Can somebody provide a line by line explanation... the content type information from the jsp header. Then check the two conditions...)). If the condition is true, create an object of DataInputStream and pass

jsp/servlet - JSP-Servlet
jsp/servlet How to create and save the excel file on given location using jsp/servlet? hi Geetanjali, Read for more information, http://www.roseindia.net/jsp/poi/excelPOI.shtml Thanks

Latest
Frameworks
Category