We will interact with relational databases using JDBC and the Structured Query Language (SQL). SQL is a domain specific language designed for updating and retrieving data in table-based databases. We will not cover it in class but you will likely need to use it. SQL is very easy and descriptive. In most cases, a simple Google search will be sufficient to find "how to" do something with SQL. My go-to place to lookup SQL syntax is https://www.w3schools.com/sql/.
Recall, from previous section, that we have created a connection to our SQLite database through JDBC:
Create a table
To create a table, we can execute the following SQL statement:
Notice SQL reads like English! There is really no need to explain it; is there?!
We can execute a SQL statement by (1) creating a
Statement object and (2) invoking its
execute method, passing the SQL statement as an argument to it.