From c4938f6f4e839890b032c75c7a57333a6a9157a9 Mon Sep 17 00:00:00 2001
From: peng <peng.com>
Date: 星期四, 06 十一月 2025 17:06:10 +0800
Subject: [PATCH] 添加新闻功能
---
backend/src/main/java/com/rongyichuang/tools/MockDataInserter.java | 15 +++++++--------
1 files changed, 7 insertions(+), 8 deletions(-)
diff --git a/backend/src/main/java/com/rongyichuang/tools/MockDataInserter.java b/backend/src/main/java/com/rongyichuang/tools/MockDataInserter.java
index 8badbed..e9f2418 100644
--- a/backend/src/main/java/com/rongyichuang/tools/MockDataInserter.java
+++ b/backend/src/main/java/com/rongyichuang/tools/MockDataInserter.java
@@ -48,14 +48,13 @@
userIds.add(uid);
}
- // 3) 鎻掑叆 20 涓鍛橈紙audit_state=0 鏈鏍革級
+ // 3) 鎻掑叆 20 涓鍛�
List<Long> playerIds = new ArrayList<>();
for (int i = 1; i <= 20; i++) {
long pid = insertPlayer(conn,
"瀛﹀憳" + i,
"1380013" + String.format("%04d", i),
1, // role_id
- 0, // audit_state 鏈鏍�
1, // state=1 姝ｅ父
userIds.get(i - 1));
playerIds.add(pid);
@@ -102,11 +101,12 @@
}
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);
@@ -131,15 +131,14 @@
throw new SQLException("鎻掑叆鐢ㄦ埛澶辫触");
}
- private long insertPlayer(Connection conn, String name, String phone, long roleId, int auditState, int state, long userId) throws SQLException {
- String sql = "INSERT INTO t_player (name, phone, role_id, audit_state, state, user_id) VALUES (?, ?, ?, ?, ?, ?)";
+ private long insertPlayer(Connection conn, String name, String phone, long roleId, int state, long userId) throws SQLException {
+ String sql = "INSERT INTO t_player (name, phone, role_id, state, user_id) VALUES (?, ?, ?, ?, ?)";
try (PreparedStatement ps = conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS)) {
ps.setString(1, name);
ps.setString(2, phone);
ps.setLong(3, roleId);
- ps.setInt(4, auditState);
- ps.setInt(5, state);
- ps.setLong(6, userId);
+ ps.setInt(4, state);
+ ps.setLong(5, userId);
ps.executeUpdate();
try (ResultSet keys = ps.getGeneratedKeys()) {
if (keys.next()) return keys.getLong(1);
--
Gitblit v1.8.0