bookticket.java

车票预定系统用 java实现的……

/*
 * bookticket.java
 *
 * Created on 2008年6月18日, 下午4:28
 */

package javaapplication1;
import java.awt.event.WindowEvent;
import javax.swing.*;
import java.awt.*;
import java.sql.*;
import javax.swing.table.DefaultTableModel;

/**
 *
 * @author  Administrator
 */
public class bookticket extends javax.swing.JFrame {
     Connection con;//创建对象
        Statement sql;
         ResultSet rs;   
    
    /** Creates new form bookticket */
    public bookticket() {
         setTitle("车票预订");
        setBounds(300,50,40,20);
        setResizable(false);
        initComponents();
    }
    
    /** 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=" 生成的代码 ">//GEN-BEGIN:initComponents
    private void initComponents() {
        jPanel1 = new javax.swing.JPanel();
        jButton4 = new javax.swing.JButton();
        jButton3 = new javax.swing.JButton();
        jButton2 = new javax.swing.JButton();
        jScrollPane1 = new javax.swing.JScrollPane();
        jTable1 = new javax.swing.JTable();
        jLabel1 = new javax.swing.JLabel();

        setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
        jPanel1.setBackground(new java.awt.Color(255, 204, 255));
        jButton4.setBackground(new java.awt.Color(204, 255, 204));
        jButton4.setText("\u9000\u56de\u8bf7\u6c42");
        jButton4.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton4ActionPerformed(evt);
            }
        });

        jButton3.setBackground(new java.awt.Color(204, 255, 204));
        jButton3.setText("\u9884\u5b9a\u8f66\u7968");
        jButton3.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton3ActionPerformed(evt);
            }
        });

        jButton2.setBackground(new java.awt.Color(204, 255, 204));
        jButton2.setText("\u663e\u793a\u8ba2\u7968\u7528\u6237");
        jButton2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton2ActionPerformed(evt);
            }
        });

        jTable1.setBackground(new java.awt.Color(255, 204, 153));
        jTable1.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null}
            },
            new String [] {
                "姓名", "性别", "身份证", "出发地", "目的地", "旅行时间", "车型要求", "是否订票"
            }
        ) {
            boolean[] canEdit = new boolean [] {
                false, false, false, false, false, false, false, false
            };

            public boolean isCellEditable(int rowIndex, int columnIndex) {
                return canEdit [columnIndex];
            }
        });
        jScrollPane1.setViewportView(jTable1);

        jLabel1.setFont(new java.awt.Font("宋体", 1, 24));
        jLabel1.setForeground(new java.awt.Color(204, 0, 0));
        jLabel1.setText("\u8f66\u7968\u9884\u8ba2");

        org.jdesktop.layout.GroupLayout jPanel1Layout = new org.jdesktop.layout.GroupLayout(jPanel1);
        jPanel1.setLayout(jPanel1Layout);
        jPanel1Layout.setHorizontalGroup(
            jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel1Layout.createSequentialGroup()
                .add(45, 45, 45)
                .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(jScrollPane1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 571, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(jPanel1Layout.createSequentialGroup()
                        .add(jButton2)
                        .add(54, 54, 54)
                        .add(jButton3)
                        .add(80, 80, 80)
                        .add(jButton4))
                    .add(jLabel1))
                .addContainerGap(54, Short.MAX_VALUE))
        );
        jPanel1Layout.setVerticalGroup(
            jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(org.jdesktop.layout.GroupLayout.TRAILING, jPanel1Layout.createSequentialGroup()
                .add(21, 21, 21)
                .add(jLabel1)
                .add(31, 31, 31)
                .add(jScrollPane1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 173, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED, 71, Short.MAX_VALUE)
                .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jButton2)
                    .add(jButton3)
                    .add(jButton4))
                .add(57, 57, 57))
        );

        org.jdesktop.layout.GroupLayout layout = new org.jdesktop.layout.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel1, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel1, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
        );
        pack();
    }// </editor-fold>//GEN-END:initComponents

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed
// TODO 将在此处添加您的处理代码：
         String[] col = { "姓名", "性别", "身份证","出发地","目的地","旅行时间","车型要求","成功订票" };
         DefaultTableModel mm= new DefaultTableModel(col,0);
         try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}//建立JDBC-ODBC的桥接器}
        catch(ClassNotFoundException e) { System.out.println(""+e); }
        try{
            con=DriverManager.getConnection("jdbc:odbc:车票预订系统","","");//连接到数据库
            sql=con.createStatement();//向数据库发送SQL语句
            rs=sql.executeQuery("use 车票预订系统 select * from 用户信息表");
            while(rs.next()) {             
                  
                    String name=rs.getString(1);
                    String sex=rs.getString(2);
                    String id=rs.getString(3);
                    String from=rs.getString(4);
                    String to=rs.getString(5);
                    String  time=rs.getString(6);
                    String type=rs.getString(7);
                    String  ok=rs.getString(8);
                    String[] str_row={name,sex,id,from,to,time,type,ok};
                     mm.addRow(str_row);//添加在表模板中
              } jTable1.setModel(mm);
        }
    catch(SQLException e) {System.out.println(e);}                
                  
                    
        
    }//GEN-LAST:event_jButton2ActionPerformed

    private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton4ActionPerformed
// TODO 将在此处添加您的处理代码：
            int t=jTable1.getSelectedRow();
              String id1=(String) (jTable1.getValueAt(t,2));
             if( jTable1.getValueAt(t,7).equals("是") )  
         {
               
               JOptionPane.showMessageDialog(this,"不可以删除！","报错",JOptionPane.WARNING_MESSAGE);   
         }
             else
             {
              try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}//建立JDBC-ODBC的桥接器}
        catch(ClassNotFoundException e) { System.out.println(""+e); }
        try {

            con=DriverManager.getConnection("jdbc:odbc:车票预订系统","","");//连接到数据库
       
            sql=con.createStatement();//向数据库发送SQL语句
          sql.execute("use 车票预订系统 delete  from 用户信息表    where 身份证="+"'"+id1+"'"); 
              
         new 失败().setVisible(true);
        
        } 
        catch (SQLException ex) {  ex.printStackTrace(); }//连接到数据库
               try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}//建立JDBC-ODBC的桥接器}
        catch(ClassNotFoundException e) { System.out.println(""+e); }
             }
              
         
        
          String[] col = { "姓名", "性别", "身份证","出发地","目的地","旅行时间","车型要求","成功订票" };
         DefaultTableModel mm= new DefaultTableModel(col,0);
         try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}//建立JDBC-ODBC的桥接器}
        catch(ClassNotFoundException e) { System.out.println(""+e); }
        try{
            con=DriverManager.getConnection("jdbc:odbc:车票预订系统","","");//连接到数据库
            sql=con.createStatement();//向数据库发送SQL语句
            rs=sql.executeQuery("use 车票预订系统 select * from 用户信息表");
            while(rs.next()) {             
                  
                    String name=rs.getString(1);
                    String sex=rs.getString(2);
                    String id=rs.getString(3);
                    String from=rs.getString(4);
                    String to=rs.getString(5);
                    String  time=rs.getString(6);
                    String type=rs.getString(7);
                    String  ok=rs.getString(8);
                    String[] str_row={name,sex,id,from,to,time,type,ok};
                     mm.addRow(str_row);//添加在表模板中
              } jTable1.setModel(mm);
        }
    catch(SQLException e) {System.out.println(e);}
         
        
    }//GEN-LAST:event_jButton4ActionPerformed

    private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton3ActionPerformed
// TODO 将在此处添加您的处理代码：
              int t=jTable1.getSelectedRow();
              String id=(String) (jTable1.getValueAt(t,2)),order=(String) jTable1.getValueAt(t,7);
              
             jTable1.setValueAt("是",t,7);
             
               try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}//建立JDBC-ODBC的桥接器}
        catch(ClassNotFoundException e) { System.out.println(""+e); }
        try {

            con=DriverManager.getConnection("jdbc:odbc:车票预订系统","","");//连接到数据库
       
            sql=con.createStatement();//向数据库发送SQL语句
          sql.execute("use 车票预订系统 update 用户信息 set 成功订票='是'   where 身份证="+"'"+id+"'");
  
              
                 new 成功().setVisible(true); 
        
        } catch (SQLException ex) {
            ex.printStackTrace();
        }//连接到数据库
    }//GEN-LAST:event_jButton3ActionPerformed
    
    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new bookticket().setVisible(true);
            }
        });
    }
    
    // 变量声明 - 不进行修改//GEN-BEGIN:variables
    private javax.swing.JButton jButton2;
    private javax.swing.JButton jButton3;
    private javax.swing.JButton jButton4;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JTable jTable1;
    // 变量声明结束//GEN-END:variables
    
}