02 May 2012

Contacts Project : Main Window




package conpack;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;



import javax.swing.DefaultListModel;
import javax.swing.JButton;

import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JList;
import javax.swing.JMenu;
import javax.swing.JMenuBar;
import javax.swing.JMenuItem;


import javax.swing.JTextField;
import javax.swing.event.ListSelectionEvent;
import javax.swing.event.ListSelectionListener;


public class windows extends JFrame implements ActionListener,ListSelectionListener{
     
      JTextField name,number;
      JButton find;
      JLabel lname,lnumber;
      JList list;
    DefaultListModel model ;

     
    public windows() {
      setLayout(null);
     
      model = new DefaultListModel();   
      list = new JList(model);
      list.setBounds(100,70,100,100);
      add(list);
     
      // Initialize the list with items
      list.addListSelectionListener(this);
     
        setTitle("Contacts");
        setSize(300, 300);
            
        name = new JTextField(5);
        name.setBounds(100,20,100,20);
        add(name);
       
        number = new JTextField(5);
        number.setBounds(180,200,100,20);
        add(number);
       
        find = new JButton("Find");
        find.setBounds(20,200,100,20);
        find.addActionListener(this);
        add(find);
       

        // Creates a menubar for a JFrame
        JMenuBar menuBar = new JMenuBar();
       
        // Add the menubar to the frame
        setJMenuBar(menuBar);
       
        // Define and add two drop down menu to the menubar
        JMenu fileMenu = new JMenu("Options");
      
        menuBar.add(fileMenu);
              
        // Create and add simple menu item to one of the drop down menu
        JMenuItem newAction = new JMenuItem("Add Contact");

        JMenuItem editAction = new JMenuItem("Edit");
        JMenuItem deleteAction = new JMenuItem("Delete");
        JMenuItem copyAction = new JMenuItem("Copy");
        // JMenuItem moveAction = new JMenuItem("Move");
        JMenuItem exitAction = new JMenuItem("Exit");
       

        fileMenu.add(newAction);
        fileMenu.add(editAction);
        fileMenu.add(deleteAction);
  
        fileMenu.add(copyAction);
        //  fileMenu.add(moveAction);
        fileMenu.addSeparator();
        fileMenu.add(exitAction);
     

        // Add a listener to the New menu item. actionPerformed() method will
        // invoked, if user triggred this menu item
       
        try{
                   
                  Class.forName("oracle.jdbc.driver.OracleDriver");
                  Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "system","system");
                 
                 
                  Statement st=con.createStatement();
                  String str = name.getText();
                  //ResultSet rs=st.executeQuery("select num from contacts where nam = '"+str+"'");
                  ResultSet rs=st.executeQuery("select * from contacts");
                int i = 0;
                  while(rs.next()){

                model.add(i,rs.getString("nam"));
                i++;

                  }
                 
              }
            catch(Exception e1)
            {
                  System.out.println(e1);
            }
       
        newAction.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent arg0) {
                System.out.println("You have clicked on the new action");
                dispose();
                AddContact c = new AddContact();
                c.setSize(300,300);
                c.setVisible(true);
                c.setLocation(500, 400);
            }
        });
       
        editAction.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent arg0) {
                System.out.println("You have clicked on the edit action");
                dispose();
                EditContact c = new EditContact();
                c.setSize(300,300);
                c.setVisible(true);c.setLocation(500, 400);
            }
        });
       
        deleteAction.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent arg0) {
                System.out.println("You have clicked on the delete action");
                dispose();
               DeleteContact c = new DeleteContact();
                c.setSize(300,300);
                c.setVisible(true);c.setLocation(500, 400);
               
            }
        });
       
        copyAction.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent arg0) {
                System.out.println("You have clicked on the copy action");
                dispose();
               CopyContact c = new CopyContact();
                c.setSize(300,300);
                c.setVisible(true);c.setLocation(500, 400);
            }
        });
       
        exitAction.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent arg0) {
               
                dispose(); // close
            
            }
        });
           
    }
   
        public void valueChanged(ListSelectionEvent e) {

                   try{
                         
                              Class.forName("oracle.jdbc.driver.OracleDriver");
                              Connection con=
DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "system","system");
                             
                             
                       Statement st=con.createStatement();
                       String str = list.getSelectedValue().toString();
ResultSet rs=st.executeQuery("select num from contacts where nam = '"+str+"'");
                              // may table name is contacts
                              // column names are num , nam and grp
                           
                              while(rs.next()){
                       
                                    number.setText(rs.getString(1));
                              }

                          }
                        catch(Exception e1)
                        {
                              System.out.println(e1);
                        }
                 
            }
   
   public void actionPerformed(ActionEvent e) {
             if(e.getSource()== find )
             {

              try{
                   
                  Class.forName("oracle.jdbc.driver.OracleDriver");
                  Connection con=
DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "system","system");
                 
                 
                  Statement st=con.createStatement();
                  String str = name.getText();
ResultSet rs=st.executeQuery("select num from contacts where nam = '"+str+"'");
                 
           
                  while(rs.next()){
                       
                        number.setText(rs.getString(1).toString());
                       
                  }
                 
           

              }
            catch(Exception e1)
                {
                  System.out.println(e1);
                }
             }
       
           
    }
  
   
    public static void main (String[] args)
    {
        windows me = new windows();
        me.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        me.setVisible(true);
        me.setLocation(500, 400);

    }
}







0 comments:

Post a Comment

Related Posts with Thumbnails

Popular Posts

 
;