froehlich 01/11/14 07:54:29
Modified: apps/db/src/java/org/apache/avalon/db/test Tester.java
Log:
working on where statement
Revision Changes Path
1.16 +7 -3
jakarta-avalon-cornerstone/apps/db/src/java/org/apache/avalon/db/test/Tester.java
Index: Tester.java
===================================================================
RCS file:
/home/cvs/jakarta-avalon-cornerstone/apps/db/src/java/org/apache/avalon/db/test/Tester.java,v
retrieving revision 1.15
retrieving revision 1.16
diff -u -r1.15 -r1.16
--- Tester.java 2001/11/13 13:01:24 1.15
+++ Tester.java 2001/11/14 15:54:29 1.16
@@ -65,14 +65,18 @@
System.err.println("SELECT 1");
st = mCon.createStatement();
String select = "<simple-select>" +
- "<columns>*</columns>" +
+ "<columns><column name=\"forename\"/>" +
+ "<column name=\"surname\"/></columns>" +
+ //"<columns>*</columns>" +
"<from><table name=\"Flintstones\"/></from>" +
+
"<where>" +
"<and>" +
- "<condition
expr=\"row.getValue('forename').startsWith('F')\"/>" + //TODO this is too Java
- "<condition
expr=\"row.getValue('forename').length() > 3\"/>" + //TODO this is too Java
+ "<condition expr=\"forename=Wilma\"/>" +
//TODO this is too Java
+ "<condition expr=\"surname=Feuerstein\"/>" +
//TODO this is too Java
"</and>" +
"</where>" +
+
"</simple-select>";
ResultSet rs = st.executeQuery(select);
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
