How to access SQL count () query value in Java program

Question

I want to get the value that I find using the COUNT SQL command. Usually I enter the column name that I want to get in the getInt () method getString (), what should I do in this case when there is no specific column name.

I used "AS" in the same way as for the table alias, I'm not sure if this will work, I would not have thought.

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 of Bohzo and Brabster will work, but you can also just use:

 rs3.getInt(1); 

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

Answer 3

I would expect this request to work with your program:

"SELECT COUNT(*) AS count FROM "+lastTempTable+")"

(You need to add a column alias, not a table)

Answer 4

I did it like this (example):

 String query="SELECT count(t1.id) from t1, t2 where t1.id=t2.id and t2.email='"[e-mail]"'"; int count=0; try { ResultSet rs = DatabaseService.statementDataBase().executeQuery(query); while(rs.next()) count=rs.getInt(1); } catch (SQLException e) { e.printStackTrace(); } finally { //... } 

Answer 5

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