This week's book giveaway is in the Big Data forum.
We're giving away four copies of Elasticsearch in Action and have Radu Gheorghe & Matthew Lee Hinman on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Retriving data from table Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Retriving data from table" Watch "Retriving data from table" New topic

Retriving data from table

Ian Cockcroft

Joined: Feb 17, 2002
Posts: 29
Hi all, the following code gets data from an ACCESS database.
I need to put the data in textFields and a checkBox, why is so difficult?
OrderDate is a DATE field.
OrderFilled is a Yes/No filled.
How should I be doing it?

I get the following error aswell, when i comment out the setText() code:
Connection error : java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid cursor state
this really is confusing, i have no idea,
any can help?
mustang india
Ranch Hand

Joined: Feb 05, 2002
Posts: 60
u have to place the cursor at the begining of the result set. All u have to do is put ur data retrivel code inside
//supposing that there is only one row fetched.
if( {
} puts the cursor pointing to the first row fetched by the resultset, if it has fetched something. If there are no rows selected, it returns false.
rocket mass heater kickstarter
subject: Retriving data from table