コード例 #1
0
  public void test_getDate() throws Exception {
    resultSet.next();

    resultSet.getDate(1, null);
    resultSet.getDate("1", null);

    {
      SQLException error = null;
      try {
        resultSet.getDate(0, null);
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getDate("0", null);
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }
  }
コード例 #2
0
  @SuppressWarnings("deprecation")
  public void test_get() throws Exception {

    Assert.assertTrue(stmt == resultSet.getPoolableStatement());
    Assert.assertTrue(raw == resultSet.getRawResultSet());

    Assert.assertTrue(resultSet.next());
    Assert.assertTrue(resultSet.wasNull() == false);
    resultSet.getString(1);
    Assert.assertTrue(resultSet.wasNull());
    resultSet.getBoolean(1);
    resultSet.getByte(1);
    resultSet.getShort(1);
    resultSet.getInt(1);
    resultSet.getLong(1);
    resultSet.getFloat(1);
    resultSet.getDouble(1);
    resultSet.getBigDecimal(1);
    resultSet.getBigDecimal(1, 1);
    resultSet.getBytes(1);
    resultSet.getDate(1);
    resultSet.getTime(1);
    resultSet.getTimestamp(1);
    resultSet.getAsciiStream(1);
    resultSet.getUnicodeStream(1);
    resultSet.getBinaryStream(1);

    resultSet.getString("1");
    resultSet.getBoolean("1");
    resultSet.getByte("1");
    resultSet.getShort("1");
    resultSet.getInt("1");
    resultSet.getLong("1");
    resultSet.getFloat("1");
    resultSet.getDouble("1");
    resultSet.getBigDecimal("1");
    resultSet.getBigDecimal("1", 1);
    resultSet.getBytes("1");
    resultSet.getDate("1");
    resultSet.getTime("1");
    resultSet.getTimestamp("1");
    resultSet.getAsciiStream("1");
    resultSet.getUnicodeStream("1");
    resultSet.getBinaryStream("1");
  }
コード例 #3
0
  public void test_setByName() throws Exception {
    long currentMillis = System.currentTimeMillis();

    Assert.assertTrue(resultSet.next());

    resultSet.updateNull("1");
    Assert.assertNull(resultSet.getString(1));
    resultSet.updateBoolean("1", true);
    Assert.assertEquals(true, resultSet.getBoolean("1"));

    resultSet.updateByte("1", (byte) 12);
    Assert.assertEquals(12, resultSet.getByte("1"));

    resultSet.updateShort("1", (short) 23);
    Assert.assertEquals(23, resultSet.getShort("1"));

    resultSet.updateInt("1", 34);
    Assert.assertEquals(34, resultSet.getInt("1"));

    resultSet.updateLong("1", 45);
    Assert.assertEquals(45, resultSet.getLong("1"));

    resultSet.updateFloat("1", 1.0F);
    Assert.assertEquals(true, 1.0F == resultSet.getFloat("1"));

    resultSet.updateDouble("1", 2.0D);
    Assert.assertEquals(true, 2.0D == resultSet.getDouble("1"));

    resultSet.updateBigDecimal("1", new BigDecimal("33"));
    Assert.assertEquals(new BigDecimal("33"), resultSet.getBigDecimal("1"));

    resultSet.updateString("1", "xxx");
    Assert.assertEquals("xxx", resultSet.getString("1"));

    resultSet.updateBytes("1", new byte[0]);
    Assert.assertEquals(0, resultSet.getBytes("1").length);

    resultSet.updateDate("1", new java.sql.Date(currentMillis));
    Assert.assertEquals(new java.sql.Date(currentMillis), resultSet.getDate("1"));

    resultSet.updateTime("1", new java.sql.Time(1000));
    Assert.assertEquals(new java.sql.Time(1000), resultSet.getTime("1"));

    resultSet.updateTimestamp("1", new java.sql.Timestamp(currentMillis));
    Assert.assertEquals(new java.sql.Timestamp(currentMillis), resultSet.getTimestamp("1"));
  }
コード例 #4
0
  public void test_get_error() throws Exception {
    {
      SQLException error = null;
      try {
        resultSet.getString(0);
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getBoolean(0);
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getByte(0);
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getShort(0);
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getInt(0);
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getLong(0);
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getFloat(0);
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getDouble(0);
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getBigDecimal(0);
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getBigDecimal(0, 1);
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getBytes(0);
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getDate(0);
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getTime(0);
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getTimestamp(0);
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getAsciiStream(0);
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getUnicodeStream(0);
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getBinaryStream(0);
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    // ////////////////

    {
      SQLException error = null;
      try {
        resultSet.getString("0");
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getBoolean("0");
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getByte("0");
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getShort("0");
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getInt("0");
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getLong("0");
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getFloat("0");
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getDouble("0");
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getBigDecimal("0");
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getBigDecimal("0", 1);
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getBytes("0");
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getDate("0");
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getTime("0");
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getTimestamp("0");
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getAsciiStream("0");
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getUnicodeStream("0");
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.getBinaryStream("0");
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }
  }