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

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

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

ResultSet.getTime介绍

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

代码示例

代码示例来源：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: 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: looly/hutool

switch (type) {
case Types.TIMESTAMP:
  rawValue = rs.getTimestamp(label);
  break;
case Types.TIME:
  rawValue = rs.getTime(label);
  break;
default:

代码示例来源：origin: looly/hutool

switch (type) {
case Types.TIMESTAMP:
  rawValue = rs.getTimestamp(label);
  break;
case Types.TIME:
  rawValue = rs.getTime(label);
  break;
default:

代码示例来源：origin: looly/hutool

switch (type) {
case Types.TIMESTAMP:
  rawValue = rs.getTimestamp(columnIndex);
  break;
case Types.TIME:
  rawValue = rs.getTime(columnIndex);
  break;
default:

代码示例来源：origin: looly/hutool

switch (type) {
case Types.TIMESTAMP:
  rawValue = rs.getTimestamp(columnIndex);
  break;
case Types.TIME:
  rawValue = rs.getTime(columnIndex);
  break;
default:

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

return rs.getTime(index);
return rs.getTimestamp(index);
  return rs.getTime(index);
  return rs.getTimestamp(index);

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

result = resultSet.getDate(columnIndex);
} else if (Time.class == type) {
  result = resultSet.getTime(columnIndex);
} else if (Timestamp.class == type) {
  result = resultSet.getTimestamp(columnIndex);
} else if (URL.class == type) {
  result = resultSet.getURL(columnIndex);

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

result = resultSet.getDate(columnLabel);
} else if (Time.class == type) {
  result = resultSet.getTime(columnLabel);
} else if (Timestamp.class == type) {
  result = resultSet.getTimestamp(columnLabel);
} else if (URL.class == type) {
  result = resultSet.getURL(columnLabel);

代码示例来源：origin: commons-beanutils/commons-beanutils

/**
 * Get a column value from a {@link ResultSet} for the specified name.
 *
 * @param resultSet The result set
 * @param name The property name
 * @return The value
 * @throws SQLException if an error occurs
 */
protected Object getObject(final ResultSet resultSet, final String name) throws SQLException {
  final DynaProperty property = getDynaProperty(name);
  if (property == null) {
    throw new IllegalArgumentException("Invalid name '" + name + "'");
  }
  final String columnName = getColumnName(name);
  final Class<?> type = property.getType();
  // java.sql.Date
  if (type.equals(Date.class)) {
    return resultSet.getDate(columnName);
  }
  // java.sql.Timestamp
  if (type.equals(Timestamp.class)) {
    return resultSet.getTimestamp(columnName);
  }
  // java.sql.Time
  if (type.equals(Time.class)) {
    return resultSet.getTime(columnName);
  }
  return resultSet.getObject(columnName);
}

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

/**
 * Get a column value from a {@link ResultSet} for the specified name.
 *
 * @param resultSet The result set
 * @param name The property name
 * @return The value
 * @throws SQLException if an error occurs
 */
protected Object getObject(final ResultSet resultSet, final String name) throws SQLException {
  final DynaProperty property = getDynaProperty(name);
  if (property == null) {
    throw new IllegalArgumentException("Invalid name '" + name + "'");
  }
  final String columnName = getColumnName(name);
  final Class<?> type = property.getType();
  // java.sql.Date
  if (type.equals(Date.class)) {
    return resultSet.getDate(columnName);
  }
  // java.sql.Timestamp
  if (type.equals(Timestamp.class)) {
    return resultSet.getTimestamp(columnName);
  }
  // java.sql.Time
  if (type.equals(Time.class)) {
    return resultSet.getTime(columnName);
  }
  return resultSet.getObject(columnName);
}

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

return rs.getTimestamp(colIdx);
return rs.getTime(colIdx);

代码示例来源：origin: com.h2database/h2

break;
case Types.TIME:
  o = rs.getTime(i + 1);
  break;
case Types.TIMESTAMP:
  o = rs.getTimestamp(i + 1);
  break;
default:

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

row.add(new Column<Date>(columnLabel, resultSet.getDate(columnLabel), columnType));
} else if (columnJavaType.equals(Time.class)) {
  row.add(new Column<Time>(columnLabel, resultSet.getTime(columnLabel), columnType));
} else if (columnJavaType.equals(Timestamp.class)) {
  row.add(new Column<Timestamp>(columnLabel, resultSet.getTimestamp(columnLabel), columnType));
} else {
  throw new RuntimeException("type =  " + columnType + " for column " + columnLabel + " not supported.");

代码示例来源：origin: lealone/Lealone

break;
case Types.TIME:
  o = rs.getTime(i + 1);
  break;
case Types.TIMESTAMP:
  o = rs.getTimestamp(i + 1);
  break;
default:

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

if ( val.getOriginalColumnType() == java.sql.Types.TIME ) {
 data = rs.getTime( i + 1 );
 break; // Time is a subclass of java.util.Date, the default date
 data = rs.getTimestamp( i + 1 );
 break; // Timestamp extends java.util.Date
} else {

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

case ValueMetaInterface.TYPE_DATE:
 if ( val.getOriginalColumnType() == java.sql.Types.TIMESTAMP ) {
  data = rs.getTimestamp( index + 1 );
  break; // Timestamp extends java.util.Date
 } else if ( val.getOriginalColumnType() == java.sql.Types.TIME ) {
  data = rs.getTime( index + 1 );
  break;
 } else {

代码示例来源：origin: prestodb/presto

assertTrue(rs.next());
assertEquals(rs.getTime(1), new Time(new DateTime(1970, 1, 1, 3, 4, 5).getMillis()));
assertEquals(rs.getTime(1, ASIA_ORAL_CALENDAR), new Time(new DateTime(1970, 1, 1, 3, 4, 5, ASIA_ORAL_ZONE).getMillis()));
assertEquals(rs.getObject(1), new Time(new DateTime(1970, 1, 1, 3, 4, 5).getMillis()));
assertEquals(rs.getTime("a"), new Time(new DateTime(1970, 1, 1, 3, 4, 5).getMillis()));
assertEquals(rs.getTime("a", ASIA_ORAL_CALENDAR), new Time(new DateTime(1970, 1, 1, 3, 4, 5, ASIA_ORAL_ZONE).getMillis()));
assertEquals(rs.getObject("a"), new Time(new DateTime(1970, 1, 1, 3, 4, 5).getMillis()));
assertEquals(rs.getTime(2), new Time(new DateTime(1970, 1, 1, 6, 7, 8, DateTimeZone.forOffsetHoursMinutes(6, 17)).getMillis()));
assertEquals(rs.getTime(2, ASIA_ORAL_CALENDAR), new Time(new DateTime(1970, 1, 1, 6, 7, 8, DateTimeZone.forOffsetHoursMinutes(6, 17)).getMillis()));
assertEquals(rs.getObject(2), new Time(new DateTime(1970, 1, 1, 6, 7, 8, DateTimeZone.forOffsetHoursMinutes(6, 17)).getMillis()));
assertEquals(rs.getTime("b"), new Time(new DateTime(1970, 1, 1, 6, 7, 8, DateTimeZone.forOffsetHoursMinutes(6, 17)).getMillis()));
assertEquals(rs.getTime("b", ASIA_ORAL_CALENDAR), new Time(new DateTime(1970, 1, 1, 6, 7, 8, DateTimeZone.forOffsetHoursMinutes(6, 17)).getMillis()));
assertEquals(rs.getObject("b"), new Time(new DateTime(1970, 1, 1, 6, 7, 8, DateTimeZone.forOffsetHoursMinutes(6, 17)).getMillis()));
assertEquals(rs.getTime(3), new Time(new DateTime(1970, 1, 1, 9, 10, 11, DateTimeZone.forID("Europe/Berlin")).getMillis()));
assertEquals(rs.getTime(3, ASIA_ORAL_CALENDAR), new Time(new DateTime(1970, 1, 1, 9, 10, 11, DateTimeZone.forID("Europe/Berlin")).getMillis()));
assertEquals(rs.getObject(3), new Time(new DateTime(1970, 1, 1, 9, 10, 11, DateTimeZone.forID("Europe/Berlin")).getMillis()));
assertEquals(rs.getTime("c"), new Time(new DateTime(1970, 1, 1, 9, 10, 11, DateTimeZone.forID("Europe/Berlin")).getMillis()));
assertEquals(rs.getTime("c", ASIA_ORAL_CALENDAR), new Time(new DateTime(1970, 1, 1, 9, 10, 11, DateTimeZone.forID("Europe/Berlin")).getMillis()));
assertEquals(rs.getObject("c"), new Time(new DateTime(1970, 1, 1, 9, 10, 11, DateTimeZone.forID("Europe/Berlin")).getMillis()));

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

/**
 * @throws Exception If failed.
 */
@Test
public void testTimestamp() throws Exception {
  ResultSet rs = stmt.executeQuery(SQL);
  int cnt = 0;
  while (rs.next()) {
    if (cnt == 0) {
      assert rs.getTimestamp("tsVal").getTime() == 1;
      assert rs.getDate(14).equals(new Date(new Timestamp(1).getTime()));
      assert rs.getTime(14).equals(new Time(new Timestamp(1).getTime()));
      assert rs.getTimestamp(14).equals(new Timestamp(1));
      assert rs.getObject(14, Date.class).equals(new Date(new Timestamp(1).getTime()));
      assert rs.getObject(14, Time.class).equals(new Time(new Timestamp(1).getTime()));
      assert rs.getObject(14, Timestamp.class).equals(new Timestamp(1));
    }
    cnt++;
  }
  assert cnt == 1;
}

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

/**
 * @throws Exception If failed.
 */
@Test
public void testTimestamp() throws Exception {
  ResultSet rs = stmt.executeQuery(SQL);
  int cnt = 0;
  while (rs.next()) {
    if (cnt == 0) {
      assert rs.getTimestamp("tsVal").getTime() == 1;
      assert rs.getDate(14).equals(new Date(new Timestamp(1).getTime()));
      assert rs.getTime(14).equals(new Time(new Timestamp(1).getTime()));
      assert rs.getTimestamp(14).equals(new Timestamp(1));
      assert rs.getObject(14, Date.class).equals(new Date(new Timestamp(1).getTime()));
      assert rs.getObject(14, Time.class).equals(new Time(new Timestamp(1).getTime()));
      assert rs.getObject(14, Timestamp.class).equals(new Timestamp(1));
    }
    cnt++;
  }
  assert cnt == 1;
}

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

resultset

相关文章

    查看更多
    微信公众号

    热门标签

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

    最新文章

    更多

    ResultSet类方法

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