test.java

一个java源码的酒店管理系统

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.setText(null);
	   handcode1.setText(null);
	   
	    roomnum1.setText(null);
	   roomprice1.setText(null);
	   roomcount1.setText(null);
	   handcode1.setText(null);
	   billcode1.setText(null);
	
	 hint1.setText("操作提示");
	 	 hint2.setText("操作提示");

}
}); 


m12.addActionListener(new ActionListener(){          
	public void actionPerformed(ActionEvent e){
		

  final JFrame f=new JFrame("菜单信息");
    
 f.addWindowListener(
   new WindowAdapter()
   {
    public void windowClosing(WindowEvent e)
    {
   
    f.dispose();
    }
   }
  );
  
  try
     {
     	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     }catch(java.lang.ClassNotFoundException ex){}  
     
     
try{

 	 String[] names;
  int i,j,RowNum,ColNum;
  Object[][] info;
    	String url="jdbc:odbc:HOTEL";
    Connection con=DriverManager.getConnection(url,"",null);

    Statement stmt=con.createStatement();
  
  
  String sql="select count(*) from foodinfo";  //取得数据表的记录数和字段数
  ResultSet res=stmt.executeQuery(sql);
  res.next(); 
  RowNum=res.getInt(1);
  String sqlstr="select * from foodinfo";
  
 res=stmt.executeQuery(sqlstr);

 
  ResultSetMetaData rsmd=res.getMetaData();
  ColNum=rsmd.getColumnCount();
  
  names=new String[ColNum];     //构造JTable
  for (i=1;i<=ColNum;i++) names[i-1]=rsmd.getColumnName(i);
  info=new Object[RowNum][];
  i=0;
  
  
  while (res.next())
  {
   info[i]=new Object[ColNum];
   for (j=1;j<=ColNum;j++)
   {
    info[i][j-1]=res.getObject(j);
   }
   i++;
  }
  
  
  JTable table=new JTable(info,names);
  table.setPreferredScrollableViewportSize(new Dimension(400,200));
  
  JScrollPane scrollPane=new JScrollPane(table);
  Container cont=f.getContentPane();
  cont.add(scrollPane);
  
  
  f.pack();
  f.setLocation(300,300);
  f.setResizable(false);
  f.setVisible(true);

}	catch(SQLException ex){}
		
}
});  

//////////////////////////////////////////////////////////
m13.addActionListener(new ActionListener(){          
	public void actionPerformed(ActionEvent e){
		

  final JFrame n=new JFrame("房间信息");
    
 n.addWindowListener(
   new WindowAdapter()
   {
    public void windowClosing(WindowEvent e)
    {
   
    n.dispose();
    }
   }
  );
  
  try
     {
     	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     }catch(java.lang.ClassNotFoundException ex){}  
     
     
try{

 	 String[] names;
  int i,j,RowNum,ColNum;
  Object[][] info;
    	String url="jdbc:odbc:HOTEL";
    Connection con=DriverManager.getConnection(url,"",null);

    Statement stmt=con.createStatement();
  
  
  String sql="select count(*) from roominfo";  //取得数据表的记录数和字段数
  ResultSet res=stmt.executeQuery(sql);
  res.next(); 
  RowNum=res.getInt(1);
  String sqlstr="select * from roominfo";
  
 res=stmt.executeQuery(sqlstr);

 
  ResultSetMetaData rsmd=res.getMetaData();
  ColNum=rsmd.getColumnCount();
  
  names=new String[ColNum];     //构造JTable
  for (i=1;i<=ColNum;i++) names[i-1]=rsmd.getColumnName(i);
  info=new Object[RowNum][];
  i=0;
  
  
  while (res.next())
  {
   info[i]=new Object[ColNum];
   for (j=1;j<=ColNum;j++)
   {
    info[i][j-1]=res.getObject(j);
   }
   i++;
  }
  
  
  JTable table=new JTable(info,names);
  table.setPreferredScrollableViewportSize(new Dimension(400,200));
  
  JScrollPane scrollPane=new JScrollPane(table);
  Container cont=n.getContentPane();
  cont.add(scrollPane);
  
  
  n.pack();
  n.setLocation(300,300);
  n.setResizable(false);
  n.setVisible(true);

}	catch(SQLException ex){}
		
}
});  
////////////////////////////////////////////////////////

///////////////////////////////////
m14.addActionListener(new ActionListener(){          
	public void actionPerformed(ActionEvent e){
		

  final JFrame n=new JFrame("服务信息");
    
 n.addWindowListener(
   new WindowAdapter()
   {
    public void windowClosing(WindowEvent e)
    {
   
    n.dispose();
    }
   }
  );
  
  try
     {
     	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     }catch(java.lang.ClassNotFoundException ex){}  
     
     
try{

 	 String[] names;
  int i,j,RowNum,ColNum;
  Object[][] info;
    	String url="jdbc:odbc:HOTEL";
    Connection con=DriverManager.getConnection(url,"",null);

    Statement stmt=con.createStatement();
  
  
  String sql="select count(*) from serviceinfo";  //取得数据表的记录数和字段数
  ResultSet res=stmt.executeQuery(sql);
  res.next(); 
  RowNum=res.getInt(1);
  String sqlstr="select * from serviceinfo";
  
 res=stmt.executeQuery(sqlstr);

 
  ResultSetMetaData rsmd=res.getMetaData();
  ColNum=rsmd.getColumnCount();
  
  names=new String[ColNum];     //构造JTable
  for (i=1;i<=ColNum;i++) names[i-1]=rsmd.getColumnName(i);
  info=new Object[RowNum][];
  i=0;
  
  
  while (res.next())
  {
   info[i]=new Object[ColNum];
   for (j=1;j<=ColNum;j++)
   {
    info[i][j-1]=res.getObject(j);
   }
   i++;
  }
  
  
  JTable table=new JTable(info,names);
  table.setPreferredScrollableViewportSize(new Dimension(400,200));
  
  JScrollPane scrollPane=new JScrollPane(table);
  Container cont=n.getContentPane();
  cont.add(scrollPane);
  
  
  n.pack();
  n.setLocation(300,300);
  n.setResizable(false);
  n.setVisible(true);

}	catch(SQLException ex){}
		
}
});  
//////////////////////////////////////////////
////////////////////////////////////////////////
m21.addActionListener(new ActionListener(){          
	public void actionPerformed(ActionEvent e){
		
	my=new Dialog(test.this,"订房",true);
	my.setLayout(new FlowLayout(FlowLayout.LEADING,20,20));
	my.add(roomnum);
    my.add(roomnum1);
     
	my.add(roomprice);
	my.add(roomprice1);
	
	my.add(roomcount);
	my.add(roomcount1);
	
	my.add(handcode);
	my.add(handcode1);
	
	my.add(billcode);
	my.add(billcode1);