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]>