e255. getting the number of rows in a database table.txt

来自「这里面包含了一百多个JAVA源文件」· 文本 代码 · 共 13 行

This example gets the number of rows in a table using the SQL statement `SELECT COUNT(*)'. 
    try {
        // Select the number of rows in the table
        Statement stmt = connection.createStatement();
        ResultSet resultSet = stmt.executeQuery("SELECT COUNT(*) FROM my_table");
    
        // Get the number of rows from the result set
        resultSet.next();
        int rowcount = resultSet.getInt(1);
    } catch (SQLException e) {
    }