JTable Pagination in Java JDBC and MySQL Database

Here we will see how to develop JTable Pagination in java.

We will use JDBC prepared statement and MySQL Database.

We used NetBeans IDE and Jdk 1.8 to develop this project.

Our Project Structure is as below

To develop this project we used Book Example.

Project Development Steps are

Create table in MySQL Database
SetUp Pagination Project
Create Model (Pojo) Class
Create a DAO class to Perform JDBC Operations
Create Frame to show data in JPanel
Implement Pagination Concepts.

1 Create Table in MySQL Database

We created ebhor database and table called book as below

CREATE TABLE book(
     id        BIGINT(20) UNSIGNED NOT NULL auto_increment,
     name      VARCHAR(200),
     author    VARCHAR(10),
     publication VARCHAR(100),
     add_date   TIMESTAMP DEFAULT CURRENT_TIMESTAMP(),
     PRIMARY KEY (id),
     UNIQUE KEY (name)
  )
engine=innodb
DEFAULT charset=utf8;

CREATE TABLE book(

id BIGINT(20) UNSIGNED NOT NULL auto_increment,

name VARCHAR(200),

author VARCHAR(10),

publication VARCHAR(100),

add_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP(),

PRIMARY KEY (id),

UNIQUE KEY (name)

)

engine=innodb

DEFAULT charset=utf8;

Inserted 100 records on it.

You can use any “MySQL Data Generator like generatedata.com generate 100 rows or as many as you want.

Fig: How to import data in MySQL database

In above figure screen when you scroll down you will find Go button click on it.

Go to browse to see data in table .

After uploading data check you data by clicking on browse in PHPMyAdmin.

Browse the PhpMyAdmin database — Fig: Browse the Book table

Book table created and 100 Records are uploaded in table.

2. SetUp Pagination Project

Create a new Java Project in Netbeans IDE

Select Java in categories and Java Applications in Project.

Provide name “Pagination” to your project

Click on Use Dedicated Folder for Storing Libraries.

How to assign Project Name in NetBeans — Fig: Assign Project Name in NetBeans

Now at left side on project explorer

click on Pagination Project.

there create packages

ebhor.model ebhor.dao ebhor.frame ebhor.pagination

Now right click on library and and click on menu Add Jar/Folder…

Now include mysql-connector-java-5.1.14-bin.jar Jar file

How to add mysql-connector-java-5.1.14-bin.jar in NetBean IDE — Fig: Adding mysql-connector-java-5.1.14-bin.jar in NetBean IDE

Next we will create a Pojo class.

3 Create a Model to hold Data

Inside ebhor.model package create a POJO Class Book

Book class contains field id, name, author publication, addDate field.

All fields getter setter , constructos and toString()

Book.java

package ebhor.model;

import java.io.Serializable;
import java.sql.Timestamp;


public class Book implements Serializable{

    private long id;
    private String name;
    private String author;
    private String publication;
    private Timestamp addDate;
    
    public Book(){
        
    }

    public Book(long id, String name, String author, String publication, Timestamp addDate) {
        this.id = id;
        this.name = name;
        this.author = author;
        this.publication = publication;
        this.addDate = addDate;
    }

    @Override
    public String toString() {
        return "Book{" + "id=" + id + ", name=" + name + ", author=" + author + ", publication=" + publication + ", addDate=" + addDate + '}';
    }

    public long getId() {
        return id;
    }

    public void setId(long id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getAuthor() {
        return author;
    }

    public void setAuthor(String author) {
        this.author = author;
    }

    public String getPublication() {
        return publication;
    }

    public void setPublication(String publication) {
        this.publication = publication;
    }

    public Timestamp getAddDate() {
        return addDate;
    }

    public void setAddDate(Timestamp addDate) {
        this.addDate = addDate;
    }

}

package ebhor.model;

import java.io.Serializable;

import java.sql.Timestamp;

public class Book implements Serializable{

private long id;

private String name;

private String author;

private String publication;

private Timestamp addDate;

public Book(){

}

public Book(long id, String name, String author, String publication, Timestamp addDate) {

this.id = id;

this.name = name;

this.author = author;

this.publication = publication;

this.addDate = addDate;

}

@Override

public String toString() {

return "Book{" + "id=" + id + ", name=" + name + ", author=" + author + ", publication=" + publication + ", addDate=" + addDate + '}';

}

public long getId() {

return id;

}

public void setId(long id) {

this.id = id;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public String getAuthor() {

return author;

}

public void setAuthor(String author) {

this.author = author;

}

public String getPublication() {

return publication;

}

public void setPublication(String publication) {

this.publication = publication;

}

public Timestamp getAddDate() {

return addDate;

}

public void setAddDate(Timestamp addDate) {

this.addDate = addDate;

}

4 Create a DAO Class to Perform JDBC Operations

Here establish a connection with database.

Extracting data from database are handling .

Inside ebhor.dao following classes are there

ConnectionFactory.java

This class contains a method getConnection() creates connection with MySQL database using database username, password and database name.

getConnection() returns connection Object.

package ebhor.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class ConnectionFactory {

    public static Connection getConnection() {
        Connection c = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            c = DriverManager.getConnection("jdbc:mysql://localhost:3306/ebhor?useUnicode=true&characterEncoding=UTF-8", "ebhor_user", "21V6");
        } catch (ClassNotFoundException e) {
            System.out.println("ClassNotFoundException " + e);
        } catch (SQLException e) {
            System.out.println("SQLException " + e);
        }
        return c;
    }
}

package ebhor.dao;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

public class ConnectionFactory {

public static Connection getConnection() {

Connection c = null;

try {

Class.forName("com.mysql.jdbc.Driver");

c = DriverManager.getConnection("jdbc:mysql://localhost:3306/ebhor?useUnicode=true&characterEncoding=UTF-8", "ebhor_user", "21V6");

} catch (ClassNotFoundException e) {

System.out.println("ClassNotFoundException " + e);

} catch (SQLException e) {

System.out.println("SQLException " + e);

}

return c;

}

BookDAO.java

This class contains two methods

1 fetchBySize() – This method takes two integer arguments

start is used to select start row in book table.
size is used to select specified number of elements from start.

If you pass parameter fetchBySize(11,10) then it will select 10 records from MySQL with starting table row of 11.

Result set values are stored in DefaultTableModel Object.

DefaultTableModel value can easily represent data in JTable.

2. getRowCount() this method is used to find total number of rows in table.

package ebhor.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.table.DefaultTableModel;

public class BookDAO {

    Connection con = null;
    PreparedStatement ps = null;
    ResultSet rs = null;
    int st;//status

    public DefaultTableModel fetchBySize(int start, int size) {
        System.out.println("book frame dao");
        DefaultTableModel model = new DefaultTableModel(new String[]{"Id", "Name", "Author", "Publication",}, 0);
        con = ConnectionFactory.getConnection();
        try {
            String query = "select * from book limit " + start + "," + size;
            System.out.println(query);
            ps = con.prepareStatement(query);
            rs = ps.executeQuery();
            int i = 0;
            while (rs.next()) {
                long id = rs.getLong("id");
                String name = rs.getString("name");
                String author = rs.getString("author");
                String publication = rs.getString("publication");
                model.addRow(new Object[]{id, name, author, publication});
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                con.close();
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
        }
        return model;
    }

    public double getRowCount() {
        System.out.println("book table row count");
        con = ConnectionFactory.getConnection();
        long count = 0;
        try {
            String query = "SELECT count(*) FROM book ";
            System.out.println(query);
            ps = con.prepareStatement(query);
            rs = ps.executeQuery();
            while (rs.next()) {
                count = rs.getLong("count(*)");

            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                con.close();
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
        }
        return count;
    }
}

package ebhor.dao;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import javax.swing.table.DefaultTableModel;

public class BookDAO {

Connection con = null;

PreparedStatement ps = null;

ResultSet rs = null;

int st;//status

public DefaultTableModel fetchBySize(int start, int size) {

System.out.println("book frame dao");

DefaultTableModel model = new DefaultTableModel(new String[]{"Id", "Name", "Author", "Publication",}, 0);

con = ConnectionFactory.getConnection();

try {

String query = "select * from book limit " + start + "," + size;

System.out.println(query);

ps = con.prepareStatement(query);

rs = ps.executeQuery();

int i = 0;

while (rs.next()) {

long id = rs.getLong("id");

String name = rs.getString("name");

String author = rs.getString("author");

String publication = rs.getString("publication");

model.addRow(new Object[]{id, name, author, publication});

}

} catch (Exception e) {

e.printStackTrace();

} finally {

try {

con.close();

} catch (SQLException ex) {

ex.printStackTrace();

}

return model;

}

public double getRowCount() {

System.out.println("book table row count");

con = ConnectionFactory.getConnection();

long count = 0;

try {

String query = "SELECT count(*) FROM book ";

System.out.println(query);

ps = con.prepareStatement(query);

rs = ps.executeQuery();

while (rs.next()) {

count = rs.getLong("count(*)");

}

} catch (Exception e) {

e.printStackTrace();

} finally {

try {

con.close();

} catch (SQLException ex) {

ex.printStackTrace();

}

return count;

}

5 Create Frame to show data in JPanel

UI designing and Action handling work is done here.

BookFrame.java is created in ebhor.frame package

BookFrame.java contains following methods

1 A Default Constructor –

Here a main JPanel is created with GridLayout.

Two other JPanel is created.

tablePanel -to place JTable and pagingPanel to place Paging buttons.

Inside this getCount() and getPageData() is called.

2 getCount() –

This method work is to find book table record count by calling getRowCount() from BookDAO.java.

It also calculate the total pages for pagination based on PAGE_SIZE field.

3. getPageData() –

Work of this method is to get records from Book Table. and set it to JTable based on page number.

To update pagination details getPaginationDetails() is get called.

4 getPaginationDetails() –

This method is used to get dynamic page numbers from Pagination.java.

According to numbers it generates buttons and add actionListeners to buttons.

Also handle button disable and enable features for first and last page number.

5 ActionPerformed()-

Handle the click actions of dynamically generated buttons.

6 public static void main() –

This function is starting execution point for our program.

package ebhor.frame;
import ebhor.dao.BookDAO;
import java.awt.Color;
import java.awt.Container;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.BorderFactory;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.border.TitledBorder;
import javax.swing.table.DefaultTableModel;
public class BookFrame extends JFrame implements ActionListener {
    JTable jTable;
    Container container;
    //  JButton start, end;
    DefaultTableModel model;
    BookDAO dao = new BookDAO();
    /*used for pagination*/
    final int PAGE_SIZE = 10;
    double tableRowCount;
    int totalPages;
    int currentPage;
    int startRow;
    int numbers[];
    JButton[] buttons;
    JPanel mainPanel, tablePanel, pagingPanel;
    BookFrame() {
        System.out.println("calling bookframe");
        container = this.getContentPane();
        mainPanel = new JPanel(new GridLayout(2, 1, 30, 50)); // main panel
        mainPanel.setBorder(BorderFactory.createTitledBorder(BorderFactory.createEtchedBorder(), "Subject Lists", TitledBorder.CENTER, TitledBorder.TOP));
        //create a JTable panel
        tablePanel = new JPanel();
        DefaultTableModel dm = (DefaultTableModel) dao.fetchBySize(0, 10);
        jTable = new JTable(dm);
        tablePanel.add(new JScrollPane(jTable));
        jTable.setRowHeight(23);
        //ading table panel to main panel
        mainPanel.add(tablePanel);
        //paging button panel
        pagingPanel = new JPanel();
        buttons = new JButton[9];
        //adding paging panel to main panel
        mainPanel.add(pagingPanel);
        //adding main panel to container
        container.add(mainPanel);
        getCount();
        getPageData(1);
    }
    @Override
    public void actionPerformed(ActionEvent e) {
        System.out.println("event called" + e.getSource());
        String pageNumber = "";
        if (e.getSource() instanceof JButton) {
            if (((JButton) e.getSource()).getText().equalsIgnoreCase("Start")) {
                pageNumber = "1";
            } else if (((JButton) e.getSource()).getText().equalsIgnoreCase("End")) {
                pageNumber = totalPages + "";
            } else if (((JButton) e.getSource()).getText().equalsIgnoreCase("<<")) {
                pageNumber = (currentPage - 1) + "";
            } else if (((JButton) e.getSource()).getText().equalsIgnoreCase(">>")) {
                pageNumber = (currentPage + 1) + "";
            } else {
                pageNumber = ((JButton) e.getSource()).getText();
            }
            System.out.println("hello " + pageNumber);
            //this.repaint();
            getPageData(Integer.parseInt(pageNumber));
            getPaginationDetails();
        }
    }
    /*get total numbers of record in table*/
    public void getCount() {
        tableRowCount = dao.getRowCount();
        if (tableRowCount > 0) {
            totalPages = (int) Math.ceil(tableRowCount / PAGE_SIZE);
            currentPage = 1;
            System.out.println("row count is " + tableRowCount + "page Count" + totalPages);
        } else {
            JOptionPane.showMessageDialog(null, "No Record to display");
        }
    }
    /*Get data from table based on page no*/
    public void getPageData(int pageNo) {
        currentPage = pageNo;
        //calculate starting row for pagination
        startRow = PAGE_SIZE * (pageNo - 1);
        DefaultTableModel dm = (DefaultTableModel) dao.fetchBySize(startRow, PAGE_SIZE);
        jTable.setModel(dm);
        getPaginationDetails();
    }
    // dynamically generate page numbers 
    public void getPaginationDetails() {
        System.out.println("pagination details");
        int inc = 0;
        System.out.println(currentPage + "  " + totalPages);
        pagingPanel.removeAll();
        pagingPanel.revalidate();
        numbers = ebhor.pagination.Pagination.getPageNos(currentPage, totalPages);
        buttons[0] = new JButton("Start");
        buttons[0].addActionListener(this);
        pagingPanel.add(buttons[0]);
        buttons[1] = new JButton("<<");
        buttons[1].addActionListener(this);
        pagingPanel.add(buttons[1]);
        for (int i = 0; i < numbers.length; i++) {
            if (numbers[i] != 0) {
                buttons[i + 2] = new JButton(numbers[i] + "");
                buttons[i + 2].setBounds(500 + inc, 500, 50, 30);
                buttons[i + 2].addActionListener(this);
                pagingPanel.add(buttons[i + 2]);
                inc += 40;
            }
            if (numbers[i] == currentPage) {
                buttons[i + 2].setBackground(Color.BLUE);
                buttons[i + 2].setForeground(Color.WHITE);
            }
        }
        buttons[7] = new JButton(">>");
        buttons[7].addActionListener(this);
        pagingPanel.add(buttons[7]);
        buttons[8] = new JButton("End");
        buttons[8].addActionListener(this);
        pagingPanel.add(buttons[8]);
        /*if current page is 1 then disable start and previous button*/
        if (currentPage == 1) {
            buttons[0].setEnabled(false);
            buttons[1].setEnabled(false);
        }
        /*if current page is last then disable end and next button*/
        if (currentPage == PAGE_SIZE) {
            buttons[7].setEnabled(false);
            buttons[8].setEnabled(false);
        }
    }
    //start of execution
    public static void main(String[] args) {
        BookFrame frame = new BookFrame();
        frame.setTitle("JTable with Pagination");
        frame.setVisible(true);
        frame.pack();
        frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

package ebhor.frame;

import ebhor.dao.BookDAO;

import java.awt.Color;

import java.awt.Container;

import java.awt.GridLayout;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import javax.swing.BorderFactory;

import javax.swing.JButton;

import javax.swing.JFrame;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.JScrollPane;

import javax.swing.JTable;

import javax.swing.border.TitledBorder;

import javax.swing.table.DefaultTableModel;

public class BookFrame extends JFrame implements ActionListener {

JTable jTable;

Container container;

// JButton start, end;

DefaultTableModel model;

BookDAO dao = new BookDAO();

/*used for pagination*/

final int PAGE_SIZE = 10;

double tableRowCount;

int totalPages;

int currentPage;

int startRow;

int numbers[];

JButton[] buttons;

JPanel mainPanel, tablePanel, pagingPanel;

BookFrame() {

System.out.println("calling bookframe");

container = this.getContentPane();

mainPanel = new JPanel(new GridLayout(2, 1, 30, 50)); // main panel

mainPanel.setBorder(BorderFactory.createTitledBorder(BorderFactory.createEtchedBorder(), "Subject Lists", TitledBorder.CENTER, TitledBorder.TOP));

//create a JTable panel

tablePanel = new JPanel();

DefaultTableModel dm = (DefaultTableModel) dao.fetchBySize(0, 10);

jTable = new JTable(dm);

tablePanel.add(new JScrollPane(jTable));

jTable.setRowHeight(23);

//ading table panel to main panel

mainPanel.add(tablePanel);

//paging button panel

pagingPanel = new JPanel();

buttons = new JButton[9];

//adding paging panel to main panel

mainPanel.add(pagingPanel);

//adding main panel to container

container.add(mainPanel);

getCount();

getPageData(1);

}

@Override

public void actionPerformed(ActionEvent e) {

System.out.println("event called" + e.getSource());

String pageNumber = "";

if (e.getSource() instanceof JButton) {

if (((JButton) e.getSource()).getText().equalsIgnoreCase("Start")) {

pageNumber = "1";

} else if (((JButton) e.getSource()).getText().equalsIgnoreCase("End")) {

pageNumber = totalPages + "";

} else if (((JButton) e.getSource()).getText().equalsIgnoreCase("<<")) {

pageNumber = (currentPage - 1) + "";

} else if (((JButton) e.getSource()).getText().equalsIgnoreCase(">>")) {

pageNumber = (currentPage + 1) + "";

} else {

pageNumber = ((JButton) e.getSource()).getText();

}

System.out.println("hello " + pageNumber);

//this.repaint();

getPageData(Integer.parseInt(pageNumber));

getPaginationDetails();

}

/*get total numbers of record in table*/

public void getCount() {

tableRowCount = dao.getRowCount();

if (tableRowCount > 0) {

totalPages = (int) Math.ceil(tableRowCount / PAGE_SIZE);

currentPage = 1;

System.out.println("row count is " + tableRowCount + "page Count" + totalPages);

} else {

JOptionPane.showMessageDialog(null, "No Record to display");

}

/*Get data from table based on page no*/

public void getPageData(int pageNo) {

currentPage = pageNo;

//calculate starting row for pagination

startRow = PAGE_SIZE * (pageNo - 1);

DefaultTableModel dm = (DefaultTableModel) dao.fetchBySize(startRow, PAGE_SIZE);

jTable.setModel(dm);

getPaginationDetails();

}

// dynamically generate page numbers

public void getPaginationDetails() {

System.out.println("pagination details");

int inc = 0;

System.out.println(currentPage + " " + totalPages);

pagingPanel.removeAll();

pagingPanel.revalidate();

numbers = ebhor.pagination.Pagination.getPageNos(currentPage, totalPages);

buttons[0] = new JButton("Start");

buttons[0].addActionListener(this);

pagingPanel.add(buttons[0]);

buttons[1] = new JButton("<<");

buttons[1].addActionListener(this);

pagingPanel.add(buttons[1]);

for (int i = 0; i < numbers.length; i++) {

if (numbers[i] != 0) {

buttons[i + 2] = new JButton(numbers[i] + "");

buttons[i + 2].setBounds(500 + inc, 500, 50, 30);

buttons[i + 2].addActionListener(this);

pagingPanel.add(buttons[i + 2]);

inc += 40;

}

if (numbers[i] == currentPage) {

buttons[i + 2].setBackground(Color.BLUE);

buttons[i + 2].setForeground(Color.WHITE);

}

buttons[7] = new JButton(">>");

buttons[7].addActionListener(this);

pagingPanel.add(buttons[7]);

buttons[8] = new JButton("End");

buttons[8].addActionListener(this);

pagingPanel.add(buttons[8]);

/*if current page is 1 then disable start and previous button*/

if (currentPage == 1) {

buttons[0].setEnabled(false);

buttons[1].setEnabled(false);

}

/*if current page is last then disable end and next button*/

if (currentPage == PAGE_SIZE) {

buttons[7].setEnabled(false);

buttons[8].setEnabled(false);

}

//start of execution

public static void main(String[] args) {

BookFrame frame = new BookFrame();

frame.setTitle("JTable with Pagination");

frame.setVisible(true);

frame.pack();

frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

}

6 Implement Pagination Concepts

ebhor.pagination.Pagination class is created to implement pagination concept.

public static int[] getPageNos(int currentPage, int totalPages) is used to implement pagination concept.

it takes two argument currentPage and totalPages to get next set of page numbers and return integer array.

Pagination.java

package ebhor.pagination;
public class Pagination {
    public static int[] getPageNos(int currentPage, int totalPages) {
        int[] pages = new int[5];
        if (currentPage <= 2) {
            System.out.println("currentPage <=2");
            if (totalPages >= 5) {
                System.out.println("if");
                for (int i = 0; i <= 4; i++) {
                    pages[i] = i + 1;
                }
            } else {
                System.out.println("else");
                for (int i = 0; i < totalPages; i++) {
                    pages[i] = i + 1;
                }
            }
        } else if (currentPage == totalPages) {
            System.out.println("currentPage == totalPages");
            if (totalPages >= 5) {
                System.out.println("if");
                int j = 4;
                for (int i = 0; i <= 4; i++) {
                    pages[i] = currentPage - j--;
                }
            } else {
                System.out.println("else");
                int j = 3;
                for (int i = 0; i <= totalPages; i++) {
                    pages[i] = currentPage - j--;
                }
            }
        } else if ((currentPage - 2) >= 1 && (currentPage + 2) <= totalPages) {
            System.out.println("((currentPage - 2) >= 1 && (currentPage + 2) <= totalPages)");
            for (int i = 0; i <= 4; i++) {
                pages[i] = currentPage - 2 + i;
            }
        } else if (currentPage == totalPages - 1) {
            System.out.println("currentPage == totalPages - 1");
            for (int i = 0; i <= 4; i++) {
                pages[i] = currentPage - 3 + i;
            }
        }
        return pages;
    }
}

package ebhor.pagination;

public class Pagination {

public static int[] getPageNos(int currentPage, int totalPages) {

int[] pages = new int[5];

if (currentPage <= 2) {

System.out.println("currentPage <=2");

if (totalPages >= 5) {

System.out.println("if");

for (int i = 0; i <= 4; i++) {

pages[i] = i + 1;

}

} else {

System.out.println("else");

for (int i = 0; i < totalPages; i++) {

pages[i] = i + 1;

}

} else if (currentPage == totalPages) {

System.out.println("currentPage == totalPages");

if (totalPages >= 5) {

System.out.println("if");

int j = 4;

for (int i = 0; i <= 4; i++) {

pages[i] = currentPage - j--;

}

} else {

System.out.println("else");

int j = 3;

for (int i = 0; i <= totalPages; i++) {

pages[i] = currentPage - j--;

}

} else if ((currentPage - 2) >= 1 && (currentPage + 2) <= totalPages) {

System.out.println("((currentPage - 2) >= 1 && (currentPage + 2) <= totalPages)");

for (int i = 0; i <= 4; i++) {

pages[i] = currentPage - 2 + i;

}

} else if (currentPage == totalPages - 1) {

System.out.println("currentPage == totalPages - 1");

for (int i = 0; i <= 4; i++) {

pages[i] = currentPage - 3 + i;

}

return pages;

}

Pagination Download

1 Create Table in MySQL Database

2. SetUp Pagination Project

3 Create a Model to hold Data

4 Create a DAO Class to Perform JDBC Operations

5 Create Frame to show data in JPanel

6 Implement Pagination Concepts

Read More