oracle软解析 java对应代码

private void checkTxId() {
        String before = CalendarUtil.getPreMinuteDateTime("30");
        final String date = before.substring(0, 4) + "-" + before.substring(4, 6) + "-" + before.substring(6, 8);
        final String time = before.substring(8, 10) + ":" + before.substring(10, 12) + ":" + before.substring(12, 14);
//        String updateSql = "UPDATE TX_TABLE SET FSN_SEND_FLAG = 0 WHERE (FSN_SEND_DATE <'"
//                + date + "' OR (FSN_SEND_DATE ='"
//                + date + "' AND FSN_SEND_TIME <'"
//                + time + "')) AND (FSN_SEND_FLAG = 1 OR FSN_SEND_FLAG = 3)";
//        jdbcTemplate.execute(updateSql);
//        Object[] params = new Object[]{date, date, time};
//        String updateSql = "UPDATE TX_TABLE SET FSN_SEND_FLAG = 0 WHERE (FSN_SEND_DATE < ? OR (FSN_SEND_DATE = ? AND FSN_SEND_TIME < ? )) AND (FSN_SEND_FLAG = 1 OR FSN_SEND_FLAG = 3)";
//        jdbcTemplate.update(updateSql, params);
        String updateSql = "UPDATE TX_TABLE SET FSN_SEND_FLAG = 0 WHERE (FSN_SEND_DATE < ? OR (FSN_SEND_DATE = ? AND FSN_SEND_TIME < ? )) AND (FSN_SEND_FLAG = 1 OR FSN_SEND_FLAG = 3)";
        jdbcTemplate.update(updateSql, new PreparedStatementSetter(){
            @Override
            public void setValues(PreparedStatement ps) throws SQLException {
                ps.setString(1, date);
                ps.setString(2, date);
                ps.setString(3, time);
            }
        });
    }