problem with my jdbc/swing code

[Sireesha ikkurthi]

jdbc/swing
============

Following is my code to retrive data from my ms-access table NAME to display the employee name and his id.

But iam getting the error as

can not resolve the symbol varaible addbutton
in the line (e.getSource == addbutton)

also can not resolve symbol
variable rs ( which is my Resultset that i have created in my code).

can any body help in solving my problem to retrieve and display the values from the table to the textfields.

Thanks in advance.

code starts:
============

import java.sql.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
 
public class sample1 extends JFrame implements ActionListener 
{
  public sample1()
  {
   super("Sample application");
 
 // JPanel p = new JPanel();
 
  JLabel empid  = new JLabel("Employee id");
 
  JLabel empnamelabel = new JLabel("Employee name");
  
 
  JTextField id = new JTextField(20); 
 
  JTextField empname = new JTextField(20);
 
  JButton addbutton = new JButton("Add");
 
  Container c = getContentPane();
 
//  c.add(p);
 
 
  c.add(addbutton);
  c.add(empnamelabel);
  c.add(empname);
  c.add(id);
  c.add(empid);
 
 
 
      addbutton.addActionListener( this);
      add( addbutton );
 
 
 
 
//load the JDBC-ODBC bridge driver
 
 
          try {
               Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 
             }
 
                 catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: "); 
System.err.println(e.getMessage());
}
 
 
    // Get the connection
 
      Connection conn = DriverManager.getConnection("jdbc  :-o	  dbc:empdsn");
 
    // create a statement object, resultset object and prepared statement to pass sql queries.
 
       Statement st = conn.createStatement();

       st.executeQuery("Select * from NAME");
      
       ResultSet rs = st.getResultSet();
 
 
   pack();
   setVisible(true);
 
 }
 
 
  public static void main(String args[])
   {
  
     sample1 sam = new sample1();
     
      sam.addWindowListener(
          new WindowAdapter() {
             public void windowClosing( WindowEvent e ) {
               System.exit( 0 );
             }
          }
       );
    }
 
 
public void actionPerformed(ActionEvent e)
{
  if(e.getSource()==addbutton) {
     try
    {
           while(rs.next())
       {
         id.setText(rs.getString(1));  
         empname.setText(rs.getString(2));
        }      
     }
     catch(Exception ee) {}
     
   }
}
 
 
}

[ August 09, 2007: Message edited by: Gregg Bolinger ]

[Gregg Bolinger]

It's all about the scope. addbutton is only accessible in the sample1() method. And it's pretty much the same issue with your ResultSet object.
[ August 09, 2007: Message edited by: Gregg Bolinger ]

[Sireesha ikkurthi]

Thanks for your reply, can you give the exact code for getting the output, as i altered my code and tried, but getting the same error.

Thanks

[Shrikanth Nekkanti]

[ August 10, 2007: Message edited by: Shrikanth Nekkanti ]

[Sireesha ikkurthi]

i did not understand what you are trying to say