/**
* 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);
// 汗!