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',CREATETIME DATE,CREATE_USER_ID INTEGER,MODIFYTIME DATE,MODIFY_USER_ID INTEGER,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,DISCOUNTPRICE DECIMAL(10,2),APPLYRULES VARCHAR(2500),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_LOG(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,PASSWD 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 ROLES(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,NAME VARCHAR(80) NOT NULL,DESCN VARCHAR(255),CONSTRAINT PK_ROLES PRIMARY KEY(ID)) CREATE MEMORY TABLE USER_ROLE(USER_ID INTEGER NOT NULL,ROLE_ID INTEGER NOT NULL,CONSTRAINT PK_USER_ROLE PRIMARY KEY(USER_ID,ROLE_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)) CREATE MEMORY TABLE PERMISSIONS(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,NAME VARCHAR(80) NOT NULL,DESCN VARCHAR(255),OPERATION VARCHAR(80),STATUS VARCHAR(2) DEFAULT '1',CONSTRAINT PK_PERMISSONS PRIMARY KEY(ID)) CREATE MEMORY TABLE ROLE_PERMIS(ROLE_ID INTEGER NOT NULL,PERMIS_ID INTEGER NOT NULL,CONSTRAINT PK_ROLE_PERMIS PRIMARY KEY(ROLE_ID,PERMIS_ID),CONSTRAINT FK_ROLE_ROLE_PERMIS_1 FOREIGN KEY(ROLE_ID) REFERENCES ROLES(ID),CONSTRAINT FK_ROLE_ROLE_PERMIS_2 FOREIGN KEY(PERMIS_ID) REFERENCES PERMISSIONS(ID)) CREATE MEMORY TABLE RESOURCES(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,NAME VARCHAR(80) NOT NULL,RES_TYPE VARCHAR(20) NOT NULL,RES_STRING VARCHAR(255) NOT NULL,DESCN VARCHAR(255),CONSTRAINT PK_RESOURCES PRIMARY KEY(ID)) CREATE MEMORY TABLE PERMIS_RESC(PERMIS_ID INTEGER NOT NULL,RESC_ID INTEGER NOT NULL,CONSTRAINT PK_PERMIS_RESC PRIMARY KEY(PERMIS_ID,RESC_ID),CONSTRAINT FK_ROLE_PERMIS_RESC_1 FOREIGN KEY(RESC_ID) REFERENCES RESOURCES(ID),CONSTRAINT FK_ROLE_PERMIS_RESC_2 FOREIGN KEY(PERMIS_ID) REFERENCES PERMISSIONS(ID)) CREATE MEMORY TABLE ACL_OBJECT_IDENTITY(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,OBJECT_IDENTITY VARCHAR_IGNORECASE(250) NOT NULL,PARENT_OBJECT BIGINT,ACL_CLASS VARCHAR_IGNORECASE(250) NOT NULL,CONSTRAINT UNIQUE_OBJECT_IDENTITY UNIQUE(OBJECT_IDENTITY),CONSTRAINT SYS_FK_66 FOREIGN KEY(PARENT_OBJECT) REFERENCES ACL_OBJECT_IDENTITY(ID)) CREATE MEMORY TABLE ACL_PERMISSION(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,ACL_OBJECT_IDENTITY BIGINT NOT NULL,RECIPIENT VARCHAR_IGNORECASE(100) NOT NULL,MASK INTEGER NOT NULL,CONSTRAINT UNIQUE_RECIPIENT UNIQUE(ACL_OBJECT_IDENTITY,RECIPIENT),CONSTRAINT SYS_FK_71 FOREIGN KEY(ACL_OBJECT_IDENTITY) REFERENCES ACL_OBJECT_IDENTITY(ID)) ALTER TABLE PRODUCT ADD CONSTRAINT SYS_FK_80 FOREIGN KEY(CREATE_USER_ID) REFERENCES USERS(ID) ALTER TABLE PRODUCT ADD CONSTRAINT SYS_FK_84 FOREIGN KEY(MODIFY_USER_ID) REFERENCES USERS(ID)ALTER TABLE CUSTOMER ALTER COLUMN ID RESTART WITH 1 ALTER TABLE CATEGORY ALTER COLUMN ID RESTART WITH 3 ALTER TABLE PRODUCT ALTER COLUMN ID RESTART WITH 6 ALTER TABLE ORDERS ALTER COLUMN ID RESTART WITH 5 ALTER TABLE LOG4J_LOG ALTER COLUMN ID RESTART WITH 0 ALTER TABLE USERS ALTER COLUMN ID RESTART WITH 5 ALTER TABLE ROLES ALTER COLUMN ID RESTART WITH 5 ALTER TABLE PERMISSIONS ALTER COLUMN ID RESTART WITH 17 ALTER TABLE RESOURCES ALTER COLUMN ID RESTART WITH 21 ALTER TABLE ACL_OBJECT_IDENTITY ALTER COLUMN ID RESTART WITH 2 ALTER TABLE ACL_PERMISSION ALTER COLUMN ID RESTART WITH 3 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 CATEGORY VALUES(2,'Software Design','Software Design') 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','2006-06-01',1,NULL,NULL) 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','2006-06-01',1,NULL,NULL) INSERT INTO PRODUCT VALUES(2,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','2006-06-01',1,NULL,NULL) INSERT INTO PRODUCT VALUES(3,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','2006-06-01',1,NULL,NULL) INSERT INTO PRODUCT VALUES(4,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','2006-06-01',1,NULL,NULL) INSERT INTO PRODUCT VALUES(5,1,'Programming Ruby','\u539f\u4e66\u4f5c\u8005\u662fAjaxian.com\u7684\u521b\u59cb\u4eba\uff0cJavaOne\u3001TheServerSide\u7b49\u8bf8\u591a\u9ad8\u7ea7\u522b\u4f1a\u8bae\u7684\u6f14\u8bb2\u8005\u3002\u672c\u4e66\u4f5c\u4e3aPragmatic\u7cfb\u5217\u4e4b\u4e00\uff0c\u4ece\u5b9e\u8df5\u51fa\u53d1\uff0c\u901a\u8fc7\u5b9e\u4f8b\u5c55\u793aAjax\u7684\u8bf8\u591a\u7279\u6027\uff0c\u624b\u628a\u624b\u6559\u4f60\u5b9e\u73b0Google Map\u7684\u7eda\u4e3d\u6548\u679c\u3002\u4e0d\u4ec5\u6559\u4f1a\u4f60Ajax\u7684\u6280\u672f\u7ec6\u8282\uff0c\u540c\u65f6\u8fd8\u5e26\u4f60\u4e86\u89e3\u5404\u79cd\u529f\u80fd\u5f3a\u5927\u7684\u4e3b\u6d41Ajax\u5de5\u5177\u5305\uff08Dojo\u3001Prototype\u3001Script.aculo.us\u3001DWR\u3001Backbase\u3001SmartClient\u3001Ajax.NET\u3001SAJAX\u3001JSON-RPC\uff09\uff0c\u638c\u63e1Ajax\u5b9e\u65f6\u67e5\u770b\u6e90\u4ee3\u7801\u7684\u65b9\u6cd5\u4ee5\u53ca\u8fdb\u884c\u4ee3\u7801\u8c03\u8bd5\u7684\u76f8\u5e94\u65b9\u6cd5\uff0c\u5b66\u4e60Ajax\u7684\u5f00\u53d1\u6a21\u5f0f\u548c\u6846\u67b6\u3002\u672c\u4e66\u540e\u534a\u90e8\u5206\u5171\u7528\u4e86\u4e94\u4e2a\u7ae0\u8282\uff0c\u4ece\u670d\u52a1\u5668\u7aef\u7f16\u7a0b\u7684\u89d2\u5ea6\uff0c\u8be6\u7ec6\u8bb2\u8ff0\u4e86Ajax\u540cPHP\u3001Ruby On Rails\u3001Java\u548c.NET\u7b49\u8bed\u8a00\u7684\u878d\u5408\uff0c\u6700\u540e\u8fd8\u4ecb\u7ecd\u4e86\u4e0eAjax\u76f8\u7c7b\u4f3c\u7684\u5176\u4ed6RIA\u6280\u672f\u4ee5\u53caAjax\u7684\u7cbe\u5f69\u672a\u6765\uff08E4X, Canvas, SVG,\u7684\u76f8\u5173\u5e94\u7528\uff09\u3002\u672c\u4e66\u7684\u5168\u90e8\u4ee3\u7801\u4e0b\u8f7d\u5730\u5740\uff1ahttp://media.pragprog.com/titles/ajax/code/ajax-code.zip',277,59.8,NULL,'Dave Thomas, Chad Fowler, Andy Hunt','/images/book/cover6.gif','\u7535\u5b50\u5de5\u4e1a\u51fa\u7248\u793e ','2006-07-01','book','2006-06-01',1,'2006-06-13',1) INSERT INTO PRODUCT VALUES(6,1,'Agile Web Development with Rails','\u6765\u81eaJolt Award\u9707\u64bc\u5927\u5956\u83b7\u5956\u56fe\u4e66\u7cfb\u5217Pragmatic \u4e66\u67b6.\u4f5c\u8005\u7684\u6587\u7b14\u6d41\u7545,\u5185\u5bb9\u6e05\u9192\u6613\u61c2,\u672c\u4eba\u5bf9\u81ea\u5df1\u7684\u82f1\u8bed\u4fe1\u606f\u53c8\u597d\u4e86\u4e00\u70b9\u4e86.\u76ee\u524d\u770b\u5230\u4e66\u4e2d\u7684--Building an Application\u7684shopping card\u5b9e\u73b0,\u5bf9rails\u7684control,action\u7b49\u6709\u4e86\u4e2a\u7b80\u5355\u7684\u4e86\u89e3,\u5bf9scaffold\u529f\u80fd\u80fd\u76f4\u63a5\u751f\u6210CRUD,\u771f\u4e0d\u9519.\u540c\u65f6\u4ed6\u7684seesion\u5904\u7406,error\u5904\u7406\u7b49\u90fd\u5f88\u4fbf\u5229,layout\u7b49\u4e5f\u5f88\u4e0d\u9519.\u5b83\u7684ORM\u4e5f\u5f88\u5f3a\u5927,\u5199\u7684code\u771f\u7684\u6bd4hibernate\u5c11\u591a\u4e86,\u5e76\u4e14\u6620\u5c04\u7684\u8bed\u610f\u4e5f\u5f88\u597d\u7406\u89e3.\u5982belongs_to\u7b49\u771f\u7684\u5f88\u7b80\u5355no need \u914d\u7f6e\u6587\u4ef6.\u4f5c\u4e3a\u4e00\u4e2afull stack,\u4e00\u53e5\u8bdd,\u771f\u7684\u80fd\u5f88\u5927\u7684\u52a0\u5feb\u5f00\u53d1\u901f\u5ea6.\u540c\u65f6\u4e5f\u89c4\u8303\u4e86\u5f00\u53d1\u6d41\u7a0b.\u5982test,development,delpoy\u7b49,\u7a0b\u5e8f\u76ee\u5f55\u7ed3\u6784\u4e5f\u5f88\u6e05\u6670,\u7ef4\u62a4,\u5f00\u53d1,\u6d4b\u8bd5\u90fd\u4f1a\u5f88\u65b9\u4fbf.\u503c\u5f97\u597d\u597d\u5b66\u4e60.',365,60.0,NULL,'Dave Thomas, David Hansson\u7b49','/images/book/cover7.gif','Dave Thomas, David Hansson\u7b49 ','2006-06-08','book','2006-06-13',1,NULL,NULL) INSERT INTO PRODUCT VALUES(7,2,'\u6df1\u5165\u6d45\u51fa\u8bbe\u8ba1\u6a21\u5f0f','

\u4f60\u4e0d\u60f3\u91cd\u65b0\u53d1\u660e\u8f66\u8f6e\uff08\u6216\u8005\u66f4\u5dee\u7684\u662f\uff0c\u6ca1\u6709\u5145\u6c14\u8f66\u80ce\u7684\u8f6e\u5b50\uff09\uff0c\u6240\u4ee5\u4f60\u4ece\u8bbe\u8ba1\u6a21\u5f0f\u4e2d\u5bfb\u6c42\u5e2e\u52a9——\u8bbe\u8ba1\u6a21\u5f0f\u662f\u8fc7\u53bb\u4eba\u4eec\u9762\u5bf9\u540c\u6837\u7684\u8f6f\u4ef6\u8bbe\u8ba1\u95ee\u9898\u6240\u5f97\u5230\u7684\u7ecf\u9a8c\u3002 \u6709\u4e86\u8bbe\u8ba1\u6a21\u5f0f\uff0c\u5c31\u53ef\u4ee5\u5229\u7528\u5176\u4ed6\u4eba\u7684\u5b9e\u8df5\u7ecf\u9a8c\u7684\u7cbe\u534e\uff0c\u56e0\u6b64\u7701\u4e0b\u7684\u65f6\u95f4\u53ef\u4ee5\u7528\u5728\u5176\u4ed6\u7684\u4e8b\u60c5\u4e0a\uff0c\u5982\uff1a\u66f4\u6709\u6311\u6218\u6027\u7684\u4e8b\u60c5\u3001\u66f4\u590d\u6742\u7684\u4e8b\u60c5\u4ee5\u53ca\u66f4\u6709\u8da3\u7684\u4e8b\u60c5\u3002\u4f60\u60f3\u8981\u5b66\u4e60\uff1a
\u000d\u000a·\u91cd\u8981\u7684\u6a21\u5f0f
\u000d\u000a·\u4f55\u65f6\u4f7f\u7528\u67d0\u4e2a\u6a21\u5f0f\uff0c\u4e3a\u4f55\u4f7f\u7528\u8be5\u6a21\u5f0f
\u000d\u000a·\u5982\u4f55\u5728\u4f60\u81ea\u5df1\u7684\u8bbe\u8ba1\u4e2d\u9a6c\u4e0a\u91c7\u7528\u8fd9\u4e9b\u6a21\u5f0f
\u000d\u000a·\u4f55\u65f6\u4e0d\u8be5\u4f7f\u7528\u8be5\u6a21\u5f0f\uff08\u5982\u4f55\u907f\u514d\u6ee5\u7528\u6a21\u5f0f\uff09
\u000d\u000a·\u67d0\u4e2a\u6a21\u5f0f\u662f\u4f9d\u636e\u54ea\u4e9b\u9762\u5411\u5bf9\u8c61\u8bbe\u8ba1\u539f\u7406\u800c\u8bbe\u8ba1\u51fa\u6765\u7684
\u000d\u000a\u66f4\u91cd\u8981\u7684\u662f\uff0c\u4f60\u60f3\u5728\u5b66\u4e60\u8bbe\u8ba1\u6a21\u5f0f\u7684\u8fc7\u7a0b\u4e2d\uff0c\u4e0d\u611f\u89c9\u5230\u660f\u660f\u6b32\u7761\u3002\u5982\u679c\u4f60\u66fe\u7ecf\u8bfb\u8fc7\u4efb\u4f55\u4e00\u672c\u6df1\u5165\u6d45\u51fa\uff08Head First\uff09\u7cfb\u5217\u4e66\u7c4d\uff0c\u4f60\u5c31\u4f1a\u77e5\u9053\u80fd\u591f\u4ece\u672c\u4e66\u4e2d\u5f97\u5230\u7684\u662f\uff1a\u900f\u8fc7\u4e30\u5bcc\u7684\u89c6\u89c9\u6548\u679c\u8ba9\u4f60\u7684\u5927\u8111\u5145\u5206\u5730\u8fd0\u4f5c\u3002\u672c\u4e66\u7684\u7f16\u5199\u8fd0\u7528\u8bb8\u591a\u6700\u65b0\u7684\u7814\u7a76\uff0c\u5305\u62ec\u795e\u7ecf\u751f\u7269\u5b66\u3001\u8ba4\u77e5\u79d1\u5b66\u4ee5\u53ca\u5b66\u4e60\u7406\u8bba\uff0c\u8fd9\u4f7f\u5f97\u8fd9\u672c\u4e66\u80fd\u591f\u5c06\u8fd9\u4e9b\u8bbe\u8ba1\u6a21\u5f0f\u6df1\u6df1\u5730\u70d9\u5370\u5728\u4f60\u7684\u8111\u6d77\u4e2d\uff0c\u4e0d\u5bb9\u6613\u88ab\u9057\u5fd8\u3002\u4f60\u5c06\u4f1a\u66f4\u64c5\u957f\u4e8e\u89e3\u51b3\u8f6f\u4ef6\u8bbe\u8ba1\u4e2d\u7684\u95ee\u9898\uff0c\u5e76\u80fd\u591f\u548c\u4f60\u7684\u56e2\u961f\u6210\u5458\u7528\u6a21\u5f0f\u7684\u8bed\u8a00\u6765\u66f4\u597d\u5730\u6c9f\u901a\u3002

',50,98.0,NULL,'\uff08\u7f8e\uff09Elisabeth Freeman,Eric Freeman','/images/book/cover8.gif','\u4e1c\u5357\u5927\u5b66\u51fa\u7248\u793e ','2006-06-09','book','2006-06-13',1,NULL,NULL) INSERT INTO PRODUCT VALUES(8,2,'\u8fc7\u7a0b\u6539\u8fdb\u4e0eCMM\u5b9e\u8df5\u95ee\u7b54','\u672c\u4e66\u4ee5\u95ee\u7b54\u7684\u5f62\u5f0f\uff0c\u52065\u4e2a\u4e13\u9898\u8be6\u7ec6\u4ecb\u7ecd\u4e86\u8f6f\u4ef6\u8fc7\u7a0b\u6539\u8fdb\u5b9e\u8df5\u4e2d\u7684\u65b9\u65b9\u9762\u9762\uff0c\u4ee5\u4e13\u9898\u63a2\u8ba8\u7684\u5f62\u5f0f\u8ba9\u8bfb\u8005\u8f7b\u677e\u5730\u7814\u4e60\u548c\u8fd0\u7528\u8fd9\u4e9b\u6750\u6599\u3002.
\u000d\u000a\u4f5c\u8005John Vu\u5148\u751f\u662f\u7f8e\u56fd\u6ce2\u97f3\u516c\u53f8\u9996\u5e2d\u5de5\u7a0b\u5e08(Chief Engineer)\u548c\u9ad8\u7ea7\u6280\u672f\u6210\u5458(Technical Fellow)\uff0c\u4ee5\u53ca\u5361\u5185\u57fa\u6885\u9686\u5927\u5b66\u56fd\u9645\u8f6f\u4ef6\u7814\u7a76\u9662\u7684\u8d44\u6df1\u79d1\u5b66\u5bb6\u3002\u5728\u8fc7\u53bb\u768415\u5e74\u4e2d\u5168\u4e16\u754c\u7684\u8f6f\u4ef6\u5b9e\u8df5\u8005\u5411\u4f5c\u8005\u63d0\u51fa\u4e86\u6570\u4ee5\u767e\u8ba1\u7684\u95ee\u9898\uff0c\u8981\u6c42\u6307\u70b9\u3002\u6b64\u4e66\u662f\u4f5c\u8005\u5bf9\u8fd9\u4e9b\u95ee\u9898\u56de\u7b54\u7684\u6c47\u603b\u548c\u63d0\u70bc\u3002\u4e0e\u4e13\u6ce8\u4e8e\u8f6f\u4ef6\u8fc7\u7a0b\u6539\u8fdb\u7406\u8bba\u7684\u76f8\u5173\u8457\u4f5c\u4e0d\u540c\uff0c\u4f5c\u8005\u4ee5\u4ed625\u5e74\u6765\u5b9e\u65bd\u548c\u8bb2\u6388\u8f6f\u4ef6\u8fc7\u7a0b\u6539\u8fdb\u7684\u7ecf\u9a8c\u4e3a\u8bfb\u8005\u63d0\u4f9b\u4e86\u7b80\u77ed\u6613\u61c2\u7684\u5b9e\u7528\u6307\u5bfc\u3002\u672c\u4e66\u6c47\u96c6\u4e86\u4f5c\u8005\u4f5c\u4e3a\u6ce2\u97f3\u516c\u53f8\u9996\u5e2d\u5de5\u7a0b\u5e08\u591a\u5e74\u79ef\u7d2f\u7684\u5927\u578b\u8f6f\u4ef6\u9879\u76ee\u5f00\u53d1\u548c\u7ba1\u7406\u7ecf\u9a8c\uff0c\u7279\u522b\u662f\u5728\u4f01\u4e1a\u4e2d\u5b9e\u65bdCMM\u65b9\u9762\u7684\u4e30\u5bcc\u77e5\u8bc6\u3002\u4e66\u4e2d\u5c55\u73b0\u4e86\u4f5c\u8005\u5728\u8f6f\u4ef6\u8fc7\u7a0b\u6539\u8fdb\u5b9e\u8df5\u4e4b\u8def\u4e0a\u7684\u771f\u77e5\u707c\u89c1\uff0c\u5185\u5bb9\u4e30\u5bcc\u3001\u7fd4\u5b9e\uff0c\u6d89\u53ca\u8fc7\u7a0b\u6539\u8fdb\u7684\u7406\u89e3\u3001\u7ba1\u7406\u3001\u5b9e\u65bd\uff0c\u4ee5\u53ca\u4e3b\u8981\u7684\u65b9\u6cd5\u8bba\u3001\u6a21\u578b\u3001\u5de5\u5177\u548c\u6848\u4f8b\u7814\u7a76\u7b49\u3002..
\u000d\u000a\u672c\u4e66\u5bf9\u4e8eIT\u4e13\u4e1a\u6280\u672f\u4eba\u5458\u3001\u8f6f\u4ef6\u5de5\u7a0b\u5b9e\u8df5\u8005\u6781\u5bcc\u53c2\u8003\u4ef7\u503c\uff0c\u540c\u65f6\u4e5f\u9002\u5408\u8f6f\u4ef6\u516c\u53f8\u9ad8\u5c42\u7ba1\u7406\u4eba\u5458\u53ca\u8f6f\u4ef6\u5de5\u7a0b\u7814\u7a76\u4eba\u5458\u9605\u8bfb\u3002',306,45.0,NULL,'\u4eba\u6c11\u90ae\u7535\u51fa\u7248\u793e ','/images/book/cover9.gif','\u4eba\u6c11\u90ae\u7535\u51fa\u7248\u793e ','2006-06-03','book','2006-06-13',1,NULL,NULL) INSERT INTO ORDERS VALUES(0,0,'2006-01-27',157.8,NULL,NULL,'\u5e7f\u5dde\u6c5f\u5357\u897f\u8def\u7d2b\u9f99\u5927\u8857101\u53f7401',NULL,'1') INSERT INTO ORDERS VALUES(1,0,'2006-01-27',470.4,NULL,NULL,'\u5e7f\u5dde\u5e02\u5317\u4eac\u8def39\u53f7','2006-02-01','2') INSERT INTO ORDERS VALUES(2,0,'2006-01-27',119.0,NULL,NULL,'\u5e7f\u5dde\u5929\u6cb3\u5317\u8def18\u53f7105','2006-02-03','2') INSERT INTO ORDERS VALUES(3,0,'2006-01-27',236.8,NULL,NULL,'\u5e7f\u5dde\u4e94\u5c71\u8def101\u53f7501',NULL,'1') INSERT INTO ORDERS VALUES(4,0,'2006-01-27',284.4,NULL,NULL,'\u5e7f\u5dde\u8d77\u4e49\u8def\u5927\u65b0\u885732\u53f7201',NULL,'1') INSERT INTO ORDER_ITEM VALUES(0,0,1,1000,59.8) INSERT INTO ORDER_ITEM VALUES(0,1,3,1,28.0) INSERT INTO ORDER_ITEM VALUES(0,2,4,2,35.0) INSERT INTO ORDER_ITEM VALUES(1,0,0,2,65.0) INSERT INTO ORDER_ITEM VALUES(1,1,1,3,59.8) INSERT INTO ORDER_ITEM VALUES(1,2,2,1,28.0) INSERT INTO ORDER_ITEM VALUES(1,3,3,1,35.0) INSERT INTO ORDER_ITEM VALUES(1,4,4,2,49.0) INSERT INTO ORDER_ITEM VALUES(2,0,1,2,35.0) INSERT INTO ORDER_ITEM VALUES(2,1,2,1,49.0) INSERT INTO ORDER_ITEM VALUES(3,0,1,1,59.8) INSERT INTO ORDER_ITEM VALUES(3,1,0,1,65.0) INSERT INTO ORDER_ITEM VALUES(3,2,2,1,28.0) INSERT INTO ORDER_ITEM VALUES(3,3,3,1,35.0) INSERT INTO ORDER_ITEM VALUES(3,4,4,1,49.0) INSERT INTO ORDER_ITEM VALUES(4,0,1,3,59.8) INSERT INTO ORDER_ITEM VALUES(4,1,3,2,28.0) INSERT INTO USERS VALUES(1,'admin','21232f297a57a5a743894a0e4a801fc3','A\u8001\u677f','boss@springside.org.cn','1') INSERT INTO USERS VALUES(2,'parttime','ed50a7dc0da2c939c92a7148a1fd4b25','A\u517c\u804c','hendy@springside.org.cn','1') INSERT INTO ROLES VALUES(1,'ADMIN','\u7ba1\u7406\u5458') INSERT INTO ROLES VALUES(2,'PARTTIME','\u517c\u804c\u4eba\u5458') INSERT INTO USER_ROLE VALUES(1,1) INSERT INTO USER_ROLE VALUES(2,2) INSERT INTO PERMISSIONS VALUES(1,'AUTH_BOOK_MANAGE','','\u56fe\u4e66\u7ba1\u7406 \u65b0\u589e/\u4fee\u6539/\u5220\u9664','1') INSERT INTO PERMISSIONS VALUES(2,'AUTH_ORDER_SHIP','','\u8ba2\u5355\u7ba1\u7406 \u53d1\u8d27','1') INSERT INTO PERMISSIONS VALUES(3,'AUTH_USER_MANAGE','','\u7528\u6237\u7ba1\u7406 \u65b0\u589e/\u4fee\u6539/\u5220\u9664/\u8d4b\u89d2\u8272','1') INSERT INTO PERMISSIONS VALUES(4,'AUTH_ROLE_MANAGE','','\u89d2\u8272\u7ba1\u7406 \u65b0\u589e/\u4fee\u6539/\u5220\u9664/\u8d4b\u6743\u9650','1') INSERT INTO PERMISSIONS VALUES(5,'AUTH_AUTHORITY_MANAGE','','\u6743\u9650\u7ba1\u7406 \u65b0\u589e/\u4fee\u6539/\u5220\u9664/\u8d4b\u8d44\u6e90','1') INSERT INTO PERMISSIONS VALUES(6,'AUTH_RESOURCE_MANAGE','','\u8d44\u6e90\u7ba1\u7406 \u65b0\u589e/\u4fee\u6539/\u5220\u9664','1') INSERT INTO PERMISSIONS VALUES(8,'AUTH_ADMIN_LOGIN','','\u540e\u53f0\u7ba1\u7406 \u8fdb\u5165','1') INSERT INTO PERMISSIONS VALUES(9,'AUTH_BOOKMANAGE_LOGIN','','\u56fe\u4e66\u7ba1\u7406 \u8fdb\u5165','1') INSERT INTO PERMISSIONS VALUES(10,'AUTH_REPORT_LOGIN','','\u62a5\u8868\u7cfb\u7edf \u8fdb\u5165','1') INSERT INTO PERMISSIONS VALUES(11,'AUTH_WEBWORK_ADMIN_LOGIN','','\u62a5\u8868\u7cfb\u7edf \u8fdb\u5165','1') INSERT INTO PERMISSIONS VALUES(12,'ACL_READ','','\u5355\u72ec\u8ba2\u5355\u7ba1\u7406 \u9605\u8bfb ','1') INSERT INTO PERMISSIONS VALUES(13,'ACL_DELETE','','\u5355\u72ec\u8ba2\u5355\u7ba1\u7406 \u5220\u9664','1') INSERT INTO PERMISSIONS VALUES(14,'ACL_ADMIN','','\u5355\u72ec\u8ba2\u5355\u7ba1\u7406 \u7ef4\u62a4\u5bdf\u770b','1') INSERT INTO PERMISSIONS VALUES(15,'AFTER_ACL_CREAT','','\u8ba2\u5355\u6574\u52a0\u540e ACL\u6743\u9650\u521b\u5efa','1') INSERT INTO PERMISSIONS VALUES(16,'ROLE_ANONYMOUS','','\u533f\u540d\u7528\u6237\u767b\u5f55','1') INSERT INTO ROLE_PERMIS VALUES(1,1) INSERT INTO ROLE_PERMIS VALUES(1,2) INSERT INTO ROLE_PERMIS VALUES(1,3) INSERT INTO ROLE_PERMIS VALUES(1,4) INSERT INTO ROLE_PERMIS VALUES(1,5) INSERT INTO ROLE_PERMIS VALUES(1,6) INSERT INTO ROLE_PERMIS VALUES(1,8) INSERT INTO ROLE_PERMIS VALUES(1,9) INSERT INTO ROLE_PERMIS VALUES(1,10) INSERT INTO ROLE_PERMIS VALUES(2,2) INSERT INTO ROLE_PERMIS VALUES(2,8) INSERT INTO ROLE_PERMIS VALUES(2,9) INSERT INTO RESOURCES VALUES(1,'\u4fdd\u5b58\u56fe\u4e66','FUNCTION','org.springside.bookstore.service.logic.BookManager.save','') INSERT INTO RESOURCES VALUES(2,'\u5220\u9664\u56fe\u4e66','FUNCTION','org.springside.bookstore.service.logic.BookManager.remove','') INSERT INTO RESOURCES VALUES(3,'\u53d1\u9001\u8ba2\u5355','FUNCTION','org.springside.bookstore.service.logic.OrderManager.shipOrder','') INSERT INTO RESOURCES VALUES(4,'\u4fdd\u5b58\u7528\u6237','FUNCTION','org.springside.modules.security.service.logic.UserManager.saveUser','') INSERT INTO RESOURCES VALUES(5,'\u5220\u9664\u7528\u6237','FUNCTION','org.springside.modules.security.service.logic.UserManager.removeUser','') INSERT INTO RESOURCES VALUES(6,'\u8d4b\u4e88\u89d2\u8272','FUNCTION','org.springside.modules.security.service.logic.UserManager.saveRoles','') INSERT INTO RESOURCES VALUES(7,'\u4fdd\u5b58\u89d2\u8272','FUNCTION','org.springside.modules.security.service.logic.RoleManager.saveRole','') INSERT INTO RESOURCES VALUES(8,'\u5220\u9664\u89d2\u8272','FUNCTION','org.springside.modules.security.service.logic.RoleManager.removeRole','') INSERT INTO RESOURCES VALUES(9,'\u8d4b\u4e88\u6743\u9650','FUNCTION','org.springside.modules.security.service.logic.RoleManager.savePermissions','') INSERT INTO RESOURCES VALUES(10,'\u4fdd\u5b58\u6743\u9650','FUNCTION','org.springside.modules.security.service.logic.PermissionManager.savePermission','') INSERT INTO RESOURCES VALUES(11,'\u5220\u9664\u6743\u9650','FUNCTION','org.springside.modules.security.service.logic.PermissionManager.removePermission','') INSERT INTO RESOURCES VALUES(12,'\u8d4b\u4e88\u8d44\u6e90','FUNCTION','org.springside.modules.security.service.logic.PermissionManager.saveResources','') INSERT INTO RESOURCES VALUES(13,'\u4fdd\u5b58\u8d44\u6e90','FUNCTION','org.springside.modules.security.service.logic.ResourceManager.saveResource','') INSERT INTO RESOURCES VALUES(14,'\u5220\u9664\u8d44\u6e90','FUNCTION','org.springside.modules.security.service.logic.ResourceManager.removeResource','') INSERT INTO RESOURCES VALUES(15,'\u8fdb\u5165\u62a5\u8868','URL','/report/**','') INSERT INTO RESOURCES VALUES(16,'\u8fdb\u5165\u56fe\u4e66\u7ba1\u7406','URL','/admin/book.do*','') INSERT INTO RESOURCES VALUES(17,'\u8fdb\u5165\u540e\u53f0\u7ba1\u7406','URL','/admin/**','') INSERT INTO RESOURCES VALUES(18,'Webwork Admin','URL','/ww/admin/**','') INSERT INTO RESOURCES VALUES(19,'\u5220\u9664\u8ba2\u5355','FUNCTION','org.springside.bookstore.service.logic.OrderManager.removeOrder','') INSERT INTO PERMIS_RESC VALUES(1,1) INSERT INTO PERMIS_RESC VALUES(1,2) INSERT INTO PERMIS_RESC VALUES(2,3) INSERT INTO PERMIS_RESC VALUES(3,4) INSERT INTO PERMIS_RESC VALUES(3,5) INSERT INTO PERMIS_RESC VALUES(3,6) INSERT INTO PERMIS_RESC VALUES(4,7) INSERT INTO PERMIS_RESC VALUES(4,8) INSERT INTO PERMIS_RESC VALUES(4,9) INSERT INTO PERMIS_RESC VALUES(5,10) INSERT INTO PERMIS_RESC VALUES(5,11) INSERT INTO PERMIS_RESC VALUES(5,17) INSERT INTO PERMIS_RESC VALUES(5,18) INSERT INTO PERMIS_RESC VALUES(6,12) INSERT INTO PERMIS_RESC VALUES(6,13) INSERT INTO PERMIS_RESC VALUES(8,17) INSERT INTO PERMIS_RESC VALUES(9,16) INSERT INTO PERMIS_RESC VALUES(10,15) INSERT INTO PERMIS_RESC VALUES(11,18) INSERT INTO PERMIS_RESC VALUES(13,19) INSERT INTO ACL_OBJECT_IDENTITY VALUES(1,'org.springside.bookstore.domain.Order:4',NULL,'org.acegisecurity.acl.basic.SimpleAclEntry') INSERT INTO ACL_PERMISSION VALUES(1,1,'parttime',2) INSERT INTO ACL_PERMISSION VALUES(2,1,'admin',1)