From dc643ba44fd2a426263015491268a0f0d6b4671d Mon Sep 17 00:00:00 2001
From: lrj <owen.stl@gmail.com>
Date: 星期三, 01 十月 2025 08:39:29 +0800
Subject: [PATCH] 删除包含test、check、fix的文件名的文件
---
backend/src/main/java/com/rongyichuang/tools/MockDataInserter.java | 16 +++++++---------
1 files changed, 7 insertions(+), 9 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..69410d6 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);
@@ -131,15 +130,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 +146,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