meetingroomcontrol.java

可以完成会议室预定功能

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



public class MeetingRoomControl {
	
	private ArrayList meetingRoomList = new ArrayList<MeetingRoom>();
	private Connection conn = new DBConnection("MEET","huanongying","123456").getConn();
	private Statement stmt;
	private ResultSet rs;
		public void showMeetingRoom() {
			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 meetingRoom";
				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("容量");
				model.addColumn("已预定");
				model.addColumn("已预定的会议");
				model.addColumn("有电子白板");
				model.addColumn("内置AV设备");
				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(model);//调用resultShow(DefaultTableMode model)方法，显示会议室数据
			
				
			}catch(SQLException e){
				System.out.println("showMeetingRoom()函数异常！");
				e.printStackTrace();
			}
		}
		
		public void resultShow(DefaultTableModel model){
			try{
				Vector tempVector;
				rs.beforeFirst();
				while(rs.next()){
					tempVector = new Vector(1,1);
					tempVector.add(rs.getString("ID"));
					tempVector.add(rs.getString("name"));
					tempVector.add(rs.getString("address"));
					tempVector.add(rs.getString("capacity"));
					tempVector.add(rs.getString("beEngaged"));
					tempVector.add(rs.getString("meetEngagedID"));
					tempVector.add(rs.getString("hasElecBoard"));
					tempVector.add(rs.getString("hasInnerAV"));
					tempVector.add(rs.getString("beConnectedLAN"));
					model.addRow(tempVector);
			
					
				}
			}catch(SQLException e){
				System.out.println("显示会议室情况时出错！");
				e.printStackTrace();
			}
		}
		
	

	public static void main(String[] args) {


	}

}