Hurry! Try our new Interactive Courses for FREE. 🥳   🚀

Pagination Example


When we have large numbers of records which can note be displayed on a single page. Then we use the concept of Pagination. It helps use to display limited number of records in a single page. Below is an example of pagination.

For creating this example below is the directory structure of the program:

pagination

pStud.html

	
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<a href="PageViewServlet?page=1">View Student</a> 
</body>
</html>
	

PageViewServlet.java

	
package com.app.studytonight;
import java.io.IOException;  
import java.io.PrintWriter;  
import java.util.List;  
import javax.servlet.ServletException;  
import javax.servlet.annotation.WebServlet;  
import javax.servlet.http.HttpServlet;  
import javax.servlet.http.HttpServletRequest;  
import javax.servlet.http.HttpServletResponse;  
  
@WebServlet("/PageViewServlet")  
public class PageViewServlet extends HttpServlet {  
    private static final long serialVersionUID = 1L;  
    protected void doGet(HttpServletRequest request1, HttpServletResponse response1) throws ServletException, IOException 
    {  
        response1.setContentType("text/html");  
        PrintWriter out=response1.getWriter();  
        String spageid1=request1.getParameter("page");  
        int pageid1=Integer.parseInt(spageid1);  
        int total1=5;  
        if(pageid1==1){}  
        else{  
            pageid1=pageid1-1;  
            pageid1=pageid1*total1+1;  
        }  
        List<pStudGetSet> list=StudDao.getRecords(pageid1,total1);  
  
        out.print("<h1>studytonight Page No: "+spageid1+"</h1>");  
        out.print("<table border='1' cellpadding='4' width='60%'>");  
        out.print("<tr><th>Id</th><th>Name</th><th>Age</th><th>City</th></tr>");  
        for(pStudGetSet e1:list){  
            out.print("<tr><td>"+e1.getId1()+"</td><td>"+e1.getName1()+"</td><td>"+e1.getAge1()+"</td></td>"+e1.getCity1()+"</td></tr>");  
        }  
        out.print("</table>");  
          
        out.print("<a href='PageViewServlet?page=1'>1</a> ");  
        out.print("<a href='PageViewServlet?page=2'>2</a> ");  
        out.print("<a href='PageViewServlet?page=3'>3</a> ");  
          
        out.close();  
    }  
}  
	

pStudGetSet.java

	
package com.app.studytonight;

public class pStudGetSet { 
private int id1;  
private String name1, age1, city1;
public int getId1() {
	return id1;
}
public void setId1(int id1) {
	this.id1 = id1;
}
public String getName1() {
	return name1;
}
public void setName1(String name1) {
	this.name1 = name1;
}
public String getAge1() {
	return age1;
}
public void setAge1(String age1) {
	this.age1 = age1;
}
public String getCity1() {
	return city1;
}
public void setCity1(String city1) {
	this.city1 = city1;
}
	

StudDao.java

	
package com.app.studytonight; 
import java.sql.*;  
import java.util.ArrayList;  
import java.util.List;  
public class StudDao {  
  
    public static Connection getConnection(){  
        Connection con1=null;  
        try{  
            Class.forName("com.mysql.jdbc.Driver");  
            con1=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","System","oracle");  
        }
        catch(Exception e)
        {
        	System.out.println(e);
        }  
        return con1;  
    }  
  
    public static List<pStudGetSet> getRecords(int start1,int total1){  
        List<pStudGetSet> list=new ArrayList<pStudGetSet>();  
        try{  
            Connection con1=getConnection();  
            PreparedStatement ps1=con1.prepareStatement("select * from student limit "+(start1-1)+","+total1);  
            ResultSet rs1=ps1.executeQuery();  
            while(rs1.next()){  
            	pStudGetSet e1=new pStudGetSet();  
                e1.setId1(rs1.getInt(1));  
                e1.setName1(rs1.getString(2));  
                e1.setAge1(rs1.getString(3));  
                e1.setCity1(rs1.getString(4)); 
                list.add(e1);  
            }  
            con1.close();  
        }catch(Exception e){System.out.println(e);}  
        return list;  
    }  
}  
	

pagination pagination pagination pagination