Meaningless Drivel is fun!*
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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
 
Don't get me started about those stupid light bulbs.
 
subject: To Get the Number of Matches Found in the Database
 
Similar Threads
NullPointerException At Statement stmt = conn.createStatement();
Array Index Out Of Bounds Exception: 0 ( Mistake with My MySQL "count"?)
Please Point Out My Mistakes
Database Connection
JDBC Exception Handling