JDBC and MySQL

[mhburney]

Hi,

I cant figure out a way to search through a table for a specific value using JDBC and mysql..

any helps!

cheers!

 

[Diancecht]

select * from your table where yourfield=yourvalue?

Cheers,

Dian

 

[mhburney]

Okat this is what iam trying but how am i suppose to check the value or the result of this query

s.executeQuery ("Select name from device where name='xyz'");

 

[Diancecht]

I don't think I understand the question. The query returns a ResultSet, then you can iterate through it ang get the data you need.

Cheers,

Dian

 

[mhburney]

you mean just use resultset.next until it == somestring.

 

[Diancecht]

For example:

http://www.fluffycat.com/java/JavaNotes-ResultSet.html

Cheers,
Dian