Book Image

NetBeans IDE 8 Cookbook

By : David Salter, Rhawi Dantas
Book Image

NetBeans IDE 8 Cookbook

By: David Salter, Rhawi Dantas

Overview of this book

<p>From the start to the end of a Java project's lifecycle, this book will show you how to perform many key tasks with the NetBeans IDE, uncovering more about mobile, desktop, and enterprise Java along the way.</p> <p>You will start by creating Java projects and learning how to refactor and use NetBeans tools to increase developer efficiency. You will then get a walkthrough of how to create a desktop application before covering JavaFX and mobile applications and how to use external services within them. Having seen how to create many different types of applications, you will then be shown how to test and profile them before storing them in revision control systems such as Git or Subversion. Finally, you will learn how to extend NetBeans itself by adding new features to the IDE.</p>
Table of Contents (19 chapters)
NetBeans IDE 8 Cookbook
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

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 connect. When creating a new Java DB database, name it cookbook and specify the username to connect to the database as APP.

How to do it...

Navigate to the Databases node within the Services explorer and perform the following steps:

  1. Right-click on the...