From 9f8395fab13ca4b230a0f7d62636e209745c91d4 Mon Sep 17 00:00:00 2001
From: lrj <owen.stl@gmail.com>
Date: 星期日, 28 九月 2025 14:16:18 +0800
Subject: [PATCH] feat: 完善注册流程的文件上传功能
---
backend/src/test/java/com/rongyichuang/tools/DataInsertTest.java | 12 +++++-------
1 files changed, 5 insertions(+), 7 deletions(-)
diff --git a/backend/src/test/java/com/rongyichuang/tools/DataInsertTest.java b/backend/src/test/java/com/rongyichuang/tools/DataInsertTest.java
index 68f10d0..0da2aa3 100644
--- a/backend/src/test/java/com/rongyichuang/tools/DataInsertTest.java
+++ b/backend/src/test/java/com/rongyichuang/tools/DataInsertTest.java
@@ -34,14 +34,13 @@
userIds.add(uid);
}
- // 3) 鎻掑叆 20 涓鍛橈紙鏈鏍� audit_state=0锛夛紝姣忎釜瀛﹀憳鍏宠仈瀵瑰簲 user_id
+ // 3) 鎻掑叆 20 涓鍛橈紝姣忎釜瀛﹀憳鍏宠仈瀵瑰簲 user_id
List<Long> playerIds = new ArrayList<>();
for (int i = 1; i <= 20; i++) {
long pid = insertPlayer(conn,
"鎵归噺瀛﹀憳" + i,
"1380014" + String.format("%04d", i),
1, // role_id
- 0, // audit_state 鏈鏍�
1, // state=1
userIds.get(i - 1));
playerIds.add(pid);
@@ -105,15 +104,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