java.sql.ResultSet.getDate()方法的使用及代码示例

x33g5p2x  于2022-01-28 转载在 其他  
字(8.6k)|赞(0)|评价(0)|浏览(156)

本文整理了Java中java.sql.ResultSet.getDate方法的一些代码示例，展示了ResultSet.getDate的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。ResultSet.getDate方法的具体详情如下：
包路径：java.sql.ResultSet
类名称：ResultSet
方法名：getDate

ResultSet.getDate介绍

[英]Gets the value of a column specified by column index as a java.sql.Date.
[中]获取列索引指定为java的列的值。sql。日期

代码示例

代码示例来源：origin: apache/incubator-shardingsphere

@Override
public Object getCalendarValue(final String columnLabel, final Class<?> type, final Calendar calendar) throws SQLException {
  if (Date.class == type) {
    return resultSet.getDate(columnLabel, calendar);
  }
  if (Time.class == type) {
    return resultSet.getTime(columnLabel, calendar);
  }
  if (Timestamp.class == type) {
    return resultSet.getTimestamp(columnLabel, calendar);
  }
  throw new SQLException(String.format("Unsupported type: %s", type));
}

代码示例来源：origin: stackoverflow.com

Calendar tzCal = Calendar.getInstance(TimeZone.getTimeZone("GMT"));
ResultSet rs = ...;
while (rs.next()) {
  Date dateValue = rs.getDate("DateColumn", tzCal);
  // Other fields and calculations
}

代码示例来源：origin: Netflix/conductor

protected <V> V getScalarFromResultSet(ResultSet rs, Class<V> returnType) throws SQLException {
  Object value = null;
  if (Integer.class == returnType) {
    value = rs.getInt(1);
  } else if (Long.class == returnType) {
    value = rs.getLong(1);
  } else if (String.class == returnType) {
    value = rs.getString(1);
  } else if (Boolean.class == returnType) {
    value = rs.getBoolean(1);
  } else if (Double.class == returnType) {
    value = rs.getDouble(1);
  } else if (Date.class == returnType) {
    value = rs.getDate(1);
  } else if (Timestamp.class == returnType) {
    value = rs.getTimestamp(1);
  } else {
    value = rs.getObject(1);
  }
  if (null == value) {
    throw new NullPointerException("Cannot get value from ResultSet of type " + returnType.getName());
  }
  return returnType.cast(value);
}

代码示例来源：origin: apache/ignite

/**
 * @throws Exception If failed.
 */
@SuppressWarnings("deprecation")
@Test
public void testDate() throws Exception {
  ResultSet rs = stmt.executeQuery(SQL);
  int cnt = 0;
  while (rs.next()) {
    if (cnt == 0) {
      assert rs.getDate("dateVal").equals(new Date(1, 1, 1));
      assert rs.getDate(12).equals(new Date(1, 1, 1));
    }
    cnt++;
  }
  assert cnt == 1;
}

代码示例来源：origin: jdbi/jdbi

@Test
public void testBatchInsertWithKeyGenerationAndExplicitSeveralColumnNames() {
  PreparedBatch batch = h.prepareBatch("insert into something (name) values (?) ");
  batch.add("Brian");
  batch.add("Thom");
  List<IdCreateTime> ids = batch.executeAndReturnGeneratedKeys("id", "create_time")
      .map((r, ctx) -> new IdCreateTime(r.getInt("id"), r.getDate("create_time")))
      .list();
  assertThat(ids).hasSize(2);
  assertThat(ids).extracting(ic -> ic.id).containsExactly(1, 2);
  assertThat(ids).extracting(ic -> ic.createTime).doesNotContainNull();
}

代码示例来源：origin: apache/phoenix

private void verifyDateResultSet(ResultSet rs, Date date, int rowCount) throws SQLException {
    for (int i=0; i<rowCount; i++) {
      assertTrue(rs.next());
      assertEquals(date, rs.getDate(1));
    }
    assertFalse(rs.next());
  }
}

代码示例来源：origin: jfinal/jfinal

int[] types = new int[columnCount + 1];
buildLabelNamesAndTypes(rsmd, labelNames, types);
while (rs.next()) {
  Model<?> ar = modelClass.newInstance();
  Map<String, Object> attrs = CPI.getAttrs(ar);
    } else {
      if (types[i] == Types.TIMESTAMP) {
        value = rs.getTimestamp(i);
      } else if (types[i] == Types.DATE) {
        value = rs.getDate(i);
      } else if (types[i] == Types.CLOB) {
        value = handleClob(rs.getClob(i));

代码示例来源：origin: changmingxie/tcc-transaction

protected void constructTransactions(ResultSet resultSet, List<Transaction> transactions) throws SQLException {
  while (resultSet.next()) {
    byte[] transactionBytes = resultSet.getBytes(3);
    Transaction transaction = (Transaction) serializer.deserialize(transactionBytes);
    transaction.changeStatus(TransactionStatus.valueOf(resultSet.getInt(4)));
    transaction.setLastUpdateTime(resultSet.getDate(7));
    transaction.setVersion(resultSet.getLong(9));
    transaction.resetRetriedCount(resultSet.getInt(8));
    transactions.add(transaction);
  }
}

代码示例来源：origin: pentaho/pentaho-kettle

data = rs.getBytes( i + 1 );
} else {
 data = rs.getString( i + 1 );
 data = rs.getTimestamp( i + 1 );
 break; // Timestamp extends java.util.Date
} else {
 data = rs.getDate( i + 1 );
 break;

代码示例来源：origin: spring-projects/spring-integration-samples

public Person mapRow(ResultSet rs, int rowNum) throws SQLException {
    Person person = new Person();
    person.setPersonId(rs.getInt("id"));
    person.setName(rs.getString("name"));
    person.setGender(Gender.getGenderByIdentifier(rs.getString("gender")));
    person.setDateOfBirth(rs.getDate("dateOfBirth"));
    return person;
  }
}

代码示例来源：origin: stackoverflow.com

public List<User> list() throws SQLException {
  List<User> users = new ArrayList<User>();

  try (
    Connection connection = database.getConnection();
    PreparedStatement statement = connection.prepareStatement("SELECT id, username, email, birthdate FROM user");
    ResultSet resultSet = statement.executeQuery();
  ) {
    while (resultSet.next()) {
      users.add(new User(
        resultSet.getLong("id"),
        resultSet.getString("username"),
        resultSet.getString("email"),
        resultSet.getDate("birthdate")));
    }
  }

  return users;
}

代码示例来源：origin: spring-projects/spring-framework

return rs.getString(index);
value = rs.getInt(index);
return rs.getDate(index);
return rs.getTimestamp(index);
  return rs.getString(index);
  return rs.getDate(index);
  return rs.getTimestamp(index);

代码示例来源：origin: apache/geode

@Test
public void readOfDateFieldWithDateColumnWritesDate() throws Exception {
 FieldType fieldType = FieldType.DATE;
 ResultSetMetaData metaData = mock(ResultSetMetaData.class);
 when(resultSet.getMetaData()).thenReturn(metaData);
 when(metaData.getColumnCount()).thenReturn(1);
 when(metaData.getColumnName(1)).thenReturn(COLUMN_NAME_1);
 when(tableMetaDataView.getColumnDataType(COLUMN_NAME_1)).thenReturn(Types.DATE);
 java.sql.Date sqlDate = java.sql.Date.valueOf("1979-09-11");
 Date expectedValue = new Date(sqlDate.getTime());
 when(resultSet.getDate(1)).thenReturn(sqlDate);
 when(resultSet.next()).thenReturn(true).thenReturn(false);
 PdxInstanceFactory factory = setupPdxInstanceFactory(fieldType);
 when(regionMapping.getFieldNameForColumn(eq(COLUMN_NAME_1), any()))
   .thenReturn(PDX_FIELD_NAME_1);
 createPdxInstance();
 verifyPdxFactoryWrite(factory, fieldType, expectedValue);
 verify(factory).create();
}

代码示例来源：origin: forcedotcom/phoenix

private void verifyDateResultSet(ResultSet rs, Date date, int rowCount) throws SQLException {
    for (int i=0; i<rowCount; i++) {
      assertTrue(rs.next());
      assertEquals(date, rs.getDate(1));
    }
    assertFalse(rs.next());
  }
}

代码示例来源：origin: jfinal/jfinal

int[] types = new int[columnCount + 1];
buildLabelNamesAndTypes(rsmd, labelNames, types);
while (rs.next()) {
  Model<?> ar = modelClass.newInstance();
  Map<String, Object> attrs = CPI.getAttrs(ar);
        value = rs.getTimestamp(i);
      } else if (t == Types.DATE) {
        value = rs.getDate(i);
      } else if (t == Types.CLOB) {
        value = handleClob(rs.getClob(i));

代码示例来源：origin: pentaho/pentaho-kettle

data = resultSet.getBytes( index + 1 );
} else {
 data = resultSet.getString( index + 1 );
 data = resultSet.getTimestamp( index + 1 );
 break; // Timestamp extends java.util.Date
} else if ( databaseInterface instanceof NetezzaDatabaseMeta ) {
 break;
} else {
 data = resultSet.getDate( index + 1 );
 break;

代码示例来源：origin: apache/ignite

@Override public void run(Connection conn) throws Exception {
    try (PreparedStatement stmt = conn.prepareStatement("SELECT 'zzz'")) {
      ResultSet rs = stmt.executeQuery();
      rs.next();
      rs.getDate(1);
    }
  }
}, "0700B", "Cannot convert to date");

代码示例来源：origin: apache/incubator-shardingsphere

@Override
public Object getCalendarValue(final int columnIndex, final Class<?> type, final Calendar calendar) throws SQLException {
  if (Date.class == type) {
    return resultSet.getDate(columnIndex, calendar);
  }
  if (Time.class == type) {
    return resultSet.getTime(columnIndex, calendar);
  }
  if (Timestamp.class == type) {
    return resultSet.getTimestamp(columnIndex, calendar);
  }
  throw new SQLException(String.format("Unsupported type: %s", type));
}

代码示例来源：origin: azkaban/azkaban

@Override
 public List<ExecutorLogEvent> handle(final ResultSet rs) throws SQLException {
  if (!rs.next()) {
   return Collections.<ExecutorLogEvent>emptyList();
  }
  final ArrayList<ExecutorLogEvent> events = new ArrayList<>();
  do {
   final int executorId = rs.getInt(1);
   final int eventType = rs.getInt(2);
   final Date eventTime = rs.getDate(3);
   final String username = rs.getString(4);
   final String message = rs.getString(5);
   final ExecutorLogEvent event =
     new ExecutorLogEvent(executorId, username, eventTime,
       EventType.fromInteger(eventType), message);
   events.add(event);
  } while (rs.next());
  return events;
 }
}

代码示例来源：origin: jfinal/jfinal

int[] types = new int[columnCount + 1];
buildLabelNamesAndTypes(rsmd, labelNames, types);
while (rs.next()) {
  Record record = new Record();
  CPI.setColumnsMap(record, config.getContainerFactory().getColumnsMap());
    } else {
      if (types[i] == Types.TIMESTAMP) {
        value = rs.getTimestamp(i);
      } else if (types[i] == Types.DATE) {
        value = rs.getDate(i);
      } else if (types[i] == Types.CLOB) {
        value = ModelBuilder.me.handleClob(rs.getClob(i));

内容来源于网络，如有侵权，请联系作者删除！

resultset

相关文章

    查看更多
    微信公众号

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多

    ResultSet类方法

    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com