最近閒來無事,想著克隆一個電影網站。
WWW.ROAK.COM
技術語言:JAVA EE
* j2ee核心组件:jsp、servlet、jdbc、ejb、jndi
* 数据通信:xml标记语言
* 前台页面展示:html、dhtml、java-script、Ext开源框架
* 控制层:servlet、struts
* 业务逻辑层:spring核心
* 数据持久层:hibernate
* 中间件:ejb(3.0)
* 操作系统:windows server 2018
* 数据库:db2、oracle
* 应用服务器:JBOSS
* 开发工具:WebSphere Studio Application Developer(WSAD),eclipse
数据库
/*電影主數據表*/ CREATE TABLE "SKYB2B"."TBL_MOVIE_PRODUCTS" ( "ID" NUMBER NOT NULL ENABLE, "AREA" NUMBER NOT NULL ENABLE, "DIRECTOR" NUMBER NOT NULL ENABLE, "PERFORMER" NUMBER NOT NULL ENABLE, "TYPE" NUMBER NOT NULL ENABLE, PRIMARY KEY ("ID") USING INITRANS MAXTRANS NOCOMPRESS LOGGING TABLESPACE "USERS" ENABLE ) SEGMENT CREATION DEFERRED PCTFREE PCTUSED INITRANS MAXTRANS NOCOMPRESS LOGGING TABLESPACE "USERS"; CREATE UNIQUE INDEX "SKYB2B"."SYS_C0012867" ON "SKYB2B"."TBL_MOVIE_PRODUCTS" ("ID") PCTFREE INITRANS MAXTRANS NOCOMPRESS LOGGING TABLESPACE "USERS";
/*區域表*/ CREATE TABLE "SKYB2B"."TBL_MOVIE_AREA" ( "ID" ,) NOT NULL ENABLE, "ANAME" ) NOT NULL ENABLE, PRIMARY KEY ("ID") USING INITRANS MAXTRANS NOCOMPRESS LOGGING TABLESPACE "USERS" ENABLE ) SEGMENT CREATION DEFERRED PCTFREE PCTUSED INITRANS MAXTRANS NOCOMPRESS LOGGING TABLESPACE "USERS"; CREATE UNIQUE INDEX "SKYB2B"."SYS_C0012855" ON "SKYB2B"."TBL_MOVIE_AREA" ("ID") PCTFREE INITRANS MAXTRANS NOCOMPRESS LOGGING TABLESPACE "USERS";
導演信息 CREATE TABLE "SKYB2B"."TBL_MOVIE_DIRECTOR" ( "ID" ,) NOT NULL ENABLE, "DNAME" ) NOT NULL ENABLE, "NATIONALITY" ) NOT NULL ENABLE, PRIMARY KEY ("ID") USING INITRANS MAXTRANS NOCOMPRESS LOGGING TABLESPACE "USERS" ENABLE ) SEGMENT CREATION DEFERRED PCTFREE PCTUSED INITRANS MAXTRANS NOCOMPRESS LOGGING TABLESPACE "USERS"; CREATE UNIQUE INDEX "SKYB2B"."SYS_C0012851" ON "SKYB2B"."TBL_MOVIE_DIRECTOR" ("ID") PCTFREE INITRANS MAXTRANS NOCOMPRESS LOGGING TABLESPACE "USERS";
/*演員*/ CREATE TABLE "SKYB2B"."TBL_MOVIE_PERFORMER" ( "ID" ,) NOT NULL ENABLE, "PNAME" ) NOT NULL ENABLE, "NATIONALITY" ) NOT NULL ENABLE, PRIMARY KEY ("ID") USING INITRANS MAXTRANS NOCOMPRESS LOGGING TABLESPACE "USERS" ENABLE ) SEGMENT CREATION DEFERRED PCTFREE PCTUSED INITRANS MAXTRANS NOCOMPRESS LOGGING TABLESPACE "USERS"; CREATE UNIQUE INDEX "SKYB2B"."SYS_C0012849" ON "SKYB2B"."TBL_MOVIE_PERFORMER" ("ID") PCTFREE INITRANS MAXTRANS NOCOMPRESS LOGGING TABLESPACE "USERS";