Java and access

[connor]

Good evening,
I have been attempting to account for the rows of the table of a database and that I will be returned to volar to then start a count in Java.
My problem is that I enter the sql code and it does not give me the value of the count of the columns.

I'll leave the code here.

Select all

 
try{ 
            String query = 
                    "SELECT COUNT(*) FROM Clientes="; 
            System.out.println("query: " +query); 

Can anyone help me?

[adrianoturbo]

Brother, create a class like this:

Select all

 
//Create a Statement class to execute the SQL statement 
Statement stmt = con.createStatement(); 
 
ResultSet rs = stmt.executeQuery("SELECT COUNT(*) AS COUNT FROM 
CLIENTES"); 
 
 while(rs.next()) { 
    System.out.println("The count is " + rs.getInt("COUNT")); 
 }