Home >Database >Mysql Tutorial >Detailed steps for myeclipse to connect to MySQL database

Detailed steps for myeclipse to connect to MySQL database

黄舟
黄舟Original
2017-08-04 13:36:102816browse

‍‍For students who have just used myeclipse for Java development, the database connection is very important. In class, the teacher will also finish speaking very quickly. Before he recovers, the class is over. I have a deep understanding of that feeling, especially the English version. I wanted to ask but didn't dare. Because I have experienced it myself, I will share here the detailed steps of connecting myeclipse to mysql database.

The first step is to open Database

Detailed steps for myeclipse to connect to MySQL database

##Open myeclipse and click on the window. Click MyEclipse Database Explorer in the Open Perspective menu to enter the picture below

The second step is to create a connection

Detailed steps for myeclipse to connect to MySQL database

Right-click the mouse in the blank space to create a new one (i.e. new) or click the shortcut key in the menu bar (the downward triangle symbol in Figure 2) to create a new one . The Database Driver menu pops up, as shown in the figure below

The third step is to select the connection method

Detailed steps for myeclipse to connect to MySQL database

Select MySql Connector/j in the Driver template option box, as shown in the figure below

The fourth step is to fill in the configuration information

Detailed steps for myeclipse to connect to MySQL database

Fill in the name of the linked database in

Driver name (this can be filled in according to your own preferences, the best recommendation is It is related to the name of the project and is easy to find during use)

Connection URL is used to fill in the address of the mysql database to be connected (jdbc:mysql://[<:3306>]/) can be changed to (jdbc:mysql://localhost:3306/test), where localhost means connecting to the local database, and 3306 means the port number for connecting to the mysql database (different database port numbers are different) ,

User name fill in the database user name mysql, the default is root

Password fill in the access password you set when accessing the mysql database. For example, as shown below

Detailed steps for myeclipse to connect to MySQL database

The fifth step is to add the driver

Detailed steps for myeclipse to connect to MySQL database

Click Add JARs to add the driver file for myeclipse to connect to the mysql database (It is best to store the driver files in an English directory. Make sure the mysql database is open during the test, otherwise the test will not succeed). What is added here is the mysql-connector-java-5.1.7-bin version (you can search and download it online ,) For example, in the figure below

The sixth step is to test whether the data configuration is correct

Detailed steps for myeclipse to connect to MySQL database

Click Test Driver to test whether the configuration is successful and enter the password to access the database. As shown below

Detailed steps for myeclipse to connect to MySQL database

Step 7 Test successful

Detailed steps for myeclipse to connect to MySQL database

The test connection to the mysql database is successful, click Finish to complete the connection creation.

Step 8 Connect to the database

Detailed steps for myeclipse to connect to MySQL database

Right-click the connection you created and click Open another connection Enter the mysql database password to see the created database table. As shown below

1Detailed steps for myeclipse to connect to MySQL database

1Detailed steps for myeclipse to connect to MySQL database

The above is the detailed content of Detailed steps for myeclipse to connect to MySQL database. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn