testkaifang.java

java开发的酒店管理系统

import java.awt.*;
import java.awt.event.*;
import java.awt.geom.*;
import javax.swing.*;
import javax.imageio.*;
import java.io.*;
import javax.swing.JLabel;
import java.awt.Window;
import java.sql.*;
import javax.swing.event.*;
import java.awt.MediaTracker;
import java.util.*;

/*public class testKaiFang
{
	public static void main(String args[])
	{
		kaiFangOk KFOK=new kaiFangOk("213");
		KFOK.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		KFOK.setVisible(true);
	}
}*/

class kaiFangOk extends JFrame
{
	public kaiFangOk(String tell)
	{
		setResizable(false);
		setBackground(new Color(204,255,255));
		Toolkit kit =Toolkit.getDefaultToolkit();
		Dimension screenSize=kit.getScreenSize();
		int screenWidth=screenSize.width;
		int screenHeight=screenSize.height;
		setLocation((screenWidth-DEFA_W)/2,(screenHeight-DEFA_H)/2);
	  setSize(DEFA_W,DEFA_H);
	  setTitle("酒店客房管理系统");
	  KFOKP=new kaiFangOkPane(tell);
		add(KFOKP);
		
	}	
	private kaiFangOkPane KFOKP;
	
	private final int DEFA_W=500;
	private final int DEFA_H=432;
}

class kaiFangOkPane extends JPanel
{
	public kaiFangOkPane(String tell)
	{
		canShu=tell;
		setLayout(null);
		getImage();
		addXiangMu();
		try
		{
			connDBQ();
		}
		catch(SQLException e){}
		try
		{
			while(rs.next())
			{
				if(TELLKONG==null)
				TELLKONG=rs.getString("tell")+" ";
				else
				TELLKONG=TELLKONG+rs.getString("tell")+" ";
			}
		}
		catch(SQLException ee){}
		//System.out.println(TELLKONG);
		try
		{
			rs=stmt.executeQuery("select * from kefangxinxi");
			while(rs.next())
			{
				if(TELLALL==null)
				TELLALL=rs.getString("tell")+" ";
				else
				TELLALL=TELLALL+rs.getString("tell")+" ";
			}
		}
		catch(SQLException e){}
	}
	
	public void paintComponent(Graphics g)
	{
		super.paintComponent(g);
		Graphics2D g2=(Graphics2D)g;
		g2.drawImage(img,0,0,null);
	}
	
	public void addXiangMu()
	{
		Tell=new JTextField();
		name=new JTextField();
		shenFenZheng=new JTextField();
		//xingBie=new JTextField();
		yuFuKuan=new JTextField();
		beiZhu=new JTextField();
		queDing=new JButton("确定");
		fanHui=new JButton("返回");
		add(Tell);
		add(name);
		add(shenFenZheng);
		//add(xingBie);
		add(yuFuKuan);
		add(beiZhu);
		add(queDing);
		add(fanHui);
		Tell.setBounds(130,110,150,30);
		Tell.setText(canShu);
		name.setBounds(130,170,150,30);
		//xingBie.setBounds(380,170,60,30);
		shenFenZheng.setBounds(130,235,150,30);
		yuFuKuan.setBounds(380,235,60,30);
		beiZhu.setBounds(130,305,330,30);
		queDing.setBounds(330,350,60,30);
		fanHui.setBounds(410,350,60,30);
		queDingAction QDA=new queDingAction();
		queDing.addActionListener(QDA);
		xingbie1=new JRadioButton("男",true);
		xingbie2=new JRadioButton("女",false);
		xingBieAll=new ButtonGroup();
		add(xingbie1);
		add(xingbie2);
		xingBieAll.add(xingbie1);
		xingBieAll.add(xingbie2);
		xingbie1.setBounds(380,170,40,20);
		xingbie2.setBounds(440,170,40,20);
		xingbie1.setBackground(new Color(251,237,207));
		xingbie2.setBackground(new Color(251,237,207));
		xingBie1Action XB1A=new xingBie1Action();
		xingBie2Action XB2A=new xingBie2Action();
		xingbie1.addActionListener(XB1A);
		xingbie2.addActionListener(XB2A);
		
	}
	
	public void getImage()
	{
		try
		{
			img=ImageIO.read(new File("img\\kaifang.jpg"));
		}
		catch(IOException e){}
	}
	
	public void getData()
	{
		TELL=Tell.getText().trim();
		NAME=name.getText().trim();
		SHENFENZHENG=shenFenZheng.getText().trim();
		//XINGBIE=xingBie.getText().trim();
		YUFUKUAN=yuFuKuan.getText().trim();
		BEIZHU=beiZhu.getText().trim();
		GregorianCalendar gregor;
		gregor=new GregorianCalendar();
		int year=gregor.get(Calendar.YEAR);
		int month=gregor.get(Calendar.MONTH)+1;
		int day=gregor.get(Calendar.DAY_OF_MONTH);
		TIMER=(year*100+month)*100+day;
		//System.out.println(TELL);
	}
	
	public void connDBQ() throws SQLException
	{
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch(ClassNotFoundException e){}
		String URL="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=mdb.mdb";
		conn=DriverManager.getConnection(URL);
		stmt=conn.createStatement();
		//stmt.executeUpdate("insert into dengji(name,shenfenzheng,fangjianhao,timer,xingbie) value ('" + NAME + "','" + SHENFENZHENG + "','" + TELL+"','"+ TIMER +",',"+XINGBIE+"'");
		rs=stmt.executeQuery("select * from kefangxinxi where kong like 'y'");
	}
	
	private class queDingAction implements ActionListener
	{
		public void actionPerformed(ActionEvent Event)
		{
			boolean bool=true;
			getData();
			if(TELL.length()!=0)						//验证房间号
			{
				if(TELLALL.indexOf(TELL)<0)
				{
					JOptionPane.showMessageDialog(null,"没有此客房，请检查输入");
					bool=false;
				}
				if(bool)
				{
					if(TELLKONG.indexOf(TELL)<0)
					{
						JOptionPane.showMessageDialog(null,"此客房已住人,请重新输入");
						bool=false;
					}
				}
			}
			else
			{
				JOptionPane.showMessageDialog(null,"客房号不能为空");
				bool=false;
			}
			if(bool)																			//验证旅客姓名
			{
				if(NAME.length()==0)
				{
					JOptionPane.showMessageDialog(null,"旅客姓名不能为空");
					bool=false;
				}
				else
				bool=true;
			}
			
			if(bool)																		//验证身份证
			{
				int i=0;
				while(i<SHENFENZHENG.length() && String.valueOf(SHENFENZHENG.charAt(i))!=null)
				{
					if(SHENFENZHENG.charAt(i)>='0' && SHENFENZHENG.charAt(i)<='9')
					{
						bool=true;
					}
					else
					{
						if(i==17 && ((SHENFENZHENG.charAt(i)>='0' && SHENFENZHENG.charAt(i)<='9') || (SHENFENZHENG.charAt(i)=='x' || SHENFENZHENG.charAt(i)=='X')))
						{
							bool=true;
							break;
						}
						bool=false;
						break;
					}
					i=i+1;
				}
				if(!bool)
				{
					JOptionPane.showMessageDialog(null,"数据输入错误(身份证号只能为数字)");
					bool=false;
				}
				if(bool)
				{
					if(SHENFENZHENG.length()!=18)
					{
						JOptionPane.showMessageDialog(null,"数据输入错误(身份证号码应为18位)");
						bool=false;
					}
					else
						bool=true;
				}
			}
			
			if(bool)															//验证预付款
			{
				if(YUFUKUAN.length()==0)
				{
					JOptionPane.showMessageDialog(null,"请输入客房预付款");
					bool=false;
				}
				if(bool)
				{
					try
					{
						YUFUKUANINT=Integer.parseInt(YUFUKUAN);
						if(YUFUKUANINT<0)
						{
							JOptionPane.showMessageDialog(null,"预付款不能小于零");
						}
					}
					catch(NumberFormatException e)
					{
						JOptionPane.showMessageDialog(null,"预付款格式不正确，应该为数字");
					}
				}
			}
			if(bool)
			{
				try
				{
					stmt.executeUpdate("insert into dengji(name,shenfenzheng,fangjianhao,timer,xingbie,yufukuan,beizhu) values ('" + NAME + "','" + SHENFENZHENG + "','" + TELL+"','"+ TIMER +"','"+XINGBIE+"',"+YUFUKUANINT+",'"+BEIZHU+"')");
					stmt.executeUpdate("update kefangxinxi set kong='"+"n'"+"where tell like '"+TELL+"'");
					rs=stmt.executeQuery("select * from dangqian");
					rs.next();
					JOptionPane.showMessageDialog(null,"房间已开通\n客房号:   "+TELL+"\n旅客姓名:   "+NAME+"\n旅客身份证号:   "+SHENFENZHENG+"\n旅客性别:   "+XINGBIE+"\n预付款:   "+YUFUKUAN+"\n备注:   "+BEIZHU);
					String Name=rs.getString("name");
					mainFrame main=new mainFrame(Name);			//打开主窗口开始
	  			main.setVisible(true);
    			main.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
				}
				catch(SQLException e){}
			}
		}
	}
	
	private class xingBie1Action implements ActionListener
	{
		public void actionPerformed(ActionEvent Event)
		{
			XINGBIE="男";
		}
	}
	private class xingBie2Action implements ActionListener
	{
		public void actionPerformed(ActionEvent Event)
		{
			XINGBIE="女";
		}
	}
	
	private JTextField Tell;
	private JTextField name;
	private JTextField shenFenZheng;
	private JTextField xingBie;
	private JTextField yuFuKuan;
	private JTextField beiZhu;
	private JButton queDing;
	private JButton fanHui;
	private JRadioButton xingbie1;
	private JRadioButton xingbie2;
	private ButtonGroup xingBieAll;
	
	private String canShu;
	private String TELL;
	private String TELLALL;
	private String TELLKONG;
	private String NAME;
	private String SHENFENZHENG;
	private String XINGBIE;
	private String YUFUKUAN;
	private int YUFUKUANINT;
	private String BEIZHU;
	private long TIMER;
	
	private Image img;
	
	private Connection conn;
	private Statement stmt;
	private ResultSet rs;
}