querytest.java

这个是perst-269.zip下面的SOURCECODE,和大家分享了。

     * <li>no exceptions are thrown.</li>
     * <li><code>select(...)</code> returned two expected objects.</li>
     * </ul>
     */
    public void test08() {
        Vector v = new Vector();
        Stored tc = new Stored(5, "t");
        Stored tc1= new Stored(6, "t");
        v.add(tc );
        v.add(tc1);
        Iterator i = query.select(Stored.class, v.iterator(), "i<10");
        for(int idx=0; idx<2; idx++){
            Object curr = i.next();
            assertNotNull(curr);
            if(curr==tc){
                tc = null;
            }else
            if (curr == tc1) {
                tc1 = null;
            }else{
                fail();
            }
        }
        assertFalse(i.hasNext());
    }

    /**
     * <B>Goal:</B> To verify the functionality of the <CODE>select</CODE> method.
     * <P>
     * <B>Conditions:</B>
     * <ul>
     * <li>two suitable object in iterator(one object of derived class
     * <code>StoredEX</code>).</li>
     * <li><code>select(Class clazz, Iterator iter, "i<10")</code> invoked.</li>
     * </ul>
     * <P>
     * <B>Result:</B>
     * <ul>
     * <li>no exceptions are thrown.</li>
     * <li><code>select(...)</code> returned two expected objects.</li>
     * </ul>
     */
    public void test09() {
        Vector v = new Vector();
        Stored tc = new Stored(5, "t");
        Stored tc1 = new StoredEx(6, "t", 25);
        v.add(tc);
        v.add(tc1);
        Iterator i = query.select(Stored.class, v.iterator(), "i<10");
        for (int idx = 0; idx < 2; idx++) {
            Object curr = i.next();
            assertNotNull(curr);
            if (curr == tc) {
                tc = null;
            } else if (curr == tc1) {
                tc1 = null;
            } else {
                fail();
            }
        }
        assertFalse(i.hasNext());
    }

    /**
     * <B>Goal:</B> To verify the functionality of the <CODE>select</CODE> method.
     * <P>
     * <B>Conditions:</B>
     * <ul>
     * <li>two suitable objects in iterator.</li>
     * <li><code>select(StoredEx.class, Iterator iter, "i<10")</code> invoked<br>
     * (field <i>i</i> defined in base class <code>Stored</code>).</li>
     * </ul>
     * <P>
     * <B>Result:</B>
     * <ul>
     * <li>no exceptions are thrown.</li>
     * <li><code>select(...)</code> returned two expected objects.</li>
     * </ul>
     */
    public void test10() {
        Vector v = new Vector();
        Stored tc = new Stored(5, "t");
        Stored tc1 = new StoredEx(6, "t", 25);
        v.add(tc);
        v.add(tc1);
        Iterator i = query.select(StoredEx.class, v.iterator(), "i<10");
        for (int idx = 0; idx < 2; idx++) {
            Object curr = i.next();
            assertNotNull(curr);
            if (curr == tc) {
                tc = null;
            } else if (curr == tc1) {
                tc1 = null;
            } else {
                fail();
            }
        }
        assertFalse(i.hasNext());
    }

    /**
     * <B>Goal:</B> To verify the functionality of the <CODE>prepare(...)</CODE> and
     * <code>execute(...)</code> methods.
     * <P>
     * <B>Conditions:</B>
     * <ul>
     * <li>two suitable objects in iterator.</li>
     * <li><code>select(Stored.class, Iterator iter, "i<10")</code> invoked.</li>
     * </ul>
     * <P>
     * <B>Result:</B>
     * <ul>
     * <li>no exceptions are thrown.</li>
     * <li><code>select(...)</code> returned two expected objects.</li>
     * </ul>
     */
    public void test11() {
        Vector v = new Vector();
        Stored tc = new Stored(5, "t");
        Stored tc1 = new Stored(6, "t");
        v.add(tc);
        v.add(tc1);
        query.prepare(Stored.class, "i<10");
        Iterator i = query.execute(v.iterator());
        for (int idx = 0; idx < 2; idx++) {
            Object curr = i.next();
            assertNotNull(curr);
            if (curr == tc) {
                tc = null;
            } else if (curr == tc1) {
                tc1 = null;
            } else {
                fail();
            }
        }
        assertFalse(i.hasNext());
    }

    /**
     * <B>Goal:</B> To verify the functionality of the <CODE>select(...)</CODE> method.
     * <P>
     * <B>Conditions:</B>
     * <ul>
     * <li>one suitable object in iterator.</li>
     * <li><code>select(Stored.class, Iterator iter, "s like '%t%'")</code> invoked.</li>
     * </ul>
     * <P>
     * <B>Result:</B>
     * <ul>
     * <li>no exceptions are thrown.</li>
     * <li><code>select(...)</code> returned expected object.</li>
     * </ul>
     */
    public void test12() {
        Vector v = new Vector();
        Stored tc = new Stored(5, "t");
        v.add(tc);
        Iterator i = query.select(Stored.class, v.iterator(), "s like '%t%'");
        assertEquals(tc, i.next());
        assertFalse(i.hasNext());
    }

    /**
     * <B>Goal:</B> To verify the functionality of the <CODE>select(...)</CODE> method.
     * <P>
     * <B>Conditions:</B>
     * <ul>
     * <li>one suitable object in iterator.</li>
     * <li><code>select(Stored.class, Iterator iter, "s like '%t%'")</code> invoked.</li>
     * </ul>
     * <P>
     * <B>Result:</B>
     * <ul>
     * <li>no exceptions are thrown.</li>
     * <li><code>select(...)</code> returned expected object.</li>
     * </ul>
     */
    public void test13() {
        Vector v = new Vector();
        Stored tc = new Stored(5, "123t456");
        v.add(tc);
        Iterator i = query.select(StoredEx.class, v.iterator(), "s like '%t%'");
        assertEquals(tc, i.next());
        assertFalse(i.hasNext());
    }

    /**
     * <B>Goal:</B> To verify the functionality of the <CODE>select(...)</CODE> method.
     * <P>
     * <B>Conditions:</B>
     * <ul>
     * <li>one suitable object in iterator.</li>
     * <li><code>select(Stored.class, Iterator iter, "s like '123%456'")</code> invoked.</li>
     * </ul>
     * <P>
     * <B>Result:</B>
     * <ul>
     * <li>no exceptions are thrown.</li>
     * <li><code>select(...)</code> returned expected object.</li>
     * </ul>
     */
    public void test14() {
        Vector v = new Vector();
        Stored tc = new Stored(5, "123t456");
        v.add(tc);
        Iterator i = query.select(StoredEx.class, v.iterator(), "s like '123%456'");
        assertEquals(tc, i.next());
        assertFalse(i.hasNext());
    }

    /**
     * <B>Goal:</B> To verify the functionality of the <CODE>select(...)</CODE> method.
     * <P>
     * <B>Conditions:</B>
     * <ul>
     * <li>two suitable objects in iterator.</li>
     * <li><code>select(Stored.class, Iterator iter, "i=5 or i=10")</code> invoked.</li>
     * </ul>
     * <P>
     * <B>Result:</B>
     * <ul>
     * <li>no exceptions are thrown.</li>
     * <li><code>select(...)</code> returned two expected objects.</li>
     * </ul>
     */
    public void test15() {
        Vector v = new Vector();
        Stored[] tcs = {new Stored(5, ""), new Stored(10, "")};
        for (Stored tc : tcs) {
            v.add(tc);
        }
        Iterator i = query.select(StoredEx.class, v.iterator(), "i=5 or i=10");
        checkIteratorContains(i, tcs);
    }

    /**
     * <B>Goal:</B> To verify the functionality of the <CODE>select(...)</CODE> method.
     * <P>
     * <B>Conditions:</B>
     * <ul>
     * <li>two suitable objects in iterator.</li>
     * <li><code>select(Stored.class, Iterator iter, "")</code> invoked.</li>
     * </ul>
     * <P>
     * <B>Result:</B>
     * <ul>
     * <li>no exceptions are thrown.</li>
     * <li><code>select(...)</code> returned two expected objects.</li>
     * </ul>
     */
    public void test16() {
        Vector v = new Vector();
        Stored[] tcs = {new Stored(5, ""), new Stored(10, "")};
        for (Stored tc : tcs) {
            v.add(tc);
        }
        Iterator i = query.select(StoredEx.class, v.iterator(), "");
        checkIteratorContains(i, tcs);
    }
    /**
     * Internal classes.
     */
    private class Stored extends Persistent{
        int i;
        String s;
        Stored(int i, String s){
            this.i = i;
            this.s = s;
        }
        public Stored(){}
        int getI(){
            return i;
        }
    }

    private class StoredEx extends Stored{
        int ex;
        StoredEx(int i, String s, int ex) {
            super(i, s);
            this.ex = ex;
        }
        public StoredEx() {}
    }
}