bookticketjdialog.java

大学课程 数据库的课程设计

/*
 * BookTicketJDialog.java
 *
 * Created on 2007年6月30日, 下午7:22
 */

package t;
import javax.swing.JOptionPane;
import java.io.*;
/**
 *
 * @author  Administrator
 */
public class BookTicketJDialog extends javax.swing.JDialog {
    String s="";
    int n;
    int k=1;
    long x;
    String sh1="";
    /** Creates new form BookTicketJDialog */
    public BookTicketJDialog(java.awt.Frame parent, boolean modal,long x1) {
        super(parent, modal);
        initComponents();
         LoadFrame.setLoc(this);
        x=x1;
        MyConnection mc = new MyConnection();
        mc.itemQuery("航班班次表","航班号");
        String a[]=mc.getItem();
        int n=mc.getItemNumber();
        mc.closeConnection();
        for(int i=0;i<n;i++)
        {
            jComboBox1.addItem(a[i]);
        }
    }
    
    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    // <editor-fold defaultstate="collapsed" desc=" Generated Code ">//GEN-BEGIN:initComponents
    private void initComponents() {
        buttonGroup1 = new javax.swing.ButtonGroup();
        jLabel1 = new javax.swing.JLabel();
        jComboBox1 = new javax.swing.JComboBox();
        jLabel2 = new javax.swing.JLabel();
        jRadioButton1 = new javax.swing.JRadioButton();
        jRadioButton2 = new javax.swing.JRadioButton();
        jButton1 = new javax.swing.JButton();
        jButton2 = new javax.swing.JButton();

        setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
        setTitle("\u8ba2\u7968\u5bf9\u8bdd\u6846");
        jLabel1.setText("\u9009\u62e9\u822a\u73ed");

        jComboBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "\u8bf7\u9009\u62e9" }));
        jComboBox1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jComboBox1ActionPerformed(evt);
            }
        });

        jLabel2.setText("\u9009\u62e9\u673a\u7968\u7c7b\u578b");

        buttonGroup1.add(jRadioButton1);
        jRadioButton1.setSelected(true);
        jRadioButton1.setText("\u7ecf\u6d4e\u8231");
        jRadioButton1.setBorder(javax.swing.BorderFactory.createEmptyBorder(0, 0, 0, 0));
        jRadioButton1.setMargin(new java.awt.Insets(0, 0, 0, 0));
        jRadioButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jRadioButton1ActionPerformed(evt);
            }
        });

        buttonGroup1.add(jRadioButton2);
        jRadioButton2.setText("\u5546\u52a1\u8231");
        jRadioButton2.setBorder(javax.swing.BorderFactory.createEmptyBorder(0, 0, 0, 0));
        jRadioButton2.setMargin(new java.awt.Insets(0, 0, 0, 0));
        jRadioButton2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jRadioButton2ActionPerformed(evt);
            }
        });

        jButton1.setText("\u786e\u5b9a");
        jButton1.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jButton1MouseClicked(evt);
            }
        });

        jButton2.setText("\u53d6\u6d88");
        jButton2.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jButton2MouseClicked(evt);
            }
        });

        org.jdesktop.layout.GroupLayout layout = new org.jdesktop.layout.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(layout.createSequentialGroup()
                .add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(layout.createSequentialGroup()
                        .add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                            .add(layout.createSequentialGroup()
                                .add(42, 42, 42)
                                .add(jLabel1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 71, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                            .add(layout.createSequentialGroup()
                                .add(59, 59, 59)
                                .add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING)
                                    .add(jButton1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 71, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                                    .add(jComboBox1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                                .add(43, 43, 43)
                                .add(jLabel2)))
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                        .add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                            .add(jRadioButton1)
                            .add(jRadioButton2)))
                    .add(layout.createSequentialGroup()
                        .add(211, 211, 211)
                        .add(jButton2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 71, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)))
                .addContainerGap(52, Short.MAX_VALUE))
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(layout.createSequentialGroup()
                .add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(layout.createSequentialGroup()
                        .addContainerGap()
                        .add(jLabel1)
                        .add(15, 15, 15)
                        .add(jComboBox1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                    .add(layout.createSequentialGroup()
                        .add(29, 29, 29)
                        .add(jLabel2))
                    .add(layout.createSequentialGroup()
                        .add(19, 19, 19)
                        .add(jRadioButton1)
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                        .add(jRadioButton2)))
                .add(29, 29, 29)
                .add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jButton2)
                    .add(jButton1))
                .addContainerGap(32, Short.MAX_VALUE))
        );
        pack();
    }// </editor-fold>//GEN-END:initComponents

    public void getIdD(String s)
    {
        sh1=s;
    }
    private void jRadioButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jRadioButton2ActionPerformed
// TODO add your handling code here:
        k=0;
    }//GEN-LAST:event_jRadioButton2ActionPerformed

    private void jRadioButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jRadioButton1ActionPerformed
// TODO add your handling code here:
        k=1;
    }//GEN-LAST:event_jRadioButton1ActionPerformed

    private void jComboBox1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jComboBox1ActionPerformed
// TODO add your handling code here:
         String s11=(String)jComboBox1.getSelectedItem();
         String s1="航班班次表"+" where "+"航班号"+"="+"'"+s11+"'";
         MyConnection mc = new MyConnection();
         mc.itemQuery(s1,"座位空数");
         String a[]=mc.getItem();
         mc.closeConnection();
         n=Integer.parseInt(a[0]);
         if(n<=0)
             JOptionPane.showMessageDialog(this,"该航班已满!","消息对话框",JOptionPane.WARNING_MESSAGE);
    }//GEN-LAST:event_jComboBox1ActionPerformed

    private void jButton1MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jButton1MouseClicked
// TODO add your handling code here:
        String s11=(String)jComboBox1.getSelectedItem();
        int k1,k2,k3;
        k1=1;
        k3=1;
        k2=0;
       // String s1="航班班次表"+" where "+"航班号"+"="+"'"+s11+"'";
        //String s2="座位空数"+"="+n;
        MyConnection mc = new MyConnection();
        //mc.itemQuery(s1,"座位空数");
       // String a[]=mc.getItem();
       // n=Integer.parseInt(a[0]);
        n-=1;
        String s2="座位空数"+"="+n;
        String s3="航班号"+"="+"'"+s11+"'";
        mc.upDate("航班班次表",s2,s3);
        mc.itemQuery("机位信息表","座位号");
        String a[]=mc.getItem();
        int n1=mc.getItemNumber();
        if(k==0)
        {
            for(int i=0;i<n1;i++)
                if(Integer.parseInt(a[i])<=5)
                {
                    k1=0;
                    k2=i+1;
                    break;
                }
        }
        if(k==1)
        {
            for(int j=0;j<n1;j++)
                if(Integer.parseInt(a[j])>5)
                {
                k3=0;
                k2=j+1;
                break;
                }
        }
        if(k1==0||k3==0)
        {
           // mc.upDate()
            String s4="'"+s11+"'"+","+x+","+"'"+"否"+"'"+","+k2;
            mc.insetAirLine("定位信息表",s4);
          //  System.out.println(k1+"  "+k3+"  "+k2);
            String s5="机位信息"+"="+0;
            String s6="班机号"+"="+"'"+s11+"'"+" and "+"座位号"+"="+k2;
            mc.upDate("机位信息表",s5,s6);
        }
        mc.closeConnection();
        dispose();
    }//GEN-LAST:event_jButton1MouseClicked

    private void jButton2MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jButton2MouseClicked
// TODO add your handling code here:
        MyConnection mc = new MyConnection();
        String sh2="旅客身份证"+"="+"'"+sh1+"'";
        mc.deleteInf("旅客资料表",sh2);
        dispose();
    }//GEN-LAST:event_jButton2MouseClicked
    
    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                //new BookTicketJDialog(new javax.swing.JFrame(), true).setVisible(true);
            }
       });
    }
    
    // Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.swing.ButtonGroup buttonGroup1;
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton2;
    private javax.swing.JComboBox jComboBox1;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JRadioButton jRadioButton1;
    private javax.swing.JRadioButton jRadioButton2;
    // End of variables declaration//GEN-END:variables
    
}