dbjframe.java

导出ORACLE数据库对象DDL语句的程序

/*
 * 创建日期 2005-7-9
 *t
 *
 * 更改所生成文件模板为
 * 窗口 > 首选项 > Java > 代码生成 > 代码和注释
 */
package com.icbc.db;

import javax.swing.*;

import com.icbc.core.TLException;
import com.icbc.util.*;

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.util.Hashtable;
import java.util.Vector;


/**
 * @author bs
 *
 * 更改所生成类型注释的模板为
 * 窗口 > 首选项 > Java > 代码生成 > 代码和注释
 */
public class DBJFrame extends JFrame {
	private static DBJFrame frame ;
	private JTextArea out;
	private JPanel panel1,panel2;
	private JLabel db1UrlLabel,db1UserLabel,db1PwdLabel,db2UrlLabel,db2UserLabel,
			db2PwdLabel,db3UrlLabel,db3UserLabel,db3PwdLabel,titleLabel,chooseLabel,chooseOwnerLabel;
	private Font font;
	private Icon icon;
	private JTextField db1UrlTextField,db1UserTextField,db2UrlTextField,
			db2UserTextField,db3UrlTextField,db3UserTextField;
	private JPasswordField db1PwdField,db2PwdField,db3PwdField;
	private JButton db1ConnBtn,db2ConnBtn,db3ConnBtn,compBtn;
	private JScrollPane scrollPane;
	private String drive="oracle.jdbc.driver.OracleDriver";
	private Context context;
	private String sql;
	private static DAO srcDao=null,desDao=null,storageDao=null;
	private static Connection srcCon=null,desCon=null,storageCon=null;
	private JCheckBox tableCheckBox,tabColumnCheckBox,indexCheckBox;
	private String scope="*";
	private JComboBox db1Owner,db2Owner;
	private String[] OWNERS1,OWNERS2;
	
	public static void main(String args[]) {
		frame= new DBJFrame();
		frame.setBounds(100, 100, 700, 500);
		//frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		frame.addWindowListener(new WindowAdapter()
		{
			public void windowClosing(WindowEvent e)
			{
				if(srcCon!=null)
					srcDao.releaseConnection(srcCon);
				if(desCon!=null)
					desDao.releaseConnection(desCon);
				if(storageCon!=null)
					storageDao.releaseConnection(storageCon);
				System.exit(0);
				
				
			}
		});
		frame.show();
	}
	public DBJFrame() {
		super();
		getContentPane().setLayout(null);
		
		panel1 = new JPanel();
		panel1.setBounds(0, 0, 592, 10);
		getContentPane().add(panel1);
		
		titleLabel = new JLabel();
		titleLabel.setHorizontalAlignment(SwingConstants.CENTER);
		titleLabel.setHorizontalTextPosition(SwingConstants.CENTER);
		titleLabel.setBounds(255, 35, 125, 30);
		getContentPane().add(titleLabel);
		font=new Font("Serif",Font.BOLD|Font.ITALIC,20);
		titleLabel.setFont(font);
		titleLabel.setText("DBTOOL");
		
		db1UrlLabel = new JLabel();
		db1UrlLabel.setBounds(5, 95, 120, 15);
		getContentPane().add(db1UrlLabel);
		db1UrlLabel.setText("请输入源数据库url");
	    //icon=new ImageIcon("image/connect.jpg");
			
		db1UrlTextField = new JTextField();
		db1UrlTextField.setBounds(120, 90, 150, 25);
		getContentPane().add(db1UrlTextField);
		
		db1UserLabel = new JLabel();
		db1UserLabel.setBounds(285, 95, 80, 15);
		getContentPane().add(db1UserLabel);
		db1UserLabel.setText("请输入用户名");
		
		db1UserTextField = new JTextField();
		db1UserTextField.setBounds(375, 90, 75, 25);
		getContentPane().add(db1UserTextField);
		
		db1PwdLabel = new JLabel();
		db1PwdLabel.setBounds(455, 95, 80, 15);
		getContentPane().add(db1PwdLabel);
		db1PwdLabel.setText("请输入密码");
		
		db1PwdField = new JPasswordField();
		db1PwdField.setBounds(525, 90, 75, 25);
		getContentPane().add(db1PwdField);
		
		db1ConnBtn = new JButton(icon);
		db1ConnBtn.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
					
					
				if(db1UrlTextField.getText().length()==0||db1UserTextField.getText().length()==0||db1PwdField.getText().length()==0)
				{
					alert();
					
					return;
				}
				showOutPut("连接源数据库参数：Url:"+db1UrlTextField.getText()+"  userName:"+db1UserTextField.getText()+"  password:"+db1PwdField.getText());
				db1connect(db1UrlTextField.getText(),db1UserTextField.getText(),db1PwdField.getText(),drive);
				for(int index=0;index<OWNERS1.length;index++)
					db1Owner.addItem(OWNERS1[index]);
					
			}
		});
		db1ConnBtn.setBounds(615, 90, 60, 25);
		getContentPane().add(db1ConnBtn);
		db1ConnBtn.setText("连接");
		
		scrollPane = new JScrollPane();
		scrollPane.setBounds(0, 370, 690, 100);
		getContentPane().add(scrollPane);
		out = new JTextArea();
		out.setBackground(new Color(243, 243, 243));
		scrollPane.setViewportView(out);
			
		db2UrlLabel = new JLabel();
		db2UrlLabel.setBounds(5, 130, 120, 20);
		getContentPane().add(db2UrlLabel);
		db2UrlLabel.setText("请输入目的数据库url");
			
		db2UrlTextField = new JTextField();
		db2UrlTextField.setBounds(120, 130, 150, 25);
		getContentPane().add(db2UrlTextField);
		
		db2UserLabel = new JLabel();
		db2UserLabel.setBounds(285, 135, 80, 15);
		getContentPane().add(db2UserLabel);
		db2UserLabel.setText("请输入用户名");
		
		db2UserTextField = new JTextField();
		db2UserTextField.setBounds(375, 130, 75, 25);
		getContentPane().add(db2UserTextField);
		
		db2PwdLabel = new JLabel();
		db2PwdLabel.setBounds(455, 135, 75, 15);
		getContentPane().add(db2PwdLabel);
		db2PwdLabel.setText("请输入密码");
		
		db2PwdField = new JPasswordField();
		db2PwdField.setBounds(525, 130, 75, 25);
		getContentPane().add(db2PwdField);
			
		db2ConnBtn = new JButton(icon);
		db2ConnBtn.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
					
				if(db2UrlTextField.getText().length()==0||db2UserTextField.getText().length()==0||db2PwdField.getText().length()==0)
				{
					alert();
					return;
				}
				
				showOutPut("连接目的数据库参数：Url:"+db2UrlTextField.getText()+"  userName:"+db2UserTextField.getText()+"  password:"+db2PwdField.getText());
				db2connect(db2UrlTextField.getText(),db2UserTextField.getText(),db2PwdField.getText(),drive);

				for(int index=0;index<OWNERS2.length;index++)
					db2Owner.addItem(OWNERS2[index]);
					
			}
		});
		db2ConnBtn.setBounds(615, 130, 60, 25);
		getContentPane().add(db2ConnBtn);
		db2ConnBtn.setText("连接");
			
		db3UrlLabel = new JLabel();
		db3UrlLabel.setBounds(5, 175, 120, 15);
		getContentPane().add(db3UrlLabel);
		db3UrlLabel.setText("请输入存储数据库url");
		
		db3UrlTextField = new JTextField();
		db3UrlTextField.setBounds(120, 170, 150, 25);
		getContentPane().add(db3UrlTextField);
		
		db3UserLabel = new JLabel();
		db3UserLabel.setBounds(285, 170, 85, 20);
		getContentPane().add(db3UserLabel);
		db3UserLabel.setText("请输入用户名");
		
		db3UserTextField = new JTextField();
		db3UserTextField.setBounds(375, 170, 75, 25);
		getContentPane().add(db3UserTextField);
			
		db3PwdLabel = new JLabel();
		db3PwdLabel.setBounds(455, 170, 70, 20);
		getContentPane().add(db3PwdLabel);
		db3PwdLabel.setText("请输入密码");
		
		db3PwdField = new JPasswordField();
		db3PwdField.setBounds(525, 170, 75, 25);
		getContentPane().add(db3PwdField);
		
		db3ConnBtn = new JButton();
		db3ConnBtn.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
		
				if(db3UrlTextField.getText().length()==0||db3UserTextField.getText().length()==0||db3PwdField.getText().length()==0)
				{
					alert();
					return;
				}
				showOutPut("连接存储数据库参数：Url:"+db3UrlTextField.getText()+"  userName:"+db3UserTextField.getText()+"  password:"+db3PwdField.getText());
				db3connect(db3UrlTextField.getText(),db3UserTextField.getText(),db3PwdField.getText(),drive);
				
				if(srcCon!=null&&desCon!=null&&storageCon!=null)
				{
					if(db1Owner.getSelectedItem()!=null&&db2Owner.getSelectedItem()!=null)
						compBtn.setEnabled(true);	
				}
					
			}
		});
		
		db3ConnBtn.setBounds(615, 170, 60, 25);
		getContentPane().add(db3ConnBtn);
		db3ConnBtn.setText("连接");
		
		db3ConnBtn.setBounds(615, 170, 60, 25);
		getContentPane().add(db3ConnBtn);
		db3ConnBtn.setText("连接");
		
		chooseLabel = new JLabel();
		chooseLabel.setBounds(5, 265, 120, 25);
		getContentPane().add(chooseLabel);
		chooseLabel.setText("请选择比较范围");
		
		tableCheckBox=new JCheckBox("TABLE");
		tableCheckBox.setBounds(120,295,100,25);
		tableCheckBox.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e) {
				
				if(tableCheckBox.isSelected())
				{
					tabColumnCheckBox.setEnabled(true);
					indexCheckBox.setEnabled(true);
					scope="";
					ParseScope("1",tableCheckBox.getText());
					if(tabColumnCheckBox.isSelected())