| | |
|---|
| | | } |
|---|
| | | |
|---|
| | | private long insertActivity(Connection conn, String name, String path, int deadlineDays) throws SQLException { |
|---|
| | | String sql = "INSERT INTO t_activity (pid, path, name, signup_deadline, rating_scheme_id, state) VALUES (0, ?, ?, ?, 1, 1)"; |
|---|
| | | String sql = "INSERT INTO t_activity (pid, path, name, signup_deadline, match_time, rating_scheme_id, state) VALUES (0, ?, ?, ?, ?, 1, 1)"; |
|---|
| | | try (PreparedStatement ps = conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS)) { |
|---|
| | | ps.setString(1, path); |
|---|
| | | ps.setString(2, name); |
|---|
| | | ps.setTimestamp(3, Timestamp.valueOf(LocalDateTime.now().plusDays(deadlineDays))); |
|---|
| | | ps.setTimestamp(4, Timestamp.valueOf(LocalDateTime.now().plusDays(deadlineDays + 3))); // 比赛时间比报名截止时间晚3天 |
|---|
| | | ps.executeUpdate(); |
|---|
| | | try (ResultSet keys = ps.getGeneratedKeys()) { |
|---|
| | | if (keys.next()) return keys.getLong(1); |
|---|
