educesql_fpg_2.java

一些平时可能用到的工具,比如导出数据,比较数据

package gongju;

import java.awt.BorderLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.FocusAdapter;
import java.awt.event.FocusEvent;
import java.awt.event.KeyAdapter;
import java.awt.event.KeyEvent;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.io.BufferedReader;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.DecimalFormat;
import java.util.Vector;

import javax.swing.ComboBoxModel;
import javax.swing.DefaultComboBoxModel;
import javax.swing.JButton;
import javax.swing.JCheckBox;
import javax.swing.JComboBox;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTextArea;
import javax.swing.JTextField;
import javax.swing.JTextPane;
import javax.swing.WindowConstants;

/**
 * This code was edited or generated using CloudGarden's Jigloo SWT/Swing GUI
 * Builder, which is free for non-commercial use. If Jigloo is being used
 * commercially (ie, by a corporation, company or business for any purpose
 * whatever) then you should purchase a license for each developer using Jigloo.
 * Please visit www.cloudgarden.com for details. Use of Jigloo implies
 * acceptance of these licensing terms. A COMMERCIAL LICENSE HAS NOT BEEN
 * PURCHASED FOR THIS MACHINE, SO JIGLOO OR THIS CODE CANNOT BE USED LEGALLY FOR
 * ANY CORPORATE OR COMMERCIAL PURPOSE.
 */
// 基本版的改版,以适合公司用
// 增加判断在客户主机上能否取到表的字段名称
public class Educesql_fpg_2 extends javax.swing.JFrame {
	private JPanel jPanel1;

	private JTextArea txtMsg;

	private JButton btnEDUCE;

	private JLabel labTABLE;

	private JTextField txtTABLE;

	//
	// private final String sql_column_name = "select distinct column_name from
	// all_tab_cols where table_name=?";
	// 防止有多个用户下的表列不同而会报出“列名无效”的错，修改为取当前用户下表的列
	private final String sql_column_name = "select distinct column_name from user_tab_cols where  table_name=?";

	private String str_table = "";

	private Vector vec_column_name;

	private StringBuffer errmsg = new StringBuffer();

	private String username;

	private String password;

	private String host;

	private String port;

	private String sid;

	private String temp_username;

	private String temp_password;

	private String temp_host;

	private String temp_port;

	private String temp_sid;

	private JLabel labHost;

	private JTextField txtHost;

	private JCheckBox chkLOCAL;

	private JComboBox cbxDB;

	private JLabel labDB;

	private JButton btnTest;

	private JScrollPane jScrollPane2;

	private JTextPane txtCondition;

	private JLabel labCondition;

	private JTextField txtPort;

	private JLabel labPort;

	private JTextField txtSid;

	private JLabel labSid;

	private JButton btnView;

	private JScrollPane jScrollPane1;

	private JTextField txtPassword;

	private JLabel labPassword;

	private JTextField txtUsername;

	private JLabel labUsername;

	private Connection con = null;

	private Connection localcon = null;

	private String before = "";

	private String after = "";

	private FileOutputStream fostream;

	private BufferedReader input;

	private String filepath;

	private String condition;

	private int checkcondition = 0;

	private boolean checkcon = true;

	private JCheckBox chkTxemp;

	private JCheckBox chkCo;

	private JPanel panTime;

	private int checkconn = 0;

	PreparedStatement ps_column = null;

	PreparedStatement local_ps_column = null;

	private Showtime showtime;

	private String txemp = "";

	// 加入数据选择
	String[] dbname = new String[] { "本地", "昆山Demo", "繁體Demo", "簡體Demo",
			"TPFNC11", "台灣基本版", "大陸基本版", "永日", "九德", "國精", "振農", "梅蘭", "振峰",
			"宏益", "剛健", "宏福", "大園", "先創", "怡球", "開源", "石安", "邦拓", "邦特测試區",
			"龍璟", "龍璟测試區", "利簾臺灣版", "利簾大陸版", "特偉","表信息", "自己"};

	/**
	 * Auto-generated main method to display this JFrame
	 */
	public static void main(String[] args) {
		Educesql_fpg_2 inst = new Educesql_fpg_2();
		inst.setVisible(true);
	}

	public Educesql_fpg_2() {
		super("Educesql_fpg_2");
		initGUI();
		Exit();
	}

	private void initGUI() {
		try {
			setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE);
			{
				jPanel1 = new JPanel();
				getContentPane().add(jPanel1, BorderLayout.CENTER);
				jPanel1.setLayout(null);
				jPanel1.setPreferredSize(new java.awt.Dimension(553, 182));
				{
					txtTABLE = new JTextField();
					jPanel1.add(txtTABLE);
					txtTABLE.setBounds(84, 49, 126, 28);
					txtTABLE.setFont(new java.awt.Font("Tahoma", 0, 20));
					txtTABLE.addKeyListener(new KeyAdapter() {
						public void keyPressed(KeyEvent evt) {
							if (evt.getKeyCode() == 10) {
								generatesql();
							}
						}
					});
				}
				{
					labTABLE = new JLabel();
					jPanel1.add(labTABLE);
					labTABLE.setText("Table");
					labTABLE.setBounds(14, 49, 63, 28);
				}
				{
					btnEDUCE = new JButton();
					jPanel1.add(btnEDUCE);
					btnEDUCE.setText("\u5bfc\u51fa");
					btnEDUCE.setBounds(224, 91, 63, 28);
					btnEDUCE.addActionListener(new ActionListener() {
						public void actionPerformed(ActionEvent evt) {
							generatesql();
						}
					});
				}
				{
					labUsername = new JLabel();
					jPanel1.add(labUsername);
					labUsername.setText("Username");
					labUsername.setBounds(14, 14, 63, 28);
				}
				{
					txtUsername = new JTextField();
					jPanel1.add(txtUsername);
					txtUsername.setBounds(84, 14, 84, 28);
					txtUsername.setFont(new java.awt.Font("Tahoma", 0, 20));
					txtUsername.setText("u1?p2");
				}
				{
					labPassword = new JLabel();
					jPanel1.add(labPassword);
					labPassword.setText("Password");
					labPassword.setBounds(182, 14, 63, 28);
				}
				{
					txtPassword = new JTextField();
					jPanel1.add(txtPassword);
					txtPassword.setBounds(245, 14, 84, 28);
					txtPassword.setFont(new java.awt.Font("Tahoma", 0, 20));
					txtPassword.setText("u1?p2");
				}
				{
					jScrollPane1 = new JScrollPane();
					jPanel1.add(jScrollPane1);
					jScrollPane1.setBounds(14, 91, 196, 35);
					{
						txtMsg = new JTextArea();
						jScrollPane1.setViewportView(txtMsg);
						txtMsg.setBounds(16, 65, 129, 32);
					}
				}
				{
					btnView = new JButton();
					jPanel1.add(btnView);
					btnView.setText("\u67e5\u770b");
					btnView.setBounds(294, 91, 63, 28);

					btnView.addActionListener(new ActionListener() {
						public void actionPerformed(ActionEvent evt) {
							// 打开生成的sql
							Runtime rt = Runtime.getRuntime();
							try {
								rt
										.exec("CMD /C"
												+ filepath.replace("//", "\\"));
								txtMsg
										.append("\n\u6253\u5f00\u6587\u4ef6\u6210\u529f");// 打开文件成功
							} catch (Exception e) {
								txtMsg
										.setText("\n\u6253\u5f00\u6587\u4ef6\u5931\u8d25");// 打开文件失败
								rt.gc();
							}
						}
					});
				}
				{
					txtHost = new JTextField();
					jPanel1.add(txtHost);
					txtHost.setBounds(420, 42, 126, 28);
					txtHost.setText("cdfn01");
					txtHost.setFont(new java.awt.Font("Tahoma", 0, 20));
				}
				{
					labHost = new JLabel();
					jPanel1.add(labHost);
					labHost.setText("HOST");
					labHost.setBounds(371, 42, 49, 28);
				}
				{
					labSid = new JLabel();
					jPanel1.add(labSid);
					labSid.setText("SID");
					labSid.setBounds(371, 98, 42, 28);
				}
				{
					txtSid = new JTextField();
					jPanel1.add(txtSid);
					txtSid.setBounds(420, 98, 126, 28);
					txtSid.setText("cdfn01");
					txtSid.setFont(new java.awt.Font("Tahoma", 0, 20));
				}
				{
					labPort = new JLabel();
					jPanel1.add(labPort);
					labPort.setText("Port");
					labPort.setBounds(371, 70, 49, 28);
				}
				{
					txtPort = new JTextField();
					jPanel1.add(txtPort);
					txtPort.setBounds(420, 70, 126, 28);
					txtPort.setText("1521");
					txtPort.setFont(new java.awt.Font("Tahoma", 0, 20));
				}
				{
					labCondition = new JLabel();
					jPanel1.add(labCondition);
					labCondition.setText("Condition");
					labCondition.setBounds(21, 133, 77, 35);
				}
				{
					jScrollPane2 = new JScrollPane();
					jPanel1.add(jScrollPane2);
					jScrollPane2.setBounds(98, 133, 301, 35);
					{
						txtCondition = new JTextPane();
						jScrollPane2.setViewportView(txtCondition);
						txtCondition.setBounds(98, 98, 266, 35);
						txtCondition.setText("只需要输入条件,前面不用加where");
						txtCondition.setFont(new java.awt.Font("宋体", 0, 18));
						// txtCondition.setFont(new
						// java.awt.Font("Tahoma",0,20));
						txtCondition.addFocusListener(new FocusAdapter() {
							public void focusGained(FocusEvent evt) {
								if (checkcondition == 0) {
									txtCondition.setText("");
									checkcondition = 1;
								}
							}
						});
					}
				}
				{
					btnTest = new JButton();
					jPanel1.add(btnTest);
					btnTest.setText("\u6d4b\u8bd5\u6570\u636e\u5e93");
					btnTest.setBounds(224, 49, 133, 28);
					btnTest.addActionListener(new ActionListener() {
						public void actionPerformed(ActionEvent evt) {
							close();
							if (Conn()) {
								txtMsg.setText("连接数据库正常!!!");
							} else {
								txtMsg.setText("连接数据库失败!!!");
							}
						}
					});
				}
				{
					panTime = new JPanel();
					BorderLayout panTimeLayout = new BorderLayout();
					jPanel1.add(panTime);
					panTime.setBounds(448, 126, 91, 42);
					panTime.setLayout(panTimeLayout);
					showtime = new Showtime();
					showtime.jTextPane1
							.setPreferredSize(new java.awt.Dimension(96, 42));
					showtime.jTextPane1.setFont(new java.awt.Font("Tahoma", 0,
							16));
					panTime.add(showtime, BorderLayout.CENTER);
				}
				{
					chkCo = new JCheckBox();
					jPanel1.add(chkCo);
					chkCo.setBounds(14, 175, 126, 21);
					chkCo.setText("\u5c06\u516c\u53f8\u66ff\u63db\u70ba'X'");
				}
				{
					chkTxemp = new JCheckBox();
					jPanel1.add(chkTxemp);
					chkTxemp