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())); } }
@Override public void apply(final int position, final PreparedStatement statement, final StatementContext ctx) throws SQLException { if (value != null) { if (calendar.isPresent()) { // We need to make a clone, because Calendar is not thread-safe // and some JDBC drivers mutate it during time calculations final Calendar calendarClone = (Calendar) calendar.get().clone(); statement.setTimestamp(position, new Timestamp(value.getMillis()), calendarClone); } else { statement.setTimestamp(position, new Timestamp(value.getMillis())); } } else { statement.setNull(position, Types.TIMESTAMP); } } }
public void fileBug(Connection c, String key, Timestamp when, int id) throws Exception { PreparedStatement insertBugData = c .prepareStatement("UPDATE findbugs_issue SET bugDatabaseKey = ?, firstSeen = ? WHERE id = ?"); int col = 1; insertBugData.setString(col++, key); insertBugData.setTimestamp(col++, when); insertBugData.setInt(col++, id); // missing execute insertBugData.close(); }
genorm_statement.setString(1, m_metricId); genorm_statement.setTimestamp(2, m_startTime); genorm_statement.setTimestamp(3, m_endTime); ret = genorm_statement.executeUpdate();
/** * @throws Exception If failed. */ @Test public void testTimestamp() throws Exception { stmt = conn.prepareStatement("select * from TestObject where tsVal is not distinct from ?"); stmt.setTimestamp(1, new Timestamp(1)); ResultSet rs = stmt.executeQuery(); int cnt = 0; while (rs.next()) { if (cnt == 0) assert rs.getInt("id") == 1; cnt++; } assert cnt == 1; stmt.setNull(1, TIMESTAMP); rs = stmt.executeQuery(); cnt = 0; while (rs.next()) { if (cnt == 0) assert rs.getInt("id") == 2; cnt++; } assert cnt == 1; }
@SuppressFBWarnings(value = {"OBL_UNSATISFIED_OBLIGATION_EXCEPTION_EDGE", "SQL_PREPARED_STATEMENT_GENERATED_FROM_NONCONSTANT_STRING"}, justification = "findbugs does not trust jdbctemplate, sql is constant in practice") public PreparedStatement createPreparedStatement(Connection connection) throws SQLException { PreparedStatement ps = connection.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS); ps.setString(1, configInfo.getDataId()); ps.setString(2, configInfo.getGroup()); ps.setString(3, tenantTmp); ps.setString(4, appNameTmp); ps.setString(5, configInfo.getContent()); ps.setString(6, md5Tmp); ps.setString(7, srcIp); ps.setString(8, srcUser); ps.setTimestamp(9, time); ps.setTimestamp(10, time); ps.setString(11, desc); ps.setString(12, use); ps.setString(13, effect); ps.setString(14, type); ps.setString(15, schema); return ps; } }, keyHolder);
Object param = parameterValues[inputSplit.getSplitNumber()][i]; if (param instanceof String) { statement.setString(i + 1, (String) param); } else if (param instanceof Long) { statement.setLong(i + 1, (Long) param); } else if (param instanceof Integer) { statement.setInt(i + 1, (Integer) param); } else if (param instanceof Double) { statement.setDouble(i + 1, (Double) param); statement.setTime(i + 1, (Time) param); } else if (param instanceof Timestamp) { statement.setTimestamp(i + 1, (Timestamp) param); } else if (param instanceof Array) { statement.setArray(i + 1, (Array) param);
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);
/** * {@inheritDoc} */ @Override public void set(final PreparedStatement st, final int index, final Date value, final int dbSqlType) throws SQLException { st.setTimestamp(index, new Timestamp(value.getTime())); }
@Override public void setValues(PreparedStatement ps) throws SQLException { Timestamp t = new Timestamp(System.currentTimeMillis()); ps.setTimestamp(1, t); ps.setString(2, encNewPassword); ps.setTimestamp(3, getPasswordLastModifiedTimestamp(t)); ps.setString(4, id); ps.setString(5, zoneId); } });
genorm_statement.setString(1, metricId); genorm_statement.setTimestamp(2, startTime); genorm_statement.setTimestamp(3, endTime); ret = genorm_statement.executeUpdate();
/** * @throws Exception If failed. */ @Test public void testTimestamp() throws Exception { stmt = conn.prepareStatement("select * from TestObject where tsVal is not distinct from ?"); stmt.setTimestamp(1, new Timestamp(1)); ResultSet rs = stmt.executeQuery(); int cnt = 0; while (rs.next()) { if (cnt == 0) assert rs.getInt("id") == 1; cnt++; } assert cnt == 1; stmt.setNull(1, TIMESTAMP); rs = stmt.executeQuery(); cnt = 0; while (rs.next()) { if (cnt == 0) assert rs.getInt("id") == 2; cnt++; } assert cnt == 1; }
@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()); }
preparedStatement.setNull(index, column.getSqlType()); } else if (columnJavaType.equals(String.class)) { preparedStatement.setString(index, (String) column.getVal()); } else if (columnJavaType.equals(Integer.class)) { preparedStatement.setInt(index, (Integer) column.getVal()); } else if (columnJavaType.equals(Double.class)) { preparedStatement.setDouble(index, (Double) column.getVal()); preparedStatement.setTime(index, (Time) column.getVal()); } else if (columnJavaType.equals(Timestamp.class)) { preparedStatement.setTimestamp(index, (Timestamp) column.getVal()); } else { throw new RuntimeException("Unknown type of value " + column.getVal() + " for column " + column.getColumnName());
@Override public void setValues(PreparedStatement ps) throws SQLException { int pos = 1; ps.setString(pos++, id); ps.setString(pos++, group.getDisplayName()); ps.setString(pos++, group.getDescription()); ps.setTimestamp(pos++, new Timestamp(new Date().getTime())); ps.setTimestamp(pos++, new Timestamp(new Date().getTime())); ps.setInt(pos++, group.getVersion()); ps.setString(pos++, zoneId); } });
@Override @SuppressWarnings("unchecked") public CHILD setDate(int columnIndex, @Nullable Date value) throws SQLException { if (value == null) { pstmt.setNull(columnIndex, Types.TIMESTAMP); } else { pstmt.setTimestamp(columnIndex, new Timestamp(value.getTime())); } return (CHILD) this; } }
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); } }
genorm_statement.setString(1, m_metricId); genorm_statement.setTimestamp(2, m_timestamp); genorm_statement.setBytes(3, m_value); ret = genorm_statement.executeUpdate();
@Test public void testSetParameterValueWithTimestampAndUtilDate() throws SQLException { java.util.Date date = new java.util.Date(1000); StatementCreatorUtils.setParameterValue(preparedStatement, 1, Types.TIMESTAMP, null, date); verify(preparedStatement).setTimestamp(1, new java.sql.Timestamp(1000)); }