addflight.java

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

package GraphicsUI;

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

public class AddFlight implements ActionListener {
	JInternalFrame jif;

	JLabel lab1;

	JLabel lab2;

	JLabel lab3;

	JLabel lab4;

	JLabel lab5;

	JLabel lab6;

	JLabel lab7;

	JLabel lab8;

	JLabel lab9;

	JTextField fil1;

	JTextField fil2;

	JTextField fil3;

	JTextField fil4;

	JTextField fil5;

	JTextField fil6;

	JTextField fil7;

	JTextField fil8;

	JTextField fil9;

	JButton btn;

	JButton clear;

	JPanel pan1;

	JPanel pan2;

	JPanel pan3;

	JPanel pan4;

	JPanel pan5;

	JPanel pan6;

	JPanel pan7;

	JPanel pan8;

	JPanel pan9;

	JPanel pan10;

	JPanel anniu;

	JLabel lab10;

	JTextField fil10;

	JPanel big;

	JPanel center;

	MainFrame mf;

	Connection conn;

	Statement stmt;

	public AddFlight(MainFrame m) {
		mf = m;
		jif = new JInternalFrame("新增航线", false, true, false, true);
		lab1 = new JLabel("航班号码:");
		fil1 = new JTextField(10);
		lab2 = new JLabel("目的机场:");
		fil2 = new JTextField(10);
		lab3 = new JLabel("出发机场:");
		fil3 = new JTextField(10);
		lab4 = new JLabel("出发日期:");
		fil4 = new JTextField(10);
		lab5 = new JLabel("抵达日期:");
		fil5 = new JTextField(10);
		lab6 = new JLabel("航空公司:");
		lab7 = new JLabel("飞机型号:");
		lab8 = new JLabel("飞行周期:");
		lab9 = new JLabel("是否中转:");
		lab10 = new JLabel("航线路径:");
		fil10 = new JTextField(10);
		fil6 = new JTextField(10);
		fil7 = new JTextField(10);
		fil8 = new JTextField(10);
		fil9 = new JTextField(10);
		btn = new JButton("增加");
		btn.addActionListener(this);
		clear = new JButton("清空");
		clear.addActionListener(this);
		pan1 = new JPanel();
		pan2 = new JPanel();
		pan3 = new JPanel();
		pan4 = new JPanel();
		pan5 = new JPanel();
		pan6 = new JPanel();
		pan7 = new JPanel();
		pan8 = new JPanel();
		pan9 = new JPanel();
		pan10 = new JPanel();
		anniu = new JPanel();
		anniu.add(btn);
		anniu.add(clear);
		big = new JPanel();
		big.setLayout(new GridLayout(10, 1));
		pan1.add(lab1);
		pan1.add(fil1);
		pan2.add(lab2);
		pan2.add(fil2);
		pan3.add(lab3);
		pan3.add(fil3);
		pan4.add(lab4);
		pan4.add(fil4);
		pan5.add(lab5);
		pan5.add(fil5);
		pan6.add(lab6);
		pan6.add(fil6);
		pan7.add(lab7);
		pan7.add(fil7);
		pan8.add(lab8);
		pan8.add(fil8);
		pan9.add(lab9);
		pan9.add(fil9);
		pan10.add(lab10);
		pan10.add(fil10);
		anniu.add(btn);
		anniu.add(clear);
		big.add(pan1);
		big.add(pan2);
		big.add(pan3);
		big.add(pan4);
		big.add(pan5);
		big.add(pan6);
		big.add(pan7);
		big.add(pan8);
		big.add(pan9);
		big.add(pan10);
		jif.add(big, BorderLayout.CENTER);
		jif.add(anniu, BorderLayout.SOUTH);
		jif.setVisible(true);
	}

	public void actionPerformed(ActionEvent e) {
		if (e.getSource() == clear) {
			fil1.setText(null);
			fil2.setText(null);
			fil3.setText(null);
			fil4.setText(null);
			fil5.setText(null);
			fil6.setText(null);
			fil7.setText(null);
			fil8.setText(null);
			fil9.setText(null);
			fil10.setText(null);
		}
		if (e.getSource() == btn) {
			try {
				System.out.println("OK");
				// int t = 0;
				conn = DriverManager.getConnection(
						"jdbc:microsoft:sqlserver://localhost:1433", "sa", "");
				stmt = conn.createStatement();
				int rs = stmt.executeUpdate("insert into flights values ('"
						+ fil1.getText() + "','" + fil3.getText() + "','"
						+ fil2.getText() + "','" + fil4.getText() + "','"
						+ fil5.getText() + "','" + fil6.getText() + "','"
						+ fil7.getText() + "','" + fil9.getText() + "','"
						+ fil8.getText() + "','" + fil10.getText() + "')");
				JOptionPane.showMessageDialog(null, "添加成功", "提示",
						JOptionPane.INFORMATION_MESSAGE);
				conn.close();
			} catch (SQLException e1) {
				// TODO 自动生成 catch 块
				e1.printStackTrace();
			}
		}
	}
}