import java.awt.*;
import java.awt.event.*;
import java.applet.*;
import java.sql.*;
import javax.swing.*;
public class test extends JFrame {
//////////////////////////////////////////////主窗口
JMenuBar mb=new JMenuBar();
JMenu b1=new JMenu("相关查询");
JMenuItem m11=new JMenuItem("添加客人信息");
JMenuItem m12 = new JMenuItem("查询餐饮");
JMenuItem m13 = new JMenuItem("查询房间");
JMenuItem m14 = new JMenuItem("查询服务");
JMenuItem m15 = new JMenuItem("查询消费项目");
JMenuItem m16= new JMenuItem("查询帐单");
JMenuItem m17 = new JMenuItem("帐单操作");
JMenu b2=new JMenu("消费");
JMenuItem m21=new JMenuItem("订房");
JMenuItem m22=new JMenuItem("服务");
JMenuItem m23=new JMenuItem("订餐");
JLabel hint = new JLabel("欢迎使用酒店管理系统");
// JLabel imageLabel = new JLabel();
//ImageIcon image;
Dialog my;
/////////////////////////////////////////////////////////
//////////////////////////////////////////////////////添加客人信息界面
JLabel altname=new JLabel("请输入要修改号码的姓名:");
JLabel id=new JLabel("请输入证件号码:");
JLabel idtype=new JLabel("请输入证件类型:");
JLabel name=new JLabel("请输入姓名:");
JLabel sex=new JLabel("请输入性别:");
JLabel address=new JLabel("请输入住址:");
JLabel remark=new JLabel("请输入说明备注:");
JLabel handcode=new JLabel("请输入手牌号:");
JTextField id1=new JTextField(25);
JTextField idtype1=new JTextField(25);
JTextField name1=new JTextField(25);
JTextField sex1=new JTextField(25);
JTextField address1=new JTextField(25);
JTextField remark1=new JTextField(25);
JTextField handcode1=new JTextField(25);
JButton qd=new JButton("确定"); //按钮
JButton qd1=new JButton("确定"); //按钮
JButton tj=new JButton("添加客人"); //按钮
JLabel hint1=new JLabel("操作提示");
JButton tc=new JButton("退出"); //按钮
//////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////订房信息
JLabel roomnum=new JLabel("请输入房号:");
JLabel roomprice=new JLabel("请输入房间价格:");
JLabel roomcount=new JLabel("请输入订房数量:");
JLabel billcode=new JLabel("请输入帐单号:");
JTextField roomnum1=new JTextField(25);
JTextField roomprice1=new JTextField(25);
JTextField billcode1=new JTextField(25);
JTextField roomcount1=new JTextField(25);
JButton df=new JButton("订房"); //按钮
JLabel hint2=new JLabel("操作提示");
//JButton tc=new JButton("退出"); //按钮
//////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////服务窗口
JLabel sername=new JLabel("请输入服务名称:");
JLabel sercount=new JLabel("请输入服务的数量:");
JLabel serprice=new JLabel("请输入单个服务价格:");
JTextField sername1=new JTextField(25);
JTextField sercount1=new JTextField(25);
JTextField serprice1=new JTextField(25);
JButton fw=new JButton("预订服务"); //按钮
JLabel hint3=new JLabel("操作提示");
//////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////订餐窗口
JLabel foodname=new JLabel("请输入餐饮名称:");
JLabel foodcount=new JLabel("请输入餐饮的数量:");
JLabel foodprice=new JLabel("请输入单个餐饮价格:");
JTextField foodname1=new JTextField(25);
JTextField foodcount1=new JTextField(25);
JTextField foodprice1=new JTextField(25);
JButton dc=new JButton("点菜"); //按钮
JLabel hint4=new JLabel("操作提示");
//////////////////////////////////////////////////////////////
JLabel handnum=new JLabel("请输入要查询帐单的手牌号:");
JLabel hand=new JLabel("请输入要结帐的手牌号:");
JTextField hand1=new JTextField(22);
JLabel billnum=new JLabel("请输入要结帐的帐单号");
JTextField billnum1=new JTextField(23);
JLabel paid=new JLabel("请输入实交金额:");
JTextField paid1=new JTextField(26);
JButton xf=new JButton("查询消费情况");
JButton jz=new JButton("结帐"); //按钮
JLabel hint5=new JLabel("操作提示");
//////////////////////////////////////////////////////
public test() {
super("酒店管理系统");
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundException ex){}
//image = new ImageIcon(test.class.getResource("d:/thor.jpg"));
//imageLabel.setIcon(image);
//this.getContentPane().add(imageLabel,BorderLayout.CENTER);
hint.setFont(new Font("Alias",Font.BOLD,25));
setLayout(new GridBagLayout());
GridBagConstraints gridBag=new GridBagConstraints();
gridBag.fill=GridBagConstraints.HORIZONTAL;
gridBag.weightx=0;
gridBag.weighty=0;
setJMenuBar(mb);
b1.add(m11);
b1.add(m12);
b1.add(m13);
b1.add(m14);
b1.add(m15);
b1.add(m16);
b1.add(m17);
mb.add(b1);
b2.add(m21);
b2.add(m22);
b2.add(m23);
mb.add(b2);
add(hint);
gridBag.fill=GridBagConstraints.BOTH;
gridBag.weightx=100;
gridBag.weighty=100;
setSize(500,400);
setVisible(true);
//////////////////////////////////////////////////添加客人模块
m11.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
my=new Dialog(test.this,"注册新客人",true);
my.setLayout(new FlowLayout(FlowLayout.LEADING,20,20));
my.add(id);
my.add(id1);
my.add(idtype);
my.add(idtype1);
my.add(name);
my.add(name1);
my.add(sex);
my.add(sex1);
my.add(address);
my.add(address1);
my.add(remark);
my.add(remark1);
my.add(handcode);
my.add(handcode1);
my.add(tj);
my.add(hint1);
my.add(tc);
my.setSize(460,450);
my.setVisible(true);
}
});
tj.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
String url="jdbc:odbc:HOTEL";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(java.lang.ClassNotFoundException ex){}
try{String s1,s2,s3,s4,s5,s6,s7;
Connection con=DriverManager.getConnection(url,"",null);
Statement stmt=con.createStatement();
s1=id1.getText();
s2=idtype1.getText();
s3=name1.getText();
s4=sex1.getText();
s5=address1.getText();
s6=remark1.getText();
s7=handcode1.getText();
String sql="INSERT INTO guest(id,idtype,name,sex,address,remark,handcode) VALUES(?,?,?,?,?,?,?)";
PreparedStatement ps=con.prepareStatement(sql);
ps.setString(1,s1);
ps.setString(2,s2);
ps.setString(3,s3);
ps.setString(4,s4);
ps.setString(5,s5);
ps.setString(6,s6);
ps.setString(7,s7);
String sql1="INSERT INTO bill(handcode,billcode,summoney,paid,repaid,paidtype) VALUES(?,0,0,0,0,false)";
PreparedStatement ps1=con.prepareStatement(sql1);
ps1.setString(1,s7);
if(s1.length()!=0&&s2.length()!=0&&s3.length()!=0&&s4.length()!=0
&&s7.length()!=0){
ps.executeUpdate();
ps1.executeUpdate();
hint1.setText("注册成功!");
stmt.close();
con.close();
}
else{
stmt.close();
con.close();
hint1.setText("注册失败!");
}
}
catch(SQLException ex){}
}
});
////////////////////////////////////////////////////////////////
tc.addActionListener(new ActionListener(){ //退出按钮
public void actionPerformed(ActionEvent e){
my.dispose();
id1.setText(null);
idtype1.setText(null);
name1.setText(null);
sex1.setText(null);
address1.setText(null);
remark1.s