File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes select statement for three column Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "select statement for three column" Watch "select statement for three column" New topic

select statement for three column

sam liya
Ranch Hand

Joined: Nov 25, 2008
Posts: 1240
there are three colums in my database table.i need to write a select statement for related to all three columns.

boolean isPresent=statement.execute("SELECT PERSON FROM ID WHERE "
+ "ID=1"
+ "AND (Address=\'abc\'AND lastName=\'xxxx\')");

is this correct?
Campbell Ritchie

Joined: Oct 13, 2005
Posts: 45307
Difficult to tell, because I don't know what your columns are. The SQL string looks like well-formed SQL, so you will have to try and see what happens when you execute that query at the command line? Have you read the API for java.sql.Statement#execute()?

Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32818

aruna sameera wrote:is this correct?

It's really close. If you look at the statement as one string you have:

Note the missing space before "and". This means your database can't parse the query.
It is sorta covered in the JavaRanch Style Guide.
subject: select statement for three column
It's not a secret anymore!