jingque.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 javax.swing.border.*;

class jingQue extends JFrame
{
	public jingQue()
	{
		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);  //设置窗口位置,位于屏幕中间
		setTitle("空房查询--精确查询");
		setSize(DEFA_W,DEFA_H);
		setResizable(false);  //不允许用户改变窗口大小
		jingQuePane jingQueP=new jingQuePane();
		add(jingQueP);
		jingQueP.setBounds(0,0,500,438);
	}
	private final int DEFA_W=500;		//设置框架的宽度
	private final int DEFA_H=438;
}


class jingQuePane extends JPanel
{
	public jingQuePane()
	{
		setLayout(null);
		readImage();
		xiangMu();
	}
	
	
	public void paintComponent(Graphics g)
	{
		int i=0;
		int x=20;
		int y=110;
		int j=0;
		super.paintComponent(g);
		Graphics2D g2=(Graphics2D)g;			
		try
		{
			connDBQ(SQLSTR);
		}
		catch(SQLException eee){}
		g2.drawImage(beiJing,0,0,null);
			try
			{
				biaoZhunrs=stmt.executeQuery("select distinct biaozhun from kefangxinxi");
			}
			catch(SQLException eee){}
			try
			{
				while(biaoZhunrs.next()&&addItembool)
				{
					biaozhun=biaoZhunrs.getString("biaozhun");
					biaoZhunBox.addItem(biaozhun);
				}
				addItembool=false;
			}
			catch(SQLException e){}	
			
			
			try
			{
				louCengrs=stmt.executeQuery("select distinct louceng from kefangxinxi");
			}
			catch(SQLException eee){}
			try
			{
				while(louCengrs.next()&&addItembool2)
				{
					louCeng=louCengrs.getString("louceng");
					louCengBox.addItem(louCeng);
				}
				addItembool2=false;
			}
			catch(SQLException e){}	
	}
	
	
	public void xiangMu()
	{
		biaoZhunBox=new JComboBox();
		louCengBox=new JComboBox();
		haoMa=new JTextField();
		BZBChaXun=new JButton("查询");
		LCChaXun=new JButton("查询");
		HMChaXun=new JButton("查询");
		biaoZhunAction BZA=new biaoZhunAction();
		haoMaAction HMA=new haoMaAction();
		louCengAction LCA=new louCengAction();
		BZBChaXun.addActionListener(BZA);
		LCChaXun.addActionListener(LCA);
		HMChaXun.addActionListener(HMA);
		biaoZhunBox.setBounds(200,122,150,30);
		louCengBox.setBounds(200,200,150,30);
		haoMa.setBounds(200,280,150,30);
		BZBChaXun.setBounds(400,117,80,40);
		LCChaXun.setBounds(400,195,80,40);
		HMChaXun.setBounds(400,275,80,40);
		add(BZBChaXun);
		add(LCChaXun);
		add(HMChaXun);
		add(louCengBox);
		add(haoMa);
		add(biaoZhunBox);

	}
	
	
	public void connDBQ(String sqlStr) 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();
		rs=stmt.executeQuery("select * from kefangxinxi"+sqlStr);
	}
	
	
	
	public void readImage()
	{
		try
		{
			beiJing=ImageIO.read(new File("kongfangjingque.jpg"));
			beiJingKong=ImageIO.read(new File("kongfangjingquekong.jpg"));
			youRen=ImageIO.read(new File("youren.jpg"));
			wuRen=ImageIO.read(new File("wuren.jpg"));
			youRenX=ImageIO.read(new File("yourenxiao.jpg"));
			wuRenX=ImageIO.read(new File("wurenxiao.jpg"));
		}
		catch(IOException e)
		{
			try
			{
				beiJing=ImageIO.read(new File("img\\kongfangjingque.jpg"));
				beiJingKong=ImageIO.read(new File("img\\kongfangjingquekong.jpg"));
				youRen=ImageIO.read(new File("img\\youren.jpg"));
				wuRen=ImageIO.read(new File("img\\wuren.jpg"));
				youRenX=ImageIO.read(new File("img\\yourenxiao.jpg"));
				wuRenX=ImageIO.read(new File("img\\wurenxiao.jpg"));
			}
			catch(IOException ee){}
		}
	}
	
	private class biaoZhunAction implements ActionListener
	{
		public void actionPerformed(ActionEvent Event)
		{
			SQLSTR="where biaozhun like '"+(String)biaoZhunBox.getSelectedItem()+"'";
			//System.out.print(SQLSTR);
			jingQueOk JQOK=new jingQueOk(SQLSTR);
			JQOK.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
			JQOK.setVisible(true);
		}
	}
	
	
	
	private class louCengAction implements ActionListener
	{
		public void actionPerformed(ActionEvent Event)
		{
			SQLSTR="where louCeng like'"+(String)louCengBox.getSelectedItem()+"'";
			System.out.print(SQLSTR);
			jingQueOk JQOK=new jingQueOk(SQLSTR);
			JQOK.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
			JQOK.setVisible(true);
		}
	}
	
	
	
	private class haoMaAction implements ActionListener
	{
		public void actionPerformed(ActionEvent Event)
		{
			SQLSTR="where tell like'"+(String)haoMa.getText()+"'";
			System.out.print(SQLSTR);
			jingQueOk JQOK=new jingQueOk(SQLSTR);
			JQOK.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
			JQOK.setVisible(true);
		}
	}
	
	private Connection conn=null;
	private Statement stmt=null;
	private ResultSet rs=null;
	private ResultSet biaoZhunrs=null;
	private ResultSet louCengrs=null;
	
	
	private String tell;
	private String biaozhun;
	private String louCeng;
	private String kong;
	
	
	private Image beiJing;
	private Image beiJingKong;
	private Image youRen;
	private Image wuRen;
	private Image youRenX;
	private Image wuRenX;
	
	
	private JComboBox biaoZhunBox;
	private JComboBox louCengBox;
	private JTextField haoMa;
	
	
	private JButton BZBChaXun;
	private JButton LCChaXun;
	private JButton HMChaXun;
	
	private boolean addItembool=true;
	private boolean addItembool2=true;
	private String SQLSTR;
}