retticpanel.java

飞机订票系统（含界面

package AirT;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.DriverManager;

import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JTextField;

import com.mysql.jdbc.ResultSet;

class RetticPanel extends JPanel implements ActionListener{
	
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	JTextField tf1 = new JTextField(5),
		tf2 = new JTextField(5),
		tf3 = new JTextField(5),
		tf4 = new JTextField(5),
		tf5 = new JTextField(8);
	JLabel lb1 = new JLabel("客户姓名:"),
		lb2 = new JLabel("航班号:"),
		lb3 = new JLabel("退票数量:"),
		lb5 = new JLabel("您的反还金额为:"),
		lb6 = new JLabel("身份证号:");
	JLabel lb4;
	JButton bt = new JButton("退票");
	//Image bg;
	
	public RetticPanel()
	{
		ImageIcon bg = new ImageIcon("img\\767.gif");
		lb4 = new JLabel(bg);
		JPanel pn = new JPanel();
		add(lb1);
		add(tf1);
		add(lb2);
		add(tf2);
		add(lb3);
		add(tf3);
		add(lb6);
		add(tf5);
		add(lb4);
		pn.add(bt);
		pn.add(lb5);
		pn.add(tf4);
		add(pn,"South");
		bt.addActionListener(this);
	}

	public void actionPerformed(ActionEvent arg0) {
		// TODO 自动生成方法存根
		try
		{
			Class.forName("org.gjt.mm.mysql.Driver");
			java.sql.Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/airt",
					"root","123");
			java.sql.Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
			String sql = "delete from ticper where name='"+tf1.getText()+"'";//,and ipcode='"+tf2.getText()+"'";
			stmt.executeUpdate(sql);
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
	}
}