How do you access the value of an SQL count () query in a Java program

https://stackoverflow.com/questions/2763659/how-do-you-access-the-value-of-an-sql-count-query-in-a-java-program

Use aliases:

SELECT COUNT(*) AS total FROM ..

and then

rs3.getInt("total")