How does Eclipse connect to a MySQL database?

If there is no framework for database connection, use JDBC directly

If you can use these frameworks such as mybatis+spring, you can directly configure the data source, there are many on the Internet, you can search for it.

See if you're using mybatis or hibernate to go to the next dependency package and go to the web to find its configuration steps.

1. Find the configuration file, path: project root config.

2. Open the database configuration file and modify the three important configurations.

3. In the controller file, import the db class.

4. Use the static method query of db class to query a piece of content from the database and save the query result.

5. Print the saved result. You can connect to the database.

Tool: Eclipse

Here's how:1Right-click a new file in the project and name it <>

3.Enter the following information in the file, which are the driver, connection, username and password of the database.

4. Create a new class. 5.Enter the following ** to test the connection to pass the test.

Tool: Eclipse

Steps. 1. Eclipse configuration.

1.Right-click on the project and select new--folder<>

2.Enter a directory name.

3.This is shown in the figure below.

4.Copied jar package.

5.Paste under Project.

6.On the project, select Build Path - Add to Build Path

7.Create a connection class.

2. Enter the connection connection.

1.Test**:

3. Test whether the connection is successful.

1.If you see the following figure in the console, the connection is successful.

1. Right-click Newfloder in the newly created project.

2. We select the mouse click to create a package called lib.

3. After that, the page of the created project directory will be displayed.

5. Select Paste and paste in the project lib package email to copy the mysqljar package.

6. Right-click on the mysqljar package to select Build Path - Add to Build Path.

7. After the addition is complete, the project is associated with the Mysqljar package. Now you can use the relevant classes and methods.

8. Create a new class in your project.

9. After that, select the keyboard and tap to enter the following**, as shown in the figure below.

10. **Note: Driver is an implementation class implemented by a specific database provider. Its connect method can get a database connection. The parameters are as shown above. After the operation is run, the output is as follows, which proves that the database connection is successful.

Environment: mysql:

Installed, friends who won't see the connection.

Tool: Eclipse

3.Enter the following information in the file, which are the driver, connection, username and password of the database.

5.Enter the following ** to test the connection to pass the test.

1. Open Eclipse and find "window"--show view"--other....

2In the pop-up window, open the folder "Data Management", find "Data Source Explorer", and click "OK".

3At this time, there will be an additional "Data Source Explorer" tab bar at the bottom of the Eclipse main interface, right-click on the "Database Connections" folder icon and select "New.".

4A new window will appear, find the database you are using"oracle", come up with your own name, and come up here"cityinfo"The name. Then click "Next>".

5When the window below appears, please click the symbol (position) shown in the upper right figure and pay attention to this step.

In the previous step, in the new dialog box, find the Oracle version you are using, it is recommended to choose Oracle Thin Driver, which is flexible and convenient.

6. Find the jar list, if you are using oracle11, please remove the ojdbc14 in it, otherwise, eclipse will keep prompting errors.

Eclipse cannot connect to the MySQL database, which may be caused by various reasons such as the JAR package not being imported, the database error, etc.

Tool: Eclipse

Method: 1. Create a data:

mysql>create database test;Create a database.

mysql>use test;Specify test as the database to be operated on.

mysql>create table user (name varchar(20),password varchar(20));Create a user table and set two fields.

mysql>insert into user values('huzhiheng','123456');Insert a piece of data into the table.

2. Open Eclipse, right-click on my---build path---add external archiver....Select the JDBC driver and click OK.

3. The driver has been imported, and the write connection to the database**.

4. Click to run the program, if the content to be displayed in ** appears, it means that it is connected.

Your configuration file is incorrect, so check that your configuration file or the string that logs into the database is correct.