java简易客户开房管理系统

import java.sql.*; class Room//添加一个客房的基本信息 { static String Number; static Double Price; static boolean add = true;

static boolean search() { Connection con; Statement sql; ResultSet rs; int i=0;

try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch(ClassNotFoundException e) { System.out.println(""+e); }

try { con=DriverManager.getConnection ("jdbc:odbc:dan","dan","123");

sql=con.createStatement(); rs=sql.executeQuery("SELECT * FROM room");

while(rs.next()) { String a = rs.getString(2); String b = rs.getString(3); String c = 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("update room set Empty = '1' where RoomNumber='"+a+"' ");//入住后empty=1,表示有人入住

i=1; break; }

} con.close(); } catch(SQLException e) { System.out.println(e); }

if(i==1) return true; else return false;

} boolean init() { String Number,Str; Double Price; int n=0;

while(true) { if(Room.search()) break;//有空闲房间就退出，否则添加房间

Str = javax.swing.JOptionPane.showInputDialog("客房已满,是否添加新客房？\n 1.是 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) return true; else return false;

} void display() { System.out.println("Room Number is "+Number); System.out.println("The Price is "+Price); } void ShowMessage() { javax.swing.JOptionPane.showMessageDialog(null,"房号:"+Number+" 价格:"+Price); }

}

class Customer extends Room//顾客姓名、身份证号、房号，天数 { String CustomerName; String IDcard; String RoomNumber; int Day;

void Creat() { Connection con; Statement sql; ResultSet rs; String CustomerName; String IDcard; String RoomNumber; String Str; Double Pay; int Day;

try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch(ClassNotFoundException e) { 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("insert into member(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(SQLException e) { System.out.println(e); } } void Display() { System.out.println("CustomerName is "+CustomerName); System.out.println("IDcard is "+IDcard); System.out.println("RoomNumber is "+RoomNumber); System.out.println("Day is "+Day); } void ShowMessage() { javax.swing.JOptionPane.showMessageDialog(null," *****客户注册信息*****\n姓名:"+CustomerName+" \n身份证号:"+IDcard+" \n房号:"+RoomNumber+" \n入住天数:"+Day); } }

class Query { void LookUp() { Connection con; Statement sql; ResultSet rs; String namelist; int i=0;

try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch(ClassNotFoundException e) { 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 CustomerName,IDcard,RoomNumber,Day,Price FROM member");//查询信息

while(rs.next()) { String name = rs.getString(1); String IDcard = rs.getString(2); String RoomNumber = rs.getString(3); String Day = rs.getString(4); String Price = rs.getString(5); Double a,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(SQLException e) { System.out.println(e); }