From ba94ceae1315174798ae1967ef62268c6d16cd5b Mon Sep 17 00:00:00 2001
From: Codex Assistant <codex@example.com>
Date: 星期一, 06 十月 2025 22:07:06 +0800
Subject: [PATCH] feat: 评审与活动相关改动 - backend(GraphQL): Activity schema 增加 updateActivityState(id, state)；实现 resolver/service 仅更新 state=2 作为逻辑删除 - backend(GraphQL): region.graphqls 新增 Query leafRegions - backend(GraphQL): player.graphqls 的 projectReviewApplications 增加可选参数 regionId - backend(Service): listProjectReviewApplications 绑定 regionId 参数，修复 QueryParameterException - frontend(web): 新增 api/activity.js 的 updateActivityState 并接入 activity-list 删除逻辑 - frontend(web): review-list.vue 权限仅校验登录，移除角色限制；查询参数修正为 name/regionId - frontend(web): 删除未引用的 ActivityList.vue - frontend(web): projectReviewNew.js GraphQL 查询增加 name 参数
---
backend/src/test/java/com/rongyichuang/DatabaseConnectionTest.java | 60 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 60 insertions(+), 0 deletions(-)
diff --git a/backend/src/test/java/com/rongyichuang/DatabaseConnectionTest.java b/backend/src/test/java/com/rongyichuang/DatabaseConnectionTest.java
new file mode 100644
index 0000000..3bb1355
--- /dev/null
+++ b/backend/src/test/java/com/rongyichuang/DatabaseConnectionTest.java
@@ -0,0 +1,60 @@
+package com.rongyichuang;
+
+import org.junit.jupiter.api.Test;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.boot.test.context.SpringBootTest;
+import org.springframework.jdbc.core.JdbcTemplate;
+
+import java.util.List;
+import java.util.Map;
+
+@SpringBootTest
+public class DatabaseConnectionTest {
+
+ @Autowired
+ private JdbcTemplate jdbcTemplate;
+
+ @Test
+ public void testDatabaseConnection() {
+ try {
+ // 妫�鏌ユ暟鎹簱杩炴帴
+ String result = jdbcTemplate.queryForObject("SELECT 1", String.class);
+ System.out.println("鉁� 鏁版嵁搴撹繛鎺ユ垚鍔�: " + result);
+
+ // 妫�鏌_wx_login_record琛ㄦ槸鍚﹀瓨鍦�
+ try {
+ String checkTableSql = "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'ryc' AND table_name = 't_wx_login_record'";
+ Integer tableExists = jdbcTemplate.queryForObject(checkTableSql, Integer.class);
+
+ if (tableExists != null && tableExists > 0) {
+ System.out.println("鉁� t_wx_login_record琛ㄥ瓨鍦�");
+
+ // 鏌ョ湅琛ㄧ粨鏋�
+ String describeTableSql = "DESCRIBE t_wx_login_record";
+ List<Map<String, Object>> columns = jdbcTemplate.queryForList(describeTableSql);
+ System.out.println("琛ㄧ粨鏋�:");
+ for (Map<String, Object> column : columns) {
+ System.out.println("- " + column.get("Field") + ": " + column.get("Type") +
+ (column.get("Null").equals("NO") ? " NOT NULL" : " NULL") +
+ (column.get("Default") != null ? " DEFAULT " + column.get("Default") : ""));
+ }
+
+ // 妫�鏌ヨ〃涓槸鍚︽湁鏁版嵁
+ String countSql = "SELECT COUNT(*) FROM t_wx_login_record";
+ Integer recordCount = jdbcTemplate.queryForObject(countSql, Integer.class);
+ System.out.println("琛ㄤ腑璁板綍鏁�: " + recordCount);
+
+ } else {
+ System.out.println("鉂� t_wx_login_record琛ㄤ笉瀛樺湪");
+ }
+ } catch (Exception e) {
+ System.out.println("鉂� 妫�鏌_wx_login_record琛ㄦ椂鍑洪敊: " + e.getMessage());
+ e.printStackTrace();
+ }
+
+ } catch (Exception e) {
+ System.out.println("鉂� 鏁版嵁搴撹繛鎺ュけ璐�: " + e.getMessage());
+ e.printStackTrace();
+ }
+ }
+}
\ No newline at end of file
--
Gitblit v1.8.0