java count = i,如何在Java程序中访问SQL count（）查询的值

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");

}

解决方案

Use aliases:

SELECT COUNT(*) AS total FROM ..

and then

rs3.getInt("total")