dropflight.java

航空航天订票系统 是数据库的课程设计 单机版

package GraphicsUI;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import java.util.Vector;

public class DropFlight extends SelectFlight implements ActionListener {

	JButton btn;

	Connection conn;

	Statement stmt;

	int c;

	public DropFlight(MainFrame m) {
		super(m);
		super.jif.setTitle("删除航线");
		btn = new JButton("删除选中航线");
		super.p.add(btn);
		btn.addActionListener(this);
	}

	public void actionPerformed(ActionEvent e) {
		if (e.getSource() == btn) {
			Object t1, t2;
			int t = super.jt.getSelectedRow();
			System.out.println("t=" + t);
			t1 = super.jt.getValueAt(t, 0);
			t2 = super.jt.getValueAt(t, 8);
			System.out.println("t1=" + t1);
			System.out.println("t2=" + t2);
			try {
				// int t = 0;
				conn = DriverManager.getConnection(
						"jdbc:microsoft:sqlserver://localhost:1433", "sa", "");
				stmt = conn.createStatement();
				c = stmt.executeUpdate("delete from flights where flyno='"
						+ t1.toString().trim() + "'" + "and flycycle='"
						+ t2.toString().trim() + "';");
				JOptionPane.showMessageDialog(null, "删除成功影响" + c + "行", "信息",
						JOptionPane.INFORMATION_MESSAGE);
				super.id.remove(t1);
				super.jcb.repaint();//好像没有用
				super.jcb.updateUI();
			} catch (SQLException e1) {
				// TODO 自动生成 catch 块
				e1.printStackTrace();
			}
		} else
			super.actionPerformed(e);/* 继承后重写了actionPerformed,
			但其他两个方法仍然喜欢交给父类的事件响应方法处理，强行调用*/
	}
}