footinfo.java

酒店管理系统（单机版）,根据酒店的日常业务运作而设计

package cg;

import java.awt.BorderLayout;
import java.awt.Dimension;

import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JLabel;
import java.awt.Rectangle;
import javax.swing.JTextField;
import javax.swing.JComboBox;
import javax.swing.BorderFactory;
import java.awt.Color;
import javax.swing.JTextArea;
import javax.swing.JButton;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;

class footInfo extends JFrame implements ActionListener, ItemListener
{

	String[] strtf={"0"};
//	String[] strfj={"101","102","103","201","202","203","301","302","303"};
	public odbc dbo=new odbc();
	public JButton jButton1,jButton2;
	public Connection con;
	public JTextField jTextField1= new JTextField();
	public JComboBox jComboBox1 = new JComboBox(dbo.getAllTabelName2());
	public JComboBox jComboBox2 = new JComboBox(strtf);
	
	
	public JLabel jLabel3 = new JLabel();
	public JLabel jLabel5 = new JLabel();
	public JLabel jLabel7 = new JLabel();
	public JLabel jLabel9 = new JLabel();
	public JLabel jLabel11 = new JLabel();
	public JLabel jLabel13 = new JLabel();
	public JComboBox jTextArea1 = new JComboBox(dbo.getAllTabelName3());  //改为帐单号
	public JLabel jLabel14 = new JLabel();
	
	public static float jg,zk,rztime,tftime;
	public static float addname;
	public static String strbox1,strtxt1;
	public static String str;            // 静态流水号
	
	
	public footInfo()
	{
		
		
		JPanel contentPane;
	    JLabel jLabel1 = new JLabel();
	    JLabel jLabel2 = new JLabel();
	    JLabel jLabel4 = new JLabel();
	    JLabel jLabel6 = new JLabel();
	    JLabel jLabel8 = new JLabel();
	    JLabel jLabel10 = new JLabel();
	    JLabel jLabel12 = new JLabel();
//	    JLabel jLabel14 = new JLabel();
//	    JTextField jTextField1 = new JTextField();
	    JLabel jLabel15 = new JLabel();
//	    JComboBox jComboBox2 = new JComboBox(strtf);
	    jComboBox2.enable(false);
	    JLabel jLabel16 = new JLabel();
//	    JTextArea jTextArea1 = new JTextArea();
	    JButton jButton1 = new JButton();
	    JButton jButton2 = new JButton();
	    
	    contentPane = (JPanel) getContentPane();
	    contentPane.setLayout(null);
	    setSize(new Dimension(471, 300));
	    jLabel1.setText("客房编号");
	    jLabel1.setBounds(new Rectangle(18, 35, 57, 25));
	    jComboBox1.setBounds(new Rectangle(75, 35, 80, 26));
	    jLabel2.setText("客房种类");
	    jLabel2.setBounds(new Rectangle(165, 35, 60, 23));
	    jLabel3.setBorder(BorderFactory.createLoweredBevelBorder());
	    jLabel3.setBounds(new Rectangle(225, 35, 71, 26));
	    jLabel4.setText("客房单价");
	    jLabel4.setBounds(new Rectangle(306, 35, 60, 23));
	    jLabel5.setBorder(BorderFactory.createLoweredBevelBorder());
	    jLabel5.setBounds(new Rectangle(367, 35, 79, 26));
	    jLabel6.setText("顾客姓名");
	    jLabel6.setBounds(new Rectangle(18, 91, 57, 25));
	    jLabel7.setBorder(BorderFactory.createLoweredBevelBorder());
	    jLabel7.setBounds(new Rectangle(75, 91, 80, 26));
	    jLabel8.setText("顾客身份证号码");
	    jLabel8.setBounds(new Rectangle(165, 90, 94, 25));
	    jLabel9.setBorder(BorderFactory.createLoweredBevelBorder());
	    jLabel9.setBounds(new Rectangle(270, 90, 176, 26));
	    jLabel10.setText("入住时间");
	    jLabel10.setBounds(new Rectangle(18, 147, 57, 25));
	    jLabel11.setBorder(BorderFactory.createLoweredBevelBorder());
	    jLabel11.setBounds(new Rectangle(75, 147, 80, 26));
	    jLabel12.setDisplayedMnemonic('0');
	    jLabel12.setHorizontalAlignment(SwingConstants.LEFT);
	    jLabel12.setText("折扣");
	    jLabel12.setBounds(new Rectangle(165, 147, 60, 23));
	    jLabel13.setBorder(BorderFactory.createLoweredBevelBorder());
	    jLabel13.setBounds(new Rectangle(225, 147, 71, 26));
	    jLabel14.setText("退房时间");
	    jLabel14.setBounds(new Rectangle(306, 147, 60, 23));
	    jTextField1.setBounds(new Rectangle(367, 147, 79, 26));
	    jLabel15.setText("是否入住");
	    jLabel15.setBounds(new Rectangle(165, 212, 60, 23));
	    jComboBox2.setBounds(new Rectangle(225, 212, 71, 26));
	    jLabel16.setText("帐单号");
	    jLabel16.setBounds(new Rectangle(306, 212, 60, 23));
	    jTextArea1.setBounds(new Rectangle(367, 212, 70, 26));
	    jButton1.setBounds(new Rectangle(18, 212, 60, 23));
	    jButton1.setText("结算");
	    jButton2.setBounds(new Rectangle(89, 212, 60, 23));
	    jButton2.setText("取消");
	    contentPane.add(jComboBox1);
	    contentPane.add(jLabel7);
	    contentPane.add(jLabel12);
	    contentPane.add(jLabel13);
	    contentPane.add(jLabel11);
	    contentPane.add(jTextField1);
	    contentPane.add(jLabel1);
	    contentPane.add(jLabel3);
	    contentPane.add(jLabel2);
	    contentPane.add(jLabel5);
	    contentPane.add(jLabel6);
	    contentPane.add(jLabel10);
	    contentPane.add(jLabel8);
	    contentPane.add(jLabel9);
	    contentPane.add(jLabel4);
	    contentPane.add(jLabel14);
	    contentPane.add(jLabel16);
	    contentPane.add(jComboBox2);
	    contentPane.add(jButton2);
	    contentPane.add(jLabel15);
	    contentPane.add(jButton1);
	    contentPane.add(jTextArea1);
	    
	    jButton1.addActionListener(this);
        jButton2.addActionListener(this);
        
        
        jComboBox1.addItemListener(this);
        jTextArea1.addItemListener(new add());
        
        jButton1.setActionCommand("true");
        jButton2.setActionCommand("false");
  
  	    this.setTitle("结帐窗口");
		this.setSize(480,300);
		this.setResizable(false);
		//this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		this.setLocationRelativeTo(this);
		this.setVisible(true);
		
		try
	        {
	            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	            con = DriverManager.getConnection("jdbc:odbc:myOdbc", "sa", "");
	            System.out.println("OK");
	        }
	        catch (ClassNotFoundException cnfe)
	        {
	            cnfe.printStackTrace();
	            System.out.println ("出错");
	        }
	        catch (SQLException sqle)
	        {
	            sqle.printStackTrace();
	            System.out.println ("出错");
	        }
	        
	}
	public void itemStateChanged(ItemEvent ie)
	{
			String str = (String)jComboBox1.getSelectedItem();		
			try
			{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				con = DriverManager.getConnection("jdbc:odbc:myodbc","sa","");
				Statement sta = con.createStatement();
				String strsql = "select * from footinfo where 客房编号 =";
				ResultSet rs = sta.executeQuery(strsql+str);
				System.out.println (strsql+str);
				
				while(rs.next())
				{
					jLabel3.setText(rs.getString(2));    //房种类
					jLabel5.setText(rs.getString(4));    //房单价
					jLabel13.setText(rs.getString(5));   //折扣
				}
				
						
				System.out.println ("rs.getString(2)");
				System.out.println ("rs.getString(4)");
				System.out.println ("rs.getString(5)");		
			}
			catch(Exception sql)
			{
				sql.printStackTrace();
			}
		}
	
	public void add(){
		jg=java.lang.Float.parseFloat(jLabel5.getText());
		rztime=java.lang.Float.parseFloat(jLabel11.getText());
		zk=java.lang.Float.parseFloat(jLabel13.getText());
		tftime=java.lang.Float.parseFloat(jTextField1.getText());
		
		addname=(tftime-rztime)*jg*zk;
		
		strbox1=(String)jComboBox2.getSelectedItem();
		strtxt1=jTextField1.getText();
		
		System.out.println (jg);
		System.out.println (rztime);
		System.out.println (zk);
		System.out.println (tftime);	
	}
	
	
	
	public void actionPerformed(ActionEvent e)
	{
		String str=e.getActionCommand();
		if(str.equals("false"))
		{
			this.setVisible(false);
		}
		if(str.equals("true"))
		{
			String a = jTextField1.getText();
			if(a.equals(""))
			{
				JOptionPane.showMessageDialog(this,"请您填写退房时间！","提示",JOptionPane.ERROR_MESSAGE);
							
			}
			else
			{
				
				
				jComboBox2.enable(true);
				add();
				new jiesuan();
			}
		}
	}
	
	
	class add implements  ItemListener{
		
		public void itemStateChanged(ItemEvent ie){
			 try{
			 	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				con = DriverManager.getConnection("jdbc:odbc:myodbc","sa","");
				Statement sta = con.createStatement();
				str = (String)jTextArea1.getSelectedItem();
				
				System.out.println ("第到的元素是："+str);
				
				String strsql = "select * from dingfangxinxi where 账单流水号 =";
				ResultSet rs = sta.executeQuery(strsql+str);
				System.out.println (strsql+str);
				
				while(rs.next())
				{
					jLabel7.setText(rs.getString(6));    //姓名
					jLabel9.setText(rs.getString(7));    //身份证
					jLabel11.setText(rs.getString(8));   //入住时间
				}
			 	
			 }catch(Exception ex){
			 	ex.printStackTrace();
			 	System.out.println ("下面的事件出错了！");
			 }
		}
	}
}