jingqueok2.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.*;
import java.util.*;

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);
		SQLSTR=sql;
		readImage();
		Add();
		fanHui=new JButton("返回");
		jiXu=new JButton("继续查询");
		add(fanHui);
		add(jiXu);
		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 Add()
	{
		int i=0;
		int x=20;
		int y=110;
		int j=0;
		int kk=0;
		int ii=0;
		try
		{
			while(rs.next())
			{
				tell=rs.getString("tell");
				biaozhun=rs.getString("biaozhun");
				kong=rs.getString("kong");
				AYLT.add(new JieGuo(tell,biaozhun,kong,x+j*70,y=i*80));
				j=j+1;
				if(j==7)
				{
					i=i+1;
					j=0;
				}
				ii++;
			}
		}
		catch(SQLException e){}
	}

	public void paintComponent(Graphics g)
	{
		int i=0;
		int x=20;
		int y=110;
		int j=0;
		int kk=0;
		int ii=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
		{
			while(rs.next())
			{
				tell=rs.getString("tell");
				biaozhun=rs.getString("biaozhun");
				kong=rs.getString("kong");
				if("y".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);
				}
					j=j+1;
				if(j==7)
					{
						i=i+1;
						j=0;
					}
			}
		}
		catch(SQLException e){}*/
		/*try
		{
			while(rs.next())
			{
				tell=rs.getString("tell");
				biaozhun=rs.getString("biaozhun");
				kong=rs.getString("kong");
				JieGuo[ii]=new JieGuo(tell,biaozhun,kong,x+j*70,y=i*80);
				j=j+1;
				if(j==7)
				{
					i=i+1;
					j=0;
				}
				ii++;
			}
		}
		catch(SQLException e){}*/
		
		while(AYLT.get(kk).getTell==null)
		{
			if("y".equals(AYLT.get(kk).getKong))
			{
				g2.drawImage(youRen,AYLT.get(kk).getX(),AYLT.get(kk).getY(),null);
			}
			else
			{
				g2.drawImage(wuRen,AYLT.get(kk).getX(),AYLT.get(kk).getY(),null);
			}
		}
	}
	
	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)
		{
			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 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 JieGuo[] JieGuo=new JieGuo[100];
	private ArrayList AYLT=new ArrayList(100);
	
}

class JieGuo
{
	public JieGuo(String T,String BZ,String k,int x,int y)
	{
		tell=T;
		biaoZhun=BZ;
		kong=k;
		X=x;
		Y=y;
	}
	
	public String getTell()
	{
		return tell;
	}
	
	public String getBiaoZhun()
	{
		return biaoZhun;
	}
	
	public String getKong()
	{
		return kong;
	}
	
	public int getX()
	{
		return X;
	}
	
	public int getY()
	{
		return Y;
	}
	private String tell;
	private String biaoZhun;
	private String kong;
	private int X;
	private int Y;
}