MySQL与Java开发者指南：马克·马修斯、吉姆·科尔与约瑟夫·格雷迪奇合著

5星 · 超过95%的资源需积分: 9 171 浏览量更新于2024-07-26 收藏 3.34MB PDF 举报

《Wiley & Sons - MySQL and Java Developer's Guide》是由Mark Matthews、Jim Cole和Joseph D. Gradecki合著的一本专业书籍，该书专注于MySQL数据库与Java技术的结合应用。作为一本开发者指南，它旨在帮助读者深入了解如何在Java环境中有效地设计、开发和管理MySQL数据库系统。作者们充分利用他们的专业知识，为读者提供了全面的教程，涵盖了从基础概念到高级技术的各个方面。本书由Robert Ipsen担任出版商，Copyeditor Elizabeth Welch、Editor Robert M. Elliott、Proofreader Nancy Sixsmith以及Managing Editor Vincent Kunkemueller等多人参与了编辑和校对工作，确保了内容的专业性和准确性。此外，书中的设计和排版由Ryan Publishing Group, Inc.完成，采用环保的酸性免费纸张，体现了出版社对可持续性的重视。版权方面，本书受2003年Wiley Publishing, Inc.的版权保护，所有权利保留。它在美国印制，并同步发行至加拿大。在引用或复制本书内容时，必须遵循1976年美国版权法第107节或第108节的规定，确保遵守法律对于版权的合理使用条款。本书的主题涵盖了关键知识点，如Java与MySQL的集成，包括但不限于：如何通过Java API操作MySQL数据库，数据访问模式（JDBC、JPA等），事务管理，数据库设计最佳实践，安全性和性能优化，以及如何处理大规模数据处理和并发问题。此外，读者还能学习到如何编写高效、可维护的代码，以适应不断变化的业务需求和技术环境。对于那些希望在IT领域从事Java开发并与MySQL交互的开发人员而言，《MySQL and Java Developer's Guide》是一本不可或缺的参考工具，它不仅提供理论知识，还包含了大量的实战案例和示例，使学习者能够迅速上手并提升技能。

ave you ever been assigned a project and realized that you had no idea

how you were going to accomplish it? Many developers have experi-

enced 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 funda-

mentals 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 Enter-

prise 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 sys-

tem 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 undis-

putable champion. So, sit back in your desk chair with a hot chocolate and get

ready to supercharge your coding.

Introduction

What’s in This Book

The primary goal of MySQL and Java Developer’s Guide is to provide a com-

prehensive approach to writing code from a Java application to a MySQL data-

base using the industry standard: JDBC. As you will see later in this

Introduction, the chapter titles indicate what area of database connectivity and

manipulation they cover. The chapters are ordered to reflect the JDBC specifi-

cation, but we aren’t here to simply describe the specification.

We wrote all of the material in the book to highlight how MySQL’s Connector/J

JDBC driver achieves the interfacing of MySQL with Java while maintaining the

spirit of the specification. With this in mind, we provide example code using all

major forms of Java development, including

■■

Applications

■■

Applets

■■

Servlets

■■

JSPs

■■

EJBs

As you work in Java and JDBC, you will see the true power of the specification.

You can write database access code in a Java application and move the code to

a servlet with little if any changes. In the case of EJBs and container-managed

persistence, we devoted a full chapter to dealing with database access without

the cumbersome details of SQL.

We designed the layout of the book to move you through the entire process of

writing Java code needed to access a back-end database. Developing the data-

base is one of the first things that you must accomplish in this process. While

we don’t delve deeply into the theory of database development, you learn how

to create databases in MySQL, administer those databases, and handle such

details as granting access permissions. From there, we take you into an exami-

nation of the MySQL Connector/J driver and how it accomplishes its goal of

portable database access. The remainder of the book steps you through Java

code that highlights how to accomplish database tasks such as the following:

■■

Querying and updating

■■

Handling ResultSets

■■

Using transactions

■■

Handling typing issues between JDBC and MySQL

■■

Working with metadata

■■

Addressing efficiency issues

INTRODUCTION

xvi

Once you’re familiar with these concepts, we present a complete application

that pulls it all together. Our application illustrates how you can create to a sim-

ple authorization service. Using a combination of JSP, servlets, and EJBs, the

service allows new users to create accounts, recall the account, and verify a

username/password combination. The system is designed to be interactive

using JSP pages, which are handled on the server using servlets. The JSPs can

be bypassed using the servlets directly. All of the critical information is kept on

the database for persistence and management needs.

After reading this book, you should know how to interface Java to MySQL and

be able to use the many examples for reference.

NOTE

All the code and examples in this book can be found on the the support Web site at

www.wiley.com/compbooks/matthews.

Who Should Read This Book

This book is written for Java developers who need to interface their code to a

back-end database. The book’s specifics deal with MySQL and Connector/J, but

this doesn’t limit the information because JDBC is designed to be portable

against many databases. If you aren’t using MySQL, you still find valuable infor-

mation.

You don’t need to know much about databases—we have included several

chapters that provide all of the basics necessary to create databases and make

sure they are operational. Keep in mind that we didn’t intend these chapters to

replace a good reference on MySQL, though.

We do expect that you are an experienced Java developer who is comfortable

with the language. This book explains a combination of Java delivery methods,

including applications, applets, beans, and EJBs; you may want to begin with

what you know best and expand from there.

The Technology Used

In this book, we use the latest Java Developments Kits (JDK) available from

Sun at the time of writing. The JDKs we used include J2SE 1.4.0 and J2EE 1.3.1.

The Java examples are used in a mixed environment, including Windows

2000/XP, Linux Mandrake, and Linux Slackware. For the most part, we devel-

oped the examples using simple text editors and compiled them using the Java

command-line compiler. However, all the examples should work just fine in an

IDE such as JBuilder.

MySQL and Java Developer’s Guide

xvii

All of the coding examples in this book are built using MySQL as the primary

database, Java as our coding language, and Connector/J, MySQL’s JDBC dri-

ver. Although the installation of these components isn’t overly difficult, this

chapter provides comprehensive instructions for obtaining all of the neces-

sary components and performing a step-by-step installation. We also provide

simple examples for testing the installation.

Chapter 5: Using JDBC with Java Applications and

Applets

This chapter is the first in a series on the use of Java to access a MySQL data-

base using JDBC. Some of the basic functionality discussed includes loading

the JDBC driver, connecting to a local or remote database, building JDBC

statements in preparation for queries, executing queries against the MySQL

database, working with ResultSets, and accessing MySQL-specific functional-

ity through JDBC.

Chapter 6: Achieving Advanced Connector/J Functionality

with Servlets

At this point, you’ve learned the basics, and it’s time to expand into the more

advanced topics. This chapter is designed to expand your understanding of

SQL, MySQL, and JDBC. The topics include updatable ResultSets, Prepared-

Statements, date/time types, BLOBs and CLOBs, and joins.

Chapter 7: MySQL Type Mapping

One of the fundamental issues associated with databases and programming

language is determining the correct mapping from one to the other. While

programming languages have a large variety of types, including simple ones

like integer, they also allow more complex ones, like classes. Databases, on

the other hand, are limited in their choices for the types of data that can be

stored. In the middle of this situation is the JDBC driver. This chapter dis-

cusses the types available on the MySQL database, how JDBC interprets

those types, and the resulting Java type produced by the mapping.

Chapter 8: Transactions and Table Locking with Connector/J

In a simple world, information is stored in a single table of a database. When

you have to update information or insert a new row, you can use a single

query. However, most modern databases store information across several dif-

ferent tables to increase the normalization of the tables. In this situation,

when you have to update information or insert new rows, you must write two

MySQL and Java Developer’s Guide

xix

剩余432页未读，继续阅读

tzeseng

粉丝: 0
资源: 6

MySQL与Java开发者指南：马克·马修斯、吉姆·科尔与约瑟夫·格雷迪奇合著

John Wiley & Sons - Practical Project Management - Tips, Tactics And Tools

John Wiley & Sons - Large-Scale Software Architecture A Practical Guide using UML

John Wiley & Sons - Mastering EJB_3rd Edition_2005

多元回归模型的参考文献

软件测试英文参考文献

关于直线倒立摆的参考文献有哪些

量子力学概论_《量子力学新讲》参考文献

天线发展史 标明参考文献

ssm框架相关外文文献和翻译

链表的研究意义和发展，并引用参考文献

最新资源

天线发展史标明参考文献