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

Question

I want to get to the value I am finding using the COUNT command of SQL. Normally I enter the column name I want to access into the getInt() getString() method, what do I do in this case when there is no specific column name.

I have used 'AS' in the same manner as is used to alias a table, I am not sure if this is going to work, I would think not.

Statement stmt3 = con.createStatement(); ResultSet rs3 = stmt3.executeQuery("SELECT COUNT(*) FROM "+lastTempTable+") AS count");     while(rs3.next()){     count = rs3.getInt("count");     } 

Answer 1

Use aliases:

SELECT COUNT(*) AS total FROM .. 

and then

rs3.getInt("total") 

Answer 2

The answers provided by Bohzo and Brabster will obviously work, but you could also just use:

rs3.getInt(1); 

to get the value in the first, and in your case, only column.