How powerdesigner connects to mysql and exports its Data Model

The hosts file. After installation, select ODBC Data Source. 2. Configure the mysql data source in the control panel, administrative tools, and ODBC Data Source. 3. Select powerdesigner.

Http://hi.baidu.com/ryb_bobo/item/05a21dcf2e123f3199b49864 1、powerdesignerconnect mysql, configure data source, download mydbc-3.51.11-2-win.exe file, after installation, select ODBC Data Source. 2. In the control panel, management tools, ODBC data source configuration mysql Data Source 3, select powerdesigner

Http://hi.baidu.com/ryb_bobo/item/05a21dcf2e123f3199b49864
1、powerdesignerconnect to mysqland configure the data source. Download The mydbc-3.51.11-2-win.exe file. After installation, select ODBC Data Source. 2. on the control panel, administrative tools, and ODBC data source, configure the mysql Data Source
3. Select powerdesigner-> DataBase-> Reverse Engineer DataBase to connect to the Database 4. Select Database in the menu bar, and then select Generate DataBase ---------------------------------------- The following is a jdbc Method -----------------------------------------------------------------

1. Create a project in workspace:

Physical data model type

Select mysql5.0 at the DBMS

2. Create a table UML diagram:

Select a table tool on the toolbar to create a table.

Double-click it to modify it.

Change the name to User_Power User table and create three fields. The ID is the primary key:

Create another table: Address_Power Address Table

3. Assume that the user and address in the business logic correspond one to one, then the address ID is determined by the user ID:

Select reference in the toolbar to establish the association between the two tables:

Here we need to change the association settings according to the business logic:

OK. Now the table design is complete.

4. Establish a connection with the database.

There is a Database option on the menu bar:

Select connect... Then the Setting dialog box is displayed:

Select the third radio button in Data source, that is, Connection profile:, and click Configure. The following window is displayed:

Select Add Data Source in the upper left corner. The following window is displayed:

Then, start setting and click set. The first parameter is the name and can be retrieved at will. The second parameter is the location where the configuration file is saved and placed in the workspace; the third is the description, no need to worry about it; the fourth is the connection type; the fifth is the database type; the sixth is the seventh, and the eighth is the username and password; the last three are some Mysql connection configurations. Note that the last JDBC driver jar files needs to be selected to the mysql jar package.

Click Test Connection in the lower left corner and click OK to close the page after the Test is passed. Return to the connect page and select the configuration file and connect to it:

5. Create a database table:

Select Database in the menu bar, and then select Generate Database. The following page is displayed:

Let you choose where the generated SQL file is stored. Here we use the Direct generation option to directly create an output table. On the second tab Options, you can select some Options to change the SQL statement. The final SQL statement can be viewed through the last tab Preview:

Click OK to generate the SQL script. The following page is displayed:

Click run to create the table.