ex1_2.java

这是个用java编写的售票系统.基本功能都有

package 售票系统;
import javax.swing.*;
import javax.swing.border.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
public class ex1_2 implements ActionListener  {
  JFrame f=null;
  JFrame f1=null;
  public ex1_2() {
  f=new JFrame("售票系统");
  Container p =f.getContentPane();
    JPanel bp=new JPanel();
    JButton b1=new JButton("查询");
    b1.addActionListener(this);
    JButton b2=new JButton("买票");
    b2.addActionListener(this);

    bp.add(b1);
    bp.add(b2);

    p.add(bp);
    f.pack();
    f.setVisible(true);
    f.addWindowListener(new WindowAdapter()
    {public void windowClosing(WindowEvent e)
    {System.exit(0);}
    }                );

  }
  public void actionPerformed(ActionEvent e){
  String cmd=e.getActionCommand();
  if(cmd.equals("查询")){

   new chaxun(f).start();
  }
   else if(cmd.equals("买票")){
     new maipiao(f1).start();
  }
  }
public static void main(String[] args)
{new ex1_2();}

}
class chaxun extends Thread
{JFrame f=null;
  public chaxun(JFrame f)
  {this.f=f;}
  public void run()
  {new chaxun1(f);
  }

}
class maipiao extends Thread
{JFrame f=null;
public maipiao(JFrame f)
{this.f=f;}
public void run()
{new maipiao1(f);
}
}


class chaxun1 implements ActionListener
{JDialog dialog;
  JTextField tf1=new JTextField();
  JTextField tf2=new JTextField();
  JTextField tf3=new JTextField();
  JTextField tf4=new JTextField();



 chaxun1(JFrame f)
 {dialog=new JDialog(f,"售票系统",true);
  Container dp=dialog.getContentPane();
  dp.setLayout(new GridLayout(5,4));
  dp.add(new JLabel("地点：",SwingConstants.CENTER));
  dp.add(tf1);
  dp.add(new JLabel("票单价：",SwingConstants.CENTER));
  dp.add(tf2);
  dp.add(new JLabel("库存数目：",SwingConstants.CENTER));
  dp.add(tf3);
  dp.add(new JLabel("发车时间：",SwingConstants.CENTER));
  dp.add(tf4);


  JButton b1=new JButton("确定");
  JButton b2=new JButton("取消");
    dp.add(b1);
    dp.add(b2);
 b1.addActionListener(this);
    b2.addActionListener(this);
      dialog.setBounds(200,150,400,130);
    dialog.show();


  }

  public void actionPerformed(ActionEvent e)
  {
    String cmd=e.getActionCommand();
    if(cmd.equals("确定")){
    try{
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      Connection con = DriverManager.getConnection("jdbc:odbc:chaxun");
      Statement stmt = con.createStatement();
      String sno = tf1.getText();
      String str1 = "select * from 查询表 where 地点 ='"+sno+"'";
      ResultSet rs = stmt.executeQuery(str1);
      while (rs.next()) {
        tf2.setText(rs.getString("票单价"));
        tf3.setText(rs.getString("库存票数"));
        tf4.setText(rs.getString("发车时间"));


      }

      stmt.close();
       con.close();
    }
    catch(Exception ex){}

    }
    else if(cmd.equals("取消")){
    dialog.dispose();}
  }
  }

class maipiao1 implements ActionListener
  { JDialog dialog;
JTextField tf1=new JTextField();
JTextField tf2=new JTextField();
JTextField tf3=new JTextField();
JTextField tf4=new JTextField();

    maipiao1(JFrame f)
    {dialog=new JDialog(f,"客户信息",true);
  Container dp=dialog.getContentPane();
  dp.setLayout(new GridLayout(5,4));
  dp.add(new JLabel("客户名：",SwingConstants.CENTER));
  dp.add(tf1);
  dp.add(new JLabel("地点：",SwingConstants.CENTER));
  dp.add(tf2);
  dp.add(new JLabel("数目：",SwingConstants.CENTER));
  dp.add(tf3);
  dp.add(new JLabel("发车时间：",SwingConstants.CENTER));
  dp.add(tf4);
  JButton b1=new JButton("确定");
  JButton b2=new JButton("取消");
    dp.add(b1);
    dp.add(b2);
 b1.addActionListener(this);
    b2.addActionListener(this);
    dialog.setBounds(200,150,400,130);
    dialog.show();

    }
    public void actionPerformed(ActionEvent e)
  {String sno,sno1,sno2,sno3;
    int i,j;
    String cmd=e.getActionCommand();
    if(cmd.equals("确定")){
    try{
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
       Connection con=DriverManager.getConnection("jdbc:odbc:chaxun");
       Statement stmt=con.createStatement();
        sno=tf1.getText();
        sno1=tf2.getText();
        sno2=tf3.getText();
        sno3=tf4.getText();
        j=Integer.parseInt(tf3.getText());
       String str1="insert into 客户表 values('"+sno+"','"+sno1+"','"+sno2+"','"+sno3+"')";
       stmt.executeUpdate(str1);
       String str2="select 库存票数 from 查询表 where 地点='"+sno1+"'";
       ResultSet rs=stmt.executeQuery(str2);
       while(rs.next())
       {i=rs.getInt("库存票数")-j;}

       String str3="insert into 查询表(库存票数) values('i')";
       stmt.executeUpdate(str3);


       stmt.close();
       con.close();

    }
    catch(Exception ex){}

    }
    else if(cmd.equals("取消")){
    dialog.dispose();}
  }


  }