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

The Address Book

You need to get a couple of pieces of infrastructure in place before moving on to order checkout. One major piece of dangling functionality involves the wallet and the address book.

The wallet (the list of credit cards) will need to use addresses. As you recall way back in the ERD design, you used the Address object as a property of the credit card rather than recording address information separately in the credit card itself. As a result, you should get addresses working first.

To begin, you need several new queries in your properties file. To remind you, the schema for ADDRESS in the database is as follows:

 create table ADDRESS ( ADDRESS_ID int not null auto_increment, FIRST_NAME char(30) not null, LAST_NAME char(40) not null, ...

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