frame1.java~275~

Apriori是数据挖掘中关联规则的经典算法

        column15.setTableName("customer");
        column15.setWidth(12);
        column15.setServerColumnName("商品12(M,m)");
        column15.setSqlType(12);
        column16.setColumnName("商品13(N,n)");
        column16.setDataType(com.borland.dx.dataset.Variant.STRING);
        column16.setPrecision(255);
        column16.setTableName("customer");
        column16.setWidth(12);
        column16.setServerColumnName("商品13(N,n)");
        column16.setSqlType(12);
        jPanel1.add(jdbNavToolBar1, new XYConstraints(16, 5, -1, -1));
        jdbTable1.setDataSet(queryDataSet1);
        tableScrollPane1.getViewport().add(jdbTable1);
        jPanel1.add(jLabel1, new XYConstraints(11, 50, -1, -1));
        jPanel1.add(jButton4, new XYConstraints(9, 75, 89, -1));
        jPanel1.add(jButton1, new XYConstraints(135, 76, -1, -1));
        jPanel1.add(jLabel2, new XYConstraints(175, 49, -1, -1));
        jPanel1.add(jTextField1, new XYConstraints(67, 46, 73, -1));
        jPanel1.add(jTextField2, new XYConstraints(232, 46, 62, -1));
        jPanel1.add(jButton2, new XYConstraints(333, 44, -1, -1));
        jPanel2.add(tableScrollPane1, java.awt.BorderLayout.CENTER);
        contentPane.add(jPanel1, java.awt.BorderLayout.NORTH);
        contentPane.add(jPanel2, java.awt.BorderLayout.CENTER);
        contentPane.add(jdbStatusLabel1, java.awt.BorderLayout.SOUTH);
        queryDataSet1.setColumns(new Column[] {column1, column2, column3,
                                 column9, column4, column5, column6, column10,
                                 column11, column12, column13, column14,
                                 column15, column16, column8, column7});
    }

    public void jButton1_actionPerformed(ActionEvent e)
    {
        try{
            c=jTextField1.getText() ;
            d=jTextField2.getText();
            a = Double.parseDouble(c);
            b = Double.valueOf(d ).doubleValue();
            //System.out.print(a) ;
            //System.out.print(b) ;
        try{
      if((a<1&&a>0)&&(b<1&&b>0))
         {
          p=true;
           }
       else
       {

         JOptionPane.showMessageDialog(null, "请输入数字介于0~1!");

       }
   }
      catch(NumberFormatException em)
      {

           JOptionPane.showMessageDialog(null, "请输入数字介于0~1!!");
      }

         if(p)
          {
         Apriori aa = new Apriori();
         aa.main(a,b);//执行Apriori
         Frame2 bb=new Frame2();
         bb.main() ;

         Dimension dlgSize = bb.getPreferredSize();
         Dimension frmSize = getSize();
         Point loc = getLocation();
         bb.setLocation((frmSize.width - dlgSize.width) / 2 + loc.x,
                     (frmSize.height - dlgSize.height) / 2 + loc.y);
         bb.pack();
         bb.show();


        }
        else
        {
        }

        }catch(Exception ex){
           JOptionPane.showMessageDialog(null, "请输入数字介于0~1!!!");
        }
    }
    /**
     * 从数据库中导处数据到文本
     * @param e ActionEvent
     */
    public void jButton4_actionPerformed(ActionEvent e)  {
    try{

        Connection con = DriverManager.getConnection( "jdbc:odbc:TRANSACTION", "", "");
        Statement stmt = con.createStatement();
        ResultSet rs = stmt.executeQuery("SELECT * FROM customer");
      try {
              ResultSetMetaData rsmd = rs.getMetaData();
              int numberOfColumns = rsmd.getColumnCount();
              StringBuffer ret = new StringBuffer(500);
              /*for (int i = 1; i <= numberOfColumns; i++) {
              String columnName = rsmd.getColumnName(i);
              ret.append(columnName + "," );
               }
              ret.append("\n");*/
           while (rs.next()) {
                for (int i = 1; i <numberOfColumns; i++)
                  ret.append(rs.getString(i)+"," );
                  ret.append(rs.getString(numberOfColumns) );
                  ret.append("\r"+"\n");//\n. 换行符（ASCII10）. \r. 回车符（ASCII13）！！！！！！


              }
                System.out.println(ret.toString());//测试
                FileWriter out=new FileWriter("c:/shujuku.txt");
                out.write(ret.toString());
                out.write("%");
                out.close();
        }


            catch(IOException ed) {
              ed.printStackTrace() ;
            }


          }
          catch(Exception ex) {
              ex.printStackTrace() ;
    }
    }
    public void jTextField1_actionPerformed(ActionEvent e) {



      }

      public void jTextField2_actionPerformed(ActionEvent e) {

      }

    public void jButton2_actionPerformed(ActionEvent e) {
    Frame1_AboutBox dlg = new Frame1_AboutBox(this);
     Dimension dlgSize = dlg.getPreferredSize();
     Dimension frmSize = getSize();
     Point loc = getLocation();
     dlg.setLocation((frmSize.width - dlgSize.width) / 2 + loc.x,
                     (frmSize.height - dlgSize.height) / 2 + loc.y);
     dlg.setModal(true);
     dlg.pack();
     dlg.show();

    }//显示Frame1_AboutBox


    class Frame1_jButton1_actionAdapter implements ActionListener {
        private Frame1 adaptee;
        Frame1_jButton1_actionAdapter(Frame1 adaptee) {
            this.adaptee = adaptee;
        }

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


class Frame1_jButton2_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jButton2_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame1_jTextField2_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jTextField2_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame1_jTextField1_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jTextField1_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame1_jButton4_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jButton4_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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