酒店管理系统资源-CSDN文库

共70个文件

class：49个

java：9个

xml：4个

JAVA

酒店管理

3星 · 超过75%的资源需积分: 9 67 浏览量 2008-06-28 13:09:34 上传评论 1 收藏 225KB ZIP 举报

SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE DATABASE [royal] GO USE [royal] GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[RoomInfo]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[RoomInfo]( [RoomNo] [int] NOT NULL, [FloorNo] [int] NOT NULL, [Status] [varchar](100) NOT NULL, [AssignedTo] [varchar](100) NOT NULL, CONSTRAINT [PK_RoomInfo] PRIMARY KEY CLUSTERED ( [RoomNo] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END INSERT INTO [RoomInfo] VALUES (1001,1,'Cleaned','Kim') INSERT INTO [RoomInfo] VALUES (1002,1,'Cleaned','Adachi') INSERT INTO [RoomInfo] VALUES (1003,1,'Not Cleaned','John') INSERT INTO [RoomInfo] VALUES (1004,1,'Cleaned','Sue') INSERT INTO [RoomInfo] VALUES (2001,2,'Cleaned','Joe') INSERT INTO [RoomInfo] VALUES (2002,2,'Not Cleaned','Kerry') INSERT INTO [RoomInfo] VALUES (2003,2,'Cleaned','Roy') INSERT INTO [RoomInfo] VALUES (2004,2,'Cleaned','Carter') INSERT INTO [RoomInfo] VALUES (3001,3,'Cleaned','Arnold') INSERT INTO [RoomInfo] VALUES (3002,3,'Not Cleaned','Shane') INSERT INTO [RoomInfo] VALUES (3003,3,'Cleaned','Kim') INSERT INTO [RoomInfo] VALUES (3005,3,'Not Cleaned','Carter') INSERT INTO [RoomInfo] VALUES (4001,4,'Cleaned','Shane') INSERT INTO [RoomInfo] VALUES (4002,4,'Not Cleaned','Sherry') INSERT INTO [RoomInfo] VALUES (4003,4,'Cleaned','Arnold') INSERT INTO [RoomInfo] VALUES (4004,4,'Not Cleaned','John') GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[loginuser]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[loginuser]( [Username] [varchar](50) NULL, [Password] [varchar](50) NULL ) ON [PRIMARY] END INSERT INTO [loginuser] VALUES ('manager','password') INSERT INTO [loginuser] VALUES ('assistant','password') GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Employees]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Employees]( [Name] [varchar](50) NULL, [Designation] [varchar](50) NULL, [Address] [varchar](50) NULL, [Telephone] [varchar](50) NULL, [Fax] [varchar](50) NULL, [EMail] [varchar](50) NULL, [ID] [int] IDENTITY(1,1) NOT NULL ) ON [PRIMARY] END INSERT INTO [Employees] VALUES ('Kim','Cleaning Staff','California','0015688489','0015688489','kim@royal.com') INSERT INTO [Employees] VALUES ('Adachi','Cleaning Staff','California','0015633443','0015633443','adachi@royal.com') INSERT INTO [Employees] VALUES ('Roy','Cleaning Staff','California','0015623452','0015623452','roy@royal.com') INSERT INTO [Employees] VALUES ('Carter','Cleaning Staff','California','0015621356','0015621356','carter@royal.com') INSERT INTO [Employees] VALUES ('Sherry','Cleaning Staff','California','0015688960','0015688960','sherry@royal.com') INSERT INTO [Employees] VALUES ('Kerry','Cleaning Staff','California','0015665740','0015665740','kerry@royal.com') INSERT INTO [Employees] VALUES ('Shane','Cleaning Staff','California','0015644988','0015644988','shane@royal.com') INSERT INTO [Employees] VALUES ('John','Cleaning Staff','California','0015600968','0015600968','john@royal.com') INSERT INTO [Employees] VALUES ('Sue','Cleaning Staff','California','001564539','001564539','sue@royal.com') INSERT INTO [Employees] VALUES ('Arnold','Cleaning Staff','California','0015634690','0015634690','arnold@royal.com') INSERT INTO [Employees] VALUES ('Ann','Manager','California','0015643790','0015643790','ann@royal.com') INSERT INTO [Employees] VALUES ('Swan','Assistant','California','0015622486','0015622486','swan@royal.com') INSERT INTO [Employees] VALUES ('Joy','Assistant','California','0015644667','0015644667','joy@royal.com')

资源推荐

资源详情

资源评论