package net.sf.jabref.sql;
import net.sf.jabref.BaseAction;
import net.sf.jabref.BasePanel;
import net.sf.jabref.Util;
import net.sf.jabref.Globals;
import javax.swing.*;
import java.sql.Connection;
import java.awt.event.ActionEvent;
/**
* Created by IntelliJ IDEA.
* User: alver
* Date: Mar 27, 2008
* Time: 6:05:13 PM
* To change this template use File | Settings | File Templates.
*/
public class DbConnectAction extends BaseAction {
private BasePanel panel;
public DbConnectAction(BasePanel panel) {
this.panel = panel;
}
public AbstractAction getAction() {
return new DbImpAction();
}
class DbImpAction extends AbstractAction {
public void actionPerformed(ActionEvent e) {
action();
}
}
public void action() {
DBStrings dbs = panel.metaData().getDBStrings();
// init DB strings if necessary
if (! dbs.isInitialized()) {
dbs.initialize();
}
// show connection dialog
DBConnectDialog dbd = new DBConnectDialog(panel.frame().getFrame(), dbs);
Util.placeDialog(dbd, panel);
dbd.setVisible(true);
// connnect to database to test DBStrings
if (dbd.getConnectToDB()) {
dbs = dbd.getDBStrings();
try {
panel.frame().output(Globals.lang("Establishing SQL connection..."));
Connection conn = SQLutil.connectToDB(dbs);
conn.close();
dbs.isConfigValid(true);
panel.frame().output(Globals.lang("SQL connection established."));
} catch (Exception ex) {
String errorMessage = SQLutil.getExceptionMessage(ex,SQLutil.DBTYPE.MYSQL);
dbs.isConfigValid(false);
String preamble = "Could not connect to SQL database for the following reason:";
panel.frame().output(Globals.lang(preamble)
+ " " + errorMessage);
JOptionPane.showMessageDialog(panel.frame(), Globals.lang(preamble)
+ "\n" + errorMessage, Globals.lang("Connect to SQL database"),
JOptionPane.ERROR_MESSAGE);
} finally {
panel.metaData().setDBStrings(dbs);
dbd.dispose();
}
}
}
}