com.scudata.ide.common.dialog.DialogODBCDataSource 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.Dimension;
import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.event.ActionEvent;
import java.awt.event.WindowEvent;
import java.util.ArrayList;
import java.util.Vector;
import javax.swing.JButton;
import javax.swing.JCheckBox;
import javax.swing.JDialog;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JPasswordField;
import javax.swing.JTextField;
import com.scudata.common.DBConfig;
import com.scudata.common.MessageManager;
import com.scudata.common.ODBCUtil;
import com.scudata.common.StringUtils;
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.JComboBoxEx;
import com.scudata.ide.common.swing.VFlowLayout;
/**
* ODBC????Դ?Ի???
*
*/
public class DialogODBCDataSource extends JDialog {
private static final long serialVersionUID = 1L;
/**
* Common??Դ??????
*/
private MessageManager mm = IdeCommonMessage.get();
/**
* ?˳?ѡ??
*/
private int m_option = JOptionPane.CANCEL_OPTION;
/**
* ??????Դ????
*/
private String oldDSName;
/**
* URL
*/
public static final String ODBC_URL = "jdbc:odbc:";
/**
* ?ַ???
*/
public static final String ODBC_CHARSET = "GBK";
/**
* ????
*/
public static final String ODBC_DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";
/**
* ȡ????ť
*/
private JButton jBCancel = new JButton();
/**
* ȷ?ϰ?ť
*/
private JButton jBOK = new JButton();
/**
* ????Դ????
*/
private JLabel jLabel1 = new JLabel();
/**
* ????Դ?????ı???
*/
private JTextField jDSName = new JTextField();
/**
* ODBC????
*/
private JLabel jLabel3 = new JLabel();
/**
* ODBC?????ı???
*/
private JComboBoxEx jODBCName = new JComboBoxEx();
/**
* ?û???
*/
private JLabel jLabel4 = new JLabel();
/**
* ?û????ı???
*/
private JTextField jUser = new JTextField();
/**
* ????
*/
private JLabel jLabel5 = new JLabel();
/**
* ?????????
*/
private JPasswordField jPassword = new JPasswordField();
/**
* ?????Ƿ??ģʽ??
*/
private JCheckBox jUseSchema = new JCheckBox();
/**
* ?Ƿ??Сд????
*/
private JCheckBox jCaseSentence = new JCheckBox();
/**
* ???????Ƿ??????
*/
private JCheckBox jCBIsAddTilde = new JCheckBox();
/**
* ?Ѿ????ڵ?????
*/
private Vector existNames;
/**
* ???캯??
*/
public DialogODBCDataSource() {
super(GV.appFrame, "ODBC????Դ", true);
try {
setSize(400, 300);
initUI();
init();
resetLangText();
GM.setDialogDefaultButton(this, jBOK, jBCancel);
} catch (Exception ex) {
GM.showException(ex);
}
}
/**
* ??????????Դ
*/
private void resetLangText() {
setTitle(mm.getMessage("dialogodbcdatasource.title")); // ODBC????Դ
jBCancel.setText(mm.getMessage("button.cancel"));
jBOK.setText(mm.getMessage("button.ok"));
jLabel1.setText(mm.getMessage("dialogodbcdatasource.dsname")); // ????Դ????
jLabel3.setText(mm.getMessage("dialogodbcdatasource.odbcname")); // ODBC????
jLabel4.setText(mm.getMessage("dialogodbcdatasource.user")); // ?û???
jLabel5.setText(mm.getMessage("dialogodbcdatasource.password")); // ????
jUseSchema.setText(mm.getMessage("dialogodbcdatasource.useschema")); // ʹ?ô?ģʽ?ı?????
jCaseSentence.setText(mm
.getMessage("dialogodbcdatasource.casesentence")); // ??Сд????
jCBIsAddTilde.setText(mm.getMessage("dialogdatasourcepara.isaddtilde"));
}
/**
* ????????Դ????
*
* @param config
*/
public void set(DBConfig config) {
if (!DialogDataSource.isLocalDataSource(new DataSource(config), false)) {
jBOK.setEnabled(false);
}
oldDSName = config.getName();
jDSName.setText(config.getName());
String url = config.getUrl();
if (url.startsWith(ODBC_URL)) {
url = url.substring(ODBC_URL.length());
}
jODBCName.setSelectedItem(url);
jUser.setText(config.getUser());
String pwd = config.getPassword();
try {
jPassword.setText(pwd); // PwdUtils.decrypt(pwd)
} catch (Exception x) {
}
jUseSchema.setSelected(config.isUseSchema());
jCaseSentence.setSelected(config.isCaseSentence());
jCBIsAddTilde.setSelected(config.isAddTilde());
}
/**
* ȡ????Դ????
*
* @return
*/
public DataSource get() {
DBConfig config = new DBConfig();
config.setName(jDSName.getText());
// config.setDBCharset(ODBC_CHARSET);
// config.setClientCharset(ODBC_CHARSET);
config.setDriver(ODBC_DRIVER);
config.setUrl(ODBC_URL + (String) jODBCName.getSelectedItem());
config.setUser(jUser.getText());
String pwd = new String(jPassword.getPassword());
config.setPassword(pwd); // PwdUtils.encrypt(pwd)
config.setUseSchema(jUseSchema.isSelected());
config.setCaseSentence(jCaseSentence.isSelected());
config.setAddTilde(jCBIsAddTilde.isSelected());
DataSource ds = new DataSource(config);
return ds;
}
/**
* ?????Ѿ????ڵ?????
*
* @param existNames
* ?Ѿ????ڵ?????
*/
public void setExistNames(Vector existNames) {
this.existNames = existNames;
}
/**
* ȡ?˳?ѡ??
*
* @return
*/
public int getOption() {
return m_option;
}
/**
* ?????Ƿ?????
*
* @return
*/
public boolean isNameChanged() {
return !jDSName.getText().equalsIgnoreCase(oldDSName);
}
/**
* ??ʼ???ؼ?
*
* @throws Exception
*/
private void initUI() throws Exception {
this.setDefaultCloseOperation(javax.swing.WindowConstants.DO_NOTHING_ON_CLOSE);
this.addWindowListener(new DialogODBCDataSource_this_windowAdapter(this));
JPanel jPanel1 = new JPanel();
JPanel jPanel2 = new JPanel();
VFlowLayout vFlowLayout1 = new VFlowLayout();
jPanel2.setLayout(vFlowLayout1);
jBCancel.setMnemonic('C');
jBCancel.setText("ȡ??(C)");
jBCancel.addActionListener(new DialogODBCDataSource_jBCancel_actionAdapter(
this));
jBOK.setMnemonic('O');
jBOK.setText("ȷ??(O)");
jBOK.addActionListener(new DialogODBCDataSource_jBOK_actionAdapter(this));
GridBagLayout gridBagLayout1 = new GridBagLayout();
GridBagLayout gridBagLayout2 = new GridBagLayout();
JPanel jPanel5 = new JPanel();
jPanel1.setLayout(gridBagLayout1);
jLabel1.setText("????Դ????");
jLabel3.setText("ODBC????");
jLabel4.setText("?û???");
jLabel5.setText("????");
jUseSchema.setText("ʹ?ô?ģʽ?ı?????");
jCaseSentence.setText("??Сд????");
jCBIsAddTilde.setText("ʹ?ô????ŵ?SQL");
JPanel jPanel3 = new JPanel();
jPanel3.setLayout(gridBagLayout2);
this.getContentPane().add(jPanel1, BorderLayout.CENTER);
this.getContentPane().add(jPanel2, BorderLayout.EAST);
jPanel2.add(jBOK, null);
jPanel2.add(jBCancel, null);
jPanel1.add(jPanel3, GM.getGBC(1, 1, true));
jPanel1.add(jPanel5, GM.getGBC(3, 1, true, true));
jPanel3.add(jLabel1, GM.getGBC(1, 1));
jPanel3.add(jDSName, GM.getGBC(1, 2, true));
jPanel3.add(jLabel3, GM.getGBC(3, 1));
jPanel3.add(jODBCName, GM.getGBC(3, 2, true));
jPanel3.add(jLabel4, GM.getGBC(4, 1));
jPanel3.add(jUser, GM.getGBC(4, 2, true));
jPanel3.add(jLabel5, GM.getGBC(5, 1));
jPanel3.add(jPassword, GM.getGBC(5, 2, true));
GridBagConstraints gbc = GM.getGBC(6, 1, true);
gbc.gridwidth = 2;
jPanel3.add(jUseSchema, gbc);
gbc = GM.getGBC(7, 1, true);
gbc.gridwidth = 2;
jPanel3.add(jCaseSentence, gbc);
gbc = GM.getGBC(8, 1, true);
gbc.gridwidth = 2;
jPanel3.add(jCBIsAddTilde, gbc);
}
/**
* ??ʼ??
*/
private void init() {
int height = 28;
jDSName.setPreferredSize(new Dimension(0, height));
jODBCName.setPreferredSize(new Dimension(0, height));
jUser.setPreferredSize(new Dimension(0, height));
jPassword.setPreferredSize(new Dimension(0, height));
jUseSchema.setPreferredSize(new Dimension(0, height));
jCaseSentence.setPreferredSize(new Dimension(0, height));
jODBCName.setEditable(true);
ArrayList dsList = ODBCUtil.getDataSourcesName(ODBCUtil.SYS_DSN
| ODBCUtil.USER_DSN);
jODBCName.setListData(dsList.toArray());
}
/**
* ȷ?ϰ?ť?¼?
*
* @param e
*/
void jBOK_actionPerformed(ActionEvent e) {
try {
if (!StringUtils.isValidString(jDSName.getText())) {
throw new Exception(
mm.getMessage("dialogdatasourcepara.emptydsname"));
}
if (!StringUtils.isValidString(jODBCName.getSelectedItem())) {
throw new Exception(
mm.getMessage("dialogdatasourcepara.emptyodbc"));
}
if (existNames != null) {
if (existNames.contains(jDSName.getText())) {
GM.messageDialog(GV.appFrame,
mm.getMessage("dialogdatasource.existdsname")
+ jDSName.getText(),
mm.getMessage("public.note"),
JOptionPane.ERROR_MESSAGE);
return;
}
} else if (isNameChanged() && GM.isExistDataSource(get())) {
return;
}
GM.setWindowDimension(this);
m_option = JOptionPane.OK_OPTION;
dispose();
} catch (Exception ex) {
GM.showException(ex);
}
}
/**
* ȡ????ť?¼?
*
* @param e
*/
void jBCancel_actionPerformed(ActionEvent e) {
GM.setWindowDimension(this);
dispose();
}
/**
* ???ڹر??¼?
*
* @param e
*/
void this_windowClosing(WindowEvent e) {
GM.setWindowDimension(this);
dispose();
}
}
class DialogODBCDataSource_jBOK_actionAdapter implements
java.awt.event.ActionListener {
DialogODBCDataSource adaptee;
DialogODBCDataSource_jBOK_actionAdapter(DialogODBCDataSource adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jBOK_actionPerformed(e);
}
}
class DialogODBCDataSource_jBCancel_actionAdapter implements
java.awt.event.ActionListener {
DialogODBCDataSource adaptee;
DialogODBCDataSource_jBCancel_actionAdapter(DialogODBCDataSource adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jBCancel_actionPerformed(e);
}
}
class DialogODBCDataSource_this_windowAdapter extends
java.awt.event.WindowAdapter {
DialogODBCDataSource adaptee;
DialogODBCDataSource_this_windowAdapter(DialogODBCDataSource adaptee) {
this.adaptee = adaptee;
}
public void windowClosing(WindowEvent e) {
adaptee.this_windowClosing(e);
}
}