frame1.java~268~

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

package apriori;

import java.awt.BorderLayout;
import java.awt.Dimension;
import java.io.*;
import javax.swing.JFrame;
import javax.swing.JPanel;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import com.borland.dbswing.TableScrollPane;
import com.borland.dbswing.JdbTable;
import com.borland.dx.dataset.ParameterRow;
import com.borland.dbswing.JdbNavToolBar;
import javax.swing.JButton;
import com.borland.dx.sql.dataset.Database;
import com.borland.dx.sql.dataset.*;
import com.borland.dbswing.DBDisposeMonitor;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import com.borland.dbswing.JdbStatusLabel;
import com.borland.datastore.DataStoreConnection;
import com.borland.dx.dataset.DataSetException;
import java.sql.Statement;
import com.borland.javax.sql.JdbcConnectionPool;
import java.sql.*;
import javax.swing.JTextField;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPasswordField;

public class Frame1 extends JFrame {
    JPanel contentPane;
    JPanel jPanel1 = new JPanel();
    JPanel jPanel2 = new JPanel();
    JdbNavToolBar jdbNavToolBar1 = new JdbNavToolBar();
    JButton jButton1 = new JButton();
    Database database1 = new Database();
    XYLayout xYLayout1 = new XYLayout();
    QueryDataSet queryDataSet1 = new QueryDataSet();
    TableScrollPane tableScrollPane1 = new TableScrollPane();
    JdbTable jdbTable1 = new JdbTable();
    JdbStatusLabel jdbStatusLabel1 = new JdbStatusLabel();
    JButton jButton4 = new JButton();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    boolean p;
    double a,b;
    String c;
    String d;


    JTextField jTextField1 = new JTextField();
    JTextField jTextField2 = new JTextField();
    XYLayout xYLayout2 = new XYLayout();
    JButton jButton2 = new JButton();
    BorderLayout borderLayout1 = new BorderLayout();
    public Frame1() {
        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(xYLayout2);
        setSize(new Dimension(400, 300));
        setTitle("Frame Title");
        jPanel1.setLayout(xYLayout1);
        jButton1.setText("挖掘");
        jButton1.addActionListener(new Frame1_jButton1_actionAdapter(this));
        database1.setConnection(new ConnectionDescriptor(
                "jdbc:odbc:TRANSACTION", "", "", false,
                "sun.jdbc.odbc.JdbcOdbcDriver"));
        database1.setDatabaseName("");
        jPanel2.setLayout(borderLayout1);
        queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
                database1, "SELECT * FROM customer", null, true, Load.ALL));
        jdbStatusLabel1.setText("jdbStatusLabel1");
        jButton4.setText("数据导出");
        jButton4.addActionListener(new Frame1_jButton4_actionAdapter(this));
        jLabel1.setText("支持度");
        jLabel2.setText("置信度");
        jTextField1.addActionListener(new Frame1_jTextField1_actionAdapter(this));
        jTextField2.addActionListener(new Frame1_jTextField2_actionAdapter(this));
        jButton2.setText("关于");
        jButton2.addActionListener(new Frame1_jButton2_actionAdapter(this));
        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));
        contentPane.add(jdbStatusLabel1, new XYConstraints(0, 274, 400, -1));
        contentPane.add(jPanel1, new XYConstraints(0, 0, 400, 101));
        contentPane.add(jPanel2, new XYConstraints(0, 103, 400, 171));
        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);
    }

    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);
    }
}