Possible Duplicate:
How do I get the row count in JDBC?
Hi,
How can I count a query in a row in MySQL database using sql count statement with JAVA?
tq
Asked
Active
Viewed 415 times
0
Community
- 1
- 1
user692495
- 69
- 2
- 6
- 13
-
1The question is not very clear - can you expand a bit? – martin clayton Mar 29 '11 at 06:43
-
@user661820: Have you try google the answer? Here's one of the first result: http://www.devdaily.com/java/edu/pj/jdbc/jdbc0003 – Hoàng Long Mar 29 '11 at 06:43
-
you mean, "How to execute SQL count query from Java?" – Nishant Mar 29 '11 at 06:44
2 Answers
1
How about
select count(*) fromtable_name
Usage would be something like:
int count;
String table = ...
Statement st = ...
ResultSet rs = st.executeQuery("select count(*) from " + table);
while (rs.next()){
count = rs.getInt(1);
}
Johan Sjöberg
- 47,929
- 21
- 130
- 148
0
If you are looking for a query to get the count :
SELECT COUNT(*) FROM MyTable
GuruKulki
- 25,776
- 50
- 140
- 201