Have you ever been assigned a project and realized that you had no idea how you were going to accomplish it? Many developers have experienced this feeling when asked to interface their code with a database.
With a few exceptions, most developers were busy learning Lisp, linked lists, and big-O notation during their formal education instead of learning the fundamentals of relationship database management systems. When the time comes to interface their code with a database, they turn to a book like the one you are holding.
Your challenge might be to write a Web-based system using servlets and Enterprise JavaBeans (EJBs) to transfer shipping records from the home office in Bend, Oregon, to a satellite shipper in New Jersey. Or perhaps your father just opened his new medical office and you volunteered to create a scheduling system over the weekend.
Whatever the situation, interfacing an application to a database is one of the most fundamental tasks a developer is required to perform. This book is designed for developers who either have a pressing task ahead of them or who are curious about how to read database information into their application. By combining MySQL, the number-one open source database available, with Java, the most portable language ever developed, you can create an undisputable champion. So, sit back in your desk chair with a hot chocolate and get ready to supercharge your coding.
- An Overview of MySQL
- JDBC and Connector/J
- Working with MySQL SQL
- Installing MySQL, Java, and Connector/J
- Using JDBC with Java Applications and Applets
- Achieving Advanced Connector/J Functionality with Servlets
- MySQL Type Mapping
- Transactions and Table Locking with Connector/J
- Using Metadata
- Connection Pooling with Connector/J
- EJBs with MySQL
- Building a General Interface for MySQL
- Database Administration
- Performance and Tuning