select count(*)

Scenario:
I dont know much about JDBC. I want to find the number of records in a table.

The SQL statement for it is : SELECT COUNT(NAME) FROM USERS

Here NAME is an attribute of the USERS table.

Problem:
I have tried executeQuery and executeUpdate methods of the Statement class. But I have got only errors. Can someone help me?

I haven't checked so I might be totaly wrong: but don't you need a "WHERE" statement?
Example:
SELECT count(name) FROM Users WHERE 1;

If it's not that, then I would need to see how you do it in your code and what errors you get.

(*) Well..... thanks for your help Dalisra. I have not tried your solution. But I got the solution to my problem.

The solution is as follows

Code :

---

Statement st = con.createStatement(); // con is reference of type Connection.
ResultSet rs = st.executeQuery("SELECT [B]COUNT(NAME) AS N1[/B] FROM USERS");
rs.next();
int number = rs.getInt("N1");
System.out.println("Number of Users : " + number);
rs.close();
con.close();

---

It works.(*)
The above code has to be in a method. The package java.sql has to be imported.

Ahh, I am glad you found that out.

Your problem seems to occur at this point:
"SELECT COUNT(NAME) AS N1 FROM USERS"

You can perform your functionality as follow:
Statement st = con.createStatement(); // con is reference of type Connection.
ResultSet rs = st.executeQuery("SELECT COUNT(NAME) AS N1 FROM USERS");
rs.next();
int number = rs.getInt("N1");// the parameter is columnName
//int number = rs.getInt(1); //the parameter is columnIndex;
System.out.println("Number of
System.out.println("Number of Users : " + number);
rs.close();
con.close();