In the previous recipes, we've seen how to connect to a variety of both open source and commercial relational databases. Connecting to a database is all well and good (after all, it's what we do in our applications), but we need to be able to easily create tables and views, and easily run SQL queries against our databases to see what data we have in them.
In this recipe, we'll see how we can perform these types of actions.
We'll be managing a Java DB instance in this recipe as Java DB is one of the easiest databases to configure and connect to from within NetBeans.
If you've not got a Java DB connected and configured within NetBeans, then please refer to the earlier recipe, Connecting to Java DB, to see how to connect. When creating a new Java DB database, name it cookbook
and specify the username to connect to the database as APP
.