jQuery in Action, 2nd edition*
The moose likes JDBC 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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "select statement for three column" Watch "select statement for three column" New topic
Author

select statement for three column

sam liyanage
Ranch Hand

Joined: Nov 25, 2008
Posts: 1087
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
Sheriff

Joined: Oct 13, 2005
Posts: 38481
    
  23
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30369
    
150

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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: select statement for three column