Shulou(Shulou.com)06/02 Report--

This article is about how to configure MyEclipse Database Explorer. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

A description of MyEclipse Database Explorer's capabilities can be found on the following page

Http://www.myeclipseide.com/ContentExpress-display-ceid-60.html

Manual configuration is required for Driver other than JDBC ODBC Bridge to take effect.

First get the jar of MySQL Connector / J:

Http://dev.mysql.com/downloads/connector/j/3.1.html

Copy the mysql-connector-java-3.1.12-bin.jar file to a specified location after decompression, for example:

C:\ MySQL-Connector E:\ Java\ Tomcat5.0\ common\ lib E:\ Java\ Tomcat5.0\ shared\ lib

Something like that.

Then select the MySQL Connector project in the Windows-> Preference screen of Eclipse, and click the Edit button to enter the editing screen.

Go to the Driver Libraries tab and click the New button. Select the location of the jar file.

After saving the settings, you can use MyEclipse Database Explorer to connect to the MySQL database.

Select window- > Open Perspective- > Other...

You can see that a menu called Select Perspective pops up and MyEclipse Databases Exporler is selected in it, and you can see that you are now on the following page.

MyEclipse Database creation diagram

Enter the relevant fields according to the above figure and click Finish to establish a database connection. Right-click on the newly emerging JDBC for Mysql and select Open connection. Click OK after confirming that the user name and password are correct. If all goes well, you will see the following screen:

MyEclipse Database establish connection diagram

Add database access function in MyEclipse (2)

(6) Click the "OK" button, and the added JAR file appears in the BookManager project list, as shown in the following figure.

Add jar file diagram of MyEclipse Database

(7) next, you need to establish a MySQL database connection in MyEclipse. Click the view switch button on the right side of the toolbar, as shown in the following illustration.

Switching views of MyEclipse Database

(8) Select MyEclipse Database Explorer from the drop-down menu to open the MyEclipse Database Explorer view. Right-click in the DB Browser on the left, as shown in the following figure.

Open the MyEclipse Database diagram

(9) Select the New menu command from the pop-up drop-down menu, and create a new MySQL database connection, as shown in the following figure.

DB Browser diagram (click for larger picture) New Database Connection Driver dialog box

The dialog box contains the following information settings:

Driver template: select the database driver template.

Driver Name: defines the database connection name.

Connection URL: defines the connection URL of the database.

User name: defines the user name that logs in to the database.

Password: enter the user password to log in.

Driver JARs: defines the JAR package used to connect to the database.

Driver classname: select the class name of the database connection driver.

Save password: choose whether to save the password of the logged-in user.

Thank you for reading! This is the end of the article on "how to configure MyEclipse Database Explorer". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.