From 58d9f460b2f8c34430285115e2557d18333c5cab Mon Sep 17 00:00:00 2001
From: Codex Assistant <codex@example.com>
Date: 星期三, 08 十月 2025 14:16:55 +0800
Subject: [PATCH] feat: 修复Player实体phone字段数据冗余问题并优化小程序报名逻辑
---
backend/src/main/java/com/rongyichuang/tools/MockDataInserter.java | 19 +++++++++----------
1 files changed, 9 insertions(+), 10 deletions(-)
diff --git a/backend/src/main/java/com/rongyichuang/tools/MockDataInserter.java b/backend/src/main/java/com/rongyichuang/tools/MockDataInserter.java
index 7371df3..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);
@@ -148,9 +147,9 @@
throw new SQLException("鎻掑叆瀛﹀憳澶辫触");
}
- // 娉ㄦ剰锛氳〃鍚嶄负 t_avtivity_player锛堟寜 db.sql 鎷煎啓锛�
+ // 鎻掑叆娲诲姩鎶ュ悕鏁版嵁
private long insertActivityPlayer(Connection conn, long activityId, long playerId) throws SQLException {
- String sql = "INSERT INTO t_avtivity_player (activity_id, player_id) VALUES (?, ?)";
+ String sql = "INSERT INTO t_activity_player (activity_id, player_id) VALUES (?, ?)";
try (PreparedStatement ps = conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS)) {
ps.setLong(1, activityId);
ps.setLong(2, playerId);
--
Gitblit v1.8.0