@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)); }
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); }
/** * @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; }
@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(); }
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()); } }
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));
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); } }
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;
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; } }
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; }
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);
@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(); }
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()); } }
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));
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;
@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 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; } }
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));