3    Database explorer module in Netbeans

3.1  Connecting to Databases

Once you have set up the connection to your database, you can perform the following simple operations that are related to JDBC-compliant databases:

·        Connect to a database

·        Create, browse and edit database structures

·        Write, edit and execute SQL commands on a connected database

·        Enter SQL queries and see the results immediately

·        Connect to multiple databases concurrently

·        Migrate table schemas across databases from different vendors

Connetting to database  MySql:

• Adding Database Drivers in Netbeans5.5

 In the  Runtime window to add a database driver, right-click the Drivers node and choose New Driver from the pop-up menu.

Click Add and browse to the location of your database driver and select the database driver's JAR or ZIP file. When you select the driver, the Driver Class and Name appear in the dialog box.

Connetting to database  Ms-Access not install a new driver but you must use JDBC-ODBC driver.

• Adding Database Drivers in Netbeans6.0

Well, in Netbeans6.0 the MySQL(Connector/J driver) is bundled with installation IDE. You NOT must install driver it is already at work!

• Establishing a Database Connection in Netbeans5.5 or Netbeans6.0  

In order to establish a connection to a database, first make sure your database server is up and running.

To create a database connection, right-click the driver node and choose Connect Using to open the New Database Connection dialog box:

Specify the Database URL and the username and password for your database server.

Connetting to database   Ms-Access :

myDBAccess  is a ODBC user data source .

Create from operating system WindowsXP: