From 0a48616045ddce1562584543a0e89e5144051fde Mon Sep 17 00:00:00 2001
From: Codex Assistant <codex@example.com>
Date: 星期日, 05 十月 2025 14:52:44 +0800
Subject: [PATCH] 报名审核
---
backend/src/test/java/com/rongyichuang/DatabaseConnectionTest.java | 68 +++++++++++++++-------------------
1 files changed, 30 insertions(+), 38 deletions(-)
diff --git a/backend/src/test/java/com/rongyichuang/DatabaseConnectionTest.java b/backend/src/test/java/com/rongyichuang/DatabaseConnectionTest.java
index c1cc1bd..3bb1355 100644
--- a/backend/src/test/java/com/rongyichuang/DatabaseConnectionTest.java
+++ b/backend/src/test/java/com/rongyichuang/DatabaseConnectionTest.java
@@ -8,9 +8,6 @@
import java.util.List;
import java.util.Map;
-/**
- * 鏁版嵁搴撹繛鎺ユ祴璇�
- */
@SpringBootTest
public class DatabaseConnectionTest {
@@ -20,48 +17,43 @@
@Test
public void testDatabaseConnection() {
try {
- // 娴嬭瘯鏁版嵁搴撹繛鎺�
- String sql = "SELECT 1 as test";
- Integer result = jdbcTemplate.queryForObject(sql, Integer.class);
- System.out.println("鏁版嵁搴撹繛鎺ユ祴璇曟垚鍔燂紝缁撴灉: " + result);
+ // 妫�鏌ユ暟鎹簱杩炴帴
+ String result = jdbcTemplate.queryForObject("SELECT 1", String.class);
+ System.out.println("鉁� 鏁版嵁搴撹繛鎺ユ垚鍔�: " + result);
- // 鏌ヨ鎵�鏈夎〃
- String tablesSql = "SHOW TABLES";
- List<Map<String, Object>> tables = jdbcTemplate.queryForList(tablesSql);
- System.out.println("鏁版嵁搴撲腑鐨勮〃:");
- for (Map<String, Object> table : tables) {
- System.out.println("- " + table.values().iterator().next());
- }
-
- } catch (Exception e) {
- System.err.println("鏁版嵁搴撹繛鎺ユ祴璇曞け璐�: " + e.getMessage());
- e.printStackTrace();
- }
- }
-
- @Test
- public void testTableStructure() {
- try {
- // 鑾峰彇琛ㄧ粨鏋勪俊鎭�
- String[] tables = {"t_activity", "t_judge", "t_player", "t_rating_scheme", "t_carousel", "t_employee", "t_media", "t_tag"};
-
- for (String tableName : tables) {
- try {
- String sql = "DESCRIBE " + tableName;
- List<Map<String, Object>> columns = jdbcTemplate.queryForList(sql);
- System.out.println("\n琛� " + tableName + " 鐨勭粨鏋�:");
+ // 妫�鏌_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" : "") +
- (column.get("Key").equals("PRI") ? " PRIMARY KEY" : ""));
+ 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") : ""));
}
- } catch (Exception e) {
- System.out.println("琛� " + tableName + " 涓嶅瓨鍦ㄦ垨鏌ヨ澶辫触: " + e.getMessage());
+
+ // 妫�鏌ヨ〃涓槸鍚︽湁鏁版嵁
+ 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.err.println("鏌ヨ琛ㄧ粨鏋勫け璐�: " + e.getMessage());
+ System.out.println("鉂� 鏁版嵁搴撹繛鎺ュけ璐�: " + e.getMessage());
e.printStackTrace();
}
}
--
Gitblit v1.8.0