java实现酒店管理系统实例

/**====================================================**

  * 项目名  ：酒店管理系统

  * 模块名  ：数据库连接

  * 文件名  ：databaseconnct.java

  * 相关文件  ：

  * 实现功能  ：jdbc连接数据库

  * 函数说明  ：

  * [## public vector getid(){}]：

  * 功能：获取数据库中系统登录id

  *

  * [## public void setid() {}]:

  * 功能：设置数据库中系统登录id

  *

  * [## public vector getpassword(){}]:

  * 功能：获取数据库中系统登录密码

  *

  * [## public void setpassword(){}]:

  * 功能：设置数据库中系统登录密码

  *

  * [## public vector getroonnum(){}]：

  * 功能：获取数据库中房间号

  *

  * [## public void setroonnum() {}]:

  * 功能：设置数据库中房间号

  *

  * [## public vector getroomtype(){}]:

  * 功能：获取数据库中房间类型

  *

  * [## public void seroomtype(){}]:

  * 功能：设置数据库中房间类型

  *

  * [## public void sql(string sql){}]:

  * 功能：执行sql语句进行查询

  *

  **===================================================**/

package com测试数据mon;

import java.sql.*;

import java.util.vector;

import javax.swing.joptionpane;

import javax.xml.crypto.dsig.keyinfo.retrievalmethod;

public class databaseconnect {

  private string drivername= "com.microsoft.sqlserver.jdbc.sqlserverdriver" ;

  private string dburl= "jdbc:sqlserver://localhost:1433;databasename=hotel_mangerment_system" ;

  private string username= "sa" ;

  private string userpwd= "1451171" ;

  private connection ct= null ;

  private resultset rs= null ;

  private statement st;

  private vector id = new vector();

  private vector password = new vector();

  /**====================================================**

  *  获取数据库中系统登录id

  **===================================================**/

  public vector getid() {

  return id;

  }

  /**====================================================**

  *  设置数据库中系统登录id

  **===================================================**/

  public void setid(vector id) {

  this .id = id;

  }

  /**====================================================**

  *  获取数据库中系统登录密码

  **===================================================**/

  public vector getpassword() {

  return password;

  }

  /**====================================================**

  *  设置数据库中系统登录id

  **===================================================**/

  public void setpassword(vector password) {

  this .password = password;

  }

  /**====================================================**

  * [## public void sql(string sql) {}]

  * 参数 ：string sql

  * 返回值 ：无

  * 修饰符 ：public

  * 功能 ：创建sql查询，从数据库里查询登陆账号与密码

  **===================================================**/

  public void sql(string sql) throws exception

  {

  class .forname(drivername);

  ct=drivermanager.getconnection(dburl,username,userpwd);

  st=ct.createstatement();

  rs=st.executequery(sql);

  while (rs.next())

  {

  id.add(rs.getint( 1 ));

  password.add(rs.getint( 2 ));

  }

  if (rs!= null )

  rs.close();

  if (st!= null )

  st.close();

  if (ct!= null )

  ct.close();

  }

  /**====================================================**

  * [## public vector roomoperation(int room_num) {}] 查询房间信息

  * 参数 ：int room_num

  * 返回值 ：无

  * 修饰符 ：public

  * 功能 ：创建sql查询房间号与类型，类外可使用

  **===================================================**/

  public vector roomoperation( int room_num) throws exception

  {

  vector<object> data= new vector<object>();

  class .forname(drivername);

  ct=drivermanager.getconnection(dburl,username,userpwd);

  st=ct.createstatement();

  rs=st.executequery( "select * from room_table where roomnum=" +room_num);

  while (rs.next())

  {

  data.add(rs.getint( 1 ));

  data.add(rs.getstring( 2 ));

  data.add(rs.getint( 3 ));

  data.add(rs.getint( 4 ));

  }

  if (rs!= null )

  rs.close();

  if (st!= null )

  st.close();

  if (ct!= null )

  ct.close();

  return data;

  }

  /**====================================================**

  * [## public void roomoperation(string sql) {}] 查询房间使用状态

  * 参数 ：string sql

  * 返回值 ：房间个数

  * 修饰符 ：public

  * 功能 ：创建sql查询满足条件房间使用状态，类外可使用

  **===================================================**/

  public int getrow(string sql) throws exception

  {

  class .forname(drivername);

  ct=drivermanager.getconnection(dburl,username,userpwd);

  int rowcount= 0 ;

  st=ct.createstatement();

  rs=st.executequery(sql);

  while (rs.next())

  {

  rowcount++;

  }

  if (rs!= null )

  rs.close();

  if (st!= null )

  st.close();

  if (ct!= null )

  ct.close();

  return rowcount;

  }

  /**====================================================**

  * [## public void insertdata(){}] 插入记录

  * 参数 ：string table_name,string str

  * 返回值 ：无

  * 修饰符 ：public

  * 功能 ：向数据库中插入记录

  **===================================================

  * @throws exception **/

  public void insertdata(string table_name,string str) throws exception

  {

  class .forname(drivername);

  ct=drivermanager.getconnection(dburl,username,userpwd);

  ct.setautocommit( false );

  st=ct.createstatement();

  string sql= "insert into" + " " +table_name+ " " + "values" + "(" +str+ ")" ;

  st.executeupdate(sql);

  ct测试数据mit();

  if (st!= null )

  st.close();

  if (ct!= null )

  ct.close();

  }

  /**====================================================**

  * [## public void updatedata(string str){}] 更新记录

  * 参数 ：string sql

  * 返回值 ：无

  * 修饰符 ：public

  * 功能 ：向数据库中更新记录

  **===================================================*/

  public void updatedata(string sql) throws exception

  {

  class .forname(drivername);

  ct=drivermanager.getconnection(dburl,username,userpwd);

  ct.setautocommit( false );

  st=ct.createstatement();

  st.executeupdate(sql);

  ct测试数据mit();

  if (st!= null )

  st.close();

  if (ct!= null )

  ct.close();

  }

  /**====================================================**

  * [## public void getdatafromcostomer(){}] 从costomer_table中获取数据

  * 参数 ：int room_num

  * 返回值 ：vector<object> data

  * 修饰符 ：public

  * 功能 ：根据房间号从costomer_table中获取数据并返回

  **===================================================*/

  public vector getdatafromcostomer( int room_num) throws exception

  {

  vector<object> data= new vector<object>();

  class .forname(drivername);

  ct=drivermanager.getconnection(dburl,username,userpwd);

  ct.setautocommit( false );

  st=ct.createstatement();

  rs=st.executequery( "select * from costomer_table where roomnum=" +room_num+ "and isliving=1" );

  while (rs.next())

  {

  data.add(rs.getint( 1 ));

  data.add(rs.getstring( 2 ));

  data.add(rs.getstring( 3 ));

  data.add(rs.getstring( 4 ));

  data.add(rs.getstring( 5 ));

  data.add(rs.getstring( 6 ));

  data.add(rs.getint( 7 ));

  data.add(rs.getint( 8 ));

  data.add(rs.getint( 9 ));

  }

  if (rs!= null )

  rs.close();

  if (st!= null )

  st.close();

  if (ct!= null )

  ct.close();

  return data;

  }

  /**====================================================**

  * [## public vector roomoperation(int room_num) {}] 查询房间信息

  * 参数 ：无

  * 返回值 ：return returedata;

  * 修饰符 ：public

  * 功能 ：创建sql查询房间号与类型,与入住状态并返回，类外可使用

  **===================================================**/

  public vector roomoperation() throws exception

  {

  vector<vector> returedata= new vector<vector>();

  vector<object> roomnum= new vector<object>();

  vector<object> roomtype= new vector<object>();

  vector<integer> roomstate= new vector<integer>();

  class .forname(drivername);

  ct=drivermanager.getconnection(dburl,username,userpwd);

  st=ct.createstatement();

  rs=st.executequery( "select roomnum,roomtype,roomatate from room_table" );

  while (rs.next())

  {

  roomnum.add(rs.getint( 1 ));

  roomtype.add(rs.getstring( 2 ));

  roomstate.add(rs.getint( 3 ));

  }

  if (rs!= null )

  rs.close();

  if (st!= null )

  st.close();

  if (ct!= null )

  ct.close();

  returedata.add(roomnum);

  returedata.add(roomtype);

  returedata.add(roomstate);

  return returedata;

  }

}

/**====================================================**

  * 项目名  ：酒店管理系统

  * 模块名  ：系统登录窗口

  * 文件名  ：hotellogingui.java

  * 相关文件  ：databaseconnct.java hotelmaingui.java

  * 实现功能  ：系统登录界面

  * 函数说明  ：

  * [## public myjframe(){}]：

  * 功能：构造函数 组建登录窗口

  * [## public void enevtoperation(final myloginjframe mj){}]

  * 功能：登录界面的事件监听处理

  * [## private boolean logincheck() {}]:

  * 功能：登录验证，仅类内使用

  * [## private void quit() {}]:

  * 功能：关闭系统函数，仅类内使用

  **===================================================**/

package com.hotelgui;

import com测试数据mon.*; //引入包

import java.awt.*;

import java.awt.event.actionevent;

import java.awt.event.actionlistener;

import java.awt.event.itemevent;

import java.awt.event.itemlistener;

import javax.jws.soap.soapbinding.style;

import javax.swing.*;

import java.net.*;

import java.util.*;

public class hotellogingui {

  public static void main(string[] args) {

  // todo auto-generated method stub

  myloginjframe logingui= new myloginjframe();

  logingui.enevtoperation(logingui);

}

}

//登录界面myjframe

class myloginjframe extends jframe implements actionlistener

{

  databaseconnect dc;

  jpasswordfield passwordnum;

  jtextfield accountnum;

  jlabel password,account,login,backimg,backimg1;

  jlabel tiplabel;

  jcombobox<string> loginchoice;

  jbutton loginbutton,resetbutton,exitbutton;

  jpanel jp,jp0,jp1,jp2,jp3,jp4,jp5;

  vector<string> dept= new vector<string>();

  private string id_now,user_type;

  /**=======================================================**

  *  设置当前成功登录的id

  **========================================================*/

  public void setid_now(string id_now) {

  this .id_now = id_now;

  }

  /**=======================================================**

  *  获得当前成功登录的id

  **========================================================*/

  public string getid_now() {

  return id_now;

  }

  /**====================================================**

  * **[## public myjframe() {}] 组建登录窗口

  * 参数 ：无

  * 返回值 ：无

  * 修饰符 ：public

  * 功能 ：组建登录窗口

  **===================================================**/

  public myloginjframe()

  { dc= new databaseconnect(); //连接数据库实例

  jp= new jpanel();

  jp.setbounds( 0 , - 5 , 550 , 200 );

  jp0= new jpanel();

  jp0.setbounds( 0 , 180 , 250 , 250 );

  jp1= new jpanel();

  jp1.setbounds( 270 , 215 , 250 , 30 );

  jp2= new jpanel();

  jp2.setbounds( 270 , 250 , 250 , 30 );

  jp3= new jpanel();

  jp3.setbounds( 270 , 280 , 250 , 30 );

  jp4= new jpanel();

  jp4.setbounds( 270 , 335 , 250 , 40 );

  jp5= new jpanel();

  jp5.setbounds( 270 , 380 , 250 , 30 );

  dept.add( "经理" );

  dept.add( "部门主管" );

  dept.add( "普通员工" );

  account= new jlabel( "账 户" );

  password= new jlabel( "密 码" );

  login= new jlabel( "用 户   " );

  backimg= new jlabel( new imageicon( "images\back.jpg" ));

  backimg1= new jlabel( new imageicon( "images\back1.jpg" ));

  tiplabel= new jlabel();

  tiplabel.setfont( new font( "宋体" , font.plain, 12 ));

  tiplabel.setforeground(color.red);

  tiplabel.setvisible( false );

  passwordnum= new jpasswordfield( 12 );

  accountnum= new jtextfield( 12 );

  loginbutton= new jbutton( "登 录" );

  loginbutton.setopaque( false );

  loginbutton.setcontentareafilled( false );

  resetbutton= new jbutton( "重 置" );

  resetbutton.setopaque( false );

  resetbutton.setcontentareafilled( false );

  exitbutton = new jbutton( "退 出" );

  exitbutton.setopaque( false );

  exitbutton.setcontentareafilled( false );

  loginchoice = new jcombobox(dept);

  jp.add(backimg);

  jp0.add(backimg1);

  jp1.add(account);

  jp1.add(accountnum);

  jp2.add(password);

  jp2.add(passwordnum);

  jp3.add(login);

  jp3.add(loginchoice);

  jp4.add(loginbutton);

  jp4.add(resetbutton);

  jp4.add(exitbutton);

  jp5.add(tiplabel);

  this .add(jp);

  this .add(jp0);

  this .add(jp1);

  this .add(jp2);

  this .add(jp3);

  this .add(jp4);

  this .add(jp5);

  this .settitle( "系统登录" );

  this .setlayout( null );

  this .setdefaultcloseoperation(jframe.exit_on_close);

  this .setresizable( false );

  this .setbounds( 320 , 160 , 550 , 450 );

  this .seticonimage( new imageicon( "images\icon.jpg" ).getimage());

  this .setvisible( true );

  }

  /**====================================================**

  * **[## private void enevtoperation() {}] 事件处理

  * 参数 ：无

  * 返回值 ：无

  * 修饰符 ：public

  * 功能 ：登录窗口的事件操作

  **===================================================**/

  public void enevtoperation( final myloginjframe mj)

  {

  /**=======================================================**

  *  登录按钮监听事件

  **========================================================*/

  loginbutton.addactionlistener( new actionlistener() {

  @override

  public void actionperformed(actionevent e) {

  // todo auto-generated method stub

  if (logincheck())

  {

  tiplabel.settext( "正 在 登 录..." );

  //记录当前的操作记录

  id_now=accountnum.gettext();

  user_type=loginchoice.getselecteditem().tostring();

  myhotelmaingui mm= new myhotelmaingui(); //登录到主界面

  mj.dispose();

  //显示当前的操作人员信息

  mm.setid_now(id_now);

  mm.setuser_type(user_type);

  mm.enevtopration();

  mm.updateroomstate();

  thread th= new thread(mm);

  th.start();

  }

  else if (accountnum.gettext().isempty() && passwordnum.getpassword().length== 0 )

  tiplabel.settext( "密码与账号不能为空!" );

  else if (accountnum.gettext().isempty() && passwordnum.getpassword().length!= 0 )

  tiplabel.settext( "请输入账号..." );

  else if (accountnum.gettext().isempty()== false && passwordnum.getpassword().length== 0 )

  tiplabel.settext( "请输入密码..." );

  else

  tiplabel.settext( "请检查后重新输入!" );

  tiplabel.setvisible( true );

  }

  });

  /**=======================================================**

  *  重置按钮监听事件

  **========================================================*/

  resetbutton.addactionlistener( new actionlistener() {

  @override

  public void actionperformed(actionevent e) {

  // todo auto-generated method stub

  accountnum.settext( "" );

  passwordnum.settext( "" );

  loginchoice.setselectedindex( 0 );

  }

  });

  /**=======================================================**

  *  退出按钮监听事件

  **========================================================*/

  exitbutton.addactionlistener( new actionlistener() {

  @override

  public void actionperformed(actionevent e) {

  // todo auto-generated method stub

  quit();

  }

  });

  }

  /**====================================================**

  * **[## private boolean logincheck() {}] 登陆验证

  * 参数 ：无

  * 返回值 ：flag

  * 修饰符 ：private

  * 功能 ：登录验证，仅类内使用

  **===================================================**/

  public boolean logincheck()

  {

  boolean flag= false ;

  if (loginchoice.getselectedindex()== 0 )

  {

  try {

  dc.sql( "select id,pass_word from mangerers_table" );

  } catch (exception e) {

  // todo auto-generated catch block

  e.printstacktrace();

  }

  }

  if (loginchoice.getselectedindex()== 1 )

  {

  try {

  dc.sql( "select id,pass_word from dept_table" );

  } catch (exception e) {

  // todo auto-generated catch block

  e.printstacktrace();

  }

  }

  if (loginchoice.getselectedindex()== 2 )

  {

  try {

  dc.sql( "select id,pass_word from common_table" );

  } catch (exception e) {

  // todo auto-generated catch block

  e.printstacktrace();

  }

  }

  for ( int i= 0 ;i<dc.getid().size();i++)

  {

  string password= new string(passwordnum.getpassword());

  if (accountnum.gettext().equals(dc.getid().get(i).tostring()) && password.equals(dc.getpassword().get(i).tostring()))

  {

  flag= true ;

  break ;

  }

  }

  return flag;

  }

  /**====================================================**

  * **[## private void quit() {}] 系统退出

  * 参数 ：无

  * 返回值 ：无

  * 修饰符 ：private

  * 功能 ：关闭系统函数，仅类内使用

  **===================================================**/

  private void quit()

  {

  int flag= 0 ;

  string msg= "你 确 定 要 关 闭 系 统 吗？" ;

  flag=joptionpane.showconfirmdialog( null , msg, "提示" ,joptionpane.yes_no_option);

  if (flag==joptionpane.yes_option)

  {

  this .setvisible( false );

  system.exit( 0 );

  }

  return ;

  }

  @override

  public void actionperformed(actionevent e) {

  // todo auto-generated method stub

  }

}

/**====================================================**

  * 项目名  ：酒店管理系统

  * 模块名  ：系统登录成功后的主窗口

  * 文件名  ：hotelmaingui.java

  * 相关文件  ：hotellogingui.java databaseconnect.java

  * 实现功能  ：系统登录成功后主界面

  * 函数说明  ：

  * [## public myhotelmaingui(int i){}]：

  * 功能：构造函数

  * [## public myhotelmaingui(){}]：

  * 功能：构造函数 组建登陆窗口

  * [## private boolean logincheck() {}]:

  * 功能：登录验证，仅类内使用

  * [## private void quit() {}]:

  * 功能：关闭系统函数，仅类内使用

  * [## public void run(){}]

  * 功能：线程执行刷新界面

  * [## public void setlabeltext(jlabel jl,int row)]

  * 功能：为jlabel设置text

  **===================================================**/

package com.hotelgui;

import java.awt.*;

import com测试数据mon.databaseconnect;

import com.databasejdbc.*;

import javax.swing.*;

import java.text.simpledateformat;

import java.util.*;

import java.awt.event.*;

public class myhotelmaingui extends jframe implements actionlistener,runnable

{

  public myhotelmaingui( int i)

  {

  }

  private static final focuslistener focuslistener = null ;

  string roomnum,roomtype;

  jpopupmenu popupmenu;

  jmenubar jmb;

  jpanel jp1,jp2,room_jp1;

  jlabel time_jl,order_jl,login_jl,change_jl,checkout_jl,relogin_jl,money_jl,exit_jl,emploer_jl;

  jmenu jm1,jm2,jm3,jm4,jm5,jm6,jm7,jm8,bt_jm;

  jbutton time_bt,order_bt,login_bt,change_bt,checkout_bt,relogin_bt,money_bt,exit_bt,emploer_bt,onef_bt,twof_bt,threef_bt,fourf_bt;

  vector<jbutton> roomjb= new vector<jbutton>();

  vector<jpopupmenu> popupvector= new vector<jpopupmenu>();

  jlabel statelabel,state,staticsstate;

  jbutton jj;

  jlabel allroom_jl,empty_jl,ordered_jl,isliv_jl,else_jl,allroom_jl1,empty_jl1,ordered_jl1,isliv_jl1,else_jl1;

  string id_now,user_type;

  /**=======================================================**

  *  获取当前成功登录的id

  **========================================================*/

  public string getid_now() {

  return id_now;

  }

  /**=======================================================**

  *  获取当前成功登录的用户类型

  **========================================================*/

  public string getuser_type() {

  return user_type;

  }

  /**=======================================================**

  *  设置当前成功登录的id

  **========================================================*/

  public void setid_now(string id_now) {

  this .id_now = id_now;

  }

  /**=======================================================**

  *  设置当前成功登录的用户类型

  **========================================================*/

  public void setuser_type(string user_type) {

  this .user_type = user_type;

  }

  /**====================================================**

  * **[## public myhotelmaingui() {}] 构造函数

  * 参数 ：无

  * 返回值 ：无

  * 修饰符 ：public

  * 功能 ：构造函数，初始化主界面

  **===================================================**/

  public myhotelmaingui()

  {

  //为每个房间设置点击事件

  for ( int i= 0 ;i< 32 ;i++)

  {

  final string str;

  if (i< 10 )

  {

   str= "40" +(i+ 1 );

  }

  else

  {

   str= "4" +(i+ 1 );

  }

  popupmenu = new jpopupmenu ();

  popupvector.add(popupmenu);

  jmenuitem ordermenuitem = new jmenuitem ( "新预定" ) ;

  ordermenuitem.setfont( new font( "宋体" ,font.italic, 14 ));

  popupvector.get(i).add ( ordermenuitem ) ;

  //添加事件

  ordermenuitem.addactionlistener( new actionlistener() {

  @override

  public void actionperformed(actionevent e) {

  // todo auto-generated method stub

  checkin ck= new checkin( "预订登记" , "images\checkin_bt.jpg" );

  ck.room_num_jf.settext(str);

  ck.cancelbutton();

  //登記入住

  ck.checkinbutton( 1 );

  updateroomstate();

  }

  });

  jmenuitem checkinmenuitem = new jmenuitem ( "入住登记" ) ;

  checkinmenuitem.setfont( new font( "宋体" ,font.italic, 14 ));

  popupvector.get(i).add ( checkinmenuitem ) ;

  checkinmenuitem.addactionlistener( new actionlistener() {

  @override

  public void actionperformed(actionevent e) {

  // todo auto-generated method stub

  checkin ck= new checkin( "入住登记" , "images\checkin_bt.jpg" );

  ck.room_num_jf.settext(str);

  ck.cancelbutton();

  //登記入住

  ck.checkinbutton( 2 );

  updateroomstate();

  }

  });

  // separator

  popupmenu.addseparator () ;

  jmenuitem changemenuitem = new jmenuitem ( "客人换房" ) ;

  changemenuitem.setfont( new font( "宋体" ,font.italic, 14 ));

  popupvector.get(i).add ( changemenuitem ) ;

  changemenuitem.addactionlistener( new actionlistener() {

  @override

  public void actionperformed(actionevent e) {

  // todo auto-generated method stub

  changeroom cr= new changeroom( "客人换房" , "images\change_bt.jpg" );

  cr.check_bt.setvisible( false );

  cr.jtf.settext(str);

  try {

  cr.check_bt( "房间未入住！" );

  } catch (exception e1) {

  // todo auto-generated catch block

  e1.printstacktrace();

  }

  }

  });

  jmenuitem msgmenuitem = new jmenuitem ( "客人信息" ) ;

  msgmenuitem.setfont( new font( "宋体" ,font.italic, 14 ));

  popupvector.get(i).add ( msgmenuitem ) ;

  msgmenuitem.addactionlistener( new actionlistener() {

  @override

  public void actionperformed(actionevent e) {

  // todo auto-generated method stub

  checkmsg cm= new checkmsg( "客人信息" , "images\" );

  cm.check_bt.setvisible( false );

  cm.jtf.settext(str);

  try {

  cm.check_bt( "房间未入住！" );

  } catch (exception e1) {

  // todo auto-generated catch block

  e1.printstacktrace();

  }

  }

  });

  jmenuitem reckmenuitem = new jmenuitem ( "客人续住" ) ;

  reckmenuitem.setfont( new font( "宋体" ,font.italic, 14 ));

  popupvector.get(i).add ( reckmenuitem ) ;

  popupmenu.addseparator () ;

  jmenuitem checkoutmenuitem = new jmenuitem ( "客人退房" ) ;

  checkoutmenuitem.setfont( new font( "宋体" ,font.italic, 14 ));

  popupvector.get(i).add ( checkoutmenuitem ) ;

  checkoutmenuitem.addactionlistener( new actionlistener() {

  @override

  public void actionperformed(actionevent e) {

  // todo auto-generated method stub

  checkout co= new checkout( "客人退房" , "images\checkout_bt.jpg" );

  co.check_bt.setvisible( false );

  co.jtf.settext(str);

  try {

  co.check_bt( "房间未入住！" );

  } catch (exception e1) {

  // todo auto-generated catch block

  e1.printstacktrace();

  }

  }

  });

  }

  onef_bt= new jbutton( new imageicon( "images\1f.jpg" ));

  onef_bt.setbounds( 20 , 170 , 60 , 50 );

  twof_bt= new jbutton( new imageicon( "images\2f.jpg" ));

  twof_bt.setbounds( 20 , 250 , 60 , 50 );

  threef_bt= new jbutton( new imageicon( "images\3f.jpg" ));

  threef_bt.setbounds( 20 , 330 , 60 , 50 );

  fourf_bt= new jbutton( new imageicon( "images\4f.jpg" ));

  fourf_bt.setbounds( 20 , 410 , 60 , 50 );

  for ( int i= 0 ;i< 32 ;i++)

  {

  jbutton jb= new jbutton();

  roomjb.add(jb);

  if (i< 8 )

  roomjb.get(i).setbounds( 90 *i, 0 , 90 , 90 );

  else if (i< 16 )

  roomjb.get(i).setbounds( 90 *(i- 8 ), 90 , 90 , 90 );

  else if (i< 24 )

  roomjb.get(i).setbounds( 90 *(i- 16 ), 180 , 90 , 90 );

  else

  roomjb.get(i).setbounds( 90 *(i- 24 ), 270 , 90 , 90 );

  roomjb.get(i).setcontentareafilled( false );

  roomjb.get(i).setcomponentpopupmenu (popupvector.get(i));

  }

  //放置房间的jpanel

  room_jp1= new jpanel();

  room_jp1.setlayout( null );

  room_jp1.setbounds( 120 , 150 , 730 , 367 );

  allroom_jl= new jlabel( new imageicon( "images\all.jpg" ));

  allroom_jl1= new jlabel();

  allroom_jl.setbounds( 950 , 150 , 75 , 30 );

  allroom_jl1.setbounds( 1110 , 150 , 75 , 30 );

  empty_jl= new jlabel( new imageicon( "images\empty.jpg" ));

  empty_jl1= new jlabel();

  empty_jl.setbounds( 950 , 200 , 75 , 30 );

  empty_jl1.setbounds( 1110 , 200 , 75 , 30 );

  ordered_jl= new jlabel( new imageicon( "images\order.jpg" ));

  ordered_jl1= new jlabel();

  ordered_jl.setbounds( 950 , 250 , 75 , 30 );

  ordered_jl1.setbounds( 1110 , 250 , 75 , 30 );

  isliv_jl= new jlabel( new imageicon( "images\isliv.jpg" ));

  isliv_jl1= new jlabel();

  isliv_jl.setbounds( 950 , 300 , 75 , 30 );

  isliv_jl1.setbounds( 1110 , 300 , 75 , 30 );

  else_jl= new jlabel( new imageicon( "images\else.jpg" ));

  else_jl1= new jlabel();

  else_jl1.setbounds( 1110 , 350 , 75 , 30 );

  else_jl.setbounds( 950 , 350 , 75 , 30 );

  state= new jlabel( "实时房态统计" );

  state.setfont( new font( "宋体" ,font.plain, 14 ));

  state.setbounds( 1000 , 90 , 100 , 40 );

  staticsstate= new jlabel();

  staticsstate.setfont( new font( "宋体" ,font.plain, 25 ));

  staticsstate.setbounds( 970 , 420 , 250 , 60 );

  staticsstate.setforeground(color.red);

  jp2= new jpanel();

  jp2.setbounds( 10 , 570 , 950 , 50 ); //底部登录状态显示

  statelabel= new jlabel();

  statelabel.setfont( new font( "宋体" ,font.center_baseline, 12 ));

  jp2.add(statelabel);

  time_jl= new jlabel( "实时房态" );

  time_jl.setfont( new font( "宋体" ,font.layout_no_limit_context, 10 ));

  time_jl.setbounds( 10 , 53 , 40 , 10 );

  time_bt= new jbutton( new imageicon( "images\实时房态.jpg" ));

  time_bt.setbounds( 10 , 10 , 40 , 40 );

  time_bt.setborderpainted( false );

  order_bt= new jbutton( new imageicon( "images\预定登记.jpg" ));

  order_bt.setbounds( 65 , 10 , 40 , 40 );

  order_bt.setborderpainted( false );

  order_jl= new jlabel( "预定登记" );

  order_jl.setfont( new font( "宋体" ,font.layout_no_limit_context, 10 ));

  order_jl.setbounds( 65 , 53 , 40 , 10 );

  login_bt= new jbutton( new imageicon( "images\入住登记.jpg" ));

  login_bt.setbounds( 120 , 10 , 40 , 40 );

  login_bt.setborderpainted( false );

  login_jl= new jlabel( "入住登记" );

  login_jl.setfont( new font( "宋体" ,font.layout_no_limit_context, 10 ));

  login_jl.setbounds( 120 , 53 , 40 , 10 );

  change_bt= new jbutton( new imageicon( "images\客人换房.jpg" ));

  change_bt.setbounds( 175 , 10 , 40 , 40 );

  change_bt.setborderpainted( false );

  change_jl= new jlabel( "客人换房" );

  change_jl.setfont( new font( "宋体" ,font.layout_no_limit_context, 10 ));

  change_jl.setbounds( 175 , 53 , 40 , 10 );

  relogin_bt= new jbutton( new imageicon( "images\客房续住.jpg" ));

  relogin_bt.setbounds( 230 , 10 , 40 , 40 );

  relogin_bt.setborderpainted( false );

  relogin_jl= new jlabel( "客人续住" );

  relogin_jl.setfont( new font( "宋体" ,font.layout_no_limit_context, 10 ));

  relogin_jl.setbounds( 230 , 53 , 40 , 10 );

  checkout_jl= new jlabel( "客人退房" );

  checkout_jl.setfont( new font( "宋体" ,font.layout_no_limit_context, 10 ));

  checkout_jl.setbounds( 285 , 53 , 40 , 10 );

  checkout_bt= new jbutton( new imageicon( "images\客人退房.jpg" ));

  checkout_bt.setbounds( 285 , 10 , 40 , 40 );

  checkout_bt.setborderpainted( false );

  money_bt= new jbutton( new imageicon( "images\收银报表.jpg" ));

  money_bt.setbounds( 340 , 10 , 40 , 40 );

  money_bt.setborderpainted( false );

  money_jl= new jlabel( "财务报表" );

  money_jl.setfont( new font( "宋体" ,font.layout_no_limit_context, 10 ));

  money_jl.setbounds( 340 , 53 , 40 , 10 );

  exit_bt= new jbutton( new imageicon( "images\退出系统.png" ));

  exit_bt.setbounds( 450 , 10 , 40 , 40 );

  exit_bt.setborderpainted( false );

  exit_jl= new jlabel( "退出系统" );

  exit_jl.setfont( new font( "宋体" ,font.layout_no_limit_context, 10 ));

  exit_jl.setbounds( 450 , 53 , 40 , 10 );

  emploer_bt= new jbutton( new imageicon( "images\员工管理.jpg" ));

  emploer_bt.setbounds( 395 , 10 , 40 , 40 );

  emploer_bt.setborderpainted( false );

  emploer_jl= new jlabel( "员工管理" );

  emploer_jl.setfont( new font( "宋体" ,font.layout_no_limit_context, 10 ));

  emploer_jl.setbounds( 395 , 53 , 40 , 10 );

  jm1= new jmenu( "预订接待(a)" );

  jm1.setfont( new font( "宋体" ,font.layout_no_limit_context, 12 ));

  jm2= new jmenu( "前台营业(b)" );

  jm2.setfont( new font( "宋体" ,font.layout_no_limit_context, 12 ));

  jm3= new jmenu( "客户管理(c)" );

  jm3.setfont( new font( "宋体" ,font.layout_no_limit_context, 12 ));

  jm4= new jmenu( "员工管理(d)" );

  jm4.setfont( new font( "宋体" ,font.layout_no_limit_context, 12 ));

  jm5= new jmenu( "财务报表(e)" );

  jm5.setfont( new font( "宋体" ,font.layout_no_limit_context, 12 ));

  jm6= new jmenu( "综合查询(z)" );

  jm6.setfont( new font( "宋体" ,font.layout_no_limit_context, 12 ));

  jm7= new jmenu( "窗口(p)" );

  jm7.setfont( new font( "宋体" ,font.layout_no_limit_context, 12 ));

  jm8= new jmenu( "帮助(h)" );

  jm8.setfont( new font( "宋体" ,font.layout_no_limit_context, 12 ));

  jmb= new jmenubar();

  jmb.add(jm1);

  jmb.add(jm2);

  jmb.add(jm3);

  jmb.add(jm4);

  jmb.add(jm5);

  jmb.add(jm6);

  jmb.add(jm7);

  jmb.add(jm8);

  for ( int i= 0 ;i< 32 ;i++)

  {

  room_jp1.add(roomjb.get(i));

  }

  this .add(onef_bt);

  this .add(twof_bt);

  this .add(threef_bt);

  this .add(fourf_bt);

  this .add(time_bt);

  this .add(order_bt);

  this .add(login_bt);

  this .add(change_bt);

  this .add(relogin_bt);

  this .add(change_bt);

  this .add(checkout_bt);

  this .add(money_bt);

  this .add(exit_bt);

  this .add(emploer_bt);

  this .add(time_jl);

  this .add(order_jl);

  this .add(login_jl);

  this .add(change_jl);

  this .add(relogin_jl);

  this .add(change_jl);

  this .add(checkout_jl);

  this .add(money_jl);

  this .add(exit_jl);

  this .add(emploer_jl);

  this .add(jp2);

  this .add(state);

  this .add(allroom_jl);

  this .add(empty_jl);

  this .add(isliv_jl);

  this .add(ordered_jl);

  this .add(else_jl);

  this .add(allroom_jl1);

  this .add(empty_jl1);

  this .add(isliv_jl1);

  this .add(ordered_jl1);

  this .add(else_jl1);

  this .add(staticsstate);

  this .setresizable( false );

  this .seticonimage( new imageicon( "images\icon.jpg" ).getimage());

  this .settitle( "i酒店管理系统" + "——" + "[" + "实时房态" + "]" );

  this .setfont( new font( "宋体" ,font.layout_no_limit_context, 12 ));

  this .setjmenubar(jmb);

  this .setlocation( 50 , 50 );

  this .setlayout( null );

  this .add(room_jp1);

  this .setsize(toolkit.getdefaulttoolkit().getscreensize().width- 100 ,toolkit.getdefaulttoolkit().getscreensize().height- 100 );

  this .setdefaultcloseoperation(jframe.exit_on_close);

  this .setvisible( true );

  }

  @override

  public void actionperformed(actionevent e) {

  // todo auto-generated method stub

  }

  /**====================================================**

  * **[## public void enevtopration {}] 主窗体上的事件监听

  * 参数 ：无

  * 返回值 ：无

  * 修饰符 ：public

  * 功能 ：监听用户在主窗体中的操作

  **===================================================**/

  public void enevtopration()

  {

  order_bt.addmouselistener( new mouselistener() {

  @override

  public void mouseclicked(mouseevent e) {

  // todo auto-generated method stub

  checkin ck= new checkin( "预订登记" , "images\checkin_bt.jpg" );

  ck.cancelbutton();

  //登記入住

  ck.checkinbutton( 1 );

  updateroomstate();

  }

  @override

  public void mousepressed(mouseevent e) {

  // todo auto-generated method stub

  }

  @override

  public void mousereleased(mouseevent e) {

  // todo auto-generated method stub

  }

  @override

  public void mouseentered(mouseevent e) {

  // todo auto-generated method stub

  order_bt.setborderpainted( true );

  }

  @override

  public void mouseexited(mouseevent e) {

  // todo auto-generated method stub

  order_bt.setborderpainted( false );

  }

  });

  login_bt.addmouselistener( new mouselistener() {

  @override

  public void mouseclicked(mouseevent e) {

  // todo auto-generated method stub

  checkin ck= new checkin( "入住登记" , "images\checkin_bt.jpg" );

  ck.cancelbutton();

  //登記入住

  ck.checkinbutton( 2 );

  updateroomstate();

  }

  @override

  public void mousepressed(mouseevent e) {

  // todo auto-generated method stub

  }

  @override

  public void mousereleased(mouseevent e) {

  // todo auto-generated method stub

  }

  @override

  public void mouseentered(mouseevent e) {

  // todo auto-generated method stub

  login_bt.setborderpainted( true );

  }

  @override

  public void mouseexited(mouseevent e) {

  // todo auto-generated method stub

  login_bt.setborderpainted( false );

  }

  });

  change_bt.addmouselistener( new mouselistener() {

  @override

  public void mouseclicked(mouseevent e) {

  // todo auto-generated method stub

  changeroom cr= new changeroom( "客人换房" , "images\change_bt.jpg" );

  updateroomstate();

  repaint();

  }

  @override

  public void mousepressed(mouseevent e) {

  // todo auto-generated method stub

  }

  @override

  public void mousereleased(mouseevent e) {

  // todo auto-generated method stub

  }

  @override

  public void mouseentered(mouseevent e) {

  // todo auto-generated method stub

  change_bt.setborderpainted( true );

  }

  @override

  public void mouseexited(mouseevent e) {

  // todo auto-generated method stub

  change_bt.setborderpainted( false );

  }

  });

  relogin_bt.addmouselistener( new mouselistener() {

  @override

  public void mouseclicked(mouseevent e) {

  // todo auto-generated method stub

  }

  @override

  public void mousepressed(mouseevent e) {

  // todo auto-generated method stub

  }

  @override

  public void mousereleased(mouseevent e) {

  // todo auto-generated method stub

  }

  @override

  public void mouseentered(mouseevent e) {

  // todo auto-generated method stub

  relogin_bt.setborderpainted( true );

  }

  @override

  public void mouseexited(mouseevent e) {

  // todo auto-generated method stub

  relogin_bt.setborderpainted( false );

  }

  });

  checkout_bt.addmouselistener( new mouselistener() {

  @override

  public void mouseclicked(mouseevent e) {

  // todo auto-generated method stub

  checkout co= new checkout( "客人退房" , "images\checkout_bt.jpg" );

  }

  @override

  public void mousepressed(mouseevent e) {

  // todo auto-generated method stub

  }

  @override

  public void mousereleased(mouseevent e) {

  // todo auto-generated method stub

  }

  @override

  public void mouseentered(mouseevent e) {

  // todo auto-generated method stub

  checkout_bt.setborderpainted( true );

  }

  @override

  public void mouseexited(mouseevent e) {

  // todo auto-generated method stub

  checkout_bt.setborderpainted( false );

  }

  });

  money_bt.addmouselistener( new mouselistener() {

  @override

  public void mouseclicked(mouseevent e) {

  // todo auto-generated method stub

  }

  @override

  public void mousepressed(mouseevent e) {

  // todo auto-generated method stub

  }

  @override

  public void mousereleased(mouseevent e) {

  // todo auto-generated method stub

  }

  @override

  public void mouseentered(mouseevent e) {

  // todo auto-generated method stub

  money_bt.setborderpainted( true );

  }

  @override

  public void mouseexited(mouseevent e) {

  // todo auto-generated method stub

  money_bt.setborderpainted( false );

  }

  });

  emploer_bt.addmouselistener( new mouselistener() {

  @override

  public void mouseclicked(mouseevent e) {

  // todo auto-generated method stub

  }

  @override

  public void mousepressed(mouseevent e) {

  // todo auto-generated method stub

  }

  @override

  public void mousereleased(mouseevent e) {

  // todo auto-generated method stub

  }

  @override

  public void mouseentered(mouseevent e) {

  // todo auto-generated method stub

  emploer_bt.setborderpainted( true );

  }

  @override

  public void mouseexited(mouseevent e) {

  // todo auto-generated method stub

  emploer_bt.setborderpainted( false );

  }

  });

  exit_bt.addmouselistener( new mouselistener() {

  @override

  public void mouseclicked(mouseevent e) {

  // todo auto-generated method stub

  quit();

  }

  @override

  public void mousepressed(mouseevent e) {

  // todo auto-generated method stub

  }

  @override

  public void mousereleased(mouseevent e) {

  // todo auto-generated method stub

  }

  @override

  public void mouseentered(mouseevent e) {

  // todo auto-generated method stub

  exit_bt.setborderpainted( true );

  }

  @override

  public void mouseexited(mouseevent e) {

  // todo auto-generated method stub

  exit_bt.setborderpainted( false );

  }

  });

  time_bt.addmouselistener( new mouselistener() {

  @override

  public void mouseclicked(mouseevent e) {

  // todo auto-generated method stub

  updateroomstate();

  }

  @override

  public void mousepressed(mouseevent e) {

  // todo auto-generated method stub

  }

  @override

  public void mousereleased(mouseevent e) {

  // todo auto-generated method stub

  }

  @override

  public void mouseentered(mouseevent e) {

  // todo auto-generated method stub

  time_bt.setborderpainted( true );

  }

  @override

  public void mouseexited(mouseevent e) {

  // todo auto-generated method stub

  time_bt.setborderpainted( false );

  }

  });

  }

  /**====================================================**

  * **[## public void run() {}] 线程执行，随着系统改变当前时间

  * 参数 ：无

  * 返回值 ：无

  * 修饰符 ：public

  * 功能 ：使用线程使当前界面时间随着系统改变当

  **===================================================**/

  public void run() {

  // todo auto-generated method stub

  simpledateformat df = new simpledateformat( "yyyy-mm-dd hh:mm:ss" );

  while ( true )

  {

  statelabel.settext( "当前时间为：" +df.format( new date())+ "  " + "当前登录的用户为：" +id_now+ "  " + "用户类型为：" +user_type);

  statelabel.repaint();

  this .repaint();

  }

  }

/**====================================================**

  * **[## private void quit() {}] 系统退出

  * 参数 ：无

  * 返回值 ：无

  * 修饰符 ：private

  * 功能 ：关闭系统函数，仅类内使用

  **===================================================**/

private void quit()

{

  int flag= 0 ;

  string msg= "你 确 定 要 关 闭 系 统 吗？" ;

  flag=joptionpane.showconfirmdialog( null , msg, "提示" ,joptionpane.yes_no_option);

  if (flag==joptionpane.yes_option)

  {

  this .setvisible( false );

  system.exit( 0 );

  }

  return ;

}

/**====================================================**

  * **[## public void setlabeltext(jlabel jl,int row) {}] 为jlabel设置text

  * 返回值 ：无

  * 修饰符 ：public

  * 功能 ：为jlabel设置text

  **===================================================**/

public void setlabeltext(jlabel jl, int row)

{

  try {

  jl.settext(integer.tostring(row)+ " " + "间" );

  } catch (exception e){}

  }

/**====================================================**

  * **[## public void updateroomstate{}] 更新入住状态

  * 返回值 ：无

  * 修饰符 ：public

  * 功能 ：更新入住统计情况

  **===================================================

  * @throws exception **/

public void updateroomstate()

{

  databaseconnect ns= new databaseconnect();

  vector<vector> returndata = null ;

  try {

  setlabeltext(allroom_jl1, ns.getrow( "select * from room_table" ));

  } catch (exception e) {

  // todo auto-generated catch block

  e.printstacktrace();

  }

  int tol= 1 ;

  try {

  tol = ns.getrow( "select * from room_table" );

  } catch (exception e) {

  // todo auto-generated catch block

  e.printstacktrace();

  }

  try {

  setlabeltext(empty_jl1, ns.getrow( "select * from room_table where roomatate=0" ));

  } catch (exception e) {

  // todo auto-generated catch block

  e.printstacktrace();

  }

  try {

  setlabeltext(ordered_jl1, ns.getrow( "select * from room_table where roomatate=1" ));

  } catch (exception e) {

  // todo auto-generated catch block

  e.printstacktrace();

  }

  try {

  setlabeltext(isliv_jl1, ns.getrow( "select * from room_table where roomatate=2" ));

  } catch (exception e) {

  // todo auto-generated catch block

  e.printstacktrace();

  }

  int isl= 1 ;

  try {

  isl = ns.getrow( "select * from room_table where roomatate=2" );

  } catch (exception e) {

  // todo auto-generated catch block

  e.printstacktrace();

  }

  try {

  setlabeltext(else_jl1, ns.getrow( "select * from room_table where roomatate=3" ));

  } catch (exception e) {

  // todo auto-generated catch block

  e.printstacktrace();

  }

  try {

  staticsstate.settext( "入 住 率 :" + " " +( int )(isl* 100 /tol)+ "%" );

  returndata=ns.roomoperation();

  } catch (exception e) {

  // todo auto-generated catch block

  e.printstacktrace();

  }

  for ( int i= 0 ;i<returndata.get( 0 ).size();i++)

  {

  try {

  roomjb.get(i).settext( "<html>" +returndata.get( 0 ).get(i)+ "<br>" +returndata.get( 1 ).get(i)+ "</html>" );

  } catch (exception e){}

  try {

  if (returndata.get( 2 ).get(i).equals( 0 ))

  roomjb.get(i).setforeground(color.green);

  else if (returndata.get( 2 ).get(i).equals( 1 ))

  roomjb.get(i).setforeground(color.pink);

  else

  roomjb.get(i).setforeground(color.red);

  } catch (exception e){}

  repaint();

  }

  }

}

/**====================================================**

  * 项目名  ：酒店管理系统

  * 模块名  ：入住登记窗口与预定登记窗口

  * 文件名  ：checkin.java

  * 相关文件  ：databaseconnct.java

  * 实现功能  ：入住登记或预定登记并写入数据库

  * 函数说明  ：

  * [## public checkin(){}]：

  * 功能：构造函数 组建入住登记窗口

  *

  * [## public void cancelbutton(){}]

  * 功能：取消按钮的事件监听处理

  *

  * [## returnbutton{}]:

  * 功能：返回按钮的事件监听处理

  *

  * [## public void checkinbutton(final int flag){}]:

  * 功能：确定登记按钮的事件监听处理

  *

  **===================================================**/

package com.databasejdbc;

import com.hotelgui.myhotelmaingui;

import com测试数据mon.*;

import java.util.*;

import java.awt.*;

import java.awt.event.*;

import java.awt.event.actionevent;

import java.awt.event.actionlistener;

import java.awt.event.mouseevent;

import java.awt.event.mouselistener;

import javax.swing.*;

public class checkin extends jframe {

  jlabel name_jl,gender_jl,id_jl,room_num_jl,room_type_jl,checkin_jl,checkout_jl,tital_jl,tip_jl,price_jl,charge_jl,despoit_jl,tip_jl1,tip_jl2;

  jbutton checkin_bt,cancel_bt,return_bt;

  jcombobox<string> gender_jb,room_type_jb;

  jtextfield name_jf,id_jf;

  public jtextfield room_num_jf;

  jtextfield price_jf;

  jtextfield despoit_jf;

  jtextfield charge_jf;

  jtextfield checkin_jf;

  jtextfield checkout_jf;

  public static void main(string[] args) {

  // todo auto-generated method stub

  checkin ck= new checkin( "入住登记" , "images\checkin_bt.jpg" );

  ck.cancelbutton();

  //ck.checkinbutton();

  }

  /**====================================================**

  * **[## public checkin(){}] 构造函数

  * 参数 ：string str1,string path //界面tital、按钮ui地址

  * 返回值 ：无

  * 修饰符 ：public

  * 功能 ：构造函数，初始化入住登记界面

  **===================================================**/

  public checkin(string str1,string path)

  {

  tital_jl= new jlabel(str1);

  tital_jl.setbounds( 300 , 20 , 100 , 60 );

  tital_jl.setfont( new font( "宋体" ,font.bold, 23 ));

  tip_jl= new jlabel( "（以下信息请完整填写）" );

  tip_jl.setbounds( 270 , 70 , 200 , 30 );

  tip_jl.setfont( new font( "宋体" ,font.hanging_baseline, 14 ));

  name_jl= new jlabel( "姓 名" );

  name_jl.setbounds( 150 , 170 , 60 , 30 );

  name_jl.setfont( new font( "宋体" ,font.hanging_baseline, 14 ));

  name_jf= new jtextfield( 10 );

  name_jf.setbounds( 230 , 170 , 140 , 27 );

  id_jl= new jlabel( "身份证号" );

  id_jl.setbounds( 450 , 170 , 60 , 30 );

  id_jl.setfont( new font( "宋体" ,font.hanging_baseline, 14 ));

  id_jf= new jtextfield( 10 );

  id_jf.setbounds( 530 , 170 , 140 , 27 );

  gender_jl= new jlabel( "性 别" );

  gender_jl.setbounds( 150 , 220 , 60 , 30 );

  gender_jl.setfont( new font( "宋体" ,font.hanging_baseline, 14 ));

  gender_jb= new jcombobox<string>();

  gender_jb.setbounds( 230 , 220 , 140 , 27 );

  gender_jb.additem( "男" );

  gender_jb.additem( "女" );

  room_num_jl= new jlabel( "房 间 号" );

  room_num_jl.setbounds( 450 , 220 , 60 , 30 );

  room_num_jl.setfont( new font( "宋体" ,font.hanging_baseline, 14 ));

  room_num_jf= new jtextfield( 10 );

  room_num_jf.setbounds( 530 , 220 , 140 , 27 );

  room_type_jl= new jlabel( "房间标准" );

  room_type_jl.setbounds( 150 , 270 , 60 , 30 );

  room_type_jl.setfont( new font( "宋体" ,font.hanging_baseline, 14 ));

  room_type_jb= new jcombobox<string>();

  room_type_jb.setbounds( 230 , 270 , 140 , 27 );

  room_type_jb.additem( "商务单间" );

  room_type_jb.additem( "商务标间" );

  room_type_jb.additem( "大床房" );

  room_type_jb.additem( "杂物间" );

  price_jl= new jlabel( "房间价格" );

  price_jl.setbounds( 450 , 270 , 60 , 30 );

  price_jl.setfont( new font( "宋体" ,font.hanging_baseline, 14 ));

  price_jf= new jtextfield( 10 );

  price_jf.setbounds( 530 , 270 , 140 , 27 );

  charge_jl= new jlabel( "实际收费" );

  charge_jl.setbounds( 150 , 320 , 60 , 30 );

  charge_jl.setfont( new font( "宋体" ,font.hanging_baseline, 14 ));

  charge_jf= new jtextfield( 10 );

  charge_jf.setbounds( 230 , 320 , 140 , 27 );

  despoit_jl= new jlabel( "预收押金" );

  despoit_jl.setbounds( 450 , 320 , 60 , 30 );

  despoit_jl.setfont( new font( "宋体" ,font.hanging_baseline, 14 ));

  despoit_jf= new jtextfield( 10 );

  despoit_jf.setbounds( 530 , 320 , 140 , 27 );

  checkin_jl= new jlabel( "入住日期" );

  tip_jl1= new jlabel( "(####-##-##)" );

  tip_jl1.setbounds( 145 , 400 , 80 , 40 );

  checkin_jl.setbounds( 150 , 370 , 60 , 40 );

  checkin_jl.setfont( new font( "宋体" ,font.hanging_baseline, 14 ));

  checkin_jf= new jtextfield( 10 );

  checkin_jf.setbounds( 230 , 370 , 140 , 27 );

  checkout_jl= new jlabel( "离店日期" );

  tip_jl2= new jlabel( "(####-##-##)" );

  tip_jl2.setbounds( 445 , 400 , 80 , 40 );

  checkout_jl.setbounds( 450 , 370 , 60 , 30 );

  checkout_jl.setfont( new font( "宋体" ,font.hanging_baseline, 14 ));

  checkout_jf= new jtextfield( 10 );

  checkout_jf.setbounds( 530 , 370 , 140 , 27 );

  checkin_bt= new jbutton( new imageicon(path));

  checkin_bt.setbounds( 160 , 500 , 85 , 30 );

  checkin_bt.setopaque( false );

  cancel_bt= new jbutton( new imageicon( "images\cancel_bt.jpg" ));

  cancel_bt.setbounds( 345 , 500 , 85 , 30 );

  cancel_bt.setopaque( false );

  return_bt= new jbutton( new imageicon( "images\return_bt.jpg" ));

  return_bt.setbounds( 530 , 500 , 85 , 30 );

  return_bt.setopaque( false );

  return_bt.setactioncommand( "1" );

  /**========================================**

  *  返回按钮注册监听

  =========================================*/

  return_bt.addactionlistener( new actionlistener() {

  @override

  public void actionperformed(actionevent e) {

  // todo auto-generated method stub

  if (e.getactioncommand().equals( "1" ))

  returnbutton();

  }

  });

  this .setlayout( null );

  this .add(tital_jl);

  this .add(tip_jl);

  this .add(name_jl);

  this .add(name_jf);

  this .add(id_jl);

  this .add(gender_jl);

  this .add(room_num_jl);

  this .add(room_type_jl);

  this .add(price_jl);

  this .add(charge_jl);

  this .add(despoit_jl);

  this .add(checkin_jl);

  this .add(tip_jl1);

  this .add(checkout_jl);

  this .add(tip_jl2);

  this .add(checkin_bt);

  this .add(cancel_bt);

  this .add(return_bt);

  this .add(id_jf);

  this .add(gender_jb);

  this .add(room_num_jf);

  this .add(room_type_jb);

  this .add(price_jf);

  this .add(charge_jf);

  this .add(despoit_jf);

  this .add(checkin_jf);

  this .add(checkout_jf);

  this .settitle(str1);

  this .seticonimage( new imageicon( "images\入住登记.jpg" ).getimage());

  this .setbounds( 250 , 80 , toolkit.getdefaulttoolkit().getscreensize().width- 600 ,toolkit.getdefaulttoolkit().getscreensize().height- 150 );

  this .setresizable( false );

  this .setvisible( true );

}

  /**====================================================**

  * **[## public void cancelbutton() {}] 取消按钮操作

  * 参数 ：无

  * 返回值 ：无

  * 修饰符 ：public

  * 功能 ：点击取消按钮清空操作

  **===================================================**/

  public void cancelbutton()

  {

  cancel_bt.addactionlistener( new actionlistener() {

  @override

  public void actionperformed(actionevent e) {

  // todo auto-generated method stub

  name_jf.settext( "" );

  id_jf.settext( "" );

  room_num_jf.settext( "" );

  charge_jf.settext( "" );

  price_jf.settext( "" );

  despoit_jf.settext( "" );

  checkin_jf.settext( "" );

  checkout_jf.settext( "" );

  gender_jb.setselectedindex( 0 );

  room_type_jb.setselectedindex( 0 );

  }

  });

  }

  /**====================================================**

  * **[## public void returnbutton() {}] 返回按钮操作

  * 参数 ：无

  * 返回值 ：无

  * 修饰符 ：public

  * 功能 ：点击返回按钮返回到主界面，入住登记界面释放

  **===================================================**/

  public void returnbutton()

  {

  this .dispose();

  }

  /**====================================================**

  * **[## public void checkinbutton(int flag) {}] 确定按钮操作

  * 参数 ：int flag flag==1,则表示入住登记状态更改 ；flag==2，则表示预订登记状态更改

  * 返回值 ：无

  * 修饰符 ：public

  * 功能 ：点击确定按钮进行入住登记输入数据库操作操作

  **===================================================**/

  public void checkinbutton( final int flag)

  {

  checkin_bt.addactionlistener( new actionlistener() {

  @override

  public void actionperformed(actionevent e) {

  // todo auto-generated method stub

  databaseconnect dc= new databaseconnect();

  string str= new string(integer.valueof(room_num_jf.gettext())+ ",'" +name_jf.gettext()+ "','" +gender_jb.getselecteditem().tostring()+ "','" +

   id_jf.gettext()+ "','" +checkin_jf.gettext()+ "','" +checkout_jf.gettext()+ "'," +integer.valueof(charge_jf.gettext())+ "," +integer.valueof(despoit_jf.gettext())+ "," + 1 );

  try {

  dc.insertdata( "costomer_table" , str);

  } catch (exception e1) {

  // todo auto-generated catch block

  e1.printstacktrace();

  }

  string sql= "update room_table set roomatate=" +flag+ " where roomnum=" +integer.valueof(room_num_jf.gettext());

  try {

  dc.updatedata(sql);

  } catch (exception e1) {

  // todo auto-generated catch block

  e1.printstacktrace();

  }

  joptionpane.showconfirmdialog( null , "登记成功!" , "提示" ,joptionpane.closed_option);

  int option= 0 ;

  if (option==joptionpane.yes_option)

  {

  try {

  myhotelmaingui hm= new myhotelmaingui( 1 );

  hm.updateroomstate();

  thread th= new thread(hm);

  th.start();

  }

  catch (exception e1)

  {}

  }

  }

  });

  }

}