• Home
• com.scudata.esproc
• esproc
• 20240823
• source code
• DialogSQLEditor.java

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

com.scudata.ide.common.dialog.DialogSQLEditor Maven / Gradle / Ivy

package com.scudata.ide.common.dialog;

import java.awt.AWTEvent;
import java.awt.BorderLayout;
import java.awt.Color;
import java.awt.Component;
import java.awt.Dimension;
import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import java.awt.event.KeyEvent;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.ResultSet;
import java.util.Arrays;
import java.util.Collections;
import java.util.List;
import java.util.Vector;

import javax.swing.BorderFactory;
import javax.swing.DefaultComboBoxModel;
import javax.swing.DefaultListModel;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JDialog;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JProgressBar;
import javax.swing.JScrollPane;
import javax.swing.JTabbedPane;
import javax.swing.JTextPane;
import javax.swing.JWindow;
import javax.swing.ListSelectionModel;
import javax.swing.SwingUtilities;
import javax.swing.event.ChangeEvent;
import javax.swing.event.ChangeListener;
import javax.swing.event.ListSelectionEvent;
import javax.swing.event.ListSelectionListener;

import com.scudata.app.common.Section;
import com.scudata.common.ArgumentTokenizer;
import com.scudata.common.DBInfo;
import com.scudata.common.Escape;
import com.scudata.common.Logger;
import com.scudata.common.MessageManager;
import com.scudata.common.StringUtils;
import com.scudata.ide.common.DataSource;
import com.scudata.ide.common.GC;
import com.scudata.ide.common.GM;
import com.scudata.ide.common.GV;
import com.scudata.ide.common.resources.IdeCommonMessage;
import com.scudata.ide.common.swing.JComboBoxEx;
import com.scudata.ide.common.swing.JListEx;
import com.scudata.ide.common.swing.JTableEx;
import com.scudata.ide.common.swing.VFlowLayout;

/**
 * SQL?༭??
 *
 */
public class DialogSQLEditor extends JDialog {
	private static final long serialVersionUID = 1L;

	/**
	 * SELECT ?ɼ?.ѧ??ID, ?ɼ?.????, sum(?ɼ?.??ѧ), ?ɼ?.Ӣ??,ѧ????.???? FROM ?ɼ? // LEFT OUTER
	 * JOIN ѧ???? ON ?ɼ?.ѧ??ID = ѧ????.id WHERE (?ɼ?.Ӣ??>60) GROUP BY ?ɼ?.ѧ??ID HAVING
	 * sum(?ɼ?.??ѧ)>300 ORDER BY ?ɼ?.????
	 * 
	 * where???Ȱ??ո????????????ݣ? having?Ǽ?????ɲ??ҷ??????󣬰ѽ????????
	 */

	/** FROMҳ */
	public static final int TAB_FROM = 0;
	/** SELECTҳ */
	public static final int TAB_SELECT = 1;
	/** WHEREҳ */
	public static final int TAB_WHERE = 2;
	/** JOINҳ */
	public static final int TAB_JOIN = 3;
	/** GROUP BYҳ */
	public static final int TAB_GROUP = 4;
	/** HAVINGҳ */
	public static final int TAB_HAVING = 5;
	/** ORDER BYҳ */
	public static final int TAB_ORDER = 6;
	/** SQLҳ */
	public static final int TAB_SQL = 7;

	/**
	 * ????У??ֶ??У?ѡ???У?ֵ?У???????
	 */
	private static final int COL_ID = 0, COL_FIELD = 1, COL_OPT = 2,
			COL_VAL = 3, COL_CONNECT = 4;

	/**
	 * ???????仯
	 */
	private TableChanged tableChanged = new TableChanged(this);

	/**
	 * ?????б?
	 */
	private Vector codeTable = new Vector();

	/**
	 * ??????ʾֵ
	 */
	private DefaultComboBoxModel dispTable = new DefaultComboBoxModel();

	/**
	 * ?ֶ????б?
	 */
	private Vector codeFields = new Vector();
	/**
	 * ?ֶ?????ʾֵ?б?
	 */
	private DefaultListModel dispFields = new DefaultListModel();

	/**
	 * ?????????б?
	 */
	private Vector operateCodeItems = new Vector(),
			operateDispItems = new Vector();

	/**
	 * ???ӷ????б?
	 */
	private Vector connectCodeItems = new Vector(),
			connectDispItems = new Vector();

	/**
	 * SQL TAB???
	 */
	private JTabbedPane jTabbedPaneSql = new JTabbedPane();

	/**
	 * SQL?༭??
	 */
	private JTextPane jTextPaneSql = new JTextPane();

	/**
	 * ???ӱ???ť
	 */
	private JButton fromButtonRight = new JButton();
	/**
	 * ɾ??????ť
	 */
	private JButton fromButtonLeft = new JButton();

	/**
	 * ȷ?ϰ?ť
	 */
	private JButton jBOK = new JButton();
	/**
	 * ȡ????ť
	 */
	private JButton jBCancel = new JButton();

	/**
	 * ?????ֶΰ?ť
	 */
	private JButton selectButtonRight = new JButton();
	/**
	 * ɾ???ֶΰ?ť
	 */
	private JButton selectButtonLeft = new JButton();

	/**
	 * ???ӷ??鰴ť
	 */
	private JButton groupButtonRight = new JButton();
	/**
	 * ɾ?????鰴ť
	 */
	private JButton groupButtonLeft = new JButton();

	/**
	 * ????????ť
	 */
	private JButton orderButtonRight = new JButton();
	/**
	 * ɾ??????ť
	 */
	private JButton orderButtonLeft = new JButton();

	/**
	 * ?ۺϷ?ʽ?ؼ?
	 */
	private JComboBoxEx selectComboSum = new JComboBoxEx();
	/**
	 * FROM???
	 */
	private JPanel fromPanel = new JPanel();

	/**
	 * ѡ???????ؼ?
	 */
	private JComboBoxEx selectComboLeft = new JComboBoxEx();
	/**
	 * ?????????ؼ?
	 */
	private JComboBoxEx groupComboLeft = new JComboBoxEx();
	/**
	 * ?????????ؼ?
	 */
	private JComboBoxEx orderComboLeft = new JComboBoxEx();

	/**
	 * ?˳?ѡ??
	 */
	protected int m_option = JOptionPane.CLOSED_OPTION;

	/**
	 * ????????
	 */
	private JButton whereButtonAdd = new JButton();

	/**
	 * ɾ??????
	 */
	private JButton whereButtonDel = new JButton();

	/**
	 * Common??Դ??????
	 */
	private MessageManager mm = IdeCommonMessage.get();

	/**
	 * ???,?ֶ?,?????,ֵ,???ӷ?
	 */
	private final String TABLE_COLS = mm
			.getMessage("dialogsqleditor.tablecols");

	/**
	 * ????????ؼ?
	 */
	private JTableEx whereTable = new JTableEx(TABLE_COLS);

	/**
	 * ????????
	 */
	private JButton joinButtonAdd = new JButton();

	/**
	 * ɾ??????
	 */
	private JButton joinButtonDel = new JButton();

	/**
	 * ???ӱ???ؼ?
	 */
	private JTableEx joinTable = new JTableEx(TABLE_COLS);

	/**
	 * ????HAVING????
	 */
	private JButton havingButtonAdd = new JButton();
	/**
	 * ɾ??HAVING????
	 */
	private JButton havingButtonDel = new JButton();

	/**
	 * HAVING?????ؼ?
	 */
	private JTableEx havingTable = new JTableEx(TABLE_COLS);

	/**
	 * ģʽ???ؼ?
	 */
	private JComboBox jCBSchema = new JComboBox();

	/**
	 * ??ǰ?ı?
	 */
	private String currentFrom = null;

	/**
	 * ?ֶ??޸?
	 */
	private boolean bEditByHand = false;

	/**
	 * ?Ƿ??ʼ????
	 */
	private boolean afterInit = false;

	/**
	 * ????Դ????
	 */
	private DataSource ds;

	/**
	 * ??ѡFROM?б?
	 */
	private JListEx fromListLeft = new JListEx();
	/**
	 * ѡ??FROM?б?
	 */
	private JListEx fromListRight = new JListEx();
	/**
	 * ??ѡSELECT?б?
	 */
	private JListEx selectListLeft = new JListEx();
	/**
	 * ѡ??SELECT?б?
	 */
	private JListEx selectListRight = new JListEx();
	/**
	 * ??ѡ?????б?
	 */
	private JListEx groupListLeft = new JListEx();
	/**
	 * ѡ???????б?
	 */
	private JListEx groupListRight = new JListEx();
	/**
	 * ??ѡ?????б?
	 */
	private JListEx orderListLeft = new JListEx();
	/**
	 * ѡ???????б?
	 */
	private JListEx orderListRight = new JListEx();

	/**
	 * ??ѡ?ı???
	 */
	private final String AVAILABLE_TABLE = mm
			.getMessage("dialogsqleditor.availabletable");

	/**
	 * ѡ??????
	 */
	private final String SELECTED_TABLE = mm
			.getMessage("dialogsqleditor.selectedtable");

	/**
	 * ѡ???ֶ???
	 */
	private final String SELECTED_FIELD = mm
			.getMessage("dialogsqleditor.selectedfield");

	/**
	 * ??
	 */
	private final String OPT_NUL = "";
	/**
	 * ???
	 */
	private final String OPT_SUM = "SUM";
	/**
	 * ???ֵ
	 */
	private final String OPT_MAX = "MAX";

	/**
	 * ??Сֵ
	 */
	private final String OPT_MIN = "MIN";
	/**
	 * ????
	 */
	private final String OPT_COUNT = "COUNT";
	/**
	 * ƽ??ֵ
	 */
	private final String OPT_AVG = "AVG";
	/**
	 * ?Ⱥ?
	 */
	private final String OPT_EQUAL = "=";
	/**
	 * ???Ⱥ?
	 */
	private final String OPT_NOT_EQUAL = "<>";
	/**
	 * ???ں?
	 */
	private final String OPT_MORE = ">";
	/**
	 * С?ں?
	 */
	private final String OPT_LESS = "<";
	/**
	 * ????
	 */
	private final String OPT_AND = "and";
	/**
	 * ????
	 */
	private final String OPT_OR = "or";

	/**
	 * ?Ƿ???ģʽ
	 */
	private boolean isCopyMode = false;

	/**
	 * ???ȴ???
	 */
	public ProcessWindow pw;

	/**
	 * ???캯??
	 * 
	 * @param ds
	 *            ????Դ
	 */
	public DialogSQLEditor(DataSource ds) {
		super(GV.appFrame, "", false);
		this.ds = ds;
		enableEvents(AWTEvent.WINDOW_EVENT_MASK);
		try {
			selectComboLeft.x_setModel(codeTable, dispTable);
			groupComboLeft.x_setModel(codeTable, dispTable);
			orderComboLeft.x_setModel(codeTable, dispTable);

			selectListLeft.x_setModel(codeFields, dispFields);
			groupListLeft.x_setModel(codeFields, dispFields);
			orderListLeft.x_setModel(codeFields, dispFields);

			fromListLeft.x_setData(new Vector