📄 database.sql
字号:
DROP TABLE ACCOUNT;
DROP TABLE J2EEACCOUNT;
DROP TABLE J2EECUSTOMER;
DROP TABLE J2EEAPPUSER;
CREATE TABLE J2EEAPPUSER(
USERNAME VARCHAR(20) CONSTRAINT PK_J2EEAPPUSER PRIMARY KEY,
PASSWORD VARCHAR(20),
USERID VARCHAR(6));
DELETE FROM J2EEAPPUSER;
INSERT INTO J2EEAPPUSER VALUES ('Alex', 'password', '1');
INSERT INTO J2EEAPPUSER VALUES ('Anita', 'password', '2');
INSERT INTO J2EEAPPUSER VALUES ('Bill', 'password', '3');
INSERT INTO J2EEAPPUSER VALUES ('Boris', 'password', '4');
INSERT INTO J2EEAPPUSER VALUES ('Bryan', 'password', '5');
INSERT INTO J2EEAPPUSER VALUES ('Chris', 'password', '6');
INSERT INTO J2EEAPPUSER VALUES ('Kenny', 'password', '7');
INSERT INTO J2EEAPPUSER VALUES ('Dominic', 'password', '8');
INSERT INTO J2EEAPPUSER VALUES ('Geronimo', 'password', '9');
INSERT INTO J2EEAPPUSER VALUES ('Glynn', 'password', '10');
INSERT INTO J2EEAPPUSER VALUES ('Gonzales', 'password', '11');
INSERT INTO J2EEAPPUSER VALUES ('Gordon', 'password', '12');
INSERT INTO J2EEAPPUSER VALUES ('Guido', 'password', '13');
INSERT INTO J2EEAPPUSER VALUES ('Gwen', 'password', '14');
INSERT INTO J2EEAPPUSER VALUES ('Hans', 'password', '15');
INSERT INTO J2EEAPPUSER VALUES ('Hugo', 'password', '16');
INSERT INTO J2EEAPPUSER VALUES ('Jeromy', 'password', '17');
INSERT INTO J2EEAPPUSER VALUES ('Jim', 'password', '18');
INSERT INTO J2EEAPPUSER VALUES ('Jo', 'password', '19');
INSERT INTO J2EEAPPUSER VALUES ('Juan', 'password', '20');
INSERT INTO J2EEAPPUSER VALUES ('Karin', 'password', '21');
INSERT INTO J2EEAPPUSER VALUES ('KimLee', 'password', '22');
INSERT INTO J2EEAPPUSER VALUES ('Maria', 'password', '23');
INSERT INTO J2EEAPPUSER VALUES ('MaryAnn', 'password', '24');
INSERT INTO J2EEAPPUSER VALUES ('Natasha', 'password', '25');
INSERT INTO J2EEAPPUSER VALUES ('Pat', 'password', '26');
INSERT INTO J2EEAPPUSER VALUES ('Patricia', 'password', '27');
INSERT INTO J2EEAPPUSER VALUES ('Rashid', 'password', '28');
INSERT INTO J2EEAPPUSER VALUES ('Scottie', 'password', '29');
INSERT INTO J2EEAPPUSER VALUES ('Sinha', 'password', '30');
INSERT INTO J2EEAPPUSER VALUES ('Sofia', 'password', '31');
INSERT INTO J2EEAPPUSER VALUES ('Cartman', 'password', '32');
INSERT INTO J2EEAPPUSER VALUES ('Yolonda', 'password', '33');
INSERT INTO J2EEAPPUSER VALUES ('Al', 'password', '34');
CREATE TABLE J2EECUSTOMER(
CUSTOMERID VARCHAR(6) CONSTRAINT PK_J2EECUSTOMER PRIMARY KEY,
FIRSTNAME VARCHAR(20),
LASTNAME VARCHAR(20),
ADDRESS VARCHAR(50),
PHONE VARCHAR(20));
DELETE FROM J2EECUSTOMER;
INSERT INTO J2EECUSTOMER VALUES ('1', 'Alex', 'TheGreat', 'Calle del Mar 9, Barcelona, Spain', '3045690907');
INSERT INTO J2EECUSTOMER VALUES ('2', 'Anita', 'Valley', 'Smorgebroed 23, Malmo, Sweden', '1236754437');
INSERT INTO J2EECUSTOMER VALUES ('3', 'Bill', 'PearlyGates', '66 Sunset Strip, San Francisco, CA', '5637878587');
INSERT INTO J2EECUSTOMER VALUES ('4', 'Boris', 'Karloff', '78 Gorky Way, Moscow, Russia', '5638728987');
INSERT INTO J2EECUSTOMER VALUES ('5', 'Bryan', 'Boytano', '222 Canary Rd, Calgary, Alberta', '2234533327');
INSERT INTO J2EECUSTOMER VALUES ('6', 'Chris', 'Would', '10 Mill St, London, UK', '3458826267');
INSERT INTO J2EECUSTOMER VALUES ('7', 'Kenny', 'James', '20 Ripper Lane, SouthPark, SD', '5552321199');
INSERT INTO J2EECUSTOMER VALUES ('8', 'Dominic', 'Domino', 'Via Sarzana 78B, Genoa, Italy', '5556677777');
INSERT INTO J2EECUSTOMER VALUES ('9', 'Geronimo', 'Smith', '29 Mountain Way, Denver, CO', '3438867677');
INSERT INTO J2EECUSTOMER VALUES ('10', 'Glynn', 'Brown', '975 Valencia St., San Francisco, CA', '2938439927');
INSERT INTO J2EECUSTOMER VALUES ('11', 'ChiChi', 'Gonzales', '12 Punto Rosso, Sao Paolo, Brasil', '5568907897');
INSERT INTO J2EECUSTOMER VALUES ('12', 'Gordon', 'Somerville', '1800 Harrison St., Oakland, CA', '4338546387');
INSERT INTO J2EECUSTOMER VALUES ('13', 'Guido', 'Sarduchi', 'Via Roma 45, Milano, Italy', '1234567897');
INSERT INTO J2EECUSTOMER VALUES ('14', 'Gwen', 'Wonderful', '234 English Way, Wales, UK', '7890056787');
INSERT INTO J2EECUSTOMER VALUES ('15', 'Hans', 'Brinker', 'Schneck Str. 10A, Munich, Germany', '1236754437');
INSERT INTO J2EECUSTOMER VALUES ('16', 'Hugo', 'Auchtnaught', 'Polish Strasse 39A, Munich, Germany', '3435523237');
INSERT INTO J2EECUSTOMER VALUES ('17', 'Jeromy', 'Williams', '898 Harrison St., Oakland, CA', '1236699997');
INSERT INTO J2EECUSTOMER VALUES ('18', 'Jim', 'Cricket', '28 Barbary Lane, Apt. 3, San Francisco, CA', '4453443887');
INSERT INTO J2EECUSTOMER VALUES ('19', 'Jo', 'Jo', '77 Sunset Strip, Los Angeles, Calif.', '9086655557');
INSERT INTO J2EECUSTOMER VALUES ('20', 'Juan', 'Gonzales', 'Calle de Aqua 55, Tasco, Mexico', '8903319197');
INSERT INTO J2EECUSTOMER VALUES ('21', 'Karin', 'Jaurez', '28 Barbary Lane, Apt. 5, San Francisco, CA', '6443311317');
INSERT INTO J2EECUSTOMER VALUES ('22', 'KimLee', 'Lim', '35 Green St., San Francisco, CA', '9087744557');
INSERT INTO J2EECUSTOMER VALUES ('23', 'Maria', 'Muledeer', '95 Fell Street, San Francisco, CA', '7893467787');
INSERT INTO J2EECUSTOMER VALUES ('24', 'MaryAnn', 'Bostich', '4578 19th St., Oakland, CA', '4568823417');
INSERT INTO J2EECUSTOMER VALUES ('25', 'Natasha', 'Kinski', '12 Greenwich St., New York, NY', '6783398987');
INSERT INTO J2EECUSTOMER VALUES ('26', 'Pat', 'Patterson', '77 Sunset Strip, Los Angeles, CA', '9086655557');
INSERT INTO J2EECUSTOMER VALUES ('27', 'Patricia', 'Shebold', 'Vatican, Vatican City, Italy', '4332840207');
INSERT INTO J2EECUSTOMER VALUES ('28', 'Rashid', 'Noreiga', '27 Lombardi Way, Boston, MA', '9098812347');
INSERT INTO J2EECUSTOMER VALUES ('29', 'Scottie', 'Beammeup', 'House at Pooh Corner, Emerald City', '5349939427');
INSERT INTO J2EECUSTOMER VALUES ('30', 'Sinha', 'Off', '456 Oceanview, Surabaya, Indonesia', '8985567897');
INSERT INTO J2EECUSTOMER VALUES ('31', 'Sofia', 'Salvio', 'Via La Spezia 33A, Venice, Italy', '2984456567');
INSERT INTO J2EECUSTOMER VALUES ('32', 'Cartman', 'Jones', '25 Wall Street, New York, NY', '6666666666');
INSERT INTO J2EECUSTOMER VALUES ('33', 'Yolonda', 'Jones', '1600 Pennsylvania Ave., Washington, D.C.', '4323544007');
INSERT INTO J2EECUSTOMER VALUES ('34', 'Al', 'Davidson', 'Route 66, Chicago, IL', '3021234567');
CREATE TABLE J2EEACCOUNT(
ACCTNUMBER VARCHAR(6) CONSTRAINT PK_J2EEACCOUNT PRIMARY KEY,
CUSTOMERID VARCHAR(6),
DESCRIPTION VARCHAR(20),
BALANCE DECIMAL(12,2),
CONSTRAINT FK_J2EEACCOUNT_1 FOREIGN KEY (CUSTOMERID) REFERENCES J2EECUSTOMER (CUSTOMERID));
DELETE FROM J2EEACCOUNT;
INSERT INTO J2EEACCOUNT VALUES ('1', '1', 'CHECKING', 1001.00);
INSERT INTO J2EEACCOUNT VALUES ('2', '2', 'CHECKING', 1002.00);
INSERT INTO J2EEACCOUNT VALUES ('3', '3', 'CHECKING', 1003.00);
INSERT INTO J2EEACCOUNT VALUES ('4', '4', 'CHECKING', 1004.00);
INSERT INTO J2EEACCOUNT VALUES ('5', '5', 'CHECKING', 1005.00);
INSERT INTO J2EEACCOUNT VALUES ('6', '6', 'CHECKING', 1006.00);
INSERT INTO J2EEACCOUNT VALUES ('7', '7', 'CHECKING', 1007.00);
INSERT INTO J2EEACCOUNT VALUES ('8', '8', 'CHECKING', 1008.00);
INSERT INTO J2EEACCOUNT VALUES ('9', '9', 'CHECKING', 1009.00);
INSERT INTO J2EEACCOUNT VALUES ('10', '10', 'CHECKING', 1010.00);
INSERT INTO J2EEACCOUNT VALUES ('11', '11', 'CHECKING', 1011.00);
INSERT INTO J2EEACCOUNT VALUES ('12', '12', 'CHECKING', 1012.00);
INSERT INTO J2EEACCOUNT VALUES ('13', '13', 'CHECKING', 1013.00);
INSERT INTO J2EEACCOUNT VALUES ('14', '14', 'CHECKING', 1014.00);
INSERT INTO J2EEACCOUNT VALUES ('15', '15', 'CHECKING', 1015.00);
INSERT INTO J2EEACCOUNT VALUES ('16', '16', 'CHECKING', 1016.00);
INSERT INTO J2EEACCOUNT VALUES ('17', '17', 'CHECKING', 1017.00);
INSERT INTO J2EEACCOUNT VALUES ('18', '18', 'CHECKING', 1018.00);
INSERT INTO J2EEACCOUNT VALUES ('19', '19', 'CHECKING', 1019.00);
INSERT INTO J2EEACCOUNT VALUES ('20', '20', 'CHECKING', 1020.00);
INSERT INTO J2EEACCOUNT VALUES ('21', '21', 'CHECKING', 1021.00);
INSERT INTO J2EEACCOUNT VALUES ('22', '22', 'CHECKING', 1022.00);
INSERT INTO J2EEACCOUNT VALUES ('23', '23', 'CHECKING', 1023.00);
INSERT INTO J2EEACCOUNT VALUES ('24', '24', 'CHECKING', 1024.00);
INSERT INTO J2EEACCOUNT VALUES ('25', '25', 'CHECKING', 1025.00);
INSERT INTO J2EEACCOUNT VALUES ('26', '26', 'CHECKING', 1026.00);
INSERT INTO J2EEACCOUNT VALUES ('27', '27', 'CHECKING', 1027.00);
INSERT INTO J2EEACCOUNT VALUES ('28', '28', 'CHECKING', 1028.00);
INSERT INTO J2EEACCOUNT VALUES ('29', '29', 'CHECKING', 1029.00);
INSERT INTO J2EEACCOUNT VALUES ('30', '30', 'CHECKING', 1030.00);
INSERT INTO J2EEACCOUNT VALUES ('31', '31', 'CHECKING', 1031.00);
INSERT INTO J2EEACCOUNT VALUES ('32', '32', 'CHECKING', 1032.00);
INSERT INTO J2EEACCOUNT VALUES ('33', '33', 'CHECKING', 1033.00);
INSERT INTO J2EEACCOUNT VALUES ('34', '34', 'CHECKING', 1034.00);
INSERT INTO J2EEACCOUNT VALUES ('35', '1', 'SAVINGS', 10010.00);
INSERT INTO J2EEACCOUNT VALUES ('36', '2', 'SAVINGS', 10020.00);
INSERT INTO J2EEACCOUNT VALUES ('37', '3', 'SAVINGS', 10030.00);
INSERT INTO J2EEACCOUNT VALUES ('38', '4', 'SAVINGS', 10040.00);
INSERT INTO J2EEACCOUNT VALUES ('39', '5', 'SAVINGS', 10050.00);
INSERT INTO J2EEACCOUNT VALUES ('40', '6', 'SAVINGS', 10060.00);
INSERT INTO J2EEACCOUNT VALUES ('41', '7', 'SAVINGS', 10070.00);
INSERT INTO J2EEACCOUNT VALUES ('42', '8', 'SAVINGS', 10080.00);
INSERT INTO J2EEACCOUNT VALUES ('43', '9', 'SAVINGS', 10090.00);
INSERT INTO J2EEACCOUNT VALUES ('44', '10', 'SAVINGS', 10100.00);
INSERT INTO J2EEACCOUNT VALUES ('45', '11', 'SAVINGS', 10110.00);
INSERT INTO J2EEACCOUNT VALUES ('46', '12', 'SAVINGS', 10120.00);
INSERT INTO J2EEACCOUNT VALUES ('47', '13', 'SAVINGS', 10130.00);
INSERT INTO J2EEACCOUNT VALUES ('48', '14', 'SAVINGS', 10140.00);
INSERT INTO J2EEACCOUNT VALUES ('49', '15', 'SAVINGS', 10150.00);
INSERT INTO J2EEACCOUNT VALUES ('50', '16', 'SAVINGS', 10160.00);
INSERT INTO J2EEACCOUNT VALUES ('51', '17', 'SAVINGS', 10170.00);
INSERT INTO J2EEACCOUNT VALUES ('52', '18', 'SAVINGS', 10180.00);
INSERT INTO J2EEACCOUNT VALUES ('53', '19', 'SAVINGS', 10190.00);
INSERT INTO J2EEACCOUNT VALUES ('54', '20', 'SAVINGS', 10200.00);
INSERT INTO J2EEACCOUNT VALUES ('55', '21', 'SAVINGS', 10210.00);
INSERT INTO J2EEACCOUNT VALUES ('56', '22', 'SAVINGS', 10220.00);
INSERT INTO J2EEACCOUNT VALUES ('57', '23', 'SAVINGS', 10230.00);
INSERT INTO J2EEACCOUNT VALUES ('58', '24', 'SAVINGS', 10240.00);
INSERT INTO J2EEACCOUNT VALUES ('59', '25', 'SAVINGS', 10250.00);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -