>데이터 베이스 >MySQL 튜토리얼 >Eclipse Tips : How To Configure MySql In Eclipse_MySQL

Eclipse Tips : How To Configure MySql In Eclipse_MySQL

WBOY
WBOY원래의
2016-06-01 13:13:05870검색

This tutorial explains the step-by-step guide for configuring the database connection within your Eclipse environment. It is one of the advantage for the developer to check the database operations within Eclipse itself instead of checking with external tool. However, this would not have the advanced database operations, but will be handy for checking the updated status of the database. This example demonstrates the MySQL database to be added in Eclipse, however the same steps will be applicable to other database. Before you install the database, you have to download the driver JAR file in your system.

1. Open Data Source Explorer in Eclipse

OpenWindow -> Show View -> Date Source Explorer

Open Data Source Explorer in Eclipse

When you open the window, it would look like this below screenshot.

Open Data Source Explorer in Eclipse View

2. Create New Connection

Right click on the above database option and select “New” for creating the new connection from the database. This below wizard shows the list of databases it supports, here we select the MySQL for our example.

Create New MYSQL Connection

3. MySQL Driver

The below wizards helps you to configure the MySQL driver package and the connection details. This wizard shows the empty list, you have to click on the icon just beside the field “Drivers” which open the new dialog to add the MySQL drivers from your system. If you already have it configured, the the field “Drivers” would list the driver names.

MySQL Driver

Select the MySQL version to be configured.

MySQL Driver

If you don’t have the JAR files added, please add it manually by clicking on the “Add Jar/Zip” button.

MySQL Driver JAR File

Look at the below screenshot, the MYSQL driver is successfully configured and shown in the list. This wizard also helps you to test the connection. If you click on the button “Test Connection”, it will test the connection with database.

mysql-database-ping

4. MySQL Data Source Configured in Eclipse

That’s it!. You have configured the database right within your Eclipse project. You can view the data by clicking on the options provided.

MySQL Data Source Configured in Eclipse

성명:
본 글의 내용은 네티즌들의 자발적인 기여로 작성되었으며, 저작권은 원저작자에게 있습니다. 본 사이트는 이에 상응하는 법적 책임을 지지 않습니다. 표절이나 침해가 의심되는 콘텐츠를 발견한 경우 admin@php.cn으로 문의하세요.