import?java.awt.EventQueue;

import?javax.swing.JDialog;
import?javax.swing.JComboBox;
import?javax.swing.JLabel;
import?javax.swing.JOptionPane;
import?javax.swing.JTextField;
import?javax.swing.JTextArea;
import?javax.swing.JScrollPane;
import?java.awt.event.ItemListener;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.awt.event.ItemEvent;
import?javax.swing.JButton;
import?java.awt.event.ActionListener;
import?java.awt.event.ActionEvent;

//預(yù)約掛號(hào)對(duì)話框類
public?class?AppointDialog?extends?JDialog?{

	JComboBox?comboBoxcomboBox_1;//科室列表框??科室醫(yī)生列表框
	JTextArea?textArea;?//掛號(hào)內(nèi)容
	String?id;??//用戶id
	/**
	?*?Create?the?dialog.
	?*/
	public?AppointDialog（）?{//初始化對(duì)話框
		settitle（“新增掛號(hào)“）;
		setBounds（100?100?747?448）;
		getContentPane（）.setLayout（null）;
		
		comboBox?=?new?JComboBox（）;
		comboBox.addItemListener（new?ItemListener（）?{
			public?void?itemStateChanged（ItemEvent?arg0）?{//響應(yīng)科室列表選擇，把對(duì)應(yīng)的醫(yī)生id加入到醫(yī)生列表框
				String?str1=（String）comboBox.getSelectedItem（）;
				if（str1==null）
					return;
				comboBox_1.removeAllItems（）;
				try{
					Statement?stmt?=?DbOp.connection.createStatement（）;
					ResultSet?rs=stmt.executeQuery（“select?*?from?users?where?roll=‘doctor‘?and?department=‘“+str1+“‘“）;
					if（rs!=null）?{
						while（rs.next（））
							comboBox_1.addItem（rs.getString（1））;							
						rs.close（）;
						stmt.close（）;
					}
				}?catch?（SQLException?ex）?{
					ex.printStackTrace（）;
				}
			}
		}）;
		comboBox.setBounds（146?56?194?21）;
		getContentPane（）.add（comboBox）;
		
		comboBox_1?=?new?JComboBox（）;
		comboBox_1.setBounds（447?56?200?21）;
		getContentPane（）.add（comboBox_1）;
		
		JLabel?lblNewLabel?=?new?JLabel（“科室“）;
		lblNewLabel.setBounds（89?59?47?15）;
		getContentPane（）.add（lblNewLabel）;
		
		JLabel?label?=?new?JLabel（“醫(yī)生“）;
		label.setBounds（385?59?60?15）;
		getContentPane（）.add（label）;
		
		JScrollPane?scrollPane?=?new?JScrollPane（）;
		scrollPane.setBounds（89?141?558?176）;
		getContentPane（）.add（scrollPane）;
		
		textArea?=?new?JTextArea（）;
		scrollPane.setViewportView（textArea）;
		textArea.setLineWrap（true）;
		
		JLabel?label_1?=?new?JLabel（“掛號(hào)內(nèi)容“）;
		label_1.setBounds（89?101?110?15）;
		getContentPane（）.add（label_1）;
		
		JButton?btnNewButton?=?new?JButton（“確定“）;
		btnNewButton.addActionListener（new?ActionListener（）?{
			public?void?actionPerformed（ActionEvent?e）?{//響應(yīng)掛號(hào)按鈕，將掛號(hào)信息保存到數(shù)據(jù)庫(kù)
				//String?str1=（String）comboBox.getSelectedItem（）;
				String?str2=（String）comboBox_1.getSelectedItem（）;
				String?str1=textArea.getText（）;
				if（str1==null||str2==null）
					return;
				String?sql=String.format（“insert?into?appointment（PatientIdDoctorIdAppointContentAppointTime）values（‘%s‘‘%s‘‘%s‘now（））“idstr2str1）;
				System.out.println（sql）;
				int?rows=0;
				try{
					java.sql.Statement?stmt?=?DbOp.connection.createStatement（）;
					rows=stmt.executeUpdate（sql）;
					stmt.close（）;					

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件????????3849??2018-01-02?21:22??hospital.sql
?????目錄???????????0??2018-01-02?11:45??HospitalApp\
?????文件?????????404??2018-01-02?11:42??HospitalApp\.classpath
?????文件?????????387??2018-01-02?11:24??HospitalApp\.project
?????目錄???????????0??2018-01-02?11:24??HospitalApp\.settings\
?????文件?????????598??2018-01-02?11:24??HospitalApp\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2018-01-02?17:40??HospitalApp\bin\
?????文件????????1927??2018-01-02?20:38??HospitalApp\bin\AppointDialog$1.class
?????文件????????2192??2018-01-02?20:38??HospitalApp\bin\AppointDialog$2.class
?????文件?????????643??2018-01-02?20:38??HospitalApp\bin\AppointDialog$3.class
?????文件????????2108??2018-01-02?20:38??HospitalApp\bin\AppointDialog.class
?????文件?????????764??2018-01-02?20:41??HospitalApp\bin\AppointMgrDialog$1.class
?????文件????????2138??2018-01-02?20:41??HospitalApp\bin\AppointMgrDialog$2.class
?????文件????????1977??2018-01-02?20:41??HospitalApp\bin\AppointMgrDialog$3.class
?????文件????????2247??2018-01-02?20:41??HospitalApp\bin\AppointMgrDialog.class
?????文件????????2550??2018-01-02?20:44??HospitalApp\bin\AuthDialog$1.class
?????文件?????????725??2018-01-02?20:44??HospitalApp\bin\AuthDialog$2.class
?????文件????????2028??2018-01-02?20:44??HospitalApp\bin\AuthDialog.class
?????文件????????2585??2018-01-02?20:45??HospitalApp\bin\DbOp.class
?????文件?????????740??2018-01-02?20:48??HospitalApp\bin\DepartDialog$1.class
?????文件????????1092??2018-01-02?20:48??HospitalApp\bin\DepartDialog$2.class
?????文件????????1752??2018-01-02?20:48??HospitalApp\bin\DepartDialog$3.class
?????文件????????1936??2018-01-02?20:48??HospitalApp\bin\DepartDialog$4.class
?????文件????????2412??2018-01-02?20:48??HospitalApp\bin\DepartDialog.class
?????文件????????1942??2018-01-02?20:50??HospitalApp\bin\DepartDlg$1.class
?????文件?????????619??2018-01-02?20:50??HospitalApp\bin\DepartDlg$2.class
?????文件????????1592??2018-01-02?20:50??HospitalApp\bin\DepartDlg.class
?????文件?????????740??2018-01-03?09:33??HospitalApp\bin\DoctorDialog$1.class
?????文件????????1838??2018-01-03?09:33??HospitalApp\bin\DoctorDialog$2.class
?????文件?????????637??2018-01-03?09:33??HospitalApp\bin\DoctorDialog$3.class
?????文件????????1914??2018-01-03?09:33??HospitalApp\bin\DoctorDialog.class
............此處省略29個(gè)文件信息