将pdm中的字段名称或者备注写入oracle数据库的备注字段（源码）

最新推荐文章于 2022-08-02 11:22:31 发布
最新推荐文章于 2022-08-02 11:22:31 发布
阅读量481 收藏
点赞数
分类专栏： oracle c# pdm 文章标签： c# pdm oracle
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/badaaasss/article/details/85991918
版权
c# 同时被 3 个专栏收录
9 篇文章 0 订阅
订阅专栏
oracle
8 篇文章 1 订阅
订阅专栏
pdm
2 篇文章 0 订阅
订阅专栏 
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Xml;
using System.Collections.Generic;
using System.Xml.XPath;
public partial class crbbg_pdm : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        GetDataBaseTable();//将pdm文件中字段的注释或者中文名，同步到数据库对应字段的注释里。 
    }
   

        public void GetDataBaseTable()
        {
            XmlDocument xmlDoc = new XmlDocument();
            xmlDoc.Load("C://Users//1.pdm");
            XmlNamespaceManager xmlnsManager = new XmlNamespaceManager(xmlDoc.NameTable);
            xmlnsManager.AddNamespace("a", "attribute");
            xmlnsManager.AddNamespace("c", "collection");
            xmlnsManager.AddNamespace("o", "object");
            XmlNode xnTables = xmlDoc.SelectSingleNode("//" + "c:Tables", xmlnsManager);
 
            List<PDMTableInfo> Tables = new List<PDMTableInfo>();
            foreach (XmlNode xnTable in xnTables.ChildNodes)
            {
                Tables.Add(GetTable(xnTable));
            }
          //comment on column OA_GZLC.YXQ is 'aa';
            AddCommnet(Tables);
         
        }
        private void AddCommnet(List<PDMTableInfo> Tables)
        {
            foreach (PDMTableInfo lm_info in Tables)
            {
                using (CDataBase cdb = new CDataBase("ylgz3"))
                {
                    string sql3 = "select table_name from all_tab_comments where table_name='" + lm_info.Code.ToUpper() + "' and  comments is null";
                    object lo_isnull = cdb.ExeSQL(sql3);
                    if (lo_isnull != DBNull.Value && lo_isnull != null)
                    {
                        string ls_commnt = "";
                        if (!string.IsNullOrEmpty(lm_info.Comment))
                            ls_commnt = lm_info.Comment;
                        else
                            ls_commnt = lm_info.Name;
                        string sql2 = "comment on table " + lm_info.Code + " is '" + Replace(lm_info.Name) + "' ";
                        try
                        {
                            cdb.ExeSQL(sql2);
                            cdb.Commit();
                        }
                        catch
                        {
                            continue;
                        }
                    }
                    if (lm_info.Columns != null)
                    {
                        foreach (PDMColumnInfo col in lm_info.Columns)
                        {
                            string ls_commnt = "";
                            if (!string.IsNullOrEmpty(col.Comment))
                                ls_commnt = col.Comment;
                            else
                                ls_commnt = col.Name;
                            string sql = "select * from user_col_comments where table_name='" + lm_info.Code.ToUpper()  + "' and  comments is null";
                            DataTable dt = cdb.SetDataTable(sql);
                            foreach (DataRow dr in dt.Rows)
                            {
                                if (dr["column_name"].ToString() == col.Code.ToUpper() && (dr["comments"] == null || dr["comments"] == DBNull.Value))
                                {

                                    string sql1 = "comment on column " + lm_info.Code + "." + col.Code + " is '" + Replace(ls_commnt) + "'";
                                    cdb.ExeSQL(sql1);
                                    cdb.Commit();
                                }
                            }
                        }
                    }
                }
              
            }
        }
        public string Replace(string ls_commnt)
        {
          return  Util.f_replacehtml(ls_commnt);
        }
        public class TableInfo
        {
            public TableInfo()
            {
            }
            string tableId;

            public string TableId
            {
                get { return tableId; }
                set { tableId = value; }
            }
            string objectID;

            public string ObjectID
            {
                get { return objectID; }
                set { objectID = value; }
            }
            string name;

            public string Name
            {
                get { return name; }
                set { name = value; }
            }
            string code;

            public string Code
            {
                get { return code; }
                set { code = value; }
            }
            int creationDate;

            public int CreationDate
            {
                get { return creationDate; }
                set { creationDate = value; }
            }
            string creator;

            public string Creator
            {
                get { return creator; }
                set { creator = value; }
            }
            int modificationDate;

            public int ModificationDate
            {
                get { return modificationDate; }
                set { modificationDate = value; }
            }
            string modifier;

            public string Modifier
            {
                get { return modifier; }
                set { modifier = value; }
            }
            string comment;

            public string Comment
            {
                get { return comment; }
                set { comment = value; }
            }

            string physicalOptions;

            public string PhysicalOptions
            {
                get { return physicalOptions; }
                set { physicalOptions = value; }
            }


            IList<ColumnInfo> columns;

            public IList<ColumnInfo> Columns
            {
                get { return columns; }
            }

            IList<PdmKey> keys;

            public IList<PdmKey> Keys
            {
                get { return keys; }
            }

            public void AddColumn(ColumnInfo mColumn)
            {
                if (columns == null)
                    columns = new List<ColumnInfo>();
                columns.Add(mColumn);
            }

            public void AddKey(PdmKey mKey)
            {
                if (keys == null)
                    keys = new List<PdmKey>();
                keys.Add(mKey);
            }
        }
        public class PdmKey
        {
            public PdmKey()
            {
            }

            string keyId;

            public string KeyId
            {
                get { return keyId; }
                set { keyId = value; }
            }
            string objectID;

            public string ObjectID
            {
                get { return objectID; }
                set { objectID = value; }
            }
            string name;

            public string Name
            {
                get { return name; }
                set { name = value; }
            }
            string code;

            public string Code
            {
                get { return code; }
                set { code = value; }
            }
            int creationDate;

            public int CreationDate
            {
                get { return creationDate; }
                set { creationDate = value; }
            }
            string creator;

            public string Creator
            {
                get { return creator; }
                set { creator = value; }
            }
            int modificationDate;

            public int ModificationDate
            {
                get { return modificationDate; }
                set { modificationDate = value; }
            }
            string modifier;

            public string Modifier
            {
                get { return modifier; }
                set { modifier = value; }
            }

            IList<ColumnInfo> columns;

            public IList<ColumnInfo> Columns
            {
                get { return columns; }
            }

            public void AddColumn(ColumnInfo mColumn)
            {
                if (columns == null)
                    columns = new List<ColumnInfo>();
                columns.Add(mColumn);
            }
        }

        //初始化"o:Table"的节点
        private PDMTableInfo GetTable(XmlNode xnTable)
        {
            PDMTableInfo mTable = new PDMTableInfo();
            XmlElement xe = (XmlElement)xnTable;
            mTable.TableId = xe.GetAttribute("Id");
            XmlNodeList xnTProperty = xe.ChildNodes;
            foreach (XmlNode xnP in xnTProperty)
            {
                switch (xnP.Name)
                {
                    case "a:ObjectID": mTable.ObjectID = xnP.InnerText;
                        break;
                    case "a:Name": mTable.Name = xnP.InnerText;
                        break;
                    case "a:Code": mTable.Code = xnP.InnerText;
                        break;
                    case "a:CreationDate": mTable.CreationDate = Convert.ToInt32(xnP.InnerText);
                        break;
                    case "a:Creator": mTable.Creator = xnP.InnerText;
                        break;
                    case "a:ModificationDate": mTable.ModificationDate = Convert.ToInt32(xnP.InnerText);
                        break;
                    case "a:Modifier": mTable.Modifier = xnP.InnerText;
                        break;
                    case "a:Comment": mTable.Comment = xnP.InnerText;
                        break;
                    case "a:PhysicalOptions": mTable.PhysicalOptions = xnP.InnerText;
                        break;
                    case "c:Columns": InitColumns(xnP, mTable);
                        break;
                    case "c:Keys": InitKeys(xnP, mTable);
                        break;
                }
            }
            return mTable;
        }
        //初始化"c:Columns"的节点
        private void InitColumns(XmlNode xnColumns, PDMTableInfo pTable)
        {
            foreach (XmlNode xnColumn in xnColumns)
            {
                pTable.AddColumn(GetColumn(xnColumn));
            }
        }
 
        //初始化c:Keys"的节点
        private void InitKeys(XmlNode xnKeys, PDMTableInfo pTable)
        {
            foreach (XmlNode xnKey in xnKeys)
            {
                pTable.AddKey(GetKey(xnKey));
            }
        }
        public class ColumnInfo
        {
            public ColumnInfo()
            { }

            string columnId;

            public string ColumnId
            {
                get { return columnId; }
                set { columnId = value; }
            }
            string objectID;

            public string ObjectID
            {
                get { return objectID; }
                set { objectID = value; }
            }
            string name;

            public string Name
            {
                get { return name; }
                set { name = value; }
            }
            string code;

            public string Code
            {
                get { return code; }
                set { code = value; }
            }
            int creationDate;

            public int CreationDate
            {
                get { return creationDate; }
                set { creationDate = value; }
            }
            string creator;

            public string Creator
            {
                get { return creator; }
                set { creator = value; }
            }
            int modificationDate;

            public int ModificationDate
            {
                get { return modificationDate; }
                set { modificationDate = value; }
            }
            string modifier;

            public string Modifier
            {
                get { return modifier; }
                set { modifier = value; }
            }
            string comment;

            public string Comment
            {
                get { return comment; }
                set { comment = value; }
            }
            string dataType;

            public string DataType
            {
                get { return dataType; }
                set { dataType = value; }
            }
            string length;

            public string Length
            {
                get { return length; }
                set { length = value; }
            }
            //是否自增量
            bool identity;

            public bool Identity
            {
                get { return identity; }
                set { identity = value; }
            }
            bool mandatory;
            //禁止为空
            public bool Mandatory
            {
                get { return mandatory; }
                set { mandatory = value; }
            }
            string extendedAttributesText;
            //扩展属性
            public string ExtendedAttributesText
            {
                get { return extendedAttributesText; }
                set { extendedAttributesText = value; }
            }
            string physicalOptions;

            public string PhysicalOptions
            {
                get { return physicalOptions; }
                set { physicalOptions = value; }
            }
        }

        private PDMColumnInfo GetColumn(XmlNode xnColumn)
        {
            PDMColumnInfo mColumn = new PDMColumnInfo();
            XmlElement xe = (XmlElement)xnColumn;
            mColumn.ColumnId = xe.GetAttribute("Id");
            XmlNodeList xnCProperty = xe.ChildNodes;
            foreach (XmlNode xnP in xnCProperty)
            {
                switch (xnP.Name)
                {
                    case "a:ObjectID": mColumn.ObjectID = xnP.InnerText;
                        break;
                    case "a:Name": mColumn.Name = xnP.InnerText;
                        break;
                    case "a:Code": mColumn.Code = xnP.InnerText;
                        break;
                    case "a:CreationDate": mColumn.CreationDate = Convert.ToInt32(xnP.InnerText);
                        break;
                    case "a:Creator": mColumn.Creator = xnP.InnerText;
                        break;
                    case "a:ModificationDate": mColumn.ModificationDate = Convert.ToInt32(xnP.InnerText);
                        break;
                    case "a:Modifier": mColumn.Modifier = xnP.InnerText;
                        break;
                    case "a:Comment": mColumn.Comment = xnP.InnerText;
                        break;
                    case "a:DataType": mColumn.DataType = xnP.InnerText;
                        break;
                    case "a:Length": mColumn.Length = xnP.InnerText;
                        break;
                    case "a:Identity": mColumn.Identity = ConvertToBooleanPG(xnP.InnerText);
                        break;
                    case "a:Mandatory": mColumn.Mandatory = ConvertToBooleanPG(xnP.InnerText);
                        break;
                    case "a:PhysicalOptions": mColumn.PhysicalOptions = xnP.InnerText;
                        break;
                    case "a:ExtendedAttributesText": mColumn.ExtendedAttributesText = xnP.InnerText;
                        break;
                }
            }
            return mColumn;
        }
 
        private PDMKey GetKey(XmlNode xnKey)
        {
            PDMKey mKey = new PDMKey();
            XmlElement xe = (XmlElement)xnKey;
            mKey.KeyId = xe.GetAttribute("Id");
            XmlNodeList xnKProperty = xe.ChildNodes;
            foreach (XmlNode xnP in xnKProperty)
            {
                switch (xnP.Name)
                {
                    case "a:ObjectID": mKey.ObjectID = xnP.InnerText;
                        break;
                    case "a:Name": mKey.Name = xnP.InnerText;
                        break;
                    case "a:Code": mKey.Code = xnP.InnerText;
                        break;
                    case "a:CreationDate": mKey.CreationDate = Convert.ToInt32(xnP.InnerText);
                        break;
                    case "a:Creator": mKey.Creator = xnP.InnerText;
                        break;
                    case "a:ModificationDate": mKey.ModificationDate = Convert.ToInt32(xnP.InnerText);
                        break;
                    case "a:Modifier": mKey.Modifier = xnP.InnerText;
                        break;
                    //还差 <c:Key.Columns>
                }
            }
            return mKey;
        }
 
        private static Boolean ConvertToBooleanPG(Object obj)
        {
            if (obj != null)
            {
                string mStr = obj.ToString();
                mStr = mStr.ToLower();
                if ((mStr.Equals("y") || mStr.Equals("1")) || mStr.Equals("true"))
                {
                    return true;
                }
            }
            return false;
        }
    } 


public class PDMColumnInfo
    {
        public PDMColumnInfo()
        { }
 
        string columnId;
 
        public string ColumnId
        {
            get { return columnId; }
            set { columnId = value; }
        }
        string objectID;
 
        public string ObjectID
        {
            get { return objectID; }
            set { objectID = value; }
        }
        string name;
 
        public string Name
        {
            get { return name; }
            set { name = value; }
        }
        string code;
 
        public string Code
        {
            get { return code; }
            set { code = value; }
        }
        int creationDate;
 
        public int CreationDate
        {
            get { return creationDate; }
            set { creationDate = value; }
        }
        string creator;
 
        public string Creator
        {
            get { return creator; }
            set { creator = value; }
        }
        int modificationDate;
 
        public int ModificationDate
        {
            get { return modificationDate; }
            set { modificationDate = value; }
        }
        string modifier;
 
        public string Modifier
        {
            get { return modifier; }
            set { modifier = value; }
        }
        string comment;
 
        public string Comment
        {
            get { return comment; }
            set { comment = value; }
        }
        string dataType;
 
        public string DataType
        {
            get { return dataType; }
            set
            {
                if (value.Contains("nvarchar") || value.Contains("varchar"))
                {
                    value = "string";
                }
                if (value.Contains("money"))
                {
                    value = "decimal";
                }
                dataType = value; 
            }
        }
        string length;
 
        public string Length
        {
            get { return length; }
            set { length = value; }
        }
        //是否自增量
        bool identity;
 
        public bool Identity
        {
            get { return identity; }
            set { identity = value; }
        }
        bool mandatory;
        //禁止为空
        public bool Mandatory
        {
            get { return mandatory; }
            set { mandatory = value; }
        }
        string extendedAttributesText;
        //扩展属性
        public string ExtendedAttributesText
        {
            get { return extendedAttributesText; }
            set { extendedAttributesText = value; }
        }
        string physicalOptions;
 
        public string PhysicalOptions
        {
            get { return physicalOptions; }
            set { physicalOptions = value; }
        }
    } 
　　

public class PDMKey
    {
        public PDMKey()
        {
        }
 
        string keyId;
 
        public string KeyId
        {
            get { return keyId; }
            set { keyId = value; }
        }
        string objectID;
 
        public string ObjectID
        {
            get { return objectID; }
            set { objectID = value; }
        }
        string name;
 
        public string Name
        {
            get { return name; }
            set { name = value; }
        }
        string code;
 
        public string Code
        {
            get { return code; }
            set { code = value; }
        }
        int creationDate;
 
        public int CreationDate
        {
            get { return creationDate; }
            set { creationDate = value; }
        }
        string creator;
 
        public string Creator
        {
            get { return creator; }
            set { creator = value; }
        }
        int modificationDate;
 
        public int ModificationDate
        {
            get { return modificationDate; }
            set { modificationDate = value; }
        }
        string modifier;
 
        public string Modifier
        {
            get { return modifier; }
            set { modifier = value; }
        }
 
        IList<PDMColumnInfo> columns;
 
        public IList<PDMColumnInfo> Columns
        {
            get { return columns; }
        }
 
        public void AddColumn(PDMColumnInfo mColumn)
        {
            if (columns == null)
                columns = new List<PDMColumnInfo>();
            columns.Add(mColumn);
        }
    } 
　　

public class PDMTableInfo
    {
        public PDMTableInfo()
        {
        }
        string tableId;
 
        public string TableId
        {
            get { return tableId; }
            set { tableId = value; }
        }
        string objectID;
 
        public string ObjectID
        {
            get { return objectID; }
            set { objectID = value; }
        }
        string name;
 
        public string Name
        {
            get { return name; }
            set { name = value; }
        }
        string code;
 
        public string Code
        {
            get { return code; }
            set { code = value; }
        }
        int creationDate;
 
        public int CreationDate
        {
            get { return creationDate; }
            set { creationDate = value; }
        }
        string creator;
 
        public string Creator
        {
            get { return creator; }
            set { creator = value; }
        }
        int modificationDate;
 
        public int ModificationDate
        {
            get { return modificationDate; }
            set { modificationDate = value; }
        }
        string modifier;
 
        public string Modifier
        {
            get { return modifier; }
            set { modifier = value; }
        }
        string comment;
 
        public string Comment
        {
            get { return comment; }
            set { comment = value; }
        }
 
        string physicalOptions;
 
        public string PhysicalOptions
        {
            get { return physicalOptions; }
            set { physicalOptions = value; }
        }
 
 
        IList<PDMColumnInfo> columns;
 
        public IList<PDMColumnInfo> Columns
        {
            get { return columns; }
        }
 
        IList<PDMKey> keys;
 
        public IList<PDMKey> Keys
        {
            get { return keys; }
        }
 
        public void AddColumn(PDMColumnInfo mColumn)
        {
            if (columns == null)
                columns = new List<PDMColumnInfo>();
            columns.Add(mColumn);
        }
 
        public void AddKey(PDMKey mKey)
        {
            if (keys == null)
                keys = new List<PDMKey>();
            keys.Add(mKey);
        }
    }

其中，f_replacehtml是字符串替换函数，代码如下：

 /// <summary>
        /// 删除html脚本 2016-6-20 liushi
        /// </summary>
        /// <param name="Htmlstring"></param>
        /// <returns></returns>
        public static string f_replacehtml(string Htmlstring)
        {
            Htmlstring = Regex.Replace(Htmlstring, @"<script[^>]*?>.*?</script>", "", RegexOptions.IgnoreCase);

            //删除HTML

            Htmlstring = Regex.Replace(Htmlstring, @"<(.[^>]*)>", "", RegexOptions.IgnoreCase);

            Htmlstring = Regex.Replace(Htmlstring, @"([\r\n])[\s]+", "", RegexOptions.IgnoreCase);

            Htmlstring = Regex.Replace(Htmlstring, @"-->", "", RegexOptions.IgnoreCase);

            Htmlstring = Regex.Replace(Htmlstring, @"<!--.*", "", RegexOptions.IgnoreCase);

            Htmlstring = Regex.Replace(Htmlstring, @"&(quot|#34);", "\"", RegexOptions.IgnoreCase);

            Htmlstring = Regex.Replace(Htmlstring, @"&(amp|#38);", "&", RegexOptions.IgnoreCase);

            Htmlstring = Regex.Replace(Htmlstring, @"&(lt|#60);", "<", RegexOptions.IgnoreCase);

            Htmlstring = Regex.Replace(Htmlstring, @"&(gt|#62);", ">", RegexOptions.IgnoreCase);

            Htmlstring = Regex.Replace(Htmlstring, @"&(nbsp|#160);", " ", RegexOptions.IgnoreCase);

            Htmlstring = Regex.Replace(Htmlstring, @"&(iexcl|#161);", "\xa1", RegexOptions.IgnoreCase);

            Htmlstring = Regex.Replace(Htmlstring, @"&(cent|#162);", "\xa2", RegexOptions.IgnoreCase);

            Htmlstring = Regex.Replace(Htmlstring, @"&(pound|#163);", "\xa3", RegexOptions.IgnoreCase);

            Htmlstring = Regex.Replace(Htmlstring, @"&(copy|#169);", "\xa9", RegexOptions.IgnoreCase);

            Htmlstring = Regex.Replace(Htmlstring, @"&#(\d+);", "", RegexOptions.IgnoreCase);

            Htmlstring = Htmlstring.Replace("<", "");

            Htmlstring = Htmlstring.Replace(">", "");

            Htmlstring = Htmlstring.Replace("\"", "“");

            Htmlstring = Htmlstring.Replace("\'", "’");

            //Htmlstring = Htmlstring.Replace("—", "");

            //Htmlstring = Htmlstring.Replace("…", "");
            Htmlstring = HttpContext.Current.Server.HtmlEncode(Htmlstring).Trim();

            return Htmlstring;

        }

 

fighting_1982
关注
专栏目录
oracle 表导出pdm文件,如何将数据库中已有表导入到powerDesigner生成pdm文件
weixin_36472625的博客
04-12 1690
1、createnewPDM；2、selectdatabasemenu;3、clickReverseEngineerdatabase；4、thenchooseyourscriptfile；5、clickOK；6、success。还有一个版本1，打开Powerdesigner工具，创建一个PDM文件，选择与之匹配的数据库类型“ibmdb2udb8.xcommo...
批量修改pdm文件表名、字段名和注释
10-17
用于批量更新PDM文件中表名、字段名code和name同时为英文的情况，使用正则和Java代码进行批量替换，需要编译工具的支持如Eclipse
【power designer】使用power designer编辑pdm物理模型图时，为字段添加中文备注
weixin_33733810的博客
05-25 856
    如下图：   1.双击下图修改 应用如下   2.为数据列添加备注属性     然后为备注列添加 中文备注 【注意，这里有个小技巧，如果光标已经点进去这个单元格，是不能复制进去文字的，但是第一次点击单元格，是可以复制进去文字的】   保存如下：    ...
PDM添加字段注释列和创建索引、查看SQL
FromNowOnUntilTheEnd
02-25 2072
1、pdm建表要注意保存为pdm文件 2、pdm界面将comment列调出，点击那个漏斗状图标。该列用来给字段设置注释 3、创建索引在Indexes选项，查看sql在preview
PDM设置备注（COMMON）,设置及作用
刺猬的博客
08-02 523
PDM设置备注（COMMON）,设置及作用
PowerDesigner 16PDM显示备注
aituochang1886的博客
03-07 795
默认显示的列是Name及类型 name和code不支持同时显示，设置方法： 　　Tool->Model Options->Name Convention->右侧display中选择显示name还是code 想同时显示实际表名和中文说明，使导出图片图更加清晰 中文说明放在备注里 默认在添加字段时，备注也是不显示的，显示设置的方法 将备注放到 s...
pdm连接oracle数据库
08-23
本文将详细介绍如何在PDM环境中成功连接到Oracle数据库的具体步骤。 #### 二、连接Oracle数据库的操作步骤 1. **进入菜单文件-ReverseEngineer-Database** - 在PDM软件中找到并点击“文件”菜单。 - 从下拉菜单...
PowerDesigner逆向工程显示字段备注
07-17
PowerDesigner16.5逆向工程显示字段备注,生成的更贴合。使用的是命令运行的方式，本人亲试，非常方便。
Powerdesigner字段备注导入到数据库
02-15
在“Model”菜单中选择“Generate Database”（生成数据库），然后在“Output Options”（输出选项）中勾选“Comments”（备注），PowerDesigner会将字段备注包含在生成的脚本中。 5. **导入字段备注到数据库** 将...
PowerDesigner批量生成SQL脚本时将name生成数据库中字段的comment
11-20
在本篇中，我们将探讨如何使用PowerDesigner批量生成SQL脚本来将name属性转换为数据库中字段的comment。 首先，我们需要了解PowerDesigner中的PDM（Physical Data Model），这是一个物理数据模型，它包含了数据库的...
给PDM所有表相同字段一次性添加Comment
01-26
打开PowerDesigner, ctrl+shift+x ，复制文本内容，修改对应comment，run。其余字段也可使用此脚本。
powerdesigner连接oracle——PDM显示注释
saydo
04-24 368
来自网络 利用vbs脚本完成。 在Sybase安装路径/VB Scripts下新建Comments2Name.vbs，内容如下：   OptionExplicit ValidationMode =True InteractiveMode = im_Batch Dim mdl 'the current model 'get the current ...
pdm怎么导入oracle,Oracle数据反向导入到pdm
weixin_34154352的博客
04-03 803
一、前置条件已存在oracle数据库已安装PowerDesigner数据库建模工具二、在PowerDesigner中创建jdbc数据库连接点击 “File>Reverse Engineer>Database” 选择数据源，如果之前没有创建则点击"Configure"进行配置 三、开始导入选择要导入的表 四、设置使name显示中文名称，点击 "Tools>Excute C...
powerdesigner 生成oracle,PowerDesigner 生成Oracle comment 备注
weixin_31119281的博客
04-15 265
环境：PowerDesigner 15.1.0.2850，oracle 11g如需生成的表与表字段有comment(备注)，钩选上红色框标识的checkbox.操作菜单: Database->Generat Database ->Format 生成后脚本：/*==============================================================*/...
PowerDesigner16.5生成SQL语句建表时如何将字段名name列复制到备注comment注释里面
zhangkai19910815的博客
05-22 2435
每次我用PowerDesigner设计数据库时，都只是注释了一些复杂的字段，一些简单的字段根本就不用注释，见到code就知道其中的意思，奈何本人英文水平有限，加上一些英文单词太长进行了简写，我就想要把字段名称name这列复制到没有注释的comment列里面，这样的话通过数据库可视化工具navicat就可以直接看到了。 数据库是ORACLE的话还好说，MySql就恼火了。最后终于找到通过脚本去生成。步骤如下： 创建表： 比如：先创建一张学生表student，有如下字段，我仅注释了性别字段。 打开编辑脚本的界
PowerDesigner使用（一）：PDM文件导入Oracle数据库
风雪独秀
08-30 1万+
PDM文件导入不同数据库的过程基本相同，这里以Oracle数据库为例，详解导入的具体步骤。所使用的导入软件PowerDesigner版本为16.5。
PowerDesigner 表字段添加注释
zhouzhiwengang的专栏
05-19 4497
PowerDesigner显示注释字段问题 选择那个表,右键- >Properties- >Columns- >Customize Columns and Filter(或直接用快捷键Ctrl+U)- >Comment(前面打勾)- >OK
powerdesigner 字段添加注释和默认值
热门推荐
qingzhuoran的博客
01-06 6万+
 1、选中表，右键       2. 选中“comment”, 这个就是列的注释 3.还是这个页面 ，往下有个“default value”, 这个就是你设置的默认值。 4. 这个是怎么设置默认值。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值