O'Reilly logo

NetBeans IDE 8 Cookbook by Rhawi Dantas, David Salter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Managing a SQL database

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.

Getting ready

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required