Package java.sql

Examples of java.sql.ResultSet.updateString()

3305
3306
3307
3308
3309
3310
3311
3312
3313
3314
3315
        Statement stmt = createStatement(
                ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE);
        ResultSet rs = stmt.executeQuery("SELECT * FROM t1");
        assertTrue("FAIL - row not found", rs.next());
        rs.updateInt(1,1234);
        rs.updateString(2,"aaaaa");
        rs.deleteRow();
        try {
            rs.updateRow();
            fail("FAIL - deleteRow should have moved the ResultSet to right" +
                    " before the next row");
View Full Code Here
3384
3385
3386
3387
3388
3389
3390
3391
3392
3393
3394
        rs.updateInt(1,2345);
        // Issue another updateInt on the same row and column to change the
        // column's value to 9999
        rs.updateInt(1,9999);
        // Issue updateString to change the column's value to 'xxxxxxx'
        rs.updateString(2,"xxxxxxx");
        println("  Now issue updateRow");
        rs.updateRow();
        rs.close();
       
        // Make sure that changes made it to the database correctly
View Full Code Here
1650
1651
1652
1653
1654
1655
1656
1657
1658
1659
1660
        ResultSet rs = stmt.executeQuery(
                "SELECT c1, c2 FROM t1 abcde FOR UPDATE of c1");
        assertTrue("FAIL - row not found", rs.next());
        // attempt to update a read only column
        try {
            rs.updateString(2,"bbbb");
            fail("FAIL - updateString on readonly column should have failed");
        } catch (SQLException e) {
            String sqlState = usingEmbedded() ? "42X31" : "XJ124";
            assertSQLState(sqlState, e);
        }
View Full Code Here
1703
1704
1705
1706
1707
1708
1709
1710
1711
1712
1713
                ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE);
        ResultSet rs = stmt.executeQuery(
                "SELECT c1, c2 as col2 FROM t1 abcde FOR UPDATE of c1");
        assertTrue("FAIL - row not found", rs.next());
        try {
            rs.updateString(2,"bbbb");
            fail("FAIL - updateString on readonly column should have failed");
        } catch (SQLException e) {
            String sqlState = usingEmbedded() ? "42X31" : "XJ124";
            assertSQLState(sqlState, e);
        }
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
            assertEquals(16, rs.getInt(1));
            assertTrue(rs.absolute(8));
            assertEquals(8, rs.getInt(1));
            assertTrue(rs.relative(-1));
            assertEquals(7, rs.getInt(1));
            rs.updateString(3, "New line 7");
            rs.updateRow();
//            assertTrue(rs.rowUpdated()); // MS API cursors appear not to support this
            rs.moveToInsertRow();
            rs.updateInt(1, 17);
            rs.updateString(2, "XXXX");
View Full Code Here
80
81
82
83
84
85
86
87
88
89
90
            rs.updateString(3, "New line 7");
            rs.updateRow();
//            assertTrue(rs.rowUpdated()); // MS API cursors appear not to support this
            rs.moveToInsertRow();
            rs.updateInt(1, 17);
            rs.updateString(2, "XXXX");
            rs.updateString(3, "LINE 17");
            rs.insertRow();
            rs.moveToCurrentRow();
            rs.last();
//            assertTrue(rs.rowInserted()); // MS API cursors appear not to support this
View Full Code Here
81
82
83
84
85
86
87
88
89
90
91
            rs.updateRow();
//            assertTrue(rs.rowUpdated()); // MS API cursors appear not to support this
            rs.moveToInsertRow();
            rs.updateInt(1, 17);
            rs.updateString(2, "XXXX");
            rs.updateString(3, "LINE 17");
            rs.insertRow();
            rs.moveToCurrentRow();
            rs.last();
//            assertTrue(rs.rowInserted()); // MS API cursors appear not to support this
            Statement stmt2 = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
View Full Code Here
166
167
168
169
170
171
172
173
174
175
176
             rs = stmt.executeQuery("SELECT id, data FROM jTDS_CachedCursorTest");
             Statement stmt2 = con2.createStatement();
             while (rs.next()) {
                 if (rs.getInt(1) == 1) {
                     assertEquals(1, stmt2.executeUpdate("UPDATE jTDS_CachedCursorTest SET data = 'NEW VALUE' WHERE id = 1"));
                     rs.updateString(2, "TEST UPDATE");
                     try {
                         rs.updateRow();
                         assertNotNull(rs.getWarnings());
                         assertEquals("Expected optimistic update exception",
                                 "24000", rs.getWarnings().getSQLState());
View Full Code Here
202
203
204
205
206
207
208
209
210
211
212
            stmt.executeUpdate("INSERT INTO ##TESTNOKEY VALUES("+i+", 'Test line "+i+"')");
        }
        ResultSet rs = stmt.executeQuery("SELECT * FROM ##TESTNOKEY");
        assertTrue(rs.next());
        assertTrue(rs.next());
        rs.updateString(2, "UPDATED");
        rs.updateRow();
        rs.close();
        rs = stmt.executeQuery("SELECT * FROM ##TESTNOKEY");
        while (rs.next()) {
            if (rs.getInt(1) == 1) {
View Full Code Here
283
284
285
286
287
288
289
290
291
292
293
        stmt = con.createStatement(
                ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
        rs = stmt.executeQuery("select * from #testColumnCollations");
        assertTrue(rs.next());
        for (int i = 2; i <= 10; i++) {
            rs.updateString(i, rs.getString(i) + "updated");
            values[i - 2] = values[i - 2] + "updated";
        }
        rs.updateRow();
        for (int i = 2; i <= 10; i++) {
            assertEquals("Column " + i + " doesn't match", values[i - 2], rs.getString(i));
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.