About java and JDBC

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

class DatePicker {
    int month = java.util.Calendar.getInstance().get(java.util.Calendar.MONTH);
    int year = java.util.Calendar.getInstance().get(java.util.Calendar.YEAR);;
    JLabel l = new JLabel("", JLabel.CENTER);
    String day = "";
    JDialog d;
    JButton[] button = new JButton[49];

    public DatePicker(JFrame parent) {
        d = new JDialog();
        d.setModal(true);
        String[] header = { "Sun", "Mon", "Tue", "Wed", "Thur", "Fri", "Sat" };
        JPanel p1 = new JPanel(new GridLayout(7, 7));
        p1.setPreferredSize(new Dimension(430, 120));

        for (int x = 0; x < button.length; x++) {
            final int selection = x;
            button[x] = new JButton();
            button[x].setFocusPainted(false);
            button[x].setBackground(Color.white);
            if (x > 6)
                button[x].addActionListener(new ActionListener() {
                    public void actionPerformed(ActionEvent ae) {
                        day = button[selection].getActionCommand();
                        d.dispose();
                    }
                });
            if (x < 7) {
                button[x].setText(header[x]);
                button[x].setForeground(Color.red);
            }
            p1.add(button[x]);
        }
        JPanel p2 = new JPanel(new GridLayout(1, 3));
        JButton previous = new JButton("<< Previous");
        previous.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent ae) {
                month--;
                displayDate();
            }
        });
        p2.add(previous);
        p2.add(l);
        JButton next = new JButton("Next >>");
        next.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent ae) {
                month++;
                displayDate();
            }
        });
        p2.add(next);
        d.add(p1, BorderLayout.CENTER);
        d.add(p2, BorderLayout.SOUTH);
        d.pack();
        d.setLocationRelativeTo(parent);
        displayDate();
        d.setVisible(true);
    }

    public void displayDate() {
        for (int x = 7; x < button.length; x++)
            button[x].setText("");
        java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat(
                "MMMM yyyy");
        java.util.Calendar cal = java.util.Calendar.getInstance();
        cal.set(year, month, 1);
        int dayOfWeek = cal.get(java.util.Calendar.DAY_OF_WEEK);
        int daysInMonth = cal.getActualMaximum(java.util.Calendar.DAY_OF_MONTH);
        for (int x = 6 + dayOfWeek, day = 1; day <= daysInMonth; x++, day++)
            button[x].setText("" + day);
        l.setText(sdf.format(cal.getTime()));
        d.setTitle("Date Picker");
    }

    public String setPickedDate() {
        if (day.equals(""))
            return day;
        java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("dd-MM-yyyy");
        java.util.Calendar cal = java.util.Calendar.getInstance();
        cal.set(year, month, Integer.parseInt(day));
        return sdf.format(cal.getTime());
    }
}

continue....

class SearchPatientInformation {
    public static void main(String[] args) {
        JLabel lab=new JLabel("Patient Name:");
        JLabel label = new JLabel("Date of Birth:");
        final JTextField t=new JTextField(20);
        final JTextField text = new JTextField(20);
        JButton b = new JButton("Search");
        JPanel p = new JPanel(new GridLayout(3,2));
        p.add(lab);
        p.add(t);
        p.add(label);
        p.add(text);
        p.add(b);
        final JFrame f = new JFrame();
        f.getContentPane().add(p);
        f.pack();
        f.setVisible(true);
        text.addKeyListener(new KeyAdapter() {
            public void keyPressed(KeyEvent ae) {
                text.setText(new DatePicker(f).setPickedDate());
            }
        });
        b.addActionListener(new ActionListener(){
            public void actionPerformed(ActionEvent e){
            String name=t.getText();
            String dob=text.getText();
            try{
           Class.forName("com.mysql.jdbc.Driver");
           Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
           Statement st=con.createStatement();
           ResultSet rs=st.executeQuery("select * from patient where patientName='"+name+"' and dob='"+dob+"'");
           String n="",d="",email="",address="";
           int contact=0;
           if(rs.next()){
               n=rs.getString("patientName");
               d=rs.getString("dob");
               email=rs.getString("email");
               address=rs.getString("address");
               contact=rs.getInt("contactNo");
           }
           String data[]={n,address,Integer.toString(contact),email,d};
           JFrame f=new JFrame();
           JPanel p=new JPanel(new GridLayout(5,2));
           String labels[]={"Patient Name","Address","Contact No","Email","Date Of Birth"};
           JLabel l[]=new JLabel[5];
           JTextField text[]=new JTextField[5];
            for(int i=0;i<5;i++){
                l[i]=new JLabel(labels[i]);
                text[i]=new JTextField(20);
                p.add(l[i]);
                p.add(text[i]);
                text[i].setText(data[i]);
                text[i].setEnabled(false);
            }
            f.add(p);
            f.setVisible(true);
            f.pack();

            }
            catch(Exception ex){}
            }
        });
    }
}

Thank u soo much sir..i will check it now..

Thank u soo much sir..i will check it now..