I have 2 problems I need your help please:
1- How can I map the result of a select query? let's say that I have a table named "Item" and I need to delete a specific item record from this table. So the user first needs to see the information related to this item. That means that I need a "Select Query" that will retrieve the information for this this item. That means after the user enters the item id (assuming that each item has a unique id) thae query will take that item id andretrieve the information of that item. But the problem that I am facing is:
- How to use the item id as a parameter to the query?
- How to use the query result (answer of the query) so that i map each field to its corresponding control (text box and combo box...etc?
2- Does any one has an idea of how to check that an item idn exist or not? I know that i need a query to select that item id and if the return value of the query is null then this item id does not exist. So again the same problem how to check the result value of a select query. As I know that the result of a select query should be stored in a ResultSet object but how to manipulate this object where to put the code?