frame1.java

这个软件实现了无重复随机抽号过程

package fetch;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import com.borland.jbcl.layout.*;
import java.sql.*;
import java.util.Vector;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2005</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class Frame1 extends JFrame implements Runnable,ActionListener{
  JPanel contentPane;
  XYLayout xYLayout1 = new XYLayout();
  JTextField jTextField1 = new JTextField();
  JLabel jLabel1 = new JLabel();
  JButton jButton1 = new JButton();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JLabel jLabel5 = new JLabel();
  JLabel jLabel6 = new JLabel();
  JLabel jLabel7 = new JLabel();
  JButton jButton2 = new JButton();
  JLabel jLabel8 = new JLabel();
  JLabel jLabe20 = new JLabel();
  String sign="开始抽号";//结束抽号
  int number=0;
  int total=0;
  Vector number_store=new Vector();
  Vector number_delete=new Vector();

 Connection con=null;
 Statement stmt=null;
 ResultSet result=null;
 String name1="";
 String name2="";
 String work_place1="";
 String work_place2="";
 String iden1="";
 String iden2="";
 Thread star=null;
 Thread temp=null;
 JLabel jLabel9 = new JLabel();
  JLabel jLabel10 = new JLabel();
  JLabel jLabel11 = new JLabel();
  JLabel jLabel12 = new JLabel();
  int total_=0;
  String show="";
  Image m=null;
  JButton jButton3 = new JButton();
  JMenuBar jMenuBar1 = new JMenuBar();
  JMenu jMenu1 = new JMenu();
  JMenuItem jMenuItem1 = new JMenuItem();
  JMenu jMenu2 = new JMenu();
  JMenuItem jMenuItem2 = new JMenuItem();
  JMenuItem jMenuItem3 = new JMenuItem();
  JMenuItem jMenuItem4 = new JMenuItem();
  JButton jButton4 = new JButton();




  //Construct the frame
  public Frame1() {
    enableEvents(AWTEvent.WINDOW_EVENT_MASK);
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }

  //Component initialization
  private void jbInit() throws Exception  {
    try {
      m=Toolkit.getDefaultToolkit().getImage("background7.jpg");
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //加载驱动程序
      con=DriverManager.getConnection("jdbc:odbc:data");
      String number_num="";
      total=0;
      number_store.removeAllElements();
      try{
        stmt = con.createStatement();
        result = stmt.executeQuery("select num from tab");
        while(result.next()){
          number_num=result.getString(1).trim();
          number_store.add(number_num);          //保存读出的数字
        total++;
        System.out.println("          number="+number_num+"  total="+number_store.size());
        }
        result.close();
        result = stmt.executeQuery("select id from a_dd");
        while(result.next())
        {
         number_delete.add(result.getString(1).trim());
        }
        result.close();
        stmt.close();
        show=String.valueOf(number_delete.size())+"/"+String.valueOf(number_store.size()+number_delete.size());
        jLabel12.setText(show);
      }
      catch(Exception de)
      {System.out.println(de.toString());}

         }
    catch(Exception e) {
      e.printStackTrace();
    }

    contentPane = (JPanel) this.getContentPane();
    jTextField1.setFont(new java.awt.Font("Arial", 1, 20));
    jTextField1.setSelectionStart(11);
    jTextField1.setText("0000");
    contentPane.setBackground(new Color(208, 208, 187));
    contentPane.setLayout(xYLayout1);
    this.setForeground(Color.black);
    this.setJMenuBar(jMenuBar1);
    this.setResizable(false);
    this.setSize(new Dimension(700, 500));
    this.setState(Frame.NORMAL);
    this.setTitle("徐州市房管局购房抽号软件");
    jLabel1.setFont(new java.awt.Font("隶书", 1, 22));
    jLabel1.setText("请输入购房资格号:");
    jButton1.setFont(new java.awt.Font("幼圆", 1, 18));
    jButton1.setText("确定");
    jButton1.addActionListener(this);
    jLabel2.setFont(new java.awt.Font("幼圆", 1, 16));
    jLabel2.setText("申请人姓名");
    jLabel3.setText("身份证号码");
    jLabel3.setFont(new java.awt.Font("幼圆", 1, 16));
    jLabel4.setText("单位");
    jLabel4.setFont(new java.awt.Font("幼圆", 1, 16));
    jLabel5.setText("申请人配偶");
    jLabel5.setFont(new java.awt.Font("幼圆", 1, 16));
    jLabel6.setFont(new java.awt.Font("幼圆", 1, 16));
    jLabel6.setText("身份证号码");
    jLabel7.setFont(new java.awt.Font("幼圆", 1, 16));
    jLabel7.setText("单位");
    jButton2.setFont(new java.awt.Font("幼圆", 1, 18));
    jButton2.setText("开始抽号");
    //jButton2.addActionListener(this);
    jLabel8.setFont(new java.awt.Font("Dialog", 1, 110));
    jLabel8.setForeground(Color.red);
    jLabel8.setText("号码");
    jLabe20.setFont(new java.awt.Font("Dialog", 1, 110));
    jLabe20.setForeground(Color.red);
    jLabe20.setText("号码");
    jLabel9.setFont(new java.awt.Font("隶书", 1, 30));
    jLabel9.setForeground(new Color(255, 48, 118));
    jLabel9.setText("抽取购房顺序号");
    jLabel10.setText("号码");
    jLabel11.setFont(new java.awt.Font("Dialog", 1, 20));
    jLabel11.setText("已抽取号码/号码总数");
   // jLabel12.setText(" ");
    jLabel12.setFont(new java.awt.Font("Dialog", 1, 20));
    jButton3.setFont(new java.awt.Font("幼圆", 1, 18));
    jButton3.setText("打印");
    jMenu1.setText("系统");
    jMenuItem1.setText("退出");
    jMenuItem4.setText("设置数据");
    jMenuItem4.addActionListener(this);
    jMenuItem1.addActionListener(new Frame1_jMenuItem1_actionAdapter(this));
    jMenu2.setText("操作");
    jMenuItem2.setText("已抽号码");
    jMenuItem2.addActionListener(new Frame1_jMenuItem2_actionAdapter(this));
    jMenuItem3.setText("未抽号码");
    jMenuItem3.addActionListener(new Frame1_jMenuItem3_actionAdapter(this));
    jButton4.setFont(new java.awt.Font("新宋体", 0, 11));
    jButton4.setText("下一个");
    jButton4.addActionListener(this);
    contentPane.add(jTextField1,     new XYConstraints(201, 28, 89, 30));

    contentPane.add(jLabel2,     new XYConstraints(12, 350, 113, 31));
    contentPane.add(jLabel5,     new XYConstraints(12, 372, 113, 31));

    contentPane.add(jLabel9,  new XYConstraints(17, 91, 234, 45));
    contentPane.add(jLabel8, new XYConstraints(141, 141, 296, 137));
    contentPane.add(jLabe20, new XYConstraints(141, 141, 296, 137));
    contentPane.add(jLabel11, new XYConstraints(419, 264, 232, 27));
    contentPane.add(jLabel12,   new XYConstraints(452, 290, 147, 27));
    contentPane.add(jLabel10, new XYConstraints(231, 312, 62, 23));
    contentPane.add(jLabel7, new XYConstraints(304, 372, 396, 31));
    contentPane.add(jLabel4,   new XYConstraints(304, 350, 396, 31));
    contentPane.add(jLabel6, new XYConstraints(144, 372, 164, 31));
    contentPane.add(jLabel3, new XYConstraints(144, 350, 164, 31));
    contentPane.add(jLabel1, new XYConstraints(9, 25, 201, 32));
    contentPane.add(jButton1,  new XYConstraints(293, 30, 70, -1));
    contentPane.add(jButton2,   new XYConstraints(365, 30, 136, 31));
    contentPane.add(jButton3, new XYConstraints(505, 30, 74, 30));
    contentPane.add(jButton4,  new XYConstraints(294, 64, 69, 27));
    jMenuBar1.add(jMenu1);
    jMenuBar1.add(jMenu2);
    jMenu1.add(jMenuItem4);
    jMenu1.addSeparator();
    jMenu1.add(jMenuItem1);

    jMenu2.add(jMenuItem2);
    jMenu2.addSeparator();
    jMenu2.add(jMenuItem3);
  }

  //Overridden so we can exit when window is closed
  protected void processWindowEvent(WindowEvent e) {
    super.processWindowEvent(e);
    if (e.getID() == WindowEvent.WINDOW_CLOSING) {
      System.exit(0);
    }
  }

/*  public void keyTyped(KeyEvent e){
if(e.getKeyCode()==KeyEvent.VK_ENTER)
{
  System.out.print("Enter");
      if(star!=null)
      {
        star.stop();
      }
}
  }*/
  public void run(){
    String number1="";
    int k=0;
    while(true){
      {
       try{
       double d=Math.random();
       k=(int)Math.floor(d*total);
       System.out.println("                 产生随即号码!!!!!!");
       System.out.println("k="+k);
       number1=(String)number_store.elementAt(k);
       number=Integer.valueOf(number1).intValue();
       if(number<=9&&number>=1)
          {
          number1="000"+String.valueOf(number);
          }
          else if(number<=99&&number>=10)
          {
          number1="00"+String.valueOf(number);
          }
          else if(number<=999&&number>=100)
          {
          number1="0"+String.valueOf(number);
          }
          else number1=String.valueOf(number);
       jLabel8.setText(number1);
      }
      catch(Exception de){
        System.out.print("run()产生随即号码!!!! 中有误");
        de.printStackTrace();
        System.out.println(de.toString());
      }
      }
    while(number==0)
          {
          System.out.println("有o数字出现");
          number=random1();
          //continue loop;
          }
          try{
            Thread.sleep(80);
          }
          catch(Exception de )
          {System.out.println(de.toString());}
    }

  }
/*  public void keyPressed(KeyEvent e){}
  public void keyReleased(KeyEvent e){}*/
  public void actionPerformed(ActionEvent e){
    String str="";
    int sq2=0;
    int sq3=0;
    if(e.getSource()==jButton1){
      str = jTextField1.getText().trim();
      if (tatol_number() == 0) {
        JOptionPane.showMessageDialog(null, "此次抽号结束!!!!");
      }
      else {
        try {
          sq2 = Integer.valueOf(str).intValue();
          if(sq2>1000||sq2<=0)
          {
          JOptionPane.showMessageDialog(null,"你输入的数字有误，请核对！！！");
          throw new Exception("你输入的数字有误，请核对！");
          }
          stmt = con.createStatement();
          result = stmt.executeQuery("select name1,iden1,work_place1,name2,iden2,work_place2,sq3 from personal_info where sq2=" +sq2);
          result.next();
          name1 = result.getString(1).trim();
          iden1 = result.getString(2).trim();
          work_place1 = result.getString(3).trim();
          name2 = result.getString(4).trim();
          iden2 = result.getString(5).trim();
          work_place2 = result.getString(6).trim();
          sq3 = result.getInt(7);
          result.close();
          stmt.close();
          if (sq3 != 0) {
            jButton2.removeActionListener(this);
            jButton2.setText("不可以抽号");
            JOptionPane.showMessageDialog(null,"此号码" + sq2+ "已经抽过!!!!!申请人：" + name1);