?? database.sql
字號:
INSERT INTO J2EEACCOUNT VALUES ('60', '26', 'SAVINGS', 10260.00);
INSERT INTO J2EEACCOUNT VALUES ('61', '27', 'SAVINGS', 10270.00);
INSERT INTO J2EEACCOUNT VALUES ('62', '28', 'SAVINGS', 10280.00);
INSERT INTO J2EEACCOUNT VALUES ('63', '29', 'SAVINGS', 10290.00);
INSERT INTO J2EEACCOUNT VALUES ('64', '30', 'SAVINGS', 10300.00);
INSERT INTO J2EEACCOUNT VALUES ('65', '31', 'SAVINGS', 10310.00);
INSERT INTO J2EEACCOUNT VALUES ('66', '32', 'SAVINGS', 10320.00);
INSERT INTO J2EEACCOUNT VALUES ('67', '33', 'SAVINGS', 10330.00);
INSERT INTO J2EEACCOUNT VALUES ('68', '34', 'SAVINGS', 10340.00);
INSERT INTO J2EEACCOUNT VALUES ('69', '5', 'VISA', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('70', '6', 'VISA', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('71', '7', 'VISA', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('72', '8', 'VISA', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('73', '9', 'VISA', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('74', '10', 'VISA', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('75', '11', 'VISA', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('76', '12', 'VISA', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('77', '13', 'VISA', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('78', '14', 'MASTERCARD', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('79', '15', 'MASTERCARD', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('80', '16', 'MASTERCARD', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('81', '17', 'MASTERCARD', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('82', '18', 'MASTERCARD', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('83', '19', 'MASTERCARD', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('84', '20', 'MASTERCARD', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('85', '21', 'MASTERCARD', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('86', '22', 'MASTERCARD', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('87', '23', 'MASTERCARD', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('88', '24', 'MASTERCARD', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('89', '25', 'MASTERCARD', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('90', '26', 'MASTERCARD', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('91', '27', 'MASTERCARD', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('92', '28', 'MASTERCARD', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('93', '29', 'MASTERCARD', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('94', '30', 'DISCOVER', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('95', '31', 'DISCOVER', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('96', '32', 'DISCOVER', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('97', '33', 'DISCOVER', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('98', '34', 'DISCOVER', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('99', '1', 'DISCOVER', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('100', '2', 'DISCOVER', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('101', '3', 'DISCOVER', 1000.00);
INSERT INTO J2EEACCOUNT VALUES ('102', '4', 'DISCOVER', 1000.00);
CREATE TABLE Account(
ACCTNUMBER VARCHAR(6) CONSTRAINT PK_Account PRIMARY KEY,
CUSTOMERID VARCHAR(6),
DESCRIPTION VARCHAR(20),
BALANCE DECIMAL(12,2),
CONSTRAINT FK_Account_1 FOREIGN KEY (CUSTOMERID) REFERENCES J2EECUSTOMER (CUSTOMERID));
DELETE FROM Account;
INSERT INTO Account VALUES ('1', '1', 'CHECKING', 1001.00);
INSERT INTO Account VALUES ('2', '2', 'CHECKING', 1002.00);
INSERT INTO Account VALUES ('3', '3', 'CHECKING', 1003.00);
INSERT INTO Account VALUES ('4', '4', 'CHECKING', 1004.00);
INSERT INTO Account VALUES ('5', '5', 'CHECKING', 1005.00);
INSERT INTO Account VALUES ('6', '6', 'CHECKING', 1006.00);
INSERT INTO Account VALUES ('7', '7', 'CHECKING', 1007.00);
INSERT INTO Account VALUES ('8', '8', 'CHECKING', 1008.00);
INSERT INTO Account VALUES ('9', '9', 'CHECKING', 1009.00);
INSERT INTO Account VALUES ('10', '10', 'CHECKING', 1010.00);
INSERT INTO Account VALUES ('11', '11', 'CHECKING', 1011.00);
INSERT INTO Account VALUES ('12', '12', 'CHECKING', 1012.00);
INSERT INTO Account VALUES ('13', '13', 'CHECKING', 1013.00);
INSERT INTO Account VALUES ('14', '14', 'CHECKING', 1014.00);
INSERT INTO Account VALUES ('15', '15', 'CHECKING', 1015.00);
INSERT INTO Account VALUES ('16', '16', 'CHECKING', 1016.00);
INSERT INTO Account VALUES ('17', '17', 'CHECKING', 1017.00);
INSERT INTO Account VALUES ('18', '18', 'CHECKING', 1018.00);
INSERT INTO Account VALUES ('19', '19', 'CHECKING', 1019.00);
INSERT INTO Account VALUES ('20', '20', 'CHECKING', 1020.00);
INSERT INTO Account VALUES ('21', '21', 'CHECKING', 1021.00);
INSERT INTO Account VALUES ('22', '22', 'CHECKING', 1022.00);
INSERT INTO Account VALUES ('23', '23', 'CHECKING', 1023.00);
INSERT INTO Account VALUES ('24', '24', 'CHECKING', 1024.00);
INSERT INTO Account VALUES ('25', '25', 'CHECKING', 1025.00);
INSERT INTO Account VALUES ('26', '26', 'CHECKING', 1026.00);
INSERT INTO Account VALUES ('27', '27', 'CHECKING', 1027.00);
INSERT INTO Account VALUES ('28', '28', 'CHECKING', 1028.00);
INSERT INTO Account VALUES ('29', '29', 'CHECKING', 1029.00);
INSERT INTO Account VALUES ('30', '30', 'CHECKING', 1030.00);
INSERT INTO Account VALUES ('31', '31', 'CHECKING', 1031.00);
INSERT INTO Account VALUES ('32', '32', 'CHECKING', 1032.00);
INSERT INTO Account VALUES ('33', '33', 'CHECKING', 1033.00);
INSERT INTO Account VALUES ('34', '34', 'CHECKING', 1034.00);
INSERT INTO Account VALUES ('35', '1', 'SAVINGS', 10010.00);
INSERT INTO Account VALUES ('36', '2', 'SAVINGS', 10020.00);
INSERT INTO Account VALUES ('37', '3', 'SAVINGS', 10030.00);
INSERT INTO Account VALUES ('38', '4', 'SAVINGS', 10040.00);
INSERT INTO Account VALUES ('39', '5', 'SAVINGS', 10050.00);
INSERT INTO Account VALUES ('40', '6', 'SAVINGS', 10060.00);
INSERT INTO Account VALUES ('41', '7', 'SAVINGS', 10070.00);
INSERT INTO Account VALUES ('42', '8', 'SAVINGS', 10080.00);
INSERT INTO Account VALUES ('43', '9', 'SAVINGS', 10090.00);
INSERT INTO Account VALUES ('44', '10', 'SAVINGS', 10100.00);
INSERT INTO Account VALUES ('45', '11', 'SAVINGS', 10110.00);
INSERT INTO Account VALUES ('46', '12', 'SAVINGS', 10120.00);
INSERT INTO Account VALUES ('47', '13', 'SAVINGS', 10130.00);
INSERT INTO Account VALUES ('48', '14', 'SAVINGS', 10140.00);
INSERT INTO Account VALUES ('49', '15', 'SAVINGS', 10150.00);
INSERT INTO Account VALUES ('50', '16', 'SAVINGS', 10160.00);
INSERT INTO Account VALUES ('51', '17', 'SAVINGS', 10170.00);
INSERT INTO Account VALUES ('52', '18', 'SAVINGS', 10180.00);
INSERT INTO Account VALUES ('53', '19', 'SAVINGS', 10190.00);
INSERT INTO Account VALUES ('54', '20', 'SAVINGS', 10200.00);
INSERT INTO Account VALUES ('55', '21', 'SAVINGS', 10210.00);
INSERT INTO Account VALUES ('56', '22', 'SAVINGS', 10220.00);
INSERT INTO Account VALUES ('57', '23', 'SAVINGS', 10230.00);
INSERT INTO Account VALUES ('58', '24', 'SAVINGS', 10240.00);
INSERT INTO Account VALUES ('59', '25', 'SAVINGS', 10250.00);
INSERT INTO Account VALUES ('60', '26', 'SAVINGS', 10260.00);
INSERT INTO Account VALUES ('61', '27', 'SAVINGS', 10270.00);
INSERT INTO Account VALUES ('62', '28', 'SAVINGS', 10280.00);
INSERT INTO Account VALUES ('63', '29', 'SAVINGS', 10290.00);
INSERT INTO Account VALUES ('64', '30', 'SAVINGS', 10300.00);
INSERT INTO Account VALUES ('65', '31', 'SAVINGS', 10310.00);
INSERT INTO Account VALUES ('66', '32', 'SAVINGS', 10320.00);
INSERT INTO Account VALUES ('67', '33', 'SAVINGS', 10330.00);
INSERT INTO Account VALUES ('68', '34', 'SAVINGS', 10340.00);
INSERT INTO Account VALUES ('69', '5', 'VISA', 1000.00);
INSERT INTO Account VALUES ('70', '6', 'VISA', 1000.00);
INSERT INTO Account VALUES ('71', '7', 'VISA', 1000.00);
INSERT INTO Account VALUES ('72', '8', 'VISA', 1000.00);
INSERT INTO Account VALUES ('73', '9', 'VISA', 1000.00);
INSERT INTO Account VALUES ('74', '10', 'VISA', 1000.00);
INSERT INTO Account VALUES ('75', '11', 'VISA', 1000.00);
INSERT INTO Account VALUES ('76', '12', 'VISA', 1000.00);
INSERT INTO Account VALUES ('77', '13', 'VISA', 1000.00);
INSERT INTO Account VALUES ('78', '14', 'MASTERCARD', 1000.00);
INSERT INTO Account VALUES ('79', '15', 'MASTERCARD', 1000.00);
INSERT INTO Account VALUES ('80', '16', 'MASTERCARD', 1000.00);
INSERT INTO Account VALUES ('81', '17', 'MASTERCARD', 1000.00);
INSERT INTO Account VALUES ('82', '18', 'MASTERCARD', 1000.00);
INSERT INTO Account VALUES ('83', '19', 'MASTERCARD', 1000.00);
INSERT INTO Account VALUES ('84', '20', 'MASTERCARD', 1000.00);
INSERT INTO Account VALUES ('85', '21', 'MASTERCARD', 1000.00);
INSERT INTO Account VALUES ('86', '22', 'MASTERCARD', 1000.00);
INSERT INTO Account VALUES ('87', '23', 'MASTERCARD', 1000.00);
INSERT INTO Account VALUES ('88', '24', 'MASTERCARD', 1000.00);
INSERT INTO Account VALUES ('89', '25', 'MASTERCARD', 1000.00);
INSERT INTO Account VALUES ('90', '26', 'MASTERCARD', 1000.00);
INSERT INTO Account VALUES ('91', '27', 'MASTERCARD', 1000.00);
INSERT INTO Account VALUES ('92', '28', 'MASTERCARD', 1000.00);
INSERT INTO Account VALUES ('93', '29', 'MASTERCARD', 1000.00);
INSERT INTO Account VALUES ('94', '30', 'DISCOVER', 1000.00);
INSERT INTO Account VALUES ('95', '31', 'DISCOVER', 1000.00);
INSERT INTO Account VALUES ('96', '32', 'DISCOVER', 1000.00);
INSERT INTO Account VALUES ('97', '33', 'DISCOVER', 1000.00);
INSERT INTO Account VALUES ('98', '34', 'DISCOVER', 1000.00);
INSERT INTO Account VALUES ('99', '1', 'DISCOVER', 1000.00);
INSERT INTO Account VALUES ('100', '2', 'DISCOVER', 1000.00);
INSERT INTO Account VALUES ('101', '3', 'DISCOVER', 1000.00);
INSERT INTO Account VALUES ('102', '4', 'DISCOVER', 1000.00);
SELECT COUNT(*) FROM J2EEACCOUNT;
SELECT COUNT(*) FROM ACCOUNT;
SELECT COUNT(*) FROM J2EECUSTOMER;
SELECT COUNT(*) FROM J2EEAPPUSER;
EXIT;?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -