PowerDesigner generates a Mysql band

1. Install PowerDesigner

Reference
https://blog.csdn. net/sinat_34104446/article/details/79885141

2 Configuration reverse engineering

2.1 New model pdm< /h3>

New model PNG

Note: DBMS select MYSQL5.0

/div>

Configure link PNG

< div class="image-view" data-width="644" data-height="584"> New database link-01.png

< span>Configuration link PNG

com.mysql.jdbc.Driver
jdbc:mysql://192.168.0.151:3306/nbspider 

Test connection to PNG < /div>

Frequently asked questions:
JavaVM cannot be initialized!
This is because powerdesiger requires 32-bit jdk If you don’t want to modify the environment variables, you can configure the script startup-classpath.bat in the powerdesiger installation directory

Set JAVA_HOME=C :\Java\jdk1.8.0_181-32 Set CLASSPATH =C:\Java\repo\mysql\mysql-connector-java\5.1.45\mysql-connector-java-5.1.45 .jar pdshell16.exe 

2.2 Modify the model according to the database link

Modify model 01.png

Modify model 02.png

• In addition, if the exported data volume structure needs to export foreign keys and other relations, Then choose the following options as appropriate.

  Export foreign key configuration button

• click OK
  
  Choose the exported database PNG

  Select the database to be exported, you can first Select "ALL users", deselect all, then select the database to be reverse engineered, and then click select all.

2.3 Generate Reverse Engineering

The effect is as follows:

image.png

Edit table name

image.png< /span>

Show comment column

1. Enter preferences

   Display code.png

2. Select code
   
   image.png< /span>

   https://blog.csdn.net/qq_17010367/article/details/79212850

   Custom column attribute button

   Display code Lebanon

   The effect after setting is as follows:

   image. png

3. In PowerDesigner, the code and name fields of the table structure are all in English, which is not easy to read. If you need to add the If the field is replaced to the name field, the execution method: Tool-execute command-edit/run script, the following dialog box will pop up:

   image.png

< div class="image-view" data-width="667" data-height="468"> image.png

• Vb script code As follows:

Option Explicit
ValidationMode = True
InteractiveMode = im_Batch

Dim mdl 'the current model'get the current active model Set mdl = ActiveModel If (mdl Is Nothing) Then MsgBox "There is no current Model "ElseIf Not mdl.IsKindOf(PdPDM.cls_Model) Then MsgBox "The current model is not an Physical Data model." Else ProcessFolder mdl End If  'This routine copy name into code for each table, each column and each view'of the current folder Private sub ProcessFolder(folder) Dim Tab 'running table for each Tab in folder.tables if not tab.isShortcut then if len(tab.comment) <> 0 then tab.name = tab.comment end if On Error Resume Next Dim col'running column for each col in tab.columns if len(col.comment) <>0 then col.name =col.comment end if On Er ror Resume Next next end if next end sub < /span>

After execution, you can save the VBScript locally, and execute it next time Execute the local script at time

/div>

image.png

4. The effect after execution is as follows:

Final effect picture Banyu

< /div>

3. How to add comments when PowerDesigner exports SQL

• Reference:https

• Reference:https: //jingyan.baidu.com/album/47a29f24652e44c0142399c3.html ? picindex
  = 2

4. #PowerDesigner generates mysql field comments Notes

• Reference:https: //www.cnblogs.com/kangxuebin/articles/3688146.html

5. PowerDesigner exports PDM to generate WORD documents

https://blog.csdn.net/ni_hao_ya/article/details/51282618