wood burning stoves 2.0*
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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: 1072
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: 38036
    
  22
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: 30130
    
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
 
Similar Threads
Max length of select statement
Batching Select Statements in JDBC
JDBC and Stored Procedure
defference jdbcTemplate.queryForInt() and others
iBatis and Parameter Map