Hi, I am writing this servlet to display the first N records and two
buttons (Next and Previous), only Next button is working fine, but the
Previous button is not, I know theat my implementation for Previous button
is not correct, please take a look to this servlet and tell me what's wrong
with Previous button.
Thanks,
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class TempServlet extends HttpServlet {
public void doGet(HttpServletRequest req, HttpServletResponse res)throws
ServletException, IOException {
res.setContentType("text/html");
PrintWriter out= res.getWriter();
ResultSet resultSet;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:data", "","");
Statement
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
resultSet=stmt.executeQuery("SELECT * FROM employee ");
out.println("<form name=form action=TempServlet>");
out.println("<center> <b> The Result Are </b> </center>");
out.println("<table border=1>");
int j=0;
int val=0;
System.out.println(req.getParameter("value"));
if(req.getParameter("value")==null){
j=0;
val=3;
}else {
// this is when we are using Next button
if (req.getParameter("bsubmit").equals("next"))
{
j=Integer.parseInt(req.getParameter("value"));
val=Integer.parseInt(req.getParameter("incrementValue"))+ 3;
}
// this is when we are using Previous button
if (req.getParameter("bsubmit").equals("previous"))
{
j=Integer.parseInt(req.getParameter("value")) - 6;
val=Integer.parseInt(req.getParameter("incrementValue"))- 3;
}
resultSet.absolute(j);
}
System.out.println("The value of J is : " +j + " the Value is :" +val);
while(resultSet.next()){
if(j<val){
out.println("<tr><td>"+j+"</td><td>"+resultSet.getString(2)+"</td></tr>");
}else {
break;
}
j++;
}
out.println("<input type=hidden name=value value="+j+">");
out.println("<input type=hidden name=incrementValue value="+val+">");
}catch(ClassNotFoundException cnf){
System.out.println("Class not found " +cnf);
}catch(SQLException sqe){
System.out.println("Sql Exception " +sqe);
}
out.println("<INPUT type=submit name=\"bsubmit\" value=\"next\">");
out.println("<INPUT type=submit name=\"bsubmit\" value=\"previous\">");
// out.println("<input type=submit value=Next>");
out.println("</form>");
}
}
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
