default.script

《J2EE企业级应用开发》一书的配套源代码

CREATE TABLE LINEITEMEJB(ITEMID VARCHAR NOT NULL,LINENUM VARCHAR,QUANTITY INTEGER NOT NULL,UNITPRICE REAL NOT NULL,THEORDER VARCHAR,UNIQUE(ITEMID))
CREATE UNIQUE INDEX PK_LINEITEMEJB ON LINEITEMEJB(ITEMID)
CREATE TABLE CUSTOMEREJB(USERID VARCHAR NOT NULL,ACCOUNT VARCHAR,PROFILE VARCHAR,UNIQUE(USERID))
CREATE UNIQUE INDEX PK_CUSTOMEREJB ON CUSTOMEREJB(USERID)
CREATE TABLE CONTACTINFOEJB(NAME VARCHAR NOT NULL,TELEPHONE VARCHAR,ADDRESS VARBINARY,EMAIL VARCHAR,ACCOUNTEJB_CONTACTINFO VARCHAR,UNIQUE(NAME))
CREATE UNIQUE INDEX PK_CONTACTINFOEJB ON CONTACTINFOEJB(NAME)
CREATE TABLE PROFILEEJB(USERID VARCHAR NOT NULL,FAVCATEGORY VARCHAR,BANNEROPT BIT NOT NULL,CUSTOMEREJB_PROFILE VARCHAR,UNIQUE(USERID))
CREATE UNIQUE INDEX PK_PROFILEEJB ON PROFILEEJB(USERID)
CREATE TABLE CREDITCARDEJB(CARDNUMBER VARCHAR NOT NULL,CARDTYPE VARCHAR,EXPIRYDATE TIMESTAMP,ACCOUNTEJB_CREDITCARD VARCHAR,UNIQUE(CARDNUMBER))
CREATE UNIQUE INDEX PK_CREDITCARDEJB ON CREDITCARDEJB(CARDNUMBER)
CREATE TABLE ACCOUNTEJB(USERID VARCHAR NOT NULL,STATUS VARCHAR,CONTACTINFO VARCHAR,CREDITCARD VARCHAR,CUSTOMEREJB_ACCOUNT VARCHAR,UNIQUE(USERID))
CREATE UNIQUE INDEX PK_ACCOUNTEJB ON ACCOUNTEJB(USERID)
CREATE TABLE CATEGORYEJB(CATEID VARCHAR NOT NULL,NAME VARCHAR,DESCRIPTION VARCHAR,UNIQUE(CATEID))
CREATE UNIQUE INDEX PK_CATEGORYEJB ON CATEGORYEJB(CATEID)
CREATE TABLE PRODUCTEJB(PRODUCTID VARCHAR NOT NULL,NAME VARCHAR,DESCRIPTION VARCHAR,CATEGORY VARCHAR,ITEMEJB_PRODUCT VARCHAR,UNIQUE(PRODUCTID))
CREATE UNIQUE INDEX PK_PRODUCTEJB ON PRODUCTEJB(PRODUCTID)
CREATE TABLE ITEMEJB(ITEMID VARCHAR NOT NULL,UNITPRICE REAL NOT NULL,SUPPLIER VARBINARY,IMAGELOCATION VARCHAR,ATTR VARCHAR,SUPPLIER VARCHAR,PRODUCT VARCHAR,UNIQUE(ITEMID))
CREATE UNIQUE INDEX PK_ITEMEJB ON ITEMEJB(ITEMID)
CREATE TABLE MEDIAEJB(ID VARCHAR NOT NULL,DESCRIPTION VARCHAR,PUBTIME TIMESTAMP,FILENAME VARCHAR,PRODUCER VARCHAR,PRODUCTEJB_MEDIAS VARCHAR,UNIQUE(ID))
CREATE UNIQUE INDEX PK_MEDIAEJB ON MEDIAEJB(ID)
CREATE TABLE SUPPLIEREJB(SUPPLIERID VARCHAR NOT NULL,ADDRESS VARBINARY,PHONE VARCHAR,UNIQUE(SUPPLIERID))
CREATE UNIQUE INDEX PK_SUPPLIEREJB ON SUPPLIEREJB(SUPPLIERID)
CREATE TABLE INVENTORYEJB(ITEMID VARCHAR NOT NULL,QTY INTEGER NOT NULL,UNIQUE(ITEMID))
CREATE UNIQUE INDEX PK_INVENTORYEJB ON INVENTORYEJB(ITEMID)
CREATE TABLE USEREJB(USERNAME VARCHAR NOT NULL,PASSWORD VARCHAR,UNIQUE(USERNAME))
CREATE UNIQUE INDEX PK_USEREJB ON USEREJB(USERNAME)
CREATE TABLE BANKSERVICEEJB(CARDNUBMER VARCHAR NOT NULL,DEPOSIT REAL NOT NULL,PASSWORD VARCHAR,UNIQUE(CARDNUBMER))
CREATE UNIQUE INDEX PK_BANKSERVICEEJB ON BANKSERVICEEJB(CARDNUBMER)
GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC
CREATE USER SA PASSWORD "" ADMIN
CREATE ALIAS DAYNAME FOR "org.hsqldb.Library.dayname"
CREATE ALIAS SPACE FOR "org.hsqldb.Library.space"
CREATE ALIAS SUBSTRING FOR "org.hsqldb.Library.substring"
CREATE ALIAS SQRT FOR "java.lang.Math.sqrt"
CREATE ALIAS ABS FOR "java.lang.Math.abs"
CREATE ALIAS POWER FOR "java.lang.Math.pow"
CREATE ALIAS CHAR FOR "org.hsqldb.Library.character"
CREATE ALIAS CONCAT FOR "org.hsqldb.Library.concat"
CREATE ALIAS PI FOR "org.hsqldb.Library.pi"
CREATE ALIAS SECOND FOR "org.hsqldb.Library.second"
CREATE ALIAS TRUNCATE FOR "org.hsqldb.Library.truncate"
CREATE ALIAS MONTH FOR "org.hsqldb.Library.month"
CREATE ALIAS LOWER FOR "org.hsqldb.Library.lcase"
CREATE ALIAS ATAN2 FOR "java.lang.Math.atan2"
CREATE ALIAS REPEAT FOR "org.hsqldb.Library.repeat"
CREATE ALIAS DAYOFMONTH FOR "org.hsqldb.Library.dayofmonth"
CREATE ALIAS TAN FOR "java.lang.Math.tan"
CREATE ALIAS RADIANS FOR "java.lang.Math.toRadians"
CREATE ALIAS FLOOR FOR "java.lang.Math.floor"
CREATE ALIAS NOW FOR "org.hsqldb.Library.now"
CREATE ALIAS ACOS FOR "java.lang.Math.acos"
CREATE ALIAS DAYOFWEEK FOR "org.hsqldb.Library.dayofweek"
CREATE ALIAS CEILING FOR "java.lang.Math.ceil"
CREATE ALIAS DAYOFYEAR FOR "org.hsqldb.Library.dayofyear"
CREATE ALIAS LCASE FOR "org.hsqldb.Library.lcase"
CREATE ALIAS WEEK FOR "org.hsqldb.Library.week"
CREATE ALIAS SOUNDEX FOR "org.hsqldb.Library.soundex"
CREATE ALIAS ASIN FOR "java.lang.Math.asin"
CREATE ALIAS LOCATE FOR "org.hsqldb.Library.locate"
CREATE ALIAS EXP FOR "java.lang.Math.exp"
CREATE ALIAS MONTHNAME FOR "org.hsqldb.Library.monthname"
CREATE ALIAS YEAR FOR "org.hsqldb.Library.year"
CREATE ALIAS LEFT FOR "org.hsqldb.Library.left"
CREATE ALIAS ROUNDMAGIC FOR "org.hsqldb.Library.roundMagic"
CREATE ALIAS BITOR FOR "org.hsqldb.Library.bitor"
CREATE ALIAS LTRIM FOR "org.hsqldb.Library.ltrim"
CREATE ALIAS COT FOR "org.hsqldb.Library.cot"
CREATE ALIAS COS FOR "java.lang.Math.cos"
CREATE ALIAS MOD FOR "org.hsqldb.Library.mod"
CREATE ALIAS SIGN FOR "org.hsqldb.Library.sign"
CREATE ALIAS DEGREES FOR "java.lang.Math.toDegrees"
CREATE ALIAS LOG FOR "java.lang.Math.log"
CREATE ALIAS SIN FOR "java.lang.Math.sin"
CREATE ALIAS CURTIME FOR "org.hsqldb.Library.curtime"
CREATE ALIAS DIFFERENCE FOR "org.hsqldb.Library.difference"
CREATE ALIAS INSERT FOR "org.hsqldb.Library.insert"
CREATE ALIAS SUBSTR FOR "org.hsqldb.Library.substring"
CREATE ALIAS DATABASE FOR "org.hsqldb.Library.database"
CREATE ALIAS MINUTE FOR "org.hsqldb.Library.minute"
CREATE ALIAS HOUR FOR "org.hsqldb.Library.hour"
CREATE ALIAS IDENTITY FOR "org.hsqldb.Library.identity"
CREATE ALIAS QUARTER FOR "org.hsqldb.Library.quarter"
CREATE ALIAS CURDATE FOR "org.hsqldb.Library.curdate"
CREATE ALIAS BITAND FOR "org.hsqldb.Library.bitand"
CREATE ALIAS USER FOR "org.hsqldb.Library.user"
CREATE ALIAS UCASE FOR "org.hsqldb.Library.ucase"
CREATE ALIAS RTRIM FOR "org.hsqldb.Library.rtrim"
CREATE ALIAS LOG10 FOR "org.hsqldb.Library.log10"
CREATE ALIAS RIGHT FOR "org.hsqldb.Library.right"
CREATE ALIAS ATAN FOR "java.lang.Math.atan"
CREATE ALIAS UPPER FOR "org.hsqldb.Library.ucase"
CREATE ALIAS ASCII FOR "org.hsqldb.Library.ascii"
CREATE ALIAS RAND FOR "java.lang.Math.random"
CREATE ALIAS LENGTH FOR "org.hsqldb.Library.length"
CREATE ALIAS ROUND FOR "org.hsqldb.Library.round"
CREATE ALIAS REPLACE FOR "org.hsqldb.Library.replace"
INSERT INTO LINEITEMEJB VALUES('item8476','lineitem100',2,566.5,'order_demo_11')
INSERT INTO LINEITEMEJB VALUES('item8479','lineitem105',2,566.5,'order_demo_11')
INSERT INTO LINEITEMEJB VALUES('item8477','lineitem101',3,45.55,'order_demo_11')
INSERT INTO LINEITEMEJB VALUES('item8478','lineitem102',3,45.55,'order_demo_11')
INSERT INTO LINEITEMEJB VALUES('item_11','item_11_0',1,34.4,'956046837406')
INSERT INTO LINEITEMEJB VALUES('item_13','item_13_0',1,34.4,'956049756187')
INSERT INTO LINEITEMEJB VALUES('item_12','956050483734_0',1,34.4,NULL)
INSERT INTO LINEITEMEJB VALUES('item_18','987597946170_0',1,34.4,'987597946155')
INSERT INTO CUSTOMEREJB VALUES('v55','v55','v55')
INSERT INTO CUSTOMEREJB VALUES('e1','e1','e1')
INSERT INTO CUSTOMEREJB VALUES('e2','e2','e2')
INSERT INTO CONTACTINFOEJB VALUES('v','v','aced0005737200246f72672e6a626f73732e696e766f636174696f6e2e4d61727368616c6c656456616c7565eacce0d1f44ad0990c00007870779100000089aced00057372001e636f6d2e6a3265656170702e636473746f72652e766f2e41646472657373f53def1271c7ffe10200044c0004636974797400124c6a6176612f6c616e672f537472696e673b4c0005737461746571007e00014c000673747265657471007e00014c00077a6970436f646571007e0001787074000176740001767400017674000176c4e9f5cc78','v',NULL)
INSERT INTO CONTACTINFOEJB VALUES('v5','v5','aced0005737200246f72672e6a626f73732e696e766f636174696f6e2e4d61727368616c6c656456616c7565eacce0d1f44ad0990c0000787077950000008daced00057372001e636f6d2e6a3265656170702e636473746f72652e766f2e41646472657373f53def1271c7ffe10200044c0004636974797400124c6a6176612f6c616e672f537472696e673b4c0005737461746571007e00014c000673747265657471007e00014c00077a6970436f646571007e00017870740002763574000276357400027635740002763574a6108878','v5',NULL)
INSERT INTO CONTACTINFOEJB VALUES('v5t','v5t','aced0005737200246f72672e6a626f73732e696e766f636174696f6e2e4d61727368616c6c656456616c7565eacce0d1f44ad0990c00007870779900000091aced00057372001e636f6d2e6a3265656170702e636473746f72652e766f2e41646472657373f53def1271c7ffe10200044c0004636974797400124c6a6176612f6c616e672f537472696e673b4c0005737461746571007e00014c000673747265657471007e00014c00077a6970436f646571007e00017870740003763574740003763574740003763574740003763574d395e74078','v5t','v55')
INSERT INTO CONTACTINFOEJB VALUES('e1','e1','aced0005737200246f72672e6a626f73732e696e766f636174696f6e2e4d61727368616c6c656456616c7565eacce0d1f44ad0990c0000787077950000008daced00057372001e636f6d2e6a3265656170702e636473746f72652e766f2e41646472657373f53def1271c7ffe10200044c0004636974797400124c6a6176612f6c616e672f537472696e673b4c0005737461746571007e00014c000673747265657471007e00014c00077a6970436f646571007e000178707400026531740002653174000265317400026531329ac0c878','v','e1')
INSERT INTO CONTACTINFOEJB VALUES('e2','e2','aced0005737200246f72672e6a626f73732e696e766f636174696f6e2e4d61727368616c6c656456616c7565eacce0d1f44ad0990c0000787077950000008daced00057372001e636f6d2e6a3265656170702e636473746f72652e766f2e41646472657373f53def1271c7ffe10200044c0004636974797400124c6a6176612f6c616e672f537472696e673b4c0005737461746571007e00014c000673747265657471007e00014c00077a6970436f646571007e000178707400026532740002653274000265327400026532aac62a0878','e2','e2')