根据Oracle中的指定表生成html或者sql文件

上传者: shuzhixin | 上传时间: 2021-05-19 02:07:41 | 文件大小: 3MB | 文件类型: 7Z
做涉及到数据库的应用系统或者是目前做智能数据分析,一般数据库表包含了系统中的很多业务,所以充分理解数据库表是很有意义的。 目前,这个程序可以根据指定的数据库表列表,自动生成 html信息, 该信息中有表名、列名、数据类型(长度)、是否空、主键、外键、列和表的描述 2,可以直接生成表的创建语句和表的注释、列的注释 数据库配置: dataflow/dataflow/conf/datasource.xml html生成的模板在 dataflow/dataflow/conf/template目录下 生成后的信息放在 dataflow/dataflow/work下 程序的入口类: com.tr.geda.dataflow.meta.MetaManage com.tr.geda.evm.dbscripts.GenerateScripts

文件下载

资源详情

[{"title":"( 79 个子文件 3MB ) 根据Oracle中的指定表生成html或者sql文件","children":[{"title":"dataflow","children":[{"title":".project <span style='color:#111;'> 384B </span>","children":null,"spread":false},{"title":"dataflow","children":[{"title":"conf","children":[{"title":"datasource.xml <span style='color:#111;'> 2.72KB </span>","children":null,"spread":false},{"title":"tables.list <span style='color:#111;'> 42B </span>","children":null,"spread":false},{"title":"comm_tables.list <span style='color:#111;'> 208B </span>","children":null,"spread":false},{"title":"tables.list.bak <span style='color:#111;'> 1.56KB </span>","children":null,"spread":false},{"title":"log4j.properties <span style='color:#111;'> 375B </span>","children":null,"spread":false},{"title":"template","children":[{"title":"head.tmpl <span style='color:#111;'> 1.56KB </span>","children":null,"spread":false},{"title":"end.tmpl <span style='color:#111;'> 921B </span>","children":null,"spread":false}],"spread":true},{"title":"driver.properties <span style='color:#111;'> 503B </span>","children":null,"spread":false},{"title":"datasource.xsd <span style='color:#111;'> 1.93KB </span>","children":null,"spread":false}],"spread":true},{"title":"logs","children":null,"spread":false},{"title":"work","children":[{"title":"data","children":[{"title":"tables","children":[{"title":"OUTPUTDOWNSTREAMCONFIG.tbl <span style='color:#111;'> 1.04KB </span>","children":null,"spread":false},{"title":"VM_TE_CACHE.tbl <span style='color:#111;'> 574B </span>","children":null,"spread":false},{"title":"HEADENDHOST.tbl <span style='color:#111;'> 545B </span>","children":null,"spread":false},{"title":"OUTPUTCONFIGURE.tbl <span style='color:#111;'> 994B </span>","children":null,"spread":false},{"title":"CHANGETE_HIST.tbl <span style='color:#111;'> 870B </span>","children":null,"spread":false},{"title":"TESUMMARY.tbl <span style='color:#111;'> 2.42KB </span>","children":null,"spread":false},{"title":"HEADEND.tbl <span style='color:#111;'> 430B </span>","children":null,"spread":false},{"title":"FLDS_TMPL_DATA.tbl <span style='color:#111;'> 1.19KB </span>","children":null,"spread":false},{"title":"OTPT_TELOG.tbl <span style='color:#111;'> 662B </span>","children":null,"spread":false},{"title":"FIELDS_TEMPLATE.tbl <span style='color:#111;'> 719B </span>","children":null,"spread":false},{"title":"STATUSCHANGE_HIST.tbl <span style='color:#111;'> 718B </span>","children":null,"spread":false},{"title":"KEYCHANGE_HIST.tbl <span style='color:#111;'> 910B </span>","children":null,"spread":false},{"title":"TEDETAIL.tbl <span style='color:#111;'> 850B </span>","children":null,"spread":false},{"title":"FIELDOUTPUTDEF.tbl <span style='color:#111;'> 350B </span>","children":null,"spread":false},{"title":"TESTATUS.tbl <span style='color:#111;'> 531B </span>","children":null,"spread":false},{"title":"HOST.tbl <span style='color:#111;'> 835B </span>","children":null,"spread":false}],"spread":false}],"spread":true},{"title":"gentables","children":[{"title":"GEDA_RIC_DROP.html <span style='color:#111;'> 6.74KB </span>","children":null,"spread":false},{"title":"FMS_CONFIG.html <span style='color:#111;'> 3.48KB </span>","children":null,"spread":false},{"title":"XLE_EXCHANGE_LIST.html <span style='color:#111;'> 3.05KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"src","children":[{"title":"com","children":[{"title":"tr","children":[{"title":"geda","children":[{"title":"dataflow","children":[{"title":"meta","children":[{"title":"TblColumn.java <span style='color:#111;'> 1.42KB </span>","children":null,"spread":false},{"title":"TblRefEntity.java <span style='color:#111;'> 1.51KB </span>","children":null,"spread":false},{"title":"TblMeta.java <span style='color:#111;'> 3.21KB </span>","children":null,"spread":false},{"title":"MetaManage.java <span style='color:#111;'> 11.08KB </span>","children":null,"spread":false}],"spread":true},{"title":"util","children":[{"title":"DBUtil.java <span style='color:#111;'> 1.04KB </span>","children":null,"spread":false},{"title":"DbConn.java <span style='color:#111;'> 1.38KB </span>","children":null,"spread":false},{"title":"EnvUtil.java <span style='color:#111;'> 1.99KB </span>","children":null,"spread":false},{"title":"DateTimeUtil.java <span style='color:#111;'> 2.75KB </span>","children":null,"spread":false},{"title":"Utils.java <span style='color:#111;'> 3.96KB </span>","children":null,"spread":false},{"title":"FileUtil.java <span style='color:#111;'> 827B </span>","children":null,"spread":false},{"title":"LoggerManager.java <span style='color:#111;'> 2.75KB </span>","children":null,"spread":false}],"spread":true},{"title":"jdbc","children":[{"title":"DataSourceType.java <span style='color:#111;'> 344B </span>","children":null,"spread":false},{"title":"DataSourceConfig.java <span style='color:#111;'> 1.29KB </span>","children":null,"spread":false},{"title":"DataSourceException.java <span style='color:#111;'> 413B </span>","children":null,"spread":false},{"title":"DataSourceManager.java <span style='color:#111;'> 8.50KB </span>","children":null,"spread":false},{"title":"DataSourceHelper.java <span style='color:#111;'> 2.47KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"evm","children":[{"title":"dbscripts","children":[{"title":"ScriptsMerge.java <span style='color:#111;'> 4.23KB </span>","children":null,"spread":false},{"title":"GenerateScripts.java <span style='color:#111;'> 3.42KB </span>","children":null,"spread":false},{"title":"InitEnv.java <span style='color:#111;'> 525B </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":"lib","children":[{"title":"jaxen-1.1-beta-6.jar <span style='color:#111;'> 238.60KB </span>","children":null,"spread":false},{"title":"dom4j-1.6.1.jar <span style='color:#111;'> 306.54KB </span>","children":null,"spread":false},{"title":"commons-pool-1.2.jar <span style='color:#111;'> 41.50KB </span>","children":null,"spread":false},{"title":"commons-collections-3.1.jar <span style='color:#111;'> 546.26KB </span>","children":null,"spread":false},{"title":"log4j-1.2.15.jar <span style='color:#111;'> 382.65KB </span>","children":null,"spread":false},{"title":"commons-dbcp-1.2.1.jar <span style='color:#111;'> 105.11KB </span>","children":null,"spread":false},{"title":"commons-io-2.4.jar <span style='color:#111;'> 180.80KB </span>","children":null,"spread":false},{"title":"ojdbc14.jar <span style='color:#111;'> 1.47MB </span>","children":null,"spread":false},{"title":"commons-logging-1.0.4.jar <span style='color:#111;'> 37.12KB </span>","children":null,"spread":false}],"spread":true},{"title":".settings","children":[{"title":"org.eclipse.jdt.core.prefs <span style='color:#111;'> 629B </span>","children":null,"spread":false},{"title":"org.eclipse.core.resources.prefs <span style='color:#111;'> 123B </span>","children":null,"spread":false}],"spread":true},{"title":".classpath <span style='color:#111;'> 862B </span>","children":null,"spread":false},{"title":"bin","children":[{"title":"com","children":[{"title":"tr","children":[{"title":"geda","children":[{"title":"dataflow","children":[{"title":"meta","children":[{"title":"MetaManage.class <span style='color:#111;'> 12.58KB </span>","children":null,"spread":false},{"title":"TblRefEntity.class <span style='color:#111;'> 1.92KB </span>","children":null,"spread":false},{"title":"TblMeta.class <span style='color:#111;'> 4.56KB </span>","children":null,"spread":false},{"title":"TblColumn.class <span style='color:#111;'> 2.04KB </span>","children":null,"spread":false}],"spread":true},{"title":"util","children":[{"title":"DBUtil.class <span style='color:#111;'> 1.43KB </span>","children":null,"spread":false},{"title":"DateTimeUtil.class <span style='color:#111;'> 1.97KB </span>","children":null,"spread":false},{"title":"EnvUtil.class <span style='color:#111;'> 1.87KB </span>","children":null,"spread":false},{"title":"FileUtil.class <span style='color:#111;'> 623B </span>","children":null,"spread":false},{"title":"Utils.class <span style='color:#111;'> 5.37KB </span>","children":null,"spread":false},{"title":"DbConn.class <span style='color:#111;'> 2.00KB </span>","children":null,"spread":false},{"title":"LoggerManager.class <span style='color:#111;'> 2.79KB </span>","children":null,"spread":false}],"spread":true},{"title":"jdbc","children":[{"title":"DataSourceManager.class <span style='color:#111;'> 7.52KB </span>","children":null,"spread":false},{"title":"DataSourceException.class <span style='color:#111;'> 749B </span>","children":null,"spread":false},{"title":"DataSourceHelper.class <span style='color:#111;'> 2.84KB </span>","children":null,"spread":false},{"title":"DataSourceType.class <span style='color:#111;'> 1.45KB </span>","children":null,"spread":false},{"title":"DataSourceConfig.class <span style='color:#111;'> 2.10KB </span>","children":null,"spread":false}],"spread":false}],"spread":true},{"title":"evm","children":[{"title":"dbscripts","children":[{"title":"InitEnv.class <span style='color:#111;'> 1.33KB </span>","children":null,"spread":false},{"title":"ScriptsMerge.class <span style='color:#111;'> 5.30KB </span>","children":null,"spread":false},{"title":"GenerateScripts.class <span style='color:#111;'> 4.76KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true}],"spread":true}],"spread":true}],"spread":true}],"spread":true}]

评论信息

  • fengGDLZ :
    已经使用不知道是不是配置问题 有些问题 无法验证
    2018-11-26
  • cdp963260425 :
    很不错,让我有了头绪
    2017-12-19
  • a11000443 :
    能用,就是版本有点老
    2017-01-10
  • xqhppt :
    很不错的,谢谢
    2015-11-15
  • zhouhaochen :
    可以导出!需设置导出的表!
    2014-05-13

免责申明

【只为小站】的资源来自网友分享,仅供学习研究,请务必在下载后24小时内给予删除,不得用于其他任何用途,否则后果自负。基于互联网的特殊性,【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查;无论 【只为小站】 经营者是否已进行审查,用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场,基于网友分享,根据中国法律《信息网络传播权保护条例》第二十二条之规定,若资源存在侵权或相关问题请联系本站客服人员,zhiweidada#qq.com,请把#换成@,本站将给予最大的支持与配合,做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明