The first thing we need to do is to create the inventory database. To do that, we're going to create a connection to our database, and then execute an SQL statement to create the table.
Because we're going to be using the JDBC-ODBC bridge, we need to create an ODBC connection. To make things simple, it doesn't matter what database you use, as long as you can create an ODBC connection to it.
Setting up an ODBC connection on a Microsoft Windows system involves the following steps:
Create the database, if necessary. We can use a text database, so we can create it on the fly, so to speak. A Microsoft Access database can also be created this way, even if you don't have the actual software ...