private boolean resetAndUpdateDatabaseLoaderIfChanged() {
DatabaseLoader dbl = (DatabaseLoader) m_dsLoader.getLoader();
String url = dbl.getUrl();
String user = dbl.getUser();
String password = dbl.getPassword();
String query = dbl.getQuery();
String keys = dbl.getKeys();
File propsFile = dbl.getCustomPropsFile();
boolean update =
(!url.equals(m_dbaseURLText.getText())
|| !user.equals(m_userNameText.getText())
|| !password.equals(m_passwordText.getText())
|| !query.equalsIgnoreCase(m_queryText.getText())
|| !keys.equals(m_keyText.getText()));
if (propsFile != null && m_dbProps.getText().length() > 0) {
update = (update || !propsFile.toString().equals(m_dbProps.getText()));
} else {
update = (update || m_dbProps.getText().length() > 0);
}
if (update) {
dbl.resetStructure();
dbl.setUrl(m_dbaseURLText.getText());
dbl.setUser(m_userNameText.getText());
dbl.setPassword(new String(m_passwordText.getPassword()));
dbl.setQuery(m_queryText.getText());
dbl.setKeys(m_keyText.getText());
if (m_dbProps.getText() != null && m_dbProps.getText().length() > 0) {
dbl.setCustomPropsFile(new File(m_dbProps.getText()));
}
}
return update;
}
/** Sets up a customizer window for a Database Connection */
private void setUpDatabase() {
removeAll();
JPanel db = new JPanel();
GridBagLayout gbLayout = new GridBagLayout();
// db.setLayout(new GridLayout(6, 1));
db.setLayout(gbLayout);
JLabel urlLab = new JLabel("Database URL", SwingConstants.RIGHT);
urlLab.setBorder(BorderFactory.createEmptyBorder(0, 5, 0, 0));
GridBagConstraints gbConstraints = new GridBagConstraints();
gbConstraints.anchor = GridBagConstraints.EAST;
gbConstraints.fill = GridBagConstraints.HORIZONTAL;
gbConstraints.gridy = 0;
gbConstraints.gridx = 0;
gbLayout.setConstraints(urlLab, gbConstraints);
db.add(urlLab);
m_dbaseURLText = new EnvironmentField();
m_dbaseURLText.setEnvironment(m_env);
/* int width = m_dbaseURLText.getPreferredSize().width;
int height = m_dbaseURLText.getPreferredSize().height;
m_dbaseURLText.setMinimumSize(new Dimension(width * 2, height));
m_dbaseURLText.setPreferredSize(new Dimension(width * 2, height)); */
m_dbaseURLText.setText(((DatabaseConverter) m_dsLoader.getLoader()).getUrl());
gbConstraints = new GridBagConstraints();
gbConstraints.anchor = GridBagConstraints.EAST;
gbConstraints.fill = GridBagConstraints.HORIZONTAL;
gbConstraints.gridy = 0;
gbConstraints.gridx = 1;
gbConstraints.weightx = 5;
gbLayout.setConstraints(m_dbaseURLText, gbConstraints);
db.add(m_dbaseURLText);
JLabel userLab = new JLabel("Username", SwingConstants.RIGHT);
userLab.setBorder(BorderFactory.createEmptyBorder(0, 5, 0, 0));
gbConstraints = new GridBagConstraints();
gbConstraints.anchor = GridBagConstraints.EAST;
gbConstraints.fill = GridBagConstraints.HORIZONTAL;
gbConstraints.gridy = 1;
gbConstraints.gridx = 0;
gbLayout.setConstraints(userLab, gbConstraints);
db.add(userLab);
m_userNameText = new EnvironmentField();
m_userNameText.setEnvironment(m_env);
/* m_userNameText.setMinimumSize(new Dimension(width * 2, height));
m_userNameText.setPreferredSize(new Dimension(width * 2, height)); */
m_userNameText.setText(((DatabaseConverter) m_dsLoader.getLoader()).getUser());
gbConstraints = new GridBagConstraints();
gbConstraints.anchor = GridBagConstraints.EAST;
gbConstraints.fill = GridBagConstraints.HORIZONTAL;
gbConstraints.gridy = 1;
gbConstraints.gridx = 1;
gbLayout.setConstraints(m_userNameText, gbConstraints);
db.add(m_userNameText);
JLabel passwordLab = new JLabel("Password ", SwingConstants.RIGHT);
passwordLab.setBorder(BorderFactory.createEmptyBorder(0, 5, 0, 0));
gbConstraints = new GridBagConstraints();
gbConstraints.anchor = GridBagConstraints.EAST;
gbConstraints.fill = GridBagConstraints.HORIZONTAL;
gbConstraints.gridy = 2;
gbConstraints.gridx = 0;
gbLayout.setConstraints(passwordLab, gbConstraints);
db.add(passwordLab);
m_passwordText = new JPasswordField();
JPanel passwordHolder = new JPanel();
passwordHolder.setLayout(new BorderLayout());
passwordHolder.setBorder(BorderFactory.createEmptyBorder(5, 5, 5, 5));
// passwordHolder.add(passwordLab, BorderLayout.WEST);
passwordHolder.add(m_passwordText, BorderLayout.CENTER);
/* passwordHolder.setMinimumSize(new Dimension(width * 2, height));
passwordHolder.setPreferredSize(new Dimension(width * 2, height)); */
gbConstraints = new GridBagConstraints();
gbConstraints.anchor = GridBagConstraints.EAST;
gbConstraints.fill = GridBagConstraints.HORIZONTAL;
gbConstraints.gridy = 2;
gbConstraints.gridx = 1;
gbLayout.setConstraints(passwordHolder, gbConstraints);
db.add(passwordHolder);
JLabel queryLab = new JLabel("Query", SwingConstants.RIGHT);
queryLab.setBorder(BorderFactory.createEmptyBorder(0, 5, 0, 0));
gbConstraints = new GridBagConstraints();
gbConstraints.anchor = GridBagConstraints.EAST;
gbConstraints.fill = GridBagConstraints.HORIZONTAL;
gbConstraints.gridy = 3;
gbConstraints.gridx = 0;
gbLayout.setConstraints(queryLab, gbConstraints);
db.add(queryLab);
m_queryText = new EnvironmentField();
m_queryText.setEnvironment(m_env);
/* m_queryText.setMinimumSize(new Dimension(width * 2, height));
m_queryText.setPreferredSize(new Dimension(width * 2, height)); */
m_queryText.setText(((DatabaseLoader) m_dsLoader.getLoader()).getQuery());
gbConstraints = new GridBagConstraints();
gbConstraints.anchor = GridBagConstraints.EAST;
gbConstraints.fill = GridBagConstraints.HORIZONTAL;
gbConstraints.gridy = 3;
gbConstraints.gridx = 1;
gbLayout.setConstraints(m_queryText, gbConstraints);
db.add(m_queryText);
JLabel keyLab = new JLabel("Key columns", SwingConstants.RIGHT);
keyLab.setBorder(BorderFactory.createEmptyBorder(0, 5, 0, 0));
gbConstraints = new GridBagConstraints();
gbConstraints.anchor = GridBagConstraints.EAST;
gbConstraints.fill = GridBagConstraints.HORIZONTAL;
gbConstraints.gridy = 4;
gbConstraints.gridx = 0;
gbLayout.setConstraints(keyLab, gbConstraints);
db.add(keyLab);
m_keyText = new EnvironmentField();
m_keyText.setEnvironment(m_env);
/*m_keyText.setMinimumSize(new Dimension(width * 2, height));
m_keyText.setPreferredSize(new Dimension(width * 2, height)); */
m_keyText.setText(((DatabaseLoader) m_dsLoader.getLoader()).getKeys());
gbConstraints = new GridBagConstraints();
gbConstraints.anchor = GridBagConstraints.EAST;
gbConstraints.fill = GridBagConstraints.HORIZONTAL;
gbConstraints.gridy = 4;
gbConstraints.gridx = 1;
gbLayout.setConstraints(m_keyText, gbConstraints);
db.add(m_keyText);
JLabel propsLab = new JLabel("DB config props", SwingConstants.RIGHT);
propsLab.setToolTipText(
"The custom properties that the user can use to override the default ones.");
propsLab.setBorder(BorderFactory.createEmptyBorder(0, 5, 0, 0));
gbConstraints = new GridBagConstraints();
gbConstraints.anchor = GridBagConstraints.EAST;
gbConstraints.fill = GridBagConstraints.HORIZONTAL;
gbConstraints.gridy = 5;
gbConstraints.gridx = 0;
gbLayout.setConstraints(propsLab, gbConstraints);
db.add(propsLab);
m_dbProps = new FileEnvironmentField();
m_dbProps.setEnvironment(m_env);
m_dbProps.resetFileFilters();
m_dbProps.addFileFilter(
new ExtensionFileFilter(".props", "DatabaseUtils property file (*.props)"));
gbConstraints = new GridBagConstraints();
gbConstraints.anchor = GridBagConstraints.EAST;
gbConstraints.fill = GridBagConstraints.HORIZONTAL;
gbConstraints.gridy = 5;
gbConstraints.gridx = 1;
gbLayout.setConstraints(m_dbProps, gbConstraints);
db.add(m_dbProps);
File toSet = ((DatabaseLoader) m_dsLoader.getLoader()).getCustomPropsFile();
if (toSet != null) {
m_dbProps.setText(toSet.getPath());
}
JButton loadPropsBut = new JButton("Load");
loadPropsBut.setToolTipText("Load config");
gbConstraints = new GridBagConstraints();
gbConstraints.anchor = GridBagConstraints.EAST;
gbConstraints.fill = GridBagConstraints.HORIZONTAL;
gbConstraints.gridy = 5;
gbConstraints.gridx = 2;
gbLayout.setConstraints(loadPropsBut, gbConstraints);
db.add(loadPropsBut);
loadPropsBut.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
if (m_dbProps.getText() != null && m_dbProps.getText().length() > 0) {
String propsS = m_dbProps.getText();
try {
propsS = m_env.substitute(propsS);
} catch (Exception ex) {
}
File propsFile = new File(propsS);
if (propsFile.exists()) {
((DatabaseLoader) m_dsLoader.getLoader()).setCustomPropsFile(propsFile);
((DatabaseLoader) m_dsLoader.getLoader()).resetOptions();
m_dbaseURLText.setText(((DatabaseLoader) m_dsLoader.getLoader()).getUrl());
}
}
}
});
JPanel buttonsP = new JPanel();
buttonsP.setLayout(new FlowLayout());
JButton ok, cancel;
buttonsP.add(ok = new JButton("OK"));
buttonsP.add(cancel = new JButton("Cancel"));
ok.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
/*((DatabaseLoader)m_dsLoader.getLoader()).resetStructure();
((DatabaseConverter)m_dsLoader.getLoader()).setUrl(m_dbaseURLText.getText());
((DatabaseConverter)m_dsLoader.getLoader()).setUser(m_userNameText.getText());
((DatabaseConverter)m_dsLoader.getLoader()).setPassword(new String(m_passwordText.getPassword()));
((DatabaseLoader)m_dsLoader.getLoader()).setQuery(m_queryText.getText());
((DatabaseLoader)m_dsLoader.getLoader()).setKeys(m_keyText.getText()); */
if (resetAndUpdateDatabaseLoaderIfChanged()) {
try {
// m_dsLoader.notifyStructureAvailable(((DatabaseLoader)m_dsLoader.getLoader()).getStructure());
// database connection has been configured
m_dsLoader.setDB(true);
} catch (Exception ex) {
}
}
if (m_parentWindow != null) {
m_parentWindow.dispose();
}
}
});
cancel.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent evt) {
if (m_backup != null) {
m_dsLoader.setLoader(m_backup);
}
if (m_parentWindow != null) {
m_parentWindow.dispose();
}
}
});
JPanel holderP = new JPanel();
holderP.setLayout(new BorderLayout());
holderP.add(db, BorderLayout.NORTH);
holderP.add(buttonsP, BorderLayout.SOUTH);
// db.add(buttonsP);
JPanel about = m_LoaderEditor.getAboutPanel();
if (about != null) {
add(about, BorderLayout.NORTH);
}
add(holderP, BorderLayout.SOUTH);
}
