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"));
}
@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");
}
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);
}
}
