加入了登录注册页面（ptstation-register文件夹），需启动react前端和创建虚拟环境并安装requirements.txt并运行run_server.py
Change-Id: I6abba3854c517286245d118a591e00761ac98685
diff --git a/ptstation-register/backend/test.py b/ptstation-register/backend/test.py
new file mode 100644
index 0000000..b27d10c
--- /dev/null
+++ b/ptstation-register/backend/test.py
@@ -0,0 +1,51 @@
+import pymysql
+import bcrypt
+import config # 使用你已有的 config.get_db_connection()
+
+def insert_test_user():
+ email = '22301110@bjtu.edu.cn'
+ password = '123456'
+ hashed_pwd = bcrypt.hashpw(password.encode(), bcrypt.gensalt()).decode()
+
+ try:
+ conn = config.get_db_connection()
+ cursor = conn.cursor()
+
+ cursor.execute("""
+ INSERT INTO sys_user (
+ user_name, nick_name, password, email, create_time, del_flag, status, user_type
+ ) VALUES (%s, %s, %s, %s, NOW(), '0', '0', '00')
+ """, (email, email, hashed_pwd, email))
+
+ conn.commit()
+ print("✅ 用户插入成功")
+ except Exception as e:
+ print("❌ 插入失败:", e)
+ finally:
+ cursor.close()
+ conn.close()
+
+
+def delete_test_user():
+ email = '22301110@bjtu.edu.cn'
+
+ try:
+ conn = config.get_db_connection()
+ cursor = conn.cursor()
+
+ cursor.execute("DELETE FROM sys_user WHERE email = %s", (email,))
+ conn.commit()
+ print("🗑️ 用户删除成功")
+ except Exception as e:
+ print("❌ 删除失败:", e)
+ finally:
+ cursor.close()
+ conn.close()
+
+
+if __name__ == '__main__':
+ # 测试：插入
+ #insert_test_user()
+
+ # 测试：删除
+ delete_test_user()