예제 #1
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"));
  }
예제 #2
0
  public void test_updateByLabel_error() throws Exception {
    long currentMillis = System.currentTimeMillis();

    Assert.assertTrue(resultSet.next());

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

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

    {
      SQLException error = null;
      try {
        resultSet.updateByte("0", (byte) 12);
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.updateShort("0", (short) 23);
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

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

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

    {
      SQLException error = null;
      try {
        resultSet.updateFloat("0", 1.0F);
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.updateDouble("0", 2.0D);
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.updateBigDecimal("0", new BigDecimal("33"));
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

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

    {
      SQLException error = null;
      try {
        resultSet.updateBytes("0", new byte[0]);
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.updateDate("0", new java.sql.Date(currentMillis));
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.updateTime("0", new java.sql.Time(1000));
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }

    {
      SQLException error = null;
      try {
        resultSet.updateTimestamp("0", new java.sql.Timestamp(currentMillis));
      } catch (SQLException ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }
  }