waitmeetlist.java

可以完成会议室预定功能

import java.awt.*;
import java.sql.*;
import java.util.*;
import javax.swing.*;
import javax.swing.table.DefaultTableModel;

public class WaitMeetList {

	private MeetingRoom meetingRoom = null;
	public ArrayList waitList = new ArrayList<Meet>();
	
	private Connection conn = new DBConnection("MEET","huanongying","123456").getConn();
	private Statement stmt;
	private ResultSet rs;
	
	public WaitMeetList(){
		
	}
	public WaitMeetList(MeetingRoom meetingRoom){//构造函数
		this.meetingRoom = meetingRoom;
	}	
	public void showWaitList(String name){//框架

		try{
			JFrame frame = new JFrame();
			String sql = new String();
			//conn = new DBConnection("MEET","huanongying","123456").getConn();
			stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			//sql ="SELECT * FROM meet where name='"+meetingRoom.getName()+"'";
			sql = "SELECT * FROM meet where meetingRoomName='"+name+"'";
			rs = stmt.executeQuery(sql);
			
			//定义窗体中要用到的对象
			JLabel label = new JLabel("以下为会议室所查询会议室的会议等待列表：");
			
			//定义一个滚动条，以便信息过多时可以上下托动查看信息
			JScrollPane scrollPane = new JScrollPane();
			//定义临时集合
			Vector tempVector = new Vector(1,1);
			//定义DefaultTableModel模型
			DefaultTableModel model = new DefaultTableModel();
			//定义JTabel为DefaultTableModel的实例model模式
			JTable table = new JTable(model);
			
			label.setFont(new Font("Dialog",0,14));
			//向model中加入列名
			model.addColumn("会议ID");
			model.addColumn("主题");
			model.addColumn("目的");
			model.addColumn("组织者ID号");
			model.addColumn("预期人数");
			model.addColumn("时间");
		
			
			//设置对象的格式及将其加入相应容器中
			frame.getContentPane().setLayout(new BorderLayout());
			
			frame.getContentPane().add(label,"North");
			frame.getContentPane().add(scrollPane,"Center");
			scrollPane.getViewport().add(table,null);
			frame.setSize(800,600);
			frame.setLocation(200,100);
			frame.setVisible(true);
			//调用resultShow(DefaultTableMode model)方法，显示等待列表数据
			showResult(model);
			
			
		}catch(SQLException e){
			System.out.println("showMeetingRoom()函数异常！");
			e.printStackTrace();
		}
	
		
	}
	
	public void showResult(DefaultTableModel model){

		try{
			Vector tempVector;
			rs.beforeFirst();
			while(rs.next()){
			
				tempVector = new Vector(1,1);
				tempVector.add(rs.getString("ID"));
				tempVector.add(rs.getString("subject"));
				tempVector.add(rs.getString("aim"));
				tempVector.add(rs.getString("organizerID"));
				tempVector.add(rs.getString("prePersonNum"));
				tempVector.add(rs.getString("useTime"));
		
				model.addRow(tempVector);
						
			}
		}catch(SQLException e){
			System.out.println("显示会议室的等待列表情况时出错！");
			e.printStackTrace();
		}
	
	}
}