酒店管理系统28878.docVIP

自选题目设计一:酒店管理系统 程序代码 1.数据库的实现 创建系统用户表格 Roomtype create database hotel go use hotel go CREATE TABLE Roomtype ( Typeid Varchar (10)primary key, Typename Varchar (16) , Bednum SMALLINT, Price INT, ) insert into Roomtype values(LX0001,标准单人间,1,100) insert into Roomtype values(LX0002,标准双人间,2,160) insert into Roomtype values(LX0003,豪华单人间,1,200) insert into Roomtype values(LX0004,豪华双人间,2,360) insert into Roomtype values(LX0005,商务套房,1,1000) insert into Roomtype values(LX0006,总统套房,2,2000) 创建客房信息表格　Rooms CREATE TABLE Rooms ( RoomNO Varchar(10) primary key, Typeid Varchar (10) NOT NULL, Roomposition Varchar(5) NULL, Putup Varchar(5) NOT NULL， FOREIGN KEY(Typeid) REFERENCES Roomtype(Typeid) ) 2. 登录功能实现 该模块只要是为了方便酒店管理员的操作，界面友好，简单易操作。需要有一定的美观性和可操作性。同时为了保证安全性，我们设定了权限功能，管理员可以使用全部功能，而普通用户不能使用系统管理功能，所以普通用户不能增减客房信息，同时，也不能增减系统的用户。 图4 主界面 主代码如下 package UI; import java.awt.*; import java.awt.event.*; import java.sql.*; import java.util.*; import UI.*; public class mainFrame extends JFrame{ private JButton bt1,bt2,bt3,bt4,bt5; private JTextField tf1,tf2; private int wholepart; public mainFrame() { super ( 金翎酒店欢迎您！); JPanel panelMain,panelCent,panelNort,panelBottom; panelMain = new JPanel(new BorderLayout()); panelNort = buildNorth(); panelCent = buildDTM(); panelMain.add(panelNort,BorderLayout.NORTH); panelMain.add(panelCent); setContentPane(panelMain); setSize (780,620); setVisible(true); } private JPanel buildNorth() { JPanel panelNort1 = new JPanel(); Icon bug1= new ImageIcon(pic/m01.gif); Icon bug2= new ImageIcon(pic/m04.gif); Icon bug3= new ImageIcon(pic/m05.gif); Icon bug4= new ImageIcon(pic/m06.gif); Icon bug5= new ImageIcon(pic/m07.gif); bt1 = new JButton ( 客户预定, bug3); bt2 = new JButton ( 入住登记, bug2); bt3 = new JButton ( 客户结账, bug1); bt4 = new JButton ( 营业查询, bug4); bt5 = new JButton ( 系统管理, bug5); panelNort1.add(bt1); panelNort1.add(bt2); panelNort1.add(bt3); panelNort1.add(bt4);