How to connect to a Derby database with Eclipse

Unzip and copy to the eclipse directory. Restart the eclipse directory. Select the project with the mouse, then right-click and select properties to indicate that the installation is successful.

Added derby plugin support for projects. Select Add Apache Derby Nature.

Then start the derby database server. Start the derby database client ij. Create via IJ and connect to server-side:

connect 'jdbc:derby://localhost:1527/helloworld;create=true;username=test;password=test';

Connect to a database called helloworld.

create=true, if the database does not exist, it will be created on the server side.

username=test;password=test, username and password is test, if the database is created, the user and password will be created.

derbysql script:,content:

create table books(

id int generated always as identity,name varchar(32) not null,price decimal(6,2),constraint p_key_1 primary key (id)

Command to execute the script:

run '';

The installation of the Derby plug-in is similar to that of other Eclipse plug-ins, you only need to extract the two plug-ins from the previous ** to the Eclipse plugins directory, and then restart Eclipse. You can do this through the plugin details

window to see if the plug-in is installed: select the menu [help]->about Eclipse SDK] and click on it.

1.When creating a database in the program, if no directory is specified, a directory with the derby database name will be generated in the root directory of the project by default, such as:

).newinstance();

load the embedded driver");

connection conn = null;

properties props = new properties();

user", test");

password", test");

create and connect the database named hellodb

conn =

jdbc:derby:testdb;create=true", props);

create and connect to testdb");

Where: "jdbc:derby:testdb; create=true", a testdb directory is generated in the root directory of the He Zihu project.

1> Create a new bookmark and select the driver.

find or other versions of the jar), select below: .

2> Next, enter the user name and password, and fill in the values assigned in the program book: test, test; When filling in the following database name, it should be noted that the absolute path of the writing system, such as e:

for the root of the project), the following url: jdbc:derby:

e: Auto-Fill).

3> Just keep connected.

1.Right-click the new floder in the new project

2.Create a package named lib.

3.The project directory after it has been created.

5.In the project lib package, select paste to paste and copy the mysql jar package.

7.Right-click the MySQL JAR package and select Build Path - Add to Build Path

8.After the addition is completed, the project is associated with the MySQL JAR package, and the relevant classes and methods can now be used.

9.Create a new class in your project.

10.Enter the following**:

11.**Explanation:

driver is an implementation class that is implemented by a specific database vendor.

Its connect method can get a database connection. The parameters are as shown in the figure above.

After running, the output is as follows, which proves that the database connection is successful!

12.Note: This is to use the driver to connect to the database, while the drivermanager or database connection pool is usually used in development, and this is only used to understand the database connection case.

Tool: Eclipse

Step 1: Configure Eclipse.

1.Right-click on the project and select new--folder2Enter 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.

This should be implemented with **, which can be achieved with the help of JDBC.

1. Right-click New Floder 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 MySQL JAR package.

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

7. After the addition is complete, the project is associated with the MySQL JAR 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.

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.

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.

The steps are as follows:

1. Open Eclipse.

2. Click "window->show view->data source explorer" in the menu bar.

3. Right-click "Database Connections" in "Data Source Explorer" and select "New".

4. Select the database type on the pop-up window, and then click "Next".

5. Add the driver and fill in the configurations.

6. After completion, click "Test Connection", and click "Finish" to complete the configuration.