Find some item count in sql db ?

Question

0.00/5 (No votes)

See more:

Hi everybody, I try to find "john" in "name" column in database.But I did't somehow. Could you please help? Thanks..

Java

String st="SELECT name FROM mytable";
ResultSet rs = stmt.executeQuery(st);
int icount = 0 ;
if (rs.equals("john")) {
while (rs.next()) { 
icount++;
}
}
jtext1.setText(String.valueOf(icount));

Posted 3-Jan-16 0:07am

bugsoul

Updated 3-Jan-16 0:09am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Michael_Davies · Accepted Answer · 2016-01-03T00:18:00

Solution 1

Try:

C#

String st="SELECT name FROM mytable WHERE name LIKE '%john %'";

You can do it all in one:

C#

String st="SELECT COUNT(*) FROM mytable WHERE name LIKE '%john %'";

C#

String st="SELECT COUNT(*) FROM mytable WHERE name LIKE '%john %'"
ResultSet rs = stmt.executeQuery(st);
int icount = 0;
while (rs.next) {
icount = rs.getInt(1);
}
jtext1.setText(String.valueOf(icount));

There should only be 1 record with 1 field in the above which will be the count of records matching.

Put a space after john so as not to get names like johnathan etc. but you can play around.

Posted 3-Jan-16 0:18am

Michael_Davies

Updated 3-Jan-16 3:07am

v6

Comments

bugsoul 3-Jan-16 7:11am

Thanks Michael, but sorry I am a begginer;

well, how can I get that result. I mean how can I ".settext" to jtext1.

thanks again..

ridoy 3-Jan-16 8:05am

Don't get your point. do you try the query @Michael_Davies posted?

Michael_Davies 3-Jan-16 9:07am

Updated my answer.

ridoy 3-Jan-16 12:49pm

a 5 from me!

bugsoul 3-Jan-16 9:12am

Thank you so much...