java获取mysql数据库表行数

import java.sql.*;

public class Main {
  public static void main(String[] args) {
    try {
      // 加载MySQL数据库驱动程序
      Class.forName("com.mysql.jdbc.Driver");
      
      // 创建数据库连接
      Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/database", "username", "password");
      
      // 创建SQL语句
      String sql = "SELECT COUNT(*) FROM table_name";
      
      // 创建Statement对象
      Statement statement = connection.createStatement();
      
      // 执行查询语句
      ResultSet resultSet = statement.executeQuery(sql);
      
      // 获取行数
      if (resultSet.next()) {
        int rowCount = resultSet.getInt(1);
        System.out.println("表的行数为：" + rowCount);
      }
      
      // 关闭连接
      resultSet.close();
      statement.close();
      connection.close();
    } catch (Exception e) {
      e.printStackTrace();
    }
  }
}