dengjiok.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 dengJiOk extends JFrame
{
  public dengJiOk(String type,String zhi)
  {
    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);  //不允许用户改变窗口大小
    dengJiOkPane DJOKP=new dengJiOkPane(type,zhi);
    add(DJOKP);
  }

  public dengJiOk(String type,String zhi1,String zhi2)
  {
    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);  //不允许用户改变窗口大小
    dengJiOkPane DJOKP=new dengJiOkPane(type,zhi1,zhi2);
    add(DJOKP);
  }

  private final int DEFA_W=570;		//设置框架的宽度
  private final int DEFA_H=430;
}


class dengJiOkPane extends JPanel
{
  public dengJiOkPane(String type,String zhi)
  {
  	setLayout(null);
    getImage();
    addAnNiu();
    System.out.println(type+"    "+zhi);
    try
    {
      connDBQ();
      rsONE=stmtONE.executeQuery("select * from dengji where " + type + " like '" + zhi + "'");
    }
    catch(SQLException e){}
  }


  public dengJiOkPane(String type,String zhi1,String zhi2)
  {
  	setLayout(null);
  	getImage();
  	addAnNiu();
    try
    {
      connDBQ();
    }
    catch(SQLException e){e.printStackTrace();}
    catch(NullPointerException ee){}
    try
    {
      rsONE=stmtONE.executeQuery("select * from dengji where " + type + ">" + zhi1 +" and " + type + "<" + zhi2);
    }
    catch(SQLException e){System.out.println(2);}
    catch(NullPointerException ee){}
  }

	/*
	public void getData()
	{
		try
    {
      while(rs.next())
      {
        name=rs.getString("name");
        shenFenZheng=rs.getString("shenFenZheng");
        shenFenZheng=shenFenZheng.substring(0,14);
        fangJianHao=rs.getString("fangjianhao");
        timer=rs.getString("timer");
				count=count+1;
      }
      rs.beforeFirst();
    }
    catch(SQLException e){}
    catch(NullPointerException ee){}
	}*/
  public void getImage()
  {
    try
    {
      img=ImageIO.read(new File("chaxun.jpg"));
    }
    catch(IOException e)
    {
      try
      {
        img=ImageIO.read(new File("img\\chaxun.jpg"));
      }
      catch(IOException ee){}
    }
  }
  
  
  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);
    stmtONE=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
  }


  public void paintComponent(Graphics g)
  {
    super.paintComponent(g);
    Graphics2D g2=(Graphics2D)g;
    g2.drawImage(img,0,0,null);
    Font biaoTi=new Font("dialog",Font.BOLD,20);
    Font xiao=new Font("Dialog",Font.PLAIN,15);
    g2.setFont(xiao);
    try
    {
      while(rsONE.next())
      {
        String name=rsONE.getString("name");
        String shenFenZheng=rsONE.getString("shenFenZheng");
        shenFenZheng=shenFenZheng.substring(0,14);
        String fangJianHao=rsONE.getString("fangjianhao");
        String timer=rsONE.getString("timer");
        g2.drawString("姓名:"+name,15,160+count*30);
        g2.drawString("身份证号:"+shenFenZheng+"****",105,160+count*30);
        g2.drawString("房间号码:"+fangJianHao,320,160+count*30);
        g2.drawString("开房时间:"+timer,420,160+count*30);
        g2.drawString("*****************************************************************************************",10,180+count*30);
        count=count+1;
      }
      rsONE.beforeFirst();
      //rs=null;
      //stmtONE=null;
    }
    catch(SQLException e){}
    catch(NullPointerException ee){}
    g2.setFont(biaoTi);
    g2.drawString("系统一下为您找到"+count+"条符合条件的记录",100,140);
    count=0;
  }
  
  public void addAnNiu()
  {
  	mainF=new JButton("返回主界面");
  	jiXu=new JButton("继续查询");
  	mainF.setBounds(320,350,100,30);
  	jiXu.setBounds(430,350,100,30);
  	add(mainF);
  	add(jiXu);
  	mainFrameAction MFA=new mainFrameAction();
  	mainF.addActionListener(MFA);
  	jiXuAction JXA=new jiXuAction();
  	jiXu.addActionListener(JXA);
  	
  }
  
  private class mainFrameAction implements ActionListener
  {
  	public void actionPerformed(ActionEvent Event)
  	{
  		String NAME=null;
  		try
  		{
  			dangQian=stmtONE.executeQuery("select * from dangqian");
  			dangQian.next();
  			NAME=dangQian.getString("name");
  		}
  		catch(SQLException ee){}
  		mainFrame main=new mainFrame(NAME);			//打开主窗口开始
	  	main.setVisible(true);
    	main.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
  	}
  }
  
  
  private class jiXuAction implements ActionListener
  {
  	public void actionPerformed(ActionEvent Event)
  	{
  		dengJi dengJiF=new dengJi();
			dengJiF.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
			dengJiF.setVisible(true);
  	}
  }

  private Connection conn=null;
  private Statement stmtONE=null;
  private ResultSet rsONE=null;
  private ResultSet dangQian=null;
  
  private int count=0;
  
  private JButton mainF;
  private JButton jiXu;

  private Image img;

}