meet.java

可以完成会议室预定功能

import java.util.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;

public class Meet implements ActionListener {
	private int ID;
	private String subject;
	private String aim;
	private int organizerID;//组织者ID号
	private int prePersonNum;//预期人数
	private String useTime;
	private String dateRange;
	private String AVNeeded;
	private String meetingRoomName;
	
	JTextField tfSubject;
	JTextField tfAim;
	JTextField tfOrganizerID;
	JTextField tfPrePersonNum;
	JTextField tfMeetingRoomName;
	public Meet(){
		
	}
public Meet(String subject,String aim,int organizerID,int prePersonNum,String meetingRoomName){
		
		this.subject = subject;
		this.organizerID = organizerID;
		this.prePersonNum = prePersonNum;
		this.meetingRoomName = meetingRoomName;
	
	}
	
	public void addMeetForm(){
		JFrame frame = new JFrame("添加会议");
		Container contentPane = frame.getContentPane();
		JPanel panel1 = new JPanel();
		JPanel panel2 = new JPanel();
		JPanel panel3 = new JPanel();
		JPanel panel4 = new JPanel();
		JPanel panel5 = new JPanel();
		JPanel panel6 = new JPanel();
		JPanel panel7 = new JPanel();
		JButton add = new JButton("提交");
		JButton cancel = new JButton("取消");
		
		JLabel subject = new JLabel("会议主题");
		JLabel aim = new JLabel("会议目的");
		JLabel organizerID = new JLabel("申请人ID");
		JLabel prePersonNum = new JLabel("预计人数");
		JLabel meetingRoomID = new JLabel("预申请会议室");
		
		tfSubject = new JTextField(10);
		tfAim = new JTextField(10);
		tfOrganizerID = new JTextField(10);
		tfPrePersonNum = new JTextField(10);
		tfMeetingRoomName = new JTextField(10);
		
		panel1.setLayout(new FlowLayout(FlowLayout.CENTER,15,20));
		panel1.add(subject);
		panel1.add(tfSubject);
		panel2.add(aim);
		panel2.add(tfAim);
		panel3.add(organizerID);
		panel3.add(tfOrganizerID);
		panel4.add(prePersonNum);
		panel4.add(tfPrePersonNum);
		panel5.add(meetingRoomID);
		panel5.add(tfMeetingRoomName);
		
		panel6.add(add);
		panel6.add(cancel);
		
		panel7.setLayout(new GridLayout(5,1));
		panel7.add(panel1);
		panel7.add(panel2);
		panel7.add(panel3);
		panel7.add(panel4);
		panel7.add(panel5);
		panel7.add(panel6);
		
		contentPane.add(panel7,"Center");
		contentPane.add(panel6,"South");
		frame.setSize(600,500);
		frame.setLocation(200,200);
		frame.setVisible(true);
		
		addMeet();
	}	
	
	public void deleteMeet(String subject){//删除会议室
		try{
		   String sql;
	       Connection conn = new DBConnection("MEET","huanongying","123456").getConn();
	       Statement stmt = conn.createStatement();
	       sql = "delete from meet where subject='"+subject+"'";
	       stmt.executeUpdate(sql);
	      
			
		}catch (SQLException ex){
		System.out.println("删除会议时出错！");
		ex.printStackTrace();
		}
	}
		

	public static void main(String[] args) {

		//new Meet().addMeetForm();
	}


	public void setMeetingRoomName(String meetingRoomName) {
		this.meetingRoomName = meetingRoomName;
	}
	
	public void addMeet(){
		try{
			String sql;
		       Connection conn = new DBConnection("MEET","huanongying","123456").getConn();
		       Statement stmt = conn.createStatement();
				
		       String sbjt = tfSubject.getText();
				String am = tfAim.getText();
				int ognzID = Integer.parseInt(tfOrganizerID.getText());
				int ppn = Integer.parseInt(tfPrePersonNum.getText());
				String mrName = tfMeetingRoomName.getText();
		       sql = "insert into meet(subject,aim,organizerID,meetingRoomName) values(";
		       sql = sql+"'"+sbjt+"',"+"'"+am+"',"+ognzID+"',"+"'"+mrName+"')";
		}catch(SQLException ex){
			System.out.println("添加会议时出错！");
			ex.printStackTrace();
		}
	}


	public void actionPerformed(ActionEvent e) {			
		if(e.getActionCommand().equals("提交")){
			
			new Meet().addMeet();			
		}		
	}
}