Package java.sql

Examples of java.sql.ResultSet.updateString()

428
429
430
431
432
433
434
435
436
437
438
    try {
      while (rs.next()) {
        int idx = 1;
        for (Object v : newVals) {
          if (v instanceof String)
            rs.updateString(idx++, (String) v);
          else if (v instanceof Boolean)
            rs.updateBoolean(idx++, (Boolean) v);
          else if (v instanceof Long)
            rs.updateLong(idx++, (Long) v);
          else
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
            rs.updateRow();
            rs.absolute(11);
            rs.deleteRow();
            rs.moveToInsertRow();
            rs.updateInt(1, 1011);
            rs.updateString(2, "INSERT1011");
            rs.updateString(3, "0101");
            rs.insertRow();
            rs.close();

            rs = st.executeQuery(s);
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
            rs.absolute(11);
            rs.deleteRow();
            rs.moveToInsertRow();
            rs.updateInt(1, 1011);
            rs.updateString(2, "INSERT1011");
            rs.updateString(3, "0101");
            rs.insertRow();
            rs.close();

            rs = st.executeQuery(s);
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
            ResultSet rs = ps.executeQuery();

            while (rs.next()) {
                String s = rs.getString(2);

                rs.updateString(2, s + s);
                rs.updateRow();
            }

            rs.close();
View Full Code Here
68
69
70
71
72
73
74
75
76
77
78
            s = "SELECT * FROM T";

            ResultSet rs = st.executeQuery(s);

            rs.absolute(10);
            rs.updateString(2, "UPDATE10");
            rs.updateRow();
            rs.absolute(11);
            rs.deleteRow();
            rs.moveToInsertRow();
            rs.updateInt(1, 1011);
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
            while (rs.next()) {
                // note, this is guaranteed to be non-null and valid
                String path = rs.getString(2);
                String dir = getDir(path);
                rs.updateString(3, dir);
                rs.updateRow();
            }
        } finally {
            databaseType.closeStatement(s);
        }
View Full Code Here
576
577
578
579
580
581
582
583
584
585
586
        ResultSet rset = stmt.executeQuery("SELECT * FROM USER_INFO");
        assertTrue(rset.first());
        assertEquals(1, rset.getInt(1));
        rset.moveToInsertRow();
        rset.updateInt(1, 5);
        rset.updateString(2, "insert5");
        rset.insertRow();
        rset.moveToCurrentRow();
        assertEquals(1, rset.getInt(1));
        assertTrue(rset.last());
        assertEquals(5, rset.getInt(1));
View Full Code Here
589
590
591
592
593
594
595
596
597
598
599
         * Because the above called rset.last(), the inserted row which ID is 6
         * becomes invisible to JdbcRowSet.
         */
        rset.moveToInsertRow();
        rset.updateInt(1, 6);
        rset.updateString(2, "insert6");
        rset.insertRow();
        rset.moveToCurrentRow();

        int index = 0;
        rset.beforeFirst();
View Full Code Here
152
153
154
155
156
157
158
159
160
161
162
                ResultSet.CONCUR_UPDATABLE);
        ResultSet rs = s.executeQuery(SELECT_STMT);
        rs.next();

        for (int i = 1; i <= COLUMNS; i++) {
            rs.updateString(i, "2");
            assertEquals("Expected rs.getDouble(" + i +
                         ") to match updated value", 2, (int) rs.getDouble(i));
        }
        rs.updateRow();
        rs.close();
View Full Code Here
145
146
147
148
149
150
151
152
153
154
155
                ResultSet.CONCUR_UPDATABLE);
        ResultSet rs = s.executeQuery(SELECT_STMT);
        rs.next();

        for (int i = 1; i <= COLUMNS; i++) {
            rs.updateString(i, "2");
            assertEquals("Expected rs.getDouble(" + i +
                         ") to match updated value", 2, (int) rs.getDouble(i));
        }
        rs.updateRow();
        rs.close();
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.