会议室预定系统--数据库版

import java.util.ArrayList; import java.io.*; public class CRRS { OrderList odl; RoomList rml; //入口主函数 public static void main(String[] args) throws Exception { System.out.println("= = = = = = = = == == == == == == == == == == == == ="); System.out.println("= 会议室预定系统 ="); System.out.println("= Conference Room Reservation(CRRS) ="); System.out.println("= 计04-4 尤海洋 200450080437 ="); System.out.println("= == == == == == == == == == == == == == == == == ==="); CRRS cr=new CRRS(); //显示绑定数据库信息 cr.bindList(); } //绑定数据库信息 public void bindList() throws Exception { //会议室信息 String sqlRoom="select * from RoomList"; RoomData rd=new RoomData();//实例化数据库操作对库 rd.OpenConn();//打开数据库连接 rml=rd.selectRoomList(sqlRoom);//执行SQL语句(详见RoomData类) rd.closeConn();//关闭数据库连接 rml.display();//显示数据库信息 //已预定会议室信息 String sqlOrder="select * from OrderList"; OrderData od=new OrderData(); od.OpenConn(); odl=od.selectOrderList(sqlOrder); od.closeConn(); odl.display(); //接收用户输入预定会议室信息 this.enterString(rml,odl); } //从数据库显示已经预定会议室信息 public void bindOrderList() throws Exception { String sqlOrder="select * from OrderList"; OrderData od=new OrderData(); od.OpenConn(); odl=od.selectOrderList(sqlOrder); od.closeConn(); odl.display(); } //用户输入预定会议室信息 public void enterString(RoomList rml,OrderList odl) throws Exception { boolean find=false; do { BufferedReader br = new BufferedReader(new InputStreamReader(System.in)); int count=0; String date,time,rmSn; RoomList rlTmp=new RoomList(); System.out.print("\n请输入于会人数："); try { count=Integer.parseInt(br.readLine()); } catch (NumberFormatException e) { System.err.println("数字格式错误:"+e.getMessage()); } System.out.print("\n请输入日期："); date=br.readLine(); System.out.print("\n请输入时间："); time=br.readLine(); //查看是否与已预定会议室冲突(详见OrderList类) Room rmTmp=odl.checkOrder(date,time); System.out.println("\n符合要求的会议室:\n"); System.out.println("房间编号 房间容量"); //判断并输出符合要求的会议室供申请者选择 for(int i=0;i<rml.getRm().size();i++) { if((rmTmp!=rml.getRm().get(i)) && (rml.getRm().get(i).notFull(count))) { find=true; rml.getRm().get(i).display(); rlTmp.getRm().add(rml.getRm().get(i)); System.out.print("\n"); } } if(!find) { System.out.println("\n\t对不起，没有符合您要求的会议室"); } else { boolean allowed=false; do { System.out.print("\n请选择您想要预定的会议室编号："); rmSn=br.readLine(); if(odl.searchOrder(rmSn,rlTmp)) { System.out.println("\n请输入您的个人信息："); System.out.print("姓名："); String name=br.readLine(); System.out.print("所在部门："); String dep=br.readLine(); System.out.print("电话号码："); String phone=br.readLine(); String insertSql="insert into OrderList(ol_Room,ol_Capacity,ol_Applicant,ol_Phone,ol_Date,ol_Time)values('"+rmSn+"',"+count+",'"+name+"','"+phone+"','"+date+"','"+time+"')"; //将新的会议室定单写入数据库 OrderData od=new OrderData(); od.OpenConn(); od.insertOrder(insertSql); od.closeConn(); //再次显示已预定会议室信息 this.bindOrderList(); allowed=true; } else { System.out.println("\t对不起，该房间不在可用列表当中，请重新选择"); } }while (!allowed); } }while (!find); } }