Wiley Publishing - MySQL and Java Developer’s Guide.pdf

(3423 KB) Pobierz
MySQL and Java
Developer’s Guide
Mark Matthews
Jim Cole
Joseph D. Gradecki
Publisher: Robert Ipsen
Editor: Robert M. Elliott
Managing Editor: Vincent Kunkemueller
Book Producer: Ryan Publishing Group, Inc.
Copyeditor: Elizabeth Welch
Proofreader: Nancy Sixsmith
Compositor: Gina Rexrode
Designations used by companies to distinguish their products are often claimed as trademarks. In all instances
where Wiley Publishing, Inc., is aware of a claim, the product names appear in initial capital or
ALL CAPITAL
LETTERS
. Readers, however, should contact the appropriate companies for more complete information regarding
trademarks and registration.
This book is printed on acid-free paper.
∞
Copyright © 2003 by Wiley Publishing, Inc. All rights reserved.
Published by Wiley Publishing, Inc., Indianapolis, Indiana
Published simultaneously in Canada.
No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any
means, electronic, mechanical, photocopying, recording, scanning, or otherwise, except as permitted under
Section 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the
Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center,
Inc., 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 750-4470. Requests to the Publisher for
permission should be addressed to the Legal Department, Wiley Publishing, Inc., 10475 Crosspoint Blvd.,
Indianapolis, IN 46256, (317) 572-3447, fax (317) 572-4447, E-mail: permcoordinator@wiley.com.
Limit of Liability/Disclaimer of Warranty: While the publisher and author have used their best efforts in preparing
this book, they make no representations or warranties with respect to the accuracy or completeness of the
contents of this book and specifically disclaim any implied warranties of merchantability or fitness for a particu-
lar purpose. No warranty may be created or extended by sales representatives or written sales materials. The
advice and strategies contained herein may not be suitable for your situation. You should consult with a profes-
sional where appropriate. Neither the publisher nor author shall be liable for any loss of profit or any other
commercial damages, including but not limited to special, incidental, consequential, or other damages.
For general information on our other products and services please contact our Customer Care Department
within the United States at (800) 762-2974, outside the United States at (317) 572-3993 or fax (317) 572-4002.
Trademarks:
Wiley, the Wiley Publishing logo and related trade dress are trademarks or registered trademarks
of Wiley Publishing, Inc., in the United States and other countries, and may not be used without written permis-
sion. All other trademarks are the property of their respective owners. Wiley Publishing, Inc., is not associated
with any product or vendor mentioned in this book.
Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be
available in electronic books.
Library of Congress Cataloging-in-Publication Data:
Matthews, Mark.
MySQL and Java developer’s guide / Mark Matthews.
p. cm.
ISBN 0-471-26923-9 (PAPER/WEBSITE)
1. SQL (Computer program language) 2. Java (Computer program
language) I. Title.
A76.3.S67M38 2003
005.75’65—dc21
2002155887
Printed in the United States of America
10 9 8 7 6 5 4 3 2 1
C O N T E N TS
Acknowledgments
About the Authors
Introduction
Chapter 1
An Overview of MySQL
Why Use an RDBMS?
Multiuser Access
Storage Transparency
Transactions
Searching, Modifying, and Analyzing Data
Ad Hoc Queries
Why Choose MySQL?
MySQL and JDBC
What’s Next
xi
xiii
xv
1
2
2
2
3
4
5
5
7
8
Chapter 2
JDBC and Connector/J
What Is JDBC?
What about ODBC?
Modeling Database Applications with JDBC
JDBC Versions
JDBC Driver Types
SQL Standards
Examining the JDBC Interface
The java.sql Package
The javax.sql Package
Understanding Connector/J
JDBC Support within 3.0.1
Obtaining JDBC Drivers
What’s Next
9
9
10
11
13
13
14
15
15
18
21
22
24
24
Chapter 3
Working with MySQL SQL
What Is a Database?
Database Models
Data Types
Designing a Database
Introducing MySQL SQL
Overview of MySQL
Creating Databases
Creating Tables
Inserts
Selects
SELECT Statement Extensions
25
25
27
29
29
32
33
34
35
39
40
42
iii

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin