Package java.sql

Examples of java.sql.ResultSet.last()

69
70
71
72
73
74
75
76
77
78
79
                                ResultSet.CONCUR_UPDATABLE);
        final ResultSet rs =
            stmt.executeQuery("SELECT * from " +
                              BLOBDataModelSetup.getBlobTableName());
        println("Last");
        rs.last();
       
        final int newVal = rs.getInt(1) + 11;
        final int newSize = rs.getInt(2) / 2;
        testUpdateBlobWithResultSetMethods(rs, newVal, newSize);
       
View Full Code Here
128
129
130
131
132
133
134
135
136
137
138
                                ResultSet.CONCUR_UPDATABLE);
        final ResultSet rs =
            stmt.executeQuery("SELECT * from " +
                              BLOBDataModelSetup.getBlobTableName());
        println("Last");
        rs.last();
       
        final int newVal = rs.getInt(1) + 11;
        final int newSize = rs.getInt(2) / 2;
        testUpdateBlobWithPositionedUpdate(rs, newVal, newSize);

View Full Code Here
189
190
191
192
193
194
195
196
197
198
199
                                ResultSet.CONCUR_UPDATABLE);
        final ResultSet rs =
            stmt.executeQuery("SELECT data,val,length from " +
                              BLOBDataModelSetup.getBlobTableName());
        println("Last");
        rs.last();
       
        final int newVal = rs.getInt(2) + 11;
        final int newSize = rs.getInt(3) / 2;
        testUpdateBlobWithResultSetMethods(rs, newVal, newSize);
       
View Full Code Here
251
252
253
254
255
256
257
258
259
260
261
        final ResultSet rs =
            stmt.executeQuery("SELECT data from " +
                              BLOBDataModelSetup.getBlobTableName() +
                              " WHERE val= " + BLOBDataModelSetup.bigVal);
        println("Last");
        rs.last();
       
        final int newVal = BLOBDataModelSetup.bigVal * 2;
        final int newSize = BLOBDataModelSetup.bigSize / 2;
        testUpdateBlobWithPositionedUpdate(rs, newVal, newSize);

View Full Code Here
846
847
848
849
850
851
852
853
854
855
856
            (ResultSet.TYPE_SCROLL_INSENSITIVE,
             ResultSet.CONCUR_UPDATABLE);
        s.setCursorName(getNextCursorName());
        ResultSet rs = s.executeQuery("select * from t1");
       
        rs.last();
        rs.next();
        while(rs.previous()) {
            // Update the key of every second row.
            int key = rs.getInt(1);
            if (key%2==0) {
View Full Code Here
889
890
891
892
893
894
895
896
897
898
899
            (ResultSet.TYPE_SCROLL_INSENSITIVE,
             ResultSet.CONCUR_UPDATABLE);
        s.setCursorName(getNextCursorName());
        ResultSet rs = s.executeQuery("select * from t1");
       
        rs.last();
        int primaryKey = rs.getInt(1);
        PreparedStatement ps = prepareStatement
            ("update t1 set id = ? where id= ?");
        ps.setInt(1, -primaryKey);
        ps.setInt(2, primaryKey);
View Full Code Here
935
936
937
938
939
940
941
942
943
944
945
            (ResultSet.TYPE_SCROLL_INSENSITIVE,
             ResultSet.CONCUR_UPDATABLE);
        s.setCursorName(getNextCursorName());
        ResultSet rs = s.executeQuery("select * from t1");
       
        rs.last();
        int primaryKey = rs.getInt(1);
        PreparedStatement ps = prepareStatement
            ("update t1 set id = ? where id= ?");
        ps.setInt(1, -primaryKey);
        ps.setInt(2, primaryKey);
View Full Code Here
978
979
980
981
982
983
984
985
986
987
988
            (ResultSet.TYPE_SCROLL_INSENSITIVE,
             ResultSet.CONCUR_UPDATABLE);
        s.setCursorName(getNextCursorName());
        ResultSet rs = s.executeQuery("select * from t1");
       
        rs.last();
        int primaryKey = rs.getInt(1);
        PreparedStatement ps = s.getConnection().prepareStatement
            ("update t1 set id = ? where id= ?");
        ps.setInt(1, -primaryKey);
        ps.setInt(2, primaryKey);
View Full Code Here
992
993
994
995
996
997
998
999
1000
1001
1002
        rs.updateInt(1, primaryKey*10);
        rs.updateInt(2, -555);
        rs.updateInt(3, -777);
        rs.updateRow();
        rs.first();
        rs.last();
        for (int i=0; i<10; i++) {
            rs.first();
            rs.last();
            rs.next();
            rs.previous();
View Full Code Here
995
996
997
998
999
1000
1001
1002
1003
1004
1005
        rs.updateRow();
        rs.first();
        rs.last();
        for (int i=0; i<10; i++) {
            rs.first();
            rs.last();
            rs.next();
            rs.previous();
            rs.updateInt(1, primaryKey*10 +i);
            rs.updateInt(2, (-555 -i));
            rs.updateInt(3, (-777 -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.