import java.sql. ; import java.awt.; import javax.swing.; import java.awt.event.; public class saving extends JFrame implements ActionListener{ JTextField edpno=new JTextField(10); JLabel l0= new JLabel ("EDP Number: ");

JComboBox fname = new JComboBox();
JLabel l1= new JLabel("First Name: ");

JTextField lname= new JTextField(20);
JLabel l2= new JLabel("Last Name: ");

// JTextField contno= new JTextField(20); // JLabel l3= new JLabel("Contact Number: ");

JComboBox contno = new JComboBox();
JLabel l3 = new JLabel ("Contact Number: ");



JButton bOK = new JButton("Save");
JButton bRetrieve = new JButton("Retrieve");
private ImageIcon icon; 
    JPanel C=new JPanel(){
        protected void paintComponent(Graphics g){
            g.drawImage(icon.getImage(),0,0,null);
            super.paintComponent(g);
        }
    };


    public Search Record (){
        icon=new ImageIcon("images/canres.png");
        C.setOpaque(false);

        C.setLayout(new GridLayout(5,2,4,4));
        setTitle("Search Record");

        C.add (l0);
        C.add (edpno);
        edpno.addActionListener(this);
        C.add (l1);
        C.add (fname);


        fname.setForeground(Color.BLUE);
        fname.setFont(new Font(" ", Font.BOLD,15));


        C.add (l2);
        C.add (lname);
        C.add (l3);
        C.add (contno);


        contno.setForeground(Color.BLUE);
        contno.setFont(new Font(" ", Font.BOLD,15));


        C.add(bOK);
        bOK.addActionListener(this);

        C.add (bRetrieve);
        bRetrieve.addActionListener(this);

        bOK.setBackground(Color.white);
        bRetrieve.setBackground(Color.white);


}
public void saverecord(){
try{

    //Connect to the Database
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    String path ="jdbc:odbc:;DRIVER=Microsoft Access Driver (*.mdb);DBQ=Database/roomassign.mdb";
    String DBPassword ="";
    String DBUserName ="";
    Connection con = DriverManager.getConnection(path,"","");
    Statement s = con.createStatement();
    s.executeQuery("select firstname, Lastname, contact number from name WHERE edpno ='"+edpno.getText()+"'");

    ResultSet rs = s.getResultSet();
    ResultSetMetaData md = rs.getMetaData();
    while(rs.next())
    {
        fname.setSelectedItem(rs.getString(1));
        lname.setText(rs.getString(2));
        contno.setSelectedItem(rs.getString(3));
//      crs.setSelectedItem(rs.getString(4));
    }
    s.close();
    con.close();
}
catch(Exception Q)
{
    JOptionPane.showMessageDialog(this,Q);
}
}


public void SaveRecord(){
        try{
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

            String path = "jdbc:odbc:;DRIVER=Microsoft Access Driver (*.mdb);DBQ=Database/roomassign.mdb";
            String DBPassword   ="";
            String DBUsername   ="";
            Connection con = DriverManager.getConnection(path,"","");
            Statement s = con.createStatement();
            String sql = "UPDATE rooms SET Firstname='"+fname.getSelectedItem()+"',Lastname='"+lname.getText()+"',Contactnumber='"+contno.getSelectedItem()+"' WHERE '"+edpno.getText()+"'=edpno";
            s.executeUpdate(sql);
                JOptionPane.showMessageDialog(this,"New room Record has been successfully saved");

            dispose();
            s.close();
            con.close();                            
        }
        catch(Exception Mismatch){
            JOptionPane.showMessageDialog(this,Mismatch);
        }
    }


    public void actionPerformed (ActionEvent ako){
        if (ako.getSource() == bRetrieve){
            dispose();
        }
        else if (ako.getSource() == bOK){
            SaveRecord();
        }

    }


public static void main (String [] awtsave){
        new Search();
    }

}