Package javax.sql.rowset

Examples of javax.sql.rowset.WebRowSet.populate()

83
84
85
86
87
88
89
90
91
92
93
            if (limit > -1) {
                result.setPageSize(limit);
                result.setMaxRows(limit);
            }

            result.populate(resultSet, start < 0 ? 1 : start + 1);
        }

        return result;
    }
View Full Code Here
349
350
351
352
353
354
355
356
357
358
359
        /*
         * Test WebRowSet filled with data
         */
        jrs = newJoinRowSet();
        webRs = newWebRowSet();
        webRs.populate(st.executeQuery("SELECT * FROM USER_INFO"));
        webRs.setMatchColumn(1);
        jrs.addRowSet(webRs);
        assertTrue(jrs.next());
        assertEquals(1, jrs.getInt(1));
        jrs.close();
View Full Code Here
381
382
383
384
385
386
387
388
389
390
391
        /*
         * Test non-empty WebRowSet.
         */
        jrs = newJoinRowSet();
        webRs = newWebRowSet();
        webRs.populate(st.executeQuery("SELECT * FROM USER_INFO"));
        jrs.addRowSet(webRs, 1);
        assertTrue(jrs.next());
        assertEquals(1, jrs.getInt(1));
        jrs.close();
    }
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
        preStmt.executeUpdate();
        preStmt.close();

        WebRowSet webRs = newWebRowSet();
        rs = st.executeQuery("SELECT * FROM USER_INFO");
        webRs.populate(rs);
        webRs.writeXml(strWriter);
        assertTrue(webRs.last());
        assertEquals(unicodeChar, webRs.getString(2));
        assertFalse(-1 == strWriter.toString().indexOf(unicodeChar));

View Full Code Here
96
97
98
99
100
101
102
103
104
105
106
         * metadata remains the same. Only four new rows which are the same as
         * the original data in WebRowSet are added.
         */
        WebRowSet webRs = newWebRowSet();
        rs = st.executeQuery("SELECT * FROM USER_INFO");
        webRs.populate(rs);
        ResultSetMetaData meta = webRs.getMetaData();
        // register listener
        Listener listener = new Listener();
        webRs.addRowSetListener(listener);
        assertNull(listener.getTag());
View Full Code Here
142
143
144
145
146
147
148
149
150
151
152
        }
        assertEquals(2, index);
        rs = st.executeQuery("SELECT * FROM CUSTOMER_INFO");
        webRs.beforeFirst();
        listener.clear();
        webRs.populate(rs);
        assertEquals(CachedRowSetListenerTest.EVENT_ROWSET_CHANGED, listener
                .getTag());
        webRs.beforeFirst();
        index = 0;
        /*
 
View Full Code Here
179
180
181
182
183
184
185
186
187
188
189
    }

    public void testWriteXML() throws Exception {
        WebRowSet webRs = newWebRowSet();
        rs = st.executeQuery("SELECT * FROM USER_INFO");
        webRs.populate(rs);

        Map<String, Class<?>> map = new HashMap<String, Class<?>>();
        map.put("VARCHAR", String.class);
        map.put("Array", Array.class);
        webRs.setTypeMap(map);
View Full Code Here
218
219
220
221
222
223
224
225
226
227
228
        assertMetadata(doc, webRs);
        assertData(doc, webRs);

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

        strWriter = new StringWriter();
        webRs.writeXml(strWriter);

        doc = getDocument(strWriter);
View Full Code Here
232
233
234
235
236
237
238
239
240
241
242
    }

    public void testWriteXML_Update() throws Exception {
        WebRowSet webRs = newWebRowSet();
        rs = st.executeQuery("SELECT * FROM USER_INFO");
        webRs.populate(rs);

        webRs.absolute(3);
        webRs.updateString(2, "update3");

        webRs.writeXml(strWriter);
View Full Code Here
264
265
266
267
268
269
270
271
272
273
274
    }

    public void testWriteXML_Insert() throws Exception {
        WebRowSet webRs = newWebRowSet();
        rs = st.executeQuery("SELECT * FROM USER_INFO");
        webRs.populate(rs);

        webRs.moveToInsertRow();
        webRs.updateString(2, "update3");
        webRs.updateInt(4, 3);
        webRs.moveToCurrentRow();
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.