Use DORADO5 to create a connection to a database (MySQL is connected to the database here)

1. In Dorado, expand the project that has been created:

2. Locate the DataSource (data source) node under Configures (config file), and double-click the node to get the database connection creation area on the right side of the display area:

3, click the red circle marked the portion of the green "ADD" to start the connection of the database, click the "Data source name" to create, and "data source Type" selection, here, the type of the default Jdbc,name random (preferably with the project name, such as the project is Hr_manage, The name is set to HR_MANAGEJDBC):

4, click OK, pop up the "Data Source Configuration Center", the database used in this project is MySQL, the configuration is as follows:

Where dialect select with MySQL, driver select MySQL driver, the URL of the address behind the database changed to the database created in Word Count database, here is the example of "School database", and then the username user (is the MySQL database connection user name, The default is root, of course, depends on your installation of MySQL is the user name you write, password is also the user name set when installing MySQL. followed by the database encoding format, it must be in the database we created when the code format of the library is consistent, otherwise garbled. Then click OK (Parameters no tube);

5, click OK will appear the following interface, has generated a database connection object, can be used at any time (using all the tables contained therein):

6, test, test whether it (HR_MANAGEJDBC) can successfully connect to the database.

(1) Open the server, click the Dorado Service Start button, as follows:

The service starts and the console appears as follows:

(2) After the service starts (must start the service) click on the Vilidata in the upper right to connect the test:

(3) The following situation indicates that the connection of database school (the database that I created in this example) is successful and can be called at any time:

(5) Click "OK", dorado the connection with the database is complete!

PS: If help you, please reply "Thank you", really gray often thanks!

If there is doubt, the pro direct question, I will be the first time online answer!

Use DORADO5 to create a connection to a database (MySQL is connected to the database here)