Deitel & Associates, Inc. Logo

Back to www.deitel.com
digg.png delicious.png blinkit.png furl.png
Java How to Program, 6/e

ISBN:
0-13-148398-6
© 2005
pages: 1576
Buy the Book!
Amazon logo
InformIT logo

To execute the example in our RowSets tutorial, you must install MySQL and the MySQL Connector/J, then create our books database. A script to help create the database is located in the example download for this article.

[Notes: This is an excerpt (Section 25.5) of Chapter 25, Accessing Databases with JDBC, from our best-selling textbook Java How to Program, 6/e. This tutorial may refer to other chapters or sections of the book that are not included here. When you purchase this book you also get free access to the Web-based Java Multimedia Cyber Classroom, 6/e, for six months. The Cyber Classroom includes audio descriptions of the examples in Chapters 1-14, solutions to approximately one-half of the end-of-chapter exercises, interactive true/false self-assessment questions and a searchable Web-based e-book. Permission Information: Deitel, Harvey M. and Paul J., JAVA HOW TO PROGRAM, ©2005, p. 1206. Electronically reproduced by permission of Pearson Education, Inc., Upper Saddle River, New Jersey.]

Java RowSet Tutorial, Setup Part 1: Instructions to install MySQL and MySQL Connector/J

The CD that accompanies Java How to Program, 6/e includes MySQL 4.0.20—an open-source database management system. MySQL executes on many platforms, including Windows, Solaris, Linux, and Macintosh. Complete information about MySQL is available from

To install MySQL:

1. Download MySQL from www.mysql.com. We used the 4.0. The most recent build of 4.0 that is available can be found at: http://dev.mysql.com/downloads/mysql/4.0.html.

2. After downloading the installer, execute it and follow the instructions to install MySQL in the C:\mysql directory, which is the default directory.

Instructions for installing MySQL can also be found in Chapter 2 of the MySQL Manual at dev.mysql.com/doc/mysql/en/index.html.

To use MySQL with JDBC, you also need to install MySQL Connector/J—a JDBC driver that allows programs to access MySQL databases via JDBC. MySQL Connector/J is on the CD that accompanies this book and can also be downloaded from

At the time of this writing, the current stable release of MySQL Connector/J was 3.0.14. To install MySQL Connector/J:

1. Copy mysql-connector-java-3.0.14-production.zip to your hard disk.

2. Open mysql-connector-java-3.0.14-production.zip with a file extractor, such as WinZip, which can be downloaded from www.winzip.com. Extract its content to the C:\ drive to create a directory named mysql-connector-java-3.0.14-production. The documentation for MySQL Connector/J is in connector-j-en.pdf in the docs subdirectory of mysql-connector-java-3.0.14-production, or you can view it online at dev.mysql.com/doc/connector/j/en/index.html.

Setup for RowSets Example:
Java RowSet Tutorial, Setup Part 1: Instructions to install MySQL and MySQL Connector/J (You are here)
Java RowSet Tutorial, Setup Part 2: Instructions on Setting MySQL User Account
Java RowSet Tutorial, Setup Part 3: Creating Database books in MySQL

Java RowSet Tutorial: RowSet Interface

Tutorial Index