CREATE SCHEMA PUBLIC AUTHORIZATION DBA CREATE MEMORY TABLE SS_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 SS_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 SS_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 SS_CATEGORY(ID)) CREATE MEMORY TABLE SS_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,ORIGINALPRICE DECIMAL(10,2),APPLYRULES VARCHAR(255),REGION VARCHAR(255),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 SS_CUSTOMER(ID)) CREATE MEMORY TABLE SS_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 SS_ORDERS(ID),CONSTRAINT FK_ITEM_2 FOREIGN KEY(PRODUCT_ID) REFERENCES SS_PRODUCT(ID)) CREATE MEMORY TABLE SS_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 SS_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),REGION VARCHAR(255),STATUS VARCHAR(2) DEFAULT '1',DESCN VARCHAR(255),CONSTRAINT PK_USERS PRIMARY KEY(ID)) CREATE MEMORY TABLE SS_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 SS_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 SS_USERS(ID),CONSTRAINT FK_USER_ROLE_2 FOREIGN KEY(ROLE_ID) REFERENCES SS_ROLES(ID)) CREATE MEMORY TABLE SS_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 SS_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 SS_ROLES(ID),CONSTRAINT FK_ROLE_ROLE_PERMIS_2 FOREIGN KEY(PERMIS_ID) REFERENCES SS_PERMISSIONS(ID)) CREATE MEMORY TABLE SS_MODULES(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,PARENT_ID INTEGER NOT NULL,TITLE VARCHAR(255) NOT NULL,DESCN VARCHAR(255),ACTIVE INTEGER DEFAULT 1 NOT NULL,CONSTRAINT PK_MODULES PRIMARY KEY(ID),CONSTRAINT FK_MODULES_1 FOREIGN KEY(PARENT_ID) REFERENCES SS_MODULES(ID)) CREATE MEMORY TABLE SS_RESOURCES(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL,NAME VARCHAR(80) NOT NULL,MODULE_ID INTEGER NOT NULL,RES_TYPE VARCHAR(20) NOT NULL,RES_STRING VARCHAR(255) NOT NULL,DESCN VARCHAR(255),CONSTRAINT PK_RESOURCES PRIMARY KEY(ID),CONSTRAINT FK_RESOURCE_1 FOREIGN KEY(MODULE_ID) REFERENCES SS_MODULES(ID)) CREATE MEMORY TABLE SS_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 SS_RESOURCES(ID),CONSTRAINT FK_ROLE_PERMIS_RESC_2 FOREIGN KEY(PERMIS_ID) REFERENCES SS_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)) CREATE MEMORY TABLE SS_MENU(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL,PARENT_ID INTEGER,SEQ INTEGER DEFAULT 1,TITLE VARCHAR(255) NOT NULL,TIP VARCHAR(255),DESCN VARCHAR(255),IMAGE VARCHAR(255),FORWARD VARCHAR(255),TARGET VARCHAR(255),CONSTRAINT PK_MENU PRIMARY KEY(ID),CONSTRAINT FK_MENU_1 FOREIGN KEY(PARENT_ID) REFERENCES SS_MENU(ID)) CREATE MEMORY TABLE SS_MENU_ROLE(ROLE_ID INTEGER NOT NULL,MENU_ID INTEGER NOT NULL,CONSTRAINT PK_MENU_ROLE PRIMARY KEY(ROLE_ID,MENU_ID),CONSTRAINT FK_MENU_ROLE_1 FOREIGN KEY(ROLE_ID) REFERENCES SS_ROLES(ID),CONSTRAINT FK_MENU_ROLE_2 FOREIGN KEY(MENU_ID) REFERENCES SS_MENU(ID)) CREATE MEMORY TABLE SS_PRODUCTTAG (ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL, PRODUCT_ID INTEGER NOT NULL, USER_ID INTEGER NOT NULL, TAG VARCHAR(50) NOT NULL, CONSTRAINT PK_PRODUCTTAG PRIMARY KEY(ID)) ALTER TABLE SS_PRODUCT ADD CONSTRAINT SYS_FK_80 FOREIGN KEY(CREATE_USER_ID) REFERENCES SS_USERS(ID) ALTER TABLE SS_PRODUCT ADD CONSTRAINT SYS_FK_84 FOREIGN KEY(MODIFY_USER_ID) REFERENCES SS_USERS(ID) ALTER TABLE SS_PRODUCTTAG ADD CONSTRAINT FK_PRODUCTTAG_PRODUCT FOREIGN KEY(PRODUCT_ID) REFERENCES SS_PRODUCT (ID) ALTER TABLE SS_PRODUCTTAG ADD CONSTRAINT FK_PRODUCTTAG_USER FOREIGN KEY(USER_ID) REFERENCES SS_USERS (ID) ALTER TABLE SS_CUSTOMER ALTER COLUMN ID RESTART WITH 1 ALTER TABLE SS_CATEGORY ALTER COLUMN ID RESTART WITH 3 ALTER TABLE SS_PRODUCT ALTER COLUMN ID RESTART WITH 9 ALTER TABLE SS_ORDERS ALTER COLUMN ID RESTART WITH 5 ALTER TABLE SS_LOG4J_LOG ALTER COLUMN ID RESTART WITH 0 ALTER TABLE SS_USERS ALTER COLUMN ID RESTART WITH 5 ALTER TABLE SS_ROLES ALTER COLUMN ID RESTART WITH 5 ALTER TABLE SS_PERMISSIONS ALTER COLUMN ID RESTART WITH 20 ALTER TABLE SS_MODULES ALTER COLUMN ID RESTART WITH 15 ALTER TABLE SS_RESOURCES ALTER COLUMN ID RESTART WITH 24 ALTER TABLE ACL_OBJECT_IDENTITY ALTER COLUMN ID RESTART WITH 6 ALTER TABLE ACL_PERMISSION ALTER COLUMN ID RESTART WITH 6 ALTER TABLE SS_MENU ALTER COLUMN ID RESTART WITH 17 create table JBPM_ACTION (ID_ bigint generated by default as identity (start with 1), class char(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ bit, ACTIONEXPRESSION_ varchar(255), ISASYNC_ bit, REFERENCEDACTION_ bigint, ACTIONDELEGATION_ bigint, EVENT_ bigint, PROCESSDEFINITION_ bigint, TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ bigint, EXPRESSION_ varchar(4000), EVENTINDEX_ integer, EXCEPTIONHANDLER_ bigint, EXCEPTIONHANDLERINDEX_ integer, primary key (ID_)); create table JBPM_BYTEARRAY (ID_ bigint generated by default as identity (start with 1), NAME_ varchar(255), FILEDEFINITION_ bigint, primary key (ID_)); create table JBPM_BYTEBLOCK (PROCESSFILE_ bigint not null, BYTES_ varbinary(1024), INDEX_ integer not null, primary key (PROCESSFILE_, INDEX_)); create table JBPM_COMMENT (ID_ bigint generated by default as identity (start with 1), VERSION_ integer not null, ACTORID_ varchar(255), TIME_ timestamp, MESSAGE_ varchar(4000), TOKEN_ bigint, TASKINSTANCE_ bigint, TOKENINDEX_ integer, TASKINSTANCEINDEX_ integer, primary key (ID_)); create table JBPM_DECISIONCONDITIONS (DECISION_ bigint not null, TRANSITIONNAME_ varchar(255), EXPRESSION_ varchar(255), INDEX_ integer not null, primary key (DECISION_, INDEX_)); create table JBPM_DELEGATION (ID_ bigint generated by default as identity (start with 1), CLASSNAME_ varchar(4000), CONFIGURATION_ varchar(4000), CONFIGTYPE_ varchar(255), PROCESSDEFINITION_ bigint, primary key (ID_)); create table JBPM_EVENT (ID_ bigint generated by default as identity (start with 1), EVENTTYPE_ varchar(255), TYPE_ char(1), GRAPHELEMENT_ bigint, PROCESSDEFINITION_ bigint, NODE_ bigint, TRANSITION_ bigint, TASK_ bigint, primary key (ID_)); create table JBPM_EXCEPTIONHANDLER (ID_ bigint generated by default as identity (start with 1), EXCEPTIONCLASSNAME_ varchar(4000), TYPE_ char(1), GRAPHELEMENT_ bigint, PROCESSDEFINITION_ bigint, GRAPHELEMENTINDEX_ integer, NODE_ bigint, TRANSITION_ bigint, TASK_ bigint, primary key (ID_)); create table JBPM_ID_GROUP (ID_ bigint generated by default as identity (start with 1), CLASS_ char(1) not null, NAME_ varchar(255), TYPE_ varchar(255), PARENT_ bigint, primary key (ID_)); create table JBPM_ID_MEMBERSHIP (ID_ bigint generated by default as identity (start with 1), CLASS_ char(1) not null, NAME_ varchar(255), ROLE_ varchar(255), USER_ bigint, GROUP_ bigint, primary key (ID_)); create table JBPM_ID_PERMISSIONS (ENTITY_ bigint not null, CLASS_ varchar(255), NAME_ varchar(255), ACTION_ varchar(255)); create table JBPM_ID_USER (ID_ bigint generated by default as identity (start with 1), CLASS_ char(1) not null, NAME_ varchar(255), EMAIL_ varchar(255), PASSWORD_ varchar(255), primary key (ID_)); create table JBPM_LOG (ID_ bigint generated by default as identity (start with 1), CLASS_ char(1) not null, INDEX_ integer, DATE_ timestamp, TOKEN_ bigint, PARENT_ bigint, MESSAGE_ varchar(4000), EXCEPTION_ varchar(4000), ACTION_ bigint, NODE_ bigint, ENTER_ timestamp, LEAVE_ timestamp, DURATION_ bigint, TRANSITION_ bigint, CHILD_ bigint, SOURCENODE_ bigint, DESTINATIONNODE_ bigint, VARIABLEINSTANCE_ bigint, OLDBYTEARRAY_ bigint, NEWBYTEARRAY_ bigint, OLDDATEVALUE_ timestamp, NEWDATEVALUE_ timestamp, OLDDOUBLEVALUE_ double, NEWDOUBLEVALUE_ double, OLDLONGIDCLASS_ varchar(255), OLDLONGIDVALUE_ bigint, NEWLONGIDCLASS_ varchar(255), NEWLONGIDVALUE_ bigint, OLDSTRINGIDCLASS_ varchar(255), OLDSTRINGIDVALUE_ varchar(255), NEWSTRINGIDCLASS_ varchar(255), NEWSTRINGIDVALUE_ varchar(255), OLDLONGVALUE_ bigint, NEWLONGVALUE_ bigint, OLDSTRINGVALUE_ varchar(4000), NEWSTRINGVALUE_ varchar(4000), TASKINSTANCE_ bigint, TASKACTORID_ varchar(255), TASKOLDACTORID_ varchar(255), SWIMLANEINSTANCE_ bigint, primary key (ID_)); create table JBPM_MESSAGE (ID_ bigint generated by default as identity (start with 1), CLASS_ char(1) not null, DESTINATION_ varchar(255), EXCEPTION_ varchar(255), ISSUSPENDED_ bit, TOKEN_ bigint, TEXT_ varchar(255), ACTION_ bigint, NODE_ bigint, TRANSITIONNAME_ varchar(255), TASKINSTANCE_ bigint, primary key (ID_)); create table JBPM_MODULEDEFINITION (ID_ bigint generated by default as identity (start with 1), CLASS_ char(1) not null, NAME_ varchar(4000), PROCESSDEFINITION_ bigint, STARTTASK_ bigint, primary key (ID_)); create table JBPM_MODULEINSTANCE (ID_ bigint generated by default as identity (start with 1), CLASS_ char(1) not null, PROCESSINSTANCE_ bigint, TASKMGMTDEFINITION_ bigint, NAME_ varchar(255), primary key (ID_)); create table JBPM_NODE (ID_ bigint generated by default as identity (start with 1), CLASS_ char(1) not null, NAME_ varchar(255), PROCESSDEFINITION_ bigint, ISASYNC_ bit, ACTION_ bigint, SUPERSTATE_ bigint, SUBPROCESSDEFINITION_ bigint, DECISIONEXPRESSION_ varchar(255), DECISIONDELEGATION bigint, SIGNAL_ integer, CREATETASKS_ bit, ENDTASKS_ bit, NODECOLLECTIONINDEX_ integer, primary key (ID_)); create table JBPM_POOLEDACTOR (ID_ bigint generated by default as identity (start with 1), ACTORID_ varchar(255), SWIMLANEINSTANCE_ bigint, primary key (ID_)); create table JBPM_PROCESSDEFINITION (ID_ bigint generated by default as identity (start with 1), NAME_ varchar(255), VERSION_ integer, ISTERMINATIONIMPLICIT_ bit, STARTSTATE_ bigint, primary key (ID_)); create table JBPM_PROCESSINSTANCE (ID_ bigint generated by default as identity (start with 1), VERSION_ integer not null, START_ timestamp, END_ timestamp, ISSUSPENDED_ bit, PROCESSDEFINITION_ bigint, ROOTTOKEN_ bigint, SUPERPROCESSTOKEN_ bigint, primary key (ID_)); create table JBPM_RUNTIMEACTION (ID_ bigint generated by default as identity (start with 1), VERSION_ integer not null, EVENTTYPE_ varchar(255), TYPE_ char(1), GRAPHELEMENT_ bigint, PROCESSINSTANCE_ bigint, ACTION_ bigint, PROCESSINSTANCEINDEX_ integer, primary key (ID_)); create table JBPM_SWIMLANE (ID_ bigint generated by default as identity (start with 1), NAME_ varchar(255), ACTORIDEXPRESSION_ varchar(255), POOLEDACTORSEXPRESSION_ varchar(255), ASSIGNMENTDELEGATION_ bigint, TASKMGMTDEFINITION_ bigint, primary key (ID_)); create table JBPM_SWIMLANEINSTANCE (ID_ bigint generated by default as identity (start with 1), NAME_ varchar(255), ACTORID_ varchar(255), SWIMLANE_ bigint, TASKMGMTINSTANCE_ bigint, primary key (ID_)); create table JBPM_TASK (ID_ bigint generated by default as identity (start with 1), NAME_ varchar(255), PROCESSDEFINITION_ bigint, DESCRIPTION_ varchar(4000), ISBLOCKING_ bit, ISSIGNALLING_ bit, DUEDATE_ varchar(255), ACTORIDEXPRESSION_ varchar(255), POOLEDACTORSEXPRESSION_ varchar(255), TASKMGMTDEFINITION_ bigint, TASKNODE_ bigint, STARTSTATE_ bigint, ASSIGNMENTDELEGATION_ bigint, SWIMLANE_ bigint, TASKCONTROLLER_ bigint, primary key (ID_)); create table JBPM_TASKACTORPOOL (TASKINSTANCE_ bigint not null, POOLEDACTOR_ bigint not null, primary key (TASKINSTANCE_, POOLEDACTOR_)); create table JBPM_TASKCONTROLLER (ID_ bigint generated by default as identity (start with 1), TASKCONTROLLERDELEGATION_ bigint, primary key (ID_)); create table JBPM_TASKINSTANCE (ID_ bigint generated by default as identity (start with 1), CLASS_ char(1) not null, NAME_ varchar(255), DESCRIPTION_ varchar(4000), ACTORID_ varchar(255), CREATE_ timestamp, START_ timestamp, END_ timestamp, DUEDATE_ timestamp, PRIORITY_ integer, ISCANCELLED_ bit, ISSUSPENDED_ bit, ISOPEN_ bit, ISSIGNALLING_ bit, ISBLOCKING_ bit, TASK_ bigint, TOKEN_ bigint, SWIMLANINSTANCE_ bigint, TASKMGMTINSTANCE_ bigint, primary key (ID_)); create table JBPM_TIMER (ID_ bigint generated by default as identity (start with 1), NAME_ varchar(255), DUEDATE_ timestamp, REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), EXCEPTION_ varchar(4000), ISSUSPENDED_ bit, ACTION_ bigint, TOKEN_ bigint, PROCESSINSTANCE_ bigint, TASKINSTANCE_ bigint, GRAPHELEMENTTYPE_ varchar(255), GRAPHELEMENT_ bigint, primary key (ID_)); create table JBPM_TOKEN (ID_ bigint generated by default as identity (start with 1), VERSION_ integer not null, NAME_ varchar(255), START_ timestamp, END_ timestamp, NODEENTER_ timestamp, NEXTLOGINDEX_ integer, ISABLETOREACTIVATEPARENT_ bit, ISTERMINATIONIMPLICIT_ bit, ISSUSPENDED_ bit, NODE_ bigint, PROCESSINSTANCE_ bigint, PARENT_ bigint, SUBPROCESSINSTANCE_ bigint, primary key (ID_)); create table JBPM_TOKENVARIABLEMAP (ID_ bigint generated by default as identity (start with 1), TOKEN_ bigint, CONTEXTINSTANCE_ bigint, primary key (ID_)); create table JBPM_TRANSITION (ID_ bigint generated by default as identity (start with 1), NAME_ varchar(255), PROCESSDEFINITION_ bigint, FROM_ bigint, TO_ bigint, FROMINDEX_ integer, primary key (ID_)); create table JBPM_VARIABLEACCESS (ID_ bigint generated by default as identity (start with 1), VARIABLENAME_ varchar(255), ACCESS_ varchar(255), MAPPEDNAME_ varchar(255), PROCESSSTATE_ bigint, TASKCONTROLLER_ bigint, INDEX_ integer, SCRIPT_ bigint, primary key (ID_)); create table JBPM_VARIABLEINSTANCE (ID_ bigint generated by default as identity (start with 1), CLASS_ char(1) not null, NAME_ varchar(255), CONVERTER_ char(1), TOKEN_ bigint, TOKENVARIABLEMAP_ bigint, PROCESSINSTANCE_ bigint, BYTEARRAYVALUE_ bigint, DATEVALUE_ timestamp, DOUBLEVALUE_ double, LONGIDCLASS_ varchar(255), LONGVALUE_ bigint, STRINGIDCLASS_ varchar(255), STRINGVALUE_ varchar(255), TASKINSTANCE_ bigint, primary key (ID_)); alter table JBPM_ACTION add constraint FK_ACTION_EVENT foreign key (EVENT_) references JBPM_EVENT; alter table JBPM_ACTION add constraint FK_ACTION_EXPTHDL foreign key (EXCEPTIONHANDLER_) references JBPM_EXCEPTIONHANDLER; alter table JBPM_ACTION add constraint FK_ACTION_PROCDEF foreign key (PROCESSDEFINITION_) references JBPM_PROCESSDEFINITION; alter table JBPM_ACTION add constraint FK_CRTETIMERACT_TA foreign key (TIMERACTION_) references JBPM_ACTION; alter table JBPM_ACTION add constraint FK_ACTION_ACTNDEL foreign key (ACTIONDELEGATION_) references JBPM_DELEGATION; alter table JBPM_ACTION add constraint FK_ACTION_REFACT foreign key (REFERENCEDACTION_) references JBPM_ACTION; alter table JBPM_BYTEARRAY add constraint FK_BYTEARR_FILDEF foreign key (FILEDEFINITION_) references JBPM_MODULEDEFINITION; alter table JBPM_BYTEBLOCK add constraint FK_BYTEBLOCK_FILE foreign key (PROCESSFILE_) references JBPM_BYTEARRAY; alter table JBPM_COMMENT add constraint FK_COMMENT_TOKEN foreign key (TOKEN_) references JBPM_TOKEN; alter table JBPM_COMMENT add constraint FK_COMMENT_TSK foreign key (TASKINSTANCE_) references JBPM_TASKINSTANCE; alter table JBPM_DECISIONCONDITIONS add constraint FK_DECCOND_DEC foreign key (DECISION_) references JBPM_NODE; alter table JBPM_DELEGATION add constraint FK_DELEGATION_PRCD foreign key (PROCESSDEFINITION_) references JBPM_PROCESSDEFINITION; alter table JBPM_EVENT add constraint FK_EVENT_PROCDEF foreign key (PROCESSDEFINITION_) references JBPM_PROCESSDEFINITION; alter table JBPM_EVENT add constraint FK_EVENT_NODE foreign key (NODE_) references JBPM_NODE; alter table JBPM_EVENT add constraint FK_EVENT_TRANS foreign key (TRANSITION_) references JBPM_TRANSITION; alter table JBPM_EVENT add constraint FK_EVENT_TASK foreign key (TASK_) references JBPM_TASK; alter table JBPM_ID_GROUP add constraint FK_ID_GRP_PARENT foreign key (PARENT_) references JBPM_ID_GROUP; alter table JBPM_ID_MEMBERSHIP add constraint FK_ID_MEMSHIP_GRP foreign key (GROUP_) references JBPM_ID_GROUP; alter table JBPM_ID_MEMBERSHIP add constraint FK_ID_MEMSHIP_USR foreign key (USER_) references JBPM_ID_USER; alter table JBPM_LOG add constraint FK_LOG_SOURCENODE foreign key (SOURCENODE_) references JBPM_NODE; alter table JBPM_LOG add constraint FK_LOG_TOKEN foreign key (TOKEN_) references JBPM_TOKEN; alter table JBPM_LOG add constraint FK_LOG_OLDBYTES foreign key (OLDBYTEARRAY_) references JBPM_BYTEARRAY; alter table JBPM_LOG add constraint FK_LOG_NEWBYTES foreign key (NEWBYTEARRAY_) references JBPM_BYTEARRAY; alter table JBPM_LOG add constraint FK_LOG_CHILDTOKEN foreign key (CHILD_) references JBPM_TOKEN; alter table JBPM_LOG add constraint FK_LOG_DESTNODE foreign key (DESTINATIONNODE_) references JBPM_NODE; alter table JBPM_LOG add constraint FK_LOG_TASKINST foreign key (TASKINSTANCE_) references JBPM_TASKINSTANCE; alter table JBPM_LOG add constraint FK_LOG_SWIMINST foreign key (SWIMLANEINSTANCE_) references JBPM_SWIMLANEINSTANCE; alter table JBPM_LOG add constraint FK_LOG_PARENT foreign key (PARENT_) references JBPM_LOG; alter table JBPM_LOG add constraint FK_LOG_NODE foreign key (NODE_) references JBPM_NODE; alter table JBPM_LOG add constraint FK_LOG_ACTION foreign key (ACTION_) references JBPM_ACTION; alter table JBPM_LOG add constraint FK_LOG_VARINST foreign key (VARIABLEINSTANCE_) references JBPM_VARIABLEINSTANCE; alter table JBPM_LOG add constraint FK_LOG_TRANSITION foreign key (TRANSITION_) references JBPM_TRANSITION; alter table JBPM_MESSAGE add constraint FK_MSG_TOKEN foreign key (TOKEN_) references JBPM_TOKEN; alter table JBPM_MESSAGE add constraint FK_CMD_NODE foreign key (NODE_) references JBPM_NODE; alter table JBPM_MESSAGE add constraint FK_CMD_ACTION foreign key (ACTION_) references JBPM_ACTION; alter table JBPM_MESSAGE add constraint FK_CMD_TASKINST foreign key (TASKINSTANCE_) references JBPM_TASKINSTANCE; alter table JBPM_MODULEDEFINITION add constraint FK_TSKDEF_START foreign key (STARTTASK_) references JBPM_TASK; alter table JBPM_MODULEDEFINITION add constraint FK_MODDEF_PROCDEF foreign key (PROCESSDEFINITION_) references JBPM_PROCESSDEFINITION; alter table JBPM_MODULEINSTANCE add constraint FK_TASKMGTINST_TMD foreign key (TASKMGMTDEFINITION_) references JBPM_MODULEDEFINITION; alter table JBPM_MODULEINSTANCE add constraint FK_MODINST_PRCINST foreign key (PROCESSINSTANCE_) references JBPM_PROCESSINSTANCE; alter table JBPM_NODE add constraint FK_PROCST_SBPRCDEF foreign key (SUBPROCESSDEFINITION_) references JBPM_PROCESSDEFINITION; alter table JBPM_NODE add constraint FK_NODE_PROCDEF foreign key (PROCESSDEFINITION_) references JBPM_PROCESSDEFINITION; alter table JBPM_NODE add constraint FK_NODE_ACTION foreign key (ACTION_) references JBPM_ACTION; alter table JBPM_NODE add constraint FK_DECISION_DELEG foreign key (DECISIONDELEGATION) references JBPM_DELEGATION; alter table JBPM_NODE add constraint FK_NODE_SUPERSTATE foreign key (SUPERSTATE_) references JBPM_NODE; create index IDX_PLDACTR_ACTID on JBPM_POOLEDACTOR (ACTORID_); alter table JBPM_POOLEDACTOR add constraint FK_POOLEDACTOR_SLI foreign key (SWIMLANEINSTANCE_) references JBPM_SWIMLANEINSTANCE; alter table JBPM_PROCESSDEFINITION add constraint FK_PROCDEF_STRTSTA foreign key (STARTSTATE_) references JBPM_NODE; alter table JBPM_PROCESSINSTANCE add constraint FK_PROCIN_PROCDEF foreign key (PROCESSDEFINITION_) references JBPM_PROCESSDEFINITION; alter table JBPM_PROCESSINSTANCE add constraint FK_PROCIN_ROOTTKN foreign key (ROOTTOKEN_) references JBPM_TOKEN; alter table JBPM_PROCESSINSTANCE add constraint FK_PROCIN_SPROCTKN foreign key (SUPERPROCESSTOKEN_) references JBPM_TOKEN; alter table JBPM_RUNTIMEACTION add constraint FK_RTACTN_PROCINST foreign key (PROCESSINSTANCE_) references JBPM_PROCESSINSTANCE; alter table JBPM_RUNTIMEACTION add constraint FK_RTACTN_ACTION foreign key (ACTION_) references JBPM_ACTION; alter table JBPM_SWIMLANE add constraint FK_SWL_ASSDEL foreign key (ASSIGNMENTDELEGATION_) references JBPM_DELEGATION; alter table JBPM_SWIMLANE add constraint FK_SWL_TSKMGMTDEF foreign key (TASKMGMTDEFINITION_) references JBPM_MODULEDEFINITION; alter table JBPM_SWIMLANEINSTANCE add constraint FK_SWIMLANEINST_TM foreign key (TASKMGMTINSTANCE_) references JBPM_MODULEINSTANCE; alter table JBPM_SWIMLANEINSTANCE add constraint FK_SWIMLANEINST_SL foreign key (SWIMLANE_) references JBPM_SWIMLANE; alter table JBPM_TASK add constraint FK_TSK_TSKCTRL foreign key (TASKCONTROLLER_) references JBPM_TASKCONTROLLER; alter table JBPM_TASK add constraint FK_TASK_ASSDEL foreign key (ASSIGNMENTDELEGATION_) references JBPM_DELEGATION; alter table JBPM_TASK add constraint FK_TASK_TASKNODE foreign key (TASKNODE_) references JBPM_NODE; alter table JBPM_TASK add constraint FK_TASK_PROCDEF foreign key (PROCESSDEFINITION_) references JBPM_PROCESSDEFINITION; alter table JBPM_TASK add constraint FK_TASK_STARTST foreign key (STARTSTATE_) references JBPM_NODE; alter table JBPM_TASK add constraint FK_TASK_TASKMGTDEF foreign key (TASKMGMTDEFINITION_) references JBPM_MODULEDEFINITION; alter table JBPM_TASK add constraint FK_TASK_SWIMLANE foreign key (SWIMLANE_) references JBPM_SWIMLANE; alter table JBPM_TASKACTORPOOL add constraint FK_TSKACTPOL_PLACT foreign key (POOLEDACTOR_) references JBPM_POOLEDACTOR; alter table JBPM_TASKACTORPOOL add constraint FK_TASKACTPL_TSKI foreign key (TASKINSTANCE_) references JBPM_TASKINSTANCE; alter table JBPM_TASKCONTROLLER add constraint FK_TSKCTRL_DELEG foreign key (TASKCONTROLLERDELEGATION_) references JBPM_DELEGATION; create index IDX_TASK_ACTORID on JBPM_TASKINSTANCE (ACTORID_); alter table JBPM_TASKINSTANCE add constraint FK_TASKINST_TMINST foreign key (TASKMGMTINSTANCE_) references JBPM_MODULEINSTANCE; alter table JBPM_TASKINSTANCE add constraint FK_TASKINST_TOKEN foreign key (TOKEN_) references JBPM_TOKEN; alter table JBPM_TASKINSTANCE add constraint FK_TASKINST_SLINST foreign key (SWIMLANINSTANCE_) references JBPM_SWIMLANEINSTANCE; alter table JBPM_TASKINSTANCE add constraint FK_TASKINST_TASK foreign key (TASK_) references JBPM_TASK; alter table JBPM_TIMER add constraint FK_TIMER_TOKEN foreign key (TOKEN_) references JBPM_TOKEN; alter table JBPM_TIMER add constraint FK_TIMER_PRINST foreign key (PROCESSINSTANCE_) references JBPM_PROCESSINSTANCE; alter table JBPM_TIMER add constraint FK_TIMER_ACTION foreign key (ACTION_) references JBPM_ACTION; alter table JBPM_TIMER add constraint FK_TIMER_TSKINST foreign key (TASKINSTANCE_) references JBPM_TASKINSTANCE; alter table JBPM_TOKEN add constraint FK_TOKEN_PARENT foreign key (PARENT_) references JBPM_TOKEN; alter table JBPM_TOKEN add constraint FK_TOKEN_NODE foreign key (NODE_) references JBPM_NODE; alter table JBPM_TOKEN add constraint FK_TOKEN_PROCINST foreign key (PROCESSINSTANCE_) references JBPM_PROCESSINSTANCE; alter table JBPM_TOKEN add constraint FK_TOKEN_SUBPI foreign key (SUBPROCESSINSTANCE_) references JBPM_PROCESSINSTANCE; alter table JBPM_TOKENVARIABLEMAP add constraint FK_TKVARMAP_CTXT foreign key (CONTEXTINSTANCE_) references JBPM_MODULEINSTANCE; alter table JBPM_TOKENVARIABLEMAP add constraint FK_TKVARMAP_TOKEN foreign key (TOKEN_) references JBPM_TOKEN; alter table JBPM_TRANSITION add constraint FK_TRANSITION_TO foreign key (TO_) references JBPM_NODE; alter table JBPM_TRANSITION add constraint FK_TRANS_PROCDEF foreign key (PROCESSDEFINITION_) references JBPM_PROCESSDEFINITION; alter table JBPM_TRANSITION add constraint FK_TRANSITION_FROM foreign key (FROM_) references JBPM_NODE; alter table JBPM_VARIABLEACCESS add constraint FK_VARACC_TSKCTRL foreign key (TASKCONTROLLER_) references JBPM_TASKCONTROLLER; alter table JBPM_VARIABLEACCESS add constraint FK_VARACC_SCRIPT foreign key (SCRIPT_) references JBPM_ACTION; alter table JBPM_VARIABLEACCESS add constraint FK_VARACC_PROCST foreign key (PROCESSSTATE_) references JBPM_NODE; alter table JBPM_VARIABLEINSTANCE add constraint FK_VARINST_TK foreign key (TOKEN_) references JBPM_TOKEN; alter table JBPM_VARIABLEINSTANCE add constraint FK_VARINST_TKVARMP foreign key (TOKENVARIABLEMAP_) references JBPM_TOKENVARIABLEMAP; alter table JBPM_VARIABLEINSTANCE add constraint FK_VARINST_PRCINST foreign key (PROCESSINSTANCE_) references JBPM_PROCESSINSTANCE; alter table JBPM_VARIABLEINSTANCE add constraint FK_VAR_TSKINST foreign key (TASKINSTANCE_) references JBPM_TASKINSTANCE; alter table JBPM_VARIABLEINSTANCE add constraint FK_BYTEINST_ARRAY foreign key (BYTEARRAYVALUE_) references JBPM_BYTEARRAY; CREATE USER SA PASSWORD "" GRANT DBA TO SA SET WRITE_DELAY 60 SET SCHEMA PUBLIC INSERT INTO SS_CUSTOMER VALUES(0,'demo','demo','demo','demo@springside.org.cn','Demo Adress',NULL) INSERT INTO SS_CATEGORY VALUES(0,'Java','Java Book') INSERT INTO SS_CATEGORY VALUES(1,'Ruby','Ruby Book') INSERT INTO SS_CATEGORY VALUES(2,'Software Design','Software Design') INSERT INTO SS_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 SS_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 SS_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 SS_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 SS_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 SS_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 SS_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 SS_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 SS_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 SS_ORDERS VALUES(0,0,'2006-01-27',59968.0,59968.0,NULL,'GZ','\u5e7f\u5dde\u6c5f\u5357\u897f\u8def\u7d2b\u9f99\u5927\u8857101\u53f7401',NULL,'1') INSERT INTO SS_ORDERS VALUES(1,0,'2006-01-27',500.0,500.0,NULL,'BJ','\u5e7f\u5dde\u5e02\u5317\u4eac\u8def39\u53f7','2006-02-01','2') INSERT INTO SS_ORDERS VALUES(2,0,'2006-01-27',99.0,100.0,NULL,'GZ','\u5e7f\u5dde\u5929\u6cb3\u5317\u8def18\u53f7105','2006-02-03','2') INSERT INTO SS_ORDERS VALUES(3,0,'2006-01-27',236.8,236.8,NULL,'BJ','\u5e7f\u5dde\u4e94\u5c71\u8def101\u53f7501',NULL,'1') INSERT INTO SS_ORDERS VALUES(4,0,'2006-01-27',284.4,284.4,NULL,'GZ','\u5e7f\u5dde\u8d77\u4e49\u8def\u5927\u65b0\u885732\u53f7201',NULL,'1') INSERT INTO SS_ORDER_ITEM VALUES(0,0,1,1000,59.8) INSERT INTO SS_ORDER_ITEM VALUES(0,1,3,1,28.0) INSERT INTO SS_ORDER_ITEM VALUES(0,2,4,2,35.0) INSERT INTO SS_ORDER_ITEM VALUES(1,0,0,2,65.0) INSERT INTO SS_ORDER_ITEM VALUES(1,1,1,3,59.8) INSERT INTO SS_ORDER_ITEM VALUES(1,2,2,1,28.0) INSERT INTO SS_ORDER_ITEM VALUES(1,3,3,1,35.0) INSERT INTO SS_ORDER_ITEM VALUES(1,4,4,2,49.0) INSERT INTO SS_ORDER_ITEM VALUES(2,0,1,2,35.0) INSERT INTO SS_ORDER_ITEM VALUES(2,1,2,1,49.0) INSERT INTO SS_ORDER_ITEM VALUES(3,0,1,1,59.8) INSERT INTO SS_ORDER_ITEM VALUES(3,1,0,1,65.0) INSERT INTO SS_ORDER_ITEM VALUES(3,2,2,1,28.0) INSERT INTO SS_ORDER_ITEM VALUES(3,3,3,1,35.0) INSERT INTO SS_ORDER_ITEM VALUES(3,4,4,1,49.0) INSERT INTO SS_ORDER_ITEM VALUES(4,0,1,3,59.8) INSERT INTO SS_ORDER_ITEM VALUES(4,1,3,2,28.0) INSERT INTO SS_USERS VALUES(1,'admin','21232f297a57a5a743894a0e4a801fc3','\u8d85\u7ea7\u7ba1\u7406\u5458','admin@springside.org.cn',NULL,'1') INSERT INTO SS_USERS VALUES(2,'employee','fa5473530e4d1a5a1e1eb53d2fedb10c','\u5e7f\u5dde\u5458\u5de5','employee@springside.org.cn','\u5e7f\u5dde','1') INSERT INTO SS_USERS VALUES(3,'employee2','af74a83ae0d5777401f86af4df941e98','\u5317\u4eac\u5458\u5de5','employee2@springside.org.cn','\u5317\u4eac','1') INSERT INTO SS_ROLES VALUES(1,'ADMIN','\u7ba1\u7406\u5458') INSERT INTO SS_ROLES VALUES(2,'EMPLOYEE','\u517c\u804c\u4eba\u5458') INSERT INTO SS_USER_ROLE VALUES(1,1) INSERT INTO SS_USER_ROLE VALUES(2,2) INSERT INTO SS_USER_ROLE VALUES(3,2) INSERT INTO SS_PERMISSIONS VALUES(1,'AUTH_BOOK_MANAGE','','\u56fe\u4e66\u7ba1\u7406 \u65b0\u589e/\u4fee\u6539/\u5220\u9664','1') INSERT INTO SS_PERMISSIONS VALUES(2,'AUTH_ORDER_SHIP','','\u8ba2\u5355\u7ba1\u7406 \u53d1\u8d27','1') INSERT INTO SS_PERMISSIONS VALUES(3,'AUTH_USER_MANAGE','','\u7528\u6237\u7ba1\u7406 \u65b0\u589e/\u4fee\u6539/\u5220\u9664/\u8d4b\u89d2\u8272','1') INSERT INTO SS_PERMISSIONS VALUES(4,'AUTH_ROLE_MANAGE','','\u89d2\u8272\u7ba1\u7406 \u65b0\u589e/\u4fee\u6539/\u5220\u9664/\u8d4b\u6743\u9650','1') INSERT INTO SS_PERMISSIONS VALUES(5,'AUTH_AUTHORITY_MANAGE','','\u6743\u9650\u7ba1\u7406 \u65b0\u589e/\u4fee\u6539/\u5220\u9664/\u8d4b\u8d44\u6e90','1') INSERT INTO SS_PERMISSIONS VALUES(6,'AUTH_RESOURCE_MANAGE','','\u8d44\u6e90\u7ba1\u7406 \u65b0\u589e/\u4fee\u6539/\u5220\u9664','1') INSERT INTO SS_PERMISSIONS VALUES(8,'AUTH_ADMIN_LOGIN','','\u540e\u53f0\u7ba1\u7406 \u8fdb\u5165','1') INSERT INTO SS_PERMISSIONS VALUES(9,'AUTH_BOOKMANAGE_LOGIN','','\u56fe\u4e66\u7ba1\u7406 \u8fdb\u5165','1') INSERT INTO SS_PERMISSIONS VALUES(10,'AUTH_REPORT_LOGIN','','\u62a5\u8868\u7cfb\u7edf \u8fdb\u5165','1') INSERT INTO SS_PERMISSIONS VALUES(11,'AUTH_WEBWORK_ADMIN_LOGIN','','\u62a5\u8868\u7cfb\u7edf \u8fdb\u5165','1') INSERT INTO SS_PERMISSIONS VALUES(12,'ACL_READ','','\u5355\u72ec\u8ba2\u5355\u7ba1\u7406 \u9605\u8bfb ','1') INSERT INTO SS_PERMISSIONS VALUES(13,'ACL_DELETE','','\u5355\u72ec\u8ba2\u5355\u7ba1\u7406 \u5220\u9664','1') INSERT INTO SS_PERMISSIONS VALUES(14,'ACL_ADMIN','','\u5355\u72ec\u8ba2\u5355\u7ba1\u7406 \u7ef4\u62a4\u5bdf\u770b','1') INSERT INTO SS_PERMISSIONS VALUES(15,'AFTER_ACL_CREAT','','\u8ba2\u5355\u6574\u52a0\u540e ACL\u6743\u9650\u521b\u5efa','0') INSERT INTO SS_PERMISSIONS VALUES(16,'ROLE_ANONYMOUS','','\u533f\u540d\u7528\u6237\u767b\u5f55','1') INSERT INTO SS_PERMISSIONS VALUES(17,'AUTH_WEBWORK_BOOK_MANAGE','','webwork\u540e\u53f0\u56fe\u4e66 \u4fee\u6539','1') INSERT INTO SS_PERMISSIONS VALUES(18,'AUTH_BOOK_BUTTON_DEL','','\u56fe\u4e66\u7ba1\u7406 \u5220\u9664\u6309\u94ae\u663e\u793a','1') INSERT INTO SS_PERMISSIONS VALUES(19,'AUTH_BOOK_BUTTON_ADD','','\u56fe\u4e66\u7ba1\u7406 \u65b0\u589e\u6309\u94ae\u663e\u793a','1') INSERT INTO SS_PERMISSIONS VALUES(20,'AUTH_ANONYMOUS','','\u56fe\u4e66\u7ba1\u7406 \u65b0\u589e\u6309\u94ae\u663e\u793a','1') INSERT INTO SS_ROLE_PERMIS VALUES(1,1) INSERT INTO SS_ROLE_PERMIS VALUES(1,2) INSERT INTO SS_ROLE_PERMIS VALUES(1,3) INSERT INTO SS_ROLE_PERMIS VALUES(1,4) INSERT INTO SS_ROLE_PERMIS VALUES(1,5) INSERT INTO SS_ROLE_PERMIS VALUES(1,6) INSERT INTO SS_ROLE_PERMIS VALUES(1,8) INSERT INTO SS_ROLE_PERMIS VALUES(1,9) INSERT INTO SS_ROLE_PERMIS VALUES(1,10) INSERT INTO SS_ROLE_PERMIS VALUES(1,11) INSERT INTO SS_ROLE_PERMIS VALUES(1,17) INSERT INTO SS_ROLE_PERMIS VALUES(1,18) INSERT INTO SS_ROLE_PERMIS VALUES(1,19) INSERT INTO SS_ROLE_PERMIS VALUES(2,2) INSERT INTO SS_ROLE_PERMIS VALUES(2,8) INSERT INTO SS_ROLE_PERMIS VALUES(2,9) INSERT INTO SS_MODULES VALUES(0,0,'Mmodules','',1) INSERT INTO SS_MODULES VALUES(1,0,'\u524d\u53f0\u6a21\u5757','',1) INSERT INTO SS_MODULES VALUES(2,1,'\u8d2d\u4e66\u6a21\u5757','',1) INSERT INTO SS_MODULES VALUES(3,1,'\u767b\u9646\u6a21\u5757','',1) INSERT INTO SS_MODULES VALUES(4,0,'\u540e\u53f0\u6a21\u5757','',1) INSERT INTO SS_MODULES VALUES(5,4,'\u767b\u9646\u6a21\u5757','',1) INSERT INTO SS_MODULES VALUES(6,4,'\u56fe\u4e66\u7ba1\u7406\u6a21\u5757','',1) INSERT INTO SS_MODULES VALUES(7,4,'\u8ba2\u5355\u7ba1\u7406\u6a21\u5757','',1) INSERT INTO SS_MODULES VALUES(8,4,'\u62a5\u8868\u7cfb\u7edf\u6a21\u5757','',1) INSERT INTO SS_MODULES VALUES(9,4,'\u6743\u9650\u7ba1\u7406\u6a21\u5757','',1) INSERT INTO SS_MODULES VALUES(10,4,'webwork\u6a21\u5757','',1) INSERT INTO SS_MODULES VALUES(11,9,'\u7528\u6237\u7ba1\u7406\u6a21\u5757','',1) INSERT INTO SS_MODULES VALUES(12,9,'\u89d2\u8272\u7ba1\u7406\u6a21\u5757','',1) INSERT INTO SS_MODULES VALUES(13,9,'\u6743\u9650\u7ba1\u7406\u6a21\u5757','',1) INSERT INTO SS_MODULES VALUES(14,9,'\u8d44\u6e90\u7ba1\u7406\u6a21\u5757','',1) INSERT INTO SS_RESOURCES VALUES(1,'\u4fdd\u5b58\u56fe\u4e66',6,'FUNCTION','org.springside.bookstore.admin.manager.BookManager.save','') INSERT INTO SS_RESOURCES VALUES(2,'\u5220\u9664\u56fe\u4e66',6,'FUNCTION','org.springside.bookstore.admin.manager.BookManager.remove','') INSERT INTO SS_RESOURCES VALUES(3,'\u53d1\u9001\u8ba2\u5355',7,'FUNCTION','org.springside.bookstore.admin.manager.OrderManager.shipOrder','') INSERT INTO SS_RESOURCES VALUES(4,'\u4fdd\u5b58\u7528\u6237',11,'FUNCTION','org.springside.bookstore.plugins.security.service.logic.UserManager.saveUser','') INSERT INTO SS_RESOURCES VALUES(5,'\u5220\u9664\u7528\u6237',11,'FUNCTION','org.springside.bookstore.plugins.security.service.logic.UserManager.removeUser','') INSERT INTO SS_RESOURCES VALUES(6,'\u8d4b\u4e88\u89d2\u8272',11,'FUNCTION','org.springside.bookstore.plugins.security.service.logic.UserManager.saveRoles','') INSERT INTO SS_RESOURCES VALUES(7,'\u4fdd\u5b58\u89d2\u8272',12,'FUNCTION','org.springside.bookstore.plugins.security.service.logic.RoleManager.saveRole','') INSERT INTO SS_RESOURCES VALUES(8,'\u5220\u9664\u89d2\u8272',12,'FUNCTION','org.springside.bookstore.plugins.security.service.logic.RoleManager.removeRole','') INSERT INTO SS_RESOURCES VALUES(9,'\u8d4b\u4e88\u6743\u9650',12,'FUNCTION','org.springside.bookstore.plugins.security.service.logic.RoleManager.savePermissions','') INSERT INTO SS_RESOURCES VALUES(10,'\u4fdd\u5b58\u6743\u9650',13,'FUNCTION','org.springside.bookstore.plugins.security.service.logic.PermissionManager.savePermission','') INSERT INTO SS_RESOURCES VALUES(11,'\u5220\u9664\u6743\u9650',13,'FUNCTION','org.springside.bookstore.plugins.security.service.logic.PermissionManager.removePermission','') INSERT INTO SS_RESOURCES VALUES(12,'\u8d4b\u4e88\u8d44\u6e90',13,'FUNCTION','org.springside.bookstore.plugins.security.service.logic.PermissionManager.saveResources','') INSERT INTO SS_RESOURCES VALUES(13,'\u4fdd\u5b58\u8d44\u6e90',14,'FUNCTION','org.springside.bookstore.plugins.security.service.logic.ResourceManager.saveResource','') INSERT INTO SS_RESOURCES VALUES(14,'\u5220\u9664\u8d44\u6e90',14,'FUNCTION','org.springside.bookstore.plugins.security.service.logic.ResourceManager.removeResource','') INSERT INTO SS_RESOURCES VALUES(15,'\u8fdb\u5165\u62a5\u8868',8,'URL','/report/**','') INSERT INTO SS_RESOURCES VALUES(16,'\u8fdb\u5165\u56fe\u4e66\u7ba1\u7406',6,'URL','/admin/book.do*','') INSERT INTO SS_RESOURCES VALUES(17,'\u8fdb\u5165\u540e\u53f0\u7ba1\u7406',4,'URL','/admin/**','') INSERT INTO SS_RESOURCES VALUES(18,'\u8fdb\u5165Webwork\u540e\u53f0\u7ba1\u7406',10,'URL','/ww/admin/**','') INSERT INTO SS_RESOURCES VALUES(19,'\u5220\u9664\u8ba2\u5355',7,'FUNCTION','org.springside.bookstore.admin.manager.OrderManager.removeOrder','') INSERT INTO SS_RESOURCES VALUES(21,'WebWork \u56fe\u4e66\u4fee\u6539',10,'FUNCTION','/ww/admin/book.action*','') INSERT INTO SS_RESOURCES VALUES(22,'\u56fe\u4e66\u5220\u9664\u6309\u94ae',6,'COMPONENT','book.deleteButton','') INSERT INTO SS_RESOURCES VALUES(23,'\u56fe\u4e66\u65b0\u589e\u6309\u94ae',6,'COMPONENT','book.addButton','') INSERT INTO SS_RESOURCES VALUES(24,'\u5220\u9664',7,'FUNCTION','org.springside.bookstore.admin.manager.OrderManager.placeOrder','') INSERT INTO SS_PERMIS_RESC VALUES(1,1) INSERT INTO SS_PERMIS_RESC VALUES(1,2) INSERT INTO SS_PERMIS_RESC VALUES(2,3) INSERT INTO SS_PERMIS_RESC VALUES(3,4) INSERT INTO SS_PERMIS_RESC VALUES(3,5) INSERT INTO SS_PERMIS_RESC VALUES(3,6) INSERT INTO SS_PERMIS_RESC VALUES(4,7) INSERT INTO SS_PERMIS_RESC VALUES(4,8) INSERT INTO SS_PERMIS_RESC VALUES(4,9) INSERT INTO SS_PERMIS_RESC VALUES(5,10) INSERT INTO SS_PERMIS_RESC VALUES(5,11) INSERT INTO SS_PERMIS_RESC VALUES(5,17) INSERT INTO SS_PERMIS_RESC VALUES(5,18) INSERT INTO SS_PERMIS_RESC VALUES(6,12) INSERT INTO SS_PERMIS_RESC VALUES(6,13) INSERT INTO SS_PERMIS_RESC VALUES(8,17) INSERT INTO SS_PERMIS_RESC VALUES(9,16) INSERT INTO SS_PERMIS_RESC VALUES(10,15) INSERT INTO SS_PERMIS_RESC VALUES(11,18) INSERT INTO SS_PERMIS_RESC VALUES(13,19) INSERT INTO SS_PERMIS_RESC VALUES(17,21) INSERT INTO SS_PERMIS_RESC VALUES(18,22) INSERT INTO SS_PERMIS_RESC VALUES(19,23) INSERT INTO SS_PERMIS_RESC VALUES(15,24) INSERT INTO SS_PERMIS_RESC VALUES(20,24) INSERT INTO ACL_OBJECT_IDENTITY VALUES(1,'org.springside.bookstore.commons.domain.Order:0',NULL,'org.acegisecurity.acl.basic.SimpleAclEntry') INSERT INTO ACL_OBJECT_IDENTITY VALUES(2,'org.springside.bookstore.commons.domain.Order:1',NULL,'org.acegisecurity.acl.basic.SimpleAclEntry') INSERT INTO ACL_OBJECT_IDENTITY VALUES(3,'org.springside.bookstore.commons.domain.Order:2',NULL,'org.acegisecurity.acl.basic.SimpleAclEntry') INSERT INTO ACL_OBJECT_IDENTITY VALUES(4,'org.springside.bookstore.commons.domain.Order:3',NULL,'org.acegisecurity.acl.basic.SimpleAclEntry') INSERT INTO ACL_OBJECT_IDENTITY VALUES(5,'org.springside.bookstore.commons.domain.Order:4',NULL,'org.acegisecurity.acl.basic.SimpleAclEntry') INSERT INTO ACL_PERMISSION VALUES(1,1,'admin',1) INSERT INTO ACL_PERMISSION VALUES(2,2,'admin',1) INSERT INTO ACL_PERMISSION VALUES(3,3,'admin',1) INSERT INTO ACL_PERMISSION VALUES(4,4,'admin',1) INSERT INTO ACL_PERMISSION VALUES(5,5,'admin',1) INSERT INTO ACL_PERMISSION VALUES(6,1,'employee',1) INSERT INTO ACL_PERMISSION VALUES(7,2,'employee2',1) INSERT INTO ACL_PERMISSION VALUES(8,3,'employee',1) INSERT INTO ACL_PERMISSION VALUES(9,4,'employee2',1) INSERT INTO ACL_PERMISSION VALUES(10,5,'employee',1) INSERT INTO SS_MENU VALUES(2,NULL,2,'\u56fe\u4e66\u7ba1\u7406','','','','','') INSERT INTO SS_MENU VALUES(3,NULL,3,'\u8ba2\u5355\u7ba1\u7406','','','','','') INSERT INTO SS_MENU VALUES(4,NULL,4,'\u62a5\u8868\u7cfb\u7edf','','','','','') INSERT INTO SS_MENU VALUES(5,NULL,5,'\u6743\u9650\u7ba1\u7406','','','','','') INSERT INTO SS_MENU VALUES(6,2,1,'\u56fe\u4e66\u7ba1\u7406','','','../images/icon/16x16/group.jpg','/admin/book.do','dblselect') INSERT INTO SS_MENU VALUES(7,2,2,'\u5efa\u7acb\u7d22\u5f15','','','../images/icon/16x16/make-index.gif','/plugins/compass/indexBook.do','dblselect') INSERT INTO SS_MENU VALUES(8,3,1,'\u8ba2\u5355\u7ba1\u7406','','','../images/icon/16x16/order.gif','/admin/order.do','dblselect') INSERT INTO SS_MENU VALUES(9,4,1,'\u9500\u552e\u62a5\u8868','','','../images/icon/16x16/report.gif','/report/saleReport.do?method=filter','dblselect') INSERT INTO SS_MENU VALUES(10,5,1,'\u7528\u6237\u7ba1\u7406','','','../images/icon/16x16/user.jpg','/security/user.do','dblselect') INSERT INTO SS_MENU VALUES(11,5,2,'\u89d2\u8272\u7ba1\u7406','','','../images/icon/16x16/role.gif','/security/role.do','dblselect') INSERT INTO SS_MENU VALUES(12,5,3,'\u6743\u9650\u7ba1\u7406','','','../images/icon/16x16/authority.gif','/security/permission.do','dblselect') INSERT INTO SS_MENU VALUES(13,5,4,'\u8d44\u6e90\u7ba1\u7406','','','../images/icon/16x16/resource.gif','/security/resource.do','dblselect') INSERT INTO SS_MENU VALUES(14,NULL,6,'\u83dc\u5355\u7ba1\u7406','','','','','') INSERT INTO SS_MENU VALUES(15,14,1,'\u83dc\u5355\u914d\u7f6e','','','../images/icon/16x16/group.jpg','/plugins/menuManager.do','dblselect') INSERT INTO SS_MENU VALUES(16,14,2,'\u83dc\u5355\u89d2\u8272','','','../images/icon/16x16/authority.gif','/plugins/menuRoleManager.do','dblselect') INSERT INTO SS_MENU_ROLE VALUES (1,2) INSERT INTO SS_MENU_ROLE VALUES (1,3) INSERT INTO SS_MENU_ROLE VALUES (1,4) INSERT INTO SS_MENU_ROLE VALUES (1,5) INSERT INTO SS_MENU_ROLE VALUES (1,6) INSERT INTO SS_MENU_ROLE VALUES (1,7) INSERT INTO SS_MENU_ROLE VALUES (1,8) INSERT INTO SS_MENU_ROLE VALUES (1,9) INSERT INTO SS_MENU_ROLE VALUES (1,10) INSERT INTO SS_MENU_ROLE VALUES (1,11) INSERT INTO SS_MENU_ROLE VALUES (1,12) INSERT INTO SS_MENU_ROLE VALUES (1,13) INSERT INTO SS_MENU_ROLE VALUES (1,14) INSERT INTO SS_MENU_ROLE VALUES (1,15) INSERT INTO SS_MENU_ROLE VALUES (1,16) INSERT INTO SS_MENU_ROLE VALUES (2,3) INSERT INTO SS_MENU_ROLE VALUES (2,8) INSERT INTO JBPM_ID_USER VALUES (1,'U','Demo','demo@springside.org.cn','demo') INSERT INTO JBPM_ID_USER VALUES (2,'U','Employee1','employee@springside.org.cn','demo')