crrs.java.bak

java与mdb,一个简单的java访问数据库系统

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);
	}
}