Java mysql获取行数

import java.sql.*;

public class MySQLRowCount {
    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/your_database";
        String user = "username";
        String password = "password";

        try (Connection conn = DriverManager.getConnection(url, user, password)) {
            String sql = "SELECT COUNT(*) FROM your_table";
            try (PreparedStatement pstmt = conn.prepareStatement(sql);
                 ResultSet rs = pstmt.executeQuery()) {
                if (rs.next()) {
                    int rowCount = rs.getInt(1);
                    System.out.println("Row count: " + rowCount);
                }
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

ResultSet rs = statement.executeQuery("SELECT * FROM your_table");
rs.last(); // 移动到最后一行
int rowCount = rs.getRow(); // 获取当前行号，即总行数