ViewIssuedBook.java

package BookClasses;

import AdminClasses.AdminLoged;
import DbClasses.DB;

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;

import javax.swing.*;

public class ViewIssuedBook extends JFrame{


    static ViewIssuedBook frame;
    private  JTable table ;

    public static void main(String []args)
    {
        EventQueue.invokeLater(new Runnable() {
            @Override
            public void run() {

                try{

                    frame = new ViewIssuedBook();
                    frame.setVisible(true);
                }catch (Exception e)
                {
                    e.printStackTrace();
                }
            }
        });

    }


    public ViewIssuedBook()
    {
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        setBounds(200,80,880,550);
        setTitle("Issued Books Database");

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


        try{
            Connection con = DB.getConnection();

            PreparedStatement ps = con.prepareStatement("select * from issuebooks", 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);
            }

            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(720,430,100,40);
        add(btnback);
        btnback.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                AdminLoged.main(new String[]{});
                frame.dispose();

            }
        });

        table = new JTable(data, column);
        JScrollPane sp = new JScrollPane(table);
        table.setBackground(Color.orange);
        add(sp);
    }
}