From 7ad9c3c93f0cc103347ae2e2429e0122fb512e24 Mon Sep 17 00:00:00 2001
From: lrj <owen.stl@gmail.com>
Date: 星期三, 01 十月 2025 21:26:12 +0800
Subject: [PATCH] feat: 修复员工管理功能并优化UI
---
backend/src/test/java/com/rongyichuang/DatabaseSchemaTest.java | 16 ++++++++++++++++
1 files changed, 16 insertions(+), 0 deletions(-)
diff --git a/backend/src/test/java/com/rongyichuang/DatabaseSchemaTest.java b/backend/src/test/java/com/rongyichuang/DatabaseSchemaTest.java
index 74d8b40..39b5ef9 100644
--- a/backend/src/test/java/com/rongyichuang/DatabaseSchemaTest.java
+++ b/backend/src/test/java/com/rongyichuang/DatabaseSchemaTest.java
@@ -58,4 +58,20 @@
System.out.println(table);
}
}
+
+ @Test
+ public void testForeignKeyConstraints() {
+ try {
+ String sql = "SELECT CONSTRAINT_NAME, TABLE_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME " +
+ "FROM information_schema.KEY_COLUMN_USAGE " +
+ "WHERE TABLE_SCHEMA = 'ryc' AND REFERENCED_TABLE_NAME IS NOT NULL";
+ List<Map<String, Object>> result = jdbcTemplate.queryForList(sql);
+ System.out.println("=== 澶栭敭绾︽潫 ===");
+ for (Map<String, Object> row : result) {
+ System.out.println(row);
+ }
+ } catch (Exception e) {
+ System.out.println("鏌ヨ澶栭敭绾︽潫澶辫触: " + e.getMessage());
+ }
+ }
}
\ No newline at end of file
--
Gitblit v1.8.0