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ī)號(hào)碼“）;
	JLabel?idL?=?new?JLabel（“身份證號(hào)“）;
	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

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

????.......???????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

????.......???????598??2014-05-26?18:20??機(jī)票管理系統(tǒng)\Plane_manager_system\.settings\org.eclipse.jdt.core.prefs

????.......??????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

????.......??????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

????.......??????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

?????目錄??????????0??2016-06-08?10:12??機(jī)票管理系統(tǒng)\Plane_manager_system\.settings

?????目錄??????????0??2016-06-08?10:12??機(jī)票管理系統(tǒng)\Plane_manager_system\bin

?????目錄??????????0??2016-06-08?10:12??機(jī)票管理系統(tǒng)\Plane_manager_system\images

?????目錄??????????0??2016-06-08?10:12??機(jī)票管理系統(tǒng)\Plane_manager_system\src

?????目錄??????????0??2016-06-08?10:12??機(jī)票管理系統(tǒng)\Plane_manager_system

?????目錄??????????0??2016-06-16?09:30??機(jī)票管理系統(tǒng)

-----------?---------??----------?-----??----

????????????????96352????????????????????28

............此處省略1個(gè)文件信息