use master
go
if exists (select * from dbo.sysdatabases where name = 'Ticket')
drop database Ticket
GO
create database Ticket
go
use Ticket
go
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[airlineInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[airlineInfo]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[customerInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[customerInfo]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[customerType]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[customerType]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[planeInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[planeInfo]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[serviceInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[serviceInfo]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ticketInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ticketInfo]
GO
CREATE TABLE [dbo].[airlineInfo] (
[airlineNO] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[departCity] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[arrivalCity] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[departDate] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[departTime] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[arrivalTime] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[planeNO] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ,
[commonPrice] [numeric](18, 2) NULL ,
[commercialPrice] [numeric](18, 2) NULL ,
[firstPrice] [numeric](18, 2) NULL ,
[airlineMemo] [text] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[customerInfo] (
[customerNO] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[customerName] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[customerSex] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[customerID] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ,
[customerTele] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[customerType] [char] (14) COLLATE Chinese_PRC_CI_AS NULL ,
[customerMemo] [text] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[customerType] (
[ctypeNO] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ctypeName] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[discount] [numeric](2, 0) NULL ,
[ctypeMemo] [text] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[planeInfo] (
[planeNO] [char] (18) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[planeType] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[buyDate] [datetime] NULL ,
[serveDate] [datetime] NULL ,
[isCommon] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[isCommercial] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[isFirst] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[planeMemo] [text] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[serviceInfo] (
[serviceNO] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[serviceName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[noPresent] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[noNewsPaper] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[noDrink] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[noFood] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[noMovie] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[canChange] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[canCancel] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[canDiscount] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[serviceMemo] [text] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[ticketInfo] (
[ticketNO] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[customerNO] [char] (�
没有合适的资源?快使用搜索试试~ 我知道了~
hangkong.rar_毕业设计_毕业设计 系统 vb
共28个文件
frm:19个
vbw:2个
exe:1个
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
0 下载量 172 浏览量
2022-09-24
13:27:26
上传
评论
收藏 92KB RAR 举报
温馨提示
vb航空公司管理系统,毕业设计..是大家很希望得到的哦!我也是花了很多时间才得到的!
资源推荐
资源详情
资源评论
收起资源包目录
hangkong.rar (28个子文件)
航空公司管理系统全套(VB+SQL)
vb航空公司管理系统
vb航空公司管理系统
Ticket_MIS.vbw 79B
frmTicket.frm 8KB
frmAbout.frm 9KB
MIS_TICKET.vbw 1KB
frmTicket1.frm 18KB
frmLogin.frm 4KB
Module1.bas 2KB
frmAirline.frm 8KB
frmCustomer1.frm 10KB
frmPlane.frm 7KB
frmcType.frm 7KB
frmTicket2.frm 10KB
frmAirline1.frm 14KB
SQL
TICKET.SQL 9KB
frmAbout.frx 778B
MSSCCPRJ.SCC 343B
frmService.frm 7KB
frmService1.frm 12KB
frmPlane1.frm 11KB
frmMain.frm 4KB
MIS_TICKET.vbp 1KB
frmcType1.frm 7KB
航空管理信息系统主程序.exe 252KB
frmAirline2.frm 4KB
frmPlane2.frm 5KB
frmCustomer.frm 7KB
frmCustomer2.frm 5KB
www.pudn.com.txt 218B
共 28 条
- 1
资源评论
Kinonoyomeo
- 粉丝: 77
- 资源: 1万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功