java - 如何在 Spring Prepared Statement 中传递 Java Date

Question

如果我有一个 Java 日期并且使用 JDBCTEmplate 我想在准备好的语句中使用它，这是正确的语法吗？

Date x = new Date();

...

String SQL = "select a.1, a.2 from b JOIN a ON b.id = a.b_id where b.name = ? and a.type = ? and a.date = ?";

A istance = jdbcTemplate.queryForObject(SQL, new Object[]{variable_1, variable_2, x}, new aAndbMapper());

或者我应该这样写:

String SQL = "select a.1, a.2 from b JOIN a ON b.id = a.b_id where b.name = ? and a.type = ? and DATE(a.date) = ?";

Answer 1

第一个是一个不错的选择，尽管我会在没有自定义映射器的情况下这样做:

String SQL = "select a.1, a.2 from b JOIN a ON b.id = a.b_id where b.name = ? and a.type = ? and a.date = ?";

A istance = getJdbcTemplate().queryForObject(SQL, new Object[]{variable_1, variable_2, x}, new BeanPropertyRowMapper(A.class));

关于 beanPropertymapper 的更多信息:Documentation