ViewBooks.java

package BookClasses;

import AdminClasses.AdminLoged;
import DbClasses.DB;
import UserClasses.UserLoged;


import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;

public class ViewBooks extends JFrame {

    public JTable table;
    static JFrame frame;



    public static void main(String [] args)
    {

        EventQueue.invokeLater(new Runnable(){

            public void run()
            {
                try{
                    frame = new ViewBooks();
                    frame.setVisible(true);
                }catch (Exception e)
                {
                    e.printStackTrace();
                }
            }
        });
    }

    public ViewBooks() {
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        setBounds(180, 80, 990, 550);
        setTitle("Library Book Database");

        String[][] data = null;
        String[] column = null;

        try {

            Connection con = DB.getConnection();

            PreparedStatement ps = con.prepareStatement("select * from books", ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);


            ResultSet rs = ps.executeQuery();

            ResultSetMetaData rsmd = rs.getMetaData();

            int cols = rsmd.getColumnCount();
            column = new String[cols];

            for (int i = 1; i <= cols; i++) {
                column[i - 1] = rsmd.getColumnName(i);
            }



            if (!rs.next()) {
                System.out.println("No data in the result set.");
            } else {
                rs.last();

                int rows = rs.getRow();
                rs.beforeFirst();

                data = new String[rows][cols];
                int count = 0;

                while (rs.next()) {
                    for (int i = 1; i <= cols; i++) {
                        data[count][i - 1] = rs.getString(i);
                    }
                    count++;
                }
            }
            con.close();

        } catch (Exception e) {
            System.out.println(e);
        }

        JButton btnback = new JButton("Back");
        btnback.setBounds(750, 468, 120, 40);
        btnback.setBackground(Color.GRAY);
        add(btnback);
        btnback.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                UserLoged.main(new String[]{});
                frame.dispose();

            }
        });

        if (column != null && data != null) {
            table = new JTable(data, column);
            table.setBackground(Color.yellow);
            JScrollPane sp = new JScrollPane(table);

            add(sp);

        } else {
            // Handle the case where columnNames is null (result set is empty)
            System.out.println("No columns to display.");
        }
    }
}