O'Reilly logo

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

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

Summary

The SQL schema is the persistent embodiment of your Java classes. Although there might not be a one-to-one relationship between Java classes and SQL tables, any data that you want to have persist between sessions must live in a SQL database.

MySQL is a good database for small to moderately sized applications, with a reasonable feature set and zero cost. However, if you will deal with large amounts of data, you might want to consider a commercial database such as Oracle.

Because MySQL doesn't use sequences, you need to use the capability of MySQL to read back the value of the last inserted autoincrement column.

Now that you have all the scutwork out of the way and you have some data to play with, you're ready to start developing your application. ...

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