附录A 开发环境的配置
对于JBuilder、Oracle9i、WebLogic 7、WebLogic Domain的安装配置除参考相关的安装手册外，可参考本栏目发表的《Jbuilder9+Oracle9i+Weblogic8.1安装配置》
A. 配置Jbuilder 9
A.选择Tools-＞Configure Servers配置Server信息
Home Directory:选择Weblogic安装目录下的Server目录，如：C:\bea\weblogic700\server
Main Class,VM Parameters：系统会自动获得，不用修改
Working Directory:创建的新Domain目录 如：C:\bea\user_projects\mydomain
Class 中：由于没有Weblogic的SP包，删除weblogic_sp.jar包，仅保留weblogic.jar
JDK Install directory:选择安装Weblogic目录下的JDK目录 如：D:\bea\jdk131_03
BEA Home directory: 选择安装Weblogic目录 如：C:\bea User Name and Password:创建Domain时Administor的用户名称和密码。
Domain Name and Server Name:系统会自动获得
配置缺省工程的Server信息(Project-＞Default Projects Properties)
这样一来新建的工程默认情况下就使用这种Server配置
配置数据库驱动
点击Add按钮
在本机Oracle的目录下选择Oracle JDBC lib的路径，如D:\Oracle\Ora92\jdbc\lib\classes12.jar
配置数据库驱动后需重启JB才能使设置生效
附录B 参考资料
1）《Mastering EJB 2》
2）《Enterprise JavaBeans, 3rd Edition》
3）《EJB Design Pattern》
4）http://java.sun.com
5）http://dev2dev.bea.com.cn
附录C 建表及表初始化的sql脚本
C.1 建表
CREATE TABLE Appointment (ActorID SMALLINT NOT NULL,CoursesID SMALLINT NOT NULL);
ALTER TABLE Appointment ADD ( PRIMARY KEY (ActorID, CoursesID) ) ;
CREATE TABLE Courses (
CoursesID SMALLINT NOT NULL,
CoursesName VARCHAR(30) NULL,
StartDate DATE NULL,
EndDate DATE NULL,
RoomID SMALLINT NULL,
ActorID SMALLINT NULL
);
ALTER TABLE Courses ADD ( PRIMARY KEY (CoursesID) ) ;
CREATE TABLE ActorInfo (
ActorID SMALLINT NOT NULL,
ActorName VARCHAR(30) NULL,
Phone VARCHAR(16) NULL,
Email VARCHAR(50) NULL
);
ALTER TABLE ActorInfo ADD ( PRIMARY KEY (ActorID) ) ;
CREATE TABLE Actor (
ActorID SMALLINT NOT NULL,
UserName VARCHAR(20) NULL,
Password CHAR(8) NULL,
ActorType SMALLINT NULL
);
ALTER TABLE Actor ADD ( PRIMARY KEY (ActorID) ) ;
CREATE TABLE Room (RoomID SMALLINT NOT NULL,RoomName VARCHAR(20) NULL);
ALTER TABLE Room ADD ( PRIMARY KEY (RoomID) ) ;
ALTER TABLE Appointment ADD ( FOREIGN KEY (CoursesID) REFERENCES Courses ) ;
ALTER TABLE Appointment ADD ( FOREIGN KEY (ActorID) REFERENCES Actor ) ;
ALTER TABLE Courses ADD ( FOREIGN KEY (ActorID) REFERENCES Actor ) ;
ALTER TABLE Courses ADD ( FOREIGN KEY (RoomID) REFERENCES Room ) ;
ALTER TABLE ActorInfo ADD ( FOREIGN KEY (ActorID) REFERENCES Actor ) ; |
C.2表的初始化
--1）初始化系统管理员
insert into actor values(1,'sysadmin','sysadmin',0);
insert into actorinfo values(1,'sysadmin','66668888','chenxc@263.net'); |
--2）初始化老师
--增加任我行老师
insert into actor values(2,'rwx','rwx',1);
insert into actorinfo values(2,'任我行','77778888','rwx@courses.com.cn'); |
--增加东方不败老师
insert into actor values(3,'dfbb','dfbb',1);
insert into actorinfo values(3,'东方不败','88888888','dfbb@courses.com.cn'); |
--增加岳不群老师
insert into actor values(4,'ybq','ybq',1);
insert into actorinfo values(4,'岳不群','99998888','ybq@courses.com.cn'); |
--3）初始化教室
insert into room values(1,'黑木崖教室1');
insert into room values(2,'黑木崖教室2');
insert into room values(3,'华山教室3'); |
|
|
