java.sql.Timestamp.<init>()方法的使用及代码示例

x33g5p2x  于2022-01-29 转载在 其他  
字(8.9k)|赞(0)|评价(0)|浏览(184)

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

Timestamp.<init>介绍

[英]Returns a Timestamp corresponding to the time specified by the supplied values for Year, Month, Date, Hour, Minutes, Seconds and Nanoseconds.
[中]返回与提供的年、月、日、时、分、秒和纳秒值指定的时间相对应的时间戳。

代码示例

代码示例来源：origin: alibaba/druid

static void setParam(PreparedStatement stmt, int paramIndex, Date value) throws SQLException {
  if (value == null) {
    stmt.setNull(paramIndex, Types.TIMESTAMP);
  } else {
    stmt.setTimestamp(paramIndex, new Timestamp(value.getTime()));
  }
}

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

private static Timestamp readTimestamp(long time, int nanos) {
  Timestamp ts = new Timestamp(time);
  ts.setNanos(nanos);
  return ts;
}

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

public DataSharingSettings(boolean allowSharing, String updatedBy, Date updatedOn) {
  this.allowSharing = allowSharing;
  this.updatedBy = updatedBy;
  this.updatedOn = new Timestamp(updatedOn.getTime());
}

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

@Override
  public void setValues(PreparedStatement ps) throws SQLException {
    ps.setTimestamp(1, new Timestamp(new Date().getTime()));
  }
});

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

private static Object convertDateValue(final Object value, final Class<?> convertType) {
    Date date = (Date) value;
    switch (convertType.getName()) {
      case "java.sql.Date":
        return new java.sql.Date(date.getTime());
      case "java.sql.Time":
        return new Time(date.getTime());
      case "java.sql.Timestamp":
        return new Timestamp(date.getTime());
      default:
        throw new ShardingException("Unsupported Date type:%s", convertType);
    }
  }
}

代码示例来源：origin: alibaba/nacos

public static Timestamp getCurrentTime() {
  Date date = new Date();
  return new Timestamp(date.getTime());
}

代码示例来源：origin: hibernate/hibernate-orm

@Override
  public Date deepCopyNotNull(Date value) {
    if ( value instanceof Timestamp ) {
      Timestamp orig = (Timestamp) value;
      Timestamp ts = new Timestamp( orig.getTime() );
      ts.setNanos( orig.getNanos() );
      return ts;
    }
    else {
      return new Date( value.getTime() );
    }
  }
}

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

@Test
public void testSetParameterValueWithDateAndUnknownType() throws SQLException {
  java.util.Date date = new java.util.Date(1000);
  StatementCreatorUtils.setParameterValue(preparedStatement, 1, SqlTypeValue.TYPE_UNKNOWN, null, date);
  verify(preparedStatement).setTimestamp(1, new java.sql.Timestamp(1000));
}

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

Timestamp stamp = new Timestamp(System.currentTimeMillis());
Date date = new Date(stamp.getTime());
System.out.println(date);

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

ps.setString(paramIndex, inValue.toString());
    ps.setString(paramIndex, strVal);
    ps.setDate(paramIndex, new java.sql.Date(((java.util.Date) inValue).getTime()));
  ps.setDate(paramIndex, new java.sql.Date(cal.getTime().getTime()), cal);
    ps.setTime(paramIndex, new java.sql.Time(((java.util.Date) inValue).getTime()));
  ps.setTime(paramIndex, new java.sql.Time(cal.getTime().getTime()), cal);
if (inValue instanceof java.util.Date) {
  if (inValue instanceof java.sql.Timestamp) {
    ps.setTimestamp(paramIndex, (java.sql.Timestamp) inValue);
    ps.setTimestamp(paramIndex, new java.sql.Timestamp(((java.util.Date) inValue).getTime()));
  ps.setTimestamp(paramIndex, new java.sql.Timestamp(cal.getTime().getTime()), cal);
  "Oracle".equals(ps.getConnection().getMetaData().getDatabaseProductName()))) {
if (isStringValue(inValue.getClass())) {
  ps.setString(paramIndex, inValue.toString());
  ps.setTimestamp(paramIndex, new java.sql.Timestamp(((java.util.Date) inValue).getTime()));
  ps.setTimestamp(paramIndex, new java.sql.Timestamp(cal.getTime().getTime()), cal);

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

@Test
public void testRow()
{
  Row r1 = new Row();
  r1.addField(new Field(AccumuloRowSerializer.getBlockFromArray(VARCHAR, ImmutableList.of("a", "b", "c")), new ArrayType(VARCHAR)));
  r1.addField(true, BOOLEAN);
  r1.addField(new Field(new Date(new GregorianCalendar(1999, 0, 1).getTime().getTime()), DATE));
  r1.addField(123.45678, DOUBLE);
  r1.addField(new Field(123.45678f, REAL));
  r1.addField(12345678, INTEGER);
  r1.addField(new Field(12345678L, BIGINT));
  r1.addField(new Field((short) 12345, SMALLINT));
  r1.addField(new GregorianCalendar(1999, 0, 1, 12, 30, 0).getTime().getTime(), TIME);
  r1.addField(new Field(new Timestamp(new GregorianCalendar(1999, 0, 1, 12, 30, 0).getTime().getTime()), TIMESTAMP));
  r1.addField((byte) 123, TINYINT);
  r1.addField(new Field("O'Leary".getBytes(UTF_8), VARBINARY));
  r1.addField("O'Leary", VARCHAR);
  r1.addField(null, VARCHAR);
  assertEquals(r1.length(), 14);
  assertEquals(r1.toString(), "(ARRAY ['a','b','c'],true,DATE '1999-01-01',123.45678,123.45678,12345678,12345678,12345,TIME '12:30:00',TIMESTAMP '1999-01-01 12:30:00.0',123,CAST('O''Leary' AS VARBINARY),'O''Leary',null)");
  Row r2 = new Row(r1);
  assertEquals(r2, r1);
}

代码示例来源：origin: alibaba/canal

try {
  if (java.sql.Date.class.equals(type)) {
    return new java.sql.Date(convertTimestamp2TimeMillis(value.toString()));
  } else if (java.sql.Time.class.equals(type)) {
    return new java.sql.Time(convertTimestamp2TimeMillis(value.toString()));
  } else if (Timestamp.class.equals(type)) {
    return new Timestamp(convertTimestamp2TimeMillis(value.toString()));
  } else {
    return new Timestamp(convertTimestamp2TimeMillis(value.toString()));

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

public Map<FileHistoryId, List<FileVersion>> getFileHistoriesToPurgeInInterval(long beginTimestamp, long endTimestamp, TimeUnit timeUnit) {
  try (PreparedStatement preparedStatement = getStatement("fileversion.select.all.getPurgeVersionsByInterval.sql")) {
    String timeUnitIdentifier = timeUnitSqlTimeUnitMap.get(timeUnit);
    
    preparedStatement.setString(1, timeUnitIdentifier);
    preparedStatement.setTimestamp(2, new Timestamp(beginTimestamp));
    preparedStatement.setTimestamp(3, new Timestamp(endTimestamp));
    
    return getAllVersionsInQuery(preparedStatement);
  }
  catch (SQLException e) {
    throw new RuntimeException(e);
  }
}

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

@Test
public void testTimestampsInResponse() throws Exception
{
 final ResultSet resultSet = client.createStatement().executeQuery(
   "SELECT __time, CAST(__time AS DATE) AS t2 FROM druid.foo LIMIT 1"
 );
 Assert.assertEquals(
   ImmutableList.of(
     ImmutableMap.of(
       "__time", new Timestamp(DateTimes.of("2000-01-01T00:00:00.000Z").getMillis()),
       "t2", new Date(DateTimes.of("2000-01-01").getMillis())
     )
   ),
   getRows(resultSet)
 );
}

代码示例来源：origin: oblac/jodd

@Override
public void set(final PreparedStatement st, final int index, final JulianDate value, final int dbSqlType) throws SQLException {
  if (value == null) {
    st.setNull(index, dbSqlType);
    return;
  }
  if (dbSqlType == Types.TIMESTAMP) {
    st.setTimestamp(index, new Timestamp(value.toMilliseconds()));
    return;
  }
  st.setLong(index, value.toMilliseconds());
}

代码示例来源：origin: alibaba/cobar

public java.util.Date readDate() {
  byte length = read();
  int year = readUB2();
  byte month = read();
  byte date = read();
  int hour = read();
  int minute = read();
  int second = read();
  if (length == 11) {
    long nanos = readUB4();
    Calendar cal = getLocalCalendar();
    cal.set(year, --month, date, hour, minute, second);
    Timestamp time = new Timestamp(cal.getTimeInMillis());
    time.setNanos((int) nanos);
    return time;
  } else {
    Calendar cal = getLocalCalendar();
    cal.set(year, --month, date, hour, minute, second);
    return new java.sql.Date(cal.getTimeInMillis());
  }
}

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

PreparedStatement preparedStatement = 
  connect.prepareStatement("INSERT into employee (time, name) VALUES (?,?)", 
  Statement.RETURN_GENERATED_KEYS);

preparedStatement.setTimestamp(1, 
  new java.sql.Timestamp(new java.util.Date().getTime()));                           
preparedStatement.setString(2, "Test");

preparedStatement.executeUpdate();

ResultSet tableKeys = preparedStatement.getGeneratedKeys();
tableKeys.next();
int autoGeneratedID = tableKeys.getInt(1);

代码示例来源：origin: hibernate/hibernate-orm

@SuppressWarnings({ "unchecked" })
public <X> X unwrap(Calendar value, Class<X> type, WrapperOptions options) {
  if ( value == null ) {
    return null;
  }
  if ( Calendar.class.isAssignableFrom( type ) ) {
    return (X) value;
  }
  if ( java.sql.Date.class.isAssignableFrom( type ) ) {
    return (X) new java.sql.Date( value.getTimeInMillis() );
  }
  if ( java.sql.Time.class.isAssignableFrom( type ) ) {
    return (X) new java.sql.Time( value.getTimeInMillis() );
  }
  if ( java.sql.Timestamp.class.isAssignableFrom( type ) ) {
    return (X) new java.sql.Timestamp( value.getTimeInMillis() );
  }
  if ( java.util.Date.class.isAssignableFrom( type ) ) {
    return (X) new  java.util.Date( value.getTimeInMillis() );
  }
  throw unknownUnwrap( type );
}

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

java.util.Date date = new Date();
Object param = new java.sql.Timestamp(date.getTime());
// The JDBC driver knows what to do with a java.sql type:
preparedStatement.setObject(param);

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

/**
 * @throws Exception If failed.
 */
@Test
public void testTimestampArrayField() throws Exception {
  Timestamp ts1 = new Timestamp(new Date().getTime());
  Timestamp ts2 = new Timestamp(new Date().getTime() + 1000);
  ts1.setNanos(1000);
  ts2.setNanos(2000);
  Timestamp[] tsArr = new Timestamp[] { ts1, ts2 };
  assertTrue(Arrays.equals(tsArr, builder("C").setField("ta", tsArr).build().<Timestamp[]>field("ta")));
}

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

timestamp

相关文章

    查看更多
    微信公众号

    热门标签

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

    最新文章

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