package?maintable;

import?java.awt.BorderLayout;
import?java.awt.FlowLayout;
import?java.awt.GridLayout;
import?java.awt.Image;
import?java.awt.Label;
import?java.awt.Toolkit;
import?java.awt.event.ActionEvent;
import?java.awt.event.ActionListener;
import?java.beans.PropertyVetoException;
import?java.sql.Connection;



import?java.sql.ResultSet;
import?java.sql.Statement;

import?javax.swing.JButton;
import?javax.swing.JDialog;
import?javax.swing.Jframe;
import?javax.swing.JInternalframe;
import?javax.swing.JLabel;
import?javax.swing.JPanel;
import?javax.swing.JScrollPane;
import?javax.swing.JTable;
import?javax.swing.JTextField;
import?javax.swing.table.TableColumn;

@SuppressWarnings（{?“serial“?“unused“?}）
public?class?Apparatus?extends?JInternalframe?implements?ActionListener{
	
	private?final?JPanel?topSearch?=?new?JPanel（）;
	private?final?JTextField?id?=?new?JTextField（20）;
	private?final?JTextField?name?=?new?JTextField（20）;
	private?final?JButton?search?=?new?JButton（“檢索“）;
	private?final?JButton?modify?=?new?JButton（“更新“）;
	private?final?JButton?delete?=?new?JButton（“刪除“）;
	private?final?JButton?insert?=?new?JButton（“插入“）;
	private?JScrollPane?jspanel=?null;
	private?final?Connection?con?=?ConnectToDatabase.getConnection（）;
	//private?final?JButton?flash?=?new?JButton（“刷新“）;
	
	public?final?String[]?columnNames?=?{“儀器代號“?“儀器名稱“?“儀器價格“?“儀器數(shù)量“?“儀器備注“};
	public?Apparatus（）?{
		super（“儀器信息管理“?true?true?true?true）;
		setSize（1115?700）;
		setLayout（new?BorderLayout（））;
	
		
		topSearch.add（new?JLabel（“儀器代號“））;
		topSearch.add（id）;
		topSearch.add（new?JLabel（“儀器名稱“））;
		topSearch.add（name）;
		//topSearch.add（new?JLabel（“????????“））;
		topSearch.add（search）;
		topSearch.add（modify）;
		topSearch.add（insert）;
		topSearch.add（delete）;
		
		search.addActionListener（this）;
		modify.addActionListener（this）;
		insert.addActionListener（this）;
		delete.addActionListener（this）;
		
	
		add（topSearch?BorderLayout.NORTH）;
		setVisible（true）;
	}
	@Override
	public?void?actionPerformed（ActionEvent?e）?{
		//?TODO?Auto-generated?method?stub
		
		try{
			if（e.getSource（）?==?search）{
				doSearch（）;
			}else?if（e.getSource（）?==?modify）{
				doModify（）;
			}else?if（e.getSource（）?==?insert）{
				doInsert（）;
			}else?if（e.getSource（）?==?delete）{
				doDelete（）;
			}
		}catch（Exception?ec）{
			ec.printStackTrace（）;
		}
	}
	
	public?void?doSearch（）throws?Exception{
		Statement?state?=?con.createStatement（）;
		ResultSet?result;
		if（id.getText（）.length（）?==?0?&&?name.getText（）.length（）?==?0）{
			result?=?state.executeQuery（“SELECT?*?FROM?APPARATUS“）;
		}else?if（id.getText（）.length（）?!=?0）{
			result?=?state.executeQuery（“SELECT?*?FROM?APPARATUS?WHERE?APPARTUS_ID?=?‘“+
					id.getText（）+“‘“）;
		}else{
			result?=?state.executeQuery（“SELECT?*?FROM?APPARATUS?WHERE?APPARTUS_NAME?LIKE?‘“?+?
					“%“?+name.getText（）+?“%‘“）;
		}
		
		
		//GetTable（）返回一個JScrollPane對象

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????430??2018-06-12?10:11??Hospital\.classpath

?????文件????????384??2018-06-11?09:07??Hospital\.project

?????文件?????????99??2018-06-18?12:59??Hospital\.settings\org.eclipse.core.resources.prefs

?????文件????????598??2018-06-11?09:07??Hospital\.settings\org.eclipse.jdt.core.prefs

?????文件??????14729??2018-06-11?09:46??Hospital\back2.jpg

?????文件??????52254??2018-06-15?11:23??Hospital\back3.jpg

?????文件??????36009??2018-06-19?12:48??Hospital\back4.jpg

?????文件??????37903??2018-06-15?17:01??Hospital\back41.jpg

?????文件??????19721??2018-06-20?14:37??Hospital\back5.jpg

?????文件??????28039??2018-06-11?09:23??Hospital\background.jpg

?????文件???????2176??2018-06-21?08:25??Hospital\bin\maintable\Apparatus$1$1.class

?????文件???????3175??2018-06-21?08:25??Hospital\bin\maintable\Apparatus$1.class

?????文件???????1734??2018-06-21?08:25??Hospital\bin\maintable\Apparatus$2.class

?????文件???????1611??2018-06-21?08:25??Hospital\bin\maintable\Apparatus$3.class

?????文件???????5608??2018-06-21?08:25??Hospital\bin\maintable\Apparatus.class

?????文件???????2247??2018-06-21?13:28??Hospital\bin\maintable\Bed$1.class

?????文件???????2394??2018-06-21?13:28??Hospital\bin\maintable\Bed$2.class

?????文件???????9227??2018-06-21?13:28??Hospital\bin\maintable\Bed.class

?????文件???????3141??2018-06-20?15:47??Hospital\bin\maintable\BroswePersonnel$1.class

?????文件???????3739??2018-06-20?15:47??Hospital\bin\maintable\BroswePersonnel$2.class

?????文件??????12235??2018-06-20?15:47??Hospital\bin\maintable\BroswePersonnel.class

?????文件???????1416??2018-06-19?14:37??Hospital\bin\maintable\ConnectToDatabase.class

?????文件???????1395??2018-06-20?10:25??Hospital\bin\maintable\DateSelect.class

?????文件???????1645??2018-06-21?08:22??Hospital\bin\maintable\Department$1.class

?????文件???????2791??2018-06-21?08:22??Hospital\bin\maintable\Department$1Listener$1.class

?????文件???????4603??2018-06-21?08:22??Hospital\bin\maintable\Department$1Listener.class

?????文件???????5244??2018-06-21?08:22??Hospital\bin\maintable\Department.class

?????文件???????1915??2018-06-19?08:37??Hospital\bin\maintable\Drug$1.class

?????文件???????2073??2018-06-19?08:37??Hospital\bin\maintable\Drug$2.class

?????文件???????6252??2018-06-19?08:37??Hospital\bin\maintable\Drug.class

............此處省略89個文件信息