i need help with this code? plz

[Aa'ed Qarta]

hey there,
i'm new to JDBC stuff, so i did my best to make a simple SQL editor for my university project. i need to know how to return my connection object in this code..

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

public class OptionsDialog extends JDialog  
 {
 
    
    private JLabel driver, url, user, password, status;
    private JTextField tdriver, turl, tuser;
    private JPasswordField tpassword;
    private JPanel p;
      private JButton connect;
            
       
    
public OptionsDialog(Frame parent) {

super(parent, "JDBC Driver Information collector" );
Dimension screen = Toolkit.getDefaultToolkit().getScreenSize();
setBounds((screen.width - 450)/2, (screen.height - 170)/2,
450, 170);
  
  setResizable(false);
  setDefaultCloseOperation(EXIT_ON_CLOSE);
  
  addWindowListener (new WindowAdapter(){
                 public void windowClosing(WindowEvent e){
                                  setVisible(false);
                                  
             }
                      });
 
 

  ActionEventHandler handler = new ActionEventHandler();

  Container container = getContentPane();
  
  container.setLayout(null);

driver = new JLabel("Driver");
  driver.setLocation(10, 10);
driver.setSize(driver.getPreferredSize());

url = new JLabel("URL");
  url.setLocation(10, 35);
url.setSize(url.getPreferredSize());

user = new JLabel("User");
  user.setLocation(10, 65);
user.setSize(user.getPreferredSize());

password = new JLabel("Password");
  password.setLocation(10, 90);
password.setSize(password.getPreferredSize());

status = new JLabel("Not Connected: ");
  status.setLocation(10, 120);
status.setSize(status.getPreferredSize());

tdriver = new JTextField(20);
tdriver.setLocation(120, 10);
  tdriver.setSize(tdriver.getPreferredSize());
 
turl = new JTextField(20);
  turl.setLocation(120, 35);
turl.setSize(turl.getPreferredSize());

tuser = new JTextField(20);
  tuser.setLocation(120, 65);
tuser.setSize(tuser.getPreferredSize());

tpassword = new JPasswordField(20);
  tpassword.setLocation(120, 90);
tpassword.setSize(tpassword.getPreferredSize());


 connect = new JButton("Connect");
   connect.setLocation(350, 10);
 connect.setSize(connect.getPreferredSize());
 connect.addActionListener(handler);
 
 
container.add(tdriver);
container.add(turl);
container.add(tuser);
container.add(tpassword);
container.add(driver);
container.add(url);
container.add(user);
container.add(password);
container.add(status);
container.add(connect);


}

    
private class ActionEventHandler implements ActionListener {
 

// handle actions
public void actionPerformed(ActionEvent e) {
if(e.getSource() == connect) {

 String driver = tdriver.getText();
 String user = tuser.getText();
 String url = turl.getText().trim();
 String password = String.copyValueOf(tpassword.getPassword());
 
 //connection to the database
 
 try {
 Class.forName(driver);
 status.setText("Driver: " + driver + "loaded");
         status.setSize(status.getPreferredSize());
 Connection conn = DriverManager.getConnection(url, user, password);
 connect.setEnabled(false);
 status.setText("Connected To: " + " " + url);
         status.setSize(status.getPreferredSize());
         
                  
 }
 
 
 catch (Exception ex) {
 ex.printStackTrace();
 }
}



};
}
 
 
      public static void main(String args[]) 
  {
         new OptionsDialog(new JFrame()).show();       
 
        
    }
 
    
    }

// sorry the code is long...but i really need this! :>

[Jeanne Boyarsky]

I would strongly favor passing the SQL and just executing the query in one place rather than trying to pass the connection around. You don't want the connection open for longer than neccessary as it wastes resources.