简单而功能强大的自定义序列号生成器

上传者: solarxie | 上传时间: 2022-05-16 10:36:28 | 文件大小: 12KB | 文件类型: RAR
序列号自动增长组件 解决问题: 1. 通常编号的生成,用oracle的sequence,sql的自动增长变号,或select max 方式,这些方式用起来不是特别方便或不够灵活,满足不了业务规则,如oracle的sequence,需要建立sequence对象,增加程序的复杂性和维护量等。 2. 使用方便,如要增加新的序号类型,无需编程,在db中配置一行数据就可以了。 -- 功能比较强大: 通过配置数据,能够产生不同的编号规则,基本能满足日常的各种应用了 -- 实现时注意: 组件的事物完整性,不和业务逻辑同事物;注意并发性控制; -- 目前只有oracle db的版本,ms sql的版本,以后再上 -- 其它: 如生成的号不用,生成的号作废 功能: 可以带前缀和后缀 可以带日期(年,年月,年月日等) 数字部分可以任意长度(不够时,前面填0) 数字部分的增长,每次增长步长可以设置,默认为1 数字部分可以以日期段循环编号(如日期部分为YYMM,跨月时,重新从最小值编号)

文件下载

资源详情

[{"title":"( 19 个子文件 12KB ) 简单而功能强大的自定义序列号生成器","children":[{"title":"generate_no","children":[{"title":"oracle","children":[{"title":"ddl.sp.com_db_seq_generator.sql <span style='color:#111;'> 3.11KB </span>","children":null,"spread":false},{"title":"sp_com_db_seq_generator.sql <span style='color:#111;'> 3.13KB </span>","children":null,"spread":false},{"title":"data.reimburse.com_db_seq_generator.sql <span style='color:#111;'> 300B </span>","children":null,"spread":false},{"title":"data.test.com_db_seq_generator.sql <span style='color:#111;'> 291B </span>","children":null,"spread":false},{"title":"ddl.table.com_db_seq_generator.sql <span style='color:#111;'> 1.01KB </span>","children":null,"spread":false},{"title":"ddl.trigger.com_db_seq_generator.sql <span style='color:#111;'> 493B </span>","children":null,"spread":false},{"title":".svn","children":[{"title":"all-wcprops <span style='color:#111;'> 1.14KB </span>","children":null,"spread":false},{"title":"prop-base","children":[{"title":"readme.txt.svn-base <span style='color:#111;'> 53B </span>","children":null,"spread":false}],"spread":true},{"title":"props","children":null,"spread":false},{"title":"tmp","children":[{"title":"prop-base","children":null,"spread":false},{"title":"props","children":null,"spread":false},{"title":"text-base","children":null,"spread":false}],"spread":true},{"title":"text-base","children":[{"title":"readme.txt.svn-base <span style='color:#111;'> 465B </span>","children":null,"spread":false},{"title":"ddl.sp.com_db_seq_generator.sql.svn-base <span style='color:#111;'> 3.11KB </span>","children":null,"spread":false},{"title":"ddl.table.com_db_seq_generator.sql.svn-base <span style='color:#111;'> 1.01KB </span>","children":null,"spread":false},{"title":"data.reimburse.com_db_seq_generator.sql.svn-base <span style='color:#111;'> 300B </span>","children":null,"spread":false},{"title":"ddl.trigger.com_db_seq_generator.sql.svn-base <span style='color:#111;'> 493B </span>","children":null,"spread":false},{"title":"data.test.com_db_seq_generator.sql.svn-base <span style='color:#111;'> 291B </span>","children":null,"spread":false},{"title":"sp_com_db_seq_generator.sql.svn-base <span style='color:#111;'> 3.13KB </span>","children":null,"spread":false}],"spread":true},{"title":"entries <span style='color:#111;'> 1.38KB </span>","children":null,"spread":false}],"spread":true},{"title":"readme.txt <span style='color:#111;'> 465B </span>","children":null,"spread":false}],"spread":true},{"title":".svn","children":[{"title":"all-wcprops <span style='color:#111;'> 84B </span>","children":null,"spread":false},{"title":"prop-base","children":null,"spread":false},{"title":"props","children":null,"spread":false},{"title":"tmp","children":[{"title":"prop-base","children":null,"spread":false},{"title":"props","children":null,"spread":false},{"title":"text-base","children":null,"spread":false}],"spread":true},{"title":"text-base","children":null,"spread":false},{"title":"entries <span style='color:#111;'> 219B </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}]

评论信息

  • zajsky :
    有点坑爹的样子 呵呵
    2014-05-03
  • pengshihai111 :
    真的很简单吗?咋感觉不简单呢
    2014-01-10
  • hesm :
    感觉不怎么好用,有点复杂哈
    2013-06-21
  • liang121711 :
    oracle的 , 可惜mssql 用不了
    2013-04-15
  • mm5z044 :
    简单易用的密码生成工具
    2012-12-18

免责申明

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