select statement for three column

[sameera liyanage]

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]

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]

aruna sameera wrote:is this correct?

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

SELECT PERSON FROM ID WHERE ID=1AND (Address=\'abc\'AND lastName=\'xxxx\')

Note the missing space before "and". This means your database can't parse the query.