Hi Friend,

By retrieving the number of rows from the database table, you will come to know about the filled seats. If seats exceed 60, then display the message that 'ADMISSION FULL'.

Here is an example.

import java.sql.*;
import java.awt.*;
import java.util.*;
import javax.swing.*;
import java.awt.event.*;

class StudentAdmissionForm{
JTextField txt;
public static void main(String[] args) throws Exception{
StudentAdmissionForm sf=new StudentAdmissionForm();
}
public StudentAdmissionForm(){
final JFrame f = new JFrame("Student Admission Form");
f.getContentPane().setLayout(null);
JLabel lbl1 = new JLabel("Name");
JTextField jt1=new JTextField(15);
JLabel lbl2 = new JLabel("Address");
JTextField jt2=new JTextField(15);
JLabel lbl3 = new JLabel("Gender");
txt=new JTextField();

JRadioButton Male,Female;
ButtonGroup radioGroup=new ButtonGroup();
Male=new JRadioButton("Male");
radioGroup.add(Male);
Female=new JRadioButton("Female");
radioGroup.add(Female);
Male.addActionListener(al);
Female.addActionListener(al);
JLabel lbl4=new JLabel("Date Of Birth");
JComboBox combo1=new JComboBox();
JComboBox combo2=new JComboBox();
JComboBox combo3=new JComboBox();
for(int i=1;i<=31;i++){
combo1.addItem(i);
}
for(int i=1;i<=12;i++){
combo2.addItem(i);
}
for(int i=1980;i<=2010;i++){
combo3.addItem(i);
}
JLabel lbl5=new JLabel("Contact No");
JTextField jt3=new JTextField(15);
JButton button=new JButton("Store");

lbl1.setBounds(50,50,70,30);
lbl2.setBounds(50,80,70,30);
lbl3.setBounds(50,110,70,30);
lbl4.setBounds(50,140,100,30);
lbl5.setBounds(50,170,100,30);
jt1.setBounds(170,50,200,25);
jt2.setBounds(170,80,200,25);
Male.setBounds(170,110,100,30);
Female.setBounds(270,110,100,30);
combo1.setBounds(170,140,50,25);
combo2.setBounds(270,140,50,25);
combo3.setBounds(370,140,80,25);
jt3.setBounds(170,170,200,25);
txt.setBounds(50,210,70,30);
button.setBounds(170,200,80,25);

f.add(lbl1);
f.add(lbl2);
f.add(lbl3);
f.add(lbl4);
f.add(lbl5);
f.add(jt1);
f.add(jt2);
f.add(jt3);
f.add(combo1);
f.add(combo2);
f.add(combo3);
f.add(Male);
f.add(Female);
f.add(button);
f.add(txt);
txt.setVisible(false);

button.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
try{
int count=0;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:access");
Statement st=con.createStatement();
ResultSet res = st.executeQuery("SELECT COUNT(*) FROM Register");
while (res.next()){
count = res.getInt(1);
}
if(count>60){
JOptionPane.showMessageDialog(null,"Admission Full");
f.setEnabled(false);
}
else{
//--------------------insert condition---------------------
}
}
catch(Exception ex){}
}
});
f.setSize(1000,1000);
f.setVisible(true);
f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}
private ActionListener al = new ActionListener() {
public void actionPerformed(ActionEvent e) {
txt.setText(((JRadioButton) e.getSource()).getText());
}
};
}

Thanks