kongfangchaxun.java

来自「java开发的酒店管理系统」· Java 代码 · 共 269 行

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.*;

/*
public class kongFangChaXun
{
	public static void main(String args[])
	{
		kongFangFrame kongFangF=new kongFangFrame();
		kongFangF.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		kongFangF.setVisible(true);
	}
}

*/
class kongFangChaXun extends JFrame
{
	public kongFangChaXun()
	{
		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);  //不允许用户改变窗口大小
		kongFangPane kongFangP=new kongFangPane();
		add(kongFangP);
		kongFangP.setBounds(0,0,800,709);
		kongFangP.anNiu();
	}
	
	private final int DEFA_W=800;		//设置框架的宽度
	private final int DEFA_H=700;
}

class kongFangPane extends JPanel
{
	public kongFangPane()
	{
		setLayout(null);
		AnNiuBianXing ANBX=new AnNiuBianXing();
    addMouseMotionListener(ANBX);
    dianJi DJ=new dianJi();
    addMouseListener(DJ);
		readImage();
	}
	
	public void readImage()
	{
		try
		{
			beiJing=ImageIO.read(new File("kongfang.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\\kongfang.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)
			{}
		}
	}
	
	
	public void paintComponent(Graphics g)
	{
		super.paintComponent(g);
		Graphics2D g2=(Graphics2D)g;
		int i=0;
		int x=20;
		int y=110;
		int j=0;
		try
		{
			connDBQ();
		}
		catch(SQLException eee){}
		g2.drawImage(beiJing,0,0,null);
		g2.drawString("注意：    图标",30,615);
		g2.drawImage(youRenX,110,600,null);
		g2.drawString("表示该客房已住进客人",145,615);
		g2.drawImage(wuRenX,110,630,null);
		g2.drawString("表示该客房没有住进客人",145,650);
		try
		{
			int xx=0;
			while(rs.next())
			{
				tell=rs.getString("tell");
				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==11)
					{
						i=i+1;
						j=0;
					}
			}
		}
		catch(SQLException eee){}
		catch(NoClassDefFoundError eeee){eeee.printStackTrace();}
		
	}
	
	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;
            	}
            }
        	}
        }
	
	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();
		rs=stmt.executeQuery("select * from kefangxinxi");
	}
	
	
	public void anNiu()
	{
		jingQue=new JButton("精确查询");
		fanHui=new JButton("返    回");
		add(jingQue);
		add(fanHui);
		fanHuiAction fanHuiA=new fanHuiAction();
		jingQueAction jingQueA=new jingQueAction();
		fanHui.addActionListener(fanHuiA);
		jingQue.addActionListener(jingQueA);
		jingQue.setBounds(550,610,90,40);
		fanHui.setBounds(670,610,90,40);
	}
	
	
	private class fanHuiAction implements ActionListener
	{
		public void actionPerformed(ActionEvent Event)
		{
			try
			{
				connDBQ();
				rs=stmt.executeQuery("select * from dangqian");
				rs.next();
				name=rs.getString("name");
				System.out.println(name);
				rs.beforeFirst();
			}
			catch(SQLException e){}
			mainFrame main=new mainFrame(name);			//打开主窗口开始
	  	main.setVisible(true);
    	main.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
		}
	}
	
	
	private class jingQueAction implements ActionListener
	{
		public void actionPerformed(ActionEvent Event)
		{
			jingQue JQ=new jingQue();
			JQ.setVisible(true);
    	JQ.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
		}
	}
	
	private Connection conn=null;
	private Statement stmt=null;
	private ResultSet rs=null;
	
	
	private String tell;
	private String biaozhun;
	private String kong;
	private String name;
	
	
	private Image beiJing;
	private Image youRen;
	private Image wuRen;
	private Image youRenX;
	private Image wuRenX;
	
	
	private JButton fanHui;
	private JButton jingQue;
	
	private int[][] xinXi=new int[100][3];
}