msm

Code for login page:

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/*
 * Login.java
 *
 * Created on Sep 6, 2010, 11:24:53 PM
 */
package mobilestorenew;

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

/**
 *
 * @author Ramesh
 */
public class Login extends javax.swing.JFrame {

    /** Creates new form Login */
    String s1, s2, s3, s4;
    ResultSet res;
    int a = 0;

    public Login() {
        initComponents();
        setSize(1270, 740);
        setTitle("Login Form");
        setVisible(true);


    }

    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">                          
    private void initComponents() {

        jLabel4 = new javax.swing.JLabel();
        jPanel1 = new javax.swing.JPanel();
        jLabel2 = new javax.swing.JLabel();
        jTextField1 = new javax.swing.JTextField();
        jLabel3 = new javax.swing.JLabel();
        jLabel1 = new javax.swing.JLabel();
        jPasswordField1 = new javax.swing.JPasswordField();
        jButton1 = new javax.swing.JButton();
        jButton2 = new javax.swing.JButton();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
        getContentPane().setLayout(null);

        jLabel4.setFont(new java.awt.Font("Monotype Corsiva", 1, 60)); // NOI18N
        jLabel4.setForeground(new java.awt.Color(51, 255, 51));
        jLabel4.setText("Raj Mobile Store");
        getContentPane().add(jLabel4);
        jLabel4.setBounds(310, 60, 420, 70);

        jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
        jPanel1.setLayout(null);

        jLabel2.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
        jLabel2.setText("User Name");
        jPanel1.add(jLabel2);
        jLabel2.setBounds(80, 100, 100, 30);

        jTextField1.setFont(new java.awt.Font("Tahoma", 1, 18));
        jPanel1.add(jTextField1);
        jTextField1.setBounds(210, 100, 110, 30);

        jLabel3.setFont(new java.awt.Font("Tahoma", 1, 18));
        jLabel3.setText("Password");
        jPanel1.add(jLabel3);
        jLabel3.setBounds(80, 150, 110, 30);

        jLabel1.setFont(new java.awt.Font("Tahoma", 1, 24)); // NOI18N
        jLabel1.setText("Login Here");
        jPanel1.add(jLabel1);
        jLabel1.setBounds(150, 30, 130, 40);

        jPasswordField1.setFont(new java.awt.Font("Tahoma", 1, 18));
        jPanel1.add(jPasswordField1);
        jPasswordField1.setBounds(210, 150, 110, 30);

        jButton1.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
        jButton1.setText("Login");
        jButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton1ActionPerformed(evt);
            }
        });
        jPanel1.add(jButton1);
        jButton1.setBounds(120, 230, 90, 40);

        jButton2.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
        jButton2.setText("Cancel");
        jButton2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton2ActionPerformed(evt);
            }
        });
        jPanel1.add(jButton2);
        jButton2.setBounds(230, 230, 90, 40);

        getContentPane().add(jPanel1);
        jPanel1.setBounds(300, 170, 430, 300);

        pack();
    }// </editor-fold>                        

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        s1 = jTextField1.getText();
        s2 = jPasswordField1.getText();

        try {
            Connection co;
            Statement st;
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            co = DriverManager.getConnection("jdbc:odbc:mobileDSN", "scott", "tiger");
            st = co.createStatement();
            res = st.executeQuery("select * from login");
            Boolean rec = res.next();
            if (!rec) {
                JOptionPane.showMessageDialog(null, "There is no records in the table");
            } else {
                do {
                    s3 = res.getString(1);
                    s4 = res.getString(2);

                    if (s1.equals(s3) && s2.equals(s4)) {
                        dispose();
                        new Home();
                        a = 1;
                        break;
                    }
                } while (res.next());
                if (a == 0) {
                    JOptionPane.showMessageDialog(null, "Invalid user or password");
                    jTextField1.setText("");
                    jPasswordField1.setText("");
                }
            }
            st.close();
            co.close();
        } catch (Exception e) {
            JOptionPane.showMessageDialog(null, "The error is:" + e);
        }
    }                                        

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        System.exit(0);

    }                                        

    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {

            public void run() {
                new Login().setVisible(true);
            }
        });
    }
    // Variables declaration - do not modify                     
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton2;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPasswordField jPasswordField1;
    private javax.swing.JTextField jTextField1;
    // End of variables declaration                   
}



Code for Home Page:

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/*
 * Home.java
 *
 * Created on Sep 6, 2010, 11:53:35 PM
 */
package mobilestorenew;

import java.sql.*;
import javax.swing.*;
import java.util.Date;

/**
 *
 * @author Ramesh
 */
public class Home extends javax.swing.JFrame {

    /** Creates new form Home */
    int a = 0, flag = 0, b = 0, c = 0, temp, d = 0, f = 0, g = 0;
    int rows = 0;
    Object data[][];
    String col[];
    String cid, cid1, id,text="";
    String mc1, mc;
    JTable table;
    String totaldata = "";
    int bid;
    Date dat1;String dt1,day1,month1,year1,date1;
    
    public Home() {

        initComponents();
        setSize(1270, 740);
        setTitle("Mobile Store Home Page");
        setVisible(true);
        idincrement();
        installmentcheck();
    }

    public void idincrement()
    {
        try
        {

            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection co=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
            Statement st=co.createStatement();
            ResultSet res=st.executeQuery("select * from newbill");
            while(res.next())
            {
                bid=res.getInt(1);
            }

            st.close();
            co.close();
        }
        catch(Exception e)
        {
            JOptionPane.showMessageDialog(null,"the error is"+e);
            System.out.println(e.getMessage());
        }
            bid=bid+1;

            dat1=new Date();
            dt1=dat1.toString();
            System.out.println(dt1);
            day1=dt1.substring(8,10);
            month1=dt1.substring(4,7);
            year1=dt1.substring(24,28);


            date1=day1;
            date1+="-";
            date1+=month1;
            date1+="-";
            date1+=year1;

    }
    public void installmentcheck()
    {
        String countcid="";
        String countcname="";
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
            Statement st=con.createStatement();
            ResultSet res1=st.executeQuery("select cid,cname,pdate, floor(months_between(sysdate,pdate)) as diff from newcustomer_details");
            Boolean rec=res1.next();
            if(rec==false)
            {
                System.out.println("there are no records");
            }
            else
            {
                do
                {
                    String dcid=res1.getString(1);
                    String dcname=res1.getString(2);

                    int diff=res1.getInt(4);

                    if(diff>=2)
                    {
                        countcid+=dcid+"\n";
                        countcname+=dcname+"\n";
                        JOptionPane.showMessageDialog(null,"The following Customer Not Payed Their Installments from last two months\n" +
                        countcid+"\t"+countcname);
                    }

                }while(res1.next());
            }

            con.commit();
            con.close();


        }
        catch(Exception e)
        {
            JOptionPane.showMessageDialog(null,"The error is :"+e);
        }
    }


    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">                          
    private void initComponents() {

        jMenuBar1 = new javax.swing.JMenuBar();
        jMenu1 = new javax.swing.JMenu();
        jMenuItem1 = new javax.swing.JMenuItem();
        jMenuItem3 = new javax.swing.JMenuItem();
        jMenuItem2 = new javax.swing.JMenuItem();
        jMenuItem4 = new javax.swing.JMenuItem();
        jMenu2 = new javax.swing.JMenu();
        jMenuItem6 = new javax.swing.JMenuItem();
        jMenuItem7 = new javax.swing.JMenuItem();
        jMenuItem8 = new javax.swing.JMenuItem();
        jMenuItem13 = new javax.swing.JMenuItem();
        jMenu3 = new javax.swing.JMenu();
        jMenuItem9 = new javax.swing.JMenuItem();
        jMenuItem10 = new javax.swing.JMenuItem();
        jMenu5 = new javax.swing.JMenu();
        jMenuItem5 = new javax.swing.JMenuItem();
        jMenuItem14 = new javax.swing.JMenuItem();
        jMenuItem15 = new javax.swing.JMenuItem();
        jMenu4 = new javax.swing.JMenu();
        jMenuItem11 = new javax.swing.JMenuItem();
        jMenuItem12 = new javax.swing.JMenuItem();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
        getContentPane().setLayout(null);

        jMenu1.setText("Mobile Phone    ");

        jMenuItem1.setText("Add Mobile Phone");
        jMenuItem1.setToolTipText("Click here to add a mobile phone");
        jMenuItem1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenuItem1ActionPerformed(evt);
            }
        });
        jMenu1.add(jMenuItem1);

        jMenuItem3.setText("Search Mobile Phone");
        jMenuItem3.setToolTipText("Click here to Search a Mobile Phone");
        jMenuItem3.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenuItem3ActionPerformed(evt);
            }
        });
        jMenu1.add(jMenuItem3);

        jMenuItem2.setText("Update Mobile Phone");
        jMenuItem2.setToolTipText("Click here to Update a Mobile Phone");
        jMenuItem2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenuItem2ActionPerformed(evt);
            }
        });
        jMenu1.add(jMenuItem2);

        jMenuItem4.setText("Delete Mobile Phone");
        jMenuItem4.setToolTipText("Click here to delete a mobile phone");
        jMenuItem4.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenuItem4ActionPerformed(evt);
            }
        });
        jMenu1.add(jMenuItem4);

        jMenuBar1.add(jMenu1);

        jMenu2.setText("Customer    ");

        jMenuItem6.setText("Search Customer");
        jMenuItem6.setToolTipText("Click here to Search a Customer");
        jMenuItem6.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenuItem6ActionPerformed(evt);
            }
        });
        jMenu2.add(jMenuItem6);

        jMenuItem7.setText("Update Customer");
        jMenuItem7.setToolTipText("Click here to Update Customer Details");
        jMenuItem7.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenuItem7ActionPerformed(evt);
            }
        });
        jMenu2.add(jMenuItem7);

        jMenuItem8.setText("Delete Customer");
        jMenuItem8.setToolTipText("Click here to Delete a Customer");
        jMenuItem8.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenuItem8ActionPerformed(evt);
            }
        });
        jMenu2.add(jMenuItem8);

        jMenuItem13.setText("Credit Payments");
        jMenuItem13.setToolTipText("Click here for Credit Payments");
        jMenuItem13.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenuItem13ActionPerformed(evt);
            }
        });
        jMenu2.add(jMenuItem13);

        jMenuBar1.add(jMenu2);

        jMenu3.setText("Bill Administration    ");

        jMenuItem9.setText("Generate Bill");
        jMenuItem9.setToolTipText("Click here to Generate Bill");
        jMenuItem9.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenuItem9ActionPerformed(evt);
            }
        });
        jMenu3.add(jMenuItem9);

        jMenuItem10.setText("Search Bill");
        jMenuItem10.setToolTipText("Click here Search a Bill");
        jMenuItem10.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenuItem10ActionPerformed(evt);
            }
        });
        jMenu3.add(jMenuItem10);

        jMenuBar1.add(jMenu3);

        jMenu5.setText("Sales Reports    ");

        jMenuItem5.setText("Daily Reports");
        jMenuItem5.setToolTipText("Click here for Daily Reports");
        jMenuItem5.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenuItem5ActionPerformed(evt);
            }
        });
        jMenu5.add(jMenuItem5);

        jMenuItem14.setText("Monthly Reports");
        jMenuItem14.setToolTipText("Click here for Monthly Reports");
        jMenuItem14.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenuItem14ActionPerformed(evt);
            }
        });
        jMenu5.add(jMenuItem14);

        jMenuItem15.setText("Yearly Reports");
        jMenuItem15.setToolTipText("Click here for Yearly Reports");
        jMenuItem15.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenuItem15ActionPerformed(evt);
            }
        });
        jMenu5.add(jMenuItem15);

        jMenuBar1.add(jMenu5);

        jMenu4.setText("User");

        jMenuItem11.setText("LogOff");
        jMenuItem11.setToolTipText("Click here to LogOff");
        jMenuItem11.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenuItem11ActionPerformed(evt);
            }
        });
        jMenu4.add(jMenuItem11);

        jMenuItem12.setText("Exit");
        jMenuItem12.setToolTipText("Click here to Exit from the Application");
        jMenuItem12.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenuItem12ActionPerformed(evt);
            }
        });
        jMenu4.add(jMenuItem12);

        jMenuBar1.add(jMenu4);

        setJMenuBar(jMenuBar1);

        pack();
    }// </editor-fold>                        

    private void jMenuItem11ActionPerformed(java.awt.event.ActionEvent evt) {                                            
        // TODO add your handling code here:
        dispose();
        new Login();
    }                                           

    private void jMenuItem12ActionPerformed(java.awt.event.ActionEvent evt) {                                            
        // TODO add your handling code here:
        dispose();
    }                                           

    private void jMenuItem1ActionPerformed(java.awt.event.ActionEvent evt) {                                           
        // TODO add your handling code here:
        new Addmobile1();
    }                                          

    private void jMenuItem3ActionPerformed(java.awt.event.ActionEvent evt) {                                           
        // TODO add your handling code here:
        
        new SearchMobile();
    }                                          

    private void jMenuItem2ActionPerformed(java.awt.event.ActionEvent evt) {                                           
        // TODO add your handling code here:
        new MobileUpdate();
    }                                          

    private void jMenuItem4ActionPerformed(java.awt.event.ActionEvent evt) {                                           
        // TODO add your handling code here:

        String id1 = JOptionPane.showInputDialog(null, "Enter Mobile Phone Id (or) IMEI No");
        while (id1.equals("")) {
            JOptionPane.showMessageDialog(null, "You should have to enter something");
            id1 = JOptionPane.showInputDialog(null, "Enter Mobile Phone Id (or) IMEI No");
        }
        try {
            Connection con;
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con = DriverManager.getConnection("jdbc:odbc:mobileDSN", "scott", "tiger");
            Statement st = con.createStatement();
            ResultSet res = st.executeQuery("select * from newmobile_details");
            Boolean rec = res.next();
            if (!rec) {
                JOptionPane.showMessageDialog(null, "There are no mobile phones in the database");
            } else {
                do {

                    String s1 = res.getString(1);
                    String s2 = res.getString(3);
                    String s3 = res.getString(6);

                    if (id1.equalsIgnoreCase(s1) || id1.equalsIgnoreCase(s3)) {
                        int reply = JOptionPane.showConfirmDialog(null, "Are you sure you want to delete the mobile phone " + s2 + " with having mobile id:" + s1 + " and IMEI no:" + s3);
                        if (reply == JOptionPane.YES_OPTION) {
                            PreparedStatement prp = con.prepareStatement("delete newmobile_details where phone_id=?");
                            prp.setString(1, s1);
                            prp.executeUpdate();
                            JOptionPane.showMessageDialog(null, "The mobile successfully deleted");
                            a = 1;
                        } else if (reply == JOptionPane.NO_OPTION) {
                            JOptionPane.showMessageDialog(null, "The mobile phone is not deleted");
                            a = 1;
                            break;
                        } else if (reply == JOptionPane.CANCEL_OPTION) {
                            JOptionPane.showMessageDialog(null, "The mobile phone details are not deleted");
                            a = 1;
                            break;
                        } else {
                        }
                    }


                } while (res.next());
                if (a == 0) {
                    JOptionPane.showMessageDialog(null, "The mobile phone does not exists in the database");
                }
            }
            con.commit();
            con.close();

        } catch (Exception e) {
            JOptionPane.showMessageDialog(null, "the error is" + e);
        }

    }                                          

    private void jMenuItem9ActionPerformed(java.awt.event.ActionEvent evt) {                                           
        // TODO add your handling code here:
        new BillGeneration();
    }                                          

    private void jMenuItem10ActionPerformed(java.awt.event.ActionEvent evt) {                                            
        // TODO add your handling code here:
        String searchbill = JOptionPane.showInputDialog(null, "Enter the Bill Id to search");
        while (searchbill.equals("")) {
            JOptionPane.showMessageDialog(null, "Please enter Bill Id");
            searchbill = JOptionPane.showInputDialog(null, "Enter the Bill Id to search");
        }
        try {

            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con = DriverManager.getConnection("jdbc:odbc:mobileDSN", "scott", "tiger");
            Statement st = con.createStatement();
            ResultSet res = st.executeQuery("select * from newbill");
            Boolean rec = res.next();
            if (!rec) {
                JOptionPane.showMessageDialog(null, "There are no Bills exists");
            } else {
                do {
                    String dbid = res.getString(1);
                    if (searchbill.equals(dbid)) {
                        BillGeneration bg = new BillGeneration();
                        bg.jTextField1.setText(dbid);
                        bg.jTextField2.setText(res.getDate(2).toString());
                        bg.jTextField3.setText(res.getString(3));
                        bg.jTextField6.setText(res.getString(4));
                        bg.jTextField7.setText(res.getString(5));
                        
                        bg.jTextArea1.setText("Phone Name \tPhone Price \tPhone Color \tIMEI Number \n-------" +
                                         "--------------------------------------------------------------------------");
                        bg.jTextArea1.append(res.getString(6));
                        bg.jPanel1.setVisible(false);
                        bg.jButton2.setVisible(false);
                        bg.jTextField7.setEditable(false);
                        bg.jTextField3.setEditable(false);

                        bg.jLabel2.setBounds(280, 110, 130, 30);
                        bg.jTextField1.setBounds(460, 110, 130, 30);
                        bg.jLabel3.setBounds(280, 170, 130, 30);
                        bg.jTextField2.setBounds(460, 170, 130, 30);
                        bg.jLabel4.setBounds(280, 230, 130, 30);
                        bg.jTextField3.setBounds(460, 230, 130, 30);
                        bg.jLabel8.setBounds(280, 290, 130, 30);
                        bg.jScrollPane1.setBounds(460, 290, 410, 160);
                        bg.jLabel9.setBounds(280, 480, 130, 30);
                        bg.jTextField6.setBounds(460, 480, 130, 30);
                        bg.jLabel10.setBounds(280, 540, 130, 30);
                        bg.jTextField7.setBounds(460, 540, 130, 30);
                        bg.jButton1.setBounds(430, 620, 100, 40);

                        bg.jLabel1.setText("Search Results");
                        bg.jLabel8.setText("Mobiles Purchased");
                        bg.jButton1.setText("CLOSE");
                        bg.setTitle("Search Bill");
                        bg.flag = 1;
                        f = 1;
                    }
                } while (res.next());

                if (f == 0) {
                    JOptionPane.showMessageDialog(null, "The Bill Id does not exists");
                }
            }
        } catch (Exception e) {
            JOptionPane.showMessageDialog(null, "The error is :" + e);
        }


    }                                           

    private void jMenuItem6ActionPerformed(java.awt.event.ActionEvent evt) {                                           
        // TODO add your handling code here:
        new SearchCustomer();
    }                                          

    private void jMenuItem7ActionPerformed(java.awt.event.ActionEvent evt) {                                           
        // TODO add your handling code here:
        cid = JOptionPane.showInputDialog(null, "Enter Customer Id");
        while (cid.equals("")) {
            JOptionPane.showMessageDialog(null, "Please Enter Customer Id");
            cid = JOptionPane.showInputDialog(null, "Enter Customer Id to Search");
        }
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con = DriverManager.getConnection("jdbc:odbc:mobileDSN", "scott", "tiger");
            Statement st = con.createStatement();
            ResultSet res = st.executeQuery("select * from newcustomer_details");
            Boolean rec = res.next();
            if (!rec) {
                JOptionPane.showMessageDialog(null, "There are no customer EXISTS");
            } else {
                do {
                    cid1 = res.getString(1);
                    if (cid.equalsIgnoreCase(cid1)) {
                        CreditCustomer cc = new CreditCustomer();

                        cc.jTextField1.setText(cid1);
                        cc.jTextField2.setText(res.getString(2));
                        java.sql.Date dt = res.getDate(3);

                        String dd = dt.toString();
                        String year = dd.substring(0, 4);
                        String month = dd.substring(5, 7);
                        String day = dd.substring(8, 10);

                        if (month.equals("01")) {
                            mc1 = "jan";
                        } else if (month.equals("02")) {
                            mc1 = "feb";
                        } else if (month.equals("03")) {
                            mc1 = "mar";
                        } else if (month.equals("04")) {
                            mc1 = "apr";
                        } else if (month.equals("05")) {
                            mc1 = "may";
                        } else if (month.equals("06")) {
                            mc1 = "jun";
                        } else if (month.equals("07")) {
                            mc1 = "jul";
                        } else if (month.equals("08")) {
                            mc1 = "aug";
                        } else if (month.equals("09")) {
                            mc1 = "sep";
                        } else if (month.equals("10")) {
                            mc1 = "oct";
                        } else if (month.equals("11")) {
                            mc1 = "nov";
                        } else if (month.equals("12")) {
                            mc1 = "dec";
                        }
                        String date = day;
                        date += "-";
                        date += mc1;
                        date += "-";
                        date += year;
                        cc.jTextField3.setText(date);
                        cc.jTextField4.setText(Integer.toString(res.getInt(4)));
                        cc.jTextField5.setText(Integer.toString(res.getInt(5)));
                        cc.jTextField6.setText(Integer.toString(res.getInt(6)));

                        java.sql.Date dob = res.getDate(7);
                        String ddob = dob.toString();
                        String year2 = ddob.substring(0, 4);
                        String month2 = ddob.substring(5, 7);
                        String day2 = ddob.substring(8, 10);

                        if (month2.equals("01")) {
                            mc = "jan";
                        } else if (month2.equals("02")) {
                            mc = "feb";
                        } else if (month2.equals("03")) {
                            mc = "mar";
                        } else if (month2.equals("04")) {
                            mc = "apr";
                        } else if (month2.equals("05")) {
                            mc = "may";
                        } else if (month2.equals("06")) {
                            mc = "jun";
                        } else if (month2.equals("07")) {
                            mc = "jul";
                        } else if (month2.equals("08")) {
                            mc = "aug";
                        } else if (month2.equals("09")) {
                            mc = "sep";
                        } else if (month2.equals("10")) {
                            mc = "oct";
                        } else if (month2.equals("11")) {
                            mc = "nov";
                        } else if (month2.equals("12")) {
                            mc = "dec";
                        }

                        cc.jComboBox1.setSelectedItem(day2);
                        cc.jComboBox2.setSelectedItem(mc);
                        cc.jComboBox3.setSelectedItem(year2);
                        cc.jTextField7.setText(Integer.toString(res.getInt(8)));

                        String gender = res.getString(9);
                        if (gender.equalsIgnoreCase("male")) {
                            cc.jRadioButton1.setSelected(true);
                        } else if (gender.equalsIgnoreCase("female")) {
                            cc.jRadioButton2.setSelected(true);
                        }

                        cc.jTextField8.setText(res.getString(10));
                        cc.jTextField9.setText(res.getString(11));
                        cc.jTextField10.setText(res.getString(12));
                        cc.jTextField11.setText(res.getString(13));
                        cc.jTextField12.setText(res.getString(14));
                        cc.jTextArea1.setText(res.getString(15));
                        cc.jTextField13.setVisible(false);
                        cc.jTextField14.setVisible(false);
                        cc.jLabel25.setVisible(false);
                        cc.jLabel26.setVisible(false);
                        cc.jLabel1.setText("Update Customer Details");
                        cc.jButton1.setText("Update Customer Details");
                        cc.flag = 3;

                        c = 1;
                        break;
                    }

                } while (res.next());
                if (c == 0) {
                    JOptionPane.showMessageDialog(null, "The customer id does not exists");
                }
            }
        } catch (Exception e) {
            JOptionPane.showMessageDialog(null, "The error is" + e);
        }
    }                                          

    private void jMenuItem8ActionPerformed(java.awt.event.ActionEvent evt) {                                           
        // TODO add your handling code here:
        cid = JOptionPane.showInputDialog(null, "Enter Customer Id");
        while (cid.equals("")) {
            JOptionPane.showMessageDialog(null, "Please Enter Customer Id");
            cid = JOptionPane.showInputDialog(null, "Enter Customer Id to Search");
        }
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con = DriverManager.getConnection("jdbc:odbc:mobileDSN", "scott", "tiger");
            Statement st = con.createStatement();
            ResultSet res = st.executeQuery("select * from newcustomer_details");
            Boolean rec = res.next();
            if (!rec) {
                JOptionPane.showMessageDialog(null, "There are no customer");
            } else {
                do {
                    cid1 = res.getString(1);
                    if (cid.equalsIgnoreCase(cid1)) {
                        int reply = JOptionPane.showConfirmDialog(null, "Are you sure you want delete this customer");

                        if (reply == JOptionPane.YES_OPTION) {
                            PreparedStatement prp = con.prepareStatement("delete newcustomer_details where cid=" + cid);
                            prp.executeUpdate();
                            JOptionPane.showMessageDialog(null, "The Customer Details Deleted Successfully");
                        } else if (reply == JOptionPane.NO_OPTION) {
                            JOptionPane.showMessageDialog(null, "The customer details are not deleted");
                        } else if (reply == JOptionPane.CANCEL_OPTION) {
                            JOptionPane.showMessageDialog(null, "The customer details are not deleted");
                        }
                        d = 1;
                        break;
                    }
                } while (res.next());
                if (d == 0) {
                    JOptionPane.showMessageDialog(null, "The Customer Id is not exists in the database");
                }
                con.commit();
                con.close();
            }
        } catch (Exception e) {
            JOptionPane.showMessageDialog(null, "The error is:" + e);
        }
    }                                          

    private void jMenuItem13ActionPerformed(java.awt.event.ActionEvent evt) {                                            
        // TODO add your handling code here:
        int creditpayid;
        String creditpayid1 = JOptionPane.showInputDialog(null, "Enter Customer Id");
        while (creditpayid1.equals(""))
        {
            JOptionPane.showMessageDialog(null, "Please enter Customer Id");
            creditpayid1 = JOptionPane.showInputDialog(null, "Enter Customer Id");
        }

        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con = DriverManager.getConnection("jdbc:odbc:mobileDSN", "scott", "tiger");
            Statement st = con.createStatement();
            ResultSet res = st.executeQuery("select * from newcustomer_details");
            Boolean rec = res.next();
            if (rec == false)
            {
                JOptionPane.showMessageDialog(null, "There are no records");
            } 
            else
            {
                do
                {
                    int dcid = res.getInt(1);
                    String dcname = res.getString(2);
                    int dpaidamt = res.getInt(4);
                    int dbalamt = res.getInt(5);
                    int drefid = res.getInt(6);
                    
                    String dmob_purchase = res.getString(15);

                    creditpayid = Integer.parseInt(creditpayid1);

                    if (creditpayid == dcid)
                    {

                        int creditpay = Integer.parseInt(JOptionPane.showInputDialog(null, "Enter the Amount that Customer want to Pay"));
                        while(creditpay<500)
                        {
                            JOptionPane.showMessageDialog(null,"The Installment Payment should be Greater than or equal to 500");
                            creditpay = Integer.parseInt(JOptionPane.showInputDialog(null, "Enter the Amount that Customer want to Pay"));
                        }

                        int totalbal = dbalamt - creditpay;

                        PreparedStatement prp = con.prepareStatement("update newcustomer_details set pdate=?,paidamt=?,balamt=? where cid=?");
                        prp.setString(1,date1);
                        prp.setInt(2, creditpay);
                        prp.setInt(3, totalbal);
                        prp.setInt(4, dcid);
                        prp.executeUpdate();

                        JOptionPane.showMessageDialog(null, dcname + " Remaining Balance Amount is: " + totalbal);
                        int reply = JOptionPane.showConfirmDialog(null, "Do you want to print the Bill");
                        if (reply == JOptionPane.YES_OPTION)
                        {

                            PrintPreview pp=new PrintPreview();
                            pp.jLabel3.setText(Integer.toString(bid));
                            pp.jLabel5.setText(date1);
                            pp.jLabel7.setText(dcname);
                            pp.jLabel10.setText("Amount Paid:");
                            pp.jLabel11.setText(Integer.toString(creditpay));
                            pp.jLabel12.setText("Remaining Balance:");
                            pp.jLabel13.setText(Integer.toString(totalbal));
                            pp.jTextArea1.setText(dmob_purchase);
                            pp.flag=1;
                        }
                        else if (reply == JOptionPane.NO_OPTION)
                        {
                        } 
                        else if (reply == JOptionPane.CANCEL_OPTION)
                        {
                        }
                        g = 1;


                    }
                }
                while (res.next());
                if (g == 0)
                {
                    JOptionPane.showMessageDialog(null, "The Customer Id does not exists");
                }
            }
            con.commit();
            con.close();
        } 
        catch(NumberFormatException e)
        {
            
        }
        catch (Exception e)
        {
            JOptionPane.showMessageDialog(null, "The error is : " + e);
        }
    }                                           

    private void jMenuItem5ActionPerformed(java.awt.event.ActionEvent evt) {                                           
        // TODO add your handling code here:
         int countsales=0,totalamt=0;
        try
        {
            String date = JOptionPane.showInputDialog(null, "Enter Date on which you want the Reports (EX:01-jan-2000)");
            while(date.equalsIgnoreCase(""))
            {
                JOptionPane.showMessageDialog(null,"Please enter date");
                date = JOptionPane.showInputDialog(null, "Enter Date on which you want the Reports (EX:01-jan-2000)");
            }
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con = DriverManager.getConnection("jdbc:odbc:mobileDSN", "scott", "tiger");
            Statement st = con.createStatement();
            ResultSet res = st.executeQuery("select * from newbill where bdate='" + date + "'");
            Boolean rec = res.next();
            if (rec == false)
            {
                JOptionPane.showMessageDialog(null, "There are no sales on the given date");
            } 
            else
            {
                SalesReports sr=new SalesReports();
                sr.jLabel2.setVisible(false);
                sr.jLabel3.setVisible(false);
                sr.jComboBox1.setVisible(false);
                sr.jComboBox2.setVisible(false);
                sr.jButton3.setVisible(false);
                sr.jScrollPane1.setBounds(60, 70, 910, 510);
                sr.jTextArea1.setText("");
                text="";
                sr.jLabel1.setText("Daily Reports");
                do
                {
                    String dbid = res.getString(1);
                    java.sql.Date dbdate = res.getDate(2);
                    String bdate = dbdate.toString();
                    String dcname = res.getString(3);
                    int dprice = res.getInt(4);
                    int damtpaid = res.getInt(5);
                    String mob_purchased = res.getString(7);
                    countsales++;
                    totalamt+=damtpaid;

                    text+="\n"+dbid+" \t"+bdate+" \t"+dcname+" \t\t"+dprice+" \t"+damtpaid+" \t"+mob_purchased+" \n";
                    sr.jTextArea1.setText("Bill Id \tBill Date \tCustomerName \t\tTotalPrice \tAmountPaid \tMobiles Purchased \n"+
                    "-----------------------------------------------------------------------------------------------------" +
                    "-----------------------------------------------------------------------------"+text+"\n--------------------------------------------------------------------------------------------"+
                    "-----------------------------------------------------------------------------\n\n\t\t Total No. Of Sales: "+countsales+"\tTotal Amount Collected: "+totalamt);
                    
                    
                } while(res.next());
                

            }
        } 
        catch(NullPointerException e)
        {

        }
        catch(SQLException e)
        {
            JOptionPane.showMessageDialog(null,"INVALID DATE!, please follow the Example");
        }
        catch (Exception e)
        {
            JOptionPane.showMessageDialog(null, "The error is:" + e);
        }
    }                                          

    private void jMenuItem14ActionPerformed(java.awt.event.ActionEvent evt) {                                            
        // TODO add your handling code here:
        SalesReports sr=new SalesReports();
        sr.jLabel1.setText("Monthly Reports");
        sr.flag=0;
    }                                           

    private void jMenuItem15ActionPerformed(java.awt.event.ActionEvent evt) {                                            
        // TODO add your handling code here:
        SalesReports sr=new SalesReports();
        sr.jLabel1.setText("Yearly Reports");
        sr.jLabel2.setVisible(false);
        sr.jComboBox1.setVisible(false);
        sr.flag=1;
    }                                           

    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {

            public void run() {
                new Home().setVisible(true);

            }
        });
    }
    // Variables declaration - do not modify                     
    private javax.swing.JMenu jMenu1;
    private javax.swing.JMenu jMenu2;
    private javax.swing.JMenu jMenu3;
    private javax.swing.JMenu jMenu4;
    private javax.swing.JMenu jMenu5;
    private javax.swing.JMenuBar jMenuBar1;
    private javax.swing.JMenuItem jMenuItem1;
    private javax.swing.JMenuItem jMenuItem10;
    private javax.swing.JMenuItem jMenuItem11;
    private javax.swing.JMenuItem jMenuItem12;
    private javax.swing.JMenuItem jMenuItem13;
    private javax.swing.JMenuItem jMenuItem14;
    private javax.swing.JMenuItem jMenuItem15;
    private javax.swing.JMenuItem jMenuItem2;
    private javax.swing.JMenuItem jMenuItem3;
    private javax.swing.JMenuItem jMenuItem4;
    private javax.swing.JMenuItem jMenuItem5;
    private javax.swing.JMenuItem jMenuItem6;
    private javax.swing.JMenuItem jMenuItem7;
    private javax.swing.JMenuItem jMenuItem8;
    private javax.swing.JMenuItem jMenuItem9;
    // End of variables declaration                   
}




Code for Addmobile Page:

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/*
 * Addmobile1.java
 *
 * Created on Sep 11, 2010, 10:53:35 PM
 */

package mobilestorenew;

import java.sql.*;
import javax.swing.JOptionPane;
import java.util.Date;

/**
 *
 * @author Ramesh
 */
public class Addmobile1 extends javax.swing.JFrame {

    /** Creates new form Addmobile1 */
    String model,name,pcolor,date1,cbox="";
    
    int price,no,s1,s3,index,inc,inc1;
    String s2,imeino,mid,dpname,dpid,pname;
    
    int a=0,z=0,b=0,d=0;
    int count=0;int prevalue=0,curvalue;
    

    public Addmobile1()
    {
        initComponents();
        setVisible(true);
        setSize(1270,740);
        setTitle("Add Mobile Phone Details");
    
        jTextField5.setEditable(false);
        jTextField6.setEditable(false);
        jComboBox2.setEnabled(false);
        jComboBox3.setEnabled(false);
        jComboBox4.setEnabled(false);
        jComboBox5.setEnabled(false);
        jCheckBox1.setEnabled(false);
        jCheckBox2.setEnabled(false);
        jCheckBox3.setEnabled(false);
        jCheckBox4.setEnabled(false);
        jCheckBox5.setEnabled(false);
        jCheckBox6.setEnabled(false);
        jButton4.setEnabled(false);
        jButton3.setEnabled(false);
        
    }
   
     /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">                          
    private void initComponents() {

        jLabel1 = new javax.swing.JLabel();
        jPanel1 = new javax.swing.JPanel();
        jLabel18 = new javax.swing.JLabel();
        jLabel19 = new javax.swing.JLabel();
        jLabel20 = new javax.swing.JLabel();
        jLabel21 = new javax.swing.JLabel();
        jLabel22 = new javax.swing.JLabel();
        jTextField5 = new javax.swing.JTextField();
        jTextField6 = new javax.swing.JTextField();
        jButton4 = new javax.swing.JButton();
        jLabel12 = new javax.swing.JLabel();
        jLabel11 = new javax.swing.JLabel();
        jComboBox2 = new javax.swing.JComboBox();
        jCheckBox1 = new javax.swing.JCheckBox();
        jCheckBox2 = new javax.swing.JCheckBox();
        jCheckBox3 = new javax.swing.JCheckBox();
        jCheckBox4 = new javax.swing.JCheckBox();
        jCheckBox5 = new javax.swing.JCheckBox();
        jCheckBox6 = new javax.swing.JCheckBox();
        jButton3 = new javax.swing.JButton();
        jComboBox3 = new javax.swing.JComboBox();
        jComboBox4 = new javax.swing.JComboBox();
        jComboBox5 = new javax.swing.JComboBox();
        jLabel5 = new javax.swing.JLabel();
        jLabel7 = new javax.swing.JLabel();
        jLabel13 = new javax.swing.JLabel();
        jPanel2 = new javax.swing.JPanel();
        jLabel2 = new javax.swing.JLabel();
        jLabel3 = new javax.swing.JLabel();
        jComboBox1 = new javax.swing.JComboBox();
        jLabel4 = new javax.swing.JLabel();
        jTextField2 = new javax.swing.JTextField();
        jTextField3 = new javax.swing.JTextField();
        jLabel6 = new javax.swing.JLabel();
        jTextField4 = new javax.swing.JTextField();
        jLabel8 = new javax.swing.JLabel();
        jLabel9 = new javax.swing.JLabel();
        jLabel10 = new javax.swing.JLabel();
        jButton1 = new javax.swing.JButton();

        setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
        getContentPane().setLayout(null);

        jLabel1.setFont(new java.awt.Font("Tahoma", 1, 24));
        jLabel1.setText("Add Mobile Phone Details");
        getContentPane().add(jLabel1);
        jLabel1.setBounds(350, 0, 303, 40);

        jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
        jPanel1.setEnabled(false);
        jPanel1.setLayout(null);

        jLabel18.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel18.setText("Mobile Phone Id");
        jPanel1.add(jLabel18);
        jLabel18.setBounds(50, 20, 130, 30);

        jLabel19.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel19.setText("Mobile Phone Color");
        jPanel1.add(jLabel19);
        jLabel19.setBounds(50, 70, 190, 30);

        jLabel20.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel20.setText("Enter IMEI Number");
        jPanel1.add(jLabel20);
        jLabel20.setBounds(50, 120, 160, 30);

        jLabel21.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel21.setText("Enter Date Of Manufacture");
        jPanel1.add(jLabel21);
        jLabel21.setBounds(50, 170, 190, 30);

        jLabel22.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel22.setText("Additional Accessories");
        jPanel1.add(jLabel22);
        jLabel22.setBounds(50, 230, 170, 30);

        jTextField5.setFont(new java.awt.Font("Tahoma", 1, 14));
        jPanel1.add(jTextField5);
        jTextField5.setBounds(250, 20, 140, 30);

        jTextField6.setFont(new java.awt.Font("Tahoma", 1, 14));
        jTextField6.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusLost(java.awt.event.FocusEvent evt) {
                jTextField6FocusLost(evt);
            }
        });
        jPanel1.add(jTextField6);
        jTextField6.setBounds(250, 120, 140, 30);

        jButton4.setFont(new java.awt.Font("Tahoma", 1, 18));
        jButton4.setText(" SAVE PHONE DETAILS");
        jButton4.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton4ActionPerformed(evt);
            }
        });
        jPanel1.add(jButton4);
        jButton4.setBounds(90, 330, 240, 50);

        jLabel12.setFont(new java.awt.Font("Tahoma", 1, 12));
        jPanel1.add(jLabel12);
        jLabel12.setBounds(410, 120, 100, 30);

        jLabel11.setFont(new java.awt.Font("Tahoma", 1, 12));
        jPanel1.add(jLabel11);
        jLabel11.setBounds(410, 20, 100, 30);

        jComboBox2.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jComboBox2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Red", "Green", "Blue", "Black", "White", "Cyan", "Yellow", "Orange", "Purple", "Pink", "Voilet", "Magenta" }));
        jPanel1.add(jComboBox2);
        jComboBox2.setBounds(250, 70, 140, 30);

        jCheckBox1.setFont(new java.awt.Font("Tahoma", 1, 11));
        jCheckBox1.setText("Charger ");
        jPanel1.add(jCheckBox1);
        jCheckBox1.setBounds(250, 240, 80, 23);

        jCheckBox2.setFont(new java.awt.Font("Tahoma", 1, 11));
        jCheckBox2.setText("HeadSet ");
        jPanel1.add(jCheckBox2);
        jCheckBox2.setBounds(360, 240, 80, 23);

        jCheckBox3.setFont(new java.awt.Font("Tahoma", 1, 11));
        jCheckBox3.setText("DataCable ");
        jPanel1.add(jCheckBox3);
        jCheckBox3.setBounds(460, 240, 100, 23);

        jCheckBox4.setFont(new java.awt.Font("Tahoma", 1, 11));
        jCheckBox4.setText("Battery ");
        jPanel1.add(jCheckBox4);
        jCheckBox4.setBounds(250, 280, 80, 23);

        jCheckBox5.setFont(new java.awt.Font("Tahoma", 1, 11));
        jCheckBox5.setText("MemoryCard ");
        jPanel1.add(jCheckBox5);
        jCheckBox5.setBounds(360, 280, 101, 23);

        jCheckBox6.setFont(new java.awt.Font("Tahoma", 1, 11));
        jCheckBox6.setText("CD ");
        jPanel1.add(jCheckBox6);
        jCheckBox6.setBounds(470, 280, 50, 23);

        jButton3.setFont(new java.awt.Font("Tahoma", 1, 18));
        jButton3.setText("CANCEL");
        jButton3.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton3ActionPerformed(evt);
            }
        });
        jPanel1.add(jButton3);
        jButton3.setBounds(370, 330, 110, 50);

        jComboBox3.setFont(new java.awt.Font("Tahoma", 1, 12));
        jComboBox3.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "31" }));
        jPanel1.add(jComboBox3);
        jComboBox3.setBounds(250, 180, 50, 30);

        jComboBox4.setFont(new java.awt.Font("Tahoma", 1, 12));
        jComboBox4.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "jan", "feb", "mar", "apr", "may", "jun", "jul", "aug", "sep", "oct", "nov", "dec" }));
        jPanel1.add(jComboBox4);
        jComboBox4.setBounds(330, 180, 56, 30);

        jComboBox5.setFont(new java.awt.Font("Tahoma", 1, 12));
        jComboBox5.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "2000", "2001", "2002", "2003", "2004", "2005", "2006", "2007", "2008", "2009", "2010", "2011", "2012", "2013", "2014", "2015", "2016", "2017", "2018", "2019", "2020" }));
        jComboBox5.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusLost(java.awt.event.FocusEvent evt) {
                jComboBox5FocusLost(evt);
            }
        });
        jPanel1.add(jComboBox5);
        jComboBox5.setBounds(426, 180, 60, 30);

        jLabel5.setFont(new java.awt.Font("Tahoma", 1, 12));
        jLabel5.setText("(DD)");
        jPanel1.add(jLabel5);
        jLabel5.setBounds(300, 180, 30, 30);

        jLabel7.setFont(new java.awt.Font("Tahoma", 1, 12));
        jLabel7.setText("(MM)");
        jPanel1.add(jLabel7);
        jLabel7.setBounds(390, 180, 32, 30);

        jLabel13.setFont(new java.awt.Font("Tahoma", 1, 12));
        jLabel13.setText("(YY)");
        jPanel1.add(jLabel13);
        jLabel13.setBounds(490, 180, 30, 30);

        getContentPane().add(jPanel1);
        jPanel1.setBounds(200, 290, 570, 400);

        jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
        jPanel2.setLayout(null);

        jLabel2.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel2.setText("Price");
        jPanel2.add(jLabel2);
        jLabel2.setBounds(50, 120, 90, 30);

        jLabel3.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel3.setText("No. of Mobile Phones");
        jPanel2.add(jLabel3);
        jLabel3.setBounds(50, 170, 150, 30);

        jComboBox1.setFont(new java.awt.Font("Tahoma", 1, 12));
        jComboBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Nokia", "Samsung", "Sony Ericson", "Lava", "Onida", "MaxMobile", "LG" }));
        jPanel2.add(jComboBox1);
        jComboBox1.setBounds(250, 20, 140, 30);

        jLabel4.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel4.setText("Mobile Phone Model");
        jPanel2.add(jLabel4);
        jLabel4.setBounds(50, 20, 150, 30);

        jTextField2.setFont(new java.awt.Font("Tahoma", 1, 14));
        jTextField2.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusLost(java.awt.event.FocusEvent evt) {
                jTextField2FocusLost(evt);
            }
        });
        jPanel2.add(jTextField2);
        jTextField2.setBounds(250, 70, 140, 30);

        jTextField3.setFont(new java.awt.Font("Tahoma", 1, 14));
        jTextField3.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusLost(java.awt.event.FocusEvent evt) {
                jTextField3FocusLost(evt);
            }
        });
        jPanel2.add(jTextField3);
        jTextField3.setBounds(250, 120, 140, 30);

        jLabel6.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel6.setText("Enter Mobile Name");
        jPanel2.add(jLabel6);
        jLabel6.setBounds(50, 70, 160, 30);

        jTextField4.setFont(new java.awt.Font("Tahoma", 1, 14));
        jTextField4.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusLost(java.awt.event.FocusEvent evt) {
                jTextField4FocusLost(evt);
            }
        });
        jPanel2.add(jTextField4);
        jTextField4.setBounds(250, 170, 140, 30);

        jLabel8.setFont(new java.awt.Font("Tahoma", 1, 12));
        jPanel2.add(jLabel8);
        jLabel8.setBounds(410, 70, 100, 30);

        jLabel9.setFont(new java.awt.Font("Tahoma", 1, 12));
        jPanel2.add(jLabel9);
        jLabel9.setBounds(410, 120, 100, 30);

        jLabel10.setFont(new java.awt.Font("Tahoma", 1, 12));
        jPanel2.add(jLabel10);
        jLabel10.setBounds(410, 170, 100, 30);

        getContentPane().add(jPanel2);
        jPanel2.setBounds(200, 60, 570, 220);

        jButton1.setFont(new java.awt.Font("Tahoma", 1, 14));
        jButton1.setText("Enter each Phone Details");
        jButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton1ActionPerformed(evt);
            }
        });
        getContentPane().add(jButton1);
        jButton1.setBounds(780, 130, 210, 60);

        pack();
    }// </editor-fold>                        

    private void jTextField2FocusLost(java.awt.event.FocusEvent evt) {                                      
        // TODO add your handling code here:
        if(jTextField2.getText().equals(""))
        {
            jLabel8.setText("Entry Is Must");
            jTextField2.setText("");
        } 
        else
        {
            jLabel8.setText("");
            try
            {

                name=jTextField2.getText();
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
                Statement st=con.createStatement();
                ResultSet res=st.executeQuery("select * from newmobile_details");
                Boolean rec=res.next();
                if(!rec)
                {

                }
                else
                {
                    do
                    {
                        String nm=res.getString(3);
                        if(name.equals(nm))
                        {
                            jTextField3.setText(Integer.toString(res.getInt(4)));
                            
                        }
                    }while(res.next());
                    

                }
                con.commit();
                con.close();
            }
            catch(Exception e)
            {
                JOptionPane.showMessageDialog(null,"The error is :"+e);
            }
        }
}                                     

    private void jTextField3FocusLost(java.awt.event.FocusEvent evt) {                                      
        // TODO add your handling code here:
        if(jTextField3.getText().equals(""))
        {
            jLabel9.setText("Entry Is Must") ;
            jTextField3.setText("");
        }

        else
        {
            String jtf1=jTextField3.getText();
            int fg=0;
            for(int i=0;i<jtf1.length();i++)
            {
                char c=jtf1.charAt(i);
                if(Character.isLetter(c))
                {
                    fg=0;
                    break;
                }
                else
                {
                    fg=1;
                    
                }
            }
            if(fg==0)
            {
                jLabel9.setText("Enter Numbers") ;
                jTextField3.setText("");
            }
            else
                jLabel9.setText("") ;
        }
    }                                     

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:

        if(jTextField2.getText().equals("") || jTextField3.getText().equals("") || jTextField4.getText().equals("")) {

            JOptionPane.showMessageDialog(null,"Enter all appropriate fields");
            
            if(jTextField2.getText().equals("")) {
                jLabel8.setText("Fill this field");
            } else {
                jLabel8.setText("");
            }
            if(jTextField3.getText().equals("")) {
                jLabel9.setText("Fill this field");

            } else {
                jLabel9.setText("");
            }
            if(jTextField4.getText().equals("")) {
                jLabel10.setText("Fill this field");
            } else {
                jLabel10.setText("");
            }

        } 
        else
        {
            no=Integer.parseInt(jTextField4.getText());
            if(count<no)
            {
                jComboBox1.setEnabled(false);
                jTextField2.setEditable(false);
                jTextField3.setEditable(false);
                jTextField4.setEditable(false);
                jButton1.setEnabled(false);
                
                JOptionPane.showMessageDialog(null,"Enter First Mobile Phone Details");
                jTextField6.setEditable(true);
                jComboBox2.setEnabled(true);
                jComboBox3.setEnabled(true);
                jComboBox4.setEnabled(true);
                jComboBox5.setEnabled(true);
                jCheckBox1.setEnabled(true);
                jCheckBox2.setEnabled(true);
                jCheckBox3.setEnabled(true);
                jCheckBox4.setEnabled(true);
                jCheckBox5.setEnabled(true);
                jCheckBox6.setEnabled(true);
                jButton4.setEnabled(true);
                jButton3.setEnabled(true);

            }
            else
            {
                JOptionPane.showMessageDialog(null,"enter No. of Mobiles as 1 or more");
                jTextField4.setText("");
            }

            //extra requirement code
            try
            {
                pname=jTextField2.getText();
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
                Statement st=con.createStatement();
                ResultSet res=st.executeQuery("select * from newmobile_details");
                Boolean rec=res.next();
                if(!rec)
                {
                    mid=jTextField2.getText();
                    mid+="-";
                    mid+="1";
                    jTextField5.setText(mid);
                }
                else
                {
                    do
                    {
                        dpid=res.getString(1);
                        dpname=res.getString(3);
                        if(pname.equalsIgnoreCase(dpname))
                        {
                            System.out.println(dpid);

                            index=dpid.indexOf("-");

                            System.out.println(index);

                            curvalue=Integer.parseInt(dpid.substring(index+1));

                            if(prevalue<curvalue)
                            {
                                inc=curvalue+1;
                                prevalue=curvalue;
                            }
                                                        
                            mid=jTextField2.getText();
                            mid+="-";
                            mid+=Integer.toString(inc);
                            jTextField5.setText(mid);
                            b=1;
                            
                        }

                    }while(res.next());

                    if(b==0)
                    {
                        mid=jTextField2.getText();
                        mid+="-";
                        mid+="1";
                        jTextField5.setText(mid);
                    }
                }
                con.commit();
                con.close();
            }
            catch(Exception e)
            {
                JOptionPane.showMessageDialog(null,"The error is:"+e);
            }
            //extra requirement code ends here
            
       }
}                                        

    private void jTextField4FocusLost(java.awt.event.FocusEvent evt) {                                      
        // TODO add your handling code here:
        if(jTextField4.getText().equals(""))
        {
            jLabel10.setText("Entry Is Must") ;
            jTextField4.setText("");
        }

        else
        {
            String jtf1=jTextField4.getText();
            int fg=0;
            for(int i=0;i<jtf1.length();i++)
            {
                char c=jtf1.charAt(i);
                if(Character.isLetter(c))
                {
                    fg=0;
                    break;
                }
                else
                {
                    fg=1;
                    
                }
            }
            if(fg==0)
            {
                jLabel10.setText("Enter Numbers") ;
                jTextField4.setText("");
            }
            else
                jLabel10.setText("") ;
                
        }
}                                     

    private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        if(jTextField5.getText().equals("") || jTextField6.getText().equals(""))
        {
            JOptionPane.showMessageDialog(null,"Enter all appropriate fields");
            if(jTextField5.getText().equals(""))
            {
                jLabel11.setText("Fill this field");

            }
            else
            {
                jLabel11.setText("");
            }
            if(jTextField6.getText().equals(""))
            {
                jLabel12.setText("Fill this field");

            }
            else
            {
                jLabel12.setText("");
            }
            
        }
        else
        {
            
            name=jTextField2.getText();
            model=(String)jComboBox1.getSelectedItem();
            price=Integer.parseInt(jTextField3.getText());
            
            pcolor=(String)jComboBox2.getSelectedItem();
            imeino=jTextField6.getText();
            
            date1=(String)jComboBox3.getSelectedItem();
            date1+="-";
            date1+=(String)jComboBox4.getSelectedItem();
            date1+="-";
            date1+=(String)jComboBox5.getSelectedItem();

            
            cbox="";
            Boolean temp=(Boolean)jCheckBox1.isSelected();
            if(temp==true)
            {
                cbox+=(String)jCheckBox1.getText();
            }
            
            Boolean temp1=(Boolean)jCheckBox2.isSelected();
            if(temp1==true)
            {
                cbox+=(String)jCheckBox2.getText();
            }

            Boolean temp2=(Boolean)jCheckBox3.isSelected();
            if(temp2==true)
            {
                cbox+=(String)jCheckBox3.getText();
            }

            Boolean temp3=(Boolean)jCheckBox4.isSelected();
            if(temp3==true)
            {
                cbox+=(String)jCheckBox4.getText();
            }

            Boolean temp4=(Boolean)jCheckBox5.isSelected();
            if(temp4==true)
            {
                cbox+=(String)jCheckBox5.getText();
            }

            Boolean temp5=(Boolean)jCheckBox6.isSelected();
            if(temp5==true)
            {
                cbox+=(String)jCheckBox6.getText();
            }
            
            System.out.println(cbox);
            try
            {
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                Connection con = DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
                System.out.println("connected successfully");

                if(count<no)
                {
                        PreparedStatement prp=con.prepareStatement("insert into newmobile_details values(?,?,?,?,?,?,?,?)");
                                               
                        prp.setString(1,mid);
                        prp.setString(2,model);
                        prp.setString(3,name);
                        prp.setInt(4,price);
                        prp.setString(5,pcolor);
                        prp.setString(6,imeino);
                        prp.setString(7,date1);
                        prp.setString(8,cbox);
                        
                        prp.executeUpdate();

                        JOptionPane.showMessageDialog(null,"Mobiele Phone details saved successfully");

                        
                        jTextField6.setText("");

                        jComboBox2.setSelectedItem("Red");
                        jComboBox3.setSelectedItem("01");
                        jComboBox4.setSelectedItem("jan");
                        jComboBox5.setSelectedItem("2000");

                        jCheckBox1.setSelected(false);
                        jCheckBox2.setSelected(false);
                        jCheckBox3.setSelected(false);
                        jCheckBox4.setSelected(false);
                        jCheckBox5.setSelected(false);
                        jCheckBox6.setSelected(false);

                        cbox="";
                        
                        con.commit();
                        con.close();

                        count++;
                        //extra requirement code starts from here

                        index=jTextField5.getText().indexOf("-");
                        System.out.println(index);
                        inc1=Integer.parseInt(jTextField5.getText().substring(index+1));
                        inc1++;
                        System.out.print(inc1);
                        mid=jTextField2.getText();
                        mid+="-";
                        mid+=Integer.toString(inc1);
                        jTextField5.setText(mid);

                        //ends here

                        if(count<no)
                        {
                            JOptionPane.showMessageDialog(null,"Enter Next Mobile Phone Details");
                        }
                        if(count>=no)
                        {
                            
                            count=0;
                            
                            jComboBox1.setEnabled(true);
                            jTextField2.setEditable(true);
                            jTextField3.setEditable(true);
                            jTextField4.setEditable(true);
                            jButton1.setEnabled(true);
                            
                            jTextField6.setEditable(false);
                            jComboBox2.setEnabled(false);
                            jCheckBox1.setSelected(false);
                            jCheckBox2.setSelected(false);
                            jCheckBox3.setSelected(false);
                            jCheckBox4.setSelected(false);
                            jCheckBox5.setSelected(false);
                            jCheckBox6.setSelected(false);

                            jComboBox1.setSelectedItem("Nokia");
                            jComboBox2.setSelectedItem("Red");
                            jComboBox3.setSelectedItem("1");
                            jComboBox4.setSelectedItem("jan");
                            jComboBox5.setSelectedItem("2000");

                            jComboBox2.setEnabled(false);
                            jComboBox3.setEnabled(false);
                            jComboBox4.setEnabled(false);
                            jComboBox5.setEnabled(false);
                            jButton4.setEnabled(false);
                            jButton3.setEnabled(false);

                            jTextField2.setText("");
                            jTextField3.setText("");
                            jTextField4.setText("");
                            jTextField5.setText("");
                            jTextField6.setText("");

                            jCheckBox1.setEnabled(false);
                            jCheckBox2.setEnabled(false);
                            jCheckBox3.setEnabled(false);
                            jCheckBox4.setEnabled(false);
                            jCheckBox5.setEnabled(false);
                            jCheckBox6.setEnabled(false);


                        }
                      
                }
                
                
            }
            catch(SQLException e)
            {
                JOptionPane.showMessageDialog(null,"INVALID DATE, please select correct date");
                jComboBox3.setSelectedItem("01");
                jComboBox4.setSelectedItem("jan");
                jComboBox5.setSelectedItem("2000");
            }
            catch(Exception e)
            {
                JOptionPane.showMessageDialog(null,"The error is1:"+e);
                System.out.println(e.getMessage());
            }

        }
    }                                        

    private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        
        count=0;

        jComboBox1.setSelectedItem("Nokia");
        jComboBox1.setEnabled(true);
        jTextField2.setEditable(true);
        jTextField3.setEditable(true);
        jTextField4.setEditable(true);
        jButton1.setEnabled(true);
        
        jTextField2.setText("");
        jTextField3.setText("");
        jTextField4.setText("");
        jTextField5.setText("");
        jTextField6.setText("");

        jComboBox2.setSelectedItem("Red");
        jComboBox3.setSelectedItem("01");
        jComboBox4.setSelectedItem("jan");
        jComboBox5.setSelectedItem("2000");

        jCheckBox1.setSelected(false);
        jCheckBox2.setSelected(false);
        jCheckBox3.setSelected(false);
        jCheckBox4.setSelected(false);
        jCheckBox5.setSelected(false);
        jCheckBox6.setSelected(false);

        jTextField6.setEditable(false);
        jComboBox2.setEnabled(false);
        jComboBox3.setEnabled(false);
        jComboBox4.setEnabled(false);
        jComboBox5.setEnabled(false);
        jCheckBox1.setEnabled(false);
        jCheckBox2.setEnabled(false);
        jCheckBox3.setEnabled(false);
        jCheckBox4.setEnabled(false);
        jCheckBox5.setEnabled(false);
        jCheckBox6.setEnabled(false);
        jButton4.setEnabled(false);
        jButton3.setEnabled(false);

    }                                        

    private void jTextField6FocusLost(java.awt.event.FocusEvent evt) {                                      
        // TODO add your handling code here:
        if(jTextField6.getText().equals(""))
        {
            jLabel12.setText("Entry Is Must");
        }
        else
        {
            String jtf1=jTextField6.getText();
            int fg=0;
            for(int i=0;i<jtf1.length();i++)
            {
                char c=jtf1.charAt(i);
                if(Character.isLetter(c))
                {
                    fg=0;
                    break;
                }
                else
                {
                    fg=1;
                    
                }
            }
            if(fg==0)
            {
                jLabel12.setText("Enter Numbers") ;
                jTextField6.setText("");
            }
            else
            {
                jLabel12.setText("");
            }

                String imei=jTextField6.getText();
                try
                {
                    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                    Connection con = DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
                    Statement st=con.createStatement();
                    ResultSet res=st.executeQuery("select * from newmobile_details");
                    Boolean rec=res.next();
                    if(!rec)
                    {

                    }
                    else
                    {
                        do
                        {
                            String dimei=res.getString(6);
                            if(imei.equals(dimei))
                            {
                                JOptionPane.showMessageDialog(null,"The Mobile Phone is already in the database");
                                jTextField6.setText("");
                                jLabel12.setText("");
                            }
                        }while(res.next());
                    }
                }
                catch(Exception e)
                {
                    JOptionPane.showMessageDialog(null,"The error is"+e);
                }

        }
    }                                     

    private void jComboBox5FocusLost(java.awt.event.FocusEvent evt) {                                     
        // TODO add your handling code here:
        String temp1=(String)jComboBox5.getSelectedItem();
        int useryear=Integer.parseInt(temp1);
        Date curyear=new Date();
        String temp2=curyear.toString();
        temp2=temp2.substring(24,28);
        int cyear=Integer.parseInt(temp2);

        if(useryear>cyear)
        {
            JOptionPane.showMessageDialog(null,"The Manufacture Date should be on (or) before this year");
            jComboBox5.setSelectedItem("2000");
        }

    }                                    

    /**
    * @param args the command line arguments
    */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new Addmobile1().setVisible(true);
            }
        });
    }

    // Variables declaration - do not modify                     
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton3;
    private javax.swing.JButton jButton4;
    private javax.swing.JCheckBox jCheckBox1;
    private javax.swing.JCheckBox jCheckBox2;
    private javax.swing.JCheckBox jCheckBox3;
    private javax.swing.JCheckBox jCheckBox4;
    private javax.swing.JCheckBox jCheckBox5;
    private javax.swing.JCheckBox jCheckBox6;
    private javax.swing.JComboBox jComboBox1;
    private javax.swing.JComboBox jComboBox2;
    private javax.swing.JComboBox jComboBox3;
    private javax.swing.JComboBox jComboBox4;
    private javax.swing.JComboBox jComboBox5;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel10;
    private javax.swing.JLabel jLabel11;
    private javax.swing.JLabel jLabel12;
    private javax.swing.JLabel jLabel13;
    private javax.swing.JLabel jLabel18;
    private javax.swing.JLabel jLabel19;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel20;
    private javax.swing.JLabel jLabel21;
    private javax.swing.JLabel jLabel22;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel7;
    private javax.swing.JLabel jLabel8;
    private javax.swing.JLabel jLabel9;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JTextField jTextField2;
    private javax.swing.JTextField jTextField3;
    private javax.swing.JTextField jTextField4;
    private javax.swing.JTextField jTextField5;
    private javax.swing.JTextField jTextField6;
    // End of variables declaration                   

}




Code for SearchMobile Page:


/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/*
 * SearchMobile.java
 *
 * Created on Nov 7, 2010, 9:35:13 PM
 */

package mobilestorenew;

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

/**
 *
 * @author Ramesh
 */
public class SearchMobile extends javax.swing.JFrame {

    /** Creates new form SearchMobile */
    int flag=0,rows=0,b=0,sprice,eprice;
    String id,mname;
    Object data[][];
    JTable table;
    JScrollPane jsp;
    ResultSet rs;
    public SearchMobile() {
        initComponents();
        setVisible(true);
        setSize(1270,740);
        setTitle("Search Mobile Phone");
        ButtonGroup bg=new ButtonGroup();
        bg.add(jRadioButton1);
        bg.add(jRadioButton2);
        bg.add(jRadioButton3);
        jTextField2.setEditable(false);
        jTextField3.setEditable(false);
        jTextField4.setEditable(false);
        jsp.setVisible(false);
        
    }
    public void tabledisp()
    {
                try
                {

                    data=new Object[rows][8];
                    Object[] colheads={"Mobile Phone Id","Mobile Phone Model","Mobile Phone Name","Mobile Phone Price","phone color","IMEI no","Manufacture Date","Accessories"};


                    Class.forName("sun.jdbc.odbc.JdbcOdbc");
                    Connection con=DriverManager.getConnection("Jdbc:Odbc:mobileDSN","scott","tiger");
                    Statement st=con.createStatement();

                    rs=st.executeQuery("select * from msearch");
                    for(int i=0;i<rows;i++)
                    {
                            rs.next();
                            for(int j=0;j<8;j++)
                            {
                                data [i][j]=rs.getString(j+1);
                                System.out.println(data[i][j]);
                            }
                    }
                    table=new JTable(data,colheads);

                    int v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED;
                    int h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED;
                    jsp=new JScrollPane(table,v,h);
                    jsp.setBounds(70,420,900,200);
                    jPanel2.add(jsp);
                    add(jsp);
                    System.out.println("hai we came here");
                    rows=0;
                    st.close();
                    con.commit();
                    con.close();

                }
                catch(Exception e)
                {
                    JOptionPane.showMessageDialog(null,"here the error is:"+e);
                }

    }

    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">                          
    private void initComponents() {

        jPanel2 = new javax.swing.JPanel();
        jPanel1 = new javax.swing.JPanel();
        jTextField1 = new javax.swing.JTextField();
        jRadioButton1 = new javax.swing.JRadioButton();
        jRadioButton2 = new javax.swing.JRadioButton();
        jRadioButton3 = new javax.swing.JRadioButton();
        jTextField2 = new javax.swing.JTextField();
        jTextField3 = new javax.swing.JTextField();
        jTextField4 = new javax.swing.JTextField();
        jLabel2 = new javax.swing.JLabel();
        jLabel3 = new javax.swing.JLabel();
        jLabel4 = new javax.swing.JLabel();
        jButton1 = new javax.swing.JButton();
        jButton2 = new javax.swing.JButton();
        jLabel1 = new javax.swing.JLabel();

        setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
        getContentPane().setLayout(null);

        jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Search Results", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 1, 12))); // NOI18N
        jPanel2.setLayout(null);
        getContentPane().add(jPanel2);
        jPanel2.setBounds(50, 380, 940, 260);

        jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
        jPanel1.setLayout(null);

        jTextField1.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
        jTextField1.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusGained(java.awt.event.FocusEvent evt) {
                jTextField1FocusGained(evt);
            }
        });
        jPanel1.add(jTextField1);
        jTextField1.setBounds(290, 40, 150, 30);

        jRadioButton1.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
        jRadioButton1.setSelected(true);
        jRadioButton1.setText(" Search By Mobile ID or IMEI No.");
        jRadioButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jRadioButton1ActionPerformed(evt);
            }
        });
        jPanel1.add(jRadioButton1);
        jRadioButton1.setBounds(20, 40, 260, 25);

        jRadioButton2.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
        jRadioButton2.setText(" Search By Mobile Name");
        jRadioButton2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jRadioButton2ActionPerformed(evt);
            }
        });
        jPanel1.add(jRadioButton2);
        jRadioButton2.setBounds(20, 100, 200, 25);

        jRadioButton3.setFont(new java.awt.Font("Tahoma", 1, 14));
        jRadioButton3.setText("Search By Mobile Price");
        jRadioButton3.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jRadioButton3ActionPerformed(evt);
            }
        });
        jPanel1.add(jRadioButton3);
        jRadioButton3.setBounds(20, 160, 190, 25);

        jTextField2.setFont(new java.awt.Font("Tahoma", 1, 14));
        jTextField2.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusGained(java.awt.event.FocusEvent evt) {
                jTextField2FocusGained(evt);
            }
        });
        jPanel1.add(jTextField2);
        jTextField2.setBounds(290, 100, 150, 30);

        jTextField3.setFont(new java.awt.Font("Tahoma", 1, 14));
        jTextField3.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusGained(java.awt.event.FocusEvent evt) {
                jTextField3FocusGained(evt);
            }
        });
        jPanel1.add(jTextField3);
        jTextField3.setBounds(290, 160, 150, 30);

        jTextField4.setFont(new java.awt.Font("Tahoma", 1, 14));
        jTextField4.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusGained(java.awt.event.FocusEvent evt) {
                jTextField4FocusGained(evt);
            }
        });
        jPanel1.add(jTextField4);
        jTextField4.setBounds(480, 160, 130, 30);

        jLabel2.setFont(new java.awt.Font("Tahoma", 1, 12));
        jLabel2.setText("to");
        jPanel1.add(jLabel2);
        jLabel2.setBounds(450, 160, 20, 30);
        jPanel1.add(jLabel3);
        jLabel3.setBounds(460, 40, 120, 30);
        jPanel1.add(jLabel4);
        jLabel4.setBounds(460, 100, 120, 30);

        getContentPane().add(jPanel1);
        jPanel1.setBounds(50, 100, 640, 250);

        jButton1.setFont(new java.awt.Font("Tahoma", 1, 18));
        jButton1.setText("Search");
        jButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton1ActionPerformed(evt);
            }
        });
        getContentPane().add(jButton1);
        jButton1.setBounds(720, 200, 120, 50);

        jButton2.setFont(new java.awt.Font("Tahoma", 1, 18));
        jButton2.setText("Cancel");
        jButton2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton2ActionPerformed(evt);
            }
        });
        getContentPane().add(jButton2);
        jButton2.setBounds(870, 200, 110, 50);

        jLabel1.setFont(new java.awt.Font("Tahoma", 1, 24));
        jLabel1.setText("Search Mobile Phone Details");
        getContentPane().add(jLabel1);
        jLabel1.setBounds(320, 20, 350, 50);

        pack();
    }// </editor-fold>                        

    private void jRadioButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                              
        // TODO add your handling code here:

        jTextField2.setEditable(true);
        jTextField1.setEditable(false);
        jTextField3.setEditable(false);
        jTextField4.setEditable(false);
        jTextField1.setText("");
        jTextField3.setText("");
        jTextField4.setText("");
        flag=1;
        jsp.setVisible(false);
}                                             

    private void jRadioButton3ActionPerformed(java.awt.event.ActionEvent evt) {                                              
        // TODO add your handling code here:
        jTextField3.setEditable(true);
        jTextField4.setEditable(true);
        jTextField1.setEditable(false);
        jTextField2.setEditable(false);
        jTextField4.setText("");
        jTextField1.setText("");
        jTextField2.setText("");
        flag=2;
        jsp.setVisible(false);
}                                             

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        if(flag==0)
        {
            if(jTextField1.getText().equals(""))
            {
                jLabel3.setText("Entry is Must");
            }
            else
            {
                id=jTextField1.getText();
                try
                {
                    Class.forName("sun.jdbc.odbc.JdbcOdbc");
                    Connection con=DriverManager.getConnection("Jdbc:Odbc:mobileDSN","scott","tiger");
                    Statement st=con.createStatement();
                    st.executeUpdate("delete msearch");
                    ResultSet res=st.executeQuery("select * from newmobile_details");
                    Boolean rec=res.next();
                    if(!rec)
                    {
                        JOptionPane.showMessageDialog(null,"There are no records");

                    }
                    else
                    {
                        do
                        {
                            String mid=res.getString(1);
                            String model=res.getString(2);
                            String name=res.getString(3);
                            int price=res.getInt(4);
                            String pcolor=res.getString(5);
                            String imei=res.getString(6);
                            java.sql.Date date=res.getDate(7);
                            String access=res.getString(8);

                            if(id.equals(mid) || id.equals(imei))
                            {
                                System.out.println("iam inside");

                                PreparedStatement prp=con.prepareStatement("insert into msearch values(?,?,?,?,?,?,?,?)");
                                prp.setString(1,mid);
                                prp.setString(2,model);
                                prp.setString(3,name);
                                prp.setInt(4,price);
                                prp.setString(5,pcolor);
                                prp.setString(6,imei);
                                prp.setDate(7,date);
                                prp.setString(8,access);

                                prp.executeUpdate();

                                System.out.println("iam inside2");
                                rows++;

                                b=1;
                                jTextField1.setText("");
                            }


                        }while(res.next());
                        if(b==0)
                        {
                            JOptionPane.showMessageDialog(null,"The mobile phone does not exists ");
                            jTextField1.setText("");
                        }
                    }
                    con.commit();
                    con.close();
                }
                catch(Exception e)
                {
                    JOptionPane.showMessageDialog(null,"The error is1:" +e);
                }
                tabledisp();
            }
        }
        
        else if(flag==1)
        {
            if(jTextField2.getText().equals(""))
            {
                jLabel4.setText("Entry is Must");
            }
            else
            {
                mname=jTextField2.getText();
                try
                {
                    Class.forName("sun.jdbc.odbc.JdbcOdbc");
                    Connection con=DriverManager.getConnection("Jdbc:Odbc:mobileDSN","scott","tiger");
                    Statement st=con.createStatement();
                    st.executeUpdate("delete msearch");
                    ResultSet res=st.executeQuery("select * from newmobile_details");
                    Boolean rec=res.next();
                    if(!rec)
                    {
                        JOptionPane.showMessageDialog(null,"There are no records");
                    }
                    else
                    {
                        do
                        {
                            String mid=res.getString(1);
                            String model=res.getString(2);
                            String name=res.getString(3);
                            int price=res.getInt(4);
                            String pcolor=res.getString(5);
                            String imei=res.getString(6);
                            java.sql.Date date=res.getDate(7);
                            String access=res.getString(8);

                            if(mname.equalsIgnoreCase(name))
                            {
                                PreparedStatement prp=con.prepareStatement("insert into msearch values(?,?,?,?,?,?,?,?)");
                                prp.setString(1,mid);
                                prp.setString(2,model);
                                prp.setString(3,name);
                                prp.setInt(4,price);
                                prp.setString(5,pcolor);
                                prp.setString(6,imei);
                                prp.setDate(7,date);
                                prp.setString(8,access);

                                prp.executeUpdate();

                                System.out.println("iam inside2");
                                rows++;

                                b=1;
                                jTextField2.setText("");
                            }


                        }while(res.next());
                        if(b==0)
                        {
                            JOptionPane.showMessageDialog(null,"The mobile does not exists ");
                            jTextField2.setText("");
                        }
                    }
                    con.commit();
                    con.close();
                }
                catch(Exception e)
                {
                    JOptionPane.showMessageDialog(null,"The error is1:" +e);
                }
                tabledisp();
                
            }
        }
        else if(flag==2)
        {
            if(jTextField3.getText().equals("") || jTextField4.getText().equals(""))
            {
                JOptionPane.showMessageDialog(null,"Fill the both fields");
            }
            else if(Integer.parseInt(jTextField3.getText())>Integer.parseInt(jTextField4.getText()))
            {
                JOptionPane.showMessageDialog(null,"First Enter small price and then Enter Big Price");
                jTextField3.setText("");
                jTextField4.setText("");
            }
            else
            {
                sprice=Integer.parseInt(jTextField3.getText());
                eprice=Integer.parseInt(jTextField4.getText());
                try
                {
                    Class.forName("sun.jdbc.odbc.JdbcOdbc");
                    Connection con=DriverManager.getConnection("Jdbc:Odbc:mobileDSN","scott","tiger");
                    Statement st=con.createStatement();
                    st.executeUpdate("delete msearch");
                    ResultSet res=st.executeQuery("select * from newmobile_details");
                    Boolean rec=res.next();
                    if(!rec)
                    {
                        JOptionPane.showMessageDialog(null,"There are no records");
                    }
                    else
                    {
                            do
                            {

                                String mid=res.getString(1);
                                String model=res.getString(2);
                                String name=res.getString(3);
                                int price=res.getInt(4);
                                String pcolor=res.getString(5);
                                String imei=res.getString(6);
                                java.sql.Date date=res.getDate(7);
                                String access=res.getString(8);

                                System.out.append("iam stuck here");
                                for(int i=sprice;i<=eprice;i++)
                                {
                                    if(i==price)
                                    {
                                        PreparedStatement prp=con.prepareStatement("insert into msearch values(?,?,?,?,?,?,?,?)");
                                        prp.setString(1,mid);
                                        prp.setString(2,model);
                                        prp.setString(3,name);
                                        prp.setInt(4,price);
                                        prp.setString(5,pcolor);
                                        prp.setString(6,imei);
                                        prp.setDate(7,date);
                                        prp.setString(8,access);

                                        prp.executeUpdate();

                                        System.out.println("iam inside2");
                                        rows++;
                                        b=1;
                                        jTextField3.setText("");
                                        jTextField4.setText("");

                                    }
                                }
                            }while(res.next());

                            if(b==0)
                            {
                                JOptionPane.showMessageDialog(null,"There are no mobiles between the price you entered");
                                jTextField3.setText("");
                                jTextField4.setText("");
                            }
                        
                    }
                }
                catch(Exception e)
                {
                    JOptionPane.showMessageDialog(null,"The error is:"+e);
                }
                tabledisp();
                
            }
        }
        

    }                                        

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        jTextField1.setText("");
        jTextField2.setText("");
        jTextField3.setText("");
        jTextField4.setText("");
}                                        

    private void jTextField1FocusGained(java.awt.event.FocusEvent evt) {                                        
        // TODO add your handling code here:
        jsp.setVisible(false);
        b=0;
    }                                       

    private void jTextField2FocusGained(java.awt.event.FocusEvent evt) {                                        
        // TODO add your handling code here:
        jsp.setVisible(false);
        b=0;
    }                                       

    private void jTextField3FocusGained(java.awt.event.FocusEvent evt) {                                        
        // TODO add your handling code here:
        jsp.setVisible(false);
        b=0;
    }                                       

    private void jTextField4FocusGained(java.awt.event.FocusEvent evt) {                                        
        // TODO add your handling code here:
        jsp.setVisible(false);
        b=0;
    }                                       

    private void jRadioButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                              
        // TODO add your handling code here:
        flag=0;
        jTextField1.setEditable(true);
        jTextField2.setEditable(false);
        jTextField3.setEditable(false);
        jTextField4.setEditable(false);
        jTextField2.setText("");
        jTextField2.setText("");
        jTextField2.setText("");

    }                                             

    /**
    * @param args the command line arguments
    */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new SearchMobile().setVisible(true);
            }
        });
    }

    // Variables declaration - do not modify                     
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton2;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JRadioButton jRadioButton1;
    private javax.swing.JRadioButton jRadioButton2;
    private javax.swing.JRadioButton jRadioButton3;
    private javax.swing.JTextField jTextField1;
    private javax.swing.JTextField jTextField2;
    private javax.swing.JTextField jTextField3;
    private javax.swing.JTextField jTextField4;
    // End of variables declaration                   

}





Code for UpdateMobile Page:


/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/*
 * MobileUpdate.java
 *
 * Created on Sep 12, 2010, 11:49:21 PM
 */

package mobilestorenew;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JOptionPane;

/**
 *
 * @author Ramesh
 */
public class MobileUpdate extends javax.swing.JFrame {

    /** Creates new form MobileUpdate */
    String model,name,cbox;
    
    int price,i1;
    
    String id,s1,s2,s3,s4,s5,pcolor,date;
    int a=0;
    int b=0;
    String imeino;
    String dt,year,ddate,mc,month;
    
    
    public MobileUpdate() {
        initComponents();
        setVisible(true);
        setSize(1270,740);
        setTitle("Update Mobile Details");
        disflds();
        JOptionPane.showMessageDialog(null,"Enter Phone Id (or) IMEI No. in the First Text Field");
        
    }
public void disflds()
{
        jComboBox1.setEnabled(false);
        jComboBox2.setEnabled(false);
        jComboBox3.setEnabled(false);
        jComboBox4.setEnabled(false);
        jComboBox5.setEnabled(false);

        jTextField2.setEditable(false);
        jTextField3.setEditable(false);
        jTextField4.setEditable(false);

        jCheckBox1.setEnabled(false);
        jCheckBox2.setEnabled(false);
        jCheckBox3.setEnabled(false);
        jCheckBox4.setEnabled(false);
        jCheckBox5.setEnabled(false);
        jCheckBox6.setEnabled(false);

        jButton1.setEnabled(false);
}
public void clrcombocheck()
{
    jComboBox1.setSelectedItem("Nokia");
    jComboBox2.setSelectedItem("Red");
    jComboBox3.setSelectedItem("01");
    jComboBox4.setSelectedItem("jan");
    jComboBox5.setSelectedItem("2000");

    jCheckBox1.setSelected(false);
    jCheckBox2.setSelected(false);
    jCheckBox3.setSelected(false);
    jCheckBox4.setSelected(false);
    jCheckBox5.setSelected(false);
    jCheckBox6.setSelected(false);
}

    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">                          
    private void initComponents() {

        jLabel1 = new javax.swing.JLabel();
        jPanel1 = new javax.swing.JPanel();
        jLabel2 = new javax.swing.JLabel();
        jTextField1 = new javax.swing.JTextField();
        jLabel4 = new javax.swing.JLabel();
        jLabel5 = new javax.swing.JLabel();
        jTextField2 = new javax.swing.JTextField();
        jLabel6 = new javax.swing.JLabel();
        jTextField3 = new javax.swing.JTextField();
        jLabel3 = new javax.swing.JLabel();
        jTextField4 = new javax.swing.JTextField();
        jLabel7 = new javax.swing.JLabel();
        jComboBox2 = new javax.swing.JComboBox();
        jLabel8 = new javax.swing.JLabel();
        jLabel9 = new javax.swing.JLabel();
        jCheckBox1 = new javax.swing.JCheckBox();
        jCheckBox2 = new javax.swing.JCheckBox();
        jCheckBox3 = new javax.swing.JCheckBox();
        jCheckBox4 = new javax.swing.JCheckBox();
        jCheckBox5 = new javax.swing.JCheckBox();
        jCheckBox6 = new javax.swing.JCheckBox();
        jLabel10 = new javax.swing.JLabel();
        jComboBox1 = new javax.swing.JComboBox();
        jComboBox3 = new javax.swing.JComboBox();
        jComboBox4 = new javax.swing.JComboBox();
        jComboBox5 = new javax.swing.JComboBox();
        jLabel11 = new javax.swing.JLabel();
        jLabel12 = new javax.swing.JLabel();
        jLabel13 = new javax.swing.JLabel();
        jPanel2 = new javax.swing.JPanel();
        jButton2 = new javax.swing.JButton();
        jButton1 = new javax.swing.JButton();

        setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
        setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));
        getContentPane().setLayout(null);

        jLabel1.setFont(new java.awt.Font("Tahoma", 1, 24));
        jLabel1.setText("Update Mobile Phone Details");
        getContentPane().add(jLabel1);
        jLabel1.setBounds(370, 20, 343, 50);

        jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder("Update Mobile Details"));
        jPanel1.setLayout(null);

        jLabel2.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel2.setText("Mobile Phone Price");
        jPanel1.add(jLabel2);
        jLabel2.setBounds(100, 210, 160, 30);

        jTextField1.setFont(new java.awt.Font("Tahoma", 1, 14));
        jTextField1.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusLost(java.awt.event.FocusEvent evt) {
                jTextField1FocusLost(evt);
            }
        });
        jPanel1.add(jTextField1);
        jTextField1.setBounds(290, 40, 140, 30);

        jLabel4.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel4.setText("Mobile Phone Model");
        jPanel1.add(jLabel4);
        jLabel4.setBounds(100, 100, 150, 30);

        jLabel5.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel5.setText("Enter Phone Id (or) IMEI No.");
        jPanel1.add(jLabel5);
        jLabel5.setBounds(60, 40, 210, 30);

        jTextField2.setFont(new java.awt.Font("Tahoma", 1, 14));
        jTextField2.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyTyped(java.awt.event.KeyEvent evt) {
                jTextField2KeyTyped(evt);
            }
        });
        jPanel1.add(jTextField2);
        jTextField2.setBounds(290, 160, 140, 30);

        jLabel6.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel6.setText("Mobile Phone Name");
        jPanel1.add(jLabel6);
        jLabel6.setBounds(100, 150, 160, 30);

        jTextField3.setFont(new java.awt.Font("Tahoma", 1, 14));
        jTextField3.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyTyped(java.awt.event.KeyEvent evt) {
                jTextField3KeyTyped(evt);
            }
        });
        jPanel1.add(jTextField3);
        jTextField3.setBounds(290, 220, 140, 30);

        jLabel3.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel3.setText("Mobile Phone Color");
        jPanel1.add(jLabel3);
        jLabel3.setBounds(100, 280, 140, 30);

        jTextField4.setFont(new java.awt.Font("Tahoma", 1, 14));
        jTextField4.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyTyped(java.awt.event.KeyEvent evt) {
                jTextField4KeyTyped(evt);
            }
        });
        jPanel1.add(jTextField4);
        jTextField4.setBounds(290, 340, 140, 30);

        jLabel7.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel7.setText("IMEI No");
        jPanel1.add(jLabel7);
        jLabel7.setBounds(100, 340, 100, 30);

        jComboBox2.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
        jComboBox2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Red", "Green", "Blue", "Black", "White", "Cyan", "Yellow", "Orange", "Purple", "Pink", "Voilet", "Magenta" }));
        jComboBox2.addItemListener(new java.awt.event.ItemListener() {
            public void itemStateChanged(java.awt.event.ItemEvent evt) {
                jComboBox2ItemStateChanged(evt);
            }
        });
        jPanel1.add(jComboBox2);
        jComboBox2.setBounds(290, 280, 140, 30);

        jLabel8.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel8.setText("Date of Manufacture");
        jPanel1.add(jLabel8);
        jLabel8.setBounds(100, 390, 150, 30);

        jLabel9.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel9.setText("Additional Accessories");
        jPanel1.add(jLabel9);
        jLabel9.setBounds(100, 440, 170, 20);

        jCheckBox1.setFont(new java.awt.Font("Tahoma", 1, 11));
        jCheckBox1.setText("Charger ");
        jCheckBox1.addItemListener(new java.awt.event.ItemListener() {
            public void itemStateChanged(java.awt.event.ItemEvent evt) {
                jCheckBox1ItemStateChanged(evt);
            }
        });
        jPanel1.add(jCheckBox1);
        jCheckBox1.setBounds(290, 440, 80, 23);

        jCheckBox2.setFont(new java.awt.Font("Tahoma", 1, 11));
        jCheckBox2.setText("HeadSet ");
        jCheckBox2.addItemListener(new java.awt.event.ItemListener() {
            public void itemStateChanged(java.awt.event.ItemEvent evt) {
                jCheckBox2ItemStateChanged(evt);
            }
        });
        jPanel1.add(jCheckBox2);
        jCheckBox2.setBounds(400, 440, 80, 23);

        jCheckBox3.setFont(new java.awt.Font("Tahoma", 1, 11));
        jCheckBox3.setText("DataCable ");
        jCheckBox3.addItemListener(new java.awt.event.ItemListener() {
            public void itemStateChanged(java.awt.event.ItemEvent evt) {
                jCheckBox3ItemStateChanged(evt);
            }
        });
        jPanel1.add(jCheckBox3);
        jCheckBox3.setBounds(290, 470, 100, 23);

        jCheckBox4.setFont(new java.awt.Font("Tahoma", 1, 11));
        jCheckBox4.setText("Battery ");
        jCheckBox4.addItemListener(new java.awt.event.ItemListener() {
            public void itemStateChanged(java.awt.event.ItemEvent evt) {
                jCheckBox4ItemStateChanged(evt);
            }
        });
        jPanel1.add(jCheckBox4);
        jCheckBox4.setBounds(400, 470, 80, 23);

        jCheckBox5.setFont(new java.awt.Font("Tahoma", 1, 11));
        jCheckBox5.setText("MemoryCard ");
        jCheckBox5.addItemListener(new java.awt.event.ItemListener() {
            public void itemStateChanged(java.awt.event.ItemEvent evt) {
                jCheckBox5ItemStateChanged(evt);
            }
        });
        jPanel1.add(jCheckBox5);
        jCheckBox5.setBounds(290, 500, 101, 23);

        jCheckBox6.setFont(new java.awt.Font("Tahoma", 1, 11));
        jCheckBox6.setText("CD ");
        jCheckBox6.addItemListener(new java.awt.event.ItemListener() {
            public void itemStateChanged(java.awt.event.ItemEvent evt) {
                jCheckBox6ItemStateChanged(evt);
            }
        });
        jPanel1.add(jCheckBox6);
        jCheckBox6.setBounds(400, 500, 50, 23);
        jPanel1.add(jLabel10);
        jLabel10.setBounds(440, 40, 120, 30);

        jComboBox1.setFont(new java.awt.Font("Tahoma", 1, 12));
        jComboBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Nokia", "Samsung", "Sony Ericson", "Lava", "Onida", "MaxMobile", "LG" }));
        jComboBox1.addItemListener(new java.awt.event.ItemListener() {
            public void itemStateChanged(java.awt.event.ItemEvent evt) {
                jComboBox1ItemStateChanged(evt);
            }
        });
        jPanel1.add(jComboBox1);
        jComboBox1.setBounds(290, 100, 140, 30);

        jComboBox3.setFont(new java.awt.Font("Tahoma", 1, 12));
        jComboBox3.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "31" }));
        jComboBox3.addItemListener(new java.awt.event.ItemListener() {
            public void itemStateChanged(java.awt.event.ItemEvent evt) {
                jComboBox3ItemStateChanged(evt);
            }
        });
        jPanel1.add(jComboBox3);
        jComboBox3.setBounds(290, 390, 50, 30);

        jComboBox4.setFont(new java.awt.Font("Tahoma", 1, 12));
        jComboBox4.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "jan", "feb", "mar", "apr", "may", "jun", "jul", "aug", "sep", "oct", "nov", "dec" }));
        jComboBox4.addItemListener(new java.awt.event.ItemListener() {
            public void itemStateChanged(java.awt.event.ItemEvent evt) {
                jComboBox4ItemStateChanged(evt);
            }
        });
        jPanel1.add(jComboBox4);
        jComboBox4.setBounds(380, 390, 56, 30);

        jComboBox5.setFont(new java.awt.Font("Tahoma", 1, 12));
        jComboBox5.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "2000", "2001", "2002", "2003", "2004", "2005", "2006", "2007", "2008", "2009", "2010", "2011", "2012", "2013", "2014", "2015", "2016", "2017", "2018", "2019", "2020" }));
        jComboBox5.addItemListener(new java.awt.event.ItemListener() {
            public void itemStateChanged(java.awt.event.ItemEvent evt) {
                jComboBox5ItemStateChanged(evt);
            }
        });
        jPanel1.add(jComboBox5);
        jComboBox5.setBounds(490, 390, 60, 30);

        jLabel11.setFont(new java.awt.Font("Tahoma", 1, 12));
        jLabel11.setText("(DD)");
        jPanel1.add(jLabel11);
        jLabel11.setBounds(340, 390, 28, 30);

        jLabel12.setFont(new java.awt.Font("Tahoma", 1, 12));
        jLabel12.setText("(MM)");
        jPanel1.add(jLabel12);
        jLabel12.setBounds(440, 390, 40, 30);

        jLabel13.setFont(new java.awt.Font("Tahoma", 1, 12));
        jLabel13.setText("(YY)");
        jPanel1.add(jLabel13);
        jLabel13.setBounds(550, 390, 24, 30);

        getContentPane().add(jPanel1);
        jPanel1.setBounds(210, 70, 590, 530);

        jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
        jPanel2.setLayout(null);

        jButton2.setFont(new java.awt.Font("Tahoma", 1, 18));
        jButton2.setText("Cancel");
        jButton2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton2ActionPerformed(evt);
            }
        });
        jPanel2.add(jButton2);
        jButton2.setBounds(280, 20, 110, 40);

        jButton1.setFont(new java.awt.Font("Tahoma", 1, 18));
        jButton1.setText("Update Mobile Details");
        jButton1.setEnabled(false);
        jButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton1ActionPerformed(evt);
            }
        });
        jPanel2.add(jButton1);
        jButton1.setBounds(30, 20, 240, 40);

        getContentPane().add(jPanel2);
        jPanel2.setBounds(320, 610, 410, 80);

        pack();
    }// </editor-fold>                        

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        id=jTextField1.getText();

        model=(String)jComboBox1.getSelectedItem();
        name=jTextField2.getText();
        price=Integer.parseInt(jTextField3.getText());
        pcolor=(String)jComboBox2.getSelectedItem();
        imeino=jTextField4.getText();

        date=(String)jComboBox3.getSelectedItem();
        date+="-";
        date+=(String)jComboBox4.getSelectedItem();
        date+="-";
        date+=(String)jComboBox5.getSelectedItem();

        cbox=null;

        Boolean temp=(Boolean)jCheckBox1.isSelected();
            if(temp==true)
            {
                cbox+=(String)jCheckBox1.getText();
            }

            Boolean temp1=(Boolean)jCheckBox2.isSelected();
            if(temp1==true)
            {
                cbox+=(String)jCheckBox2.getText();
            }

            Boolean temp2=(Boolean)jCheckBox3.isSelected();
            if(temp2==true)
            {
                cbox+=(String)jCheckBox3.getText();
            }

            Boolean temp3=(Boolean)jCheckBox4.isSelected();
            if(temp3==true)
            {
                cbox+=(String)jCheckBox4.getText();
            }

            Boolean temp4=(Boolean)jCheckBox5.isSelected();
            if(temp4==true)
            {
                cbox+=(String)jCheckBox5.getText();
            }

            Boolean temp5=(Boolean)jCheckBox6.isSelected();
            if(temp5==true)
            {
                cbox+=(String)jCheckBox6.getText();
            }

            cbox=cbox.substring(4);
        try
	{

    		Connection con;
		Statement st;

		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
		st=con.createStatement();
					
                PreparedStatement prp=con.prepareStatement("update newmobile_details set mobile_model=?,mobile_name=?,mobile_price=?,pcolor=?,imeino=?,mdate=?,accessories=? where phone_id=?");
                prp.setString(1,model);
                prp.setString(2,name);
                prp.setInt(3,price);
                prp.setString(4,pcolor);
                prp.setString(5,imeino);
                prp.setString(6,date);
                prp.setString(7,cbox);
                prp.setString(8,id);
                prp.executeUpdate();
                JOptionPane.showMessageDialog(null,"Mobile Phone details updated successfully");
                jTextField1.setText("");
                jTextField2.setText("");
                jTextField2.setText("");
                jTextField3.setText("");
                jTextField4.setText("");

                cbox=null;
                
                jTextField1.setEditable(true);

                disflds();

                clrcombocheck();
                jButton1.setEnabled(false);
                con.commit();
		con.close();
	}
	catch(Exception e)
	{
		System.out.println(e.getMessage());
                JOptionPane.showMessageDialog(null,"error is:"+e);
	}
    }                                        

    private void jTextField1FocusLost(java.awt.event.FocusEvent evt) {                                      
        // TODO add your handling code here:
        if(jTextField1.getText().equals(""))
        {
            jLabel10.setText("Entry is Must");
        }
        else
        {
                id=jTextField1.getText();
                try
                {
                        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                        Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
                        Statement st=con.createStatement();
                        ResultSet res=st.executeQuery("select * from newmobile_details");
                        Boolean rec=res.next();
                        if(!rec)
                        {
                                JOptionPane.showMessageDialog(null,"There are no mobiles in the database");
                                jTextField1.setText("");
                        }
                        else
                        {
                                do
                                {
                                       s1=res.getString(1);
                                       s2=res.getString(2);
                                       s3=res.getString(3);
                                       i1=res.getInt(4);
                                       s4=res.getString(5);
                                       s5=res.getString(6);


                                       if(id.equalsIgnoreCase(s1) || id.equalsIgnoreCase(s5))
                                       {
                              
                                            jTextField1.setEditable(false);
                                            jTextField2.setEditable(true);
                                            jTextField2.setEditable(true);
                                            jTextField3.setEditable(true);
                                            jTextField4.setEditable(true);

                                            jComboBox1.setEnabled(true);
                                            jComboBox2.setEnabled(true);
                                            jComboBox3.setEnabled(true);
                                            jComboBox4.setEnabled(true);
                                            jComboBox5.setEnabled(true);

                                            jCheckBox1.setEnabled(true);
                                            jCheckBox2.setEnabled(true);
                                            jCheckBox3.setEnabled(true);
                                            jCheckBox4.setEnabled(true);
                                            jCheckBox5.setEnabled(true);
                                            jCheckBox6.setEnabled(true);
                                            jComboBox2.setEnabled(true);

                                            jLabel5.setText("          Mobile Phone Id");

                                            jLabel10.setText("");

                                            b=1;

                                            jTextField1.setText(s1);
                                            jComboBox1.setSelectedItem(s2);
                                            jTextField2.setText(s3);
                                            jTextField3.setText(Integer.toString(i1));
                                            jComboBox2.setSelectedItem(s4);
                                            jTextField4.setText(s5);

                                            dt=res.getDate(7).toString();
                                            System.out.println(dt);

                                            year=dt.substring(0,4);
                                            System.out.println(year);

                                            month=dt.substring(5,7);
                                            System.out.println(month);

                                            ddate=dt.substring(8,10);
                                            System.out.println(ddate);
                                            if(month.equals("01"))
                                            {
                                                mc="jan";
                                            }
                                            else if(month.equals("02"))
                                            {
                                                mc="feb";
                                            }
                                            else if(month.equals("03"))
                                            {
                                                mc="mar";
                                            }
                                            else if(month.equals("04"))
                                            {
                                                mc="apr";
                                            }
                                            else if(month.equals("05"))
                                            {
                                                mc="may";
                                            }
                                            else if(month.equals("06"))
                                            {
                                                mc="jun";
                                            }
                                            else if(month.equals("07"))
                                            {
                                                mc="jul";
                                            }
                                            else if(month.equals("08"))
                                            {
                                                mc="aug";
                                            }
                                            else if(month.equals("09"))
                                            {
                                                mc="sep";
                                            }
                                            else if(month.equals("10"))
                                            {
                                                mc="oct";
                                            }
                                            else if(month.equals("11"))
                                            {
                                                mc="nov";
                                            }
                                            else if(month.equals("12"))
                                            {
                                                mc="dec";
                                            }

                                            jComboBox3.setSelectedItem(ddate);
                                            jComboBox4.setSelectedItem(mc);
                                            jComboBox5.setSelectedItem(year);
                                            
                                            cbox=res.getString(8);
                                            Boolean cb1=cbox.contains("Charger");
                                            if(cb1==true)
                                            {
                                                jCheckBox1.setSelected(true);
                                            }
                                            else
                                            {                                               
                                            }

                                            Boolean cb2=cbox.contains("HeadSet");
                                            if(cb2==true)
                                            {
                                                jCheckBox2.setSelected(true);
                                            }
                                            else
                                            {                                               
                                            }

                                            Boolean cb3=cbox.contains("DataCable");
                                            if(cb3==true)
                                            {
                                                jCheckBox3.setSelected(true);
                                            }
                                            else
                                            {                                                
                                            }

                                            Boolean cb4=cbox.contains("Battery");
                                            if(cb4==true)
                                            {
                                                jCheckBox4.setSelected(true);
                                            }
                                            else
                                            {                                                
                                            }

                                            Boolean cb5=cbox.contains("MemoryCard");
                                            if(cb5==true)
                                            {
                                                jCheckBox5.setSelected(true);
                                            }
                                            else
                                            {                                                
                                            }

                                            Boolean cb6=cbox.contains("CD");
                                            if(cb6==true)
                                            {
                                                jCheckBox6.setSelected(true);
                                            }
                                            else
                                            {                                                
                                            }

                                            jButton1.setEnabled(false);
                                        }
                                }while(res.next());

                                if(b!=1)
                                {
                                    JOptionPane.showMessageDialog(null,"The mobile details does not exists in the database");
                                    jTextField1.setText("");
                                    jLabel10.setText("");
                                }
                        }
                        con.commit();
                        con.close();
                }
                catch(Exception e)
                {
                    JOptionPane.showMessageDialog(null,"There are no additional accessories for this mobile");
                    jButton1.setEnabled(false);
                }
        }
    }                                     

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        jTextField1.setText("");
        jTextField2.setText("");
        jTextField3.setText("");
        jTextField4.setText("");
        
        jTextField1.setEditable(true);

        disflds();

        clrcombocheck();

        b=0;
    }                                        

    private void jTextField4KeyTyped(java.awt.event.KeyEvent evt) {                                     
        // TODO add your handling code here:
        jButton1.setEnabled(true);
    }                                    

    private void jTextField3KeyTyped(java.awt.event.KeyEvent evt) {                                     
        // TODO add your handling code here:
        jButton1.setEnabled(true);
    }                                    

    private void jComboBox2ItemStateChanged(java.awt.event.ItemEvent evt) {                                            
        // TODO add your handling code here:
        jButton1.setEnabled(true);
    }                                           

    private void jComboBox3ItemStateChanged(java.awt.event.ItemEvent evt) {                                            
        // TODO add your handling code here:
        jButton1.setEnabled(true);
    }                                           

    private void jComboBox4ItemStateChanged(java.awt.event.ItemEvent evt) {                                            
        // TODO add your handling code here:
        jButton1.setEnabled(true);
    }                                           

    private void jComboBox5ItemStateChanged(java.awt.event.ItemEvent evt) {                                            
        // TODO add your handling code here:
        jButton1.setEnabled(true);
    }                                           

    private void jCheckBox1ItemStateChanged(java.awt.event.ItemEvent evt) {                                            
        // TODO add your handling code here:
        jButton1.setEnabled(true);
    }                                           

    private void jCheckBox2ItemStateChanged(java.awt.event.ItemEvent evt) {                                            
        // TODO add your handling code here:
        jButton1.setEnabled(true);
    }                                           

    private void jCheckBox3ItemStateChanged(java.awt.event.ItemEvent evt) {                                            
        // TODO add your handling code here:
        jButton1.setEnabled(true);
    }                                           

    private void jCheckBox4ItemStateChanged(java.awt.event.ItemEvent evt) {                                            
        // TODO add your handling code here:
        jButton1.setEnabled(true);
    }                                           

    private void jCheckBox5ItemStateChanged(java.awt.event.ItemEvent evt) {                                            
        // TODO add your handling code here:
        jButton1.setEnabled(true);
    }                                           

    private void jCheckBox6ItemStateChanged(java.awt.event.ItemEvent evt) {                                            
        // TODO add your handling code here:
        jButton1.setEnabled(true);
    }                                           

    private void jComboBox1ItemStateChanged(java.awt.event.ItemEvent evt) {                                            
        // TODO add your handling code here:
        jButton1.setEnabled(true);
    }                                           

    private void jTextField2KeyTyped(java.awt.event.KeyEvent evt) {                                     
        // TODO add your handling code here:
        jButton1.setEnabled(true);
    }                                    

    /**
    * @param args the command line arguments
    */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new MobileUpdate().setVisible(true);
            }
        });
    }

    // Variables declaration - do not modify                     
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton2;
    private javax.swing.JCheckBox jCheckBox1;
    private javax.swing.JCheckBox jCheckBox2;
    private javax.swing.JCheckBox jCheckBox3;
    private javax.swing.JCheckBox jCheckBox4;
    private javax.swing.JCheckBox jCheckBox5;
    private javax.swing.JCheckBox jCheckBox6;
    private javax.swing.JComboBox jComboBox1;
    private javax.swing.JComboBox jComboBox2;
    private javax.swing.JComboBox jComboBox3;
    private javax.swing.JComboBox jComboBox4;
    private javax.swing.JComboBox jComboBox5;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel10;
    private javax.swing.JLabel jLabel11;
    private javax.swing.JLabel jLabel12;
    private javax.swing.JLabel jLabel13;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel7;
    private javax.swing.JLabel jLabel8;
    private javax.swing.JLabel jLabel9;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JTextField jTextField1;
    private javax.swing.JTextField jTextField2;
    private javax.swing.JTextField jTextField3;
    private javax.swing.JTextField jTextField4;
    // End of variables declaration                   
}



Code for BillGeneration Page:


/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/*
 * BillGeneration.java
 *
 * Created on Nov 1, 2010, 6:56:04 PM
 */

package mobilestorenew;

import java.sql.*;
import javax.swing.*;
import java.util.Date;

/**
 *
 * @author Ramesh
 */
public class BillGeneration extends javax.swing.JFrame {

    /** Creates new form BillGeneration */

    Date dat;
    int bid,reply;
    int a=0,b=0,c=0,d=0,x=0;
    String dt,year,month,day,date;
    int price=0,amtpaid,balamt,dpaidamt,dbalamt,drefid,dage;
    String text="",cid="r",dcid,dcname,year1,month1,day1,mc1,dt1,dgender;
    String cname,mob_purchased,ddno,dstreet,dcity,dstate,dphno;
    int flag=0;
    String s1,s2,s3,s4,nameappend="";int addprice;

    public BillGeneration() {
        initComponents();
        setVisible(true);
        setSize(1270,740);
        setTitle("Generate Bill");
        jTextField1.setEditable(false);
        jTextField2.setEditable(false);
        jTextField6.setEditable(false);
        idincrement();
        jTextField6.setText(Integer.toString(price));
      
    }
    public void idincrement()
    {
        try
        {

            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection co=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
            Statement st=co.createStatement();
            ResultSet res=st.executeQuery("select * from newbill");
            while(res.next())
            {
                bid=res.getInt(1);
            }
            
            st.close();
            co.close();
        }
        catch(Exception e)
        {
            JOptionPane.showMessageDialog(null,"the error is"+e);
            System.out.println(e.getMessage());
        }
            bid=bid+1;
            jTextField1.setText(Integer.toString(bid));
            
            dat=new Date();
            dt=dat.toString();
            System.out.println(dt);
            day=dt.substring(8,10);
            month=dt.substring(4,7);
            year=dt.substring(24,28);


            date=day;
            date+="-";
            date+=month;
            date+="-";
            date+=year;

            jTextField2.setText(date);

    }

    
    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">                          
    private void initComponents() {

        jLabel1 = new javax.swing.JLabel();
        jLabel2 = new javax.swing.JLabel();
        jLabel3 = new javax.swing.JLabel();
        jLabel4 = new javax.swing.JLabel();
        jLabel8 = new javax.swing.JLabel();
        jLabel9 = new javax.swing.JLabel();
        jLabel10 = new javax.swing.JLabel();
        jButton1 = new javax.swing.JButton();
        jTextField1 = new javax.swing.JTextField();
        jTextField2 = new javax.swing.JTextField();
        jTextField3 = new javax.swing.JTextField();
        jTextField6 = new javax.swing.JTextField();
        jTextField7 = new javax.swing.JTextField();
        jScrollPane1 = new javax.swing.JScrollPane();
        jTextArea1 = new javax.swing.JTextArea();
        jButton2 = new javax.swing.JButton();
        jLabel11 = new javax.swing.JLabel();
        jPanel1 = new javax.swing.JPanel();
        jLabel5 = new javax.swing.JLabel();
        jLabel6 = new javax.swing.JLabel();
        jLabel7 = new javax.swing.JLabel();
        jTextField4 = new javax.swing.JTextField();
        jComboBox1 = new javax.swing.JComboBox();
        jLabel12 = new javax.swing.JLabel();
        jLabel13 = new javax.swing.JLabel();
        jTextField5 = new javax.swing.JTextField();
        jLabel15 = new javax.swing.JLabel();
        jLabel14 = new javax.swing.JLabel();

        setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
        getContentPane().setLayout(null);

        jLabel1.setFont(new java.awt.Font("Tahoma", 1, 24));
        jLabel1.setText("Generate Bill");
        getContentPane().add(jLabel1);
        jLabel1.setBounds(390, 20, 220, 40);

        jLabel2.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel2.setText("Bill Id");
        getContentPane().add(jLabel2);
        jLabel2.setBounds(280, 80, 120, 30);

        jLabel3.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel3.setText("Bill Date");
        getContentPane().add(jLabel3);
        jLabel3.setBounds(280, 130, 130, 30);

        jLabel4.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel4.setText("Customer Name");
        getContentPane().add(jLabel4);
        jLabel4.setBounds(280, 180, 130, 30);

        jLabel8.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel8.setText("Added Mobiles");
        getContentPane().add(jLabel8);
        jLabel8.setBounds(280, 400, 110, 30);

        jLabel9.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel9.setText("Price");
        getContentPane().add(jLabel9);
        jLabel9.setBounds(280, 530, 110, 30);

        jLabel10.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel10.setText("Amount Paid");
        getContentPane().add(jLabel10);
        jLabel10.setBounds(280, 580, 110, 30);

        jButton1.setFont(new java.awt.Font("Tahoma", 1, 18));
        jButton1.setText("Generate Bill");
        jButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton1ActionPerformed(evt);
            }
        });
        getContentPane().add(jButton1);
        jButton1.setBounds(380, 640, 160, 40);

        jTextField1.setFont(new java.awt.Font("Tahoma", 1, 14));
        getContentPane().add(jTextField1);
        jTextField1.setBounds(460, 80, 130, 30);

        jTextField2.setFont(new java.awt.Font("Tahoma", 1, 14));
        getContentPane().add(jTextField2);
        jTextField2.setBounds(460, 130, 130, 30);

        jTextField3.setFont(new java.awt.Font("Tahoma", 1, 14));
        jTextField3.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusLost(java.awt.event.FocusEvent evt) {
                jTextField3FocusLost(evt);
            }
        });
        getContentPane().add(jTextField3);
        jTextField3.setBounds(460, 180, 130, 30);

        jTextField6.setFont(new java.awt.Font("Tahoma", 1, 14));
        getContentPane().add(jTextField6);
        jTextField6.setBounds(460, 530, 130, 30);

        jTextField7.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
        jTextField7.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusLost(java.awt.event.FocusEvent evt) {
                jTextField7FocusLost(evt);
            }
        });
        getContentPane().add(jTextField7);
        jTextField7.setBounds(460, 580, 130, 30);

        jTextArea1.setColumns(20);
        jTextArea1.setEditable(false);
        jTextArea1.setFont(new java.awt.Font("Tahoma", 1, 11));
        jTextArea1.setRows(5);
        jTextArea1.setTabSize(9);
        jScrollPane1.setViewportView(jTextArea1);

        getContentPane().add(jScrollPane1);
        jScrollPane1.setBounds(460, 400, 410, 110);

        jButton2.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
        jButton2.setText("ADD");
        jButton2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton2ActionPerformed(evt);
            }
        });
        getContentPane().add(jButton2);
        jButton2.setBounds(740, 280, 100, 40);
        getContentPane().add(jLabel11);
        jLabel11.setBounds(580, 180, 120, 30);

        jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
        jPanel1.setLayout(null);

        jLabel5.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel5.setText("Select Phone Model");
        jPanel1.add(jLabel5);
        jLabel5.setBounds(40, 20, 150, 30);

        jLabel6.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel6.setText("Enter Phone Name");
        jPanel1.add(jLabel6);
        jLabel6.setBounds(40, 70, 180, 30);

        jLabel7.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel7.setText("Enter IMEI Number");
        jPanel1.add(jLabel7);
        jLabel7.setBounds(40, 120, 180, 30);

        jTextField4.setFont(new java.awt.Font("Tahoma", 1, 14));
        jTextField4.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusGained(java.awt.event.FocusEvent evt) {
                jTextField4FocusGained(evt);
            }
            public void focusLost(java.awt.event.FocusEvent evt) {
                jTextField4FocusLost(evt);
            }
        });
        jPanel1.add(jTextField4);
        jTextField4.setBounds(220, 70, 130, 30);

        jComboBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Nokia", "Samsung", "Sony Ericson", "Lava", "Onida", "MaxMobile", "LG" }));
        jComboBox1.addItemListener(new java.awt.event.ItemListener() {
            public void itemStateChanged(java.awt.event.ItemEvent evt) {
                jComboBox1ItemStateChanged(evt);
            }
        });
        jPanel1.add(jComboBox1);
        jComboBox1.setBounds(220, 20, 130, 30);

        jLabel12.setFont(new java.awt.Font("Tahoma", 1, 12));
        jPanel1.add(jLabel12);
        jLabel12.setBounds(360, 70, 100, 30);

        jLabel13.setFont(new java.awt.Font("Tahoma", 1, 12));
        jPanel1.add(jLabel13);
        jLabel13.setBounds(360, 120, 100, 30);

        jTextField5.setFont(new java.awt.Font("Tahoma", 1, 12));
        jTextField5.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusGained(java.awt.event.FocusEvent evt) {
                jTextField5FocusGained(evt);
            }
            public void focusLost(java.awt.event.FocusEvent evt) {
                jTextField5FocusLost(evt);
            }
        });
        jPanel1.add(jTextField5);
        jTextField5.setBounds(220, 120, 130, 30);

        getContentPane().add(jPanel1);
        jPanel1.setBounds(240, 220, 480, 170);

        jLabel15.setFont(new java.awt.Font("Tahoma", 1, 12));
        getContentPane().add(jLabel15);
        jLabel15.setBounds(600, 580, 100, 30);

        jLabel14.setFont(new java.awt.Font("Tahoma", 1, 12));
        getContentPane().add(jLabel14);
        jLabel14.setBounds(600, 530, 200, 30);

        pack();
    }// </editor-fold>                        

    private void jTextField3FocusLost(java.awt.event.FocusEvent evt) {                                      
        // TODO add your handling code here:
        if(jTextField3.getText().equals(""))
        {
            jLabel11.setText("Entry Is Must") ;
            jTextField3.setText("");
        }

        else
        {
            jLabel11.setText("") ;
        }
    }                                     

    private void jTextField4FocusLost(java.awt.event.FocusEvent evt) {                                      
        // TODO add your handling code here:
        if(jTextField4.getText().equals(""))
        {
            jLabel12.setText("Entry Is Must");
        }
        else
        {
            jLabel12.setText("");
        
            String name=jTextField4.getText();
            String model=(String) jComboBox1.getSelectedItem();
            try
            {
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                Connection con=DriverManager.getConnection("Jdbc:Odbc:mobileDSN","scott","tiger");
                Statement st=con.createStatement();

                ResultSet res=st.executeQuery("select * from newmobile_details");
                Boolean rec=res.next();
                if(!rec)
                {
                    JOptionPane.showMessageDialog(null,"There are no Mobile phones in database");

                }
                else
                {
                    do
                    {
                        String s11=res.getString(2);
                        String s22=res.getString(3);

                        if(model.equalsIgnoreCase(s11) && name.equalsIgnoreCase(s22))
                        {
                               b=1;
                        }

                    }while(res.next());
                    if(b==0)
                    {
                        JOptionPane.showMessageDialog(null,"The mobile phone is not available, Please purchase another one");
                        jTextField4.setText("");
                        jLabel12.setText("Entry Is Must");


                    }
                }
                con.commit();
                con.close();
            }
            catch(Exception e)
            {
                JOptionPane.showMessageDialog(null,"The error is: "+e);
            }
        }
    }                                     

    private void jTextField4FocusGained(java.awt.event.FocusEvent evt) {                                        
        // TODO add your handling code here:
        b=0;
        
    }                                       

    private void jTextField5FocusLost(java.awt.event.FocusEvent evt) {                                      
        // TODO add your handling code here:
        if(jTextField5.getText().equals(""))
        {
            jLabel13.setText("Entry is Must");
        }
        else
        {
            String jtf1=jTextField5.getText();
            int fg=0;
            for(int i=0;i<jtf1.length();i++)
            {
                char c1=jtf1.charAt(i);
                if(Character.isLetter(c1))
                {
                    fg=0;
                    break;
                }
                else
                {
                    fg=1;

                }
            }
            if(fg==0)
            {
                jLabel13.setText("Enter Numbers") ;
                jTextField5.setText("");
            }
            else
            {
                jLabel13.setText("") ;
            }
            try
            {
                String imeino=jTextField5.getText();
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
                Statement st=con.createStatement();

                ResultSet res=st.executeQuery("select * from newmobile_details");
                Boolean rec=res.next();
                if(!rec)
                {
                    JOptionPane.showMessageDialog(null,"There are no Mobile phones in database");

                }
                else
                {
                    do
                    {
                        String s12=res.getString(6);
                        if(imeino.equals(s12))
                        {
                            c=1;
                        }
                    }while(res.next());
                    if(c==0)
                    {
                        JOptionPane.showMessageDialog(null,"The mobile phone is not available, Please purchase another one");
                        jTextField5.setText("");
                        jLabel13.setText("Entry is Must");
                    }
                }
                con.commit();
                con.close();

            }
            catch(Exception e)
            {
                JOptionPane.showMessageDialog(null,"The error is:"+e);
            }
        }
    }                                     

    private void jTextField5FocusGained(java.awt.event.FocusEvent evt) {                                        
        // TODO add your handling code here:
        c=0;
    }                                       

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        x=0;
            if(jTextField4.getText().equals("") || jTextField5.getText().equals(""))
            {
                JOptionPane.showMessageDialog(null,"Enter All appropriate fields");
                if(jTextField4.getText().equals(""))
                {
                    jLabel12.setText("Fill this Field");
                }
                else
                {
                    jLabel12.setText("");
                }
                if(jTextField5.getText().equals(""))
                {
                    jLabel13.setText("Fill this Field");
                }
                else
                {
                    jLabel13.setText("");
                }
            }
            else
            {
                try
                {

                    String model=(String)jComboBox1.getSelectedItem();
                    String name=jTextField4.getText();
                    String imeino=jTextField5.getText();

                    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                    Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
                    Statement st=con.createStatement();

                    ResultSet res=st.executeQuery("select * from newmobile_details");
                    Boolean rec=res.next();
                    if(!rec)
                    {
                        JOptionPane.showMessageDialog(null,"There are no Mobile phones in database");
                        jTextField4.setText("");
                        jTextField5.setText("");

                    }
                    else
                    {
                        do
                        {
                             s1=res.getString(2);
                             s2=res.getString(3);
                             addprice=res.getInt(4);
                             s3=res.getString(5);
                             s4=res.getString(6);
                             
                            if(s1.equalsIgnoreCase(model) && s2.equalsIgnoreCase(name) && s4.equalsIgnoreCase(imeino))
                            {

                                int reply2=JOptionPane.showConfirmDialog(null,"Are Sure You Want to Purchase");
                                if(reply2==JOptionPane.YES_OPTION)
                                {

                                        price+=addprice;
                                        jTextField6.setText(Integer.toString(price));

                                        text+="\n"+s2+"\t"+addprice+"\t"+s3+"\t"+s4;
                                        System.out.println(text);

                                        jTextArea1.setText("Phone Name \tPhone Price \tPhone Color \tIMEI Number \n-------" +
                                        "--------------------------------------------------------------------------"+text);

                                        PreparedStatement prp=con.prepareStatement("delete newmobile_details where imeino="+s4);
                                        prp.executeUpdate();
                                        nameappend+=s2+", ";
                                        System.out.println(nameappend);
                                        jComboBox1.setSelectedItem("nokia");
                                        jTextField4.setText("");
                                        jTextField5.setText("");
                                        x=1;

                                }
                                if(reply2==JOptionPane.NO_OPTION)
                                {
                                        jComboBox1.setSelectedItem("nokia");
                                        jTextField4.setText("");
                                        jTextField5.setText("");
                                }
                                if(reply2==JOptionPane.CANCEL_OPTION)
                                {
                                        jComboBox1.setSelectedItem("nokia");
                                        jTextField4.setText("");
                                        jTextField5.setText("");
                                }

                            }
                        }while(res.next());
                        if(x==0)
                        {
                            JOptionPane.showMessageDialog(null,"The Model and Name and IMEI No does not match, please enter correctly");
                        }
                    }
                }
                catch(Exception e)
                {
                    JOptionPane.showMessageDialog(null,"The error is:"+e);
                }
            }

    }                                        

    private void jComboBox1ItemStateChanged(java.awt.event.ItemEvent evt) {                                            
        // TODO add your handling code here:
        jTextField4.setText("");
        jTextField5.setText("");
    }                                           

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        if(flag==0)
        {
            if(jTextField3.getText().equals("") || jTextField6.getText().equals("0") || jTextField7.getText().equals(""))
            {
                JOptionPane.showMessageDialog(null,"Enter all appropriate fields");
                if(jTextField3.getText().equals(""))
                {
                    jLabel11.setText("Fill this Field");
                }
                else
                {
                    jLabel11.setText("");
                }
                if(jTextField6.getText().equals("0"))
                {
                    jLabel14.setText("Please Add Mobile Phone");
                }
                else
                {
                    jLabel14.setText("");
                }
                if(jTextField7.getText().equals(""))
                {
                    jLabel15.setText("Fill this field");
                }
                else
                {
                    jLabel15.setText("");
                }
            }
            else
            {
                cname=jTextField3.getText();
                mob_purchased=text;
                amtpaid=Integer.parseInt(jTextField7.getText());
                balamt=price-amtpaid;
                try
                {
                    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                    Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");

                    PreparedStatement prp=con.prepareStatement("insert into newbill values(?,?,?,?,?,?,?)");
                    prp.setInt(1,bid);
                    prp.setString(2,date);
                    prp.setString(3,cname);
                    prp.setInt(4,price);
                    prp.setInt(5,amtpaid);
                    prp.setString(6,mob_purchased);
                    prp.setString(7,nameappend);
                    
                    prp.executeUpdate();
                    JOptionPane.showMessageDialog(null,"Bill details successfully saved");

                    PrintPreview pp=new PrintPreview();
                    pp.jLabel3.setText(Integer.toString(bid));
                    pp.jLabel5.setText(date);
                    pp.jLabel7.setText(cname);
                    pp.jTextArea1.setText("Phone Name \tPhone Price \tPhone Color \tIMEI Number \n-------" +
                    "--------------------------------------------------------------------------"+text);
                    pp.jLabel11.setText(Integer.toString(price));
                    pp.jLabel13.setText(Integer.toString(amtpaid));
                    pp.text=text;
                    pp.flag=0;
                                
                    price=0;
                    bid++;
                    text="-";
                    jTextField1.setText(Integer.toString(bid));
                    jTextField3.setText("");
                    jTextArea1.setText("");
                    jTextField6.setText("0");
                    jTextField7.setText("");

                    con.commit();
                    con.close();
                }
                catch(Exception e)
                {
                    JOptionPane.showMessageDialog(null,"The error is:"+e);
                }

            }
        }
        if(flag==1)
        {
            dispose();
        }
    }                                        

    private void jTextField7FocusLost(java.awt.event.FocusEvent evt) {                                      
        // TODO add your handling code here:
        int amtcheck=Integer.parseInt(jTextField7.getText());
        if(amtcheck>price)
        {
            jTextField7.setText("");
            JOptionPane.showMessageDialog(null,"The Bill Amount is:"+price+", So pay less than or equal to the amount");
        }
    }                                     

    /**
    * @param args the command line arguments
    */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new BillGeneration().setVisible(true);
            }
        });
    }

    // Variables declaration - do not modify                     
    public javax.swing.JButton jButton1;
    public javax.swing.JButton jButton2;
    private javax.swing.JComboBox jComboBox1;
    public javax.swing.JLabel jLabel1;
    public javax.swing.JLabel jLabel10;
    private javax.swing.JLabel jLabel11;
    private javax.swing.JLabel jLabel12;
    private javax.swing.JLabel jLabel13;
    private javax.swing.JLabel jLabel14;
    private javax.swing.JLabel jLabel15;
    public javax.swing.JLabel jLabel2;
    public javax.swing.JLabel jLabel3;
    public javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel7;
    public javax.swing.JLabel jLabel8;
    public javax.swing.JLabel jLabel9;
    public javax.swing.JPanel jPanel1;
    public javax.swing.JScrollPane jScrollPane1;
    public javax.swing.JTextArea jTextArea1;
    public javax.swing.JTextField jTextField1;
    public javax.swing.JTextField jTextField2;
    public javax.swing.JTextField jTextField3;
    private javax.swing.JTextField jTextField4;
    private javax.swing.JTextField jTextField5;
    public javax.swing.JTextField jTextField6;
    public javax.swing.JTextField jTextField7;
    // End of variables declaration                   

}



Code for PrintPreview Page:


/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/*
 * PrintPreview.java
 *
 * Created on Nov 14, 2010, 10:52:13 PM
 */

package mobilestorenew;

import java.awt.Font;
import java.awt.Graphics;
import java.awt.Graphics2D;
import java.awt.print.*;
import java.sql.*;
import javax.swing.*;

/**
 *
 * @author Ramesh
 */
public class PrintPreview extends javax.swing.JFrame implements Printable{

    /** Creates new form PrintPreview */
    int a=0,d=0,flag=0;
    int price,amtpaid,reply1=1,reply,balamt,dpaidamt,dbalamt,drefid,dage;
    String refid="c",custrefid,cname,date,text,cid="r",dcid;
    String dcname,year1,month1,day1,mc1,dt1,dgender,ddno,dstreet,dcity,dstate,dphno;

    public PrintPreview() {
        initComponents();
        setVisible(true);
        setTitle("Print Preview");
        setSize(700,650);
        setResizable(false);
        setLocation(180,60);
    }

    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">                          
    private void initComponents() {

        jLabel1 = new javax.swing.JLabel();
        jPanel1 = new javax.swing.JPanel();
        jLabel2 = new javax.swing.JLabel();
        jLabel3 = new javax.swing.JLabel();
        jLabel4 = new javax.swing.JLabel();
        jLabel5 = new javax.swing.JLabel();
        jLabel6 = new javax.swing.JLabel();
        jLabel7 = new javax.swing.JLabel();
        jLabel8 = new javax.swing.JLabel();
        jLabel9 = new javax.swing.JLabel();
        jScrollPane1 = new javax.swing.JScrollPane();
        jTextArea1 = new javax.swing.JTextArea();
        jLabel10 = new javax.swing.JLabel();
        jLabel11 = new javax.swing.JLabel();
        jLabel12 = new javax.swing.JLabel();
        jLabel13 = new javax.swing.JLabel();
        jButton1 = new javax.swing.JButton();

        setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
        getContentPane().setLayout(null);

        jLabel1.setFont(new java.awt.Font("Monotype Corsiva", 1, 36));
        jLabel1.setText("Raj Mobile Store");
        getContentPane().add(jLabel1);
        jLabel1.setBounds(230, 30, 270, 40);

        jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
        jPanel1.setLayout(null);

        jLabel2.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
        jLabel2.setText("Bill Id :");
        jPanel1.add(jLabel2);
        jLabel2.setBounds(40, 40, 50, 30);

        jLabel3.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
        jLabel3.setText("Bill Id");
        jPanel1.add(jLabel3);
        jLabel3.setBounds(100, 40, 90, 30);

        jLabel4.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel4.setText("Bill Date :");
        jPanel1.add(jLabel4);
        jLabel4.setBounds(410, 40, 70, 30);

        jLabel5.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
        jLabel5.setText("Bill Date");
        jPanel1.add(jLabel5);
        jLabel5.setBounds(480, 40, 110, 30);

        jLabel6.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel6.setText("Customer Name :");
        jPanel1.add(jLabel6);
        jLabel6.setBounds(40, 90, 130, 30);

        jLabel7.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
        jLabel7.setText("Customer Name");
        jPanel1.add(jLabel7);
        jLabel7.setBounds(170, 90, 270, 30);

        jLabel8.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
        jLabel8.setText("---------------------------------------------------------------------------------------------------------");
        jPanel1.add(jLabel8);
        jLabel8.setBounds(0, 130, 630, 17);

        jLabel9.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel9.setText("Mobiles Purchased :");
        jPanel1.add(jLabel9);
        jLabel9.setBounds(40, 170, 140, 30);

        jTextArea1.setColumns(20);
        jTextArea1.setEditable(false);
        jTextArea1.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jTextArea1.setRows(5);
        jTextArea1.setTabSize(9);
        jScrollPane1.setViewportView(jTextArea1);

        jPanel1.add(jScrollPane1);
        jScrollPane1.setBounds(190, 170, 410, 110);

        jLabel10.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
        jLabel10.setText("Total Price :");
        jPanel1.add(jLabel10);
        jLabel10.setBounds(40, 310, 100, 30);

        jLabel11.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
        jLabel11.setText("Total Price");
        jPanel1.add(jLabel11);
        jLabel11.setBounds(190, 310, 100, 30);

        jLabel12.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
        jLabel12.setText("Amount Paid :");
        jPanel1.add(jLabel12);
        jLabel12.setBounds(40, 350, 150, 30);

        jLabel13.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel13.setText("Amount Paid ");
        jPanel1.add(jLabel13);
        jLabel13.setBounds(190, 350, 100, 30);

        jButton1.setFont(new java.awt.Font("Tahoma", 1, 14));
        jButton1.setText("Print");
        jButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton1ActionPerformed(evt);
            }
        });
        jPanel1.add(jButton1);
        jButton1.setBounds(280, 410, 100, 40);

        getContentPane().add(jPanel1);
        jPanel1.setBounds(30, 100, 630, 480);

        pack();
    }// </editor-fold>                        

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:

        if(flag==0)
        {
            jButton1.setVisible(false);
            PrinterJob printJob = PrinterJob.getPrinterJob();
            
            if (printJob.printDialog())
            {
                try
                {
                    printJob.print();
                    printJob.setCopies(1);

                }
                catch(Exception PrintException)
                {
                    PrintException.printStackTrace();
                }
                printJob.cancel();
            }
            printJob.cancel();
            jButton1.setVisible(true);

            cname=jLabel7.getText();
            date=jLabel5.getText();
            amtpaid=Integer.parseInt(jLabel13.getText());
            price=Integer.parseInt(jLabel11.getText());
            balamt=price-amtpaid;


            if(price!=amtpaid)
            {
                dispose();
                while(reply1!=JOptionPane.YES_OPTION)
                {
                    reply=JOptionPane.showConfirmDialog(null,"Is this customer is new Customer or Existing Customer\n If new customer press Yes\n If Existing Customer Press No");
                    if(reply==JOptionPane.YES_OPTION)
                    {
                        while(!refid.equals(custrefid))
                        {
                            try
                            {
                                refid=JOptionPane.showInputDialog(null,"Enter Previous Customer Reference Id");
                                while(refid.equals(""))
                                {
                                    JOptionPane.showMessageDialog(null,"Please Enter Reference Id");
                                    refid=JOptionPane.showInputDialog(null,"Enter Previous Customer Referece Id");
                                }
                            }
                            catch(NullPointerException e)
                            {
                                int reply3=JOptionPane.showConfirmDialog(null,"Are you sure, you dont want to save customer details");
                                if(reply3==JOptionPane.YES_OPTION)
                                {
                                    JOptionPane.showMessageDialog(null,"The customer details are not saved");
                                    break;
                                }
                                if(reply3==JOptionPane.NO_OPTION)
                                {
                                    refid=JOptionPane.showInputDialog(null,"Enter Previous Customer Reference Id");
                                    while(refid.equals(""))
                                    {
                                        JOptionPane.showMessageDialog(null,"Please Enter Reference Id");
                                        refid=JOptionPane.showInputDialog(null,"Enter Previous Customer Referece Id");
                                    }
                                }
                                if(reply3==JOptionPane.CANCEL_OPTION)
                                {
                                    JOptionPane.showMessageDialog(null,"The customer details are not saved");
                                    break;
                                }
                            }
                            try
                            {
                                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                                Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
                                Statement st=con.createStatement();
                                ResultSet res=st.executeQuery("select * from newcustomer_details");
                                Boolean rec=res.next();
                                if(!rec)
                                {
                                    custrefid="1";
                                    CreditCustomer cs=new CreditCustomer();
                                    cs.jTextField2.setText(cname);
                                    cs.jTextField3.setText(date);
                                    cs.jTextField4.setText(Integer.toString(amtpaid));
                                    cs.jTextField5.setText(Integer.toString(balamt));
                                    cs.jTextField6.setText(refid);
                                    cs.jTextArea1.setText("Phone Name \tPhone Price \tPhone Color \tIMEI Number \n-------" +
                                    "--------------------------------------------------------------------------"+text);
                                    cs.jTextField13.setVisible(false);
                                    cs.jTextField14.setVisible(false);
                                    cs.jLabel25.setVisible(false);
                                    cs.jLabel26.setVisible(false);
                                    cs.flag=0;
                                }
                                else
                                {
                                    do
                                    {
                                        custrefid=res.getString(1);
                                        if(refid.equals(custrefid))
                                        {
                                            CreditCustomer cs=new CreditCustomer();
                                            cs.jTextField2.setText(cname);
                                            cs.jTextField3.setText(date);
                                            cs.jTextField4.setText(Integer.toString(amtpaid));
                                            cs.jTextField5.setText(Integer.toString(balamt));
                                            cs.jTextField6.setText(refid);
                                            cs.jTextArea1.setText("Phone Name \tPhone Price \tPhone Color \tIMEI Number \n-------" +
                                            "--------------------------------------------------------------------------"+text);
                                            cs.jTextField13.setVisible(false);
                                            cs.jTextField14.setVisible(false);
                                            cs.jLabel25.setVisible(false);
                                            cs.jLabel26.setVisible(false);
                                            cs.flag=0;
                                            a=1;
                                            break;
                                        }
                                    }while(res.next());
                                    if(a==0)
                                    {
                                        JOptionPane.showMessageDialog(null,"The Reference Id is wrong, please enter correct Reference ID");
                                    }
                                }
                            }
                            catch(Exception e)
                            {
                                JOptionPane.showMessageDialog(null,"The error is:"+e);
                            }
                        }
                        break;
                    }
                    else if(reply==JOptionPane.NO_OPTION)
                    {
                        while(!cid.equals(dcid))
                        {
                            System.out.println("i came here");
                            try
                            {
                                cid=JOptionPane.showInputDialog(null,"Enter Customer Id");
                                while(cid.equals(""))
                                {
                                    JOptionPane.showMessageDialog(null,"Plese Enter Customer Id");
                                    cid=JOptionPane.showInputDialog(null,"Enter Customer Id");
                                }
                            }
                            catch(NullPointerException e)
                            {
                                int reply4=JOptionPane.showConfirmDialog(null,"Are you sure, you dont want to save customer details");
                                if(reply4==JOptionPane.YES_OPTION)
                                {
                                    JOptionPane.showMessageDialog(null,"The customer details are not saved");
                                    break;
                                }
                                if(reply4==JOptionPane.NO_OPTION)
                                {
                                    cid=JOptionPane.showInputDialog(null,"Enter Customer Id");
                                    while(cid.equals(""))
                                    {
                                        JOptionPane.showMessageDialog(null,"Plese Enter Customer Id");
                                        cid=JOptionPane.showInputDialog(null,"Enter Customer Id");
                                    }
                                }
                                if(reply4==JOptionPane.CANCEL_OPTION)
                                {
                                    JOptionPane.showMessageDialog(null,"The customer details are not saved");
                                    break;
                                }
                            }
                            try
                            {
                                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                                Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
                                Statement st=con.createStatement();
                                ResultSet res=st.executeQuery("select * from newcustomer_details");
                                Boolean rec=res.next();
                                if(!rec)
                                {
                                }
                                else
                                {
                                    do
                                    {
                                        dcid=res.getString(1);
                                        dcname=res.getString(2);
                                        dpaidamt=res.getInt(4);
                                        dbalamt=res.getInt(5);
                                        drefid=res.getInt(6);

                                        java.sql.Date ddob=res.getDate(7);
                                        dt1=ddob.toString();
                                        year1=dt1.substring(0,4);
                                        month1=dt1.substring(5,7);
                                        day1=dt1.substring(8,10);
                                        if(month1.equals("01"))
                                        {
                                            mc1="jan";
                                        }
                                        else if(month1.equals("02"))
                                        {
                                            mc1="feb";
                                        }
                                        else if(month1.equals("03"))
                                        {
                                            mc1="mar";
                                        }
                                        else if(month1.equals("04"))
                                        {
                                            mc1="apr";
                                        }
                                        else if(month1.equals("05"))
                                        {
                                            mc1="may";
                                        }
                                        else if(month1.equals("06"))
                                        {
                                            mc1="jun";
                                        }
                                        else if(month1.equals("07"))
                                        {
                                            mc1="jul";
                                        }
                                        else if(month1.equals("08"))
                                        {
                                            mc1="aug";
                                        }
                                        else if(month1.equals("09"))
                                        {
                                            mc1="sep";
                                        }
                                        else if(month1.equals("10"))
                                        {
                                            mc1="oct";
                                        }
                                        else if(month1.equals("11"))
                                        {
                                            mc1="nov";
                                        }
                                        else if(month1.equals("12"))
                                        {
                                            mc1="dec";
                                        }

                                        dage=res.getInt(8);
                                        dgender=res.getString(9);
                                        ddno=res.getString(10);
                                        dstreet=res.getString(11);
                                        dcity=res.getString(12);
                                        dstate=res.getString(13);
                                        dphno=res.getString(14);
                                        String dmob_purchase=res.getString(15);
                                        dmob_purchase+=text;
                                        if(cid.equals(dcid))
                                        {
                                            CreditCustomer cs=new CreditCustomer();
                                            cs.jComboBox1.setEnabled(false);
                                            cs.jComboBox2.setEnabled(false);
                                            cs.jComboBox3.setEnabled(false);
                                            cs.jTextField7.setEditable(false);
                                            cs.jRadioButton1.setEnabled(false);
                                            cs.jRadioButton2.setEnabled(false);
                                            cs.jTextField8.setEditable(false);
                                            cs.jTextField9.setEditable(false);
                                            cs.jTextField10.setEditable(false);
                                            cs.jTextField11.setEditable(false);
                                            cs.jTextField12.setEditable(false);
                                            cs.jButton1.setText("Update Customer Details");

                                            cs.jTextField1.setText(dcid);
                                            cs.jTextField2.setText(dcname);
                                            cs.jTextField3.setText(date);
                                            cs.jTextField4.setText(Integer.toString(amtpaid));
                                            cs.jTextField5.setText(Integer.toString(balamt));
                                            cs.jTextField6.setText(Integer.toString(drefid));
                                            cs.jTextArea1.setText(dmob_purchase);
                                            cs.jComboBox1.setSelectedItem(day1);
                                            cs.jComboBox2.setSelectedItem(mc1);
                                            cs.jComboBox3.setSelectedItem(year1);
                                            cs.jTextField7.setText(Integer.toString(dage));
                                            if(dgender.equalsIgnoreCase("male"))
                                                cs.jRadioButton1.setSelected(true);
                                            if(dgender.equalsIgnoreCase("female"))
                                                cs.jRadioButton2.setSelected(true);

                                            cs.jTextField8.setText(ddno);
                                            cs.jTextField9.setText(dstreet);
                                            cs.jTextField10.setText(dcity);
                                            cs.jTextField11.setText(dstate);
                                            cs.jTextField12.setText(dphno);
                                            cs.jTextField13.setText(Integer.toString(dbalamt));

                                            int totalamt=dbalamt+balamt;
                                            cs.jTextField14.setText(Integer.toString(totalamt));

                                            cs.flag=1;
                                            d=1;
                                            break;
                                        }
                                    }while(res.next());
                                    if(d==0)
                                    {
                                        JOptionPane.showMessageDialog(null,"Please enter correct Customer Id");
                                    }
                                }
                            }
                            catch(Exception e)
                            {
                                JOptionPane.showMessageDialog(null,"The error is:"+e);
                            }
                        }
                        break;
                    }
                    else if(reply==JOptionPane.CANCEL_OPTION)
                    {
                        reply1=JOptionPane.showConfirmDialog(null,"Are you sure you dont want to save customer details");

                        if(reply1==JOptionPane.YES_OPTION)
                        {
                            JOptionPane.showMessageDialog(null,"The Customer Details are not saved");
                        }
                        if(reply1==JOptionPane.NO_OPTION)
                        {
                        }
                        if(reply1==JOptionPane.CANCEL_OPTION)
                        {
                            JOptionPane.showMessageDialog(null,"The customer details are not saved");
                            break;
                        }

                    }
                }
            }
            else
            {
                dispose();
            }
        }
        else if(flag==1)
        {
            jButton1.setVisible(false);
            PrinterJob printJob = PrinterJob.getPrinterJob();
            
            if (printJob.printDialog())
            {
                try
                {
                    printJob.print();
                    printJob.setCopies(1);

                }
                catch(Exception PrintException)
                {
                    PrintException.printStackTrace();
                }
                printJob.cancel();
            }
            printJob.cancel();
            jButton1.setVisible(true);

        }

    }                                        
public int print(Graphics g, PageFormat pf, int pi) throws PrinterException
{
    Graphics2D g2 = (Graphics2D) g;
    g2.translate(pf.getImageableX()+5, pf.getImageableY()+5);
    Font  f = new Font("Monospaced",Font.PLAIN,12);
    g2.setFont (f);
    paint (g2);
    return Printable.PAGE_EXISTS;
}
    /**
    * @param args the command line arguments
    */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new PrintPreview().setVisible(true);
            }
        });
    }

    // Variables declaration - do not modify                     
    public javax.swing.JButton jButton1;
    private javax.swing.JLabel jLabel1;
    public javax.swing.JLabel jLabel10;
    public javax.swing.JLabel jLabel11;
    public javax.swing.JLabel jLabel12;
    public javax.swing.JLabel jLabel13;
    public javax.swing.JLabel jLabel2;
    public javax.swing.JLabel jLabel3;
    public javax.swing.JLabel jLabel4;
    public javax.swing.JLabel jLabel5;
    public javax.swing.JLabel jLabel6;
    public javax.swing.JLabel jLabel7;
    private javax.swing.JLabel jLabel8;
    public javax.swing.JLabel jLabel9;
    private javax.swing.JPanel jPanel1;
    public javax.swing.JScrollPane jScrollPane1;
    public javax.swing.JTextArea jTextArea1;
    // End of variables declaration                   

}


Code for AddCustomer Page:


/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/*
 * CreditCustomer.java
 *
 * Created on Nov 5, 2010, 8:24:54 PM
 */

package mobilestorenew;

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

/**
 *
 * @author Ramesh
 */
public class CreditCustomer extends javax.swing.JFrame {

    /** Creates new form CreditCustomer */
    int cid,paidamt,balamt,refid,age,currentcid;
    String sex="Male";
    String cname,pdate,dob,dno,street,city,state,phno,mob_purchased,year;
    int flag,totalbal,prevalue=0,curvalue;
    java.sql.Date dat;
    public CreditCustomer() {
        initComponents();
        setVisible(true);
        setSize(1270,740);
        setTitle("Credit Customer");
        jTextField1.setEditable(false);
        jTextField2.setEditable(false);
        jTextField3.setEditable(false);
        jTextField4.setEditable(false);
        jTextField5.setEditable(false);
        jTextField6.setEditable(false);
        jTextField13.setEditable(false);
        jTextField14.setEditable(false);
        jTextArea1.setEditable(false);

        idincrement();

        ButtonGroup bg=new ButtonGroup();
        bg.add(jRadioButton1);
        bg.add(jRadioButton2);
    }
   
    public void idincrement()
    {
        try
        {

            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection co=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
            Statement st=co.createStatement();
            ResultSet res=st.executeQuery("select sysdate from dual");
            res.next();
            dat=res.getDate(1);
            res=st.executeQuery("select * from newcustomer_details");
            Boolean rec=res.next();
            if(!rec)
            {
                cid=1;
            }
            else
            {
                do
                {
                    curvalue=res.getInt(1);
                    if(prevalue<curvalue)
                    {
                        cid=curvalue+1;
                        prevalue=curvalue;
                    }

                }while(res.next());
            }

            st.close();
            co.close();
        }
        catch(Exception e)
        {
            JOptionPane.showMessageDialog(null,"the error is"+e);
        }
        
        jTextField1.setText(Integer.toString(cid));

        year=dat.toString();
        year=year.substring(0,4);
    }
    public void saveupdate()
    {
                dob=(String)jComboBox1.getSelectedItem();
                dob+="-";
                dob+=(String)jComboBox2.getSelectedItem();
                dob+="-";
                dob+=(String)jComboBox3.getSelectedItem();
                System.out.println(dob);

                age=Integer.parseInt(jTextField7.getText());
                dno=jTextField8.getText();
                street=jTextField9.getText();
                city=jTextField10.getText();
                state=jTextField11.getText();
                phno=jTextField12.getText();
                mob_purchased=jTextArea1.getText();

    }

    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">                          
    private void initComponents() {

        jLabel1 = new javax.swing.JLabel();
        jPanel2 = new javax.swing.JPanel();
        jLabel5 = new javax.swing.JLabel();
        jLabel4 = new javax.swing.JLabel();
        jRadioButton1 = new javax.swing.JRadioButton();
        jRadioButton2 = new javax.swing.JRadioButton();
        jLabe = new javax.swing.JLabel();
        jLabel7 = new javax.swing.JLabel();
        jLabel11 = new javax.swing.JLabel();
        jLabel12 = new javax.swing.JLabel();
        jTextField7 = new javax.swing.JTextField();
        jTextField9 = new javax.swing.JTextField();
        jLabel14 = new javax.swing.JLabel();
        jTextField10 = new javax.swing.JTextField();
        jTextField8 = new javax.swing.JTextField();
        jLabel6 = new javax.swing.JLabel();
        jLabel16 = new javax.swing.JLabel();
        jComboBox2 = new javax.swing.JComboBox();
        jLabel17 = new javax.swing.JLabel();
        jComboBox3 = new javax.swing.JComboBox();
        jLabel18 = new javax.swing.JLabel();
        jComboBox1 = new javax.swing.JComboBox();
        jTextField11 = new javax.swing.JTextField();
        jTextField12 = new javax.swing.JTextField();
        jLabel19 = new javax.swing.JLabel();
        jLabel20 = new javax.swing.JLabel();
        jLabel21 = new javax.swing.JLabel();
        jLabel23 = new javax.swing.JLabel();
        jLabel24 = new javax.swing.JLabel();
        jLabel22 = new javax.swing.JLabel();
        jPanel1 = new javax.swing.JPanel();
        jTextField1 = new javax.swing.JTextField();
        jLabel2 = new javax.swing.JLabel();
        jLabel3 = new javax.swing.JLabel();
        jTextField2 = new javax.swing.JTextField();
        jLabel8 = new javax.swing.JLabel();
        jTextField3 = new javax.swing.JTextField();
        jLabel9 = new javax.swing.JLabel();
        jScrollPane1 = new javax.swing.JScrollPane();
        jTextArea1 = new javax.swing.JTextArea();
        jLabel10 = new javax.swing.JLabel();
        jTextField4 = new javax.swing.JTextField();
        jLabel13 = new javax.swing.JLabel();
        jTextField5 = new javax.swing.JTextField();
        jLabel15 = new javax.swing.JLabel();
        jTextField6 = new javax.swing.JTextField();
        jLabel25 = new javax.swing.JLabel();
        jTextField13 = new javax.swing.JTextField();
        jLabel26 = new javax.swing.JLabel();
        jTextField14 = new javax.swing.JTextField();
        jPanel3 = new javax.swing.JPanel();
        jButton1 = new javax.swing.JButton();
        jButton2 = new javax.swing.JButton();

        setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
        getContentPane().setLayout(null);

        jLabel1.setFont(new java.awt.Font("Tahoma", 1, 24));
        jLabel1.setText("Add Credit Customer Details");
        getContentPane().add(jLabel1);
        jLabel1.setBounds(340, 0, 350, 40);

        jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Customer Details", javax.swing.border.TitledBorder.RIGHT, javax.swing.border.TitledBorder.TOP));
        jPanel2.setLayout(null);

        jLabel5.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel5.setText("Age");
        jPanel2.add(jLabel5);
        jLabel5.setBounds(480, 30, 80, 30);

        jLabel4.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel4.setText("Gender");
        jPanel2.add(jLabel4);
        jLabel4.setBounds(40, 90, 110, 30);

        jRadioButton1.setFont(new java.awt.Font("Tahoma", 1, 12));
        jRadioButton1.setSelected(true);
        jRadioButton1.setText("Male");
        jRadioButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jRadioButton1ActionPerformed(evt);
            }
        });
        jPanel2.add(jRadioButton1);
        jRadioButton1.setBounds(130, 90, 60, 30);

        jRadioButton2.setFont(new java.awt.Font("Tahoma", 1, 12));
        jRadioButton2.setText("Female");
        jRadioButton2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jRadioButton2ActionPerformed(evt);
            }
        });
        jPanel2.add(jRadioButton2);
        jRadioButton2.setBounds(210, 90, 70, 30);

        jLabe.setFont(new java.awt.Font("Tahoma", 1, 12));
        jLabe.setText("City");
        jPanel2.add(jLabe);
        jLabe.setBounds(480, 140, 90, 30);

        jLabel7.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel7.setText("Door NO");
        jPanel2.add(jLabel7);
        jLabel7.setBounds(480, 90, 110, 30);

        jLabel11.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel11.setText("Street");
        jPanel2.add(jLabel11);
        jLabel11.setBounds(40, 140, 80, 30);

        jLabel12.setFont(new java.awt.Font("Tahoma", 1, 12));
        jLabel12.setText("State");
        jPanel2.add(jLabel12);
        jLabel12.setBounds(40, 200, 80, 30);

        jTextField7.setFont(new java.awt.Font("Tahoma", 1, 14));
        jTextField7.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusGained(java.awt.event.FocusEvent evt) {
                jTextField7FocusGained(evt);
            }
            public void focusLost(java.awt.event.FocusEvent evt) {
                jTextField7FocusLost(evt);
            }
        });
        jPanel2.add(jTextField7);
        jTextField7.setBounds(580, 30, 160, 30);

        jTextField9.setFont(new java.awt.Font("Tahoma", 1, 14));
        jTextField9.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusLost(java.awt.event.FocusEvent evt) {
                jTextField9FocusLost(evt);
            }
        });
        jPanel2.add(jTextField9);
        jTextField9.setBounds(130, 140, 170, 30);

        jLabel14.setFont(new java.awt.Font("Tahoma", 1, 12));
        jLabel14.setText("Phone Number");
        jPanel2.add(jLabel14);
        jLabel14.setBounds(480, 200, 100, 30);

        jTextField10.setFont(new java.awt.Font("Tahoma", 1, 14));
        jTextField10.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusLost(java.awt.event.FocusEvent evt) {
                jTextField10FocusLost(evt);
            }
        });
        jPanel2.add(jTextField10);
        jTextField10.setBounds(580, 140, 160, 30);

        jTextField8.setFont(new java.awt.Font("Tahoma", 1, 14));
        jTextField8.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusLost(java.awt.event.FocusEvent evt) {
                jTextField8FocusLost(evt);
            }
        });
        jPanel2.add(jTextField8);
        jTextField8.setBounds(580, 90, 160, 30);

        jLabel6.setFont(new java.awt.Font("Tahoma", 1, 12));
        jLabel6.setText("Date of Birth");
        jPanel2.add(jLabel6);
        jLabel6.setBounds(40, 30, 90, 30);

        jLabel16.setFont(new java.awt.Font("Tahoma", 1, 12));
        jLabel16.setText("(DD)");
        jPanel2.add(jLabel16);
        jLabel16.setBounds(180, 30, 30, 30);

        jComboBox2.setFont(new java.awt.Font("Tahoma", 1, 12));
        jComboBox2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "jan", "feb", "mar", "apr", "may", "jun", "jul", "aug", "sep", "oct", "nov", "dec" }));
        jPanel2.add(jComboBox2);
        jComboBox2.setBounds(210, 30, 56, 30);

        jLabel17.setFont(new java.awt.Font("Tahoma", 1, 12));
        jLabel17.setText("(MM)");
        jPanel2.add(jLabel17);
        jLabel17.setBounds(270, 30, 40, 30);

        jComboBox3.setFont(new java.awt.Font("Tahoma", 1, 12));
        jComboBox3.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "1910", "1911", "1912", "1913", "1914", "1915", "1916", "1917", "1918", "1919", "1920", "1921", "1922", "1923", "1924", "1925", "1926", "1927", "1928", "1929", "1930", "1931", "1932", "1933", "1934", "1935", "1936", "1937", "1938", "1939", "1940", "1941", "1942", "1943", "1944", "1945", "1946", "1947", "1948", "1949", "1950", "1951", "1952", "1953", "1954", "1955", "1956", "1957", "1958", "1959", "1960", "1961", "1962", "1963", "1964", "1965", "1966", "1967", "1968", "1969", "1970", "1971", "1972", "1973", "1974", "1975", "1976", "1977", "1978", "1979", "1980", "1981", "1982", "1983", "1984", "1985", "1986", "1987", "1988", "1989", "1990", "1991", "1992", "1993", "1994", "1995" }));
        jPanel2.add(jComboBox3);
        jComboBox3.setBounds(310, 30, 60, 30);

        jLabel18.setFont(new java.awt.Font("Tahoma", 1, 12));
        jLabel18.setText("(YY)");
        jPanel2.add(jLabel18);
        jLabel18.setBounds(370, 30, 30, 30);

        jComboBox1.setFont(new java.awt.Font("Tahoma", 1, 12));
        jComboBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "31" }));
        jPanel2.add(jComboBox1);
        jComboBox1.setBounds(130, 30, 50, 30);

        jTextField11.setFont(new java.awt.Font("Tahoma", 1, 14));
        jTextField11.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusLost(java.awt.event.FocusEvent evt) {
                jTextField11FocusLost(evt);
            }
        });
        jPanel2.add(jTextField11);
        jTextField11.setBounds(130, 200, 170, 30);

        jTextField12.setFont(new java.awt.Font("Tahoma", 1, 14));
        jTextField12.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusLost(java.awt.event.FocusEvent evt) {
                jTextField12FocusLost(evt);
            }
        });
        jPanel2.add(jTextField12);
        jTextField12.setBounds(580, 200, 160, 30);
        jPanel2.add(jLabel19);
        jLabel19.setBounds(750, 30, 170, 30);
        jPanel2.add(jLabel20);
        jLabel20.setBounds(750, 90, 170, 30);
        jPanel2.add(jLabel21);
        jLabel21.setBounds(310, 140, 110, 30);
        jPanel2.add(jLabel23);
        jLabel23.setBounds(310, 200, 120, 30);
        jPanel2.add(jLabel24);
        jLabel24.setBounds(750, 200, 170, 30);
        jPanel2.add(jLabel22);
        jLabel22.setBounds(750, 140, 160, 30);

        getContentPane().add(jPanel2);
        jPanel2.setBounds(20, 370, 980, 250);

        jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Customer Details", javax.swing.border.TitledBorder.RIGHT, javax.swing.border.TitledBorder.TOP));
        jPanel1.setLayout(null);

        jTextField1.setFont(new java.awt.Font("Tahoma", 1, 14));
        jPanel1.add(jTextField1);
        jTextField1.setBounds(170, 30, 140, 30);

        jLabel2.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel2.setText("Customer Id");
        jPanel1.add(jLabel2);
        jLabel2.setBounds(30, 30, 100, 30);

        jLabel3.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel3.setText("Customer Name");
        jPanel1.add(jLabel3);
        jLabel3.setBounds(370, 30, 120, 30);

        jTextField2.setFont(new java.awt.Font("Tahoma", 1, 14));
        jPanel1.add(jTextField2);
        jTextField2.setBounds(490, 30, 170, 30);

        jLabel8.setFont(new java.awt.Font("Tahoma", 1, 12));
        jLabel8.setText("Date Purchased");
        jPanel1.add(jLabel8);
        jLabel8.setBounds(30, 80, 100, 30);

        jTextField3.setFont(new java.awt.Font("Tahoma", 1, 14));
        jPanel1.add(jTextField3);
        jTextField3.setBounds(170, 80, 140, 30);

        jLabel9.setFont(new java.awt.Font("Tahoma", 1, 12));
        jLabel9.setText("Mobiles Purchased");
        jPanel1.add(jLabel9);
        jLabel9.setBounds(370, 130, 120, 30);

        jTextArea1.setColumns(20);
        jTextArea1.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jTextArea1.setRows(5);
        jTextArea1.setTabSize(9);
        jScrollPane1.setViewportView(jTextArea1);

        jPanel1.add(jScrollPane1);
        jScrollPane1.setBounds(490, 130, 410, 170);

        jLabel10.setFont(new java.awt.Font("Tahoma", 1, 12));
        jLabel10.setText("Paid Amount");
        jPanel1.add(jLabel10);
        jLabel10.setBounds(370, 80, 100, 30);

        jTextField4.setFont(new java.awt.Font("Tahoma", 1, 14));
        jPanel1.add(jTextField4);
        jTextField4.setBounds(490, 80, 170, 30);

        jLabel13.setFont(new java.awt.Font("Tahoma", 1, 12));
        jLabel13.setText("Balance Amount");
        jPanel1.add(jLabel13);
        jLabel13.setBounds(30, 130, 100, 30);

        jTextField5.setFont(new java.awt.Font("Tahoma", 1, 14));
        jPanel1.add(jTextField5);
        jTextField5.setBounds(170, 130, 140, 30);

        jLabel15.setFont(new java.awt.Font("Tahoma", 1, 12));
        jLabel15.setText("Reference Id");
        jPanel1.add(jLabel15);
        jLabel15.setBounds(30, 180, 100, 30);

        jTextField6.setFont(new java.awt.Font("Tahoma", 1, 14));
        jPanel1.add(jTextField6);
        jTextField6.setBounds(170, 180, 140, 30);

        jLabel25.setFont(new java.awt.Font("Tahoma", 1, 12));
        jLabel25.setText("Old Balance Amount");
        jPanel1.add(jLabel25);
        jLabel25.setBounds(30, 230, 130, 30);

        jTextField13.setFont(new java.awt.Font("Tahoma", 1, 14));
        jPanel1.add(jTextField13);
        jTextField13.setBounds(170, 230, 140, 30);

        jLabel26.setFont(new java.awt.Font("Tahoma", 1, 12));
        jLabel26.setText("Total Balance Amount");
        jPanel1.add(jLabel26);
        jLabel26.setBounds(30, 280, 140, 30);

        jTextField14.setFont(new java.awt.Font("Tahoma", 1, 14));
        jPanel1.add(jTextField14);
        jTextField14.setBounds(170, 280, 140, 30);

        getContentPane().add(jPanel1);
        jPanel1.setBounds(20, 40, 980, 320);

        jPanel3.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
        jPanel3.setLayout(null);

        jButton1.setFont(new java.awt.Font("Tahoma", 1, 14));
        jButton1.setText("Save Customer Details");
        jButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton1ActionPerformed(evt);
            }
        });
        jPanel3.add(jButton1);
        jButton1.setBounds(150, 10, 210, 40);

        jButton2.setFont(new java.awt.Font("Tahoma", 1, 14));
        jButton2.setText("Cancel");
        jButton2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton2ActionPerformed(evt);
            }
        });
        jPanel3.add(jButton2);
        jButton2.setBounds(370, 10, 100, 40);

        getContentPane().add(jPanel3);
        jPanel3.setBounds(180, 630, 610, 60);

        pack();
    }// </editor-fold>                        

    private void jTextField7FocusLost(java.awt.event.FocusEvent evt) {                                      
        // TODO add your handling code here:
        if(jTextField7.getText().equals(""))
        {
            jLabel19.setText("Entry Is Must");
        }
        else if(jTextField7.getText().length()>2)
        {
            jLabel19.setText("Enter Valid Age");
            jTextField7.setText("");
        }
        else
        {
            String jtf1=jTextField7.getText();
            int fg=0;
            for(int i=0;i<jtf1.length();i++)
            {
                char c1=jtf1.charAt(i);
                if(Character.isLetter(c1))
                {
                    fg=0;
                    break;
                }
                else
                {
                    fg=1;
                }
            }
            if(fg==0)
            {
                jLabel19.setText("Enter Numbers");
                jTextField7.setText("");
            }
            else
                jLabel19.setText("") ;
        }
    }                                     

    private void jRadioButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                              
        // TODO add your handling code here:
        sex="Male";
        System.out.println(sex);
    }                                             

    private void jRadioButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                              
        // TODO add your handling code here:
        sex="Female";
        System.out.println(sex);
    }                                             

    private void jTextField8FocusLost(java.awt.event.FocusEvent evt) {                                      
        // TODO add your handling code here:
        if(jTextField8.getText().equals(""))
        {
            jLabel20.setText("Entry Is Must");
        }
        else
        {
            jLabel20.setText("");
        }
    }                                     

    private void jTextField9FocusLost(java.awt.event.FocusEvent evt) {                                      
        // TODO add your handling code here:
        if(jTextField9.getText().equals(""))
        {
            jLabel21.setText("Entry Is Must");
        }
        else
        {
            jLabel21.setText("");
        }
    }                                     

    private void jTextField10FocusLost(java.awt.event.FocusEvent evt) {                                       
        // TODO add your handling code here:
        if(jTextField10.getText().equals(""))
        {
            jLabel22.setText("Entry Is Must");
        }
        else
        {
            jLabel22.setText("");
        }
    }                                      

    private void jTextField11FocusLost(java.awt.event.FocusEvent evt) {                                       
        // TODO add your handling code here:
        if(jTextField11.getText().equals(""))
        {
            jLabel23.setText("Entry Is Must");
        }
        else
        {
            jLabel23.setText("") ;
        }
    }                                      

    private void jTextField12FocusLost(java.awt.event.FocusEvent evt) {                                       
        // TODO add your handling code here:
        if(jTextField12.getText().equals(""))
        {
            jLabel24.setText("Entry Is Must");
        }
        else
        {
            String jtf1=jTextField12.getText();
            int fg=0;
            for(int i=0;i<jtf1.length();i++)
            {
                char c1=jtf1.charAt(i);
                if(Character.isLetter(c1))
                {
                    fg=0;
                    break;
                }
                else
                {
                    fg=1;
                }
            }
            if(fg==0)
            {
                jLabel24.setText("Enter Valid Phone Number");
                jTextField12.setText("");
            }
            else
                jLabel24.setText("") ;
        }
    }                                      

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        if(jTextField7.getText().equals("") || jTextField8.getText().equals("") || jTextField9.getText().equals("") || jTextField10.getText().equals("") || jTextField11.getText().equals("") || jTextField12.getText().equals(""))
        {
            JOptionPane.showMessageDialog(null,"Enter all appropriate fields");
            if(jTextField7.getText().equals(""))
            {
                jLabel19.setText("Fill this Field");
            }
            else
                jLabel19.setText("");
            if(jTextField8.getText().equals(""))
            {
                jLabel20.setText("Fill this Field");
            }
            else
                jLabel20.setText("");
            if(jTextField9.getText().equals(""))
            {
                jLabel21.setText("Fill this Field");
            }
            else
                jLabel21.setText("");
            if(jTextField10.getText().equals(""))
            {
                jLabel22.setText("Fill this Field");
            }
            else
                jLabel22.setText("");
            if(jTextField11.getText().equals(""))
            {
                jLabel23.setText("Fill this Field");
            }
            else
                jLabel23.setText("");
            if(jTextField12.getText().equals(""))
            {
                jLabel24.setText("Fill this Field");
            }
            else
                jLabel24.setText("");
        }
        else
        {
            if(flag==0)
            {
                cname=jTextField2.getText();
                pdate=jTextField3.getText();
                paidamt=Integer.parseInt(jTextField4.getText());
                balamt=Integer.parseInt(jTextField5.getText());
                refid=Integer.parseInt(jTextField6.getText());
                saveupdate();
                
                try
                {
                    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                    Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");

                    PreparedStatement prp=con.prepareStatement("insert into newcustomer_details values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
                    prp.setInt(1,cid);
                    prp.setString(2,cname);
                    prp.setString(3,pdate);
                    prp.setInt(4,paidamt);
                    prp.setInt(5,balamt);
                    prp.setInt(6,refid);
                    prp.setString(7,dob);
                    prp.setInt(8,age);
                    prp.setString(9,sex);
                    prp.setString(10,dno);
                    prp.setString(11,street);
                    prp.setString(12,city);
                    prp.setString(13,state);
                    prp.setString(14,phno);
                    prp.setString(15,mob_purchased);

                    prp.executeUpdate();

                    JOptionPane.showMessageDialog(null,"Customer Details saved successfully");

                    con.commit();
                    con.close();
                    dispose();

                }
                catch(SQLException e)
                {
                    JOptionPane.showMessageDialog(null,"INVALID DATE, please select correct date");
                    jComboBox1.setSelectedItem("01");
                    jComboBox2.setSelectedItem("jan");
                    jComboBox3.setSelectedItem("1910");
                }
                catch(Exception e)
                {
                    JOptionPane.showMessageDialog(null,"Error is:"+e);
                }
            }
            else if(flag==1)
            {
                currentcid=Integer.parseInt(jTextField1.getText());
                totalbal=Integer.parseInt(jTextField14.getText());
                mob_purchased=jTextArea1.getText();
                try
                {
                    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                    Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");

                    PreparedStatement prp=con.prepareStatement("update newcustomer_details set balamt=?, mob_purchased=? where cid=?");
                    prp.setInt(1,totalbal);
                    prp.setString(2,mob_purchased);
                    prp.setInt(3,currentcid);
                    prp.executeUpdate();

                    JOptionPane.showMessageDialog(null,"The Customer Details updated successfully");
                    con.commit();
                    con.close();
                    dispose();

                }
                catch(Exception e)
                {
                    JOptionPane.showMessageDialog(null,"The error is:"+e);
                }

            }
            else if(flag==2)
            {
                dispose();
            }
            else if(flag==3)
            {
                currentcid=Integer.parseInt(jTextField1.getText());
                saveupdate();
                try
                {
                    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                    Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");

                    PreparedStatement prp=con.prepareStatement("update newcustomer_details set dob=?,age=?,gender=?,dno=?,street=?,city=?,state=?,phno=? where cid=?");
                    prp.setString(1,dob);
                    prp.setInt(2,age);
                    prp.setString(3,sex);
                    prp.setString(4,dno);
                    prp.setString(5,street);
                    prp.setString(6,city);
                    prp.setString(7,state);
                    prp.setString(8,phno);
                    prp.setInt(9,currentcid);
                    prp.executeUpdate();
                    JOptionPane.showMessageDialog(null,"The Customer Details Updated Successfully");
                    con.commit();
                    con.close();
                    dispose();
                    

                }
                catch(Exception e)
                {
                    JOptionPane.showMessageDialog(null,"The error is:"+e);
                }
            }
            
        }
    }                                        

    private void jTextField7FocusGained(java.awt.event.FocusEvent evt) {                                        
        // TODO add your handling code here:
        String temp=(String)jComboBox3.getSelectedItem();
        int birthyear=Integer.parseInt(temp);
        int thisyear=Integer.parseInt(year);
        System.out.println(birthyear+","+thisyear);
        int agefind=thisyear-birthyear;
        agefind=agefind-1;
        jTextField7.setText(Integer.toString(agefind));

    }                                       

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        jComboBox1.setSelectedItem("01");
        jComboBox2.setSelectedItem("jan");
        jComboBox3.setSelectedItem("1910");
        jRadioButton1.setSelected(true);
        jTextField7.setText("");jLabel19.setText("");
        jTextField8.setText("");jLabel20.setText("");
        jTextField9.setText("");jLabel21.setText("");
        jTextField10.setText("");jLabel22.setText("");
        jTextField11.setText("");jLabel23.setText("");
        jTextField12.setText("");jLabel24.setText("");

    }                                        

    /**
    * @param args the command line arguments
    */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new CreditCustomer().setVisible(true);
            }
        });
    }

    // Variables declaration - do not modify                     
    public javax.swing.JButton jButton1;
    public javax.swing.JButton jButton2;
    public javax.swing.JComboBox jComboBox1;
    public javax.swing.JComboBox jComboBox2;
    public javax.swing.JComboBox jComboBox3;
    private javax.swing.JLabel jLabe;
    public javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel10;
    private javax.swing.JLabel jLabel11;
    private javax.swing.JLabel jLabel12;
    private javax.swing.JLabel jLabel13;
    private javax.swing.JLabel jLabel14;
    private javax.swing.JLabel jLabel15;
    private javax.swing.JLabel jLabel16;
    private javax.swing.JLabel jLabel17;
    private javax.swing.JLabel jLabel18;
    private javax.swing.JLabel jLabel19;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel20;
    private javax.swing.JLabel jLabel21;
    private javax.swing.JLabel jLabel22;
    private javax.swing.JLabel jLabel23;
    private javax.swing.JLabel jLabel24;
    public javax.swing.JLabel jLabel25;
    public javax.swing.JLabel jLabel26;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel7;
    public javax.swing.JLabel jLabel8;
    private javax.swing.JLabel jLabel9;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JPanel jPanel3;
    public javax.swing.JRadioButton jRadioButton1;
    public javax.swing.JRadioButton jRadioButton2;
    private javax.swing.JScrollPane jScrollPane1;
    public javax.swing.JTextArea jTextArea1;
    public javax.swing.JTextField jTextField1;
    public javax.swing.JTextField jTextField10;
    public javax.swing.JTextField jTextField11;
    public javax.swing.JTextField jTextField12;
    public javax.swing.JTextField jTextField13;
    public javax.swing.JTextField jTextField14;
    public javax.swing.JTextField jTextField2;
    public javax.swing.JTextField jTextField3;
    public javax.swing.JTextField jTextField4;
    public javax.swing.JTextField jTextField5;
    public javax.swing.JTextField jTextField6;
    public javax.swing.JTextField jTextField7;
    public javax.swing.JTextField jTextField8;
    public javax.swing.JTextField jTextField9;
    // End of variables declaration                   

}



Code for SearchCustomer Page:


/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/*
 * SearchCustomer.java
 *
 * Created on Nov 10, 2010, 2:26:43 AM
 */

package mobilestorenew;

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

/**
 *
 * @author Ramesh
 */
public class SearchCustomer extends javax.swing.JFrame {

    /** Creates new form SearchCustomer */
    int flag=0,rows=0,a=0,b=0;
    String cid;
    Object data[][];
    JTable table;
    JScrollPane jsp;
    ResultSet res;
    ResultSet rs;
    public SearchCustomer() {
        initComponents();
        setVisible(true);
        setSize(1270,740);
        setTitle("Search Customer");
        ButtonGroup bg=new ButtonGroup();
        bg.add(jRadioButton1);
        bg.add(jRadioButton2);
    }
    public void tabledisp()
    {
        try
                {

                    data=new Object[rows][15];
                    Object[] colheads={"Custmer Id","Customer Name","Purchase Date","Paid Amount","Balance Amount","Reference Id","Date Of Birth","Age","Gender","Door No","Street","City","State","Phone No","Mobiles Purchased"};


                    Class.forName("sun.jdbc.odbc.JdbcOdbc");
                    Connection con=DriverManager.getConnection("Jdbc:Odbc:mobileDSN","scott","tiger");
                    Statement st=con.createStatement();

                    rs=st.executeQuery("select * from csearch");
                    for(int i=0;i<rows;i++)
                    {
                            rs.next();
                            for(int j=0;j<15;j++)
                            {
                                data [i][j]=rs.getString(j+1);
                                System.out.println(data[i][j]);
                            }
                    }
                    table=new JTable(data,colheads);

                    int v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED;
                    int h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED;
                    jsp=new JScrollPane(table,v,h);
                    jsp.setBounds(70,380,900,240);
                    jPanel2.add(jsp);
                    add(jsp);
                    System.out.println("hai we came here");
                    rows=0;
                    st.close();
                    con.commit();
                    con.close();

                }
                catch(Exception e)
                {
                    JOptionPane.showMessageDialog(null,"here the error is:"+e);
                }

    }
   

    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">                          
    private void initComponents() {

        jPanel1 = new javax.swing.JPanel();
        jLabel2 = new javax.swing.JLabel();
        jTextField1 = new javax.swing.JTextField();
        jLabel3 = new javax.swing.JLabel();
        jRadioButton1 = new javax.swing.JRadioButton();
        jRadioButton2 = new javax.swing.JRadioButton();
        jLabel1 = new javax.swing.JLabel();
        jButton1 = new javax.swing.JButton();
        jButton2 = new javax.swing.JButton();
        jPanel2 = new javax.swing.JPanel();

        setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
        getContentPane().setLayout(null);

        jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(""));
        jPanel1.setLayout(null);

        jLabel2.setFont(new java.awt.Font("Tahoma", 1, 14));
        jLabel2.setText("Search Field");
        jPanel1.add(jLabel2);
        jLabel2.setBounds(90, 40, 90, 30);

        jTextField1.setFont(new java.awt.Font("Tahoma", 1, 14));
        jTextField1.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusGained(java.awt.event.FocusEvent evt) {
                jTextField1FocusGained(evt);
            }
        });
        jPanel1.add(jTextField1);
        jTextField1.setBounds(210, 40, 160, 30);
        jPanel1.add(jLabel3);
        jLabel3.setBounds(380, 40, 100, 30);

        jRadioButton1.setFont(new java.awt.Font("Tahoma", 1, 14));
        jRadioButton1.setSelected(true);
        jRadioButton1.setText(" Search By Customer Id");
        jRadioButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jRadioButton1ActionPerformed(evt);
            }
        });
        jPanel1.add(jRadioButton1);
        jRadioButton1.setBounds(90, 110, 210, 25);

        jRadioButton2.setFont(new java.awt.Font("Tahoma", 1, 14));
        jRadioButton2.setText(" Search By Customer Name");
        jRadioButton2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jRadioButton2ActionPerformed(evt);
            }
        });
        jPanel1.add(jRadioButton2);
        jRadioButton2.setBounds(90, 160, 230, 25);

        getContentPane().add(jPanel1);
        jPanel1.setBounds(40, 90, 500, 240);

        jLabel1.setFont(new java.awt.Font("Tahoma", 1, 24));
        jLabel1.setText("Search Customer Details");
        getContentPane().add(jLabel1);
        jLabel1.setBounds(310, 20, 320, 50);

        jButton1.setFont(new java.awt.Font("Tahoma", 1, 18));
        jButton1.setText("Search");
        jButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton1ActionPerformed(evt);
            }
        });
        getContentPane().add(jButton1);
        jButton1.setBounds(610, 180, 120, 40);

        jButton2.setFont(new java.awt.Font("Tahoma", 1, 18));
        jButton2.setText("Cancel");
        getContentPane().add(jButton2);
        jButton2.setBounds(770, 180, 100, 40);

        jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder("Search Results"));

        javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
        jPanel2.setLayout(jPanel2Layout);
        jPanel2Layout.setHorizontalGroup(
            jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 944, Short.MAX_VALUE)
        );
        jPanel2Layout.setVerticalGroup(
            jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGap(0, 270, Short.MAX_VALUE)
        );

        getContentPane().add(jPanel2);
        jPanel2.setBounds(40, 350, 960, 300);

        pack();
    }// </editor-fold>                        

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        if(jTextField1.getText().equals(""))
        {
            jLabel3.setText("Entry Is Must");
            jTextField1.setText("");
        }
        else
        {
            jLabel3.setText("");
            cid=jTextField1.getText();
            if(flag==0)
            {
                try
                {
                    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                    Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
                    Statement st=con.createStatement();
                    st.executeUpdate("delete csearch");
                    res=st.executeQuery("select * from newcustomer_details");
                    Boolean rec=res.next();
                    if(rec==false)
                    {
                        JOptionPane.showMessageDialog(null,"There are no customers exists");
                        jTextField1.setText("");
                    }
                    else
                    {
                        do
                        {
                            String dcid=res.getString(1);
                            String dcname=res.getString(2);

                            java.sql.Date dt=res.getDate(3);
                            String dd=dt.toString();
                            String year=dd.substring(0,4);
                            String month=dd.substring(5,7);
                            String day=dd.substring(8,10);
                            String mc="";
                            if(month.equals("01"))
                            {
                                mc="jan";
                            }
                            else if(month.equals("02"))
                            {
                                mc="feb";
                            }
                            else if(month.equals("03"))
                            {
                                mc="mar";
                            }
                            else if(month.equals("04"))
                            {
                                mc="apr";
                            }
                            else if(month.equals("05"))
                            {
                                mc="may";
                            }
                            else if(month.equals("06"))
                            {
                                mc="jun";
                            }
                            else if(month.equals("07"))
                            {
                                mc="jul";
                            }
                            else if(month.equals("08"))
                            {
                                mc="aug";
                            }
                            else if(month.equals("09"))
                            {
                                mc="sep";
                            }
                            else if(month.equals("10"))
                            {
                                mc="oct";
                            }
                            else if(month.equals("11"))
                            {
                                mc="nov";
                            }
                            else if(month.equals("12"))
                            {
                                mc="dec";
                            }
                            String date=day+"-"+mc+"-"+year;

                            int dpaidamt=res.getInt(4);
                            int dbalamt=res.getInt(5);
                            int drefid=res.getInt(6);

                            java.sql.Date dob=res.getDate(7);

                            String ddob=dob.toString();
                            String year1=ddob.substring(0,4);
                            String month1=ddob.substring(5,7);
                            String day1=ddob.substring(8,10);

                            String mc1="";
                            if(month1.equals("01"))
                            {
                                mc1="jan";
                            }
                            else if(month1.equals("02"))
                            {
                                mc1="feb";
                            }
                            else if(month1.equals("03"))
                            {
                                mc1="mar";
                            }
                            else if(month1.equals("04"))
                            {
                                mc1="apr";
                            }
                            else if(month1.equals("05"))
                            {
                                mc1="may";
                            }
                            else if(month1.equals("06"))
                            {
                                mc1="jun";
                            }
                            else if(month1.equals("07"))
                            {
                                mc1="jul";
                            }
                            else if(month1.equals("08"))
                            {
                                mc1="aug";
                            }
                            else if(month1.equals("09"))
                            {
                                mc1="sep";
                            }
                            else if(month1.equals("10"))
                            {
                                mc1="oct";
                            }
                            else if(month1.equals("11"))
                            {
                                mc1="nov";
                            }
                            else if(month1.equals("12"))
                            {
                                mc1="dec";
                            }

                            String date1=day1+"-"+mc1+"-"+year1;

                            int dage=res.getInt(8);
                            String dgender=res.getString(9);
                            String ddno=res.getString(10);
                            String dstreet=res.getString(11);
                            String dcity=res.getString(12);
                            String dstate=res.getString(13);
                            String dphno=res.getString(14);
                            String dmob_purchased=res.getString(15);

                            if(cid.equalsIgnoreCase(dcid))
                            {
                                PreparedStatement prp=con.prepareStatement("insert into csearch values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
                                prp.setString(1,dcid);
                                prp.setString(2,dcname);
                                prp.setString(3,date);
                                prp.setInt(4,dpaidamt);
                                prp.setInt(5,dbalamt);
                                prp.setInt(6,drefid);
                                prp.setString(7,date1);
                                prp.setInt(8,dage);
                                prp.setString(9,dgender);
                                prp.setString(10,ddno);
                                prp.setString(11,dstreet);
                                prp.setString(12,dcity);
                                prp.setString(13,dstate);
                                prp.setString(14,dphno);
                                prp.setString(15,dmob_purchased);

                                prp.executeUpdate();
                                rows++;
                                System.out.println(rows);
                                System.out.println("i came here");

                                a=1;

                                jTextField1.setText("");

                            }
                            
                        }while(res.next());
                        if(a==0)
                        {
                            JOptionPane.showMessageDialog(null,"The customer ID does not exists");
                            jTextField1.setText("");
                        }
                    }
                    con.commit();
                    con.close();
                }
                catch(Exception e)
                {
                    JOptionPane.showMessageDialog(null,"The error is:"+e);
                }
                tabledisp();
            }
            if(flag==1)
            {
                try
                {
                    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                    Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
                    Statement st=con.createStatement();
                    st.executeUpdate("delete csearch");
                    res=st.executeQuery("select * from newcustomer_details");
                    Boolean rec=res.next();
                    if(rec==false)
                    {
                        JOptionPane.showMessageDialog(null,"There are no customers exists");
                        jTextField1.setText("");
                    }
                    else
                    {
                        do
                        {
                            String dcid=res.getString(1);
                            String dcname=res.getString(2);

                            java.sql.Date dt=res.getDate(3);
                            String dd=dt.toString();
                            String year=dd.substring(0,4);
                            String month=dd.substring(5,7);
                            String day=dd.substring(8,10);
                            String mc="";
                            if(month.equals("01"))
                            {
                                mc="jan";
                            }
                            else if(month.equals("02"))
                            {
                                mc="feb";
                            }
                            else if(month.equals("03"))
                            {
                                mc="mar";
                            }
                            else if(month.equals("04"))
                            {
                                mc="apr";
                            }
                            else if(month.equals("05"))
                            {
                                mc="may";
                            }
                            else if(month.equals("06"))
                            {
                                mc="jun";
                            }
                            else if(month.equals("07"))
                            {
                                mc="jul";
                            }
                            else if(month.equals("08"))
                            {
                                mc="aug";
                            }
                            else if(month.equals("09"))
                            {
                                mc="sep";
                            }
                            else if(month.equals("10"))
                            {
                                mc="oct";
                            }
                            else if(month.equals("11"))
                            {
                                mc="nov";
                            }
                            else if(month.equals("12"))
                            {
                                mc="dec";
                            }
                            String date=day+"-"+mc+"-"+year;

                            int dpaidamt=res.getInt(4);
                            int dbalamt=res.getInt(5);
                            int drefid=res.getInt(6);

                            java.sql.Date dob=res.getDate(7);

                            String ddob=dob.toString();
                            String year1=ddob.substring(0,4);
                            String month1=ddob.substring(5,7);
                            String day1=ddob.substring(8,10);

                            String mc1="";
                            if(month1.equals("01"))
                            {
                                mc1="jan";
                            }
                            else if(month1.equals("02"))
                            {
                                mc1="feb";
                            }
                            else if(month1.equals("03"))
                            {
                                mc1="mar";
                            }
                            else if(month1.equals("04"))
                            {
                                mc1="apr";
                            }
                            else if(month1.equals("05"))
                            {
                                mc1="may";
                            }
                            else if(month1.equals("06"))
                            {
                                mc1="jun";
                            }
                            else if(month1.equals("07"))
                            {
                                mc1="jul";
                            }
                            else if(month1.equals("08"))
                            {
                                mc1="aug";
                            }
                            else if(month1.equals("09"))
                            {
                                mc1="sep";
                            }
                            else if(month1.equals("10"))
                            {
                                mc1="oct";
                            }
                            else if(month1.equals("11"))
                            {
                                mc1="nov";
                            }
                            else if(month1.equals("12"))
                            {
                                mc1="dec";
                            }

                            String date1=day1+"-"+mc1+"-"+year1;

                            int dage=res.getInt(8);
                            String dgender=res.getString(9);
                            String ddno=res.getString(10);
                            String dstreet=res.getString(11);
                            String dcity=res.getString(12);
                            String dstate=res.getString(13);
                            String dphno=res.getString(14);
                            String dmob_purchased=res.getString(15);

                            if(cid.equals(dcname))
                            {
                                PreparedStatement prp=con.prepareStatement("insert into csearch values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
                                prp.setString(1,dcid);
                                prp.setString(2,dcname);
                                prp.setString(3,date);
                                prp.setInt(4,dpaidamt);
                                prp.setInt(5,dbalamt);
                                prp.setInt(6,drefid);
                                prp.setString(7,date1);
                                prp.setInt(8,dage);
                                prp.setString(9,dgender);
                                prp.setString(10,ddno);
                                prp.setString(11,dstreet);
                                prp.setString(12,dcity);
                                prp.setString(13,dstate);
                                prp.setString(14,dphno);
                                prp.setString(15,dmob_purchased);

                                prp.executeUpdate();
                                rows++;
                                System.out.println(rows);
                                System.out.println("i came here");

                                b=1;

                                jTextField1.setText("");

                            }
                            
                        }while(res.next());
                        if(b==0)
                        {
                            JOptionPane.showMessageDialog(null,"The customer Name does not exists");
                            jTextField1.setText("");
                        }
                    }
                    con.commit();
                    con.close();
                }
                catch(Exception e)
                {
                    JOptionPane.showMessageDialog(null,"The error is:"+e);
                }
                tabledisp();
            }
        }

    }                                        

    private void jTextField1FocusGained(java.awt.event.FocusEvent evt) {                                        
        // TODO add your handling code here:
        jsp.setVisible(false);
        a=0;
        b=0;
    }                                       

    private void jRadioButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                              
        // TODO add your handling code here:
        flag=0;
    }                                             

    private void jRadioButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                              
        // TODO add your handling code here:
        flag=1;
    }                                             

    /**
    * @param args the command line arguments
    */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new SearchCustomer().setVisible(true);
            }
        });
    }

    // Variables declaration - do not modify                     
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton2;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JRadioButton jRadioButton1;
    private javax.swing.JRadioButton jRadioButton2;
    private javax.swing.JTextField jTextField1;
    // End of variables declaration                   

}




Code for SalesReports Page:



/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/*
 * SalesReports.java
 *
 * Created on Nov 15, 2010, 1:27:07 AM
 */

package mobilestorenew;

import java.awt.Font;
import java.awt.Graphics;
import java.awt.Graphics2D;
import java.awt.print.*;
import java.sql.*;
import javax.swing.*;



/**
 *
 * @author Ramesh
 */
public class SalesReports extends javax.swing.JFrame implements Printable {

    /** Creates new form SalesReports */
    String text="";
    int a=0,flag;
    int countsales=0,totalamt=0;
    public SalesReports() {
        initComponents();
        setSize(1270,740);
        setTitle("Sales Reports");
        jTextArea1.setEditable(false);
        setVisible(true);

    }

    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">                          
    private void initComponents() {

        jLabel1 = new javax.swing.JLabel();
        jButton1 = new javax.swing.JButton();
        jButton2 = new javax.swing.JButton();
        jScrollPane1 = new javax.swing.JScrollPane();
        jTextArea1 = new javax.swing.JTextArea();
        jComboBox1 = new javax.swing.JComboBox();
        jLabel2 = new javax.swing.JLabel();
        jLabel3 = new javax.swing.JLabel();
        jComboBox2 = new javax.swing.JComboBox();
        jButton3 = new javax.swing.JButton();

        setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
        getContentPane().setLayout(null);

        jLabel1.setFont(new java.awt.Font("Tahoma", 1, 24)); // NOI18N
        jLabel1.setText("Sales Reports");
        getContentPane().add(jLabel1);
        jLabel1.setBounds(430, 10, 320, 40);

        jButton1.setFont(new java.awt.Font("Tahoma", 1, 18));
        jButton1.setText("Print");
        jButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton1ActionPerformed(evt);
            }
        });
        getContentPane().add(jButton1);
        jButton1.setBounds(400, 610, 110, 50);

        jButton2.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
        jButton2.setText("Close");
        jButton2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton2ActionPerformed(evt);
            }
        });
        getContentPane().add(jButton2);
        jButton2.setBounds(550, 610, 100, 50);

        jTextArea1.setColumns(20);
        jTextArea1.setEditable(false);
        jTextArea1.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
        jTextArea1.setRows(5);
        jTextArea1.setTabSize(10);
        jScrollPane1.setViewportView(jTextArea1);

        getContentPane().add(jScrollPane1);
        jScrollPane1.setBounds(70, 140, 910, 440);

        jComboBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "jan", "feb", "mar", "apr", "may", "jun", "jul", "aug", "sep", "oct", "nov", "dec" }));
        getContentPane().add(jComboBox1);
        jComboBox1.setBounds(280, 80, 100, 30);

        jLabel2.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
        jLabel2.setText("Select Month");
        getContentPane().add(jLabel2);
        jLabel2.setBounds(160, 80, 100, 30);

        jLabel3.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
        jLabel3.setText("Select Year");
        getContentPane().add(jLabel3);
        jLabel3.setBounds(420, 80, 90, 30);

        jComboBox2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "2000", "2001", "2002", "2003", "2004", "2005", "2006", "2007", "2008", "2009", "2010", "2011", "2012", "2013", "2014", "2015", "2016", "2017", "2018", "2019", "2020" }));
        getContentPane().add(jComboBox2);
        jComboBox2.setBounds(520, 80, 100, 30);

        jButton3.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
        jButton3.setText("Generate Report");
        jButton3.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton3ActionPerformed(evt);
            }
        });
        getContentPane().add(jButton3);
        jButton3.setBounds(720, 70, 160, 50);

        pack();
    }// </editor-fold>                        

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        jButton1.setVisible(false);
        jButton2.setVisible(false);
        jButton3.setVisible(false);
        PrinterJob printJob = PrinterJob.getPrinterJob();
        
        if (printJob.printDialog())
        {
            try
            {
                printJob.print();
                printJob.setCopies(1);

            }
            catch(Exception PrintException)
            {
                PrintException.printStackTrace();
            }
            printJob.cancel();
        }
        printJob.cancel();
        jButton1.setVisible(true);
        jButton2.setVisible(true);
        jButton3.setVisible(true);
    }                                        

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        dispose();
    }                                        

    private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        jTextArea1.setText("");
        text="";
        a=0;
        String month=(String)jComboBox1.getSelectedItem();
        String year=(String)jComboBox2.getSelectedItem();

        try
            {
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                Connection con=DriverManager.getConnection("jdbc:odbc:mobileDSN","scott","tiger");
                Statement st=con.createStatement();
                ResultSet res=st.executeQuery("select * from newbill");
                Boolean rec=res.next();
                if(rec==false)
                {
                    JOptionPane.showMessageDialog(null,"There are no sales on that month");
                }
                else
                {
                    if(flag==0)
                    {
                        do
                        {
                            String dbid = res.getString(1);
                            java.sql.Date dbdate = res.getDate(2);
                            String bdate = dbdate.toString();
                            String dmonth=bdate.substring(5,7);
                            String dyear=bdate.substring(0,4);
                            String mc1="";
                            if (dmonth.equals("01"))
                            {
                                mc1 = "jan";
                            } 
                            else if (dmonth.equals("02"))
                            {
                                    mc1 = "feb";
                            } else if (dmonth.equals("03"))
                            {
                                    mc1 = "mar";
                            } else if (dmonth.equals("04"))
                            {
                                    mc1 = "apr";
                            } else if (dmonth.equals("05"))
                            {
                                    mc1 = "may";
                            } else if (dmonth.equals("06"))
                            {
                                    mc1 = "jun";
                            } else if (dmonth.equals("07"))
                            {
                                    mc1 = "jul";
                            } else if (dmonth.equals("08"))
                            {
                                    mc1 = "aug";
                            } else if (dmonth.equals("09"))
                            {
                                    mc1 = "sep";
                            } else if (dmonth.equals("10"))
                            {
                                    mc1 = "oct";
                            } else if (dmonth.equals("11"))
                            {
                                    mc1 = "nov";
                            } else if (dmonth.equals("12"))
                            {
                                    mc1 = "dec";
                            }

                            String dcname = res.getString(3);
                            int dprice = res.getInt(4);
                            int damtpaid = res.getInt(5);
                            String mob_purchased = res.getString(7);

                            if(mc1.equalsIgnoreCase(month) && dyear.equalsIgnoreCase(year))
                            {
                                countsales++;
                                totalamt+=damtpaid;
                                text+="\n"+dbid+" \t"+bdate+" \t"+dcname+" \t\t"+dprice+" \t"+damtpaid+" \t"+mob_purchased+" \n";
                                jTextArea1.setText("Bill Id \tBill Date \tCustomerName \t\tTotalPrice \tAmountPaid \tMobiles Purchased \n"+
                                "-----------------------------------------------------------------------------------------------------" +
                                "-----------------------------------------------------------------------------"+text+"\n--------------------------------------------------------------------------------------------"+
                                "-----------------------------------------------------------------------------\n\n\t\t Total No. Of Sales: "+countsales+"\tTotal Amount Collected: "+totalamt);
                                a=1;
                                countsales=0;
                                totalamt=0;
                            }
                        }while(res.next());
                        
                    }
                    if(flag==1)
                    {
                        do
                        {
                            String dbid = res.getString(1);
                            java.sql.Date dbdate = res.getDate(2);
                            String bdate = dbdate.toString();
                            String dyear=bdate.substring(0,4);
                            String dcname = res.getString(3);
                            int dprice = res.getInt(4);
                            int damtpaid = res.getInt(5);
                            String mob_purchased = res.getString(7);
                            if(dyear.equalsIgnoreCase(year))
                            {

                                countsales++;
                                totalamt+=damtpaid;
                                text+="\n"+dbid+" \t"+bdate+" \t"+dcname+" \t\t"+dprice+" \t"+damtpaid+" \t"+mob_purchased+" \n";
                                jTextArea1.setText("Bill Id \tBill Date \tCustomerName \t\tTotalPrice \tAmountPaid \tMobiles Purchased \n"+
                                "-----------------------------------------------------------------------------------------------------" +
                                "-----------------------------------------------------------------------------"+text+"\n--------------------------------------------------------------------------------------------"+
                                "-----------------------------------------------------------------------------\n\n\t\t Total No. Of Sales: "+countsales+"\tTotal Amount Collected: "+totalamt);
                                countsales=0;
                                totalamt=0;
                                a=1;
                            }

                        }
                        while(res.next());
                        
                    }
                    if(a==0)
                    {
                        JOptionPane.showMessageDialog(null,"There are no sales on that particular month");
                        jTextArea1.setText("");
                    }
                }
            }
            catch(Exception e)
            {
                JOptionPane.showMessageDialog(null,"The error is:"+e);
            }


    }                                        
public int print(Graphics g, PageFormat pf, int pi) throws PrinterException
{
    Graphics2D g2 = (Graphics2D) g;
    g2.translate(pf.getImageableX()+5, pf.getImageableY()+5);
    Font  f = new Font("Monospaced",Font.PLAIN,12);
    g2.setFont (f);
    paint (g2);
    return Printable.PAGE_EXISTS;
}
    /**
    * @param args the command line arguments
    */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new SalesReports().setVisible(true);
            }
        });
    }

    // Variables declaration - do not modify                     
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton2;
    public javax.swing.JButton jButton3;
    public javax.swing.JComboBox jComboBox1;
    public javax.swing.JComboBox jComboBox2;
    public javax.swing.JLabel jLabel1;
    public javax.swing.JLabel jLabel2;
    public javax.swing.JLabel jLabel3;
    public javax.swing.JScrollPane jScrollPane1;
    public javax.swing.JTextArea jTextArea1;
    // End of variables declaration                   

}