huocheframe.java~13~

自己看

package huochepiao;
/*定义包.类*/
import java.awt.BorderLayout;
import java.awt.Dimension;

import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JLabel;
import java.awt.Rectangle;
import java.awt.Font;
import javax.swing.JTextField;
import javax.swing.JRadioButton;
import javax.swing.JButton;
import javax.swing.ButtonGroup;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import javax.swing.JOptionPane;

//import javax.swing.JOptionPane;
//import java.awt.Color;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class HuocheFrame extends JFrame {
    int x=0;
    int y=0;/*定义2个常量*/
    JPanel contentPane;
    JLabel biaoti = new JLabel();
    JLabel huochecheci = new JLabel();
    JTextField checi = new JTextField();
    JLabel chenchefangshi = new JLabel();
    JPanel jPanel1 = new JPanel();
    JRadioButton yingzuo = new JRadioButton();
    JRadioButton yingwo = new JRadioButton();
    JLabel dinggoushuliang = new JLabel();
    JTextField shuliang = new JTextField();
    JButton queding = new JButton();
    JOptionPane xiaoxi = new JOptionPane();
    public HuocheFrame() {
        try {
            setDefaultCloseOperation(EXIT_ON_CLOSE);
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    /**
     * Component initialization.
     *
     * @throws java.lang.Exception
     */
    private void jbInit() throws Exception {
        contentPane = (JPanel) getContentPane();
        contentPane.setLayout(null);
        setSize(new Dimension(400, 300));
        setTitle("Frame Title");
        biaoti.setFont(new java.awt.Font("新宋体", Font.PLAIN, 18));
        biaoti.setText("订购火车票");
        biaoti.setBounds(new Rectangle(127, 20, 154, 34));
        huochecheci.setFont(new java.awt.Font("新宋体", Font.PLAIN, 18));
        huochecheci.setText("火车车次:");
        huochecheci.setBounds(new Rectangle(16, 68, 103, 29));
        checi.setFont(new java.awt.Font("新宋体", Font.PLAIN, 18));
        checi.setBounds(new Rectangle(129, 68, 157, 28));
        chenchefangshi.setFont(new java.awt.Font("新宋体", Font.PLAIN, 18));
        chenchefangshi.setText("乘车方式:");
        chenchefangshi.setBounds(new Rectangle(16, 120, 102, 32));

        jPanel1.setBounds(new Rectangle(129, 118, 157, 42));
        jPanel1.setLayout(null);
        yingzuo.setText("硬座");
        yingzuo.setBounds(new Rectangle(13, 6, 49, 23));
        yingwo.setText("硬卧");
        yingwo.setBounds(new Rectangle(90, 6, 52, 22));
        ButtonGroup a=new ButtonGroup();/*选择按钮*/
        a.add(yingzuo);
        a.add(yingwo);

        dinggoushuliang.setFont(new java.awt.Font("新宋体", Font.PLAIN, 18));
        dinggoushuliang.setText("订购数量:");
        dinggoushuliang.setBounds(new Rectangle(16, 179, 101, 32));
        shuliang.setBounds(new Rectangle(129, 179, 156, 31));
        queding.setFont(new java.awt.Font("新宋体", Font.PLAIN, 18));
        queding.setText("确定");
        queding.setBounds(new Rectangle(115, 235, 124, 34));
        queding.addActionListener(new HuocheFrame_queding_actionAdapter(this));
        contentPane.add(biaoti);
        contentPane.add(huochecheci);
        contentPane.add(checi);
        contentPane.add(chenchefangshi);
        contentPane.add(jPanel1);
        contentPane.add(dinggoushuliang);
        contentPane.add(shuliang);
        contentPane.add(queding);
        jPanel1.add(yingzuo);
        jPanel1.add(yingwo);
    }

   public void queding_actionPerformed(ActionEvent e) {
       String a1=checi.getText();
       String a2=shuliang.getText();
        try{
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            }catch(ClassNotFoundException ce){
                System.out.println(ce);
            }
            if(yingzuo.isSelected())
            {
                try
                {
                 String url = "jdbc:odbc:text";/*连接数据源*/
                 Connection con=DriverManager.getConnection(url);
                 Statement s=con.createStatement();
                 ResultSet rs=s.executeQuery("select * from TrainTicket");/*数据库连接*/
                 while(rs.next())
                 {
                     if(a1.equals(rs.getString(1)))
                     {
                         x++;
                     }
                 }if(x==0)
                 {
                     xiaoxi.showMessageDialog(this,"确认车次!");
                     x--;
                 }else
                 {
                     ResultSet rn=s.executeQuery("select seatNum,seatPrice from TrainTicket where TrainNo='"+checi.getText()+"'");
                     rn.next();
                     int s1=rn.getInt(1);
                     float s2=rn.getFloat(2);
                     Integer qwe=new Integer(shuliang.getText());
                      int s3=qwe.intValue();
                      int s4=s1-s3;
                      if(s1<s3)
                      {
                          xiaoxi.showMessageDialog(this,"车票购买失败?原因：票量不足");
                      }
                      else
                      {
                          int rowcount=s.executeUpdate("update TrainTicket set seatNum="+s4+" where TrainNo='"+checi.getText()+"'");/*加入数据库   更改数据*/
                          float z=s3*s2;
                          xiaoxi.showMessageDialog(this,"车票购买成功，应付金额"+z);/*应付金额*/
                      }
                 }
             }catch(SQLException ce)/*数据库异常*/
             {
              System.out.println(ce);
             }
            }


            if(yingwo.isSelected())
            {
                try
                {
                 String url = "jdbc:odbc:text";/*连接数据源*/
                 Connection con=DriverManager.getConnection(url);
                 Statement s=con.createStatement();
                 ResultSet rs=s.executeQuery("select * from TrainTicket");/*数据库连接*/
                 while(rs.next())
                 {
                     if(a1.equals(rs.getString(2)))
                     {
                         x++;
                     }
                 }if(x==0)
                 {
                     xiaoxi.showMessageDialog(this,"确认车次!");
                     x--;
                 }else
                 {
                     ResultSet rn=s.executeQuery("select seatNum,seatPrice from TrainTicket where TrainNo='"+checi.getText()+"'");
                     rn.next();
                     int s1=rn.getInt(1);
                     float s2=rn.getFloat(2);
                     Integer qwe=new Integer(shuliang.getText());
                      int s3=qwe.intValue();
                      int s4=s1-s3;
                      if(s1<s3)
                      {
                          xiaoxi.showMessageDialog(this,"车票购买失败?原因：票量不足");/*弹出异常*/
                      }
                      else
                      {
                          int rowcount=s.executeUpdate("update TrainTicket set bedNum="+s4+" where TrainNo='"+checi.getText()+"'");/*加入数据库*/
                          float z=s3*s2;
                          xiaoxi.showMessageDialog(this,"车票购买成功，应付金额"+z);/*应付金额*/
                      }
                 }
             }catch(SQLException ce)
             {
              System.out.println(ce);
             }
            }


    }
}


class HuocheFrame_queding_actionAdapter implements ActionListener {
    private HuocheFrame adaptee;
    HuocheFrame_queding_actionAdapter(HuocheFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.queding_actionPerformed(e);
    }
}