mystoreschema.data

Enterprise Java Bean的PPT文档,很好的东西.

INSERT INTO STOREACCESS(USERNAME,PASSWORD,USERID) VALUES('VTUSC','PASSWD','U1')
INSERT INTO STOREACCESS(USERNAME,PASSWORD,USERID) VALUES('ANDY','PASSWD','U2')
INSERT INTO STOREACCESS(USERNAME,PASSWORD,USERID) VALUES('SAPP','PASSWD','U3')
INSERT INTO STOREACCESS(USERNAME,PASSWORD,USERID) VALUES('TUSX','PASSWD','U4')
INSERT INTO STOREACCESS(USERNAME,PASSWORD,USERID) VALUES('RORGE','PASSWD','U5')
INSERT INTO STOREACCESS(USERNAME,PASSWORD,USERID) VALUES('RUSTY','PASSWD','U6')

INSERT INTO CUSTOMER(CUSTOMERID,USERID,FIRSTNAME,LASTNAME,ADDRESS,PHONE,MESSAGE,SHAREHOLDER_STAT) VALUES('C1','U1','VISHAL','SHARMA','4/267 VICTORIA ST','98402222','hi','N')
INSERT INTO CUSTOMER(CUSTOMERID,USERID,FIRSTNAME,LASTNAME,ADDRESS,PHONE,MESSAGE,SHAREHOLDER_STAT) VALUES('C2','U2','ANDREW','HENDRY','5/267 DONCASTER RD','98402222','hi','Y')
INSERT INTO CUSTOMER(CUSTOMERID,USERID,FIRSTNAME,LASTNAME,ADDRESS,PHONE,MESSAGE,SHAREHOLDER_STAT) VALUES('C3','U3','GLEN','McCALLUM','6/267 IRIS ST','98402222','hi','Y')

INSERT INTO SUPPLIER(SUPPLIERID,USERID,FIRSTNAME,LASTNAME,ADDRESS,MESSAGE,CREDIT_LIMIT) VALUES('S1','U4','SEBASTIAN','BELLOFIORE','10 ELIZABETH ST','hi',0)
INSERT INTO SUPPLIER(SUPPLIERID,USERID,FIRSTNAME,LASTNAME,ADDRESS,MESSAGE,CREDIT_LIMIT) VALUES('S2','U5','GEORGE','ALSTON','12 BOURKE ST','hi',0)

INSERT INTO MANAGER(MANAGERID,USERID,FIRSTNAME,LASTNAME,ADDRESS,MESSAGE,SALARY) VALUES('M1','U6','STEFFI','LINDSAY','10 COLLINS ST','hi',80000.00)


INSERT INTO ITEM(ITEMID,SUPPLIERID,DESCRIPTION,QUANTITY,PRICE) VALUES('I1','S1','CALCULATOR',0,45.00)
INSERT INTO ITEM(ITEMID,SUPPLIERID,DESCRIPTION,QUANTITY,PRICE) VALUES('I2','S1','PENCILS',190,1.10)
INSERT INTO ITEM(ITEMID,SUPPLIERID,DESCRIPTION,QUANTITY,PRICE) VALUES('I3','S2','INK PENS',90,2.10)
INSERT INTO ITEM(ITEMID,SUPPLIERID,DESCRIPTION,QUANTITY,PRICE) VALUES('I4','S1','CLOCK',0,65.00)