MySQL™ and JSP™ Web Applications: Data-Driven Programming Using Tomcat and MySQL

Building a Database Schema

Now that you're ready to build your schema and populate it with data, it's worth talking about how to manage your database.

In the BFG example, MySQL is the database that was chosen. Accordingly, a database instance, called BFG, was created to use with it. Although you can do schema and database maintenance on the fly during development, it's important to capture all that information into scripts that can be run repeatedly, each time re-creating a perfect beginning state for your database.

WHY USE MYSQL? When choosing a database for a JSP project, a number of considerations come into play. MySQL certainly has one overwhelming characteristic that places it at the head of the class: It's free. If price were the only ...