connectiondialog.java

实体对象javabean的自动生成工具。用于生成数据库表单的javabean程序

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

public class ConnectionDialog extends JDialog {
	  protected JTextField useridField;
		protected JTextField passwordField;
		protected JTextField urlField;
		protected JTextField drvField;
		protected JTextField tablField;
		
		protected boolean canceled;
		protected Connection con;
		
		protected String user = "";
		protected String password = "";
		protected String url = "";
		protected String drv = "";
		protected String tablename = "";
		
		public ConnectionDialog(JFrame f){
		  super(f,"Connect To Database",true);
			buildDialogLayout();
			setSize(450,300);
		}
		
		public Connection getConnection(){
		  setVisible(true);
			return con;
		}
		
		protected void buildDialogLayout(){
		  JLabel label;
			Container pane = getContentPane();
			pane.setLayout(new GridBagLayout());
			GridBagConstraints gbc = new GridBagConstraints();
			gbc.anchor = GridBagConstraints.WEST;
			gbc.insets = new Insets(5,10,5,10);
			
			gbc.gridx = 0;
			gbc.gridy = 0;
			label = new JLabel("Userid: ",JLabel.LEFT);
			pane.add(label, gbc);
			
			gbc.gridy++;
			label = new JLabel("Password: ",JLabel.LEFT);
			pane.add(label,gbc);
			
			gbc.gridy++;
			label = new JLabel("URL: ",JLabel.LEFT);
			pane.add(label,gbc);
			
			gbc.gridy++;
			label = new JLabel("Driver: ",JLabel.LEFT);
			pane.add(label,gbc);
			
			gbc.gridy++;
			label = new JLabel("tablename: ",JLabel.LEFT);
			pane.add(label,gbc);
			
			gbc.gridx = 1;
			gbc.gridy = 0;
			
			useridField = new JTextField(20);
			pane.add(useridField,gbc);
			
			gbc.gridy++;
			passwordField = new JTextField(20);
			pane.add(passwordField,gbc);
			
			gbc.gridy++;
			urlField = new JTextField(25);
			pane.add(urlField,gbc);
			
			gbc.gridy++;
			drvField = new JTextField(25);
			pane.add(drvField,gbc);
			
			gbc.gridy++;
			tablField = new JTextField(25);
			pane.add(tablField,gbc);
			
			gbc.gridx = 0;
			gbc.gridy = 5;
			gbc.gridwidth = GridBagConstraints.REMAINDER;
			gbc.anchor = GridBagConstraints.CENTER;
			pane.add(getButtonPanel(),gbc);
			
		}
		
		
		protected JPanel getButtonPanel(){
		  JPanel panel = new JPanel();
			JButton btn = new JButton("OK");
			btn.addActionListener(new ActionListener(){
			  public void actionPerformed(ActionEvent event){
				  onDialogOK();
				}	
			}	);
			panel.add(btn);
			
			btn = new JButton("Cancel");
			btn.addActionListener(new ActionListener(){
			  public void actionPerformed(ActionEvent event){
				  onDialogCancel();
				}
			}	);
			panel.add(btn);
			return panel;
		}
		
		protected void onDialogOK(){
		  if(attemptConnection()){
			  setVisible(false);
			}
		}
		
		protected void onDialogCancel(){
		  System.exit(0);
		}
		
		protected boolean attemptConnection(){ 
		  try{
        Class.forName(drvField.getText());
			  con = DriverManager.getConnection(
				          urlField.getText(),
									useridField.getText(),
									passwordField.getText());
				return true;
			} catch(ClassNotFoundException ce){
			  JOptionPane.showMessageDialog(null,
			                              ce.getMessage(),
																	  "SQLException",
																		JOptionPane.WARNING_MESSAGE);
        //System.out.println("SQLException:"+ce.getMessage());
		    //return;
      }catch (Exception e){
			  JOptionPane.showMessageDialog(this,
				   "Error connecting to "+
					 "database: "+ e.getMessage());
			}
			return false;
		}
		
		public String getUser(){
		  user = useridField.getText();
		  return user;
	  }
		
		public String getPassword(){
		  password = passwordField.getText();
		  return password;
	  }
		
		public String getUrl(){
		  url = urlField.getText();
		  return url;
	  }
		
		public String getDrv(){
		  drv = drvField.getText();
		  return drv;
	  }
		
		public String getTablename(){
		  tablename = tablField.getText();
		  return tablename;
	  }
		
	
	}