GeeCON Prague 2014*
The moose likes JDBC and the fly likes how to select from a row from a database using an id Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to select from a row from a database using an id" Watch "how to select from a row from a database using an id" New topic
Author

how to select from a row from a database using an id

Igbe Jr. Chukwudi
Greenhorn

Joined: Nov 29, 2010
Posts: 12
Gud day,thanks for your support before now.Am trying to retrieve a particular customer information from the database,but am confused on how to construct the method for this in my DATA ACCESS OBJECT CLASS
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30586
    
154

The SQL is easy: select * from table where id = ?. Or similar depending on how many fields your key has.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
GeeCON Prague 2014
 
subject: how to select from a row from a database using an id