@Override public java.sql.Timestamp convert(String s) throws ParseException { if (timeStampWithoutSecPatternLen == s.length()) { s = s + ":00"; } if (s.length() > dateLen) { return java.sql.Timestamp.valueOf(s); } else { return new java.sql.Timestamp(new SimpleDateFormat(datePattern).parse(s).getTime()); } } }
/** * 获取最近一条运行中的任务统计数据. * * @return 运行中的任务统计数据对象 */ public Optional<JobRunningStatistics> findLatestJobRunningStatistics() { JobRunningStatistics result = null; String sql = String.format("SELECT id, running_count, statistics_time, creation_time FROM %s order by id DESC LIMIT 1", TABLE_JOB_RUNNING_STATISTICS); try ( Connection conn = dataSource.getConnection(); PreparedStatement preparedStatement = conn.prepareStatement(sql); ResultSet resultSet = preparedStatement.executeQuery() ) { while (resultSet.next()) { result = new JobRunningStatistics(resultSet.getLong(1), resultSet.getInt(2), new Date(resultSet.getTimestamp(3).getTime()), new Date(resultSet.getTimestamp(4).getTime())); } } catch (final SQLException ex) { // TODO 记录失败直接输出日志,未来可考虑配置化 log.error("Fetch latest jobRunningStatistics from DB error:", ex); } return Optional.fromNullable(result); }
@Override public String objectToSQLString(Date value, Dialect dialect) throws Exception { final Timestamp ts = Timestamp.class.isInstance( value ) ? ( Timestamp ) value : new Timestamp( value.getTime() ); // TODO : use JDBC date literal escape syntax? -> {d 'date-string'} in yyyy-mm-dd hh:mm:ss[.f...] format return StringType.INSTANCE.objectToSQLString( ts.toString(), dialect ); }
java.util.Date utilDate = new java.util.Date(); Calendar cal = Calendar.getInstance(); cal.setTime(utilDate); cal.set(Calendar.MILLISECOND, 0); System.out.println(new java.sql.Timestamp(utilDate.getTime())); System.out.println(new java.sql.Timestamp(cal.getTimeInMillis()));
@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 ); }
@Test public void testTimestamp() { Date d = new Date(0); Timestamp ts = new Timestamp(0); assertThat(jdkTypeToJson(ts), containsString(new SimpleDateFormat("yyyy-MM-dd").format(d))); }
private Timestamp getTimestamp(final MySQLPacketPayload payload) { Calendar calendar = Calendar.getInstance(); calendar.set(0, Calendar.JANUARY, 0, payload.readInt1(), payload.readInt1(), payload.readInt1()); Timestamp result = new Timestamp(calendar.getTimeInMillis()); result.setNanos(0); return result; }
ps.setString(paramIndex, inValue.toString()); ps.setNString(paramIndex, inValue.toString()); ps.setNClob(paramIndex, new StringReader(strVal), strVal.length()); 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); 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);
protected void readFieldValue(Object object, FieldInfo field, ResultSet rs, int paramIndex) throws SQLException { Class<?> fieldType = field.getFieldType(); Object fieldValue = null; if (fieldType.equals(int.class) || fieldType.equals(Integer.class)) { fieldValue = rs.getInt(paramIndex); } else if (fieldType.equals(long.class) || fieldType.equals(Long.class)) { fieldValue = rs.getLong(paramIndex); } else if (fieldType.equals(String.class)) { fieldValue = rs.getString(paramIndex); } else if (fieldType.equals(Date.class)) { Timestamp timestamp = rs.getTimestamp(paramIndex); if (timestamp != null) { fieldValue = new Date(timestamp.getTime()); } } else { throw new UnsupportedOperationException(); } try { field.getField().set(object, fieldValue); } catch (IllegalArgumentException e) { throw new DruidRuntimeException("set field error" + field.getField(), e); } catch (IllegalAccessException e) { throw new DruidRuntimeException("set field error" + field.getField(), e); } }
@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)); }
private byte[] encodeTime(Timestamp timestamp) { ByteBuffer encoded; long time = timestamp.getTime(); try { String formatted = dateFormat.format(new Date(time)); encoded = Text.encode(formatted); } catch (CharacterCodingException e) { throw new RuntimeException(e); } return Arrays.copyOf(encoded.array(), encoded.limit()); }
private boolean updateJobExecutionEventWhenSuccess(final JobExecutionEvent jobExecutionEvent) { boolean result = false; String sql = "UPDATE `" + TABLE_JOB_EXECUTION_LOG + "` SET `is_success` = ?, `complete_time` = ? WHERE id = ?"; try ( Connection conn = dataSource.getConnection(); PreparedStatement preparedStatement = conn.prepareStatement(sql)) { preparedStatement.setBoolean(1, jobExecutionEvent.isSuccess()); preparedStatement.setTimestamp(2, new Timestamp(jobExecutionEvent.getCompleteTime().getTime())); preparedStatement.setString(3, jobExecutionEvent.getId()); if (0 == preparedStatement.executeUpdate()) { return insertJobExecutionEventWhenSuccess(jobExecutionEvent); } result = true; } catch (final SQLException ex) { // TODO 记录失败直接输出日志,未来可考虑配置化 log.error(ex.getMessage()); } return result; }
private Timestamp convertToTimestamp(Object object) { final long millis; if (object instanceof Long) { millis = (Long) object; } else { // use 'provided' Joda time final DateTime value = (DateTime) object; millis = value.toDate().getTime(); } return new Timestamp(millis - LOCAL_TZ.getOffset(millis)); }
public Person createModesty() { Address benhome = new Address("NN Island", "Blue Cave", "ta", new Zipcode("82742")); Address benwork = new Address("44 Planetary St.", "Neptune", "Milkiway", new Zipcode("12345")); Calendar benCal = Calendar.getInstance(); benCal.set(1986, Calendar.AUGUST, 8, 8, 11); Person ben = new Person("Modesty", "Blase", benCal.getTime(), benhome, benwork); benCal = Calendar.getInstance(); benCal.set(1995, Calendar.MAY, 21, 8, 11); ben.setFirstBaseBallGame(new Timestamp(benCal.getTime().getTime())); ben.getHobbies().add("sneak"); ben.getHobbies().add("kill"); ben.getHobbies().add("fight"); return ben; }
DateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy"); Date date = dateFormat.parse("23/09/2007"); long time = date.getTime(); new Timestamp(time);