conn system/password
PROMPT ======== 先删除Run script先前产生之User 及 Table ========;
DROP User Abel;
DROP User Ivan;
DROP User Alan;
DROP User Henry;
DROP User Bard;
DROP User Harry;
DROP User Bart;
DROP User Eden;
DROP User Beau;
DROP User Carl;
DROP User Ed;
DROP User Cliff;
DROP User Dan;
DROP User Frank;
DROP User Hermes;
DROP User Des;
DROP User Gale;
DROP User Beck;
DROP User Gary;
DROP User Danny;
DROP User Ford;
DROP User CASH;
DROP User Eddy;
DROP User Ian;
DROP User Barton;
DROP User Hank;
DROP User Ira;
DROP User Abner;
DROP User Jack;
DROP User Ade;
DROP TABLE EMP CASCADE CONSTRAINT;
DROP TABLE depart CASCADE CONSTRAINT;
DROP TABLE Product CASCADE CONSTRAINT;
DROP TABLE customer CASCADE CONSTRAINT;
DROP TABLE wip CASCADE CONSTRAINT;
DROP TABLE ord CASCADE CONSTRAINT;
DROP TABLE stock CASCADE CONSTRAINT;
DROP TABLE Probuy CASCADE CONSTRAINT;
DROP TABLE invoice CASCADE CONSTRAINT;
DROP TABLE delivery CASCADE CONSTRAINT;
DROP TABLE salgrade CASCADE CONSTRAINT;
prompt ======== 建立使用者并授与适当权限 =========;
create user Abel identified by Abel;
grant create session ,create view,
create sequence, create procedure
to Abel;
create user Ivan identified by Ivan;
grant create session ,create view,
create sequence, create procedure
to Ivan;
create user Alan identified by Alan;
grant create session ,create view,
create sequence, create procedure
to Alan;
create user Henry identified by Henry;
grant create session ,create view,
create sequence, create procedure
to Henry;
create user Bard identified by Bard;
grant create session ,create view,
create sequence, create procedure
to Bard;
create user Harry identified by Harry;
grant create session ,create view,
create sequence, create procedure
to Harry;
create user Bart identified by Bart;
grant create session ,create view,
create sequence, create procedure
to Bart;
create user Eden identified by Eden;
grant create session ,create view,
create sequence, create procedure
to Eden;
create user Beau identified by Beau;
grant create session ,create view,
create sequence, create procedure
to Beau;
create user Carl identified by Carl;
grant create session ,create view,
create sequence, create procedure
to Carl;
create user Ed identified by Ed;
grant create session ,create view,
create sequence, create procedure
to Ed;
create user Cliff identified by Cliff;
grant create session ,create view,
create sequence, create procedure
to Cliff;
create user Dan identified by Dan;
grant create session ,create view,
create sequence, create procedure
to Dan;
create user Frank identified by Frank;
grant create session ,create view,
create sequence, create procedure
to Frank;
create user Hermes identified by Hermes;
grant create session ,create view,
create sequence, create procedure
to Hermes;
create user Des identified by Des;
grant create session ,create view,
create sequence, create procedure
to Des;
create user Gale identified by Gale;
grant create session ,create view,
create sequence, create procedure
to Gale;
create user Beck identified by Beck;
grant create session ,create view,
create sequence, create procedure
to Beck;
create user Gary identified by Gary;
grant create session ,create view,
create sequence, create procedure
to Gary;
create user Danny identified by Danny;
grant create session ,create view,
create sequence, create procedure
to Danny;
create user Ford identified by Ford;
grant create session ,create view,
create sequence, create procedure
to Ford;
create user CASH identified by CASH;
grant create session ,create view,
create sequence, create procedure
to CASH;
create user Eddy identified by Eddy;
grant create session ,create view,
create sequence, create procedure
to Eddy;
create user Barton identified by Barton;
grant create session ,create view,
create sequence, create procedure
to Barton;
create user Ian identified by Ian;
grant create session ,create view,
create sequence, create procedure
to Ian;
create user Hank identified by Hank;
grant create session ,create view,
create sequence, create procedure
to Hank;
create user Ira identified by Ira;
grant create session ,create view,
create sequence, create procedure
to Ira;
create user Abner identified by Abner;
grant create session ,create view,
create sequence, create procedure
to Abner;
create user Jack identified by Jack;
grant create session ,create view,
create sequence, create procedure
to Jack;
create user Ade identified by Ade;
grant create session ,create view,
create sequence, create procedure
to Ade;
prompt ========建立表格 =========;
CREATE TABLE EMP
(EmpID VARCHAR2(10),
EmpName VARCHAR2(10),
EmpAdd VARCHAR2(20),
EmpPhone VARCHAR2(12),
EMail VARCHAR2(20),
MGR VARCHAR2(6),
HireDate DATE,
COMM NUMBER(7,2),
DeptNo NUMBER(2));
CREATE TABLE Depart
(EmpID VARCHAR2(10),
DepName VARCHAR2(10),
Pro VARCHAR2(12),
Sal NUMBER(6),
Educa VARCHAR2(12),
Exper VARCHAR2(20),
DeptNo NUMBER(2),
LOC VARCHAR2(13));
CREATE TABLE ProBuy
(ProID VARCHAR2(10),
StiQty NUMBER(10),
InsQty NUMBER(10));
CREATE TABLE Customer
(CustID VARCHAR2(10),
CustName VARCHAR2(22),
CustAdd VARCHAR2(20),
CustPhone VARCHAR2(12),
CustFax VARCHAR2(12));
CREATE TABLE Delivery
(ProID VARCHAR2(10),
OrdID VARCHAR2(10),
CarNO VARCHAR2(10));
CREATE TABLE Invoice
(InvID VARCHAR2(10),
ProID VARCHAR2(10),
Money NUMBER(10));
CREATE TABLE Ord
(OrdID VARCHAR2(10),
ProID VARCHAR2(10),
CustID VARCHAR2(10),
Qty NUMBER(10),
OrdDate DATE,
D_Date DATE);
CREATE TABLE Product
(ProID VARCHAR2(10),
ProName VARCHAR2(20));
CREATE TABLE Stock
(ProID VARCHAR2(10),
StiQty NUMBER(10));
CREATE TABLE WIP
(WIPID VARCHAR2(10),
ProID VARCHAR2(10),
Qty NUMBER(10));
create table salgrade
(grade number(1),
losal number(6),
hisal number(6));
prompt ========建立使用者对资料之增删查改等权限 =========;
grant select,
index, references
on EMP
to Abel
with grant option;
grant select,
index, references
on EMP
to Bard
with grant option;
grant select,
index, references
on EMP
to Harry
with grant option;
grant select, insert, update, alter, delete,
index, references
on EMP
to Bart
with grant option;
grant select,
index, references
on depart
to Abel
with grant option;
grant select,
index, references
on depart
to Bard
with grant option;
grant select,
index, references
on depart
to Harry
with grant option;
grant select, insert, update, alter, delete,
index, references
on depart
to Bart
with grant option;
grant select,
index, references
on Product
to Abel
with grant option;
grant select,
index, references
on Product
to Ivan
with grant option;
grant select,
index, references
on Product
to Alan
with grant option;
grant select,
index, references
on Product
to Henry
with grant option;
grant select,
index, references
on Product
to Bard
with grant option;
grant select,
index, references
on Product
to Harry
with grant option;
grant select,
index, references
on Product
to Bart
with grant option;
grant select,
index, references
on Product
to Eden
with grant option;
grant select,
index, references
on Product
to Beau
with grant option;
grant select,
index, references
on Product
to Carl
with grant option;
grant select,
index, references
on Product
to Ed
with grant option;
grant select,
index, references
on Product
to Cliff
with grant option;
grant select,
index, references
on Product
to Dan
with grant option;
grant select,
index, references
on Product
to Frank
with grant option;
grant select, insert, update, alter, delete,
index, references
on Product
to Hermes
with grant option;
grant select, insert, update, alter, delete,
index, references
on Product
to Des
with grant option;
grant select, insert, update, alter, delete,
index, refere
JSP+Oracle 开发的 生产管理系统源码
5星 · 超过95%的资源 需积分: 9 173 浏览量
2009-06-17
22:23:30
上传
评论 3
收藏 1.56MB RAR 举报 
JSP+Oracle 开发的 生产管理系统源码 （216个子文件） 
PoolBean.class 4KB Addrbook.class 4KB WhoisBean.class 4KB WrapFilter.class 2KB Visit.class 2KB DateBean.class 2KB MailBean.class 2KB CartBean.class 2KB RedBean.class 2KB Big5Name.class 2KB Big5Filter.class 2KB RsBean.class 2KB VisitBean.class 2KB TimerFilter.class 2KB GetEnvVar.class 2KB MySqlUtil.class 2KB BlueBean.class 2KB Hello.class 2KB DummyCartBean.class 2KB EnumBean.class 2KB TimerFilterServlet.class 2KB NumbBean.class 2KB ItemBean.class 2KB QuoteFileBean.class 1KB QuoteBean.class 1KB SAXHandler.class 1KB TelBean.class 1KB MyUtil.class 1KB BindBean.class 1KB ConnectionBean.class 1KB Big5FilterServlet.class 1KB IdBean.class 1KB ConnBean.class 1KB WrapFilterServlet.class 1KB AccountBean.class 1KB HelloWorld.class 1KB Morning.class 1KB LionBean.class 1KB Hi.class 963B BannerBean.class 923B Conv.class 888B PasswordBean.class 878B MyCharResponseWrapper.class 804B BallBean.class 720B CheckboxBean.class 620B CounterBean.class 497B
anarule.gif 2KB anabull1.gif 2KB anabull2.gif 240B anabull3.gif 234B
index.html 2KB insert01.html 1KB update01.html 1KB insert05.html 1KB update05.html 1KB update02.html 956B insert02.html 956B index01.html 900B index11.html 896B index09.html 872B index07.html 872B index05.html 872B index03.html 872B index10.html 872B index08.html 872B index02.html 872B index04.html 872B index06.html 872B insert04.html 829B update04.html 829B update08.html 713B insert08.html 713B update10.html 711B update11.html 711B update09.html 707B insert10.html 705B insert11.html 705B update06.html 703B insert06.html 703B insert09.html 701B insert03.html 661B update03.html 657B insert07.html 654B update07.html 652B delete11.html 627B delete04.html 626B select01.html 625B delete02.html 624B delete05.html 623B delete03.html 623B delete06.html 623B delete09.html 623B select11.html 623B delete08.html 623B delete01.html 623B delete10.html 623B select04.html 622B select05.html 621B select06.html 621B select03.html 621B共 216 条
- 1
- 2
- 3
- 1
- 2
前往页