null

最新推荐文章于 2024-10-31 09:45:35 发布
最新推荐文章于 2024-10-31 09:45:35 发布
阅读量138 收藏
点赞数
CC 4.0 BY-SA版权
分类专栏： core java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/iteye_10196/article/details/81993867

System.out.println(null);

 

-----------> compilation error

 

System.out.println((Object)null);

 

-----------> output null

 

 

NOT NULL 和NULL
01-20
如果既不指定NULL也不指定NOT NULL，列被认为指定了NULL 在 MySQL 中， 为一个 NOT NULL 字段设置 NULL 值 ， 它并不会出错， MySQL 会自动将 NULL值转化为该字段的默认值， 那怕是你在表定义时没有...
MySQL null与not null和null与空值的区别详解
12-14
MySQL数据库在设计表结构时，`NULL` 和 `NOT NULL` 是两个重要的字段约束，它们在数据存储和查询中有着显著的区别。理解这些差异对于优化数据库性能和编写正确的SQL语句至关重要。 首先，我们需要明确“空值”和...
Null类型
y935072878的博客
02-22 2273
Null类型 null类型是第二个只有一个值得数据类型，这个特殊的值时null。从逻辑角度看，null值表示一个空对象指针，而这也正是使用typeof操作符检测null值时会返回“object”的原因，如下面的例子： var car == null; alert(typeof car); //"object" 如果定义的变量在将来用于保存对象，那么最好将该变量初始化为null而不是其他值。...
使Flutter工程支持null safe
gaoyp的专栏
03-31 3372
支持null safe的flutter最低版本是2.0.0，对应的dart sdk是2.12.0。 1、 要使工程支持null safe,电脑上必须安装Flutter 2.0.0 及以上的版本。 2、 要将pubspec.yaml中的sdk大于2.12.0 此处设置的是dart的版本，如下： environment: sdk: ">=2.12.0 <3.0.0" 3、 如果电脑上的Flutter是 2.0.0的，但是pubspec中的sdk设置的值低于2.12.0，如下：
MySQL NULL与空值
xupeng1644的博客
11-14 2442
一 NULL和空值 NULL也就是在字段中存储NULL值，空值也就是字段中存储空字符(’’)。 1、占用空间区别 mysql> select length(NULL), length(''), length('1'); +--------------+------------+-------------+ | length(NULL) | length('') | length('1') ...
NULL 和nullptr
m0_62824048的博客
08-27 2259
可见，C++中 NULL实际是0，因为C++中不能把void*类型的指针隐式转换成其他类型的指针，所以为了结果空指针的表示问题，引入了0表示空指针。在阅读李同学（看不懂啊啊啊啊啊）的代码时，发现李同学空指针不是用NULL而是用nullptr，于是好奇啊好奇，有啥区别捏？nullptr的出现是为了解决NULL表示空指针在C++中具有二义性的问题。所以说NULL实际上是一个空指针，如果在C语言中写下以下代码，编译无问题。因为C语言中把空指针赋给int和char指针的时候，发生了。ULL代表空指针，但是在将。..
null=null不能作为关联条件
鸭梨的博客
06-29 1751
null=null不能作为关联条件,用在on后面 测试 SELECT NULL=NULL; SELECT NULL<>NULL; 从上面可以看出null=null和null<>null 均不成立. 那如何处理呢? on后的关联条件如果有null,可以用case when把null进行处理 ...
UnsupportedOperationException:null
qq_45592174的博客
10-31 1233
Java.lang.UnsupportedOperationException:nullat java.util.AbstractCollection. add(AbstractCollection.java:262)~[2:1.A.D141) 原因: Set set1 = SetUtils.emptySet(); set1.add(“string”); 像类似的empty()方法所创建的对象都是final不可变的，不能改变对象。一般只用于return的时候用作返回值。 所以，没有确定这个集合一定为空，或
oracle添加not null,oracle添加not null约束
weixin_42518930的博客
04-09 1288
在创建表时，为列添加not null约束，形式如下： column_name data_type [constraint constraint_name] not null 其中，constraint constraint_name 表示为约束指定名称。 也可以为已创建的表中添加not null约束，这时就需要使用alter table... modify语句，形式如下： alter table ...
java get null_get（）方法返回null，Java
weixin_29596051的博客
02-18 2575
通过gi.get()方法返回数据库中的数据，数据库中对应的列都有数值，不为空。其他几个也没问题都没返回值，但是第一个gi.getGoodsname()搞不懂为什么返回的是NULL，见附图。请指教下小...通过gi.get()方法返回数据库中的数据，数据库中对应的列都有数值，不为空。其他几个也没问题都没返回值，但是第一个gi.getGoodsname()搞不懂为什么返回的是NULL，见附图。请指教下...
MyBatis-Plus 更新对象时如何将字段值更新为 null
sg_knight的专栏
10-31 3147
如果你需要更复杂的更新逻辑，可以自定义 Mapper 方法，并在 XML 文件中编写自定义的 SQL 语句。@Mapper// 将 name 字段更新为 nullMyBatis-Plus 提供了多种方法来将字段值更新为null，你可以根据具体需求选择合适的方法。手动设置字段为null和使用是最常见和推荐的方法。全局配置策略虽然简单，但可能会影响其他更新操作，因此应谨慎使用。自定义方法则提供了更高的灵活性，适用于复杂的更新逻辑。
mysql数据库存储null_MySQL null值存储，null性能影响
weixin_35797963的博客
01-19 1978
MySQL null值的存储mysql>createtablemytest(t1varchar(10),t2varchar(10),t3varchar(10),t4varchar(10))engine=innodbcharset=latin1row_format=compact;QueryOK,0rowsaffected(0.08sec)mysql>...
NULL
12-09
NULL 博文链接：https://accplxmaccplxm.iteye.com/blog/1126652
详解MySQL中的NULL值
12-15
在MySQL数据库中，`NULL`值是一个特殊的存在，表示数据未知或者不存在。处理`NULL`值时，需要注意一些特定的规则和操作符。本篇文章将深入解析MySQL中的`NULL`值及其相关的查询方法。 首先，当尝试使用`= NULL`或`!...
STM32F103C8T6与HC-06、PC端及ROS串口通信测试
06-20
资源下载链接为： https://pan.quark.cn/s/502b0f9d0e26 在进行STM32F103C8T6与HC - 06蓝牙模块、PC端以及ROS（机器人操作系统）的串口通信测试时，我们编写了以下程序。 硬件连接 将STM32F103C8T6的USART1的TX（PA9）引脚与HC - 06的RX引脚相连，同时将USART1的RX（PA10）引脚与HC - 06的TX引脚相连，以实现两者之间的串口通信。 另外，通过串口转USB模块（如CH340等）将STM32F103C8T6与PC端连接起来，方便在PC端进行通信数据的发送和接收。 程序功能 初始化USART1，设置波特率为9600，用于与HC - 06通信。同时，初始化USART2（连接串口转USB模块），波特率同样设置为9600，用于与PC端通信。 在主循环中，STM32F103C8T6不断检测USART1和USART2是否有数据接收。当从USART1（HC - 06）接收到数据时，将数据暂存到一个缓冲区中，然后通过USART2发送给PC端。反之，当从USART2（PC端）接收到数据时，也暂存到缓冲区，再通过USART1发送给HC - 06。这样就实现了STM32F103C8T6作为中间节点，将HC - 06与PC端的数据进行转发。 硬件连接 HC - 06蓝牙模块通过串口与STM32F103C8T6连接，如上所述。 程序功能（蓝牙通信部分） HC - 06在默认状态下会自动进入配对模式，等待与手机或其他蓝牙设备配对。当配对成功后，它会将从蓝牙设备接收到的数据通过串口发送给STM32F103C8T6。同时，它也会将STM32F103C8T6发送过来的数据转发给已配对的蓝牙设备。在本测试程序中，主要关注其与STM32F103C8T6之间的串口通信功能，确保数据能够正确地在两者之间传输。 硬件连接 通过串口
【大数据技术】大数据特性、技术及应用领域综述：从数据采集到价值转化的全流程解析
06-20
内容概要：本文详细介绍了大数据的概念、特点、技术及应用领域。大数据指规模庞大且结构复杂的数据集合，具有体量大、多样性、时效性和可变性的特点。大数据技术涵盖数据采集、存储、处理、分析和可视化五个方面，分别对应不同技术和工具，如HDFS、NoSQL数据库、Hadoop、Spark等。大数据在金融、医疗、零售和互联网等多个领域有广泛应用，帮助各行业进行风险控制、疾病预测、销售趋势预测等工作。; 适合人群：对大数据技术感兴趣的初学者、希望了解大数据基本概念及其应用的人士。; 使用场景及目标：①了解大数据的基本定义和特征；②掌握大数据技术栈，包括数据采集、存储、处理、分析和可视化；③探索大数据在不同行业的具体应用场景。; 其他说明：大数据技术的发展正深刻影响着各个行业，学习和掌握相关技能不仅可以提升个人能力，还能为企业创造更多价值。建议读者结合实际案例深入理解大数据的应用，同时关注新技术的发展动态。
【单片机设计】单片机设计 基于两个单片机串行通信的电子密码锁的详细项目实例（含模型描述及示例代码）
06-20
内容概要：本文详细介绍了一个基于两个单片机串行通信的电子密码锁项目。项目背景指出随着信息技术的发展，电子密码锁因其高可靠性、低成本等优势成为主流选择。项目采用主控和辅助两个单片机分别负责不同功能模块，并通过串行通信（如UART协议）实现数据交互。主控单片机处理密码输入验证、用户界面显示等，辅助单片机负责锁控制。系统还涉及多级安全防护、低功耗设计、友好的用户界面等特性。项目挑战包括确保通信稳定、提升密码验证安全性、优化电源管理和用户交互设计等。项目创新点在于双单片机协同工作、串行通信协议优化、多级安全防护以及低功耗设计。; 适合人群：对嵌入式系统开发有一定了解，特别是对单片机编程、串行通信协议、密码锁设计感兴趣的工程师或学生。; 使用场景及目标：①适用于家庭安防、商业办公、银行金融、智能酒店、医疗行业等需要高安全性的场所；②帮助开发者掌握双单片机协同工作的原理，提高系统的稳定性和安全性；③通过实际项目加深对串行通信协议的理解，掌握密码锁系统的软硬件设计方法。; 阅读建议：建议读者结合实际硬件设备进行实践操作，重点理解串行通信协议的设计与实现，同时关注密码验证的安全性设计和电源管理优化。此外，可以通过提供的代码示例加深对各功能模块的理解，并尝试修改和优化代码以适应不同的应用场景。
课程设计-jsp1070分类信息发布系统springmvc+mysql-qkrp.zip
最新发布
06-20
课程设计 源代码配套报告数据库教程
卡尔曼-MPC控制方案的Koopman识别算法的Matlab源代码;.rar
06-20
1.版本：matlab2014/2019a/2024a 2.附赠案例数据可直接运行。 3.代码特点：参数化编程、参数可方便更改、代码编程思路清晰、注释明细。 4.适用对象：计算机，电子信息工程、数学等专业的大学生课程设计、期末大作业和毕业设计。
--DATE:2023-10-27 --CONTENT:KMPLM-6979 新增与优化变更配置项管理和菜单入口 by 薛启宽 DECLARE VN INT; BEGIN SELECT COUNT(1) INTO VN FROM plm_cls_define WHERE CCLSID = 754; IF VN = 0 THEN insert into plm_cls_define (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE) values (754, 750, 'EbomChangeIssue', null, null, 'ECI', 'EBOM问题报告', 'PLM_EbomChangeIssue', '5,7,70,251,750,754', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 1, 1, 1, null, 999, null, null, ',7900,', null, 1); END IF; SELECT COUNT(1) INTO VN FROM plm_cls_define WHERE CCLSID = 755; IF VN = 0 THEN insert into plm_cls_define (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE) values (755, 750, 'PbomChangeIssue', null, null, 'PCI', 'PBOM问题报告', 'PLM_PbomChangeIssue', '5,7,70,251,750,755', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 2, 1, 1, null, 999, null, null, ',7900,', null, 1); END IF; SELECT COUNT(1) INTO VN FROM plm_cls_define WHERE CCLSID = 756; IF VN = 0 THEN insert into plm_cls_define (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE) values (756, 751, 'EbomChangeRequest', null, null, 'ECR', 'EBOM变更申请', 'PLM_EbomChangeRequest', '5,7,70,251,751,756', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 1, 1, 1, null, 999, null, null, ',7900,', null, 1); END IF; SELECT COUNT(1) INTO VN FROM plm_cls_define WHERE CCLSID = 757; IF VN = 0 THEN insert into plm_cls_define (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE) values (757, 751, 'PbomChangeRequest', null, null, 'PCR', 'PBOM变更申请', 'PLM_PbomChangeRequest', '5,7,70,251,751,757', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 2, 1, 1, null, 999, null, null, ',7900,', null, 1); END IF; SELECT COUNT(1) INTO VN FROM plm_cls_define WHERE CCLSID = 758; IF VN = 0 THEN insert into plm_cls_define (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE) values (758, 752, 'EbomChangeOrder', null, null, 'ECO', 'EBOM变更指令', 'PLM_EbomChangeOrder', '5,7,70,251,752,758', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 1, 1, 1, null, 999, null, null, ',7900,', null, 1); END IF; SELECT COUNT(1) INTO VN FROM plm_cls_define WHERE CCLSID = 759; IF VN = 0 THEN insert into plm_cls_define (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE) values (759, 752, 'PbomChangeOrder', null, null, 'PCO', 'PBOM变更指令', 'PLM_PbomChangeOrder', '5,7,70,251,752,759', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 2, 1, 1, null, 999, null, null, ',7900,', null, 1); END IF; SELECT COUNT(1) INTO VN FROM plm_cls_define WHERE CCLSID = 760; IF VN = 0 THEN insert into plm_cls_define (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE) values (760, 753, 'EbomChangeActivity', null, null, 'ECA', 'EBOM变更活动', 'PLM_EbomChangeActivity', '5,7,70,251,753,760', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 3, 1, 1, null, 999, null, null, ',7900,', null, 1); END IF; SELECT COUNT(1) INTO VN FROM plm_cls_define WHERE CCLSID = 761; IF VN = 0 THEN insert into plm_cls_define (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE) values (761, 753, 'PbomChangeActivity', null, null, 'PCA', 'PBOM变更活动', 'PLM_PbomChangeActivity', '5,7,70,251,753,761', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 2, 1, 1, null, 999, null, null, ',7900,', null, 1); END IF; SELECT COUNT(1) INTO VN FROM plm_cls_define_edit WHERE CCLSID = 754; IF VN = 0 THEN insert into plm_cls_define_edit (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE) values (754, 750, 'EbomChangeIssue', null, null, 'ECI', 'EBOM问题报告', 'PLM_EbomChangeIssue', '5,7,70,251,750,754', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 1, 1, 1, null, 999, null, null, ',7900,', null, 1); END IF; SELECT COUNT(1) INTO VN FROM plm_cls_define_edit WHERE CCLSID = 755; IF VN = 0 THEN insert into plm_cls_define_edit (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE) values (755, 750, 'PbomChangeIssue', null, null, 'PCI', 'PBOM问题报告', 'PLM_PbomChangeIssue', '5,7,70,251,750,755', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 2, 1, 1, null, 999, null, null, ',7900,', null, 1); END IF; SELECT COUNT(1) INTO VN FROM plm_cls_define_edit WHERE CCLSID = 756; IF VN = 0 THEN insert into plm_cls_define_edit (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE) values (756, 751, 'EbomChangeRequest', null, null, 'ECR', 'EBOM变更申请', 'PLM_EbomChangeRequest', '5,7,70,251,751,756', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 1, 1, 1, null, 999, null, null, ',7900,', null, 1); END IF; SELECT COUNT(1) INTO VN FROM plm_cls_define_edit WHERE CCLSID = 757; IF VN = 0 THEN insert into plm_cls_define_edit (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE) values (757, 751, 'PbomChangeRequest', null, null, 'PCR', 'PBOM变更申请', 'PLM_PbomChangeRequest', '5,7,70,251,751,757', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 2, 1, 1, null, 999, null, null, ',7900,', null, 1); END IF; SELECT COUNT(1) INTO VN FROM plm_cls_define_edit WHERE CCLSID = 758; IF VN = 0 THEN insert into plm_cls_define_edit (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE) values (758, 752, 'EbomChangeOrder', null, null, 'ECO', 'EBOM变更指令', 'PLM_EbomChangeOrder', '5,7,70,251,752,758', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 1, 1, 1, null, 999, null, null, ',7900,', null, 1); END IF; SELECT COUNT(1) INTO VN FROM plm_cls_define_edit WHERE CCLSID = 759; IF VN = 0 THEN insert into plm_cls_define_edit (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE) values (759, 752, 'PbomChangeOrder', null, null, 'PCO', 'PBOM变更指令', 'PLM_PbomChangeOrder', '5,7,70,251,752,759', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 2, 1, 1, null, 999, null, null, ',7900,', null, 1); END IF; SELECT COUNT(1) INTO VN FROM plm_cls_define_edit WHERE CCLSID = 760; IF VN = 0 THEN insert into plm_cls_define_edit (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE) values (760, 753, 'EbomChangeActivity', null, null, 'ECA', 'EBOM变更活动', 'PLM_EbomChangeActivity', '5,7,70,251,753,760', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 3, 1, 1, null, 999, null, null, ',7900,', null, 1); END IF; SELECT COUNT(1) INTO VN FROM plm_cls_define_edit WHERE CCLSID = 761; IF VN = 0 THEN insert into plm_cls_define_edit (CCLSID, CPCLSID, CCLSNAME, CCLSEXECNAME, CCLSSHORTHANDNAME, CCLSSIGN, CNAME, CTABLENAME, CPATH, CSTATE, CLEVEL, CREMARK, CICONID, CISSUBSIDIARY, CISHARD, CCANINSTANTIATION, CENCODEUNIQUE, CVERSION, CMASTERCLSID, CREVISIONCLSID, CREVISION, CRESERVE, CLIFEMODELID, CVERRULEID, CIFTIMEVALID, CIFBATCHVALID, CIFSEQVALID, CDOMAINID, CISLEAFCLS, CCODEPROPID, CUNIQUERANGE, CCODERULEID, CHASCOPY, CPARTVIEWID, CBOMUSAGECLSID, CUSEPARTVIEW, CTYPE, CDISPLAYED, CUI_DISPLAYED, CIS_SUPPORT_WORKFLOW, CIS_SUPPORT_PERMISSION, CIS_SUPPORT_ASSOCIATION, CIS_SUPPORT_GLOBAL_QUERY, CSCHEMEID, CAPPLICATION_TYPE, CSUPPORT_VALIDITY, CINDEX, CIS_DISPLAYED_IN_FOLDER, CIS_SUPPORT_ATTACHMENT, CIS_SUPPORT_NEWVERSION, CATTACHNUM, CVEREXCEPT, CVERPREFIX, CSERVICE, CREVISIONNUM, CREVISIONRULE) values (761, 753, 'PbomChangeActivity', null, null, 'PCA', 'PBOM变更活动', 'PLM_PbomChangeActivity', '5,7,70,251,753,761', 1, null, null, null, 0, 1, 1, null, 0, null, null, null, 1, null, null, null, null, null, 0, 0, null, null, null, 0, 0, 0, 1, null, null, null, null, null, null, null, null, 0, null, 2, 1, 1, null, 999, null, null, ',7900,', null, 1); END IF; COMMIT; END; /
05-17
### PLM系统中EBOM和PBOM变更管理的表定义及数据初始化 在产品生命周期管理（PLM）系统中，工程物料清单（EBOM, Engineering Bill of Materials）和工艺物料清单（PBOM, Process Bill Of Materials）是核心组成部分。为了支持EBOM和PBOM的变更管理，需要设计一系列数据库表来跟踪变更请求、审批状态、变更历史以及其他相关活动。以下是基于SQL脚本的设计方案。 --- #### 数据库表设计 ##### 1. 变更申请表 (`Change_Request`) 该表用于记录所有的变更请求信息。 ```sql CREATE TABLE Change_Request ( Request_ID INT PRIMARY KEY AUTO_INCREMENT, Title VARCHAR(255) NOT NULL, Description TEXT, Created_By INT NOT NULL REFERENCES User(User_ID), Created_Date DATETIME DEFAULT CURRENT_TIMESTAMP, Status ENUM('Draft', 'Submitted', 'Approved', 'Rejected') DEFAULT 'Draft', BOM_Type ENUM('EBOM', 'PBOM') NOT NULL -- 表明变更涉及 EBOM 或 PBOM ); ``` ##### 2. 变更指令表 (`Change_Order`) 该表用于记录批准后的变更指令及其执行情况。 ```sql CREATE TABLE Change_Order ( Order_ID INT PRIMARY KEY AUTO_INCREMENT, Request_ID INT UNIQUE NOT NULL REFERENCES Change_Request(Request_ID), Issued_By INT NOT NULL REFERENCES User(User_ID), Issued_Date DATETIME DEFAULT CURRENT_TIMESTAMP, Execution_Status ENUM('Pending', 'In Progress', 'Completed') DEFAULT 'Pending' ); ``` ##### 3. 变更活动日志表 (`Change_Activity_Log`) 该表用于记录每次变更的具体操作细节。 ```sql CREATE TABLE Change_Activity_Log ( Log_ID INT PRIMARY KEY AUTO_INCREMENT, Order_ID INT NOT NULL REFERENCES Change_Order(Order_ID), Activity_Description TEXT NOT NULL, Performed_By INT NOT NULL REFERENCES User(User_ID), Perform_Date DATETIME DEFAULT CURRENT_TIMESTAMP ); ``` ##### 4. 物料版本控制表 (`Part_Version_Control`) 该表用于追踪物料的不同版本及其与变更的关系。 ```sql CREATE TABLE Part_Version_Control ( Version_ID INT PRIMARY KEY AUTO_INCREMENT, Part_Number VARCHAR(50) NOT NULL, Version_Number DECIMAL(5, 2) NOT NULL, Effective_Date DATE NOT NULL, Obsolete_Date DATE, Associated_Change_Order INT REFERENCES Change_Order(Order_ID), UNIQUE (Part_Number, Version_Number) ); ``` ##### 5. BOM结构表 (`BOM_Structure`) 该表用于存储当前有效的EBOM/PBOM结构。 ```sql CREATE TABLE BOM_Structure ( Structure_ID INT PRIMARY KEY AUTO_INCREMENT, Parent_Part_Number VARCHAR(50) NOT NULL, Child_Part_Number VARCHAR(50) NOT NULL, Quantity_Per_Parent DECIMAL(10, 3) NOT NULL, BOM_Type ENUM('EBOM', 'PBOM') NOT NULL, Effective_Version INT REFERENCES Part_Version_Control(Version_ID), FOREIGN KEY (Parent_Part_Number) REFERENCES Parts(Part_Number), FOREIGN KEY (Child_Part_Number) REFERENCES Parts(Part_Number) ); ``` ##### 6. 零件基础信息表 (`Parts`) 该表用于存储零件的基础属性。 ```sql CREATE TABLE Parts ( Part_Number VARCHAR(50) PRIMARY KEY, Name VARCHAR(255) NOT NULL, Category VARCHAR(100), Manufacturer VARCHAR(100), Specification TEXT ); ``` --- #### 初始数据加载 以下是一些示例SQL语句，展示如何向上述表格中插入初始数据。 ##### 插入零件基本信息 ```sql INSERT INTO Parts (Part_Number, Name, Category, Manufacturer, Specification) VALUES ('PART001', 'Engine Block', 'Mechanical', 'ABC Corp.', 'High-performance engine block'); ``` ##### 创建一个新的变更请求 ```sql INSERT INTO Change_Request (Title, Description, Created_By, BOM_Type) VALUES ('Update Engine Specifications', 'Modify the specifications of PART001 to support higher RPMs', 101, 'EBOM'); ``` ##### 将变更请求转化为变更指令 ```sql INSERT INTO Change_Order (Request_ID, Issued_By) SELECT Request_ID, 102 FROM Change_Request WHERE Request_ID = 1 AND Status = 'Approved'; ``` ##### 记录变更活动 ```sql INSERT INTO Change_Activity_Log (Order_ID, Activity_Description, Performed_By) VALUES (1, 'Updated specification field for PART001', 103); ``` ##### 更新物料版本 ```sql INSERT INTO Part_Version_Control (Part_Number, Version_Number, Effective_Date, Associated_Change_Order) VALUES ('PART001', 2.0, '2023-09-01', 1); ``` ##### 修改BOM结构 ```sql UPDATE BOM_Structure SET Effective_Version = (SELECT Version_ID FROM Part_Version_Control WHERE Part_Number = 'PART001' AND Version_Number = 2.0) WHERE Child_Part_Number = 'PART001'; ``` --- ### 总结 通过上述表结构设计和SQL脚本，可以有效地管理和追溯EBOM和PBOM的变更过程。这种设计方案不仅涵盖了变更申请、审批、执行的历史记录，还提供了详细的物料版本控制能力[^1]。 ---
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值