mysql - Oracle和MySQL的代码形式区别-6ren

mysql - Oracle和MySQL的代码形式区别

转载作者：行者123 更新时间：2023-11-29 05:50:33

我正在通过 http://www.sqlines.com/online 将 Oracle 中的代码转换为 MYSQL。代码在 Oracle 中完全正确(创建的表和数据没有任何错误消息)，但是当我复制代码并粘贴到 MYSQL 时出现错误消息:

SQL Error [1005] [HY000]: Can't create table universityddl.faculty (errno: 150 "Foreign key constraint is incorrectly formed").

我不明白是什么原因，因为我是 DBMS 的新手。如果有人可以提供帮助，我将不胜感激。

Oracle 中的代码:

CREATE TABLE Faculty ( 
    FacNo         CHAR(11)      NOT NULL, 
    FacFirstName  VARCHAR(30)   NOT NULL, 
    FacLastName   VARCHAR(30)   NOT NULL, 
    FacCity       VARCHAR(30)   NOT NULL, 
    FacState      CHAR(2)       NOT NULL, 
    FacDept       CHAR(6)       NULL, 
    FacRank       CHAR(4)       NULL, 
    FacSalary     DECIMAL(10,2) NULL, 
    FacSupervisor CHAR(11)      NULL, 
    FacHireDate   DATE      NULL, 
    FacZipCode    CHAR(10)      NOT NULL, 
    CONSTRAINT FacultyPK PRIMARY KEY (FacNo),  
    CONSTRAINT SupervisorFK FOREIGN KEY (FacSupervisor) REFERENCES Faculty
);

CREATE TABLE Course ( 
    CourseNo      CHAR(6)       NOT NULL, 
    CrsDesc       VARCHAR(50)   NOT NULL, 
    CrsUnits      INTEGER       NULL, 
    CONSTRAINT CoursePK PRIMARY KEY (CourseNo) 
);

CREATE TABLE Offering ( 
    OfferNo       INTEGER       NOT NULL, 
    CourseNo      CHAR(6)       NOT NULL, 
    OffTerm       CHAR(6)       NOT NULL, 
    OffYear       INTEGER       NOT NULL, 
    OffLocation   VARCHAR(30)   NULL, 
    OffTime       VARCHAR(10)   NULL, 
    FacNo         CHAR(11)      NULL, 
    OffDays       CHAR(4)       NULL, 
    CONSTRAINT OfferingPK PRIMARY KEY (OfferNo), 
    CONSTRAINT CourseFK FOREIGN KEY (CourseNo) REFERENCES Course, 
    CONSTRAINT FacultyFK FOREIGN KEY (FacNo) REFERENCES Faculty
);

CREATE TABLE Student ( 
    StdNo         CHAR(11)      NOT NULL, 
    StdFirstName  VARCHAR(30)   NOT NULL, 
    StdLastName   VARCHAR(30)   NOT NULL, 
    StdCity       VARCHAR(30)   NOT NULL, 
    StdState      CHAR(2)       NOT NULL, 
    StdZip        CHAR(10)      NOT NULL, 
    StdMajor      CHAR(6)       NULL, 
    StdClass      CHAR(2)       NULL, 
    StdGPA        DECIMAL(3,2)  NULL, 
    CONSTRAINT StudentPk PRIMARY KEY (StdNo) 
);

CREATE TABLE Enrollment( 
    OfferNo       INTEGER       NOT NULL, 
    StdNo         CHAR(11)      NOT NULL, 
    EnrGrade      DECIMAL(3,2)  NULL, 
    CONSTRAINT EnrollmentPK PRIMARY KEY (OfferNo,StdNo), 
    CONSTRAINT OfferingFK FOREIGN KEY (OfferNo) REFERENCES Offering 
                      ON DELETE CASCADE,
    CONSTRAINT StudentFK FOREIGN KEY (StdNo) REFERENCES Student 
                      ON DELETE CASCADE
);

INSERT INTO Faculty VALUES ('543210987','VICTORIA','EMMANUEL','BOTHELL','WA','MS','PROF',120000.0,NULL,'15/Apr/1998','98011-2242');

INSERT INTO Faculty VALUES ('654321098','LEONARD','FIBON','SEATTLE','WA','MS','ASSC',70000.00,'543210987','1/May/1996','98121-0094');

INSERT INTO Faculty VALUES ('098765432','LEONARD','VINCE','SEATTLE','WA','MS','ASST',35000.00,'654321098','10/Apr/1997','98111-9921');

INSERT INTO Faculty VALUES ('765432109','NICKI','MACON','BELLEVUE','WA','FIN','PROF',65000.00,NULL,'11/Apr/1999','98015-9945');

INSERT INTO Faculty VALUES ('876543210','CRISTOPHER','COLAN','SEATTLE','WA','MS','ASST',40000.00,'654321098','1/Mar/2001','98114-1332');

INSERT INTO Faculty VALUES ('987654321','JULIA','MILLS','SEATTLE','WA','FIN','ASSC',75000.00,'765432109','15/Mar/2002','98114-9954');

INSERT INTO Course VALUES ('FIN300','FUNDAMENTALS OF FINANCE',4);

INSERT INTO Course VALUES ('FIN450','PRINCIPLES OF INVESTMENTS',4);

INSERT INTO Course VALUES ('FIN480','CORPORATE FINANCE',4);

INSERT INTO Course VALUES ('IS320','FUNDAMENTALS OF BUSINESS PROGRAMMING',4);

INSERT INTO Course VALUES ('IS460','SYSTEMS ANALYSIS',4);

INSERT INTO Course VALUES ('IS470','BUSINESS DATA COMMUNICATIONS',4);

INSERT INTO Course VALUES ('IS480','FUNDAMENTALS OF DATABASE MANAGEMENT',4);

INSERT INTO Offering VALUES (1111,'IS320','SUMMER',2010,'BLM302','10:30:00',NULL,'MW');

INSERT INTO Offering VALUES (1234,'IS320','FALL',2009,'BLM302','10:30:00','098765432','MW');

INSERT INTO Offering VALUES (2222,'IS460','SUMMER',2009,'BLM412','13:30:00',NULL,'TTH');

INSERT INTO Offering VALUES (3333,'IS320','SPRING',2010,'BLM214','8:30:00','098765432','MW');

INSERT INTO Offering VALUES (4321,'IS320','FALL',2009,'BLM214','15:30:00','098765432','TTH');

INSERT INTO Offering VALUES (4444,'IS320','WINTER',2010,'BLM302','15:30:00','543210987','TTH');

INSERT INTO Offering VALUES (5555,'FIN300','WINTER',2010,'BLM207','8:30:00','765432109','MW');

INSERT INTO Offering VALUES (5678,'IS480','WINTER',2010,'BLM302','10:30:00','987654321','MW');

INSERT INTO Offering VALUES (5679,'IS480','SPRING',2010,'BLM412','15:30:00','876543210','TTH');

INSERT INTO Offering VALUES (6666,'FIN450','WINTER',2010,'BLM212','10:30:00','987654321','TTH');

INSERT INTO Offering VALUES (7777,'FIN480','SPRING',2010,'BLM305','13:30:00','765432109','MW');

INSERT INTO Offering VALUES (8888,'IS320','SUMMER',2010,'BLM405','13:30:00','654321098','MW');

INSERT INTO Offering VALUES (9876,'IS460','SPRING',2010,'BLM307','13:30:00','654321098','TTH');

INSERT INTO Student VALUES ('123456789','HOMER','WELLS','SEATTLE','WA','98121-1111','IS','FR',3.00);

INSERT INTO Student VALUES ('124567890','BOB','NORBERT','BOTHELL','WA','98011-2121','FIN','JR',2.70);

INSERT INTO Student VALUES ('234567890','CANDY','KENDALL','TACOMA','WA','99042-3321','ACCT','JR',3.50);

INSERT INTO Student VALUES ('345678901','WALLY','KENDALL','SEATTLE','WA','98123-1141','IS','SR',2.80);

INSERT INTO Student VALUES ('456789012','JOE','ESTRADA','SEATTLE','WA','98121-2333','FIN','SR',3.20);

INSERT INTO Student VALUES ('567890123','MARIAH','DODGE','SEATTLE','WA','98114-0021','IS','JR',3.60);

INSERT INTO Student VALUES ('678901234','TESS','DODGE','REDMOND','WA','98116-2344','ACCT','SO',3.30);

INSERT INTO Student VALUES ('789012345','ROBERTO','MORALES','SEATTLE','WA','98121-2212','FIN','JR',2.50);

INSERT INTO Student VALUES ('876543210','CRISTOPHER','COLAN','SEATTLE','WA','98114-1332','IS','SR',4.00);

INSERT INTO Student VALUES ('890123456','LUKE','BRAZZI','SEATTLE','WA','98116-0021','IS','SR',2.20);

INSERT INTO Student VALUES ('901234567','WILLIAM','PILGRIM','BOTHELL','WA','98113-1885','IS','SO',3.80);

INSERT INTO Enrollment VALUES (1234,'123456789',3.30);

INSERT INTO Enrollment VALUES (1234,'234567890',3.50);

INSERT INTO Enrollment VALUES (1234,'345678901',3.20);

INSERT INTO Enrollment VALUES (1234,'456789012',3.10);

INSERT INTO Enrollment VALUES (1234,'567890123',3.80);

INSERT INTO Enrollment VALUES (1234,'678901234',3.40);

INSERT INTO Enrollment VALUES (4321,'123456789',3.50);

INSERT INTO Enrollment VALUES (4321,'124567890',3.20);

INSERT INTO Enrollment VALUES (4321,'789012345',3.50);

INSERT INTO Enrollment VALUES (4321,'876543210',3.10);

INSERT INTO Enrollment VALUES (4321,'890123456',3.40);

INSERT INTO Enrollment VALUES (4321,'901234567',3.10);

INSERT INTO Enrollment VALUES (5555,'123456789',3.20);

INSERT INTO Enrollment VALUES (5555,'124567890',2.70);

INSERT INTO Enrollment VALUES (5678,'123456789',3.20);

INSERT INTO Enrollment VALUES (5678,'234567890',2.80);

INSERT INTO Enrollment VALUES (5678,'345678901',3.30);

INSERT INTO Enrollment VALUES (5678,'456789012',3.40);

INSERT INTO Enrollment VALUES (5678,'567890123',2.60);

INSERT INTO Enrollment VALUES (5679,'123456789',2.00);

INSERT INTO Enrollment VALUES (5679,'124567890',3.70);

INSERT INTO Enrollment VALUES (5679,'678901234',3.30);

INSERT INTO Enrollment VALUES (5679,'789012345',3.80);

INSERT INTO Enrollment VALUES (5679,'890123456',2.90);

INSERT INTO Enrollment VALUES (5679,'901234567',3.10);

INSERT INTO Enrollment VALUES (6666,'234567890',3.10);

INSERT INTO Enrollment VALUES (6666,'567890123',3.60);

INSERT INTO Enrollment VALUES (7777,'876543210',3.40);

INSERT INTO Enrollment VALUES (7777,'890123456',3.70);

INSERT INTO Enrollment VALUES (7777,'901234567',3.40);

INSERT INTO Enrollment VALUES (9876,'124567890',3.50);

INSERT INTO Enrollment VALUES (9876,'234567890',3.20);

INSERT INTO Enrollment VALUES (9876,'345678901',3.20);

INSERT INTO Enrollment VALUES (9876,'456789012',3.40);

INSERT INTO Enrollment VALUES (9876,'567890123',2.60);

INSERT INTO Enrollment VALUES (9876,'678901234',3.30);

INSERT INTO Enrollment VALUES (9876,'901234567',4.00);

转换后的代码(到 MY SQL):

CREATE TABLE Faculty ( 
    FacNo         CHAR(11)      NOT NULL, 
    FacFirstName  VARCHAR(30)   NOT NULL, 
    FacLastName   VARCHAR(30)   NOT NULL, 
    FacCity       VARCHAR(30)   NOT NULL, 
    FacState      CHAR(2)       NOT NULL, 
    FacDept       CHAR(6)       NULL, 
    FacRank       CHAR(4)       NULL, 
    FacSalary     DECIMAL(10,2) NULL, 
    FacSupervisor CHAR(11)      NULL, 
    FacHireDate   DATE      NULL, 
    FacZipCode    CHAR(10)      NOT NULL, 
    CONSTRAINT FacultyPK PRIMARY KEY (FacNo),  
    CONSTRAINT SupervisorFK FOREIGN KEY (FacSupervisor) REFERENCES Faculty
);

CREATE TABLE Course ( 
    CourseNo      CHAR(6)       NOT NULL, 
    CrsDesc       VARCHAR(50)   NOT NULL, 
    CrsUnits      INTEGER       NULL, 
    CONSTRAINT CoursePK PRIMARY KEY (CourseNo) 
);

CREATE TABLE Offering ( 
    OfferNo       INTEGER       NOT NULL, 
    CourseNo      CHAR(6)       NOT NULL, 
    OffTerm       CHAR(6)       NOT NULL, 
    OffYear       INTEGER       NOT NULL, 
    OffLocation   VARCHAR(30)   NULL, 
    OffTime       VARCHAR(10)   NULL, 
    FacNo         CHAR(11)      NULL, 
    OffDays       CHAR(4)       NULL, 
    CONSTRAINT OfferingPK PRIMARY KEY (OfferNo), 
    CONSTRAINT CourseFK FOREIGN KEY (CourseNo) REFERENCES Course, 
    CONSTRAINT FacultyFK FOREIGN KEY (FacNo) REFERENCES Faculty
);

CREATE TABLE Student ( 
    StdNo         CHAR(11)      NOT NULL, 
    StdFirstName  VARCHAR(30)   NOT NULL, 
    StdLastName   VARCHAR(30)   NOT NULL, 
    StdCity       VARCHAR(30)   NOT NULL, 
    StdState      CHAR(2)       NOT NULL, 
    StdZip        CHAR(10)      NOT NULL, 
    StdMajor      CHAR(6)       NULL, 
    StdClass      CHAR(2)       NULL, 
    StdGPA        DECIMAL(3,2)  NULL, 
    CONSTRAINT StudentPk PRIMARY KEY (StdNo) 
);

CREATE TABLE Enrollment( 
    OfferNo       INTEGER       NOT NULL, 
    StdNo         CHAR(11)      NOT NULL, 
    EnrGrade      DECIMAL(3,2)  NULL, 
    CONSTRAINT EnrollmentPK PRIMARY KEY (OfferNo,StdNo), 
    CONSTRAINT OfferingFK FOREIGN KEY (OfferNo) REFERENCES Offering 
                      ON DELETE CASCADE,
    CONSTRAINT StudentFK FOREIGN KEY (StdNo) REFERENCES Student 
                      ON DELETE CASCADE
);

INSERT INTO Faculty VALUES ('543210987','VICTORIA','EMMANUEL','BOTHELL','WA','MS','PROF',120000.0,NULL,'15/Apr/1998','98011-2242');

INSERT INTO Faculty VALUES ('654321098','LEONARD','FIBON','SEATTLE','WA','MS','ASSC',70000.00,'543210987','1/May/1996','98121-0094');

INSERT INTO Faculty VALUES ('098765432','LEONARD','VINCE','SEATTLE','WA','MS','ASST',35000.00,'654321098','10/Apr/1997','98111-9921');

INSERT INTO Faculty VALUES ('765432109','NICKI','MACON','BELLEVUE','WA','FIN','PROF',65000.00,NULL,'11/Apr/1999','98015-9945');

INSERT INTO Faculty VALUES ('876543210','CRISTOPHER','COLAN','SEATTLE','WA','MS','ASST',40000.00,'654321098','1/Mar/2001','98114-1332');

INSERT INTO Faculty VALUES ('987654321','JULIA','MILLS','SEATTLE','WA','FIN','ASSC',75000.00,'765432109','15/Mar/2002','98114-9954');

INSERT INTO Course VALUES ('FIN300','FUNDAMENTALS OF FINANCE',4);

INSERT INTO Course VALUES ('FIN450','PRINCIPLES OF INVESTMENTS',4);

INSERT INTO Course VALUES ('FIN480','CORPORATE FINANCE',4);

INSERT INTO Course VALUES ('IS320','FUNDAMENTALS OF BUSINESS PROGRAMMING',4);

INSERT INTO Course VALUES ('IS460','SYSTEMS ANALYSIS',4);

INSERT INTO Course VALUES ('IS470','BUSINESS DATA COMMUNICATIONS',4);

INSERT INTO Course VALUES ('IS480','FUNDAMENTALS OF DATABASE MANAGEMENT',4);

INSERT INTO Offering VALUES (1111,'IS320','SUMMER',2010,'BLM302','10:30:00',NULL,'MW');

INSERT INTO Offering VALUES (1234,'IS320','FALL',2009,'BLM302','10:30:00','098765432','MW');

INSERT INTO Offering VALUES (2222,'IS460','SUMMER',2009,'BLM412','13:30:00',NULL,'TTH');

INSERT INTO Offering VALUES (3333,'IS320','SPRING',2010,'BLM214','8:30:00','098765432','MW');

INSERT INTO Offering VALUES (4321,'IS320','FALL',2009,'BLM214','15:30:00','098765432','TTH');

INSERT INTO Offering VALUES (4444,'IS320','WINTER',2010,'BLM302','15:30:00','543210987','TTH');

INSERT INTO Offering VALUES (5555,'FIN300','WINTER',2010,'BLM207','8:30:00','765432109','MW');

INSERT INTO Offering VALUES (5678,'IS480','WINTER',2010,'BLM302','10:30:00','987654321','MW');

INSERT INTO Offering VALUES (5679,'IS480','SPRING',2010,'BLM412','15:30:00','876543210','TTH');

INSERT INTO Offering VALUES (6666,'FIN450','WINTER',2010,'BLM212','10:30:00','987654321','TTH');

INSERT INTO Offering VALUES (7777,'FIN480','SPRING',2010,'BLM305','13:30:00','765432109','MW');

INSERT INTO Offering VALUES (8888,'IS320','SUMMER',2010,'BLM405','13:30:00','654321098','MW');

INSERT INTO Offering VALUES (9876,'IS460','SPRING',2010,'BLM307','13:30:00','654321098','TTH');

INSERT INTO Student VALUES ('123456789','HOMER','WELLS','SEATTLE','WA','98121-1111','IS','FR',3.00);

INSERT INTO Student VALUES ('124567890','BOB','NORBERT','BOTHELL','WA','98011-2121','FIN','JR',2.70);

INSERT INTO Student VALUES ('234567890','CANDY','KENDALL','TACOMA','WA','99042-3321','ACCT','JR',3.50);

INSERT INTO Student VALUES ('345678901','WALLY','KENDALL','SEATTLE','WA','98123-1141','IS','SR',2.80);

INSERT INTO Student VALUES ('456789012','JOE','ESTRADA','SEATTLE','WA','98121-2333','FIN','SR',3.20);

INSERT INTO Student VALUES ('567890123','MARIAH','DODGE','SEATTLE','WA','98114-0021','IS','JR',3.60);

INSERT INTO Student VALUES ('678901234','TESS','DODGE','REDMOND','WA','98116-2344','ACCT','SO',3.30);

INSERT INTO Student VALUES ('789012345','ROBERTO','MORALES','SEATTLE','WA','98121-2212','FIN','JR',2.50);

INSERT INTO Student VALUES ('876543210','CRISTOPHER','COLAN','SEATTLE','WA','98114-1332','IS','SR',4.00);

INSERT INTO Student VALUES ('890123456','LUKE','BRAZZI','SEATTLE','WA','98116-0021','IS','SR',2.20);

INSERT INTO Student VALUES ('901234567','WILLIAM','PILGRIM','BOTHELL','WA','98113-1885','IS','SO',3.80);

INSERT INTO Enrollment VALUES (1234,'123456789',3.30);

INSERT INTO Enrollment VALUES (1234,'234567890',3.50);

INSERT INTO Enrollment VALUES (1234,'345678901',3.20);

INSERT INTO Enrollment VALUES (1234,'456789012',3.10);

INSERT INTO Enrollment VALUES (1234,'567890123',3.80);

INSERT INTO Enrollment VALUES (1234,'678901234',3.40);

INSERT INTO Enrollment VALUES (4321,'123456789',3.50);

INSERT INTO Enrollment VALUES (4321,'124567890',3.20);

INSERT INTO Enrollment VALUES (4321,'789012345',3.50);

INSERT INTO Enrollment VALUES (4321,'876543210',3.10);

INSERT INTO Enrollment VALUES (4321,'890123456',3.40);

INSERT INTO Enrollment VALUES (4321,'901234567',3.10);

INSERT INTO Enrollment VALUES (5555,'123456789',3.20);

INSERT INTO Enrollment VALUES (5555,'124567890',2.70);

INSERT INTO Enrollment VALUES (5678,'123456789',3.20);

INSERT INTO Enrollment VALUES (5678,'234567890',2.80);

INSERT INTO Enrollment VALUES (5678,'345678901',3.30);

INSERT INTO Enrollment VALUES (5678,'456789012',3.40);

INSERT INTO Enrollment VALUES (5678,'567890123',2.60);

INSERT INTO Enrollment VALUES (5679,'123456789',2.00);

INSERT INTO Enrollment VALUES (5679,'124567890',3.70);

INSERT INTO Enrollment VALUES (5679,'678901234',3.30);

INSERT INTO Enrollment VALUES (5679,'789012345',3.80);

INSERT INTO Enrollment VALUES (5679,'890123456',2.90);

INSERT INTO Enrollment VALUES (5679,'901234567',3.10);

INSERT INTO Enrollment VALUES (6666,'234567890',3.10);

INSERT INTO Enrollment VALUES (6666,'567890123',3.60);

INSERT INTO Enrollment VALUES (7777,'876543210',3.40);

INSERT INTO Enrollment VALUES (7777,'890123456',3.70);

INSERT INTO Enrollment VALUES (7777,'901234567',3.40);

INSERT INTO Enrollment VALUES (9876,'124567890',3.50);

INSERT INTO Enrollment VALUES (9876,'234567890',3.20);

INSERT INTO Enrollment VALUES (9876,'345678901',3.20);

INSERT INTO Enrollment VALUES (9876,'456789012',3.40);

INSERT INTO Enrollment VALUES (9876,'567890123',2.60);

INSERT INTO Enrollment VALUES (9876,'678901234',3.30);

INSERT INTO Enrollment VALUES (9876,'901234567',4.00);

最佳答案

1) 正如 Nick 所回答的，外键语法需要修复。有 5 个外键声明需要更改:

CREATE TABLE Faculty ( 
    ...
    CONSTRAINT SupervisorFK FOREIGN KEY (FacSupervisor) REFERENCES Faculty(FacNo)
);

CREATE TABLE Offering ( 
    ...
    CONSTRAINT CourseFK FOREIGN KEY (CourseNo) REFERENCES Course(CourseNo),
    CONSTRAINT FacultyFK FOREIGN KEY (FacNo) REFERENCES Faculty(FacNo)
);

CREATE TABLE Enrollment( 
    ....
    CONSTRAINT OfferingFK FOREIGN KEY (OfferNo) REFERENCES Offering(OfferNo) 
        ON DELETE CASCADE,
    CONSTRAINT StudentFK FOREIGN KEY (StdNo) REFERENCES Student(StdNo) 
        ON DELETE CASCADE
);

CONSTRAINT CourseFK FOREIGN KEY (CourseNo) REFERENCES Course(CourseNo)

代替:

CONSTRAINT CourseFK FOREIGN KEY (CourseNo) REFERENCES Course

2) 在插入数据时，您应该预料到处理日期时会出现问题。您正在为数据类型 date(即 Faculty.FacHireDate)的列提供 MySQL 值，例如 '1/Mar/2001':它将不接受。日期的默认格式是 yyyy-mm-dd。

一种解决方案是在从 Oracle 提取数据时转换格式，方法是使用 TO_CHAR(FacHireDate, 'yyyy-mm-dd')，或者可能通过更改 NLS parameter NLS_DATE_FORMAT .否则，您可以使用 MySQL function STR_TO_DATE()将字符串翻译成日期:

INSERT INTO Faculty VALUES (
    '543210987',
    'VICTORIA',
    'EMMANUEL',
    'BOTHELL',
    'WA',
    'MS',
    'PROF',
    120000.0,
    NULL,
    STR_TO_DATE('15/Apr/1998', '%d/%b/%Y'),
    '98011-2242'
);

通过这些修复，脚本在 this MySQL DB Fiddle 中运行良好.

关于mysql - Oracle和MySQL的代码形式区别，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/54817992/

文章推荐：具有复合主键和触发器自动增量的 MySQL 死锁

文章推荐： iOS Core Data 乐观锁失败误报

文章推荐： ios - Obj-C - didSelectRowAtIndexPath 未触发？

实例讲解JQuery中this和$(this)区别
平时很少在jquery中用到this。查看代码时发现用到了，就调试出this的值，心想原来如此。还是挺有用的。这里总结一下this与$(this)的区别和使用。　　$(this)生成的是什么？
jsf - Java单例类与JSF应用程序范围的托管bean - 区别？
使用单例类和应用程序范围的托管 bean 来保存应用程序数据有区别吗？我需要查找某些 JNDI 资源，例如远程 bean 接口(interface)，因此我为自己编写了一个单例来缓存我的引用并且只允
Groovy - 闭包与方法 - 区别
如果您仔细查看包含的图片，您会注意到您可以使用 Eclipse IDE 重构 Groovy 代码并将方法转换为闭包，反之亦然。那么，闭包到底是什么，它与方法有什么不同呢？有人可以举一个使用闭包的好例子
打包和重新打包之间的 Vagrant 区别
vagrant box repackage有什么区别( docs ) 和 vagrant package ( docs )？我意识到 vagrant package仅适用于 VirtualBox 提
Java BigDecimal 区别
我想看看是否有人可以解释为什么以下代码适用于 valueOf 但不适用于其他代码。 import java.math.BigDecimal; public class Change { publ
closures - 闭包与匿名函数(区别？)
这个问题已经有答案了: 已关闭12 年前。 Possible Duplicates: What is Closures/Lambda in PHP or Javascript in layman te
docker - Docker和Chef工会，区别
This question already has answers here: Vagrant, Docker, Puppet, Chef (3个答案) 2年前关闭。 docker和chef有什么共同
c# - 调试和发布之间的C#区别
以下代码在95％的机器上产生相同的输出，但是在几台机器上却有所不同。在 Debug模式下，输出: Changing from New to Fin OK 但在 Release模式下: Changing
javascript - 创建一个对象和初始化一个对象 - 区别
////Creating Object var Obj; // init Object Obj= {}; 它们之间有什么区别两个？有没有可能把它变成一个单行？这样使用有什么好处吗？
java - 程序定时器和自动定时器 - 区别
我想找出定时器服务之间的区别。我应该使用哪个以及何时使用。我正在使用 Jboss 应用服务器。 1) java.ejb.Schedule。 @Schedule注解或配置自xml。 2) javax.e
将对象传递给它时方法签名之间的 C++ 区别
我发现在 C++ 中可以通过三种不同的方式将对象传递给函数。假设我的类(class)是这样的: class Test { int i; public: Test(int x);
java - 字符串到对象类型转换 - 区别
有什么区别。 public class Test { public static void main(String args[]) { String toBeCast = "c
MYSQL 自动增加一列或只有一个整数，区别？
如果我有一列，设置为主索引，设置为INT。如果我不将其设置为自动递增，而只是将唯一的随机整数插入其中，与自动递增相比，这是否会减慢 future 的查询速度？如果我在主索引和唯一索引为 INT 的
ios - NSDateFormatter 区别
这两种日期格式有什么区别。第一个给出实际时间，第二个给出时间购买添加时区偏移值。 NSDateFormatter * dateFormatter = [[NSDateFormatter alloc]
javascript - 调用函数与返回函数调用 - 区别？
如果有一个函数，请说foo: function foo() { console.log('bar'); } 那么在 JavaScript 中，从另一个函数调用一个函数有什么区别，如下所示: f
javascript - 使用更具体的模块导入有什么好处/区别？
关闭。这个问题是opinion-based 。目前不接受答案。想要改进这个问题吗？更新问题，以便 editing this post 可以用事实和引文来回答它。 . 已关闭 4 年前。 Improv
一些构造函数代码之间的 C++ 区别
代码是什么: class Time { private: int hours; int minutes; int seconds; pu
两个数组声明之间的 C++ 区别
我知道这是非常基本的，但有人介意解释一下这两个数组声明之间的区别吗: #include array myints; ...和: int myints[5]; ...以及为什么 myints.size
伪类和伪元素在特异性计算中的 CSS 区别？
我学会了如何根据 http://reference.sitepoint.com/css/specificity 计算 css 特异性但是，基于this reference，我不明白伪类(来自c)和伪元
何时使用括号之间的 Linux 区别
为什么在运行 2) 时会出现额外的空行？对我来说 1 就像 2。那么为什么 2) 中的额外行？ 1) export p1=$(cd $(dirname $0) && pwd) #

行者123

个人简介

我是一名优秀的程序员,十分优秀！

作者热门文章

滴滴打车优惠券免费领取

全站热门文章

首页

博学

6Ren·AI

商城

mysql - Oracle和MySQL的代码形式区别