File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes To Get the Number of Matches Found in the Database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "To Get the Number of Matches Found in the Database" Watch "To Get the Number of Matches Found in the Database" New topic
Author

To Get the Number of Matches Found in the Database

JiaPei Jen
Ranch Hand

Joined: Nov 19, 2000
Posts: 1309
I am working a database search by supplying a 'memberName'. There is a field in the data table called 'message_receiver'. I want to count the number if the 'memberName' and the 'messag_receiver' is a match and return the number. How do I do it?
Mukesh Netedge
Greenhorn

Joined: Apr 17, 2004
Posts: 10
Hi JiaPei Jen ,
It seems you need count of the result set returns from the query according to the parameter passed.
Try the following query:
String query = "SELECT count(*****) as countNo FROM message_thread WHERE message_receiver = '" + memberName + "'";
or
String query = "SELECT count(*****) as countNo FROM message_thread WHERE message_receiver like '%" + memberName + "%'";
Then usinf your resultset retrieve the first element as
String noOfMembers=rs.getString("countNo")
Hope it will hepl you.
Mukesh
 
Consider Paul's rocket mass heater.
 
subject: To Get the Number of Matches Found in the Database
 
Similar Threads
Database Connection
Please Point Out My Mistakes
JDBC Exception Handling
NullPointerException At Statement stmt = conn.createStatement();
Array Index Out Of Bounds Exception: 0 ( Mistake with My MySQL "count"?)