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/main/java/com/rongyichuang/tools/MockDataInserter.java | 12 +++++------- 1 files changed, 5 insertions(+), 7 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..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 姝e父 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); -- Gitblit v1.8.0