jingqueok.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 jingQueOk extends JFrame
{
	public jingQueOk(String sql)
	{
		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);  //不允许用户改变窗口大小
		jingQueOkPane jingQueOKP=new jingQueOkPane(sql);
		add(jingQueOKP);
		jingQueOKP.setBounds(0,0,500,438);
	}
	private final int DEFA_W=500;		//设置框架的宽度
	private final int DEFA_H=438;
}

class jingQueOkPane extends JPanel
{
	public jingQueOkPane(String sql)
	{
		setLayout(null);
    //AnNiuBianXing ANBX=new AnNiuBianXing();
    //addMouseMotionListener(ANBX);
		SQLSTR=sql;
		readImage();
		fanHui=new JButton("返回");
		jiXu=new JButton("继续查询");
		add(fanHui);
		add(jiXu);
		AnNiuBianXing ANBX=new AnNiuBianXing();
    addMouseMotionListener(ANBX);
    dianJi DJ=new dianJi();
    addMouseListener(DJ);
		fanHui.setBounds(420,355,60,30);
		jiXu.setBounds(320,355,90,30);
		fanHuiAction FHA=new fanHuiAction();
		jiXuAction JXA=new jiXuAction();
		fanHui.addActionListener(FHA);
		jiXu.addActionListener(JXA);

	}


	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(beiJingKong,0,0,null);
		g2.drawString("注意：    图标",30,360);
		g2.drawImage(youRenX,110,345,null);
		g2.drawString("表示该客房已住进客人",145,360);
		g2.drawImage(wuRenX,110,375,null);
		g2.drawString("表示该客房没有住进客人",145,390);
		try
		{	int xx=0;
			while(rs.next())
			{
				tell=rs.getString("tell").trim();
				biaozhun=rs.getString("biaozhun");
				kong=rs.getString("kong");
				if("n".equals(kong))
					{
						g2.drawImage(youRen,x+j*70,y+i*80,null);
						g2.drawString(biaozhun,x+j*70,y+i*80-5);
						g2.drawString(tell,x+j*70+12,y+i*80+60);
					}
				else
				{
					g2.drawImage(wuRen,x+j*70,y+i*80,null);
					g2.drawString(biaozhun,x+j*70,y+i*80-5);
					g2.drawString(tell,x+j*70+12,y+i*80+60);
				}
				xinXi[xx][0]=Integer.parseInt(tell);
				xinXi[xx][1]=x+j*70;
				xinXi[xx][2]=y+i*80;
				xx++;
				j=j+1;
				if(j==7)
					{
						i=i+1;
						j=0;
					}
			}
		}
		catch(SQLException e){}
	}

	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
		{
			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
			{
				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 fanHuiAction implements ActionListener
	{
		public void actionPerformed(ActionEvent Event)
		{
			try
			{
				rs=stmt.executeQuery("select * from dangqian");
				rs.next();
				Name=rs.getString("name");
			}
			catch(SQLException e){}
			mainFrame main=new mainFrame(Name);			//打开主窗口开始
	  	main.setVisible(true);
    	main.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
		}
		private String Name;
	}


	private class jiXuAction implements ActionListener
	{
		public void actionPerformed(ActionEvent Event)
		{
			jingQue JQ=new jingQue();
			JQ.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
			JQ.setVisible(true);
		}
	}

        private class AnNiuBianXing implements MouseMotionListener
        {
          public void mouseMoved(MouseEvent Event)
          {
            for(int xx=0;xinXi[xx][0]!=0;xx++)
            {
               if( (Event.getX()>=xinXi[xx][1] && Event.getX()<=xinXi[xx][1]+48) && (Event.getY()>=xinXi[xx][2] && Event.getY()<=xinXi[xx][2]+48) )
               {
                 setCursor(Cursor.getPredefinedCursor(Cursor.HAND_CURSOR));
                 break;
               }
             else
             {
                setCursor(Cursor.getPredefinedCursor(Cursor.DEFAULT_CURSOR));
             }



            }
          }

          public void mouseDragged(MouseEvent Event)
          {
          }
        }
        
        private class dianJi extends MouseAdapter
        {
        	public void mouseClicked(MouseEvent Event)
        	{
        		System.out.println(Event.getX()+"   "+Event.getY());
        		for(int xx=0;xinXi[xx][0]!=0;xx++)
            {
        			if( (Event.getX()>=xinXi[xx][1] && Event.getX()<=xinXi[xx][1]+48) && (Event.getY()>=xinXi[xx][2] && Event.getY()<=xinXi[xx][2]+48) )
            	{
            		kaiFang KF=new kaiFang(xinXi[xx][0]+"");
            		KF.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
            		KF.setVisible(true);
              	break;
            	}
            }
        	}
        }



	private Connection conn=null;
	private Statement stmt=null;
	private ResultSet rs=null;


	private String tell;
	private String biaozhun;
	private String louCeng;
	private String kong;


	private Image beiJingKong;
	private Image youRen;
	private Image wuRen;
	private Image youRenX;
	private Image wuRenX;


	private JButton fanHui;
	private JButton jiXu;

	private String SQLSTR;

	private int[][] xinXi=new int[100][3];
}