csunittest.java

第三方的SQL Server and Sybase的jdbc dirver,速度更快

                               smallmoney[i] + ")         ");
        }


        // long l = System.currentTimeMillis();
        // while (l + 500 > System.currentTimeMillis()) ;
        ResultSet rs = stmt.executeQuery("select * from #t0019 order by i");

        for (i=0; rs.next(); i++) {
            BigDecimal  m;
            BigDecimal  sm;

            m = (BigDecimal)rs.getObject("mymoney");
            sm = (BigDecimal)rs.getObject("mysmallmoney");

            assertEquals(m, money[i]);
            assertEquals(sm, smallmoney[i]);

            output.println(m + ", " + sm);
        }
        stmt.close();
    }

    /*
    public void testBooleanAndCompute0026() throws Exception {
      Statement   stmt = con.createStatement();
      dropTable("#t0026");
      int count = stmt.executeUpdate("create table #t0026             " +
      "  (i      integer,             " +
      "   b      bit,                 " +
      "   s      char(5),             " +
      "   f      float)               ");
      output.println("Creating table affected " + count + " rows");

      stmt.executeUpdate("insert into #t0026 values(0, 0, 'false', 0.0)");
      stmt.executeUpdate("insert into #t0026 values(0, 0, 'N', 10)");
      stmt.executeUpdate("insert into #t0026 values(1, 1, 'true', 7.0)");
      stmt.executeUpdate("insert into #t0026 values(2, 1, 'Y', -5.0)");

      ResultSet  rs = stmt.executeQuery(
      "select * from #t0026 order by i compute sum(f) by i");

      assertTrue(rs.next());

      assertTrue(!(rs.getBoolean("i")
      || rs.getBoolean("b")
      || rs.getBoolean("s")
      || rs.getBoolean("f")));

      assertTrue(rs.next());

      assertTrue(!(rs.getBoolean("i")
      || rs.getBoolean("b")
      || rs.getBoolean("s")
      || rs.getBoolean("f")));
      assertTrue(rs.next());

      assertTrue(rs.getBoolean("i")
      && rs.getBoolean("b")
      && rs.getBoolean("s")
      && rs.getBoolean("f"));
      assertTrue(rs.next());

      assertTrue(rs.getBoolean("i")
      && rs.getBoolean("b")
      && rs.getBoolean("s")
      && rs.getBoolean("f"));

      ResultSet  rs = stmt.executeQuery(
         "select * from #t0026 order by i compute sum(f) by i");



      if (!rs.next())
      {
         throw new SQLException("Failed");
      }
      passed = passed && (! (rs.getBoolean("i")
                             || rs.getBoolean("b")
                             || rs.getBoolean("s")
                             || rs.getBoolean("f")));


      if (!rs.next())
      {
         throw new SQLException("Failed");
      }
      passed = passed && (! (rs.getBoolean("i")
                             || rs.getBoolean("b")
                             || rs.getBoolean("s")
                             || rs.getBoolean("f")));


      if (!rs.next())
      {
         throw new SQLException("Failed");
      }
      passed = passed && (rs.getBoolean("i")
                          && rs.getBoolean("b")
                          && rs.getBoolean("s")
                          && rs.getBoolean("f"));

      if (!rs.next())
      {
         throw new SQLException("Failed");
      }
      passed = passed && (rs.getBoolean("i")
                          && rs.getBoolean("b")
                          && rs.getBoolean("s")
                          && rs.getBoolean("f"));

     assertTrue(passed);
    }
    */

    public void testDataTypes0027() throws Exception {
        output.println("Test all the SQLServer datatypes in Statement\n"
                       + "and PreparedStatement using the preferred getXXX()\n"
                       + "instead of getObject like #t0017.java does.");
        output.println("!!!Note- This test is not fully implemented yet!!!");
        Statement   stmt = con.createStatement();
        ResultSet   rs;
        stmt.execute("set dateformat ymd");
        dropTable("#t0027");
        String sql =
        "create table #t0027 (                                  " +
        " mybinary                   binary(5) not null,       " +
        " myvarbinary                varbinary(4) not null,    " +
        " mychar                     char(10) not null,        " +
        " myvarchar                  varchar(8) not null,      " +
        " mydatetime                 datetime not null,        " +
        " mysmalldatetime            smalldatetime not null,   " +
        " mydecimal10_3              decimal(10,3) not null,   " +
        " mynumeric5_4               numeric (5,4) not null,   " +
        " myfloat6                   float(6) not null,        " +
        " myfloat14                  float(6) not null,        " +
        " myreal                     real not null,            " +
        " myint                      int not null,             " +
        " mysmallint                 smallint not null,        " +
        " mytinyint                  tinyint not null,         " +
        " mymoney                    money not null,           " +
        " mysmallmoney               smallmoney not null,      " +
        " mybit                      bit not null,             " +
        " mytimestamp                timestamp not null,       " +
        " mytext                     text not null,            " +
        " myimage                    image not null,           " +
        " mynullbinary               binary(3) null,          " +
        " mynullvarbinary            varbinary(6) null,       " +
        " mynullchar                 char(10) null,            " +
        " mynullvarchar              varchar(40) null,         " +
        " mynulldatetime             datetime null,            " +
        " mynullsmalldatetime        smalldatetime null,       " +
        " mynulldecimal10_3          decimal(10,3) null,       " +
        " mynullnumeric15_10         numeric(15,10) null,      " +
        " mynullfloat6               float(6) null,            " +
        " mynullfloat14              float(14) null,           " +
        " mynullreal                 real null,                " +
        " mynullint                  int null,                 " +
        " mynullsmallint             smallint null,            " +
        " mynulltinyint              tinyint null,             " +
        " mynullmoney                money null,               " +
        " mynullsmallmoney           smallmoney null,          " +
        " mynulltext                 text null,                " +
        " mynullimage                image null)               ";

        assertEquals(stmt.executeUpdate(sql), 0);


        // Insert a row without nulls via a Statement
        sql =
        "insert into #t0027               " +
        "  (mybinary,                    " +
        "   myvarbinary,                 " +
        "   mychar,                      " +
        "   myvarchar,                   " +
        "   mydatetime,                  " +
        "   mysmalldatetime,             " +
        "   mydecimal10_3,               " +
        "   mynumeric5_4,              " +
        "   myfloat6,                    " +
        "   myfloat14,                   " +
        "   myreal,                      " +
        "   myint,                       " +
        "   mysmallint,                  " +
        "   mytinyint,                   " +
        "   mymoney,                     " +
        "   mysmallmoney,                " +
        "   mybit,                       " +
        "   mytimestamp,                 " +
        "   mytext,                      " +
        "   myimage,                     " +
        "   mynullbinary,                " +
        "   mynullvarbinary,             " +
        "   mynullchar,                  " +
        "   mynullvarchar,               " +
        "   mynulldatetime,              " +
        "   mynullsmalldatetime,         " +
        "   mynulldecimal10_3,           " +
        "   mynullnumeric15_10,          " +
        "   mynullfloat6,                " +
        "   mynullfloat14,               " +
        "   mynullreal,                  " +
        "   mynullint,                   " +
        "   mynullsmallint,              " +
        "   mynulltinyint,               " +
        "   mynullmoney,                 " +
        "   mynullsmallmoney,            " +
        "   mynulltext,                  " +
        "   mynullimage)                 " +
        " values                         " +
        "   (0x1213141516,               " + //   mybinary,
        "    0x1718191A,                 " + //   myvarbinary
        "    '1234567890',               " + //   mychar
        "    '12345678',                 " + //   myvarchar
        "    '19991015 21:29:59.01',     " + //   mydatetime
        "    '19991015 20:45',           " + //   mysmalldatetime
        "    1234567.089,                " + //   mydecimal10_3
        "    1.2345,                     " + //   mynumeric5_4
        "    65.4321,                    " + //   myfloat6
        "    1.123456789,                " + //   myfloat14
        "    987654321.0,                " + //   myreal
        "    4097,                       " + //   myint
        "    4094,                       " + //   mysmallint
        "    200,                        " + //   mytinyint
        "    19.95,                      " + //   mymoney
        "    9.97,                       " + //   mysmallmoney
        "    1,                          " + //   mybit
        "    null,                       " + //   mytimestamp
        "    'abcdefg',                  " + //   mytext
        "    0x0AAABB,                   " + //   myimage
        "    0x123456,                   " + //   mynullbinary
        "    0xAB,                       " + //   mynullvarbinary
        "    'z',                        " + //   mynullchar
        "    'zyx',                      " + //   mynullvarchar
        "    '1976-07-04 12:00:00.04',   " + //   mynulldatetime
        "    '2000-02-29 13:46',         " + //   mynullsmalldatetime
        "     1.23,                      " + //   mynulldecimal10_3
        "     7.1234567891,              " + //   mynullnumeric15_10
        "     987654,                    " + //   mynullfloat6
        "     0,                         " + //   mynullfloat14
        "     -1.1,                      " + //   mynullreal
        "     -10,                       " + //   mynullint
        "     126,                       " + //   mynullsmallint
        "     7,                         " + //   mynulltinyint
        "     -19999.00,                 " + //   mynullmoney
        "     -9.97,                     " + //   mynullsmallmoney
        "     '1234',                    " + //   mynulltext
        "     0x1200340056)              " + //   mynullimage)
        "";

        assertEquals(stmt.executeUpdate(sql), 1);

        sql = "select * from #t0027";
        rs = stmt.executeQuery(sql);
        assertTrue(rs.next());
        output.println("mybinary is " + rs.getObject("mybinary"));
        output.println("myvarbinary is " + rs.getObject("myvarbinary"));
        output.println("mychar is " + rs.getString("mychar"));
        output.println("myvarchar is " + rs.getString("myvarchar"));
        output.println("mydatetime is " + rs.getTimestamp("mydatetime"));
        output.println("mysmalldatetime is " + rs.getTimestamp("mysmalldatetime"));
        output.println("mydecimal10_3 is " + rs.getObject("mydecimal10_3"));
        output.println("mynumeric5_4 is " + rs.getObject("mynumeric5_4"));
        output.println("myfloat6 is " + rs.getDouble("myfloat6"));
        output.println("myfloat14 is " + rs.getDouble("myfloat14"));
        output.println("myreal is " + rs.getDouble("myreal"));
        output.println("myint is " + rs.getInt("myint"));
        output.println("mysmallint is " + rs.getShort("mysmallint"));
        output.println("mytinyint is " + rs.getByte("mytinyint"));
        output.println("mymoney is " + rs.getObject("mymoney"));
        output.println("mysmallmoney is " + rs.getObject("mysmallmoney"));
        output.println("mybit is " + rs.getObject("mybit"));
        output.println("mytimestamp is " + rs.getObject("mytimestamp"));
        output.println("mytext is " + rs.getObject("mytext"));
        output.println("myimage is " + rs.getObject("myimage"));
        output.println("mynullbinary is " + rs.getObject("mynullbinary"));
        output.println("mynullvarbinary is " + rs.getObject("mynullvarbinary"));
        output.println("mynullchar is " + rs.getString("mynullchar"));
        output.println("mynullvarchar is " + rs.getString("mynullvarchar"));
        output.println("mynulldatetime is " + rs.getTimestamp("mynulldatetime"));
        output.println("mynullsmalldatetime is " + rs.getTimestamp("mynullsmalldatetime"));
        output.println("mynulldecimal10_3 is " + rs.getObject("mynulldecimal10_3"));
        output.println("mynullnumeric15_10 is " + rs.getObject("mynullnumeric15_10"));
        output.println("mynullfloat6 is " + rs.getDouble("mynullfloat6"));
        output.println("mynullfloat14 is " + rs.getDouble("mynullfloat14"));
        output.println("mynullreal is " + rs.getDouble("mynullreal"));
        output.println("mynullint is " + rs.getInt("mynullint"));
        output.println("mynullsmallint is " + rs.getShort("mynullsmallint"));
        output.println("mynulltinyint is " + rs.getByte("mynulltinyint"));
        output.println("mynullmoney is " + rs.getObject("mynullmoney"));
        output.println("mynullsmallmoney is " + rs.getObject("mynullsmallmoney"));
        output.println("mynulltext is " + rs.getObject("mynulltext"));
        output.println("mynullimage is " + rs.getObject("mynullimage"));
        stmt.close();
    }
    public void testCallStoredProcedures0028() throws Exception {
        Statement   stmt = con.createStatement();
        ResultSet   rs;

        boolean isResultSet;
        int updateCount;

        int resultSetCount=0;
        int rowCount=0;