DBcon t = new DBcon(); t.consql(); //a=t.updatesql("insert into stuInfo values(5,'王五','男')"); //t.updatesql("update stuInfo set stuSex='女' where stuName='王五'"); //a=t.updatesql("delete from stuInfo where stuName='王五'"); //System.out.println (a); t.closesql(); }
}
create database hotel use hotel-- 房间列表create table room ( roomId varchar(20) primary key, -- 房间号 roomState varchar(20) not null check(roomState='住客净房' or roomState='住客脏房' or roomState='空脏房' or roomState='空净房' or roomState='维修房' or roomState='自用房'), -- 房间状态 roomPrice money not null check(roomPrice=888 or roomPrice=380 or roomPrice=260 or roomPrice=660 or roomPrice=180), -- 房价 roomFx varchar(20) not null check(roomFx='豪华套房' or roomFx='商务套房' or roomFx='标准套房' or roomFx='豪华标间' or roomFx='标准间') -- 房型 )drop table room-- 插入数据insert into room values('0101','住客净房',180,'标准间') insert into room values('0102','住客净房',180,'标准间') insert into room values('0103','空脏房',180,'标准间') insert into room values('0104','空脏房',180,'标准间') insert into room values('0105','空净房',180,'标准间') insert into room values('0106','住客脏房',180,'标准间') insert into room values('0107','空脏房',180,'标准间') insert into room values('0108','住客净房',180,'标准间') insert into room values('0109','空脏房',180,'标准间') insert into room values('0110','住客净房',180,'标准间') insert into room values('0111','住客脏房',180,'标准间') insert into room values('0112','住客净房',180,'标准间') insert into room values('0113','空脏房',180,'标准间') insert into room values('0114','住客净房',180,'标准间') insert into room values('0115','空净房',180,'标准间') insert into room values('0116','空脏房',180,'标准间') insert into room values('0117','住客净房',180,'标准间') insert into room values('0118','空净房',180,'标准间') insert into room values('0119','空脏房',180,'标准间') insert into room values('0120','住客净房',180,'标准间')insert into room values('0201','住客净房',260,'标准套房') insert into room values('0202','空净房',260,'标准套房') insert into room values('0203','住客净房',260,'标准套房') insert into room values('0204','空净房',260,'标准套房') insert into room values('0205','住客脏房',260,'标准套房') insert into room values('0206','住客脏房',260,'标准套房') insert into room values('0207','空净房',260,'标准套房') insert into room values('0208','住客净房',260,'标准套房') insert into room values('0209','住客净房',260,'标准套房') insert into room values('0210','住客脏房',260,'标准套房') insert into room values('0211','住客脏房',260,'标准套房') insert into room values('0212','住客净房',260,'标准套房') insert into room values('0213','住客脏房',260,'标准套房') insert into room values('0214','住客净房',260,'标准套房') insert into room values('0215','空脏房',260,'标准套房') insert into room values('0216','空净房',260,'标准套房') insert into room values('0217','住客净房',260,'标准套房') insert into room values('0218','住客净房',260,'标准套房') insert into room values('0219','空脏房',260,'标准套房') insert into room values('0220','空脏房',260,'标准套房')insert into room values('0301','空净房',380,'商务套房') insert into room values('0302','住客净房',380,'商务套房') insert into room values('0303','空脏房',380,'商务套房') insert into room values('0304','住客净房',380,'商务套房') insert into room values('0305','住客净房',380,'商务套房') insert into room values('0306','空净房',380,'商务套房') insert into room values('0307','住客脏房',380,'商务套房') insert into room values('0308','住客净房',380,'商务套房') insert into room values('0309','空脏房',380,'商务套房') insert into room values('0310','住客脏房',380,'商务套房') insert into room values('0311','住客净房',380,'商务套房') insert into room values('0312','住客净房',380,'商务套房') insert into room values('0313','住客脏房',380,'商务套房') insert into room values('0314','住客净房',380,'商务套房') insert into room values('0315','空脏房',380,'商务套房') insert into room values('0316','住客净房',380,'商务套房') insert into room values('0317','住客脏房',380,'商务套房') insert into room values('0318','住客净房',380,'商务套房') insert into room values('0319','空净房',380,'商务套房') insert into room values('0320','住客脏房',380,'商务套房')insert into room values('0401','住客净房',660,'豪华标间') insert into room values('0402','住客净房',660,'豪华标间') insert into room values('0403','住客脏房',660,'豪华标间') insert into room values('0404','住客净房',660,'豪华标间') insert into room values('0405','住客脏房',660,'豪华标间') insert into room values('0406','住客净房',660,'豪华标间') insert into room values('0407','空净房',660,'豪华标间') insert into room values('0408','住客净房',660,'豪华标间') insert into room values('0409','空脏房',660,'豪华标间') insert into room values('0410','住客净房',660,'豪华标间') insert into room values('0411','住客净房',660,'豪华标间') insert into room values('0412','空净房',660,'豪华标间') insert into room values('0413','住客净房',660,'豪华标间') insert into room values('0414','住客净房',660,'豪华标间') insert into room values('0415','空脏房',660,'豪华标间') insert into room values('0416','住客脏房',660,'豪华标间') insert into room values('0417','住客净房',660,'豪华标间') insert into room values('0418','空净房',660,'豪华标间') insert into room values('0419','住客净房',660,'豪华标间') insert into room values('0420','住客净房',660,'豪华标间')insert into room values('0501','住客净房',888,'豪华套房') insert into room values('0502','空净房',888,'豪华套房') insert into room values('0503','住客脏房',888,'豪华套房') insert into room values('0504','空脏房',888,'豪华套房') insert into room values('0505','空脏房',888,'豪华套房') insert into room values('0506','住客净房',888,'豪华套房') insert into room values('0507','住客净房',888,'豪华套房') insert into room values('0508','空净房',888,'豪华套房') insert into room values('0509','住客脏房',888,'豪华套房') insert into room values('0510','空脏房',888,'豪华套房') insert into room values('0511','住客脏房',888,'豪华套房') insert into room values('0512','住客净房',888,'豪华套房') insert into room values('0513','住客净房',888,'豪华套房') insert into room values('0514','住客净房',888,'豪华套房') insert into room values('0515','空脏房',888,'豪华套房') insert into room values('0516','住客净房',888,'豪华套房') insert into room values('0517','住客脏房',888,'豪华套房') insert into room values('0518','空净房',888,'豪华套房') insert into room values('0519','自用房',888,'豪华套房') insert into room values('0520','维修房',888,'豪华套房') update room set roomState='自用房' where roomId='0519' update room set roomState='维修房' where roomId='0520' delete from roomselect * from room --查询房间状态 select roomState from room group by roomState-- 入住退房表create table ruzhu ( ruzhuId varchar(20) foreign key references room(roomId), -- 房间号 ruzhuName varchar(20) not null, -- 姓名 ruzhuSex varchar(2) check(ruzhuSex='男' or ruzhuSex='女'), -- 性别 ruzhuCode varchar(20) not null, -- 身份证 ruzhuTouch varchar(20) not null, -- 联系方式 ruzhuTime varchar(20) not null, -- 入住时间 ruzhuTuiTime varchar(20) -- 退房时间 ) drop table ruzhu
以上是包括数据库的全部代码了 有高人帮忙的话直接复制就OK了 还希望加下QQ 谢谢
import java.util.Random; import java.awt.*; import java.awt.event.*; public class shuangSeQiu implements ActionListener{ int i,k; static int rm,rr; int [] a = new int [33]; Frame f = new Frame("ﾋｫﾉｫﾇ貊摠"); TextField tf = new TextField(); Random rd = new Random(); public shuangSeQiu() { for(i=0;i<33;i++) { a[i] = i; } f.setLayout(new BorderLayout()); f.addWindowListener(new WindowAdapter(){ public void windowClosing(WindowEvent e) { System.exit(0); } }); } public void init() { tf.addActionListener(this); Button b = new Button("ｿｪﾊｼ"); b.addActionListener(this); f.add(tf,"North"); f.add(b); f.setSize(300,300); f.setVisible(true); } public void actionPerformed(ActionEvent e) { if(e.getActionCommand().equals("ｿｪﾊｼ")) //tf.setText(""+(rd.nextInt(33)+1)+" "+(rd.nextInt(33)+1)+" "+(rd.nextInt(33)+1)+" "+(rd.nextInt(33)+1)+" "+(rd.nextInt(33)+1)+" "+(rd.nextInt(33)+1)+" ﾀｶﾉｫﾇﾅﾂ・ｺ"+(rd.nextInt(15)+1)); { /*rr = new Random().nextInt(33); rm = new Random().nextInt(33);*/ for(i=0;i<33;i++) { rr = new Random().nextInt(33); rm = new Random().nextInt(33); System.out.print(rr+" "); k=a[rm]; a[rm]=a[rr]; a[rr]=k; } tf.setText("ｺ・ｫﾇﾅﾂ・ｺ"+(a[0]+1)+" "+(a[1]+1)+" "+(a[2]+1)+" "+(a[3]+1)+" "+(a[4]+1)+" "+(a[5]+1)+" ﾀｶﾉｫﾇﾅﾂ・ｺ"+(rd.nextInt(15)+1)); } } public static void main(String[] args)//throws Exception { new shuangSeQiu().init(); } }
import java.awt.*;//导包
import java.awt.event.*;//导包import javax.swing.*;//导包
import javax.swing.event.*;//导包import java.util.*;//导包
import java.sql.*;//导包public class house extends JFrame implements ActionListener{
JTabbedPane ge1;//定义窗格
JPanel mianban1,mianban2,mianban3,mianban4,mianban5,mianban6,mianban7,mianban8;
JLabel bq1,bq2,bq3,bq4,bq5,bq6,bq7,bq8,bq9,bq10,bq11,bq12,bq13,bq14,bq15,bq16,bq17,bq18,bq19,bq20,bq21,bq22,bq23,bq24,bq25,bq26,bq27;
//定义文本框
JTextField txt1,txt2,txt3,txt4,txt5,txt6,txt7,txt8,txt9,txt10,txt11,txt12,txt13;
JTextField txt14,txt15,txt16,txt17,txt18,txt19,txt20,txt21,txt22;
JTextField txt23,txt24,txt25,txt26,txt27,txt28,txt29,txt30,txt31;
JComboBox xiala,xiala1,xiala2,xiala3;//定义下拉菜单
JRadioButton ra1,ra2,ra3,ra4;//定义单选按钮
ButtonGroup bg,bg1;//定义单选按钮组
JButton but1,but2,but3,but4,but5,but6;//定义入住登记中的按钮
JButton but11,but12,but13,but14,but15,but16;//定义状态查询界面中的按钮
JButton but21,but22,but23,but24,but25,but26;
JButton but31,but32,but33,but34,but35,but36;
JLabel bq30,bq31,bq32,bq33,bq34,bq35,bq36,bq37;//定义标签
JLabel bq40,bq41,bq42,bq43,bq44,bq45,bq46;//定义标签
JPanel bq70,bq71,bq72,bq73,bq74,bq75;//定义面板
JPanel bq80,bq81,bq82,bq83,bq84,bq85;//定义面板
JPanel bq90,bq91,bq92,bq93,bq94,bq95;//定义面板
JPanel rzan,zcxan,ydan;//定义面板
JLabel bq50,bq51,bq52,bq53,bq54,bq55,bq56,bq57,bq58,bq59,bq60,bq61,bq62,bq63;//定义标签
JButton [] rzanbutton=new JButton[100];//入住100个按钮
JButton [] cxbutton=new JButton[100];
JButton [] ydbutton=new JButton[100];
house(){
/**
* 入住登记界面
*/
int i=0;//定义变量..
ge1=new JTabbedPane();//实例化窗格
mianban1=new JPanel();//实例化面板
mianban2=new JPanel();
mianban3=new JPanel();
mianban4=new JPanel();
mianban5=new JPanel();
mianban6=new JPanel();
mianban7=new JPanel();
mianban8=new JPanel();
bg=new ButtonGroup();//实例化单选按钮组
bg1=new ButtonGroup();
bq1=new JLabel("账 号:");//实例化标签
bq2=new JLabel("房 间 号:");
bq3=new JLabel("房间类型:");
bq4=new JLabel("房 价:");
bq5=new JLabel("抵达日期:");
bq6=new JLabel("离店日期:");
bq7=new JLabel("联系方式:");
bq8=new JLabel("顾客姓名:");
bq9=new JLabel("性 别:");
bq10=new JLabel("证件号码:");
bq11=new JLabel("入 住 登 记");
bq12=new JLabel("男");
bq13=new JLabel("女");
bq14=new JLabel("(外地手机前加\"0\"或加区号,如:010-88888888)");
bq15=new JLabel("空 净 房");
bq16=new JLabel("空 净 房");
bq17=new JLabel("空 脏 房");
bq18=new JLabel("空 脏 房");
bq19=new JLabel("住客净房");
bq20=new JLabel("住客净房");
bq21=new JLabel("住客脏房");
bq22=new JLabel("住客脏房");
bq23=new JLabel("自 用 房");
bq24=new JLabel("自 用 房");
bq25=new JLabel("维 修 房");
bq26=new JLabel("维 修 房");
bq27=new JLabel("房 间 状 态 查 询");
bq70=new JPanel();
bq71=new JPanel();
bq72=new JPanel();
bq73=new JPanel();
bq74=new JPanel();
bq75=new JPanel();
bq80=new JPanel();
bq81=new JPanel();
bq82=new JPanel();
bq83=new JPanel();
bq84=new JPanel();
bq85=new JPanel();
bq90=new JPanel();
bq91=new JPanel();
bq92=new JPanel();
bq93=new JPanel();
bq94=new JPanel();
bq95=new JPanel();
txt1=new JTextField();//实例化标签
txt2=new JTextField();
txt3=new JTextField();
txt4=new JTextField();
txt5=new JTextField();
txt6=new JTextField();
txt7=new JTextField();
txt8=new JTextField();
txt9=new JTextField();
txt10=new JTextField();
//想窗格中添加选项
ge1.addTab("入住登记",mianban1);
ge1.addTab("房间状态",mianban2);
ge1.addTab("预定管理",mianban3);
ge1.addTab("退房管理",mianban4);
ge1.addTab("帮 助",mianban5);
xiala=new JComboBox();//实例化下拉菜单
xiala1=new JComboBox();
xiala2=new JComboBox();
xiala3=new JComboBox();
ra1=new JRadioButton();//实例化单选按钮
ra2=new JRadioButton();
but1=new JButton("新 建");
but1.setFont(new java.awt.Font("黑体",Font.BOLD,14));
but2=new JButton("保 存");
but2.setFont(new java.awt.Font("黑体",Font.BOLD,14));
but3=new JButton("放 弃");
but3.setFont(new java.awt.Font("黑体",Font.BOLD,14));
but4=new JButton("用户更换");
but4.setFont(new java.awt.Font("黑体",Font.BOLD,14));
but5=new JButton("锁屏离开");
but5.setFont(new java.awt.Font("黑体",Font.BOLD,14));
but6=new JButton("退 出");
but6.setFont(new java.awt.Font("黑体",Font.BOLD,14));
but11=new JButton("状态更改");
but11.setFont(new java.awt.Font("黑体",Font.BOLD,14));
but12=new JButton("保 存");
but12.setFont(new java.awt.Font("黑体",Font.BOLD,14));
but13=new JButton("放 弃");
but13.setFont(new java.awt.Font("黑体",Font.BOLD,14));
but14=new JButton("用户更换");
but14.setFont(new java.awt.Font("黑体",Font.BOLD,14));
but15=new JButton("锁屏离开");
but15.setFont(new java.awt.Font("黑体",Font.BOLD,14));
but16=new JButton("退 出");
but16.setFont(new java.awt.Font("黑体",Font.BOLD,14));
but21=new JButton("新建预定");
but21.setFont(new java.awt.Font("黑体",Font.BOLD,14));
but22=new JButton("保 存");
but22.setFont(new java.awt.Font("黑体",Font.BOLD,14));
but23=new JButton("放 弃");
but23.setFont(new java.awt.Font("黑体",Font.BOLD,14));
but24=new JButton("用户更换");
but24.setFont(new java.awt.Font("黑体",Font.BOLD,14));
but25=new JButton("锁屏离开");
but25.setFont(new java.awt.Font("黑体",Font.BOLD,14));
but26=new JButton("退 出");
but26.setFont(new java.awt.Font("黑体",Font.BOLD,14));
but31=new JButton("退房结账");
but31.setFont(new java.awt.Font("黑体",Font.BOLD,14));
but32=new JButton("保 存");
but32.setFont(new java.awt.Font("黑体",Font.BOLD,14));
but33=new JButton("放 弃");
but33.setFont(new java.awt.Font("黑体",Font.BOLD,14));
but34=new JButton("用户更换");
but34.setFont(new java.awt.Font("黑体",Font.BOLD,14));
but35=new JButton("锁屏离开");
but35.setFont(new java.awt.Font("黑体",Font.BOLD,14));
but36=new JButton("退 出");
but36.setFont(new java.awt.Font("黑体",Font.BOLD,14));
mianban1.setLayout(null);//设置面板布局为空布局
mianban2.setLayout(null);
mianban1.add(bq11);//向面板中添加标签和文本框
bq11.setBounds(280,0,260,40);//设置位置和大小
bq11.setFont(new java.awt.Font("华文新魏", Font.BOLD, 26));//设置字体
bq27.setBounds(280,0,260,40);
//bq27.setFont(new java.awt.Font("宋体", Font.HANGING_BASELINE,22));
bq27.setFont(new java.awt.Font("华文新魏", Font.BOLD,26));
mianban1.add(bq2);
bq2.setBounds(new Rectangle(60,50,110,20));
mianban1.add(txt1);
txt1.setBounds(120,50,125,20);
mianban1.add(bq3);
bq3.setBounds(new Rectangle(290,50,100,20));
//mianban1.add(txt2);
//txt2.setBounds(290,50,120,20);
mianban1.add(xiala);
xiala.setBounds(370,50,120,20);
xiala.addItem("请选择房型");
xiala.addItem("豪华套房");
xiala.addItem("商务套房");
xiala.addItem("标准套房");
xiala.addItem("豪华标间");
xiala.addItem("标 准 间");
mianban1.add(bq4);//向面板中添加标签
bq4.setBounds(new Rectangle(540,50,80,20));
mianban1.add(txt2);
txt2.setBounds(600,50,100,20);
mianban1.add(bq5);
bq5.setBounds(new Rectangle(60,90,80,20));
mianban1.add(txt3);
txt3.setBounds(new Rectangle(130,90,220,20));
mianban1.add(bq6);
bq6.setBounds(new Rectangle(390,90,60,20));
mianban1.add(txt4);
txt4.setBounds(new Rectangle(470,90,220,20));
mianban1.add(bq7);
bq7.setBounds(60, 170, 80, 20);
mianban1.add(txt7);
txt7.setBounds(130, 170, 200, 20);
mianban1.add(bq8);
bq8.setBounds(new Rectangle(60,130,80,20));
mianban1.add(txt5);
txt5.setBounds(new Rectangle(120,130,120,20));
mianban1.add(bq9);
bq9.setBounds(270, 130, 60, 20);
bg.add(ra1);
bg.add(ra2);
mianban1.add(bq12);
bq12.setBounds(320, 130, 20, 20);
mianban1.add(ra1);
ra1.setBounds(335,130,20,20);
mianban1.add(bq13);
bq13.setBounds(370, 130, 20, 20);
mianban1.add(ra2);
ra2.setBounds(385,130,20,20);
mianban1.add(bq10);
bq10.setBounds(420, 130,80,20);
mianban1.add(txt6);
txt6.setBounds(490,130,240,20); mianban1.add(bq14);
bq14.setBounds(350, 170, 300, 20);
//入住100按钮------------------------
rzan=new JPanel();
rzan.setLayout(new GridLayout(10,1));
rzan.setBounds(20, 200,750,340);
//rzan.setBackground(Color.red);
//rzan.setBorder(BorderFactory.createEtchedBorder());
JPanel [] pan = new JPanel[10];//负责装100个按钮
for(i=0;i<pan.length;i++){//for循环
pan[i]=new JPanel();//实例化按钮
}
DBcon db = new DBcon();//实例化连库类对象
db.consql();//开库
ResultSet res=db.selectsql("select * from room");//查询记录集
try{//异常处理
int j=0;//定义变量
for(i=0;i<rzanbutton.length;i++){//for循环
res.next();//将记录集游标移动到下一行
rzanbutton[i]=new JButton(); //从数据库读取记录
rzanbutton[i].setText(res.getString(1));//从数据库中读出第一行数据
String roomstate=res.getString(2);//从数据库中读出第二列数据
if(roomstate.equals("住客净房")){//比较第二列的值
rzanbutton[i].setBackground(Color.GREEN);
}
else if(roomstate.equals("空脏房")){//比较第二列的值
rzanbutton[i].setBackground(Color.MAGENTA);
}
else if(roomstate.equals("自用房")){//比较第二列的值
rzanbutton[i].setBackground(Color.red);
}
else if(roomstate.equals("维修房")){//比较第二列的值
rzanbutton[i].setBackground(Color.lightGray);
}
else if(roomstate.equals("住客脏房")){//比较第二列的值
rzanbutton[i].setBackground(Color.orange);
}
else if(roomstate.equals("空净房")){//比较第二列的值
rzanbutton[i].setBackground(Color.cyan);
}
pan[j].add(rzanbutton[i]);//向面板中添加按钮
if((i+1)%10==0){//设置添加按钮面板的循环
j++;
}
}
}catch(Exception ex){//设置捕获异常信息
}
db.closesql();//关库
for(i=0;i<pan.length;i++){//设置循环添加按钮
rzan.add(pan[i]);//向面板中添加小面板
}
mianban1.add(rzan);//将副面板添加到主面板
//图例---------------------
mianban1.add(bq70);
bq70.setBackground(Color.green);
bq70.setBounds(50, 560, 50, 30);
mianban1.add(bq15);
bq15.setBounds(105, 560, 50, 30);
mianban1.add(bq71);
bq71.setBackground(Color.magenta);
bq71.setBounds(160, 560, 50, 30);
mianban1.add(bq17);
bq17.setBounds(215, 560, 50, 30);
mianban1.add(bq72);
bq72.setBackground(Color.cyan);
bq72.setBounds(270, 560, 50, 30);
mianban1.add(bq19);
bq19.setBounds(325, 560, 60, 30);
mianban1.add(bq73);
bq73.setBackground(Color.orange);
bq73.setBounds(390, 560, 50, 30);
mianban1.add(bq21);
bq21.setBounds(445, 560, 60, 30);
mianban1.add(bq74);
bq74.setBackground(Color.red);
bq74.setBounds(510, 560, 50, 30);
mianban1.add(bq23);
bq23.setBounds(565, 560, 60, 30);
mianban1.add(bq75);
bq75.setBackground(Color.lightGray);
bq75.setBounds(625, 560, 50, 30);
mianban1.add(bq25);
bq25.setBounds(685, 560, 60, 30);
mianban1.add(but1);
but1.setBounds(770, 30, 100, 40);
mianban1.add(but2);
but2.setBounds(770, 80, 100, 40);
mianban1.add(but3);
but3.setBounds(770, 130, 100, 40);
mianban1.add(but4);
but4.setBounds(770, 180, 100, 40);
mianban1.add(but5);
but5.setBounds(770, 230, 100, 40);
mianban1.add(but6);
but6.setBounds(770, 280, 100, 40);
/**
*
* 房间查询界面
*/
zcxan=new JPanel();//实例化用来装按钮面板的面板
zcxan.setLayout(new GridLayout(10,1));//设置面板布局
zcxan.setBounds(20, 60,750,480);//设置面板位置
//rzan1.setBackground(Color.red);
JPanel [] pan1 = new JPanel[10];//负责装100个按钮
for(i=0;i<pan1.length;i++){//for循环实例化面板
pan1[i]=new JPanel();
}
db.consql();//开库
ResultSet res1=db.selectsql("select * from room");//查询记录集
try{//抛异常
int k=0;
for(i=0;i<cxbutton.length;i++){
res1.next();//将记录集游标移动到下一行
cxbutton[i]=new JButton(); //从数据库读取记录
cxbutton[i].setText(res1.getString(1));//从数据库中读出第一行数据
String roomstate1=res1.getString(2);//从数据库中读出第二列数据
if(roomstate1.equals("住客净房")){//比较第二列的值
cxbutton[i].setBackground(Color.GREEN);
}
else if(roomstate1.equals("空脏房")){//比较第二列的值
cxbutton[i].setBackground(Color.MAGENTA);
}
else if(roomstate1.equals("自用房")){//比较第二列的值
cxbutton[i].setBackground(Color.red);
}
else if(roomstate1.equals("维修房")){//比较第二列的值
cxbutton[i].setBackground(Color.lightGray);
}
else if(roomstate1.equals("住客脏房")){//比较第二列的值
cxbutton[i].setBackground(Color.orange);
}
else if(roomstate1.equals("空净房")){//比较第二列的值
cxbutton[i].setBackground(Color.cyan);
}
pan1[k].add(cxbutton[i]);
if((i+1)%10==0){
k++;
}
}
}catch(Exception ex){//捕获异常信息
}
db.closesql();//关库
for(i=0;i<pan1.length;i++){
zcxan.add(pan1[i]);
}
mianban2.add(zcxan);
// 添加面板2中的图例-----------------
mianban2.add(bq80);
bq80.setBackground(Color.green);
bq80.setBounds(50, 560, 50, 30);
mianban2.add(bq16);
bq16.setBounds(105, 560, 50, 30);
mianban2.add(bq81);
bq81.setBackground(Color.magenta);
bq81.setBounds(160, 560, 50, 30);
mianban2.add(bq18);
bq18.setBounds(215, 560, 50, 30);
mianban2.add(bq82);
bq82.setBackground(Color.cyan);
bq82.setBounds(270, 560, 50, 30);
mianban2.add(bq20);
bq20.setBounds(325, 560, 60, 30);
mianban2.add(bq83);
bq83.setBackground(Color.orange);
bq83.setBounds(390, 560, 50, 30);
mianban2.add(bq22);
bq22.setBounds(445, 560, 60, 30);
mianban2.add(bq84);
bq84.setBackground(Color.red);
bq84.setBounds(510, 560, 50, 30);
mianban2.add(bq24);
bq24.setBounds(565, 560, 60, 30);
mianban2.add(bq85);
bq85.setBackground(Color.lightGray);
bq85.setBounds(625, 560, 50, 30);
mianban2.add(bq26);
bq26.setBounds(685, 560, 60, 30);
mianban2.add(bq27);
mianban2.add(but11);
but11.setBounds(770, 30, 100, 40);
mianban2.add(but12);
but12.setBounds(770, 80, 100, 40);
mianban2.add(but13);
but13.setBounds(770, 130, 100, 40);
mianban2.add(but14);
but14.setBounds(770, 180, 100, 40);
mianban2.add(but15);
but15.setBounds(770, 230, 100, 40);
mianban2.add(but16);
but16.setBounds(770, 280, 100, 40);
/**
* 预定管理界面
*
*
*/
ydan=new JPanel();//实例化用来装按钮面板的面板
ydan.setLayout(new GridLayout(10,1));//设置布局
ydan.setBounds(20, 200,750,340);//设置位置
//ydan.setBackground(Color.red);//设置颜色 用来测试大小和位置
//ydan.setBorder(BorderFactory.createEtchedBorder());
JPanel [] pan2 = new JPanel[10];//负责装100个按钮
for(i=0;i<pan2.length;i++){//循环实例化面板
pan2[i]=new JPanel();
}
db.consql();//开库
ResultSet res2=db.selectsql("select * from room");//查询记录集
try{//抛异常
int z=0;
for(i=0;i<ydbutton.length;i++){
res2.next();//将记录集游标移动到下一行
ydbutton[i]=new JButton("0101"); //从数据库读取记录 ydbutton[i].setText(res2.getString(1));//从数据库中读出第一行数据
String roomstate2=res2.getString(2);//从数据库中读出第二列数据
if(roomstate2.equals("住客净房")){//比较第二列的值
ydbutton[i].setBackground(Color.GREEN);
}
else if(roomstate2.equals("空脏房")){//比较第二列的值
ydbutton[i].setBackground(Color.MAGENTA);
}
else if(roomstate2.equals("自用房")){//比较第二列的值
ydbutton[i].setBackground(Color.red);
}
else if(roomstate2.equals("维修房")){//比较第二列的值
ydbutton[i].setBackground(Color.lightGray);
}
else if(roomstate2.equals("住客脏房")){//比较第二列的值
ydbutton[i].setBackground(Color.orange);
}
else if(roomstate2.equals("空净房")){//比较第二列的值
ydbutton[i].setBackground(Color.cyan);
}
pan2[z].add(ydbutton[i]);
if((i+1)%10==0){
z++;
}
}
}catch(Exception ex){//捕获异常信息
}
db.closesql();//关库
for(i=0;i<pan2.length;i++){
ydan.add(pan2[i]);
}
mianban3.add(ydan);
mianban3.setLayout(null);
bq30=new JLabel("房 间 号:");
bq31=new JLabel("房间类型:");
bq32=new JLabel("房 价:");
bq33=new JLabel("抵达日期:");
bq34=new JLabel("预离日期:");
bq35=new JLabel("顾客姓名:");
bq36=new JLabel("联系方式:");
bq37=new JLabel("预 定 管 理");
bq40=new JLabel("空 净 房");
bq41=new JLabel("空 脏 房");
bq42=new JLabel("住客净房");
bq43=new JLabel("住客脏房");
bq44=new JLabel("自 用 房");
bq45=new JLabel("维 修 房");
txt14=new JTextField();
txt15=new JTextField();
txt16=new JTextField();
txt17=new JTextField();
txt18=new JTextField();
txt19=new JTextField();
txt20=new JTextField();
txt21=new JTextField();
txt22=new JTextField();
mianban3.add(bq30);
//bq30.setFont(new );
bq30.setBounds(60, 55, 110, 20);
mianban3.add(txt14);
txt14.setBounds(120, 55, 125, 20);
mianban3.add(bq31);
bq31.setBounds(new Rectangle(295,55,110,20)); mianban3.add(xiala1);
xiala1.setBounds(370,55,120,20);
xiala1.addItem("请选择房型");
xiala1.addItem("豪华套房");
xiala1.addItem("商务套房");
xiala1.addItem("标准套房");
xiala1.addItem("豪华标间");
xiala1.addItem("标 准 间");
mianban3.add(bq37);
bq37.setFont(new java.awt.Font("华文新魏", Font.BOLD, 26));
bq37.setBounds(300,0,200,40);
mianban3.add(bq32);
bq32.setBounds(new Rectangle(540,55,80,20));
mianban3.add(txt16);
txt16.setBounds(600,55,100,20);
mianban3.add(bq33);
bq33.setBounds(new Rectangle(60,95,80,20));
mianban3.add(txt17);
txt17.setBounds(new Rectangle(130,95,220,20));
mianban3.add(bq34);
bq34.setBounds(new Rectangle(390,95,60,20));
mianban3.add(txt18);
txt18.setBounds(new Rectangle(470,95,220,20));
mianban3.add(bq35);
bq35.setBounds(60, 135, 80, 20);
mianban3.add(txt19);
txt19.setBounds(130, 135, 200, 20);
mianban3.add(bq36);
bq36.setBounds(60, 175, 100, 20);
mianban3.add(txt20);
txt20.setBounds(130, 175, 260, 20);
mianban3.add(bq90);
bq90.setBackground(Color.green);
bq90.setBounds(50, 560, 50, 30);
mianban3.add(bq40);
bq40.setBounds(105, 560, 50, 30);
mianban3.add(bq91);
bq91.setBackground(Color.magenta);
bq91.setBounds(160, 560, 50, 30);
mianban3.add(bq41);
bq41.setBounds(215, 560, 50, 30);
mianban3.add(bq92);
bq92.setBackground(Color.cyan);
bq92.setBounds(270, 560, 50, 30);
mianban3.add(bq42);
bq42.setBounds(325, 560, 60, 30);
mianban3.add(bq93);
bq93.setBackground(Color.orange);
bq93.setBounds(390, 560, 50, 30);
mianban3.add(bq43);
bq43.setBounds(445, 560, 60, 30);
mianban3.add(bq94);
bq94.setBackground(Color.red);
bq94.setBounds(510, 560, 50, 30);
mianban3.add(bq44);
bq44.setBounds(565, 560, 60, 30);
mianban3.add(bq95);
bq95.setBackground(Color.lightGray);
bq95.setBounds(625, 560, 50, 30);
mianban3.add(bq45);
bq45.setBounds(685, 560, 60, 30);
mianban3.add(but21);
but21.setBounds(770, 30, 100, 40);
mianban3.add(but22);
but22.setBounds(770, 80, 100, 40);
mianban3.add(but23);
but23.setBounds(770, 130, 100, 40);
mianban3.add(but24);
but24.setBounds(770, 180, 100, 40);
mianban3.add(but25);
but25.setBounds(770, 230, 100, 40);
mianban3.add(but26);
but26.setBounds(770, 280, 100, 40);
/**
* 退房管理界面
*
*/
mianban4.setLayout(null);
txt23=new JTextField();
txt24=new JTextField();
txt25=new JTextField();
txt26=new JTextField();
txt27=new JTextField();
txt28=new JTextField();
txt29=new JTextField();
txt30=new JTextField();
txt31=new JTextField();
bq50=new JLabel("房 间 号:");
bq51=new JLabel("房间类型:");
bq52=new JLabel("房 价:");
bq53=new JLabel("抵达日期:");
bq54=new JLabel("退房日期:");
bq55=new JLabel("顾客姓名:");
bq56=new JLabel("证件号码:");
bq57=new JLabel("联系方式:");
bq58=new JLabel("(外地手机前加\"0\"或加区号,如:010-88888888)");
bq59=new JLabel("消费金额:");
bq60=new JLabel("退 房 管 理");
bq61=new JLabel("退房时请认真核对金额!!");
bq62=new JLabel("认真核对钱币数量,真假!");
mianban4.add(bq60);
bq60.setFont(new java.awt.Font("华文新魏", Font.BOLD, 26));
bq60.setBounds(280, 0, 300, 40);
mianban4.add(bq50);
bq50.setBounds(30, 50, 60, 20);
mianban4.add(txt23);
txt23.setBounds(90, 50, 140, 20);
mianban4.add(bq51);
bq51.setBounds(260, 50, 100, 20);
mianban4.add(txt24);
txt24.setBounds(330, 50, 140, 20);
mianban4.add(bq52);
bq52.setBounds(500, 50, 140, 20);
mianban4.add(txt25);
txt25.setBounds(560, 50, 140, 20);
mianban4.add(bq53);
bq53.setBounds(30, 90, 100, 20);
mianban4.add(txt26);
txt26.setBounds(100, 90, 220, 20);
mianban4.add(bq54);
bq54.setBounds(330, 90, 100, 20);
mianban4.add(txt27);
txt27.setBounds(400, 90, 220, 20);
mianban4.add(bq55);
bq55.setBounds(30, 130, 100, 20);
mianban4.add(txt28);
txt28.setBounds(100, 130, 120, 20);
mianban4.add(bq56);
bq56.setBounds(240, 130, 100, 20);
mianban4.add(txt29);
txt29.setBounds(320, 130, 320, 20);
mianban4.add(bq57);
bq57.setBounds(30, 170, 100, 20);
mianban4.add(txt30);
txt30.setBounds(100, 170, 400, 20);
mianban4.add(bq58);
bq58.setBounds(500, 170, 500, 20);
mianban4.add(bq59);
bq59.setBounds(30, 210, 100, 20);
mianban4.add(txt31);
txt31.setBounds(100, 210, 200, 20);
mianban4.add(bq61);
bq61.setFont(new java.awt.Font("华文新魏", Font.BOLD, 42));
bq61.setBounds(180, 280, 600, 100);
mianban4.add(bq62);
bq62.setFont(new java.awt.Font("华文新魏", Font.BOLD, 42));
bq62.setBounds(180, 400, 600, 100);
mianban4.add(but31);
but31.setBounds(770, 30, 100, 40);
mianban4.add(but32);
but32.setBounds(770, 80, 100, 40);
mianban4.add(but33);
but33.setBounds(770, 130, 100, 40);
mianban4.add(but34);
but34.setBounds(770, 180, 100, 40);
mianban4.add(but35);
but35.setBounds(770, 230, 100, 40);
mianban4.add(but36);
but36.setBounds(770, 280, 100, 40);
this.getContentPane().add(ge1);
ge1.setBounds(0, 0, 900,668);
Container contentPane = this.getContentPane();
contentPane.setLayout(null);
//this.setUndecorated(true);
this.setLayout(null);
this.setDefaultCloseOperation(3);
this.setTitle("酒店营业系统");
this.setBounds( 200, 60, 900, 668);
//this.setEnabled(false);//锁定
this.setVisible(true);
}
public static void main(String[] args) {
new house(); }
public void actionPerformed(ActionEvent ex) {
} }
public class DBcon{
//声明4个连库类对象
Connection con=null; //负责连接数据库
Statement stat=null; //负责执行Sql语句
PreparedStatement pstat=null;//负责执行带参数Sql语句
ResultSet rs=null;//负责记录查询的结果集
public DBcon(){
}
//定义4个方法
//开库方法
public void consql(){ //必须加异常
try{
//找到jdbc驱动
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//开始连接数据库
con=DriverManager.getConnection("jdbc:odbc:test","sa","");
System.out.println ("con ok!");
}catch(Exception ex){
ex.printStackTrace();
System.out.println ("con error!");
}
}
//关库方法
public void closesql(){
try {
if(rs!=null){
rs.close();
}
if(stat!=null){
stat.close();
}
if(pstat!=null){
pstat.close();
}
if(con!=null){
con.close();
}
System.out.println ("close ok!");
}
catch (Exception ex) {
ex.printStackTrace();
System.out.println ("close error!");
}
}
//执行增删改Sql语句的方法
public int updatesql(String sql){ //sql代表要执行的sql语句
int i=0;
try {
//创建Statement对象
stat=con.createStatement();
i=stat.executeUpdate(sql);
System.out.println ("update ok!");
}
catch (Exception ex) {
ex.printStackTrace();
System.out.println ("update error!");
}
return i;
}
//执行查询方法
public ResultSet selectsql(String sql){
try {
stat=con.createStatement(1005,1008);
rs=stat.executeQuery(sql);
System.out.println ("select ok");
}
catch (Exception ex) {
ex.printStackTrace();
System.out.println ("select error!");
}
return rs;
}
public static void main(String [] args){
int a;
DBcon t = new DBcon();
t.consql();
//a=t.updatesql("insert into stuInfo values(5,'王五','男')");
//t.updatesql("update stuInfo set stuSex='女' where stuName='王五'");
//a=t.updatesql("delete from stuInfo where stuName='王五'");
//System.out.println (a);
t.closesql();
}
}
create database hotel
use hotel-- 房间列表create table room
(
roomId varchar(20) primary key, -- 房间号
roomState varchar(20) not null check(roomState='住客净房' or roomState='住客脏房' or roomState='空脏房' or roomState='空净房' or roomState='维修房' or roomState='自用房'), -- 房间状态
roomPrice money not null check(roomPrice=888 or roomPrice=380 or roomPrice=260 or roomPrice=660 or roomPrice=180), -- 房价
roomFx varchar(20) not null check(roomFx='豪华套房' or roomFx='商务套房' or roomFx='标准套房' or roomFx='豪华标间' or roomFx='标准间') -- 房型
)drop table room-- 插入数据insert into room values('0101','住客净房',180,'标准间')
insert into room values('0102','住客净房',180,'标准间')
insert into room values('0103','空脏房',180,'标准间')
insert into room values('0104','空脏房',180,'标准间')
insert into room values('0105','空净房',180,'标准间')
insert into room values('0106','住客脏房',180,'标准间')
insert into room values('0107','空脏房',180,'标准间')
insert into room values('0108','住客净房',180,'标准间')
insert into room values('0109','空脏房',180,'标准间')
insert into room values('0110','住客净房',180,'标准间')
insert into room values('0111','住客脏房',180,'标准间')
insert into room values('0112','住客净房',180,'标准间')
insert into room values('0113','空脏房',180,'标准间')
insert into room values('0114','住客净房',180,'标准间')
insert into room values('0115','空净房',180,'标准间')
insert into room values('0116','空脏房',180,'标准间')
insert into room values('0117','住客净房',180,'标准间')
insert into room values('0118','空净房',180,'标准间')
insert into room values('0119','空脏房',180,'标准间')
insert into room values('0120','住客净房',180,'标准间')insert into room values('0201','住客净房',260,'标准套房')
insert into room values('0202','空净房',260,'标准套房')
insert into room values('0203','住客净房',260,'标准套房')
insert into room values('0204','空净房',260,'标准套房')
insert into room values('0205','住客脏房',260,'标准套房')
insert into room values('0206','住客脏房',260,'标准套房')
insert into room values('0207','空净房',260,'标准套房')
insert into room values('0208','住客净房',260,'标准套房')
insert into room values('0209','住客净房',260,'标准套房')
insert into room values('0210','住客脏房',260,'标准套房')
insert into room values('0211','住客脏房',260,'标准套房')
insert into room values('0212','住客净房',260,'标准套房')
insert into room values('0213','住客脏房',260,'标准套房')
insert into room values('0214','住客净房',260,'标准套房')
insert into room values('0215','空脏房',260,'标准套房')
insert into room values('0216','空净房',260,'标准套房')
insert into room values('0217','住客净房',260,'标准套房')
insert into room values('0218','住客净房',260,'标准套房')
insert into room values('0219','空脏房',260,'标准套房')
insert into room values('0220','空脏房',260,'标准套房')insert into room values('0301','空净房',380,'商务套房')
insert into room values('0302','住客净房',380,'商务套房')
insert into room values('0303','空脏房',380,'商务套房')
insert into room values('0304','住客净房',380,'商务套房')
insert into room values('0305','住客净房',380,'商务套房')
insert into room values('0306','空净房',380,'商务套房')
insert into room values('0307','住客脏房',380,'商务套房')
insert into room values('0308','住客净房',380,'商务套房')
insert into room values('0309','空脏房',380,'商务套房')
insert into room values('0310','住客脏房',380,'商务套房')
insert into room values('0311','住客净房',380,'商务套房')
insert into room values('0312','住客净房',380,'商务套房')
insert into room values('0313','住客脏房',380,'商务套房')
insert into room values('0314','住客净房',380,'商务套房')
insert into room values('0315','空脏房',380,'商务套房')
insert into room values('0316','住客净房',380,'商务套房')
insert into room values('0317','住客脏房',380,'商务套房')
insert into room values('0318','住客净房',380,'商务套房')
insert into room values('0319','空净房',380,'商务套房')
insert into room values('0320','住客脏房',380,'商务套房')insert into room values('0401','住客净房',660,'豪华标间')
insert into room values('0402','住客净房',660,'豪华标间')
insert into room values('0403','住客脏房',660,'豪华标间')
insert into room values('0404','住客净房',660,'豪华标间')
insert into room values('0405','住客脏房',660,'豪华标间')
insert into room values('0406','住客净房',660,'豪华标间')
insert into room values('0407','空净房',660,'豪华标间')
insert into room values('0408','住客净房',660,'豪华标间')
insert into room values('0409','空脏房',660,'豪华标间')
insert into room values('0410','住客净房',660,'豪华标间')
insert into room values('0411','住客净房',660,'豪华标间')
insert into room values('0412','空净房',660,'豪华标间')
insert into room values('0413','住客净房',660,'豪华标间')
insert into room values('0414','住客净房',660,'豪华标间')
insert into room values('0415','空脏房',660,'豪华标间')
insert into room values('0416','住客脏房',660,'豪华标间')
insert into room values('0417','住客净房',660,'豪华标间')
insert into room values('0418','空净房',660,'豪华标间')
insert into room values('0419','住客净房',660,'豪华标间')
insert into room values('0420','住客净房',660,'豪华标间')insert into room values('0501','住客净房',888,'豪华套房')
insert into room values('0502','空净房',888,'豪华套房')
insert into room values('0503','住客脏房',888,'豪华套房')
insert into room values('0504','空脏房',888,'豪华套房')
insert into room values('0505','空脏房',888,'豪华套房')
insert into room values('0506','住客净房',888,'豪华套房')
insert into room values('0507','住客净房',888,'豪华套房')
insert into room values('0508','空净房',888,'豪华套房')
insert into room values('0509','住客脏房',888,'豪华套房')
insert into room values('0510','空脏房',888,'豪华套房')
insert into room values('0511','住客脏房',888,'豪华套房')
insert into room values('0512','住客净房',888,'豪华套房')
insert into room values('0513','住客净房',888,'豪华套房')
insert into room values('0514','住客净房',888,'豪华套房')
insert into room values('0515','空脏房',888,'豪华套房')
insert into room values('0516','住客净房',888,'豪华套房')
insert into room values('0517','住客脏房',888,'豪华套房')
insert into room values('0518','空净房',888,'豪华套房')
insert into room values('0519','自用房',888,'豪华套房')
insert into room values('0520','维修房',888,'豪华套房')
update room set roomState='自用房' where roomId='0519'
update room set roomState='维修房' where roomId='0520'
delete from roomselect * from room
--查询房间状态
select roomState from room group by roomState-- 入住退房表create table ruzhu
(
ruzhuId varchar(20) foreign key references room(roomId), -- 房间号
ruzhuName varchar(20) not null, -- 姓名
ruzhuSex varchar(2) check(ruzhuSex='男' or ruzhuSex='女'), -- 性别
ruzhuCode varchar(20) not null, -- 身份证
ruzhuTouch varchar(20) not null, -- 联系方式
ruzhuTime varchar(20) not null, -- 入住时间
ruzhuTuiTime varchar(20) -- 退房时间
)
drop table ruzhu
static int rm,rr;
int [] a = new int [33];
Frame f = new Frame("ﾋｫﾉｫﾇ貊摠"); TextField tf = new TextField();
Random rd = new Random();
public shuangSeQiu()
{
for(i=0;i<33;i++)
{
a[i] = i;
} f.setLayout(new BorderLayout());
f.addWindowListener(new WindowAdapter(){
public void windowClosing(WindowEvent e)
{
System.exit(0);
}
});
} public void init()
{ tf.addActionListener(this); Button b = new Button("ｿｪﾊｼ");
b.addActionListener(this);
f.add(tf,"North");
f.add(b);
f.setSize(300,300);
f.setVisible(true); } public void actionPerformed(ActionEvent e)
{
if(e.getActionCommand().equals("ｿｪﾊｼ"))
//tf.setText(""+(rd.nextInt(33)+1)+" "+(rd.nextInt(33)+1)+" "+(rd.nextInt(33)+1)+" "+(rd.nextInt(33)+1)+" "+(rd.nextInt(33)+1)+" "+(rd.nextInt(33)+1)+" ﾀｶﾉｫﾇﾅﾂ・ｺ"+(rd.nextInt(15)+1));
{
/*rr = new Random().nextInt(33);
rm = new Random().nextInt(33);*/
for(i=0;i<33;i++)
{
rr = new Random().nextInt(33);
rm = new Random().nextInt(33);
System.out.print(rr+" ");
k=a[rm];
a[rm]=a[rr];
a[rr]=k;
}
tf.setText("ｺ・ｫﾇﾅﾂ・ｺ"+(a[0]+1)+" "+(a[1]+1)+" "+(a[2]+1)+" "+(a[3]+1)+" "+(a[4]+1)+" "+(a[5]+1)+" ﾀｶﾉｫﾇﾅﾂ・ｺ"+(rd.nextInt(15)+1));
}
}
public static void main(String[] args)//throws Exception
{
new shuangSeQiu().init();
}
}