1.1

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.jh.util.DBUtil;

/**

• 数据库连接测试程序

• 2305-3 程永耀20233967 12月31号
  */
  public class TestDB {
  public static void main(String[] args) {
  System.out.println("测试数据库连接...");

   Connection conn = null;
   PreparedStatement pstmt = null;
   ResultSet rs = null;
   
   try {
       // 测试数据库连接
       conn = DBUtil.getConnection();
       if (conn != null) {
           System.out.println("✅ 数据库连接成功！");
           
           // 测试查询数据
           String sql = "SELECT COUNT(*) FROM user";
           pstmt = conn.prepareStatement(sql);
           rs = pstmt.executeQuery();
           if (rs.next()) {
               int count = rs.getInt(1);
               System.out.println("✅ 查询成功！用户总数：" + count);
           }
           
           // 测试查询任务数据
           sql = "SELECT COUNT(*) FROM task";
           pstmt = conn.prepareStatement(sql);
           rs = pstmt.executeQuery();
           if (rs.next()) {
               int count = rs.getInt(1);
               System.out.println("✅ 查询成功！任务总数：" + count);
           }
        数据库测试连接