how can manages recordset in jsp

I am ask a question how can show 5-5 records in jsp page and I get answer provided by you but it give exception:-

org.apache.jasper.JasperException: /jsp/paging.jsp(75,0) According to TLD or attribute directive in tag file, attribute items does not accept any expressions

View Answers

April 18, 2011 at 5:47 PM

pagination.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;
}
%>
<%
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=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 employee 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");
}
%>
<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>Name</th><th>Address</th><th>Contact</th><th>Email</th>
</tr>
<%
while(rs1.next()){
%>
<tr><td><%=rs1.getString("name")%></td><td><%=rs1.getString("address")%></td><td><%=rs1.getInt("contactNo")%></td>
<td><%=rs1.getString("email")%></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="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>

March 31, 2013 at 3:32 PM

I have a question that you are using SQL but in case of oracle database how can i solve this. I don't want to use tag library. I want to handle it locally.

Advertisements

How can i pass the valus from a JSP to the action class???
How can i pass the valus from a JSP to the action class??? hewllo wevryone... can anyone help me with how i can pass the value of menuId in my JSP and pass it in the action class

how can we pass parameters from jsp href to another servlet
how can we pass parameters from jsp href to another servlet how can we pass parameters from jsp href to another servlet

How i can send mail by using jsp.............. - JavaMail
How i can send mail by using JSP Hi, will you please tell me how i can send mail by using jsp. Tell me in detail. Thanks! Example and JSP Code for sending mailSee the give link for JSP coding, that will allow you

How can I get the full URL with the attached parameters? - JSP-Servlet
How can I get the full URL with the attached parameters? Hi, I'm trying to figure out how to get the current url and use it in my jsp page. I...:8080/MesEduSchoolsProject/displayMenu.jsp How can I get the full URL with the attached parameters

How Can I get ArrayList of Data from jsp with ajax request
How Can I get ArrayList of Data from jsp with ajax request Hi, I retereved 5 Employee Record of Data from Struts Action class to jsp with ajax response. But I don't how how can reterve this dynamic 5 employee records

how can i connected jsp wih mysql - Java Beginners
how can i connected jsp wih mysql i have a code jsp file... not exist i have a tomcat 4.0,mysql 5.0, and jdk 1.4 plz any one help me how to connect this and how can i use it plz help me its very urgent plz send my

How can i implement the calculator programe in jsp code
How can i implement the calculator programe in jsp code Please send code for the calculator using jsp technologies please guidelines to me. Here is a simple jsp calculator code that accepts two numbers from the user

how i can add an horizontal scrollbar at my PdfAnnotation ? - JSP-Servlet
how i can add an horizontal scrollbar at my PdfAnnotation ? How to add the an horizontal scrollbar at my PdfAnnotation ? for example document d=new document(0. document.open

User Registration Form Using JSP(JspBeans) after that how i can insert in database
User Registration Form Using JSP(JspBeans) after that how i can insert in database User Registration Form Using JSP(JspBeans) after that how i can insert in database

can we write a method in JSP - JSP-Servlet
that second jsp file to avoid code rewriting. how can I do this please help me out... to call another second jsp file. I can do it by redirecting my first jsp file... for execution) of first jsp file by redirecting second page to the first page. I can call

how can i send a mail to a particular user from a many user dropdown list in jsp
how can i send a mail to a particular user from a many user dropdown list in jsp how can i a sent a user question to a particular person from a drop down list in jsp

How can I access databse through JSP. I am using postgresql-8.4.4-1-windows as database and jboss-4.0.5.GA as server.
How can I access databse through JSP. I am using postgresql-8.4.4-1-windows as database and jboss-4.0.5.GA as server. I am using postgresql-8.4.4-1... netbeans-6.1-ml-windows.How can I set up connection to database? Please help me

How to connect to MySQL in JSP?
How to connect to MySQL in JSP? How to connect to MySQL in JSP..., You can use the Java JDBC code to connect to MySQL database in JSP page. Check the tutorial: Connect JSP with mysql Thanks

How to call servlet in JSP?
How to call servlet in JSP? How to call servlet in JSP

how can i use one dbase conection in serveral pages - JSP-Servlet
how can i use one dbase conection in serveral pages Hi! Thanks for sending code... But my actual requirement is In my project i am writing dbase connections many times whereever i need in several pages. How can I avoid

Can not find "org.apache.poi " - JSP-Servlet
Can not find "org.apache.poi " Hi friend, Thanks... an error message that "org.apache.poi " can not be resolved. I have search it form net but i m unable to download the jar file. So can u help me to do

How to use ajax in jsp?
How to use ajax in jsp? Hi, How i can access the server-side data in JSP using the Ajax? Thanks Hi, You can use the Ajax code to access the server side data from JSP page. Check the tutorial Combo Box Using Ajax

How to break statement in JSP
How to break statement in JSP Hi, I am writing JSP page and there is for loop inside it. How to break statement in JSP? Thanks Hi, I JSP you can use the break statement to break a loop. Here is simple example

how to pass an array from one jsp to another jsp - JSP-Servlet
how to pass an array from one jsp to another jsp hi friedns, can any One tell me how to send an array from one jsp to another jsp,pls any one send the code for this.also porvid the code how to retrive the arry in another jsp

How to make first JSP page?
How to make first JSP page? Hello, How I can make first JSP page? Thanks

can i remopve a jsp web page - JSP-Interview Questions
can i remopve a jsp web page Dear, I ask you a question BUT you do noit answer me: My question Can I remove .jsp and the program still working because it generates .class file. Regards

how to make exampage in jsp ?
how to make exampage in jsp ? how to make a online exam page in jsp and servelet

How to display date in JSP?
How to display date in JSP? How to create a simple JSP program which displays date on the page? Thanks

How to Open JSP?
How to Open JSP? In this section you learn How to Open JSP in text editor. The JSP... can easily edit the JSP file.ADS_TO_REPLACE_2 Other text editors to open

how to call jsp from flex
how to call jsp from flex hi, i want to know that how can i call a FLEX from JSP. . A good Example will be appreciated

how to set the values in jsp
how to set the values in jsp how to set the values text boxs in jsp frm dbase via servlet

How to connect mysql with jsp
How to connect mysql with jsp how to connect jsp with mysql while using apache tomcat

How to make first JSP page?
How to make first JSP page? Hello, How I can make first JSP page? Thanks HI, Beginner can learn JSP from writing the first Program. You can do it manually by creating a web application and then write jsp page

Can JSP using apachi POI handle the very complicated JSP?
Can JSP using apachi POI handle the very complicated JSP? Can the following jsp handle the very complicated excel: such as, multiple sheet, tree structure, with chart in the excell file, etc. <%@page import="java.io.*"%>

how to deploy and run jsp - JSP-Servlet
how to deploy and run jsp hi anybody plz tell how to deploy and run jsp. and where jsp and html files save in web-inf or any where? Hi...- WEB-INF-classes | | root web.xml You save the jsp or html

How to access the database from JSP?
How to access the database from JSP? Hi, What is the process of accessing the database from JSP page? Thanks Hi, In the JSP program... database from JSP which explains you how to access the database by embedding

How to compile and run the JSP
How to compile and run the JSP Hi Kindly tell me how to run and compile JSP small Program using Tomcat as webserver. I created small program HELLO JSP in HTML and compile the program but it is saying Class o r interface

How To Include Two Jsp page in another jsp page?
How To Include Two Jsp page in another jsp page? I use following code to Include Two Jsp Page Header and footer <%@include file="header.jsp... in page How can i Display at correct position? Please visit

How to display date in JSP?
How to display date in JSP? How to create a simple JSP program which displays date on the page? Thanks Hi, You should import...() %> Check complete tutorial at How to Create JSP Page? Thanks

how to run jdbc in jsp program - JSP-Servlet
how to run jdbc in jsp program i want to use sql server 2005 in jsp program to store data.i know how to run simple program but this program i tried... visit the following links: http://www.roseindia.net/jsp/submit-comments

how to use iframe in jsp - JSP-Servlet
how to use iframe in jsp Hi, i am using a jsp page in whic records... links which point to error. jsp an another jsp when i click the link a new page is opened.however i require to open it in the parent jsp help me please

How to save value in JSP
324 2012-12-12 save i want to save dis value jsp to action ...how can i get all value ..and store..how can its values goes...How to save value in JSP Employee Name Time-IN Time-OUT

How to Work - JSP-Servlet
How to Work Respected sir i am ramesh doing final year MCA.Now i am doing final year project using java,jsp,servlet.i only know java.i want details about where we save the jsp and servlet file and how we link with java.send one

how to call a java class in jsp - JSP-Servlet
how to call a java class in jsp hi.. friends iam new to roseindia.i... : Example of Extends Attribute of page Directive in JSP...(){ return "Roseindia.net"; } } For more information on JSP visit to : http

how to call a java class in jsp - JSP-Servlet
how to call a java class in jsp hi.. friends iam new to roseindia.i... : Example of Extends Attribute of page Directive in JSP... on JSP visit to : http://www.roseindia.net/jsp/ImportAttribute.shtml

How to use contentType Attribute in JSP?
How to use contentType Attribute in JSP? Hi, I am learning JSP and now trying to use the contentType Attribute in JSP. tell me how to use the contentType Attribute in JSP? Thanks

after entering details in reg page,n enter the submit button,how can v store the data in db, n hw can v retrive the data frm db in jsp
after entering details in reg page,n enter the submit button,how can v store the data in db, n hw can v retrive the data frm db in jsp i ve creted... the submit button,how can v store the data in db, n hw can v retrive the data frm

how call ireports in jsp
how call ireports in jsp please send me code any one for calling ireports in servlet-jsp program i am trying to call the ireports in servlet and jsp error is occurred exception: javax.servlet.ServletException

how to convert jsp to exe
how to convert jsp to exe hello sir, i am doing webapplication. the configuration is windows xp operating system,IE6.0,apache tomcat5.0,j2se5.0 and jsp,servlets i am using.this is doing in localhost only. now i want

Can Login on Fedora, cannot on Windows- JSP/Servlet for login
Can Login on Fedora, cannot on Windows- JSP/Servlet for login I am using JSP and Servlet to perform login. When I host the website and test it works...) clients cannot login to the website. How can I fix this? Please help....

how can manages recordset in jsp

Questions by Category