com.scudata.ide.common.dialog.DialogDataSourcePara Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of esproc Show documentation
Show all versions of esproc Show documentation
SPL(Structured Process Language) A programming language specially for structured data computing.
package com.scudata.ide.common.dialog;
import java.awt.BorderLayout;
import java.awt.Color;
import java.awt.Dimension;
import java.awt.FlowLayout;
import java.awt.GridBagLayout;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.FocusEvent;
import java.awt.event.ItemEvent;
import java.awt.event.WindowEvent;
import java.sql.Driver;
import java.sql.DriverPropertyInfo;
import java.util.Properties;
import java.util.StringTokenizer;
import java.util.Vector;
import javax.swing.BorderFactory;
import javax.swing.DefaultCellEditor;
import javax.swing.JButton;
import javax.swing.JCheckBox;
import javax.swing.JComboBox;
import javax.swing.JDialog;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JPasswordField;
import javax.swing.JScrollPane;
import javax.swing.JSpinner;
import javax.swing.JTabbedPane;
import javax.swing.JTextField;
import javax.swing.SpinnerNumberModel;
import javax.swing.event.ChangeEvent;
import javax.swing.table.TableCellEditor;
import javax.swing.table.TableCellRenderer;
import javax.swing.table.TableColumn;
import com.scudata.common.DBConfig;
import com.scudata.common.MessageManager;
import com.scudata.common.StringUtils;
import com.scudata.ide.common.DBTypeEx;
import com.scudata.ide.common.DataSource;
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.CheckBoxRenderer;
import com.scudata.ide.common.swing.JTableEx;
import com.scudata.ide.common.swing.VFlowLayout;
/**
* ???ݿ????Ӷ???Ի???
*
* ???ܣ??ṩ????????????һ?????ݿ?????
*/
public class DialogDataSourcePara extends JDialog {
private static final long serialVersionUID = 1L;
/**
* Common??Դ??????
*/
private MessageManager mm = IdeCommonMessage.get();
/** ????? */
private final byte COL_INDEX = 0;
/** ?????? */
private final byte COL_NAME = 1;
/** ֵ?? */
private final byte COL_VALUE = 2;
/** ?Ƿ?????? */
private final byte COL_ISNEED = 3;
/**
* ??չ???Ա?
*/
private JTableEx tableExtend = new JTableEx(
mm.getMessage("dialogdatasourcepara.colnames"));
/**
* ?????ı???
*/
private JTextField jTextName = new JTextField();
/**
* ????????
*/
private JLabel jLabel7 = new JLabel("????????");
/**
* ????Դ????
*/
private JLabel jLabel1 = new JLabel("????Դ????");
/**
* ????ԴURL??ע???滻?????е?????
*/
private JLabel jLabel3 = new JLabel("????ԴURL??ע???滻?????е?????");
/**
* ?û?
*/
private JLabel jLabel4 = new JLabel("?û?");
/**
* ????
*/
private JLabel jLabel5 = new JLabel("????");
/**
* ȷ?ϰ?ť
*/
private JButton jBOK = new JButton("ȷ??");
/**
* ȡ????ť
*/
private JButton jBCancel = new JButton("ȡ??");
/**
* ɾ????ť
*/
private JButton jBDel = new JButton();
/**
* ???Ӱ?ť
*/
private JButton jBAdd = new JButton();
/**
* ?????????ؼ?
*/
private JComboBox jComboBoxDriver = new JComboBox();
/**
* ???ݿ??????????
*/
private JComboBox jDBTitles = new JComboBox();
/**
* URL??????
*/
private JComboBox jComboBoxURL = new JComboBox();
/**
* ?û????ı???
*/
private JTextField jTextUser = new JTextField();
/**
* ?????
*/
private JPasswordField jPassword = new JPasswordField();
/**
* ?˳???ѡ??
*/
private int m_option = JOptionPane.CANCEL_OPTION;
/**
* ????TAB???
*/
private JTabbedPane jTabbedPaneAttr = new JTabbedPane();
/**
* ????ǰ?Ƿ????ģʽ??
*/
private JCheckBox jCBUseSchema = new JCheckBox();
/**
* ????Դ????
*/
private JLabel jLabel6 = new JLabel();
/**
* ???????Ƿ??????
*/
private JCheckBox jCBIsAddTilde = new JCheckBox();
/**
* ??չ???Դ?
*/
private String extend;
/**
* ??????
*/
private String oldName = "";
/**
* ????ȡ????????
*/
private JSpinner jSBatchSize = new JSpinner(new SpinnerNumberModel(0, 0,
Integer.MAX_VALUE, 1));
/**
* ?Ѵ??ڵ?????
*/
private Vector existNames;
private static final int TAB_EXTEND = 1;
/**
* ???캯??
*/
public DialogDataSourcePara() {
super(GV.appFrame, "????Դ", true);
String[] dbTitles = DBTypeEx.listDBTitles();
for (int i = 0; i < dbTitles.length; i++) {
jDBTitles.addItem(dbTitles[i]);
}
jDBTitle_itemStateChanged(null);
initUI();
init();
resetLangText();
if (GM.isChineseLanguage()) {
setSize(600, 420);
} else {
setSize(650, 420);
}
GM.setDialogDefaultButton(this, jBOK, jBCancel);
}
/**
* ??ʼ??
*/
private void init() {
TableColumn tc = tableExtend.getColumn(COL_ISNEED);
JCheckBox checkBoxEditor = new JCheckBox();
checkBoxEditor.setEnabled(false);
checkBoxEditor.setBackground(Color.lightGray);
checkBoxEditor.setHorizontalAlignment(JLabel.CENTER);
TableCellEditor cellEditor = new DefaultCellEditor(checkBoxEditor);
TableCellRenderer cellRenderer = new CheckBoxRenderer();
tc.setCellEditor(cellEditor);
tc.setCellRenderer(cellRenderer);
tableExtend.setIndexCol(COL_INDEX);
}
/**
* ??????????Դ
*/
private void resetLangText() {
this.setTitle(mm.getMessage("dialogdatasourcepara.title"));
jLabel7.setText(mm.getMessage("dialogdatasourcepara.engine"));
jLabel1.setText(mm.getMessage("dialogdatasourcepara.datasrcname"));
jLabel3.setText(mm.getMessage("dialogdatasourcepara.datasrcurl"));
jLabel4.setText(mm.getMessage("dialogdatasourcepara.user"));
jLabel5.setText(mm.getMessage("dialogdatasourcepara.pw"));
jBOK.setActionCommand(mm.getMessage("public.ok"));
jBOK.setText(mm.getMessage("button.ok"));
jBCancel.setText(mm.getMessage("button.cancel"));
jBDel.setText(mm.getMessage("button.delete"));
jBAdd.setText(mm.getMessage("button.add"));
jCBUseSchema.setText(mm.getMessage("dialogdatasourcepara.useschema"));
jLabel6.setText(mm.getMessage("dialogdatasourcepara.datasettype"));
jTabbedPaneAttr.setTitleAt(0,
mm.getMessage("dialogdatasourcepara.general"));
jTabbedPaneAttr.setTitleAt(1,
mm.getMessage("dialogdatasourcepara.extend"));
jCBIsAddTilde.setText(mm.getMessage("dialogdatasourcepara.isaddtilde"));
}
/**
* ??ʼ???ؼ?
*/
private void initUI() {
setModal(true);
this.getContentPane().setLayout(new BorderLayout());
jBOK.setDebugGraphicsOptions(0);
jBOK.setActionCommand("ȷ??");
jBOK.setMnemonic('O');
jBOK.setText("ȷ??(O)");
jBOK.addActionListener(new DialogDataSourcePara_jBOK_actionAdapter(this));
jBCancel.setMnemonic('C');
jBCancel.setText("ȡ??(C)");
jBCancel.addActionListener(new DialogDataSourcePara_jBCancel_actionAdapter(
this));
jDBTitles
.addItemListener(new DialogDataSourcePara_jDBTitle_itemAdapter(
this));
jComboBoxURL.setPreferredSize(new Dimension(387, 25));
jComboBoxURL.setEditable(true);
jComboBoxDriver.setPreferredSize(new Dimension(387, 25));
jComboBoxDriver.setEditable(true);
JPanel jPanel3 = new JPanel(new GridBagLayout());
JPanel jPanelCB = new JPanel();
JPanel jPanelCB2 = new JPanel();
jPanelCB.setLayout(new FlowLayout(FlowLayout.LEFT));
jPanelCB2.setLayout(new GridLayout(1, 2));
JPanel jPanelOKCancel = new JPanel(new VFlowLayout());
JScrollPane jScrollPane1 = new JScrollPane();
jScrollPane1.setViewportBorder(null);
jScrollPane1.setAlignmentX((float) 5.0);
jScrollPane1.setBorder(BorderFactory.createEtchedBorder());
jScrollPane1.setPreferredSize(new Dimension(40, 40));
jScrollPane1.setVerifyInputWhenFocusTarget(true);
JPanel jPanelExtend = new JPanel(new BorderLayout());
jBDel.setMnemonic('D');
jBDel.setText("ɾ??(D)");
jBDel.addActionListener(new DialogDataSourcePara_jBDel_actionAdapter(
this));
jBAdd.setMnemonic('A');
jBAdd.setText("????(A)");
jBAdd.addActionListener(new DialogDataSourcePara_jBAdd_actionAdapter(
this));
JPanel jPanel4 = new JPanel(new VFlowLayout());
jTabbedPaneAttr
.addChangeListener(new DialogDataSourcePara_jTabbedPaneAttr_changeAdapter(
this));
jCBUseSchema.setText("ʹ?ô?ģʽ?ı?????");
jLabel6.setText("???ݿ?????");
JPanel jPanel1 = new JPanel();
GridLayout gridLayout3 = new GridLayout();
gridLayout3.setColumns(2);
gridLayout3.setHgap(5);
gridLayout3.setRows(2);
jPanel1.setLayout(gridLayout3);
jCBIsAddTilde.setText("ʹ?ô????ŵ?SQL");
JPanel jPanelGeneral = new JPanel();
jPanelGeneral.add(jPanel1, null);
jPanel1.add(jLabel1, null);
jPanel1.add(jLabel6, null);
jPanel1.add(jTextName, null);
jPanel1.add(jDBTitles, null);
jPanelGeneral.add(jLabel7);
jPanelGeneral.add(jComboBoxDriver);
jPanelGeneral.add(jLabel3, null);
jPanelGeneral.add(jComboBoxURL, null);
jPanelGeneral.add(jPanel3, null);
jPanelGeneral.add(jPanelCB, null);
JPanel panelBatchSize = new JPanel(new BorderLayout());
panelBatchSize.add(
new JLabel(mm.getMessage("dialogdatasourcepara.batchsize")),
BorderLayout.WEST);
panelBatchSize.add(jSBatchSize, BorderLayout.CENTER);
jPanelGeneral.add(panelBatchSize, null);
jPanelGeneral.add(jPanelCB2, null);
jPanel3.add(jLabel4, GM.getGBC(1, 1, true, false, 0));
jPanel3.add(jLabel5, GM.getGBC(1, 2, true, false, 0));
jPanel3.add(jTextUser, GM.getGBC(2, 1, true, false, 0));
jPanel3.add(jPassword, GM.getGBC(2, 2, true, false, 0));
jPanelCB2.add(jCBUseSchema, null);
jPanelCB2.add(jCBIsAddTilde, null);
this.getContentPane().add(jPanelOKCancel, BorderLayout.EAST);
jPanelGeneral.setLayout(new VFlowLayout());
jPanelOKCancel.add(jBOK, null);
jPanelOKCancel.add(jBCancel, null);
this.getContentPane().add(jTabbedPaneAttr, BorderLayout.CENTER);
jTabbedPaneAttr.add(jPanelGeneral, " ???????? ");
jTabbedPaneAttr.add(jPanelExtend, " ??չ???? ");
jPanelExtend.add(jScrollPane1, BorderLayout.CENTER);
jScrollPane1.getViewport().add(tableExtend, null);
jPanelExtend.add(jPanel4, BorderLayout.EAST);
jPanel4.add(jBAdd, null);
jPanel4.add(jBDel, null);
if (GM.isChineseLanguage()) {
tableExtend.getColumn(COL_ISNEED).setMaxWidth(70);
}
// else {
// tableExtend.getColumn(COL_ISNEED).setMaxWidth(140);
// }
tableExtend.getColumn(COL_NAME).setPreferredWidth(70);
this.setResizable(true);
this.addWindowListener(new DialogDataSourcePara_WindowAdapter(this));
}
/**
* ????????Դ
*
* @param ds
*/
public void set(DBConfig ds) {
if (!DialogDataSource.isLocalDataSource(new DataSource(ds), false)) {
jBOK.setEnabled(false);
}
oldName = ds.getName();
jTextName.setText(ds.getName());
String dbVender = DBTypeEx.getDBTypeName(ds.getDBType());
jDBTitles.setSelectedItem(dbVender);
jDBTitle_itemStateChanged(null);
jComboBoxDriver.setSelectedItem(ds.getDriver());
jComboBoxURL.setSelectedItem(ds.getUrl());
jTextUser.setText(ds.getUser());
String pwd = ds.getPassword();
try {
jPassword.setText(pwd); // PwdUtils.decrypt(pwd)
} catch (Exception x) {
}
jCBUseSchema.setSelected(ds.isUseSchema());
jCBIsAddTilde.setSelected(ds.isAddTilde());
extend = ds.getExtend();
tableExtend.setIndexCol(COL_INDEX);
jSBatchSize.setValue(new Integer(ds.getBatchSize()));
}
/**
* ?????Ѿ????ڵ?????
*
* @param existNames
*/
public void setExistNames(Vector existNames) {
this.existNames = existNames;
}
/**
* ?????Ƿ?仯
*
* @return
*/
public boolean isNameChanged() {
return !jTextName.getText().equalsIgnoreCase(oldName);
}
/**
* ȡ????Դ
*
* @return
*/
public DataSource get() {
DBConfig config = new DBConfig();
config.setName(jTextName.getText());
config.setDriver(((String) jComboBoxDriver.getSelectedItem()).trim());
config.setUrl(((String) jComboBoxURL.getSelectedItem()).trim());
config.setUser(jTextUser.getText());
String pwd = new String(jPassword.getPassword());
config.setPassword(pwd); // PwdUtils.encrypt(pwd)
config.setUseSchema(jCBUseSchema.isSelected());
config.setAddTilde(jCBIsAddTilde.isSelected());
config.setBatchSize(((Number) jSBatchSize.getValue()).intValue());
tableExtend.acceptText();
StringBuffer sb = new StringBuffer();
Properties porps = new Properties();
for (int i = 0; i < tableExtend.getRowCount(); i++) {
Object key = tableExtend.data.getValueAt(i, COL_NAME);
if (!StringUtils.isValidString(key)) {
continue;
}
Object val = tableExtend.data.getValueAt(i, COL_VALUE);
if (!StringUtils.isValidString(val)) {
continue;
}
porps.put((String) key, (String) val);
sb.append(";" + key + "=" + val);
}
config.setInfo(porps);
if (sb.length() > 1) {
config.setExtend(sb.substring(1));
} else {
config.setExtend("");
}
String dbTitle = (String) jDBTitles.getSelectedItem();
DataSource ds = new DataSource(config);
config.setDBType(DBTypeEx.getDBType(dbTitle));
return ds;
}
/**
* ???ڹر??¼?
*
* @param e
*/
void this_windowClosing(WindowEvent e) {
GM.setWindowDimension(this);
dispose();
}
/**
* ѡ??????¼?
*
* @param e
*/
void jDBTitle_itemStateChanged(ItemEvent e) {
Object tmpVal;
String dbTitle = (String) jDBTitles.getSelectedItem();
String[] tmpListVal;
tmpListVal = DBTypeEx.getDBSampleDriver(dbTitle);
tmpVal = jComboBoxDriver.getSelectedItem();
jComboBoxDriver.removeAllItems();
for (int k = 0; k < tmpListVal.length; k++) {
jComboBoxDriver.addItem(tmpListVal[k]);
}
jComboBoxDriver.setSelectedItem(tmpVal);
tmpListVal = DBTypeEx.getDBSampleURL(dbTitle);
tmpVal = jComboBoxURL.getSelectedItem();
jComboBoxURL.removeAllItems();
for (int k = 0; k < tmpListVal.length; k++) {
jComboBoxURL.addItem(tmpListVal[k]);
}
jComboBoxURL.setSelectedItem(tmpVal);
}
/**
* ȷ?ϰ?ť?¼?
*
* @param e
*/
void jBOK_actionPerformed(ActionEvent e) {
try {
if (!StringUtils.isValidString(jTextName.getText())) {
throw new Exception(
mm.getMessage("dialogdatasourcepara.emptydsname"));
}
if (!StringUtils.isValidString(jComboBoxURL.getSelectedItem())) {
throw new Exception(
mm.getMessage("dialogdatasourcepara.emptyurl"));
}
if (!StringUtils.isValidString(jComboBoxDriver.getSelectedItem())) {
throw new Exception(
mm.getMessage("dialogdatasourcepara.emptyengine"));
}
if (existNames != null) {
if (existNames.contains(jTextName.getText())) {
GM.messageDialog(GV.appFrame,
mm.getMessage("dialogdatasource.existdsname")
+ jTextName.getText(),
mm.getMessage("public.note"),
JOptionPane.ERROR_MESSAGE);
return;
}
} else if (isNameChanged() && GM.isExistDataSource(get())) {
return;
}
m_option = JOptionPane.OK_OPTION;
GM.setWindowDimension(this);
dispose();
} catch (Exception ex) {
GM.showException(ex);
}
}
/**
* ȡ????ť?¼?
*
* @param e
*/
void jBCancel_actionPerformed(ActionEvent e) {
GM.setWindowDimension(this);
m_option = JOptionPane.CANCEL_OPTION;
dispose();
}
/**
* ȡ?˳?ѡ??
*
* @return
*/
public int getOption() {
return m_option;
}
/**
* ѡ???TAB?????仯
*
* @param e
*/
void jTabbedPaneAttr_stateChanged(ChangeEvent e) {
try {
int newIndex = jTabbedPaneAttr.getSelectedIndex();
if (newIndex != TAB_EXTEND)
return;
tableExtend.removeAllRows();
tableExtend.clearSelection();
tableExtend.acceptText();
if (!StringUtils.isValidString(jComboBoxDriver.getSelectedItem())) {
return;
}
String driver = (String) jComboBoxDriver.getSelectedItem();
if (!StringUtils.isValidString(jComboBoxURL.getSelectedItem())) {
return;
}
String url = (String) jComboBoxURL.getSelectedItem();
Driver d = (Driver) Class.forName(driver).newInstance();
DriverPropertyInfo[] dpi = d.getPropertyInfo(url, new Properties());
// boolean isDL = driver.startsWith("com.datalogic");
// tableExtend.data.setRowCount(isDL ? dpi.length : dpi.length - 2);
// tableExtend.resetIndex();
for (int i = 0; i < dpi.length; i++) {
if (dpi[i].name.equalsIgnoreCase("user")) {
continue;
}
if (dpi[i].name.equalsIgnoreCase("password")) {
continue;
}
int row = tableExtend.addRow(false);
tableExtend.data.setValueAt(dpi[i].name, row, COL_NAME);
tableExtend.data.setValueAt(new Boolean(dpi[i].required), row,
COL_ISNEED);
}
tableExtend.resetIndex();
String tmpSeg, key, val;
tmpSeg = extend;
if (!StringUtils.isValidString(tmpSeg)) {
tmpSeg = "";
}
StringTokenizer st = new StringTokenizer(tmpSeg, ";");
int index;
int r;
while (st.hasMoreTokens()) {
tmpSeg = st.nextToken();
index = tmpSeg.indexOf("=");
key = tmpSeg.substring(0, index);
val = tmpSeg.substring(index + 1);
r = tableExtend.searchName(key, COL_NAME, false);
if (r == -1) {
r = tableExtend.addRow();
tableExtend.data.setValueAt(key, r, COL_NAME);
tableExtend.data.setValueAt(val, r, COL_VALUE);
} else {
tableExtend.data.setValueAt(val, r, COL_VALUE);
}
}
} catch (Exception t) {
GM.showException(t);
}
}
/**
* ??չ???Ա?ʧȥ?????
*
* @param e
*/
void tableExtend_focusLost(FocusEvent e) {
tableExtend.acceptText();
}
/**
* ???Ӱ?ť?¼?
*
* @param e
*/
void jBAdd_actionPerformed(ActionEvent e) {
int r = tableExtend.addRow();
tableExtend.data.setValueAt(Boolean.FALSE, r, COL_ISNEED);
}
/**
* ɾ????ť?¼?
*
* @param e
*/
void jBDel_actionPerformed(ActionEvent e) {
tableExtend.acceptText();
tableExtend.deleteSelectedRows();
}
}
class DialogDataSourcePara_WindowAdapter extends java.awt.event.WindowAdapter {
DialogDataSourcePara adaptee;
DialogDataSourcePara_WindowAdapter(DialogDataSourcePara adaptee) {
this.adaptee = adaptee;
}
public void windowClosing(WindowEvent e) {
adaptee.this_windowClosing(e);
}
}
class DialogDataSourcePara_jDBTitle_itemAdapter implements
java.awt.event.ItemListener {
DialogDataSourcePara adaptee;
DialogDataSourcePara_jDBTitle_itemAdapter(DialogDataSourcePara adaptee) {
this.adaptee = adaptee;
}
public void itemStateChanged(ItemEvent e) {
adaptee.jDBTitle_itemStateChanged(e);
}
}
class DialogDataSourcePara_jBOK_actionAdapter implements
java.awt.event.ActionListener {
DialogDataSourcePara adaptee;
DialogDataSourcePara_jBOK_actionAdapter(DialogDataSourcePara adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jBOK_actionPerformed(e);
}
}
class DialogDataSourcePara_jBCancel_actionAdapter implements
java.awt.event.ActionListener {
DialogDataSourcePara adaptee;
DialogDataSourcePara_jBCancel_actionAdapter(DialogDataSourcePara adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jBCancel_actionPerformed(e);
}
}
class DialogDataSourcePara_jTabbedPaneAttr_changeAdapter implements
javax.swing.event.ChangeListener {
DialogDataSourcePara adaptee;
DialogDataSourcePara_jTabbedPaneAttr_changeAdapter(
DialogDataSourcePara adaptee) {
this.adaptee = adaptee;
}
public void stateChanged(ChangeEvent e) {
adaptee.jTabbedPaneAttr_stateChanged(e);
}
}
class DialogDataSourcePara_jTable1_focusAdapter extends
java.awt.event.FocusAdapter {
DialogDataSourcePara adaptee;
DialogDataSourcePara_jTable1_focusAdapter(DialogDataSourcePara adaptee) {
this.adaptee = adaptee;
}
public void focusLost(FocusEvent e) {
adaptee.tableExtend_focusLost(e);
}
}
class DialogDataSourcePara_jBAdd_actionAdapter implements
java.awt.event.ActionListener {
DialogDataSourcePara adaptee;
DialogDataSourcePara_jBAdd_actionAdapter(DialogDataSourcePara adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jBAdd_actionPerformed(e);
}
}
class DialogDataSourcePara_jBDel_actionAdapter implements
java.awt.event.ActionListener {
DialogDataSourcePara adaptee;
DialogDataSourcePara_jBDel_actionAdapter(DialogDataSourcePara adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jBDel_actionPerformed(e);
}
}