list_customers.java

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

package chemist_shop;
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;

public class list_customers extends JFrame implements ActionListener
{
    JTable j1;
    JButton b1;
    String h[]={"Customer ID", "Name", "Date", "Age"};
    String d[][]=new String[15][4];
    int i=0, j=0;
    public list_customers()
    {
        super("Users");
        setSize(1000, 1000);
        setLocation(150, 150);
        try
        {
            String q = "SELECT * FROM CUSTOMER";
            conn c2 = new conn();
            ResultSet rs = c2.s.executeQuery(q);
            while(rs.next())
            {
                d[i][j++]=rs.getString("CUSTOMER_ID");
                d[i][j++]=rs.getString("NAME");
                d[i][j++]=rs.getString("START_DATE");
                d[i][j]=rs.getString("AGE");
                i++;
                j=0;
            }
            j1 = new JTable(d, h);
        }
        catch(Exception e){}
        b1 = new JButton("Print");
        add(b1, "South");
        JScrollPane s1 = new JScrollPane(j1);
        add(s1);
        b1.addActionListener(this);
    }
    public void actionPerformed(ActionEvent ae)
    {
        try
        {
            j1.print();
        }
        catch(Exception e){}
    }
    public static void main(String s[])
    {
        new list_customers().setVisible(true);
    }
    
}