java - 错误: No operations allowed after statement closed

Question

我正在尝试执行此代码，但出现此错误，我知道我必须使用

关闭连接

preparedStatement.close() 

但是在治疗完成之前它就关闭了，并且给了我以下错误

Caused by: java.sql.SQLException: No operations allowed after statement closed.

我的代码

    private void fakesAssociate(List<Map<String, Object>> Employees) {
    coreEmployees.forEach(row -> {
        try {
            myrefJdbcTemplate.update("INSERT INTO `n_associate` (`active`, `first_name`, `birthday`) VALUES ( ?, ?, ? );", preparedStatement -> {
                   preparedStatement.setBoolean(1, true);
                   preparedStatement.setString(2, String.valueOf(row.get("usual_first_name")));

                Date birthdate = ((Date) row.get("birth_date"));
                if (birthdate != null) {
                    Calendar calendar = Calendar.getInstance();
                    calendar.setTime(birthdate);
                    calendar.set(Calendar.YEAR, 1970);
                    preparedStatement.setDate(3, new Date(calendar.getTime().getTime()));
                } else {
                    preparedStatement.setDate(3, null);
                }

                preparedStatement.close();
            });

            });
        } catch (DataIntegrityViolationException e) {
            String queryAssociate = "UPDATE n_associate SET  `active`= ?  " +
                WHERE n_associate.first_name = ?;";

            myrefJdbcTemplate.update(queryAssociate, preparedStatement -> {

                    preparedStatement.setBoolean(1, false);
                preparedStatement.close();

            });
        }
    });
}

请帮忙看看如何解决

Answer 1

不要关闭语句。 JdbcTemplate 需要打开它才能执行它。 JdbcTemplate 将在使用完毕后关闭该语句。