test-db-connection.bat 1.0 KB

123456789101112131415161718192021222324252627282930313233343536
  1. @echo off
  2. echo ========== 数据库连接测试开始 ==========
  3. REM 查找 MySQL JDBC 驱动(Maven 本地仓库)
  4. set DRIVER_JAR=%USERPROFILE%\.m2\repository\com\mysql\mysql-connector-j\8.4.0\mysql-connector-j-8.4.0.jar
  5. if not exist "%DRIVER_JAR%" (
  6. echo ❌ MySQL JDBC 驱动未找到: %DRIVER_JAR%
  7. echo 请确保已通过 Maven 下载依赖
  8. pause
  9. exit /b 1
  10. )
  11. echo ✅ 找到 MySQL JDBC 驱动: %DRIVER_JAR%
  12. echo.
  13. REM 编译 SimpleDBTest
  14. echo 正在编译 SimpleDBTest.java...
  15. javac -cp "%DRIVER_JAR%" "D:\tmp\ai_coding\projects\business-webapi\src\test\java\com\hz3r\infrastructure\park\SimpleDBTest.java" -d "D:\tmp\ai_coding\projects\business-webapi\target\test-classes" 2>&1
  16. if errorlevel 1 (
  17. echo ❌ 编译失败
  18. pause
  19. exit /b 1
  20. )
  21. echo ✅ 编译成功
  22. echo.
  23. REM 运行测试
  24. echo 正在测试数据库连接...
  25. java -cp "D:\tmp\ai_coding\projects\business-webapi\target\test-classes;%DRIVER_JAR%" com.hz3r.infrastructure.park.SimpleDBTest 2>&1
  26. echo.
  27. echo ========== 数据库连接测试结束 ==========
  28. pause