MySQL and Java Developer's Guide

• Shows Java developers everything they need to know to build
  Java database applications with MySQL.

  • Takes a hands-on, code-intensive approach in which readers will
    learn how to build a sophisticated Web database management
    application.

  • Begins with a review of the fundamentals of MySQL.

  • Explains using Java's JDBC with MySQL, as well as servlet and
    JSP programming with MySQL.

  • Provides a code-rich tutorial on how to build the sample Java
    database application using EJBs.

  • The companion Web site provides the full code examples plus
    links to useful sites.

  Autorentext

MARK MATTHEWS is the creator of Connector/J and its predecessor MM.MySQL, the Java JDBC drivers for MySQL. He is the undisputed authority on developing Java database applications with MySQL.

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.

Klappentext
The first comprehensive guide to MySQL for Java developers 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

  Zusammenfassung

• Shows Java developers everything they need to know to build Java database applications with MySQL.
• Takes a hands-on, code-intensive approach in which readers will learn how to build a sophisticated Web database management application.
• Begins with a review of the fundamentals of MySQL.
• Explains using Java's JDBC with MySQL, as well as servlet and JSP programming with MySQL.
• Provides a code-rich tutorial on how to build the sample Java database application using EJBs.

• The companion Web site provides the full code examples plus links to useful sites.

  Inhalt
  Acknowledgments. About the Authors.

  Introduction.

  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.

  Index.