froehlich 01/11/09 15:32:04
Modified: apps/db/src/java/org/apache/avalon/db/test TestGUI.java
Log:
some changes to get the <simple-select> enabled
Revision Changes Path
1.5 +21 -12
jakarta-avalon-cornerstone/apps/db/src/java/org/apache/avalon/db/test/TestGUI.java
Index: TestGUI.java
===================================================================
RCS file:
/home/cvs/jakarta-avalon-cornerstone/apps/db/src/java/org/apache/avalon/db/test/TestGUI.java,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- TestGUI.java 2001/11/08 23:47:02 1.4
+++ TestGUI.java 2001/11/09 23:32:04 1.5
@@ -17,6 +17,7 @@
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.SQLException;
+import java.util.Vector;
import javax.swing.*;
@@ -53,16 +54,6 @@
protected DocumentBuilderFactory docBuilderFactory;
protected DocumentBuilder docBuilder;
- public TestGUI() {
- setupDBDriver();
- try {
- docBuilderFactory = DocumentBuilderFactory.newInstance();
- docBuilder = docBuilderFactory.newDocumentBuilder();
- } catch (ParserConfigurationException e) {
- handleException(e);
- }
- }
-
public Component createComponents() {
outputArea.setEditable(false);
@@ -108,8 +99,15 @@
} else if (action.equals("insert-into")) {
outputArea.setText("Row inserted!");
int returnUpdate =
statement.executeUpdate(inputArea.getText());
- } else {
- outputArea.setText("Query not implemented yet!");
+ } else if (action.equals("simple-select")){
+ outputArea.setText("simple-select fired!");
+ ResultSet rs =
statement.executeQuery(inputArea.getText());
+ Vector vector = new Vector();
+ int rowcounter = 0;
+ while(rs.next()) {
+ rowcounter++;
+ }
+ outputArea.setText(rowcounter + " rows
fetched!");
}
statement.close();
} catch (SQLException slqe) {
@@ -199,6 +197,8 @@
frame.setSize(450, 330);
frame.setVisible(true);
frame.setResizable(false);
+ app.setupDBDriver();
+ app.setupParser();
}
private void setupDBDriver() {
@@ -233,6 +233,15 @@
} catch(IOException ioe) {
handleException(ioe);
return "";
+ }
+ }
+
+ private void setupParser() {
+ try {
+ docBuilderFactory = DocumentBuilderFactory.newInstance();
+ docBuilder = docBuilderFactory.newDocumentBuilder();
+ } catch (ParserConfigurationException e) {
+ handleException(e);
}
}
}
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
