创建部门信息表
create table department(
id number(4) primary key,
departmentid varchar2(20) not null,
departmentname varchar2(20) not null,
unique(departmentid)
);
插入部门数据
INSERT INTO department VALUES (1,'1001','研发部');
INSERT INTO department VALUES(2,'1002','销售部');
INSERT INTO department VALUES(3,'1003','采购部');
INSERT INTO department VALUES(4,'1004','售后服务部');
INSERT INTO department VALUES(5,'1005','维修部');
INSERT INTO department VALUES(6,'1007','内勤部');
INSERT INTO department VALUES(7,'1008','运输部');
创建员工表
CREATE TABLE employee(
id number(8) NOT NULL,
EmployeeId varchar2(20) NOT NULL,
EmployeePass varchar2(20) NOT NULL,
EmployeeName varchar2(20) NOT NULL,
EmployeeSex varchar2(4) NOT NULL,
EmployeeAge number(3) NOT NULL,
EmployeeIdenCard varchar2(20) NOT NULL,
EmployeeBirthDate varchar2(20) default NULL,
EmployeeDiploma varchar2(20) NOT NULL,
EmployeeJoinDate varchar2(20) default NULL,
EmployeeAdd varchar2(50) NOT NULL,
EmployeePhone varchar2(20) default NULL,
EmployeeMobile varchar(20) default NULL,
DepartmentId varchar2(20) NOT NULL ,
JobsId varchar2(20) NOT NULL,
PRIMARY KEY (ID),
UNIQUE (EmployeeId),
UNIQUE (DepartmentId),
FOREIGN KEY (DepartmentId) REFERENCES department (DepartmentId)
);
创建仓库表
CREATE TABLE warehouse(
ID number(4) NOT NULL,
WareHouseId varchar(20) NOT NULL,
WareHouseName varchar(20) NOT NULL,
WareHouseAdd varchar(100) NOT NULL,
PRIMARY KEY (ID),
UNIQUE(WareHouseId)
)
创建商品所在位置表
CREATE TABLE stock(
ID number(4) NOT NULL,
StockId varchar(20) NOT NULL,
StockName varchar(20) NOT NULL,
PRIMARY KEY (ID),
UNIQUE(StockId)
)
CREATE TABLE goods(
ID number(8) NOT NULL,
GoodsId varchar(20),
GoodsName varchar(20) ,
GoodsABC varchar(10) NOT NULL,
GoodsProvince varchar(20) NOT NULL,
WareHouseId varchar(20) NOT NULL,
GoodsPrice float NOT NULL,
GoodsStockNumber number(8) NOT NULL ,
GoodsStockInDate varchar(20) NOT NULL,
StockId varchar(20) NOT NULL,
PRIMARY KEY (ID),
UNIQUE (GoodsId),
FOREIGN KEY (WareHouseId) REFERENCES warehouse(WareHouseId),
FOREIGN KEY (StockId) REFERENCES stock(StockId)
)
创建车辆表
CREATE TABLE car(
ID number(4) NOT NULL,
carid varchar(20) NOT NULL,
carname varchar(20) NOT NULL,
PRIMARY KEY (ID),
UNIQUE(carid)
)
创建入库单表
create table goodsin(
ID number(8) NOT NULL,
InId varchar2(20) NOT NULL,
GoodsId varchar2(20) NOT NULL,
InNumber number(8) NOT NUll,
InDate varchar2(20) NOT NULL,
EmployeeId varchar2(20) NOT NULL,
carid varchar(20) NOT NULL,
PRIMARY KEY (ID),
UNIQUE (InId),
FOREIGN KEY (GoodsId) REFERENCES goods(GoodsId),
FOREIGN KEY (EmployeeId) REFERENCES employee(EmployeeId),
FOREIGN KEY (carid) REFERENCES car(carid)
)
创建出库单表
create table goodsout(
ID number(8) NOT NULL,
OutId varchar2(20) NOT NULL,
GoodsId varchar2(20) NOT NULL,
OutNumber number(8) NOT NUll,
OutDate varchar2(20) NOT NULL,
EmployeeId varchar2(20) NOT NULL,
carid varchar(20) NOT NULL,
PRIMARY KEY (ID),
UNIQUE (OutId),
FOREIGN KEY (GoodsId) REFERENCES goods(GoodsId),
FOREIGN KEY (EmployeeId) REFERENCES employee(EmployeeId),
FOREIGN KEY (carid) REFERENCES car(carid)
)
没有合适的资源?快使用搜索试试~ 我知道了~
wuliuguanli.rar_物流 JSP
共274个文件
gif:68个
java:53个
class:53个
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
0 下载量 89 浏览量
2022-09-24
17:25:10
上传
评论
收藏 2MB RAR 举报
温馨提示
运用jsp+servlet+orcle编写的物流管理系统
资源推荐
资源详情
资源评论
收起资源包目录
wuliuguanli.rar_物流 JSP (274个子文件)
GoodsDao.class 8KB
EmployeeDao.class 7KB
OutDao.class 5KB
InDao.class 5KB
WarehouseDao.class 5KB
CarDao.class 4KB
Employee.class 4KB
EditeEmployeeServlet.class 3KB
AddEmployeeServlet.class 3KB
Goods.class 2KB
EmployeeServlet.class 2KB
EditeGoodsServlet.class 2KB
AddGoodsServlet.class 2KB
AddOutServlet.class 2KB
AddInServlet.class 2KB
EditeWarehouseServlet.class 2KB
StockDao.class 2KB
DepartmentDao.class 2KB
Goodsout.class 2KB
Filterqx.class 2KB
Filteryh.class 2KB
Goodsin.class 2KB
LoadWarehouseServlet.class 2KB
LoadEmployeeServlet.class 2KB
ListEmployeeServelt1.class 2KB
ListEmployeeServelt.class 2KB
AddWarehouseServlet.class 2KB
EditeCarServlet.class 2KB
LoadGoodsServlet.class 2KB
LoadCarServlet.class 2KB
AddCarServlet.class 2KB
ListWarehouseServlet1.class 2KB
ListWarehouseServlet.class 2KB
ListGoodsoutServlet1.class 1KB
ListGoodsinServlet1.class 1KB
ListGoodsServlet1.class 1KB
ListGoodsoutServlet.class 1KB
ListGoodsinServlet.class 1KB
ListGoodsServlet.class 1KB
ListCarServlet1.class 1KB
ListCarServlet.class 1KB
DeleteWarehouseServlet.class 1KB
DBTools.class 1KB
DeleteEmployeeServlet.class 1KB
DeleteGoodsServlet.class 1KB
DeleteOutServlet.class 1KB
DeleteCarServlet.class 1KB
DeleteInServlet.class 1KB
Warehouse.class 1KB
Filterzm.class 1KB
department.class 948B
Stock.class 930B
Car.class 885B
.classpath 432B
org.eclipse.wst.jsdt.ui.superType.container 49B
SpryTabbedPanels.css 8KB
SpryCollapsiblePanel.css 6KB
SpryAccordion.css 6KB
style.css 5KB
dtree.css 795B
st.css 763B
style1.css 366B
scrollerarea.css 257B
Thumbs.db 371KB
Thumbs.db 27KB
icon_19.gif 14KB
icon_20.gif 14KB
icon_21.gif 14KB
btn_Show.gif 13KB
btn_Collapse.gif 13KB
globe.gif 1KB
icon_23.gif 1KB
trash.gif 1KB
question.gif 1KB
icon_22.gif 1KB
base.gif 1KB
icon_17.gif 1KB
icon_24.gif 1KB
icon_04.gif 1KB
icon_25.gif 1KB
icon_18.gif 1019B
icon_08.gif 1005B
icon_09.gif 1001B
icon_PersonBlue.gif 995B
icon_12.gif 992B
icon_10.gif 991B
icon_PersonRed.gif 991B
icon_03.gif 991B
icon_02.gif 988B
nolines_plus.gif 870B
nolines_minus.gif 861B
icon_ArrowRight.gif 799B
icon_ArrowLeft.gif 788B
bg_HeaderMenuRight.gif 649B
icon_26.gif 641B
musicfolder.gif 633B
icon_27.gif 628B
imgfolder.gif 622B
icon_11.gif 608B
icon_15.gif 604B
共 274 条
- 1
- 2
- 3
资源评论
weixin_42651887
- 粉丝: 79
- 资源: 1万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功