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 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.
         */

         */
        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));

        filteredRowSet.setUrl(DERBY_URL);


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


        Predicate filter = new OddRowFilter();


        filteredRowSet.setFilter(filter);


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

Examples of javax.sql.rowset.Predicate

Related Classes of javax.sql.rowset.Predicate