java实现客房管理系统

import java.awt.borderlayout;

import java.awt.color;

import java.awt.container;

import java.awt.flowlayout;

import java.awt.gridlayout;

import java.awt.event.actionevent;

import java.awt.event.actionlistener;

import java.sql.connection;

import java.sql.drivermanager;

import java.sql.resultset;

import java.sql.statement;

import java.util.calendar;

import javax.naming.spi.dirstatefactory.result;

import javax.swing.borderfactory;

import javax.swing.box;

import javax.swing.buttongroup;

import javax.swing.jbutton;

import javax.swing.jdialog;

import javax.swing.jframe;

import javax.swing.jlabel;

import javax.swing.joptionpane;

import javax.swing.jpanel;

import javax.swing.jradiobutton;

import javax.swing.jtextfield;

import javax.swing.uimanager;

import javax.swing.uimanager.lookandfeelinfo;

  public class addclient extends jframe implements actionlistener{

  jtextfield sname,id,age,home_addr,employer,phone,cno,rno,intime,outtime,days,cashpledge;

  jbutton save,cancel,save1;

  jpanel pl,pl1,pl2,pl3,pl4,pl5,pl6,pl7,pl8,pl9,pl10,pl11,pl12,pl13,pl14,pl15,pl16;

  jradiobutton man,wuman,yes,no;

  buttongroup group,group1;

  string sex,vip;

  int k,k1,k2;

  public addclient(){

  pl= new jpanel();

  pl1= new jpanel();

  pl2= new jpanel();

  pl3= new jpanel();

  pl4= new jpanel();

  pl5= new jpanel();

  pl6= new jpanel();

  pl7= new jpanel();

  pl8= new jpanel();

  pl9= new jpanel();

  pl10= new jpanel();

  pl11= new jpanel();

  pl12= new jpanel();

  pl13= new jpanel();

  pl14= new jpanel();

  pl15= new jpanel();

  pl16= new jpanel( new flowlayout(flowlayout.center, 20 , 20 ));

  sname= new jtextfield( 15 );

  id= new jtextfield( 15 );

  age= new jtextfield( 15 );

  home_addr= new jtextfield( 15 );

  employer= new jtextfield( 15 );

  phone= new jtextfield( 15 );

  cno= new jtextfield( 15 );

  rno= new jtextfield( 15 );

  intime= new jtextfield( 15 );

  outtime= new jtextfield( 15 );

  days= new jtextfield( 15 );

  cashpledge= new jtextfield( 15 );

  group= new buttongroup();

  group1= new buttongroup();

  man= new jradiobutton( "男" , true );

  wuman= new jradiobutton( "女" , false );

  yes= new jradiobutton( "是" , true );

  no= new jradiobutton( "否" , false );

  group.add(man);

  group.add(wuman);

  group1.add(yes);

  group1.add(no);

  pl1.add( new jlabel( "姓名：  " ,jlabel.right));

  pl1.add(sname);

  pl2.add( new jlabel( "身份证号：" ,jlabel.right));

  pl2.add(id);

  pl3.add( new jlabel( "性别：  " ,jlabel.right));

  pl3.add(man);

  pl3.add(wuman);

  pl4.add( new jlabel( "vip客户:" ));

  pl4.add(yes);

  pl4.add(no);

  pl5.add( new jlabel( "年龄：  " ,jlabel.right));

  pl5.add(age);

  pl6.add( new jlabel( "家庭地址：" ,jlabel.right));

  pl6.add(home_addr);

  pl7.add( new jlabel( "工作单位：" ,jlabel.right));

  pl7.add(employer);

  pl8.add( new jlabel( "手机号： " ,jlabel.right));

  pl8.add(phone);

  pl.setborder(borderfactory.createtitledborder( "客户 信息" ));

  pl.setlayout( new gridlayout( 4 , 2 , 10 , 10 ));

  pl.add(pl1);

  pl.add(pl2);

  pl.add(pl3);

  pl.add(pl4);

  pl.add(pl5);

  pl.add(pl8);

  pl.add(pl7);

  pl.add(pl6);

  pl9.add( new jlabel( "房号：   " ,jlabel.right));

  pl9.add(rno);

  pl10.add( new jlabel( "入住时间：" ,jlabel.right));

  pl10.add(intime);

  pl11.add( new jlabel( "预离店时间" ,jlabel.right));

  pl11.add(outtime);

  pl12.add( new jlabel( "入住天数：" ,jlabel.right));

  pl12.add(days);

  pl13.add( new jlabel( "预交押金：" ,jlabel.right));

  pl13.add(cashpledge);

  pl14.add( new jlabel( "入住序号：" ,jlabel.right));

  pl14.add(cno);

  pl15.setborder(borderfactory.createtitledborder( "客户入住 信息" ));

  pl15.setlayout( new gridlayout( 3 , 2 , 15 , 15 ));

  pl15.add(pl14);

  pl15.add(pl9);

  pl15.add(pl10);

  pl15.add(pl11);

  pl15.add(pl12);

  pl15.add(pl13);

  save= new jbutton( "登记入住" );

  cancel= new jbutton( "取消" );

  save1= new jbutton( "添加家属" );

  save.addactionlistener( this );

  cancel.addactionlistener( this );

  save1.addactionlistener( this );

  pl16.add(save);

  pl16.add(save1);

  pl16.add(cancel);

  add(pl,borderlayout.north);

  add(pl15,borderlayout.center);

  add(pl16,borderlayout.south);

  setbounds( 600 , 300 , 600 , 600 );

  settitle( "客户入住信息" );

  setvisible( true );

  }

  @override

  public void actionperformed(actionevent e) {

  if (e.getsource()==save){

  int result=joptionpane.showconfirmdialog( null , "确认提交吗" , "温馨提示" , joptionpane.yes_no_option);

  if (result== 0 ) {

  if (man.isselected()){

   sex= "男" ;

   }

  else {

   sex= "女" ;

   }

  if (yes.isselected()){

   vip= "是" ;

   }

  else {

   vip= "否" ;

   }

  try

   {

   class .forname(url.driver);

   connection con=drivermanager.getconnection(url.url,url.username,url.userpwd);

   statement sql=con.createstatement(resultset.type_scroll_sensitive,resultset.concur_read_only);

   k=sql.executeupdate( "insert into client values('" +sname.gettext()+ "','" +id.gettext()+ "','" +sex+ "','" +age.gettext()+ "','" +home_addr.gettext()+ "','" +employer.gettext()+ "','" +vip+ "','" +phone.gettext()+ "')" );

   k1=sql.executeupdate( "insert into check_in(cno,rno,intime,outtime,dayss,cashpledge) values('" +cno.gettext()+ "','" +rno.gettext()+ "','" +intime.gettext()+ "','" +outtime.gettext()+ "','" +days.gettext()+ "','" +cashpledge.gettext()+ "')" );

   k2=sql.executeupdate( "insert into type_in values('" +cno.gettext()+ "','" +id.gettext()+ "')" );

   if (k== 1 &&k1== 1 &&k2== 1 ) {

   int result1=joptionpane.showconfirmdialog( null , "入住成功!是否添加家属信息?" , "温馨提示" , joptionpane.yes_no_option);

   if (result1== 0 ){

   id.settext( "" );

   sname.settext( "" );

   age.settext( "" );

   home_addr.settext( "" );

   phone.settext( "" );

   employer.settext( "" );

   }

   else {

   dispose();

   }

  }

   } catch (exception e1){

   joptionpane.showmessagedialog( this , "入住失败" );

   }

  }

  }

  if (e.getsource()==cancel){

  dispose();

  }

  if (e.getsource()==save1){

  int result=joptionpane.showconfirmdialog( null , "确认提交吗" , "温馨提示" , joptionpane.yes_no_option);

  if (result== 0 ) {

  if (man.isselected()){

   sex= "男" ;

   }

  else {

   sex= "女" ;

   }

  if (yes.isselected()){

   vip= "是" ;

   }

  else {

   vip= "否" ;

   }

  try

   {

   class .forname(url.driver);

   connection con=drivermanager.getconnection(url.url,url.username,url.userpwd);

   statement sql=con.createstatement();

   k=sql.executeupdate( "insert into client values('" +sname.gettext()+ "','" +id.gettext()+ "','" +sex+ "','" +age.gettext()+ "','" +home_addr.gettext()+ "','" +employer.gettext()+ "','" +vip+ "','" +phone.gettext()+ "')" );

   k2=sql.executeupdate( "insert into type_in values('" +cno.gettext()+ "','" +id.gettext()+ "')" );

   if (k== 1 &&k2== 1 ) {

   int result1=joptionpane.showconfirmdialog( null , "入住成功!是否继续添加家人信息?" , "温馨提示" , joptionpane.yes_no_option);

   if (result1== 0 ){

   id.settext( "" );

   sname.settext( "" );

   age.settext( "" );

   home_addr.settext( "" );

   phone.settext( "" );

   employer.settext( "" );

   }

   else {

   dispose();

   }

  }

   } catch (exception e1){

   joptionpane.showmessagedialog( this , "添加失败" );

   }

  }

  }

  }

}

import java.awt.borderlayout;

import java.awt.container;

import java.awt.event.actionevent;

import java.awt.event.actionlistener;

import javax.swing.imageicon;

import javax.swing.jdialog;

import javax.swing.jframe;

import javax.swing.jlabel;

import javax.swing.jmenu;

import javax.swing.jmenubar;

import javax.swing.jmenuitem;

import javax.swing.jpanel;

class adminframe extends jdialog implements actionlistener{

  jlabel label = new jlabel();

  jmenubar mbar= new jmenubar();

  private jmenu quarto,message,clinet;

  private jmenuitem item1,item2,item3,item4,item5,item6,item7,item8,item9;

  jpanel pl1;

  container con;

  adminframe(){

  pl1= new jpanel();

  setjmenubar(mbar);

  imageicon icon = new imageicon( "src/picture/1.jpg" );

  label.seticon(icon);

  label.setbounds( 0 , 0 , 600 , 500 );

  pl1.add(label);

  add(pl1);

  setbounds( 600 , 300 , 600 , 500 );

  quarto= new jmenu( "客房操作" );

  message= new jmenu( "信息查询" );

  clinet= new jmenu( "统计客房相关信息" );

  mbar.add(quarto);

  mbar.add(message);

  mbar.add(clinet);

  item3= new jmenuitem( "查询客房" );

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

  item2= new jmenuitem( "退房操作" );

  quarto.add(item1);

  quarto.addseparator();

  quarto.add(item2);

  quarto.addseparator();

  quarto.add(item3);

  item4= new jmenuitem( "客人信息查询" );

  item5= new jmenuitem( "客房时间查询" );

  item6= new jmenuitem( "客人费用查询" );

  message.add(item4);

  message.addseparator();

  message.add(item5);

  message.addseparator();

  message.add(item6);

  item7= new jmenuitem( "各类房型入住情况" );

  item8= new jmenuitem( "各月份客房收入" );

  clinet.add(item7);

  clinet.addseparator();

  clinet.add(item8);

  item1.addactionlistener( this );

  item2.addactionlistener( this );

  item3.addactionlistener( this );

  item4.addactionlistener( this );

  item5.addactionlistener( this );

  item6.addactionlistener( this );

  item7.addactionlistener( this );

  item8.addactionlistener( this );

  setvisible( false );

  settitle( "客房管理系统" );

  validate();

  }

  @override

  public void actionperformed(actionevent e) {

  if (e.getsource()==item1){

  addclient stu= new addclient();

  stu.setvisible( true );

  }

  if (e.getsource()==item2){

  left left= new left();

  left.setvisible( true );

  }

  if (e.getsource()==item3) {

  queryroom qr= new queryroom();

  qr.setvisible( true );

  }

  if (e.getsource()==item4) {

  queryclient qc= new queryclient();

  qc.setvisible( true );

  }

  if (e.getsource()==item5){

  querytime qt= new querytime();

  qt.setvisible( true );

  }

  if (e.getsource()==item6){

  querycost qc= new querycost();

  qc.setvisible( true );

  }

  if (e.getsource()==item7){

  statisticsinformation si= new statisticsinformation();

  si.setvisible( true );

  }

  if (e.getsource()==item8){

  income income= new income();

  income.setvisible( true );

  }

}

}