📄 inputdatadboperatorproperty.java
字号:
// Put the editor pane in a scroll pane.
JScrollPane editorScrollPane = new JScrollPane(editorPane);
editorScrollPane
.setVerticalScrollBarPolicy(JScrollPane.VERTICAL_SCROLLBAR_ALWAYS);
//editorScrollPane.setPreferredSize(new Dimension(250, 145));
editorScrollPane.setMinimumSize(new Dimension(10, 50));
editorScrollPane.setPreferredSize(new Dimension(10, 50));
m_DBPanelTemp2.add(editorScrollPane, BorderLayout.CENTER);
dbFieldPanel.add(m_selectedDBComboBox, BorderLayout.NORTH);
m_selectedDBComboBox.addItem(Resource.srcStr("SelectItem"));
m_selectedDBComboBox.setPreferredSize(new Dimension(100, 20));
m_SelectedTableComboBox.addItem(Resource.srcStr("SelectItem"));
m_SelectedTableComboBox.setPreferredSize(new Dimension(80, 20));
dbFieldPanel.add(m_DBPanelTemp1, BorderLayout.CENTER);
dbFieldPanel.add(m_DBPanelTemp2, BorderLayout.SOUTH);
dbSeverPanel.setPreferredSize(new Dimension(400, 140));
m_dbPanel.setPreferredSize(new Dimension(400, 155));
propertyDBPanel.add(dbSeverPanel, BorderLayout.CENTER);
propertyDBPanel.add(m_dbPanel, BorderLayout.SOUTH);
m_ButtonApply.setText(Resource.srcStr("m_ButtonApply"));
m_ButtonReset.setSelected(false);
m_ButtonReset.setText(Resource.srcStr("m_ButtonReset"));
m_ButtonClose.setSelected(false);
m_ButtonClose.setText(Resource.srcStr("m_ButtonClose"));
buttonPanel.add(m_ButtonApply);
buttonPanel.add(m_ButtonReset);
buttonPanel.add(m_ButtonClose);
m_ButtonApply.addActionListener(this);
m_ButtonApply.setPreferredSize(m_defaultButtonSize);
m_ButtonReset.addActionListener(this);
m_ButtonReset.setPreferredSize(m_defaultButtonSize);
m_ButtonClose.addActionListener(this);
m_ButtonClose.setPreferredSize(m_defaultButtonSize);
this.getContentPane().add(propertyDBPanel, BorderLayout.NORTH);
this.getContentPane().add(buttonPanel, BorderLayout.SOUTH);
this.setSize(450, 385);
//ODBCj.getDataSources();
DataSource[] DSNs = ODBCj.getDataSources();
int len = DSNs.length;
m_DSNComboBox.addItem(Resource.srcStr("SelectItem"));
ODBCDriver drvName;
for (int i = 0; i < len; i++) {
drvName = DSNs[i].getDriver();
if (drvName != null) {
if (drvName.toString().startsWith(ODBC_DRVNAME_MYSQL)
|| drvName.toString().startsWith(ODBC_DRVNAME_ACCESS)
|| drvName.toString().endsWith(ODBC_DRVNAME_MYSQL)
|| drvName.toString().endsWith(ODBC_DRVNAME_ACCESS)) {
m_DSNComboBox.addItem(DSNs[i].getName());
}
}
}
getContent();
}
/**
* @see java.awt.event.ActionListener#actionPerformed(ActionEvent)
*/
public void actionPerformed(ActionEvent e) {
if (e.getSource() == m_connectButton) {
if (m_DBDriver.getSelectedIndex() == 0) {
m_MessageDialog.showWarning(Resource.srcStr("ChooseDriverMessage"), "Warning");
} else if (m_DBDriver.getSelectedIndex() > 1
&& m_host.getText().trim().length() <= 0) {
m_MessageDialog.showWarning(Resource.srcStr("InputHoseMessage"), "Warning");
} else if (m_DBDriver.getSelectedIndex() > 1
&& m_Port.getText().trim().length() <= 0) {
m_MessageDialog.showWarning(Resource.srcStr("InputPortMessage"), "Warning");
} else if (m_DBDriver.getSelectedIndex() == 1
&& m_DSNComboBox.getSelectedIndex() <= 0) {
m_MessageDialog.showWarning(Resource.srcStr("ChooseDSNMessage"), "Warning");
}/*
* else if (m_DBUser.getText().trim().length() <= 0) {
* MessageDialog.showWarning("Please input User Name.", "Warning"); }
*/else if (m_DBUser.getText().trim().length() > 100) {
m_DBUser.setText("");
m_DBUser.requestFocus();
m_DBUser.selectAll();
m_MessageDialog
.showWarning(
Resource.srcStr("LengthMessage"),
"Warning");
} else {
if (connectToSever()) {
if (m_RadioTable.isSelected()) {
m_RadioTable.setEnabled(true);
m_RadioSQL.setEnabled(true);
m_SelectedTableComboBox.setEnabled(true);
editorPane.setEnabled(false);
} else {
m_RadioTable.setEnabled(true);
m_RadioSQL.setEnabled(true);
m_SelectedTableComboBox.setEnabled(false);
editorPane.setEnabled(true);
}
} else {
setEnableDBPanel(false);
ResetDBPanel();
}
}
} else if (e.getSource() == m_ButtonApply) {
if (m_DBDriver.getSelectedIndex() == 0) {
m_MessageDialog.showWarning(Resource.srcStr("ChooseDriverMessage"), "Warning");
} else if (m_DBDriver.getSelectedIndex() > JDBC_ODBC_Driver
&& m_host.getText().trim().length() <= 0) {
m_MessageDialog.showWarning(Resource.srcStr("InputHoseMessage"), "Warning");
} else if (m_DBDriver.getSelectedIndex() > JDBC_ODBC_Driver
&& m_Port.getText().trim().length() <= 0) {
m_MessageDialog.showWarning(Resource.srcStr("InputPortMessage"), "Warning");
} else if (m_DBDriver.getSelectedIndex() == JDBC_ODBC_Driver
&& m_DSNComboBox.getSelectedIndex() <= 0) {
m_MessageDialog.showWarning(Resource.srcStr("ChooseDSNMessage"), "Warning");
} /*
* else if (m_DBUser.getText().trim().length() <= 0) {
* MessageDialog.showWarning("Please input User Name.",
* "Warning"); }
*/
else if (m_DBUser.getText().trim().length() > 100) {
m_DBUser.setText("");
m_DBUser.requestFocus();
m_DBUser.selectAll();
m_MessageDialog
.showWarning(
Resource.srcStr("LengthMessage"),
"Warning");
} else if (m_RadioSQL.isSelected()
&& editorPane.getText().trim().length() <= 0) {
m_MessageDialog.showWarning(Resource.srcStr("ValidSQLMessage"),
"Warning");
} else if (m_RadioTable.isSelected()
&& m_SelectedTableComboBox.getSelectedIndex() <= 0) {
// MessageDialog
// .showWarning("Please select table or input SQL query.",
// "Warning");
m_MessageDialog.showWarning(Resource.srcStr("InputTableMessage"), "Warning");
} else {
if (setContent()) {
m_ParameterChanged = true;
} //if (setContent()) close();
}
} else if (e.getSource() == m_ButtonReset) {
getContent();
} else if (e.getSource() == m_ButtonClose)
close();
else if (e.getSource() == m_DBDriver) {
if (m_DBDriver.getSelectedIndex() == JDBC_ODBC_Driver) {
//disable host and port
m_host.setEnabled(false);
m_Port.setEnabled(false);
m_portLabel.setEnabled(false);
m_hostLabel.setEnabled(false);
CardLayout cl = (CardLayout) (m_cards_1.getLayout());
cl.show(m_cards_1, "DSN_LABEL");
CardLayout c2 = (CardLayout) (m_cards_2.getLayout());
c2.show(m_cards_2, "DSN_INPUT");
CardLayout c3 = (CardLayout) (m_cards_3.getLayout());
c3.show(m_cards_3, "NULL_LABEL");
CardLayout c4 = (CardLayout) (m_cards_4.getLayout());
c4.show(m_cards_4, "NULL_INPUT");
} else {
//enable host and port
m_host.setEnabled(true);
m_Port.setEnabled(true);
m_portLabel.setEnabled(true);
m_hostLabel.setEnabled(true);
CardLayout cl = (CardLayout) (m_cards_1.getLayout());
cl.show(m_cards_1, "HOST_LABEL");
CardLayout c2 = (CardLayout) (m_cards_2.getLayout());
c2.show(m_cards_2, "HOST_INPUT");
CardLayout c3 = (CardLayout) (m_cards_3.getLayout());
c3.show(m_cards_3, "PORT_LABEL");
CardLayout c4 = (CardLayout) (m_cards_4.getLayout());
c4.show(m_cards_4, "PORT_INPUT");
}
}
}
@SuppressWarnings("deprecation")
public boolean connectToSever() {
// set db inform
this.m_selectedDBComboBox.removeAllItems();
m_selectedDBComboBox.addItem(Resource.srcStr("SelectItem"));
this.m_SelectedTableComboBox.removeAllItems();
m_SelectedTableComboBox.addItem(Resource.srcStr("SelectItem"));
try {
// set table information
String url, dbUser, dbPassword, driver;
url = "jdbc:odbc:" + m_DSNComboBox.getSelectedItem().toString();
dbUser = m_DBUser.getText().trim();
if (dbUser.length() <= 0)
dbUser = "''";
dbPassword = m_DBPassword.getText().trim();
driver = "sun.jdbc.odbc.JdbcOdbcDriver";
// System.out.println( url + "\n");
// System.out.println( dbUser + "\n");
// System.out.println( dbPassword + "\n");
// System.out.println(driver + "\n");
if (url.equals("jdbc:odbc:") || m_DBDriver.getSelectedIndex() <= 0) {
m_MessageDialog.showWarning(
Resource.srcStr("AllInformationMessage"),
"Warning");
return false;
}
MiningSqlSource a_Source = new MiningSqlSource(url, dbUser,
dbPassword, driver);
a_Source.getConnection();
TableInfo[] tb = a_Source.getTables();
// remove table
m_SelectedTableComboBox.removeAllItems();
m_SelectedTableComboBox.addItem(Resource.srcStr("SelectItem"));
// add table
for (int i = 0; i < tb.length; i++) {
m_SelectedTableComboBox.addItem(tb[i].toString());
}
m_SelectedTableComboBox.setSelectedIndex(0);
// connection to jdbc
if (this.m_DBDriver.getSelectedIndex() == JDBC_ODBC_Driver) {
this.m_selectedDBComboBox.setEnabled(false);
} else {
this.m_selectedDBComboBox.setEnabled(true);
}
} catch (MiningException me) {
//<< added by Joyce 2005/03/31
m_DBUser.setText("");
m_DBPassword.setText("");
//>>>
m_DBUser.requestFocus();
m_DBUser.selectAll();
m_MessageDialog.showError("Error in loading meta data: "
+ me.getMessage(), "Error");
return false;
}
return true;
}
@SuppressWarnings("deprecation")
private boolean setContent() {
String dbDriverName = this.m_DBDriver.getSelectedItem().toString();
String dbDriver = "";
String DSN = this.m_DSNComboBox.getSelectedItem().toString();
String host = this.m_Port.getText();
String port = this.m_Port.getText();
String dbUser = m_DBUser.getText();
String dbPassword = m_DBPassword.getText();
String dbName = this.m_selectedDBComboBox.getSelectedItem().toString();//m_DBName.getText();
String dbTableName = this.m_SelectedTableComboBox.getSelectedItem()
.toString();
String query = editorPane.getText();
if (dbDriverName == null)
dbDriverName = "";
else
dbDriverName = dbDriverName.trim();
if (DSN == null)
DSN = "";
else
DSN = DSN.trim();
if (host == null)
host = "";
else
host = host.trim();
if (port == null)
port = "";
else
port = port.trim();
if (dbUser == null)
dbUser = "";
else
dbUser = dbUser.trim();
if (dbPassword == null)
dbPassword = "";
else
dbPassword = dbPassword.trim();
if (dbName == null)
dbName = "";
else
dbName = dbName.trim();
if (dbTableName == null)
dbTableName = "";
else
dbTableName = dbTableName.trim();
if (query == null)
query = "";
else
query = query.trim();
int seLDB_Driver = m_DBDriver.getSelectedIndex();
if (seLDB_Driver == 0
|| (query.length() <= 0 && dbTableName.length() <= 0)) {
{
// JOptionPane.showMessageDialog(m_ParentPanel.getCaseWindow(),
// Resource.srcStr("AllInformationMessage"),
// "Error", JOptionPane.ERROR_MESSAGE);
m_MessageDialog.showWarning(
Resource.srcStr("AllInformationMessage"),
"Warning");
return false;
}
} else if (seLDB_Driver == JDBC_ODBC_Driver) {
if (DSN.equals(Resource.srcStr("SelectItem")) || DSN.length() <= 0) {
// JOptionPane.showMessageDialog(m_ParentPanel.getCaseWindow(),
// Resource.srcStr("AllInformationMessage"),
// "Error", JOptionPane.ERROR_MESSAGE);
m_MessageDialog.showWarning(
Resource.srcStr("AllInformationMessage"),
"Warning");
return false;
}
dbDriverName = ODBC_ParameterValue;
dbDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
dbName = DSN;
} else if (seLDB_Driver > JDBC_ODBC_Driver) {
if (host.equals(Resource.srcStr("SelectItem")) || host.length() <= 0
|| port.equals(Resource.srcStr("SelectItem")) || port.length() <= 0
|| dbName.equals(Resource.srcStr("SelectItem"))
|| dbName.length() <= 0) {
// JOptionPane.showMessageDialog(m_ParentPanel.getCaseWindow(),
// Resource.srcStr("AllInformationMessage"),
// "Error", JOptionPane.ERROR_MESSAGE);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -