CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE CUSTOMER(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,NAME VARCHAR(80) NOT NULL,LOGINID VARCHAR(20) NOT NULL,PASSWD VARCHAR(255) NOT NULL,EMAIL VARCHAR(80),ADDRESS VARCHAR(80),STATUS VARCHAR(20),CONSTRAINT PK_CUSTOMER PRIMARY KEY(ID))
CREATE MEMORY TABLE CATEGORY(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,NAME VARCHAR(80) NOT NULL,DESCN VARCHAR(255),CONSTRAINT PK_CATEGORY PRIMARY KEY(ID))
CREATE MEMORY TABLE PRODUCT(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,CATEGORY_ID INTEGER NOT NULL,NAME VARCHAR(80) NOT NULL,DESCN VARCHAR(255),INVENTORY INTEGER,UNITPRICE DECIMAL(10,2),STATUS VARCHAR(20),ATTR1 VARCHAR(255),ATTR2 VARCHAR(255),ATTR3 VARCHAR(255),ATTR4 VARCHAR(255),TYPE VARCHAR(20) DEFAULT 'product',CONSTRAINT PK_PRODUCT PRIMARY KEY(ID),CONSTRAINT FK_PRODUCT_1 FOREIGN KEY(CATEGORY_ID) REFERENCES CATEGORY(ID))
CREATE MEMORY TABLE ORDERS(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,CUSTOMER_ID INTEGER NOT NULL,ORDERDATE DATE NOT NULL,TOTALPRICE DECIMAL(10,2) NOT NULL,SHIPADDR VARCHAR(80),SHIPDATE DATE,STATUS VARCHAR(2) DEFAULT '1',CONSTRAINT PK_ORDERS PRIMARY KEY(ID),CONSTRAINT FK_ORDERS_1 FOREIGN KEY(CUSTOMER_ID) REFERENCES CUSTOMER(ID))
CREATE MEMORY TABLE ORDER_ITEM(ORDER_ID INTEGER NOT NULL,LINENUM INTEGER NOT NULL,PRODUCT_ID INTEGER NOT NULL,QUANTITY INTEGER NOT NULL,UNITPRICE DECIMAL(10,2) NOT NULL,CONSTRAINT PK_ORDERITEM PRIMARY KEY(ORDER_ID,LINENUM),CONSTRAINT FK_ITEM_1 FOREIGN KEY(ORDER_ID) REFERENCES ORDERS(ID),CONSTRAINT FK_ITEM_2 FOREIGN KEY(PRODUCT_ID) REFERENCES PRODUCT(ID))
CREATE MEMORY TABLE LOG4J_MSG(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,LOGINID VARCHAR(20) NOT NULL,PRIORITY VARCHAR(10) NOT NULL,LOGDATE VARCHAR(21) NOT NULL,CLASS VARCHAR(255) NOT NULL,METHOD VARCHAR(100),MSG VARCHAR(200),CONSTRAINT PK_LOG4J_MSG PRIMARY KEY(ID))
CREATE MEMORY TABLE USERS(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,LOGINID VARCHAR(20) NOT NULL,PASSD VARCHAR(255) NOT NULL,NAME VARCHAR(80) NOT NULL,EMAIL VARCHAR(255) NOT NULL,STATUS VARCHAR(2) DEFAULT '1',CONSTRAINT PK_USERS PRIMARY KEY(ID))
CREATE MEMORY TABLE GROUPS(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,NAME VARCHAR(80) NOT NULL,PARENT_ID INTEGER NOT NULL,DESCN VARCHAR(255),CONSTRAINT PK_GROUPS PRIMARY KEY(ID),CONSTRAINT FK_GROUPS FOREIGN KEY(PARENT_ID) REFERENCES GROUPS(ID))
CREATE MEMORY TABLE ROLES(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,GROUP_ID INTEGER NOT NULL,NAME VARCHAR(80) NOT NULL,DESCN VARCHAR(255),CONSTRAINT PK_ROLES PRIMARY KEY(ID),CONSTRAINT FK_ROLES FOREIGN KEY(GROUP_ID) REFERENCES GROUPS(ID))
CREATE MEMORY TABLE RESOURCES(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,NAME VARCHAR(80) NOT NULL,RES_STRING VARCHAR(255) NOT NULL,RES_TYPE VARCHAR(20) NOT NULL,DESCN VARCHAR(255),CONSTRAINT PK_RESOURCES PRIMARY KEY(ID))
CREATE MEMORY TABLE OPERATIONS(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,NAME VARCHAR(80) NOT NULL,DESCN VARCHAR(255),STATUS VARCHAR(2) DEFAULT '1',CONSTRAINT PK_OPERATIONS PRIMARY KEY(ID))
CREATE MEMORY TABLE PERMISSIONS(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,RESOURCE_ID INTEGER NOT NULL,OPERATION_ID INTEGER NOT NULL,CONSTRAINT PK_PERMISSION PRIMARY KEY(ID),CONSTRAINT FK_PERMISSIONS_1 FOREIGN KEY(RESOURCE_ID) REFERENCES RESOURCES(ID),CONSTRAINT FK_PERMISSIONS_2 FOREIGN KEY(OPERATION_ID) REFERENCES OPERATIONS(ID))
CREATE MEMORY TABLE ROLE_PERMISSION(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,ROLE_ID INTEGER NOT NULL,PERMI_ID INTEGER NOT NULL,CONSTRAINT PK_ROLE_PERMI PRIMARY KEY(ID),CONSTRAINT FK_ROLE_PERMI_1 FOREIGN KEY(ROLE_ID) REFERENCES ROLES(ID),CONSTRAINT FK_ROLE_PERMI_2 FOREIGN KEY(PERMI_ID) REFERENCES PERMISSIONS(ID))
CREATE MEMORY TABLE USER_ROLE(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,USER_ID INTEGER NOT NULL,ROLE_ID INTEGER NOT NULL,CONSTRAINT PK_USER_ROLE PRIMARY KEY(ID),CONSTRAINT FK_USER_ROLE_1 FOREIGN KEY(USER_ID) REFERENCES USERS(ID),CONSTRAINT FK_USER_ROLE_2 FOREIGN KEY(ROLE_ID) REFERENCES ROLES(ID))
ALTER TABLE CUSTOMER ALTER COLUMN ID RESTART WITH 1
ALTER TABLE CATEGORY ALTER COLUMN ID RESTART WITH 2
ALTER TABLE PRODUCT ALTER COLUMN ID RESTART WITH 16
ALTER TABLE ORDERS ALTER COLUMN ID RESTART WITH 6
ALTER TABLE LOG4J_MSG ALTER COLUMN ID RESTART WITH 0
ALTER TABLE USERS ALTER COLUMN ID RESTART WITH 0
ALTER TABLE GROUPS ALTER COLUMN ID RESTART WITH 0
ALTER TABLE ROLES ALTER COLUMN ID RESTART WITH 0
ALTER TABLE RESOURCES ALTER COLUMN ID RESTART WITH 0
ALTER TABLE OPERATIONS ALTER COLUMN ID RESTART WITH 0
ALTER TABLE PERMISSIONS ALTER COLUMN ID RESTART WITH 0
ALTER TABLE ROLE_PERMISSION ALTER COLUMN ID RESTART WITH 0
ALTER TABLE USER_ROLE ALTER COLUMN ID RESTART WITH 0
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 60
SET SCHEMA PUBLIC
INSERT INTO CUSTOMER VALUES(0,'demo','demo','demo','demo@springside.org.cn','Demo Adress',NULL)
INSERT INTO CATEGORY VALUES(0,'Java','Java Book')
INSERT INTO CATEGORY VALUES(1,'Ruby','Ruby Book')
INSERT INTO PRODUCT VALUES(0,0,'J2EE \u6280\u672f\u5185\u5e55','\u672c\u4e66\u4eceJava\u6280\u672f\u7684\u80cc\u666f\u548c\u4f01\u4e1a\u7cfb\u7edf\u5f00\u53d1\u8fc7\u7a0b\u5f00\u59cb\u8c08\u8d77\uff0c\u7136\u540e\u7740\u773c\u4e8eJ2EE\u5e94\u7528\u5f00\u53d1\u4e2d\u9700\u8981\u505a\u7684\u5de5\u4f5c\uff0c\u5e76\u8c08\u5230\u4e86\u4e00\u4e9b\u5173\u952e\u6280\u672f\u3002\u5305\u62ecJava\u547d\u540d\u548c\u76ee\u5f55\u63a5\u53e3\u3001\u8f7b\u578b\u76ee\u5f55\u8bbf\u95ee\u534f\u8bae\u3001Java\u6570\u636e\u5e93\u8fde\u63a5\u3001Java\u670d\u52a1\u5668\u7aef\u5c0f\u7a0b\u5e8f\uff08servlet\uff09\u3001Java\u670d\u52a1\u5668\u9875\u9762\uff08JSP\uff09\u3001\u6a21\u578b-\u89c6\u56fe-\u63a7\u5236\u5668\uff08MVC\uff09\u548c\u4f01\u4e1aJavaBeans\uff08EJB\uff09\u3002\u7136\u540e\u53c8\u8bba\u8ff0\u4e86J2EE\u5e94\u7528\u7684\u4e13\u7528\u7ec4\u4ef6\uff0c\u4e3b\u8981\u96c6\u4e2d\u5728JavaMail\u3001Java\u6d88\u606f\u670d\u52a1\uff08JMS\uff09\u548c\u53ef\u6269\u5c55\u6807\u8bb0\u8bed\u8a00\uff08XML\uff09\u3002\u6700\u540e\u8fd8\u8ba8\u8bba\u4e86\u542f\u7528\u548c\u90e8\u7f72\u7a0b\u5e8f\u6240\u6d89\u53ca\u7684\u8bb8\u591a\u95ee\u9898\u3002\u5168\u4e66\u5305\u62ec19\u7ae0\u53ca\u4e09\u4e2a\u9644\u5f55\uff0c\u5185\u5bb9\u975e\u5e38\u5168\u9762\u5b9e\u7528\uff0c\u662f\u4f01\u4e1a\u6784\u5efa\u57fa\u4e8eWeb\u7684\u5e94\u7528\u548c\u5206\u5e03\u5f0f\u5e94\u7528\u65f6\u975e\u5e38\u5b9d\u8d35\u7684\u53c2\u8003\u8d44\u6e90\u3002 ',178,65.0,NULL,'\uff08\u7f8e\uff09Joseph J.Bambara Paul R.Allen\u7b49','/images/book/cover1.gif','\u673a\u68b0\u5de5\u4e1a\u51fa\u7248\u793e','2002-06-01','book')
INSERT INTO PRODUCT VALUES(1,0,'Expert One-on-One J2EE Development without EJB\u4e2d\u6587\u7248','\u8fd9\u672c\u4e66\u62e5\u6709\u4e00\u5927\u5806\u201c\u770b\u70b9\u201d\u3002\u8b6c\u5982\u8bf4\uff0c\u5b83\u7684\u4f5c\u8005Rod Johnson\u62e5\u670910\u5e74\u7f16\u5199Java\u7a0b\u5e8f\u7684\u7ecf\u9a8c\uff0c\u76ee\u524d\u662fServlet\u548cJDO 2.0\u4e24\u4e2aJSR\u4e13\u5bb6\u7ec4\u7684\u6210\u5458\uff1b\u518d\u8b6c\u5982\u8bf4\uff0c\u4e66\u4e2d\u7740\u529b\u4ecb\u7ecd\u7684Spring\u3001Hibernate\u3001WebWork\u7b49\u90fd\u662f\u65f6\u4e0b\u6d41\u884c\u7684\u5f00\u6e90\u6846\u67b6\uff0cIoC\u3001AOP\u4e4b\u7c7b\u90fd\u662f\u65f6\u4e0b\u6d41\u884c\u7684\u6982\u5ff5\u8bcd\u6c47\u3002\u800c\u6700\u5927\u7684\u770b\u70b9\u5c31\u8d6b\u7136\u6446\u5728\u8fd9\u672c\u4e66\u7684\u5c01\u9762\u4e0a\uff1a\u201cwithout EJB\u201d\u3002\u6211\u4eec\u66fe\u7ecf\u5728\u65e0\u6570\u7684\u4e66\u7c4d\u548c\u6587\u7ae0\u4e2d\u770b\u5230\uff0cEJB\u662fJ2EE\u7684\u6838\u5fc3\u6280\u672f\u4e4b\u4e00\uff1b\u800cRod Johnson\u7684\u8fd9\u672c\u4e66\u7adf\u7136\u5ba3\u79f0\uff0c\u7edd\u5927\u591a\u6570\u7684J2EE\u5e94\u7528\u6839\u672c\u4e0d\u9700\u8981EJB\u3002\u8fd9\u79cd\u8fd1\u4e4e\u6311\u8845\u7684\u59ff\u6001\u4ee4\u4efb\u4f55\u4e00\u4e2a\u8d1f\u8d23\u7684J2EE\u67b6\u6784\u5e08\u5f88\u96be\u4e0d\u840c\u751f\u4e00\u63a2\u7a76\u7adf\u7684\u5ff5\u5934--\u4e0d\u8bba\u4f60\u662f\u6253\u7b97\u8d5e\u540c\u4ed6\u8fd8\u662f\u6253\u7b97\u9a73\u65a5\u4ed6\u3002\u000d\u000a\u4f46\u6240\u6709\u8fd9\u4e9b\u5c3d\u7686\u4e0d\u662f\u672c\u4e66\u6700\u5927\u7684\u4ef7\u503c\u6240\u5728\u3002\u9009\u62e9\u4e00\u79cd\u67b6\u6784\u3001\u4e00\u79cd\u6280\u672f\u7684\u4f9d\u636e\u662f\u4ec0\u4e48\uff1fRod Johnson\u8ba4\u4e3a\uff0c\u5e94\u8be5\u662f\u57fa\u4e8e\u5b9e\u8df5\u7684\u8bc1\u636e\u3001\u6765\u81ea\u5386\u53f2\u9879\u76ee\u6216\u4eb2\u81ea\u8bd5\u9a8c\u7684\u7ecf\u9a8c\uff0c\u800c\u4e0d\u662f\u4efb\u4f55\u5f62\u5f0f\u7684\u5076\u50cf\u5d07\u62dc\u6216\u8005\u95e8\u6237\u4e4b\u89c1\u3002\u4e66\u4e2d\u8c08\u5230\u4e86\u4f01\u4e1a\u5e94\u7528\u65b9\u65b9\u9762\u9762\u7684\u95ee\u9898\u548c\u89e3\u51b3\u529e\u6cd5\uff0c\u800c\u8fd9\u4e9b\u65b9\u6848\u65e0\u4e00\u4e0d\u662f\u8fd9\u79cd\u201c\u5faa\u8bc1\u65b9\u6cd5\u201d\u7684\u4ea7\u7269\u3002\u9664\u4e86\u628a\u8fd9\u4e9b\u65b9\u6848\u4ea4\u7ed9\u8bfb\u8005\uff0cRod Johnson\u901a\u8fc7\u8fd9\u672c\u4e66\u5e0c\u671b\u4f20\u8fbe\u7684\u3001\u66f4\u4e3a\u91cd\u8981\u7684\u4fe1\u606f\u6b63\u662f\u201c\u5faa\u8bc1\u201d\u7684\u5de5\u4f5c\u65b9\u5f0f\u2014\u2014\u90a3\u539f\u672c\u5c31\u5e94\u8be5\u662f\u7a0b\u5e8f\u5458\u7684\u5de5\u4f5c\u65b9\u5f0f\u3002 ',277,59.8,NULL,'\uff08\u7f8e\uff09Rod Johnson,Juergen Hoeller ','/images/book/cover2.gif','\u7535\u5b50\u5de5\u4e1a\u51fa\u7248\u793e','2005-08-01','book')
INSERT INTO PRODUCT VALUES(13,0,'J2EE\u67b6\u6784\u5e08\u8ba4\u8bc1\u6307\u5357','\u672c\u4e66\u662fSun\u516c\u53f8J2EE\u67b6\u6784\u5e08\u8ba4\u8bc1\u8003\u8bd5\uff08SCEA\uff09\u7684\u6307\u5bfc\u7528\u4e66\u3002\u4f5c\u4e3aSun\u516c\u53f8\u8ba4\u8bc1\u90e8\u95e8\u6240\u7b56\u5212\u7684\u7cfb\u5217\u7528\u4e66\u4e4b\u4e00\uff0c\u5b83\u56f4\u7ed5\u8003\u8bd5\u4e2d\u6240\u6d89\u53ca\u7684\u5185\u5bb9\u6709\u9488\u5bf9\u6027\u5730\u8fdb\u884c\u4ecb\u7ecd\uff0c\u4e3b\u8981\u5305\u62ec\u4f53\u7cfb\u7ed3\u6784\u548cJ2EE\u6280\u672f\u7684\u6982\u8ff0\u3001\u4f53\u7cfb\u7ed3\u6784\u7684\u6587\u6863\u5316\u3001\u8bbe\u8ba1\u6a21\u5f0f\u3001\u7cfb\u7edf\u5b89\u5168\u6027\u4ee5\u53ca\u7cfb\u7edf\u56fd\u9645\u5316\u4e0e\u672c\u5730\u5316\u7b49\u3002\u6b64\u5916\u8fd8\u63d0\u4f9b\u4e00\u4e9b\u6709\u5173\u8003\u8bd5\u7684\u80cc\u666f\u4fe1\u606f\u548c\u6280\u5de7\u3002\u672c\u4e66\u5185\u5bb9\u4e30\u5bcc\uff0c\u7ed3\u6784\u6e05\u6670\uff0c\u9002\u5408\u4e8e\u51c6\u5907SCEA\u8003\u8bd5\u7684J2EE\u5f00\u53d1\u4eba\u5458\u4f7f\u7528\uff0c\u540c\u65f6\u4e5f\u53ef\u4f5c\u4e3aJava\u7f16\u7a0b\u4eba\u5458\u7684\u53c2\u8003\u7528\u4e66\u3002 \u672c\u4e66\u662f\u7531Sun\u516c\u53f8\u67b6\u6784\u5e08\u8ba4\u8bc1\u8003\u8bd5\u5c0f\u7ec4\u7684\u4e3b\u8981\u5f00\u53d1\u4eba\u5458\u548c\u6280\u672f\u987e\u95ee\u7f16\u5199\u914c\u5b66\u4e60\u6307\u5357\uff0c \u63d0\u4f9b\u4e86\u4e13\u5bb6\u7ea7\u7684\u6307\u5bfc\u548c\u76f8\u5173\u7684\u80cc\u666f\u4ecb\u7ecd\u3002\u6b64\u5916\uff0c\u8fd8\u4e3a\u8003\u8bd5\u7684\u6bcf\u4e00\u4e2a\u90e8\u5206\u63d0\u4f9b\u4e86\u5168\u9762\u7684\u9884\u5907 \u77e5\u8bc6\u4ecb\u7ecd\u3002\u4f60\u4f1a\u53d1\u73b0\u672c\u4e66\u6db5\u76d6\u4e86J2EE\u5e73\u53f0\u4f53\u7cfb\u7ed3\u6784\u7684\u5173\u952e\u95ee\u9898\u548c\u8ba4\u8bc1\u8003\u8bd5\u7684\u57fa\u672c\u5185\u5bb9\u3002\u4e0d \u4ec5\u662fJ2EE\u67b6\u6784\u5e08\u8ba4\u8bc1\u5fc5\u5907\uff0c\u4e5f\u662f\u5b66\u4e60J2EE\u67b6\u6784\u8bbe\u8ba1\u7684\u6781\u597d\u6750\u6599\u3002 \u4e3b\u8981\u5185\u5bb9\uff1a \u4e86\u89e3\u67b6\u6784\u5e08\u7684\u76ee\u6807 \u5229\u7528\u5df2\u8bc1\u660e\u7684\u8bbe\u8ba1\u6a21\u5f0f \u5728\u5e94\u7528\u7a0b\u5e8f\u4e2d\u786e\u5b9a\u6b63\u786e\u7684J2EE\u6280\u672f\u548cAPI \u5728\u4f01\u4e1a\u73af\u5883\u4e2d\uff0c\u6700\u5927\u9650\u5ea6\u5730\u63d0\u9ad8\u5b89\u5168\u6027\uff0c\u5e76\u5bf9\u9632\u706b\u5899\u8fdb\u884c\u4e86\u89e3\u91ca \u4f7f\u7528EJB\u4f53\u7cfb\u7ed3\u6784\u5bb9\u5668\u6a21\u578b\u6700\u5927\u9650\u5ea6\u5730\u63d0\u9ad8\u53ef\u4f38\u7f29\u6027 \u8bc4\u4f30\u5df2\u6709\u4f53\u7cfb\u7ed3\u6784\u7684\u4f18\u70b9\u548c\u7f3a\u9677',149,28.0,NULL,'\uff08\u7f8e\uff09Mark Cade,Simon Roberts ','/images/book/cover3.gif','\u673a\u68b0\u5de5\u4e1a\u51fa\u7248\u793e','2004-01-01','book')
INSERT INTO PRODUCT VALUES(14,0,'J2EE\u5feb\u901f\u5f00\u53d1','\u672c\u4e66\u6df1\u5165\u4ecb\u7ecdJ2EE\u5e94\u7528\u5feb\u901f\u5f00\u53d1\u7684\u6280\u672f\u548c\u65b9\u6cd5\uff0c\u6d89\u53ca\u4ece\u8bbe\u8ba1\u5230\u6d4b\u8bd5\u7684\u65b9\u65b9\u9762\u9762\uff0c\u5176\u4e2d\u5305\u62ec\u5feb\u901f\u5f00\u53d1\u7684\u4e0d\u540c\u9636\u6bb5\uff0c\u5176\u4ed6\u53ef\u7528\u6280\u672f\uff0c\u6240\u9700\u7684\u5de5\u5177\u3001\u6280\u672f\u548c\u6d41\u7a0b\u3002\u4e66\u4e2d\u6240\u4f7f\u7528\u7684\u793a\u4f8b\u90fd\u5c3d\u53ef\u80fd\u5730\u4f7f\u7528\u4e86\u5f00\u6e90\u8f6f\u4ef6\uff0c\u6700\u5927\u5316\u5730\u964d\u4f4e\u4e86\u638c\u63e1\u5feb\u901f\u5f00\u53d1\u6280\u672f\u7684\u6210\u672c\uff0c\u56e0\u6b64\u672c\u4e66\u975e\u5e38\u5b9e\u7528\u3002.\u000d\u000a\u672c\u4e66\u9002\u4e8e\u4efb\u4f55\u5e0c\u671b\u4ece\u4e8bJ2EE\u5e73\u53f0\u4f01\u4e1a\u7ea7\u7cfb\u7edf\u5f00\u53d1\u7684\u4eba\u5458\u3001\u9879\u76ee\u8d1f\u8d23\u4eba\u3001\u7ecf\u7406\u9605\u8bfb\u3002\u000d\u000a\u867d\u8bf4J2EE\u662f\u5f53\u4eca\u4f01\u4e1a\u7ea7\u5f00\u53d1\u7684\u4e3b\u8981\u5e73\u53f0\uff0c\u4f46\u4e5f\u5f88\u96be\u6839\u636e\u5f53\u524d\u4e1a\u52a1\u9700\u6c42\u5f88\u5feb\u5730\u53d1\u5e03J2EE\u89e3\u51b3\u65b9\u6848\u3002\u672c\u4e66\u7ed9\u51fa\u4e86\u53ef\u4ee5\u8d2f\u7a7f\u6574\u4e2a\u9879\u76ee\u5468\u671f\u7684\u5b8c\u6574\u3001\u5b9e\u7528\u7684\u5feb\u901f\u5f00\u53d1\u57fa\u7840\uff0c\u5176\u4e2d\u4ecb\u7ecd\u7684\u6700\u4f73\u5b9e\u8df5\u548c\u5de5\u5177\u4e0d\u4ec5\u53ef\u4ee5\u52a0\u901f\u5f00\u53d1\uff0c\u800c\u4e14\u8fd8\u6709\u52a9\u4e8e\u5f00\u53d1\u4eba\u5458\u66f4\u597d\u5730\u9002\u5e94\u9879\u76ee\u4e0d\u65ad\u589e\u52a0\u7684\u590d\u6742\u5ea6\u548c\u4e0d\u65ad\u7684\u4fee\u6539\u3002\u8bfb\u8005\u5c06\u5b66\u4e60\u5982\u4f55\u5145\u5206\u5e94\u7528\u8fed\u4ee3\u5f00\u53d1\u3001\u6a21\u578b\u9a71\u52a8\u67b6\u6784\uff08MDA\uff09\u3001\u4ee3\u7801\u751f\u6210\u5de5\u5177\u3001\u9762\u5411\u65b9\u9762\u7f16\u7a0b\uff08AOP\uff09\u3001\u6d4b\u8bd5\u9a71\u52a8\u5f00\u53d1\u7b49\u7b49\u3002',97,35.0,NULL,'\uff08\u7f8e\uff09Alan Monnox ','/images/book/cover4.gif','\u673a\u68b0\u5de5\u4e1a\u51fa\u7248\u793e','2006-01-01','book')
INSERT INTO PRODUCT VALUES(15,0,'J2EE\u53cd\u6a21\u5f0f','\u6240\u8c13\u6a21\u5f0f\uff0c\u5c31\u662f\u4ee5\u4e00\u79cd\u6b63\u5f0f\u6a21\u677f\u7684\u5f62\u5f0f\u6765\u63cf\u8ff0\u597d\u7684\u5b9e\u8df5\u505a\u6cd5\uff0c\u800c\u53cd\u6a21\u5f0f\u662f\u91c7\u7528\u76f8\u540c\u7684\u5f62\u5f0f\u6765\u63cf\u8ff0\u4e0d\u6070\u5f53\u7684\u5b9e\u8df5\u505a\u6cd5\u3002\u672c\u4e66\u4e0d\u4ec5\u6307\u51fa\u4e86\u8bb8\u591aJ2EE\u5f00\u53d1\u4e2d\u5b58\u5728\u7684\u53cd\u6a21\u5f0f\u53ca\u5176\u75c7\u72b6\u548c\u5f15\u53d1\u7684\u540e\u679c\uff0c\u800c\u4e14\u5206\u6790\u4e86\u5176\u4ea7\u751f\u7684\u539f\u56e0\uff0c\u5e76\u81f3\u5c11\u7ed9\u51fa\u4e86\u4e00\u79cd\u91cd\u6784\u65b9\u6848\uff0c\u6307\u5bfc\u5f00\u53d1\u4eba\u5458\u9010\u6b65\u8f6c\u6362\u4ee3\u7801\u5b9e\u73b0\uff0c\u4ece\u800c\u5f97\u5230\u66f4\u597d\u7684\u6ca1\u8ba1\uff1a\u672c\u4e66\u7684\u76ee\u7684\u4e0d\u662f\u60f3\u6307\u5bfc\u5f00\u53d1\u4eba\u5458\u5982\u4f55\u5b8c\u6210J2EE\u8bbe\u8ba1\u548c\u5f00\u53d1\uff0c\u800c\u662f\u901a\u8fc7\u6307\u51fa\u5e94\u7528\u5f00\u53d1\u4e2d\u5e38\u72af\u7684\u9519\u8bef\u53ca\u4fee\u590d\u9519\u8bef\u7684\u65b9\u6cd5\uff0c\u6765\u6307\u5bfc\u8bfb\u8005\u6210\u4e3a\u66f4\u597d\u7684J2EE\u5f00\u53d1\u4eba\u5458\u3002.\u000d\u000a\u5982\u4eca\u6709\u8bb8\u591a\u5df2\u53d1\u5e03\u7684\u8f6f\u4ef6\u4e2d\u90fd\u5b58\u5728\u7740\u5927\u91cf\u7684bug\uff0c\u8fd0\u4f5c\u5f97\u5341\u5206\u7cdf\u7cd5\u3002\u9057\u61be\u7684\u662f\uff0c\u901a\u5e38\u6211\u4eec\u5f88\u96be\u51c6\u786e\u5730\u627e\u51fa\u662f\u54ea\u91cc\u51fa\u4e86\u95ee\u9898\uff0c\u9700\u8981\u505a\u54ea\u4e9b\u5de5\u4f5c\u624d\u80fd\u8ba9\u60c5\u51b5\u597d\u8f6c\u3002\u672c\u4e66\u4ee5\u5168\u65b0\u7684\u89c6\u89d2\uff0c\u9488\u5bf9J2EE\uff0c\u4e3a\u8bfb\u8005\u5949\u4e0a\u4e86\u5927\u91cf\u627e\u51fa\u5e76\u4fee\u6b63\u53cd\u6a21\u5f0f (\u5373\u4e0d\u597d\u7684\u7f16\u7801\u548c\u8bbe\u8ba1\u4e60\u60ef) \u7684\u5de5\u5177\u3002\u672c\u4e66\u4f5c\u8005\u5206\u6790\u4e86\u5f00\u53d1J2EE\u5e94\u7528\u65f6\u5e38\u72af\u7684\u9519\u8bef\uff0c\u5e76\u4e14\u6e05\u695a\u5730\u6307\u51fa\u4e86\u8be5\u5982\u4f55\u8fdb\u884c\u91cd\u6784\u4ee5\u6446\u8131\u56f0\u5883\u3002\u000d\u000a\u672c\u4e66\u9996\u5148\u4ee5\u6a21\u677f\u7684\u5f62\u5f0f\u6765\u4ecb\u7ecd\u67d0\u79cd\u53cd\u6a21\u5f0f\uff0c\u63cf\u8ff0\u5176\u75c7\u72b6\u548c\u540e\u679c\uff0c\u5e76\u6307\u51fa\u5176\u4ea7\u751f\u7684\u5178\u578b\u539f\u56e0\uff0c\u7136\u540e\u9010\u6b65\u5bf9\u4ee3\u7801\u5b9e\u73b0\u8fdb\u884c\u8f6c\u6362\uff0c\u4ece\u800c\u5f97\u5230\u4e00\u4e2a\u66f4\u597d\u7684\u8bbe\u8ba1\u3002\u5bf9\u4e8e\u6bcf\u4e00\u79cd\u53cd\u6a21\u5f0f\uff0c\u4f5c\u8005\u90fd\u63d0\u4f9b\u4e00\u4e9b\u5b9e\u9645\u7684\u4f8b\u5b50\u548c\u4ee3\u7801\uff0c\u800c\u4e14\u81f3\u5c11\u63d0\u4f9b\u4e86\u4e00\u79cd\u91cd\u6784\u65b9\u6848\u3002\u8bfb\u8005\u53ef\u4ee5\u4f7f\u7528\u8fd9\u4e9b\u65b9\u6848\uff0c\u8f7b\u677e\u7f16\u5199\u51fa\u8868\u73b0\u66f4\u597d\u3001\u8fd0\u884c\u66f4\u5feb\u7684J2EE\u7a0b\u5e8f\u3002\u4e66\u4e2d\u6db5\u76d650\u591a\u79cdJ2EE\u53cd\u6a21\u5f0f\uff0c\u5176\u4e2d\u6d89\u53caJava\u7f16\u7a0b\u7684\u8bb8\u591a\u70ed\u70b9\u95ee\u9898',57,49.0,NULL,'\uff08\u7f8e\uff09Bill Dudney,Stephen Asbury, Joseph K.Krozak','/images/book/cover5.gif','\u673a\u68b0\u5de5\u4e1a\u51fa\u7248\u793e','2006-01-01','book')
INSERT INTO ORDERS VALUES(1,0,'2006-01-27',157.8,'\u5e7f\u5dde\u6c5f\u5357\u897f\u8def\u7d2b\u9f99\u5927\u8857101\u53f7401','2006-01-27','1')
INSERT INTO ORDERS VALUES(2,0,'2006-01-27',470.4,'\u5e7f\u5dde\u5e02\u5317\u4eac\u8def39\u53f7','2006-02-01','2')
INSERT INTO ORDERS VALUES(3,0,'2006-01-27',119.0,'\u5e7f\u5dde\u5929\u6cb3\u5317\u8def18\u53f7105','2006-02-03','2')
INSERT INTO ORDERS VALUES(4,0,'2006-01-27',236.8,'\u5e7f\u5dde\u4e94\u5c71\u8def101\u53f7501','2006-02-04','1')
INSERT INTO ORDERS VALUES(5,0,'2006-01-27',284.4,'\u5e7f\u5dde\u8d77\u4e49\u8def\u5927\u65b0\u885732\u53f7201','2006-02-05','1')
INSERT INTO ORDER_ITEM VALUES(1,0,1,1,59.8)
INSERT INTO ORDER_ITEM VALUES(1,1,13,1,28.0)
INSERT INTO ORDER_ITEM VALUES(1,2,14,2,35.0)
INSERT INTO ORDER_ITEM VALUES(2,0,0,2,65.0)
INSERT INTO ORDER_ITEM VALUES(2,1,1,3,59.8)
INSERT INTO ORDER_ITEM VALUES(2,2,13,1,28.0)
INSERT INTO ORDER_ITEM VALUES(2,3,14,1,35.0)
INSERT INTO ORDER_ITEM VALUES(2,4,15,2,49.0)
INSERT INTO ORDER_ITEM VALUES(3,0,14,2,35.0)
INSERT INTO ORDER_ITEM VALUES(3,1,15,1,49.0)
INSERT INTO ORDER_ITEM VALUES(4,0,1,1,59.8)
INSERT INTO ORDER_ITEM VALUES(4,1,0,1,65.0)
INSERT INTO ORDER_ITEM VALUES(4,2,13,1,28.0)
INSERT INTO ORDER_ITEM VALUES(4,3,14,1,35.0)
INSERT INTO ORDER_ITEM VALUES(4,4,15,1,49.0)
INSERT INTO ORDER_ITEM VALUES(5,0,1,3,59.8)
INSERT INTO ORDER_ITEM VALUES(5,1,13,2,28.0)
INSERT INTO ORDER_ITEM VALUES(5,2,15,1,49.0)