Database access with zxJDBC
- Create a connection (object).
- Create a cursor (object).
- Execute a query.
- Retrieve the rowset.
- Get and display the descriptions of the columns.
- Iterate over and display the rows in the rowset.
- Add a row to the table. Before adding, check for the existence of
a row with the key to be added.
- Delete a row from a table. Before deleting, determine whether the
row exists, and display a message if it does not.
What you will learn:
- Some of the features of the Python DB API 2.0.
- How to use zxJDBC to perform a simple query and display the
results.
- How to use zxJDBC to retrieve and show the description of the
columns in a table.
- How to use zxJDBC to delete a row from a table.
- How to use zxJDBC to add a row to a table.
Additional information: