import?java.awt.Font;
import?java.awt.event.ActionEvent;
import?java.awt.event.ActionListener;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.Statement;

import?javax.swing.ImageIcon;
import?javax.swing.JButton;
import?javax.swing.Jframe;
import?javax.swing.JLabel;
import?javax.swing.JOptionPane;
import?javax.swing.JPanel;
import?javax.swing.JTextField;

import?com.mysql.jdbc.Connection;


public?class?Date_Write?extends?Jframe?implements?ActionListener{
	JLabel?titleL?=?new?JLabel（“乘機(jī)人信息登記“）;
	JLabel?nameL?=?new?JLabel（“姓名“）;
	JLabel?phoneNumberL?=?new?JLabel（“手機(jī)號碼“）;
	JLabel?idL?=?new?JLabel（“身份證號“）;
	JLabel?mailL?=?new?JLabel（“電子郵箱“）;
	JTextField?nameT?=?new?JTextField（20）;
	JTextField?phoneNumberT?=?new?JTextField（20）;
	JTextField?idT?=?new?JTextField（20）;
	JTextField?mailT?=?new?JTextField（20）;
	JPanel?panel?=?new?JPanel（）;
	JPanel?titleP?=?new?JPanel（）;
	JPanel?nameP?=?new?JPanel（）;
	JPanel?phoneNumberP?=?new?JPanel（）;
	JPanel?idP?=?new?JPanel（）;
	JPanel?mailP?=?new?JPanel（）;
	JPanel?submitP?=?new?JPanel（）;
	JButton?submit?=?new?JButton（new?ImageIcon（“images/submit.jpg“））;
	JButton?cancel?=?new?JButton（new?ImageIcon（“images/cancel.jpg“））;
	Select?select;
	
	public?Date_Write（）?{
		this.settitle（“乘機(jī)人信息登記“）;
		this.setVisible（true）;
		this.setResizable（false）;
		this.setSize（340?400）;
		getContentPane（）.add（panel）;
		panel.add（titleP）;
		panel.add（nameP）;
		panel.add（phoneNumberP）;
		panel.add（idP）;
		panel.add（mailP）;
		panel.add（submitP）;
		titleP.add（titleL）;
		nameP.add（nameL）;
		nameP.add（nameT）;
		phoneNumberP.add（phoneNumberL）;
		phoneNumberP.add（phoneNumberT）;
		idP.add（idL）;
		idP.add（idT）;
		mailP.add（mailL）;
		mailP.add（mailT）;
		submitP.add（submit）;
		submitP.add（cancel）;
		titleL.setFont（new?Font（“楷體“?Font.BOLD?30））;
		nameL.setFont（new?Font（“楷體“?Font.BOLD?20））;
		phoneNumberL.setFont（new?Font（“楷體“?Font.BOLD?20））;
		idL.setFont（new?Font（“楷體“?Font.BOLD?20））;
		mailL.setFont（new?Font（“楷體“?Font.BOLD?20））;
		submit.addActionListener（this）;
		cancel.addActionListener（this）;
	}
	
	public?void?actionPerformed（ActionEvent?e）?{
		if（e.getSource（）==cancel）?{
			setVisible（false）;
		}
		if（e.getSource（）==submit）?{
			
			String?name?=?nameT.getText（）;
			String?phoneNumber?=?phoneNumberT.getText（）;
			String?id?=?idT.getText（）;
			String?mail?=?mailT.getText（）;
			String?sql?=?“select?*?from?passenger_information“;
			try?{
				Class.forName（“com.mysql.jdbc.Driver“）;
				Connection?connection?=?（Connection）?DriverManager.getConnection（“jdbc:mysql://localhost:3306/plane_manager_system“?“root“?““）;
				Statement?stm?=?connection.createStatement（）;	
				ResultSet?rs?=?stm.executeQuery（sql）;???		
				
//				String?sqll?=?“insert?into?passenger_information（name?phone_number?id?E_mail）?values（‘“+name+“‘?‘“+phoneNumber+“‘?‘“+id+“‘‘“+?mail+“‘）“;
//				int?i?=?stm.executeUpdate（sql

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2016-06-16?09:30??機(jī)票管理系統(tǒng)\
?????目錄???????????0??2016-06-08?10:12??機(jī)票管理系統(tǒng)\Plane_manager_system\
?????文件?????????426??2014-05-29?11:18??機(jī)票管理系統(tǒng)\Plane_manager_system\.classpath
?????文件?????????396??2014-05-26?18:20??機(jī)票管理系統(tǒng)\Plane_manager_system\.project
?????目錄???????????0??2016-06-08?10:12??機(jī)票管理系統(tǒng)\Plane_manager_system\.settings\
?????文件?????????598??2014-05-26?18:20??機(jī)票管理系統(tǒng)\Plane_manager_system\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2016-06-08?10:12??機(jī)票管理系統(tǒng)\Plane_manager_system\bin\
?????文件????????4896??2014-05-30?07:57??機(jī)票管理系統(tǒng)\Plane_manager_system\bin\Date_Write.class
?????文件?????????788??2014-05-30?08:03??機(jī)票管理系統(tǒng)\Plane_manager_system\bin\FigurePanel.class
?????文件????????5162??2014-05-30?08:01??機(jī)票管理系統(tǒng)\Plane_manager_system\bin\Inquire.class
?????文件?????????653??2014-05-30?08:41??機(jī)票管理系統(tǒng)\Plane_manager_system\bin\Select$1.class
?????文件?????????588??2014-05-30?08:41??機(jī)票管理系統(tǒng)\Plane_manager_system\bin\Select$2.class
?????文件?????????709??2014-05-30?08:41??機(jī)票管理系統(tǒng)\Plane_manager_system\bin\Select$3.class
?????文件????????8442??2014-05-30?08:41??機(jī)票管理系統(tǒng)\Plane_manager_system\bin\Select.class
?????目錄???????????0??2016-06-08?10:12??機(jī)票管理系統(tǒng)\Plane_manager_system\images\
?????文件????????3533??2014-05-28?12:02??機(jī)票管理系統(tǒng)\Plane_manager_system\images\cancel.jpg
?????文件???????19762??2014-05-28?11:11??機(jī)票管理系統(tǒng)\Plane_manager_system\images\forgin.jpg
?????文件???????15683??2014-05-28?11:13??機(jī)票管理系統(tǒng)\Plane_manager_system\images\inland.jpg
?????文件????????2783??2014-05-28?10:45??機(jī)票管理系統(tǒng)\Plane_manager_system\images\schedule.jpg
?????文件????????6490??2014-05-26?21:32??機(jī)票管理系統(tǒng)\Plane_manager_system\images\search.jpg
?????文件????????2576??2014-05-28?12:02??機(jī)票管理系統(tǒng)\Plane_manager_system\images\submit.jpg
?????文件????????2437??2014-05-28?10:47??機(jī)票管理系統(tǒng)\Plane_manager_system\images\update.jpg
?????目錄???????????0??2016-06-08?10:12??機(jī)票管理系統(tǒng)\Plane_manager_system\src\
?????文件????????3796??2014-05-30?07:57??機(jī)票管理系統(tǒng)\Plane_manager_system\src\Date_Write.java
?????文件?????????511??2014-05-30?08:03??機(jī)票管理系統(tǒng)\Plane_manager_system\src\FigurePanel.java
?????文件????????4800??2014-05-30?05:23??機(jī)票管理系統(tǒng)\Plane_manager_system\src\Inquire.java
?????文件????????8580??2014-05-30?08:41??機(jī)票管理系統(tǒng)\Plane_manager_system\src\Select.java
?????文件????????2743??2014-05-30?09:46??機(jī)票管理系統(tǒng)\plane_manager_system4.sql