MySQL and Java Developer's Guide / Edition 1

MySQL and Java Developer's Guide / Edition 1

by Mark Matthews, Jim Cole, Joseph D. Gradecki
     
 

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,

See more details below

Overview

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

Read More

Product Details

ISBN-13:
9780471269236
Publisher:
Wiley
Publication date:
03/06/2003
Series:
Java Open Source Library
Edition description:
New Edition
Pages:
432
Product dimensions:
9.25(w) x 7.50(h) x 0.88(d)

Table of Contents

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.

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >