Hi Friend,

1)Insert Date

import java.sql.*;
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.text.*;
class InsertDate extends JFrame{

InsertDate(){
JLabel l=new JLabel("Enter Date (dd/MM/yyyy):");
final JTextField text=new JTextField(15);
JButton b=new JButton("Insert");
JPanel p=new JPanel(new GridLayout(2,2));
p.add(l);
p.add(text);
p.add(b);
b.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ae){
String date=text.getText();
if(isValidDate(date)){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:access");
PreparedStatement ps = con.prepareStatement("INSERT INTO InsertDate(ID,lastDate) VALUES(?,?)");
ps.setString(1,"8");
ps.setString(2,date);
ps.executeUpdate();
System.out.println("inserted");
}
catch(Exception e){
System.out.println(e);
}
}
}
});
add(p);
setVisible(true);
pack();
}
public boolean isValidDate(String inDate) {

if (inDate == null)
return false;
SimpleDateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy");
dateFormat.setLenient(false);
try {
dateFormat.parse(inDate.trim());
}
catch (ParseException pe) {
return false;
}
return true;
}

public static void main(String[] args){
InsertDate insert=new InsertDate();
}
}

2)Check Status

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

class CheckStatus{
public static void main(String[] args) {
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:access");
Statement st = con.createStatement();
ResultSet rs=st.executeQuery("Select lastDate from InsertDate where id='8'");
String ld="";
if(rs.next()){
ld=rs.getString("lastDate");
}

String lastDate=ld.substring(0,10);
System.out.println(lastDate);
java.util.Date d = new java.util.Date();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
String todayDate=sdf.format(d);
System.out.println(todayDate);
java.util.Date date1 = sdf.parse(lastDate);
java.util.Date date2 = sdf.parse(todayDate);
if(date1.equals(date2)){
JOptionPane.showMessageDialog(null,"Today is Last date of Admission ");
}
else if (date1.before(date2)){
JOptionPane.showMessageDialog(null,"Admission is Over");
}
}
catch(Exception e){
System.out.println(e);
}
}
}

Thanks