Package java.sql

Examples of java.sql.ResultSet.last()

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
991
992
993
994
995
996
997
998
999
1000
1001
        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
994
995
996
997
998
999
1000
1001
1002
1003
1004
        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
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
            (ResultSet.TYPE_SCROLL_INSENSITIVE,
             ResultSet.CONCUR_UPDATABLE);
        s.setCursorName(getNextCursorName());
        ResultSet rs = s.executeQuery("select * from t1");
       
        rs.last();
        rs.next();
        int newKey = 0;
        while(rs.previous()) {
            // Update the secondary key of all rows
            rs.updateInt(2, newKey--);
View Full Code Here
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
            (ResultSet.TYPE_SCROLL_INSENSITIVE,
             ResultSet.CONCUR_UPDATABLE);
        s.setCursorName(getNextCursorName());
        ResultSet rs = s.executeQuery("select * from t1");
       
        rs.last();
        int indexedKey = rs.getInt(2);
        PreparedStatement ps =
            prepareStatement("update t1 set a = ? where a= ?");
        ps.setInt(1, -indexedKey);
        ps.setInt(2, indexedKey);
View Full Code Here
1495
1496
1497
1498
1499
1500
1501
1502
1503
1504
1505
        rs.first();
        rs.deleteRow();
        checkDetectabilityCallsOutsideRow(rs, "after deleteRow");

        rs.last();
        rs.deleteRow();
        checkDetectabilityCallsOutsideRow(rs, "after deleteRow of last row");

        rs.close();
        s.close();
View Full Code Here
122
123
124
125
126
127
128
129
130
131
132
                statement = conn.createStatement(
                        ResultSet.TYPE_SCROLL_INSENSITIVE,
                        ResultSet.CONCUR_READ_ONLY);

                rs = statement.executeQuery(queryString);
                if (rs.last()) {
                    count = rs.getRow();
                } else {
                    count = 0;
                }
            } finally {
View Full Code Here
310
311
312
313
314
315
316
317
318
319
320
                    prepareStatement(ClaimDBConstants.GET_CLAIMS_FOR_DIALECTT_SQL);
                    prepStmt.setString(1, dialectUri);
                    prepStmt.setInt(2, tenantId);
                    prepStmt.setInt(3, tenantId);
                    ResultSet rs = prepStmt.executeQuery();
                    rs.last();
                    if(rs.getRow() < 2){
                        throw new UserStoreException("Cannot delete all claim mappings");
                    }
                }
            prepStmt = dbConnection
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
                }
            }
            rs = statement.executeQuery();
            resultSetOutput = new ResultSetOutput(rs, getStartIndex(), getCountOnEachPage());

            rs.last();
            totalCount = rs.getRow();
        } catch (SQLException sqle) {
            //TODO: change to a customize execption
            throw new RuntimeException("Generate report error", sqle);
        } finally {
View Full Code Here
198
199
200
201
202
203
204
205
206
207
208
      // 启始记录位置
      int Offset = 0;
      try {
        Rs = stmt.executeQuery(SQLStatement);
        // 初始化分页对象
        if (Page == 0 && Rs.first() && Rs.last())
        {
          if (Rs.getRow() % rowsPerPage != 0)
            Result.setTotalPage(String.valueOf(Rs.getRow()
                / rowsPerPage + 1));
          else
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.