MySQL and Java developer's guide : Java open source library

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.

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

Hier erfahren Java Entwickler alles, was sie wissen mssen, um Java Datenbankanwendungen mit MySQL zu entwickeln. "MySQL and Java Developer's Guide" ist der erste umfassende Leitfaden zu MySQL fr Java-Entwickler. Er basiert auf einem praxisorientierten und codeintensiven Ansatz. Hier lernen Java Entwickler, wie sie eine komplexe Managementanwendung fr Webdatenbanken entwickeln. Zunchst gibt der Autor einen berblick ber die Grundlagen von MySQL. Dann erklrt er, wie man JDBC mit MySQL verwendet und wie man Servlets und JSP mit MySQL entwickelt. Mit einem codeintensiven Tutorial. Es demonstriert, wie man die Muster-Datenbankanwendung mit Hilfe von EJB entwickelt. Mit begleitender Website. Sie enthlt die kompletten Quellcodebeispiele aus dem Buch sowie Links zu anderen ntzlichen Seiten. Geschrieben von Mark Matthews, dem Erfinder des JDBC-Treibers fr MySQL und unbestrittene Autoritt auf dem Gebiet der Java Programmierung mit MySQL. Content: 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. Aimed at Java developers, explains how to build Web database applications with MySQL, covering topics such as administration advice, tuning techniques, and EJB development. In this chapter, we explain why you might choose to use a database system with your software.