deletemiddletable.java

java 读写EXCEL文件的源码

/********************************************************************
 *
 * $RCSfile: DeleteMiddleTable.java,v $  $Revision: 1.1 $  $Date: 2003/09/22 08:06:24 $
 *
 * $Log: DeleteMiddleTable.java,v $
 * Revision 1.1  2003/09/22 08:06:24  icestone
 * init
 *
 *
 *
 **********************************************************************/
package pcdmupgradedata;
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;
import java.net.*;
import java.io.*;
import java.io.FileOutputStream;
import java.io.FileInputStream;
import java	    .io		.BufferedReader;
import java	    .io		.BufferedWriter;
import java	    .io		.File;
import java	    .io		.IOException;
import java.util.*;
  public class DeleteMiddleTable
  {
      public DeleteMiddleTable
      (
       Connection conn,
       String filePath
      )
      {

        boolean DEBUG = false;

       String rdfile;

       try{

  	    Statement updateStatement = conn.createStatement();

            LineNumberReader out1 = new LineNumberReader
                                   (new InputStreamReader
                                   (new FileInputStream(filePath)));


            while((rdfile=out1.readLine()) != null) {
if(DEBUG)System.out.println(rdfile);
                if(rdfile.equals(""))continue;
                updateStatement.executeUpdate(rdfile);
               }//end while
           out1.close();
           updateStatement.close();
         }
         catch (ArrayIndexOutOfBoundsException ae)//vector throw exception
          {
           }
         catch (java.sql.SQLException se)
          {
               JOptionPane.showConfirmDialog(null, "数据库操作错误\n"+se,"错误",JOptionPane.DEFAULT_OPTION, JOptionPane.ERROR_MESSAGE);
               return;
           }
        catch ( FileNotFoundException fe) {
               JOptionPane.showConfirmDialog(null, "脚本文件丢失！"+fe, "错误", JOptionPane.DEFAULT_OPTION, JOptionPane.ERROR_MESSAGE);
             }//end try
        catch ( IOException ioe) {
               System.err.println(ioe.toString());
            }

  }
}