With more than three million users, MySQL is the most popular open source database server in the world. It is the most popular database server for Linux and also runs on Windows, Macintosh, FreeBSD, and many flavors of UNIX. Most developers have built MySQL applications using programming languages like C, PHP, and Perl, but three years ago the author of this book, Mark Matthews, created MM.MySQL, the Java driver for MySQL. Since then, MySQL AB has shown their support for Java developers by hiring Mark, adopting his driver, and re–releasing it as Connector/J. Now, Mark Matthews and team explain everything you need to build database applications with MySQL and Java.
This book is a complete and authoritative tutorial and reference on MySQL for Java and takes a hands–on, code–intensive approach so you can learn how to build sophisticated Web database applications. Matthews begins by reviewing the fundamentals of MySQL 3.x and 4.x, followed by:
- Details of how to use JDBC with MySQL for Java application, servlet, JSP, and EJB development
- Several sample database applications, including an Address and Fingerprint Management system that uses servlets, and an Advanced Account Management system that uses EJBs
- MySQL and JDBC tuning techniques
- MySQL administration advice
- JDBC API reference specific to MySQL and Connector/J
About the Authors.
Chapter 1: An Overview of MySQL.
Chapter 2: JDBC and Connector/J.
Chapter 3: Working with MySQL SQL.
Chapter 4: Installing MySQL, Java, and Connector/J.
Chapter 5: Using JDBC with Java Applications and Applets.
Chapter 6: Achieving Advanced Connector/J Functionality with Servlets.
Chapter 7: MySQL Type Mapping.
Chapter 8: Transactions and Table Locking with Connector/J.
Chapter 9: Using Metadata.
Chpater 10: Connection Pooling with Connector/J.
Chapter 11: EJBs with MySQL.
Chapter 12: Building a General Interface for MySQL.
Chapter 13: Database Administration.
Chapter 14: Performance and Tuning.
Appendix A: MySQL Development and Test Environments.
Appendix B: Databases and Tables.
Appendix C: The JDBC API and Connector/J.
Appendix D: MySQL Functions and Operators.
Appendix E: Connector/J Late–Breaking Additions.
JIM COLE is a senior software engineer specializing in Internet and knowledge management systems. He is an active developer, working in Java, C++, and MySQL.
JOSEPH D. GRADECKI is a senior software engineer working on enterprise–level securities processing systems. He has built numerous dynamic, enterprise applications using Java, MySQL, servlets, JSPs, Resin, XML, and more.