Charging the Credit Card
Until now, you've done everything you need to do for the site except actually let a customer pay for a purchase. Some might consider this to be a minor oversight, but it's funny how the folks in accounting get a bit upset if they don't see revenue flowing in. So, to keep them happy, you should probably implement credit card authorization.
As has already happened several times, reconsidering the original design in light of what has been learned during development leads to some redesign. For one thing, the original schema for the table to record orders is needlessly redundant with tables that you already have in the database, and it can be simplified a great deal. You can do this by storing the credit card number, credit ...
Get MySQL™ and JSP™ Web Applications: Data-Driven Programming Using Tomcat and MySQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
