Refine search
@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)); }
@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)); }
switch (type) { case Types.TIMESTAMP: rawValue = rs.getTimestamp(label); break; case Types.TIME: rawValue = rs.getTime(label); break; default:
switch (type) { case Types.TIMESTAMP: rawValue = rs.getTimestamp(label); break; case Types.TIME: rawValue = rs.getTime(label); break; default:
switch (type) { case Types.TIMESTAMP: rawValue = rs.getTimestamp(columnIndex); break; case Types.TIME: rawValue = rs.getTime(columnIndex); break; default:
switch (type) { case Types.TIMESTAMP: rawValue = rs.getTimestamp(columnIndex); break; case Types.TIME: rawValue = rs.getTime(columnIndex); break; default:
return rs.getTime(index); return rs.getTimestamp(index); return rs.getTime(index); return rs.getTimestamp(index);
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);
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);
/** * 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); }
/** * 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); }
return rs.getTimestamp(colIdx); return rs.getTime(colIdx);
break; case Types.TIME: o = rs.getTime(i + 1); break; case Types.TIMESTAMP: o = rs.getTimestamp(i + 1); break; default:
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.");
break; case Types.TIME: o = rs.getTime(i + 1); break; case Types.TIMESTAMP: o = rs.getTimestamp(i + 1); break; default:
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 {
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 {
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()));
/** * @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; }
/** * @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; }