Package java.sql

Examples of java.sql.ResultSet.last()

62
63
64
65
66
67
68
69
70
71
72
                                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
121
122
123
124
125
126
127
128
129
130
131
                                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
182
183
184
185
186
187
188
189
190
191
192
                                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
244
245
246
247
248
249
250
251
252
253
254
        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
467
468
469
470
471
472
473
474
475
476
477
        assertTrue(!rs.next());
        assertTrue(!rs.next());
        assertTrue(!rs.next());
        assertTrue(!rs.previous());
        assertTrue(!rs.first());
        assertTrue(!rs.last());
        assertEquals(0, rs.getRow());
        assertTrue(!rs.absolute(1));
        assertTrue(!rs.relative(1));
        assertTrue(!rs.isBeforeFirst());
        assertTrue(!rs.isAfterLast());
View Full Code Here
577
578
579
580
581
582
583
584
585
586
587
        catch (SQLException e)
        {
        }
        try
        {
            rs.last();
            fail("last() on a TYPE_FORWARD_ONLY resultset did not throw an exception");
        }
        catch (SQLException e)
        {
        }
View Full Code Here
153
154
155
156
157
158
159
160
161
162
163
        Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
        ResultSet rs = stmt.executeQuery("SELECT * FROM testrs where id=100");
        rs.beforeFirst();
        rs.afterLast();
        assertTrue(!rs.first());
        assertTrue(!rs.last());
        assertTrue(!rs.next());
    }

    public void testMaxFieldSize() throws SQLException
    {
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
        query+=getSiteAttrSubquery(rs.getString("name"),rs.getString("id"));
      }
      query+=" from mote m, site s " +
             " where s.id=m.site_id";
      rs = sql.retrieve(query, param);
      rs.last();
      int rows = rs.getRow();
      int cols = rs.getMetaData().getColumnCount();
      result = new SimpleTable(rows,cols);
      rs.beforeFirst();
View Full Code Here
172
173
174
175
176
177
178
179
180
181
182
      ResultSet rs = conn.createStatement(
          ResultSet.TYPE_SCROLL_INSENSITIVE,
          ResultSet.CONCUR_READ_ONLY).executeQuery(
          "SELECT e.id FROM Employee e ORDER BY e.id");

      rs.last();
      int rowCount = rs.getRow();
      idList = new int[rowCount];
      rs.first();

      int i = 0;
View Full Code Here
102
103
104
105
106
107
108
109
110
111
112
            Statement statement = conn.createStatement(
                    ResultSet.TYPE_SCROLL_INSENSITIVE,
                    ResultSet.CONCUR_READ_ONLY);

            ResultSet rs = statement.executeQuery(queryString);
            if (rs.last()) {
                count = rs.getRow();
            } else {
                count = 0;
            }
            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.