JBuilder2005 connection MySQL driver configuration

1, MySQL 4.0.12, download URL:

Http://dev.mysql.com/get/Downloads/MySQL-4.1/mysql-4.1.12a-win32.zip/from/pick

2.MySQL jdbc driver 3.0.9, download URL:

Http://www.mysql.com/downloads/api-jdbc-stable.html

This article on the installation of JBuilder and MySQL is not in this complaint, focusing on the MySQL driver from the JDBC.

First of all, to unlock the MySQL JDBC driver compression package, in fact, in this package is really useful is mysql-connector-java-3.0.9-stable-bin.jar, so I put it directly to C: SYSTEMMYSQL-JDBC (this directory can be defined by itself)

In JBuilder, do the following:

First, select tool-> Configure libraries, select New in the Configure libraries window under the left list box, pop the new Library Wizard window, and enter MySQL in name (you can define it yourself). Location Select User Home, click Add, choose the path of MySQL jdbc: c:systemmysql-jdbc mysql-connector-java-3.0.9-stable-bin.jar, click OK (two times);

Second, select Project-> project Properties-> Paths-> Required Libraries-> Click Add, select the user home under the first step of MySQL, click OK (two times) ；

Third, select tool-> Enterprise Setup-> Database Drivers-> Click Add, select just add user home under MySQL, click OK, In the list box appears mysql.config, click OK;

Four, prompts the restart JBuilder, the setting can take effect, after confirming, restarts the JBuilder;

V. Select tool-> Database Pilot, select View-> options-> Drivers-> Click Add in the Database Pilot window

Driver class Input: Com.mysql.jdbc.Driver

Sample URL Input: mysql://localhost:3306/databasename click OK;

In the Database Pilot window, select File-> New, in the new URL window,

Driver: Select the Com.mysql.jdbc.Driver from the list of steps established by step five

URL: Change the databasename to the existing database, in this case the URL is as follows: Jdbc:mysql://localhost:3306/test, click OK;

Seven, in the Database Pilot window in the list of database URLs, double-click the URL you just established, enter the user name and password to connect to the database and connect successfully.