@Override public void write(PreparedStatement statement, int index, Date value) throws SQLException { int sqlType = getSqlType(); if (value == null) { statement.setNull(index, sqlType); } else { long time = value.getTime(); statement.setDate(index, new java.sql.Date(time)); } }
ps.setString(paramIndex, inValue.toString()); ps.setString(paramIndex, strVal); if (inValue instanceof java.util.Date) { if (inValue instanceof java.sql.Date) { ps.setDate(paramIndex, (java.sql.Date) inValue); ps.setDate(paramIndex, new java.sql.Date(((java.util.Date) inValue).getTime())); ps.setDate(paramIndex, new java.sql.Date(cal.getTime().getTime()), cal); "Oracle".equals(ps.getConnection().getMetaData().getDatabaseProductName()))) { if (isStringValue(inValue.getClass())) { ps.setString(paramIndex, inValue.toString());
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.setShort(i + 1, (Short) param); } else if (param instanceof Date) { statement.setDate(i + 1, (Date) param); } else if (param instanceof Time) { statement.setTime(i + 1, (Time) param); resultSet = statement.executeQuery(); hasNext = resultSet.next(); } catch (SQLException se) {
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.setLong(index, (Long) column.getVal()); } else if (columnJavaType.equals(Date.class)) { preparedStatement.setDate(index, (Date) column.getVal()); } else if (columnJavaType.equals(Time.class)) { preparedStatement.setTime(index, (Time) column.getVal());
String sql = "INSERT INTO studenten (id, naam, adres, postcode, plaats, geboren)" + " VALUES (?, ?, ?, ?, ?, ?)"; Connection connection = null; PreparedStatement statement = null; try { connection = database.getConnection(); statement = connection.prepareStatement(sql); statement.setLong(lastId + 1); // Why don't you use an generated sequence? This is plain ugly and errorprone. statement.setString(contact.getNaam()); statement.setString(contact.getAdres()); statement.setString(contact.getPostcode()); statement.setString(contact.getPlaats()); statement.setDate(new java.sql.Date(contact.getGeboren().getTime())); // Assuming it returns java.util.Date statement.executeUpdate(); } finally { // Always close in finally to prevent resource leaks. if (statement != null) try { statement.close(); } catch (SQLException ignore) {} if (connection != null) try { connection.close(); } catch (SQLException ignore) {} }
private static void initPtsdbTableValues(long ts) throws Exception { ensureTableCreated(getUrl(),PTSDB_NAME,null, ts-2); String url = PHOENIX_JDBC_URL + ";" + PhoenixRuntime.CURRENT_SCN_ATTRIB + "=" + ts; // Insert at timestamp 0 Properties props = new Properties(TEST_PROPERTIES); Connection conn = DriverManager.getConnection(url, props); conn.setAutoCommit(true); PreparedStatement stmt = conn.prepareStatement("upsert into PTSDB VALUES ('x', 'y', ?, 0.5)"); stmt.setDate(1, D1); stmt.execute(); conn.close(); }
protected void updateStagedModelLastPublishDates( long groupId, String tableName, Date lastPublishDate) throws Exception { try (PreparedStatement ps = connection.prepareStatement( StringBundler.concat( "update ", tableName, " set lastPublishDate = ? where ", "groupId = ?"))) { ps.setDate(1, new java.sql.Date(lastPublishDate.getTime())); ps.setLong(2, groupId); ps.executeUpdate(); } }
private void assertNumRecords(int count, String sql, Connection conn, Date... params) throws Exception { PreparedStatement stmt = conn.prepareStatement(sql); int counter = 1; for (Date param : params) { stmt.setDate(counter++, param); } ResultSet rs = stmt.executeQuery(); assertTrue(rs.next()); assertEquals(count, rs.getInt(1)); }
int pointer = 0; int[] result = new int[paras.length]; PreparedStatement pst = conn.prepareStatement(sql); for (int i=0; i<paras.length; i++) { for (int j=0; j<paras[i].length; j++) { if (value instanceof java.util.Date) { if (value instanceof java.sql.Date) { pst.setDate(j + 1, (java.sql.Date)value); } else if (value instanceof java.sql.Timestamp) { pst.setTimestamp(j + 1, (java.sql.Timestamp)value);
case Types.LONGVARCHAR: if (value instanceof String) { pstmt.setString(i, (String) value); } else if (value == null) { pstmt.setNull(i, type); } else { pstmt.setString(i, value.toString()); pstmt.setBigDecimal(i, (BigDecimal) value); } else if (value instanceof Byte) { pstmt.setInt(i, ((Byte) value).intValue()); case Types.DATE: if (value instanceof java.sql.Date) { pstmt.setDate(i, (java.sql.Date) value); } else if (value instanceof java.util.Date) { pstmt.setDate(i, new java.sql.Date(((java.util.Date) value).getTime())); } else if (value instanceof String) { String v = (String) value; v = v.trim().replace(" ", "T"); DateTime dt = new DateTime(v); pstmt.setDate(i, new Date(dt.toDate().getTime())); } else { pstmt.setNull(i, type);
case CHARACTER: case STRING: preparedState.setString(index, isNull ? null : String.valueOf(param.getValue())); break; case PRIMITIVE_INT: case INTEGER: preparedState.setInt(index, isNull ? 0 : Integer.parseInt(param.getValue())); break; case PRIMITIVE_SHORT: case JAVA_UTIL_DATE: case JAVA_SQL_DATE: preparedState.setDate(index, isNull ? null : java.sql.Date.valueOf(param.getValue())); break; case JAVA_SQL_TIME:
private static void initPTSDBTableValues1(String pTSDBTableName) throws Exception { ensureTableCreated(getUrl(),pTSDBTableName, PTSDB_NAME, null, null, null); String url = getUrl(); // Insert at timestamp 0 Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES); Connection conn = DriverManager.getConnection(url, props); conn.setAutoCommit(true); PreparedStatement stmt = conn.prepareStatement("upsert into "+pTSDBTableName+" VALUES ('x', 'y', ?, 0.5)"); stmt.setDate(1, D1); stmt.execute(); conn.close(); }
@Signature public void bind(Environment env, int index, Memory value) throws SQLException { if (value.instanceOf(WrapTime.class)) { WrapTime time = value.toObject(WrapTime.class); statement.setDate(index + 1, new Date(time.getDate().getTime()), time.getCalendar()); } else if (value.instanceOf(Stream.class)) { statement.setBlob(index + 1, Stream.getInputStream(env, value)); } else if (value.toValue() instanceof BinaryMemory) { statement.setBytes(index + 1, value.getBinaryBytes(env.getDefaultCharset())); } else { if (value.isNull()) { statement.setNull(index + 1, Types.NULL); } else { switch (value.getRealType()) { case INT: statement.setLong(index + 1, value.toLong()); break; case DOUBLE: statement.setDouble(index + 1, value.toDouble()); break; case BOOL: statement.setBoolean(index + 1, value.toBoolean()); break; default: statement.setString(index + 1, value.toString()); } } } }
int size = list.size(); int[] result = new int[size]; PreparedStatement pst = conn.prepareStatement(sql); for (int i=0; i<size; i++) { Map map = isModel ? ((Model)list.get(i))._getAttrs() : ((Record)list.get(i)).getColumns(); if (value instanceof java.util.Date) { if (value instanceof java.sql.Date) { pst.setDate(j + 1, (java.sql.Date)value); } else if (value instanceof java.sql.Timestamp) { pst.setTimestamp(j + 1, (java.sql.Timestamp)value);
break; case Types.INTEGER: stmt.setInt(parameterIndex, Integer.parseInt(parameterValue)); break; case Types.BIGINT: break; case Types.DATE: stmt.setDate(parameterIndex, new Date(Long.parseLong(parameterValue))); break; case Types.TIME: case Types.LONGNVARCHAR: case Types.LONGVARCHAR: stmt.setString(parameterIndex, parameterValue); break; default:
case java.sql.Types.LONGVARCHAR: case java.sql.Types.LONGNVARCHAR: upload.setString(index + 1, (String) row.getField(index)); break; case java.sql.Types.TINYINT: break; case java.sql.Types.INTEGER: upload.setInt(index + 1, (int) row.getField(index)); break; case java.sql.Types.BIGINT: break; case java.sql.Types.DATE: upload.setDate(index + 1, (java.sql.Date) row.getField(index)); break; case java.sql.Types.TIME:
@Test public void testSetParameterValueWithDateAndCalendar() throws SQLException { java.util.Calendar cal = new GregorianCalendar(); StatementCreatorUtils.setParameterValue(preparedStatement, 1, Types.DATE, null, cal); verify(preparedStatement).setDate(1, new java.sql.Date(cal.getTime().getTime()), cal); }
preparedStatement.setString( index, getString( data ) ); } else { String string = getString( data ); preparedStatement.setCharacterStream( index, new StringReader( string ), string.length() ); } else { preparedStatement.setString( index, string ); java.sql.Date ddate = new java.sql.Date( dat ); if ( ignoreTimezone || this.getDateFormatTimeZone() == null ) { preparedStatement.setDate( index, ddate ); } else { preparedStatement.setDate( index, ddate, Calendar.getInstance( this.getDateFormatTimeZone() ) ); preparedStatement.setString( index, getBoolean( data ).booleanValue() ? "Y" : "N" ); } else { preparedStatement.setNull( index, java.sql.Types.CHAR );
break; case Types.INTEGER: stmt.setInt(parameterIndex, Integer.parseInt(parameterValue)); break; case Types.BIGINT: break; case Types.DATE: stmt.setDate(parameterIndex, new Date(Long.parseLong(parameterValue))); break; case Types.TIME: case Types.LONGNVARCHAR: case Types.LONGVARCHAR: stmt.setString(parameterIndex, parameterValue); break; default: