The Java Developers Almanac 1.4

Home > List of Packages > java.sql [73 examples] > Retrieving Data [7 examples]

e255. Getting the Number of Rows in a Database Table

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) {
    }

Related Examples

e251. Getting Rows from a Database Table
e252. Getting Data from a Result Set
e253. Determining If a Fetched Value Is NULL
e254. Getting the Column Names in a Result Set
e256. Getting BLOB Data from a Database Table
e257. Matching with Wildcards in a SQL Statement

See also: Batching Connections Database Meta Data Deleting Data Drivers Importing and Exporting Inserting and Updating Data Oracle OBJECTs Oracle VARRAYs Procedures and Functions Scrollable Result Sets Tables Updatable Result Sets

© 2002 Addison-Wesley.