通过PreparedStatement.setObject()方法向Oracle插入Date类型数据，报错:请求的转换无效

 

/**
    * Sets the value of the designated parameter with the given object.
    *
    * This method is similar to {@link #setObject(int parameterIndex,
    * Object x, int targetSqlType, int scaleOrLength)},
    * except that it assumes a scale of zero.
    *
    * @param parameterIndex the first parameter is 1, the second is 2, ...
    * @param x the object containing the input parameter value
    * @param targetSqlType the SQL type (as defined in java.sql.Types) to be
    *                      sent to the database
    * @exception SQLException if parameterIndex does not correspond to a parameter
    * marker in the SQL statement; if a database access error occurs or this
    * method is called on a closed PreparedStatement
    * @exception SQLFeatureNotSupportedException if
    * the JDBC driver does not support the specified targetSqlType
    * @see Types
    */
    void setObject(int parameterIndex, Object x, int targetSqlType)
      throws SQLException;

// 调用如下
date = new SimpleDateFormat("yyyy-MM-dd").parse(dateColumn);
preparedStatement.setObject(index,date,Types.DATE);

// 在传入第二个参数Object x 时，传入的是date对象，导致报错： 请求的转换无效

// 将传入的对象改为String类型后解决问题
date = new SimpleDateFormat("yyyy-MM-dd").parse(dateColumn);
String datefmt = new SimpleDateFormat("yyyy-MM-dd").format(date);
preparedStatement.setObject(index,datefmt ,Types.DATE);

// 汗！