Examples of javax.sql.rowset.Predicate

javax.sql.rowset.Predicate
k the present row determine if it lies // within the filtering criteria. for (int i = 0; i < idx.length; i++) { int value; try { value = (Integer) rs.getObject(idx[i]); } catch (SQLException ex) { Logger.getLogger(Range.class.getName()).log(Level.SEVERE, null, ex); return false; } if (value < lo[i] && value> hi[i]) { // outside of filter constraints return false; } } // Within filter constraints return true; } } }
The example above implements a simple range predicate. Note, that implementations should but are not required to provide String and integer index based constructors to provide for JDBC RowSet Implementation applications that use both column identification conventions. @author Jonathan Bruce, Amit Handa

    public void testCreateShared() throws Exception {
        FilteredRowSet filteredRowSet = newFilterRowSet();
        rs = st.executeQuery("SELECT * FROM USER_INFO");
        filteredRowSet.populate(rs);


        Predicate range = new RangeOne();
        filteredRowSet.setFilter(range);


        FilteredRowSet copyFilteredRs = (FilteredRowSet) filteredRowSet
                .createShared();
        assertSame(range, copyFilteredRs.getFilter());

View Full Code Here

    public void testCreateCopy() throws Exception {
        FilteredRowSet filteredRowSet = newFilterRowSet();
        rs = st.executeQuery("SELECT * FROM USER_INFO");
        filteredRowSet.populate(rs);


        Predicate range = new RangeOne();
        filteredRowSet.setFilter(range);


        if ("true".equals(System.getProperty("Testing Harmony"))) {
            filteredRowSet.createCopy();
        } else {

View Full Code Here

        filteredRowSet.populate(rs);


        /*
         * Set Filter: RangeOne
         */
        Predicate range = new RangeOne();
        filteredRowSet.setFilter(range);
        filteredRowSet.beforeFirst();
        int index = 0;
        while (filteredRowSet.next()) {
            index++;

View Full Code Here

        rs = st.executeQuery("SELECT * FROM USER_INFO");
        filteredRowSet.populate(rs);


        filteredRowSet.next();
        assertEquals(1, filteredRowSet.getRow());
        Predicate range = new RangeOne();
        filteredRowSet.setFilter(range);


        // not filtered
        assertEquals(1, filteredRowSet.getRow());
        assertEquals("hermit", filteredRowSet.getString(2));

View Full Code Here

    public void testFilter_Insert() throws Exception {
        FilteredRowSet filteredRowSet = newFilterRowSet();
        rs = st.executeQuery("SELECT * FROM USER_INFO");
        filteredRowSet.populate(rs);


        Predicate range = new RangeOne();
        filteredRowSet.setFilter(range);


        /*
         * Insert a row. when call updateXXX(), evaluate(Object value, int
         * column) is called to check first.

View Full Code Here

    public void testFilter_Update() throws Exception {
        FilteredRowSet filteredRowSet = newFilterRowSet();
        rs = st.executeQuery("SELECT * FROM USER_INFO");
        filteredRowSet.populate(rs);


        Predicate range = new RangeOne();
        filteredRowSet.setFilter(range);


        /*
         * Update the third row. Filter has no effect here.
         */

View Full Code Here

         */
        assertTrue(filteredRowSet.first());
        assertEquals(1, filteredRowSet.getInt(1));
        filteredRowSet.deleteRow();


        Predicate range = new RangeOne();
        filteredRowSet.setFilter(range);


        assertTrue(filteredRowSet.first());
        assertEquals(2, filteredRowSet.getInt(1));

View Full Code Here

        filteredRowSet.setUrl(DERBY_URL);


        filteredRowSet.setPageSize(3);
        filteredRowSet.execute();


        Predicate filter = new OddRowFilter();


        filteredRowSet.setFilter(filter);


        assertEquals("select * from USER_INFO", filteredRowSet.getCommand());

View Full Code Here

         * Test FilteredRowSet filled with data and Filter
         */
        jrs = newJoinRowSet();
        filteredRs = newFilterRowSet();
        filteredRs.populate(st.executeQuery("SELECT * FROM USER_INFO"));
        Predicate range = new RangeOne();
        filteredRs.setFilter(range);
        if ("true".equals(System.getProperty("Testing Harmony"))) {
            jrs.addRowSet(filteredRs, 1);
        } else {
            try {

View Full Code Here

    public void testCreateShared() throws Exception {
        FilteredRowSet filteredRowSet = newFilterRowSet();
        rs = st.executeQuery("SELECT * FROM USER_INFO");
        filteredRowSet.populate(rs);


        Predicate range = new RangeOne();
        filteredRowSet.setFilter(range);


        FilteredRowSet copyFilteredRs = (FilteredRowSet) filteredRowSet
                .createShared();
        assertSame(range, copyFilteredRs.getFilter());

View Full Code Here

0 1 2 3

TOP

Related Classes of javax.sql.rowset.Predicate

org.apache.harmony.sql.tests.internal.rowset.FilteredRowSetTest

org.apache.harmony.sql.tests.internal.rowset.JoinRowSetTest

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.