recordpanel.java

飞机订票系统（含界面

package AirT;

import java.awt.Button;
//import java.awt.Container;
import java.awt.Dialog;
import java.awt.FlowLayout;
import java.awt.GridLayout;
import java.awt.Label;
import java.awt.TextField;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
//import java.awt.event.WindowAdapter;
//import java.awt.event.WindowEvent;
import java.sql.DriverManager;
//import java.awt.evnet.*;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JPasswordField;
import javax.swing.JTextField;

class RecordPanel extends JPanel implements ActionListener{
	/**
	 * 
	 */
	private static final long serialVersionUID = -6688410723795531515L;
	JFrame jf = new JFrame(); 
	Label label = new Label("Please input ID and PW");
	TextField tfName = new TextField("");
	JPasswordField tfPassword = new JPasswordField("");
	Button button = new Button("Login");
	Dialog dlg = new Dialog(jf,"Dialog Title", true);
	
	FlowLayout fl = new FlowLayout();
	
	JLabel lb1 = new JLabel("所属公司："),
		lb2 = new JLabel("航班代号:"),
		lb3 = new JLabel("航班日期:"),
		lb4 = new JLabel("起飞时间:"),
		lb5 = new JLabel("抵达时间:"),
		lb6 = new JLabel("起飞城市:"),
		lb7 = new JLabel("抵达城市:"),
		lb8 = new JLabel("飞机票价:"),
		lb9 = new JLabel("票价折扣:"),
		lb10 = new JLabel("机票数量:"),
		lb11 = new JLabel("是否满员:");
	
	JLabel img1,img2,img3,img4,img5,img6,img7,img8;
	
	JTextField tf1 = new JTextField(8),
		tf2 = new JTextField(8),
		tf3 = new JTextField(8),
		tf4 = new JTextField(8),
		tf5 = new JTextField(8),
		tf6 = new JTextField(8),
		tf7 = new JTextField(8),
		tf8 = new JTextField(8),
		tf9 = new JTextField(8),
		tf10 = new JTextField(8),
		tf11 = new JTextField(8);
		
	JButton bt = new JButton("录入");
	JFrame f = new JFrame("TextDialog");
	TextField tf = new TextField(10);
	public String stm;

	public RecordPanel() {
		JPanel pn1 = new JPanel(),
			pn2 = new JPanel(),
			pn3 = new JPanel();
		ImageIcon ty = new ImageIcon("img\\b777.gif"),
			i1 = new ImageIcon("img\\1.gif"),
			i2 = new ImageIcon("img\\2.gif"),
			i3 = new ImageIcon("img\\3.gif"),
			i4 = new ImageIcon("img\\4.gif"),
			i5 = new ImageIcon("img\\5.gif"),
			i6 = new ImageIcon("img\\6.gif");
		//img1 = new JLabel(ss);
		img2 = new JLabel(ty);
		img3 = new JLabel(i1);
		img4 = new JLabel(i2);
		img5 = new JLabel(i3);
		img6 = new JLabel(i4);
		img7 = new JLabel(i5);
		img8 = new JLabel(i6);
		pn1.setLayout(new GridLayout(12,2));
		pn1.add(lb1);
		pn1.add(tf1);
		pn1.add(lb2);
		pn1.add(tf2);
		pn1.add(lb3);
		pn1.add(tf3);
		pn1.add(lb4);
		pn1.add(tf4);
		pn1.add(lb5);
		pn1.add(tf5);
		pn1.add(lb6);
		pn1.add(tf6);
		pn1.add(lb7);
		pn1.add(tf7);
		pn1.add(lb8);
		pn1.add(tf8);
		pn1.add(lb9);
		pn1.add(tf9);
		pn1.add(lb10);
		pn1.add(tf10);
		pn1.add(lb11);
		pn1.add(tf11);
		pn1.add(bt);
		add(pn1,"West");
		pn2.add(img2);
		add(pn2,"East");
		pn3.add(img3);
		pn3.add(img4);
		pn3.add(img5);
		pn3.add(img6);
		pn3.add(img7);
		pn3.add(img8);
		add(pn3,"South");
		bt.addActionListener(this);
	}
	
	public void actionPerformed(ActionEvent e)
	{ 
		jf.setTitle("Login Check");
		jf.getContentPane().setLayout(new GridLayout(4,1));
		jf.getContentPane().add(label);
		jf.getContentPane().add(tfName);
		jf.getContentPane().add(tfPassword);
		jf.getContentPane().add(button);
		jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		jf.setSize(300, 200);
		jf.setLocation(200, 300);
		jf.setVisible(true);
		button.addActionListener(new ActionListener(){

			public void actionPerformed(ActionEvent arg0) {
				// TODO 自动生成方法存根
				Button b1 = new Button("确定"); 
				Label lbs = new Label();
				try
				{
					Class.forName("org.gjt.mm.mysql.Driver");
					java.sql.Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/test",
							"root","123");
					java.sql.Statement stmt = conn.createStatement();
					String sql = "select * from wzl where username = '" + tfName.getText() + "'";
					sql += "and password = '" + tfPassword + "'";
					java.sql.ResultSet rs = stmt.executeQuery( sql );
					if (rs.next())
					{
						label.setText("legality user");
						String sd = getStatement();
						Stat(sd);
						jf.dispose();
					}
					else
					{
						label.setText("lowless uesr");
						lbs.setText("对不起，您没有使用权限！");
						dlg.setModal(false);
						dlg.setBounds(0,0,200,150);
						dlg.setVisible(true);
						dlg.setLayout(fl);
						dlg.add(lbs,"North");
						dlg.add(b1,"Center");
						b1.addActionListener(new ActionListener(){
							public void actionPerformed(ActionEvent e)
							{
								dlg.dispose();
							}
						});
					}
						
				}
				catch (Exception ee)
				{
					ee.printStackTrace();
				}
			}
			
		});
	}	
	public String getStatement()
	{
		String r1,r2,r3,r4,r5,r6,r7,r8,r9,r10,r11;
		r1 = tf1.getText();
		r2 = tf2.getText();
		r3 = tf3.getText();
		r4 = tf4.getText();
		r5 = tf5.getText();
		r6 = tf6.getText();
		r7 = tf7.getText();
		r8 = tf8.getText();
		r9 = tf9.getText();
		r10 = tf10.getText();
		r11 = tf11.getText();
		stm = "insert into plane(company,sysboml,flydate,uptime,downtime,upcity,downcity,fare,agio,ticketnum,memberful) values ('"+r1+"','"+r2+"','"+r3+"','"+r4+"','"+r5+"','"+r6+"','"+r7+"','"+r8+"','"+r9+"','"+r10+"','"+r11+"')"; 
		return stm;
	}
	public void Stat(String str)
	{
		System.out.println(str);
		try {
			Class.forName("org.gjt.mm.mysql.Driver");
			java.sql.Connection conn1 = DriverManager.getConnection("jdbc:mysql://localhost/airt","root","123");
			java.sql.Statement stmt1 =  conn1.createStatement();
			//java.sql.ResultSet rst = stmt.executeUpdate(sql);
			stmt1.executeUpdate(str);
		} 
		catch (Exception s)
		{
			s.printStackTrace();
		}
	}
}