1. Download the spoon package and driver
The spoon package I use, including spoon7.1, Mysql driver and Oracle driver
link: https:// pan.baidu.com/s/16Q-iUNB7qGU0xlKbGTw-vg Extraction code: q9h5
If you have installed an Oracle database or oracle client locally, you can use its own Oracle driver,
< p> all the jar packages beginning with ojdbc under the directory: \product\11.2.0\dbhome_1\jdbc\lib
2, double-click spoon.bat to open the spoon main page
Click “File” in the upper left corner, create a new conversion, configure a data connection (using mysql database as an example)
select the “main object tree” in the left working area, select DB connection, right-click and select New, enter Configuration information
If the database is local, the host name can be written as localhost, if not locally, write the ip of the host where the database is located
3. Click test, and the following pop-up box appears, indicating that the configuration is correct
For Oracle database connection, please refer to the following configuration:
p>