Hi friends,
Please help me to solve a problem in servlets . I am creating a program to retrieve records from database . I want to display first 5 records , then on clicking the next button the page should show me next 5 records and so on .
I have tried the program using servletContext . The program is working but on refreshing the page it is showing me the next 5 records . How can i stop this so that only clicking the next button it should show me the next 5 records . Please Help.
Following is the Program :
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
import java.io.*;
import java.net.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class page1 extends HttpServlet {
ServletContext obj = null;
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
obj = getServletContext();
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
int x=0;
try
{
Object o = getServletContext().getAttribute("database");
Connection con=null;
Statement stmt=null;
ResultSet rs=null;
if(o==null)
{
DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
con = DriverManager.getConnection("jdbc:odbc:dsn98");
stmt = con.createStatement();
rs = stmt.executeQuery("select * from table2");
}
else
{
rs = (ResultSet)o;
}
out.println("<form method=GET action=page1 name=f>");
out.println("<table border=5 align=center>");
out.println("<tr><th>ROLLNO</th></tr>");
while(rs.next())
{
int rollno = rs.getInt(1);
out.println("<tr><td>"+rollno+"</td></tr>");
x++;
if(x%5==0)
{
obj.setAttribute("database",rs);
break;
}
}
out.println("</table>");
out.println("<input type=submit value=next name=submit1>");
out.println("</form>");
}
catch(Exception e){}
out.close();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
public String getServletInfo() {
return "Short description";
}
}
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------