java简易客户开房管理系统.docx
《java简易客户开房管理系统.docx》由会员分享,可在线阅读,更多相关《java简易客户开房管理系统.docx(18页珍藏版)》请在冰豆网上搜索。
java简易客户开房管理系统
importjava.sql.*;
classRoom//添加一个客房的基本信息
{
staticStringNumber;
staticDoublePrice;
staticbooleanadd=true;
staticbooleansearch()
{
Connectioncon;
Statementsql;
ResultSetrs;
inti=0;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundExceptione)
{
System.out.println(""+e);
}
try
{
con=DriverManager.getConnection
("jdbc:
odbc:
dan","dan","123");
sql=con.createStatement();
rs=sql.executeQuery("SELECT*FROMroom");
while(rs.next())
{
Stringa=rs.getString
(2);
Stringb=rs.getString(3);
Stringc=rs.getString(4);
if(c.equals("0"))//显示空房信息
{
System.out.println("空闲房间");
System.out.println("房号:
"+a);
System.out.println("价格:
"+b);
Room.Number=a;
Room.Price=Double.parseDouble(b);
sql.executeUpdate("updateroomsetEmpty='1'whereRoomNumber='"+a+"'");//入住后empty=1,表示有人入住
i=1;
break;
}
}
con.close();
}
catch(SQLExceptione)
{
System.out.println(e);
}
if(i==1)returntrue;
elsereturnfalse;
}
booleaninit()
{
StringNumber,Str;
DoublePrice;
intn=0;
while(true)
{
if(Room.search())break;//有空闲房间就退出,否则添加房间
Str=javax.swing.JOptionPane.showInputDialog("客房已满,是否添加新客房?
\n1.是0.否");
n=Integer.parseInt(Str);
if(n==1)
{
Number=javax.swing.JOptionPane.showInputDialog("输入房号");
Str=javax.swing.JOptionPane.showInputDialog("输入价格");
Price=Double.parseDouble(Str);
this.Number=Number;
this.Price=Price;
break;
}
if(n==0)
{
javax.swing.JOptionPane.showMessageDialog(null,"没有客房添加!
");
Room.add=false;
break;
}
else
{
javax.swing.JOptionPane.showMessageDialog(null,"错误!
请重新输入");
}
}
if(n==1)returntrue;
else
returnfalse;
}
voiddisplay()
{
System.out.println("RoomNumberis"+Number);
System.out.println("ThePriceis"+Price);
}
voidShowMessage()
{
javax.swing.JOptionPane.showMessageDialog(null,"房号:
"+Number+"价格:
"+Price);
}
}
classCustomerextendsRoom//顾客姓名、身份证号、房号,天数
{
StringCustomerName;
StringIDcard;
StringRoomNumber;
intDay;
voidCreat()
{
Connectioncon;
Statementsql;
ResultSetrs;
StringCustomerName;
StringIDcard;
StringRoomNumber;
StringStr;
DoublePay;
intDay;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundExceptione)
{
System.out.println(""+e);
}
try
{
con=DriverManager.getConnection
("jdbc:
odbc:
dan","dan","123");
sql=con.createStatement();
CustomerName=javax.swing.JOptionPane.showInputDialog("顾客姓名:
");
IDcard=javax.swing.JOptionPane.showInputDialog("身份证号:
");
RoomNumber=Number;
Str=javax.swing.JOptionPane.showInputDialog("入住天数:
");
Day=Integer.parseInt(Str);
Pay=Price;
sql.executeUpdate("insertintomember(CustomerName,IDcard,RoomNumber,Day,Price)values('"+CustomerName+"','"+IDcard+"','"+RoomNumber+"',"+Day+","+Price+")");
this.CustomerName=CustomerName;
this.IDcard=IDcard;
this.RoomNumber=RoomNumber;
this.Day=Day;
con.close();
}
catch(SQLExceptione)
{
System.out.println(e);
}
}
voidDisplay()
{
System.out.println("CustomerNameis"+CustomerName);
System.out.println("IDcardis"+IDcard);
System.out.println("RoomNumberis"+RoomNumber);
System.out.println("Dayis"+Day);
}
voidShowMessage()
{
javax.swing.JOptionPane.showMessageDialog(null,"*****客户注册信息*****\n姓名:
"+CustomerName+"\n身份证号:
"+IDcard+"\n房号:
"+RoomNumber+"\n入住天数:
"+Day);
}
}
classQuery
{
voidLookUp()
{
Connectioncon;
Statementsql;
ResultSetrs;
Stringnamelist;
inti=0;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundExceptione)
{
System.out.println(""+e);
}
try
{
con=DriverManager.getConnection
("jdbc:
odbc:
dan","dan","123");
sql=con.createStatement();
namelist=javax.swing.JOptionPane.showInputDialog("身份证号:
");
rs=sql.executeQuery("SELECTCustomerName,IDcard,RoomNumber,Day,PriceFROMmember");//查询信息
while(rs.next())
{
Stringname=rs.getString
(1);
StringIDcard=rs.getString
(2);
StringRoomNumber=rs.getString(3);
StringDay=rs.getString(4);
StringPrice=rs.getString(5);
Doublea,b,Pay;
if(IDcard.equals(namelist))
{
System.out.println("\n身份证号:
"+IDcard);
System.out.println("姓名:
"+name);
System.out.println("房号:
"+RoomNumber);
System.out.println("入住天数:
"+Day);
System.out.println("价格:
"+Price);
a=Double.parseDouble(Day);
b=Double.parseDouble(Price);
Pay=a*b;
System.out.println("应缴款数:
"+Pay);
javax.swing.JOptionPane.showMessageDialog(null,"客户:
\n"+name+",您应交纳"+Pay+"元");
i=1;
break;
}
}
if(i==0)
{
javax.swing.JOptionPane.showMessageDialog(null,"没有该客户任何信息记录!
");
System.out.print("\n没有记录");
}
con.close();
}
catch(SQLExceptione)
{
System.out.println(e);
}
}
}
classDelete
{
booleandelete()
{
Connectioncon;
Statementsql;
ResultSetrs,sr;
Stringnamelist;
inti=0;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundExceptione)
{
System.out.println(""+e);
}
try
{
con=DriverManager.getConnection
("jdbc:
odbc:
dan","dan","123");
sql=con.createStatement();
namelist=javax.swing.JOptionPane.showInputDialog("待删除信息的客户身份证号:
");
rs=sql.executeQuery("SELECT*FROMmember");//查询信息
while(rs.next())
{
StringIDcard=rs.getString(3);
StringRoomNumber=rs.getString(4);
System.out.println("\n房号:
"+RoomNumber);
System.out.println("身份证号:
"+IDcard);
if(namelist.equals(IDcard))
{
sql.executeUpdate("updateroomsetEmpty='0'whereRoomNumber='"+RoomNumber+"'");//入住后empty=0,表示无人入住
sql.executeUpdate("deletefrommemberwhereIDcard='"+namelist+"'");//删除数据
i=1;
break;
}
}
con.close();
}
catch(SQLExceptione)
{
System.out.println(e);
}
if(i==1)returntrue;
elsereturnfalse;
}
}
publicclassacess
{publicstaticvoidmain(Stringargs[])
{
StringStr;
intn,m,k=0;
javax.swing.JOptionPane.showMessageDialog(null,"欢迎使用客房管理系统!
");
while(true)
{
Str=javax.swing.JOptionPane.showInputDialog("********客房管理系统********\n======1.添加住户======\n======2.查询住户======\n======3.删除住户======\n======0.直接退出======");
n=Integer.parseInt(Str);
if(n==1)//添加客房和用户信息
{
Roomroom=newRoom();
Customercustomer=newCustomer();
if(room.init())
{
customer.Creat();
k=1;
}
else
{
if(room.add)
{
customer.Creat();
k=1;
}
}
while(k==1)
{
if(room.add)
{
Str=javax.swing.JOptionPane.showInputDialog("是否显示输入信息?
\n1.是0.否");
m=Integer.parseInt(Str);
if(m==1)
{
room.ShowMessage();
customer.ShowMessage();
break;
}
if(m==0)
{
javax.swing.JOptionPane.showMessageDialog(null,"欢迎再次使用!
");
break;
}
else
javax.swing.JOptionPane.showMessageDialog(null,"错误!
请重新输入");
}
}
if(k==1)
{
room.display();
customer.Display();
}
else
System.out.println("没有添加客房,返回菜单!
");
}
if(n==2)//查询住户
{
while(true)
{
Queryquery=newQuery();
query.LookUp();
Str=javax.swing.JOptionPane.showInputDialog("是否继续查询?
\n1.是0.否");
m=Integer.parseInt(Str);
if(m==1)continue;
if(m==0)
{
break;
}
else
javax.swing.JOptionPane.showMessageDialog(null,"错误!
请重新输入");
}
}
if(n==3)
{
while(true)
{
DeleteX=newDelete();
if(X.delete())
System.out.println("删除成功!
");
else
System.out.println("删除失败!
");
Str=javax.swing.JOptionPane.showInputDialog("是否继续删除?
\n1.是0.否");
m=Integer.parseInt(Str);
if(m==1)continue;
if(m==0)
{
break;
}
else
javax.swing.JOptionPane.showMessageDialog(null,"错误!
请重新输入");
}
}
if(n==0)
{
javax.swing.JOptionPane.showMessageDialog(null,"欢迎再次使用!
");
break;
}
if(n<0||n>3)
{
javax.swing.JOptionPane.showMessageDialog(null,"错误!
请重新输入");
}
}
}
}