public void actionPerformed(ActionEvent e) {
int k = 0;
try {
rs = statement.executeQuery("select * from hostelStatus");
while (rs.next()) {
data[k][0] = rs.getString(1);
data[k][1] = rs.getString(2);
data[k][2] = rs.getString(3);
k++;
}
data[k][0] = " ";
data[k][1] = " ";
data[k][2] = " ";
table = new JTable(data, col);
table.setFont(new Font("Serif", Font.BOLD, 16));
table.setBackground(new Color(250, 250, 250));
JScrollPane jsp = new JScrollPane(table);
jsp.setHorizontalScrollBarPolicy(JScrollPane.HORIZONTAL_SCROLLBAR_NEVER);
jsp.setBounds(5, 100, 590, 200);
cn.add(jsp);
} catch (Exception sq) {
JOptionPane.showMessageDialog(null, "error" + sq);
}
}
public hostelStatus() {
setTitle("Hostel");
connect();
updateRecord();
JFrame fr = new JFrame();
Toolkit tkt = fr.getToolkit();
Dimension frsize = tkt.getScreenSize();
setBounds(frsize.width / 4, frsize.height / 12, frsize.width / 2, frsize.height / 8);
setLayout(null);
cn = getContentPane();
cn.setBackground(new Color(190, 180, 170));
setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
tl = new JLabel("Current Hostels Status");
tl.setFont(new Font("Engravers MT", 1, 25));
tl.setForeground(new Color(247, 251, 249));
p1 = new JPanel();
p1.setBounds(0, 0, 600, 50);
p1.add(tl);
p1.setBackground(new Color(31, 88, 166));
cn.add(p1);
b1 = new JButton("LOAD");
b1.setMnemonic('L');
b1.addActionListener(new dispListener());
b1.setBounds(230, 320, 120, 30);
b2 = new JButton("EXIT");
b2.setMnemonic('X');
b2.addActionListener(new exitListener());
b2.setBounds(350, 320, 100, 30);
cn.add(b1);
cn.add(b2);
table = new JTable(data, col);
table.setFont(new Font("Serif", Font.BOLD, 16));
table.setBackground(new Color(250, 250, 250));
table.setEnabled(false);
JScrollPane jsp = new JScrollPane(table);
jsp.setHorizontalScrollBarPolicy(JScrollPane.HORIZONTAL_SCROLLBAR_NEVER);
jsp.setBounds(5, 100, 590, 200);
cn.add(jsp);
screensize = Toolkit.getDefaultToolkit().getScreenSize();
setSize(600, 400);
setVisible(true);
setVisible(true);
setResizable(true);
connect();
}
