Package java.sql

Examples of java.sql.ResultSet.last()

207
208
209
210
211
212
213
214
215
216
217
        assertTrue(rs.first());
        assertEquals(1, rs.getInt(1));
        assertEquals(1, rs.getRow());

        assertTrue(rs.last());
        assertEquals(3, rs.getInt(1));
        assertEquals(3, rs.getRow());

        assertTrue(rs.relative(0));
        assertEquals(3, rs.getRow());
View Full Code Here
516
517
518
519
520
521
522
523
524
525
526
            if (!error) {
                throw e;
            }
        }
        try {
            boolean valid = rs.last();
            assertEquals(rows > 0, valid);
            if (valid) {
                assertState(rs, false, rows == 1, true, rows == 0);
            }
        } catch (SQLException e) {
View Full Code Here
184
185
186
187
188
189
190
191
192
193
194
            prep.setString(2, "" + i / 200);
            prep.execute();
        }
        Statement s2 = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
        rs = s2.executeQuery("SELECT NAME FROM DATA");
        rs.last();
        conn.setAutoCommit(true);

        rs = s2.executeQuery("SELECT NAME FROM DATA ORDER BY ID");
        while (rs.next()) {
            // do nothing
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
        try {
            //statement = connection.createStatement();
            statement = connection.prepareStatement(RETRIEVE, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            statement.setInt(1, sessionID);
            results = statement.executeQuery();
            results.last();
            headingsCount = results.getRow();
            headings = new String[headingsCount];
            results.beforeFirst();
            while (results.next()) {
                headings[results.getInt("position")] = results.getString("name");
View Full Code Here
36
37
38
39
40
41
42
43
44
45
46
    try {
      // Send query to database and store results.
      rs = pstmt.executeQuery();

      if (rs.next()) {
        rs.last();
        returnTypeList = new ArrayList<ReturnType>(rs.getRow());
        rs.beforeFirst();

        while (rs.next()) {
          returnTypeList.add(beanPopulator.populate(rs));
View Full Code Here
119
120
121
122
123
124
125
126
127
128
129
      DatabaseMetaData meta = connection.getMetaData();

      rs = meta.getColumns(null, null, selectedTable, null);

      rs.last();

      return rs.getRow();

    } finally {
      closeResultSet(rs);
View Full Code Here
123
124
125
126
127
128
129
130
131
132
133
                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
414
415
416
417
418
419
420
421
422
423
424
      out.print(_$6092);
      boolean flag3 = UserModel.isAdminLoginned(request);
      boolean flag4 = UserModel.isSourceBrowser(request);
      boolean flag5 = k == 0;
      boolean flag6 = k != 0;
      if (flag5 && resultset1.first() || !flag5 && resultset1.last())
        do
        {
          i = resultset1.getInt("solution_id");
          if (i > k1)
            k1 = i;
View Full Code Here
300
301
302
303
304
305
306
307
308
309
310
                rs.getInt(3) + ")");
        rs.updateInt(2, 3);
        println("T1: updateInt(2, 3);");
        rs.updateRow();
        println("T1: updateRow()");
        rs.last(); // Go to last tuple
        println("T1: Read last Tuple:(" + rs.getInt(1) + "," +
                rs.getInt(2) + "," +
                rs.getInt(3) + ")");
        rs.updateInt(2, 3);
        println("T1: updateInt(2, 3);");
View Full Code Here
813
814
815
816
817
818
819
820
821
822
823
                rs.getInt(3) + ")");
        rs.updateInt(2, 3);
        println("T1: updateInt(2, 3);");
        rs.updateRow();       
        println("T1: updateRow()");
        rs.last(); // Go to last tuple
        println("T1: Read last Tuple:(" + rs.getInt(1) + "," +
                rs.getInt(2) + "," +
                rs.getInt(3) + ")");
        rs.updateInt(2, 3);
        println("T1: updateInt(2, 3);");
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.