← Back to branch summary

~ubuntu-branches/ubuntu/wily/libpgjava/wily

« back to all changes in this revision

Viewing changes to src/interfaces/jdbc/org/postgresql/test/jdbc2/ResultSetTest.java

  • Committer: Bazaar Package Importer
  • Author(s): Stefan Gybas
  • Date: 2002-02-06 23:43:06 UTC
  • Revision ID: james.westby@ubuntu.com-20020206234306-hsg7suqr8q56qg40
Tags: upstream-7.2
Import upstream version 7.2

Show diffs side-by-side

added added

removed removed

Lines of Context:
src/interfaces/jdbc/org/postgresql/test/jdbc2/ResultSetTest.java
 
1
package org.postgresql.test.jdbc2;
 
2
 
 
3
import org.postgresql.test.JDBC2Tests;
 
4
import junit.framework.TestCase;
 
5
import java.io.*;
 
6
import java.sql.*;
 
7
 
 
8
/*
 
9
 * ResultSet tests.
 
10
 */
 
11
public class ResultSetTest extends TestCase
 
12
{
 
13
        private Connection con;
 
14
 
 
15
        public ResultSetTest(String name)
 
16
        {
 
17
                super(name);
 
18
        }
 
19
 
 
20
        protected void setUp() throws Exception
 
21
        {
 
22
                con = JDBC2Tests.openDB();
 
23
                Statement stmt = con.createStatement();
 
24
 
 
25
                JDBC2Tests.createTable(con, "testrs", "id integer");
 
26
 
 
27
                stmt.executeUpdate("INSERT INTO testrs VALUES (1)");
 
28
                stmt.executeUpdate("INSERT INTO testrs VALUES (2)");
 
29
                stmt.executeUpdate("INSERT INTO testrs VALUES (3)");
 
30
                stmt.executeUpdate("INSERT INTO testrs VALUES (4)");
 
31
                stmt.executeUpdate("INSERT INTO testrs VALUES (6)");
 
32
                stmt.executeUpdate("INSERT INTO testrs VALUES (9)");
 
33
 
 
34
                stmt.close();
 
35
        }
 
36
 
 
37
        protected void tearDown() throws Exception
 
38
        {
 
39
                JDBC2Tests.dropTable(con, "testrs");
 
40
                JDBC2Tests.closeDB(con);
 
41
        }
 
42
 
 
43
        public void testAbsolute() throws Exception
 
44
        {
 
45
                Statement stmt = con.createStatement();
 
46
                ResultSet rs = stmt.executeQuery("SELECT * FROM testrs");
 
47
 
 
48
                assertTrue(rs.absolute( -1));
 
49
                assertEquals(6, rs.getRow());
 
50
 
 
51
                assertTrue(rs.absolute(1));
 
52
                assertEquals(1, rs.getRow());
 
53
 
 
54
                assertTrue(!rs.absolute( -10));
 
55
                assertEquals(0, rs.getRow());
 
56
                assertTrue(rs.next());
 
57
                assertEquals(1, rs.getRow());
 
58
 
 
59
                assertTrue(!rs.absolute(10));
 
60
                assertEquals(0, rs.getRow());
 
61
                assertTrue(rs.previous());
 
62
                assertEquals(6, rs.getRow());
 
63
 
 
64
                stmt.close();
 
65
        }
 
66
}