easylov.java

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

package gongju;

import java.awt.BorderLayout;
import java.awt.Toolkit;
import java.awt.datatransfer.Clipboard;
import java.awt.datatransfer.StringSelection;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.text.SimpleDateFormat;
import java.util.GregorianCalendar;

import javax.swing.JButton;
import javax.swing.JCheckBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
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.
 */
// 方便进行LOV添加
public class EasyLov extends JFrame {
	private JPanel jPanel1;

	private JTextField txtColnm;

	private JLabel labSearchCol;

	private JCheckBox chkL;

	private JCheckBox chkBLOCK_B;

	private JCheckBox chkQUERY;

	private JButton btnCopy;

	private JTextPane txtLov;

	private JScrollPane jScrollPane2;

	private JButton btnOk;

	private JTextField txtComp;

	private JLabel labComp;

	private JTextField txtsDbAuto;

	private JLabel labsDbAuto;

	private JTextField txtDisplay;

	private JLabel labDispCol;

	private JTextField txtSearchCol;

	private JScrollPane jScrollPane1;

	private JTextPane txtSql;

	private JLabel labSql;

	private JLabel labName;

	public EasyLov() {
		super("EasyLov");
		initGUI();
	}

	private void initGUI() {
		try {
			this.setDefaultCloseOperation(DISPOSE_ON_CLOSE);
			setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE);
			{
				jPanel1 = new JPanel();
				getContentPane().add(jPanel1, BorderLayout.CENTER);
				jPanel1.setLayout(null);
				{
					labName = new JLabel();
					jPanel1.add(labName);
					labName.setText("Colnm");
					labName.setBounds(7, 7, 63, 28);
				}
				{
					txtColnm = new JTextField();
					jPanel1.add(txtColnm);
					txtColnm.setBounds(77, 7, 116, 28);
				}
				{
					labSql = new JLabel();
					jPanel1.add(labSql);
					labSql.setText("SQL");
					labSql.setBounds(7, 49, 63, 28);
				}
				{
					jScrollPane1 = new JScrollPane();
					jPanel1.add(jScrollPane1);
					jScrollPane1.setBounds(77, 49, 455, 56);
					{
						txtSql = new JTextPane();
						jScrollPane1.setViewportView(txtSql);
						txtSql.setBounds(217, 168, 196, 35);
					}
				}
				{
					labSearchCol = new JLabel();
					jPanel1.add(labSearchCol);
					labSearchCol.setText("SearchCol");
					labSearchCol.setBounds(7, 119, 63, 28);
				}
				{
					txtSearchCol = new JTextField();
					jPanel1.add(txtSearchCol);
					txtSearchCol.setBounds(77, 119, 455, 28);
				}
				{
					labDispCol = new JLabel();
					jPanel1.add(labDispCol);
					labDispCol.setText("DispCol");
					labDispCol.setBounds(7, 161, 63, 28);
				}
				{
					txtDisplay = new JTextField();
					jPanel1.add(txtDisplay);
					txtDisplay.setBounds(77, 161, 455, 28);
				}
				{
					labsDbAuto = new JLabel();
					jPanel1.add(labsDbAuto);
					labsDbAuto.setText("DbAuto");
					labsDbAuto.setBounds(7, 203, 63, 28);
				}
				{
					txtsDbAuto = new JTextField();
					jPanel1.add(txtsDbAuto);
					txtsDbAuto.setBounds(77, 203, 455, 28);
				}
				{
					labComp = new JLabel();
					jPanel1.add(labComp);
					labComp.setText("Comp");
					labComp.setBounds(7, 245, 63, 28);
				}
				{
					txtComp = new JTextField();
					jPanel1.add(txtComp);
					txtComp.setBounds(77, 245, 455, 28);
				}
				{
					btnOk = new JButton();
					jPanel1.add(btnOk);
					btnOk.setText("\u751f\u6210");
					btnOk.setBounds(399, 7, 63, 28);
					btnOk.addActionListener(new ActionListener() {
						public void actionPerformed(ActionEvent evt) {
							if (chkL.isSelected()) {
								toLov_L();
							} else {
								if (chkQUERY.isSelected()) {
									toLov1();
								} else {
									toLov();
								}
							}
						}
					});
				}
			}
			{
				jScrollPane2 = new JScrollPane();
				jPanel1.add(jScrollPane2);
				jScrollPane2.setBounds(21, 294, 504, 133);
				{
					txtLov = new JTextPane();
					jScrollPane2.setViewportView(txtLov);
				}
			}
			{
				btnCopy = new JButton();
				jPanel1.add(btnCopy);
				btnCopy.setText("\u590d\u5236");
				btnCopy.setBounds(468, 7, 64, 28);
				btnCopy.addActionListener(new ActionListener() {
					public void actionPerformed(ActionEvent evt) {
						Copy();
					}
				});
			}
			{
				chkQUERY = new JCheckBox();
				jPanel1.add(chkQUERY);
				chkQUERY.setText("QUERY");
				chkQUERY.setBounds(249, 7, 67, 28);
			}
			{
				chkBLOCK_B = new JCheckBox();
				jPanel1.add(chkBLOCK_B);
				chkBLOCK_B.setText("BLOCK_B");
				chkBLOCK_B.setBounds(319, 7, 81, 28);
			}
			{
				chkL = new JCheckBox();
				jPanel1.add(chkL);
				chkL.setText("L\u6863");
				chkL.setBounds(200, 10, 49, 23);
			}
			{
				setSize(547, 490);
				setVisible(true);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}

	}

	public static void main(String args[]) {
		new EasyLov();
		// a.setVisible(true);
	}

	private void Copy() {

		Clipboard clipboard = Toolkit.getDefaultToolkit().getSystemClipboard();// ?锟給锟絫?锟脚