movedatagui.java

java 读写EXCEL文件的源码

             fristFlag=1;
       	   }//end for
         conn.commit();
         /* 恢复原提交状态 */
         conn.setAutoCommit(true);
         statusBar.setText("数据表将转换为中间表格式");
         I_SqlStatement.close();
         I_selsqlResultSet.close();

        }//end if
       else
        _updateZ(1);

        this.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));

        /*单表转换*/
        if(error_flag==false)
         {

          jPanel1.setVisible(true);
          jPanel9.setVisible(false);
          jPanel10.setVisible(true);
          jPanel5.setVisible(false);
          selectpanel.setVisible(false);
          jPanel4.setVisible(true);
          jCheckBox2.setVisible(false);

          getAreacode();
          ThreadRun();
         }
        else
          reback();
     }
     catch(java.sql.SQLException es){
        JOptionPane.showMessageDialog(this, "中间定义表"+I_TABLENAME+"可能不存在或无法清除其已转换数据\n"+es, "错误", JOptionPane.ERROR_MESSAGE);
        System.exit(0);
      }

     }//end jb5
/////////////////////////////////end runup2
  private  void  updateZtable(String Utable,int execuFlag)
  {
       String sql=null;
       String frist_sql=null;
       String second_sql=null;
       String pcdm_sql=null;
       String delete_t_table=null;
       String sel_sql=null;
       try{
Debug.print("execuFlag is "+execuFlag);
                  ResultSet selsqlResultSet;

                  if(jCheckBox2.isSelected()==true)
                  {
                     frist_sql="update zjdy_t set readflag=0";
                     sql="update zjdy_t set readflag=1 where ctablename='"+Utable+"'";
                  }
                  else
                  {
                     frist_sql="update zjdy_t set readflag=1";
                     sql="update zjdy_t set readflag=0 where ctablename='"+Utable+"'";

                  }
                  if(execuFlag==0)
                  {
                    runSql(frist_sql);
                    runSql(sql);
                  }
                     Statement SqlStatement = conn.createStatement();

                     sel_sql="select TABLENAME,PCDM_SQL from zjdy_t where ctablename='"+Utable+"'";
                     selsqlResultSet=SqlStatement.executeQuery(sel_sql);
                     selsqlResultSet.next();
                     delete_t_table="DELETE FROM "+selsqlResultSet.getString(1);
                     pcdm_sql=selsqlResultSet.getString(2);

                     selsqlResultSet.close();
Debug.print(pcdm_sql);
Debug.print(delete_t_table);
                     runSql(delete_t_table);
                     runSql(pcdm_sql);


/* 2003 07 20 Lm change
                      second_sql="drop table "+m_table;
                      Statement updateStatement = conn.createStatement();
                      try
                         {
                          if(execuFlag==0)
                           updateStatement.executeUpdate(frist_sql);
                           updateStatement.executeUpdate(sql);
                           updateStatement.executeUpdate(second_sql);
                           DropZFile(sel_st,sel_ed);
	                  }
                          catch(java.sql.SQLException e){
      	                  }//end try

                  finally{
      	                  updateStatement.close();
      	                  SqlStatement.close();
                         }//end finally
*/
	          }
              catch(java.sql.SQLException e){
     	     }
  }


/////////////////////////////////end runup2
  private  void  _updateZ(int execuFlag)
  {

             String sql=null;
             if(execuFlag==0)
              {
               sql="update zjdy_t set readflag=0";
              }
             else
             {
               sql="update zjdy_t set readflag=1";
             }
             runSql(sql);

  }



  void jButton7_actionPerformed(ActionEvent e) {
               codeRule cRule=new codeRule();
               cRule.setLocation((BaseGui.screenSize.width - BaseGui.frameSize.width-100) / 2,
                                (BaseGui.screenSize.height - BaseGui.frameSize.height+100) / 2);
               cRule.setSize(365,220);
               cRule.show();
  }
/**全选复选框事件*/
  void jCheckBox2_actionPerformed(ActionEvent e) {
        SelectPanel.uTablename.removeAllElements();
        for(int i=0;i<SelectPanel.pos;i++)
         {
            if(jCheckBox2.isSelected()==false)
              {
                SelectPanel.jCheckBox[i].setSelected(false);
                this.setCursor(new java.awt.Cursor(java.awt.Cursor.WAIT_CURSOR));
                _updateZ(1);
                this.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));

              }
            else
              {
                SelectPanel.jCheckBox[i].setSelected(true);
               this.setCursor(new java.awt.Cursor(java.awt.Cursor.WAIT_CURSOR));
                _updateZ(0);
                this.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));

              }
         }//end for
  }


  void jButton10_actionPerformed(ActionEvent e) {
    if(jPanel7.isVisible()==true){
    }else if(jPanel8.isVisible()==true){
      jPanel8.setVisible(false);
      jPanel7.setVisible(true);
      jButton10.setEnabled(false);

    }else if(jPanel9.isVisible()==true){
      jPanel9.setVisible(false);
      jPanel8.setVisible(true);
    }else if(jPanel10.isVisible()==true){
      jPanel10.setVisible(false);
      jPanel9.setVisible(true);
      jButton9.setEnabled(true);
      jButton2.setEnabled(false);
    }

  }

  void jButton9_actionPerformed(ActionEvent e) {
        if(jPanel7.isVisible()==true){
          jPanel7.setVisible(false);
          jPanel8.setVisible(true);
          jButton10.setEnabled(true);
        }else if(jPanel8.isVisible()==true){
          jPanel8.setVisible(false);
          jPanel9.setVisible(true);

        }else if(jPanel9.isVisible()==true){
          jPanel9.setVisible(false);
          jPanel10.setVisible(true);
          jButton9.setEnabled(false);
          jButton2.setEnabled(true);
        }else if(jPanel10.isVisible()==true){
        }
  }

  void jRadioButton6_actionPerformed(ActionEvent e) {
    changeTypeDialog=new ChangeTypeDialog(conn);
    changeTypeDialog.setLocation((BaseGui.screenSize.width - BaseGui.frameSize.width-100) / 2,
                     (BaseGui.screenSize.height - BaseGui.frameSize.height+100) / 2);

    changeTypeDialog.setSize(540,390);
    changeTypeDialog.setVisible(true);

  }

  void jRadioButton4_actionPerformed(ActionEvent e) {
//       jRadioButton3.setSelected(true);
        getAreacode();
        jButton9.setEnabled(false);
        this.setCursor(new java.awt.Cursor(java.awt.Cursor.WAIT_CURSOR));
  	new DataImport(this,"选择数据表导入",false,conn,bmtmp,jButton9);
        this.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));

//     this.dispose();
  }///////////////////////////////////////////////////////////end updateZtable

/**
*重新创建中间表操作
**/

   private void DropZFile(int st,int ed){

       String d_rdfile=null;
       int linenum=1;
       try{
  	    Statement updateStatement = conn.createStatement();

            LineNumberReader out1 = new LineNumberReader
                                   (new InputStreamReader
                                   (new FileInputStream(Const.PD_CREATEDB)));


            while((d_rdfile=out1.readLine()) != null) {

                 if(st<=linenum&&ed>=linenum)
                   {

                    updateStatement.executeUpdate(d_rdfile);
                   }
                 linenum++;
               }//end while
           out1.close();
           updateStatement.close();
   	}//end try
        catch (java.sql.SQLException se)
          {
               JOptionPane.showConfirmDialog(this, "过滤不成功！"+se, "错误", JOptionPane.DEFAULT_OPTION, JOptionPane.ERROR_MESSAGE);

           }
        catch ( FileNotFoundException fe) {
               JOptionPane.showConfirmDialog(this, "脚本文件丢失！"+fe, "错误", JOptionPane.DEFAULT_OPTION, JOptionPane.ERROR_MESSAGE);

             }//end try
        catch ( IOException ioe) {
               JOptionPane.showConfirmDialog(this, "操作失败！"+ioe, "错误", JOptionPane.DEFAULT_OPTION, JOptionPane.ERROR_MESSAGE);
            }
     }//end DropZFile
  void runSql(String sql)
  {
              try{
                     Statement  InsertStatement = conn.createStatement();
                      try
                         {
                           if(sql!=null)
                            InsertStatement.executeUpdate(sql);

	                  }
                          catch(java.sql.SQLException e){
                          	System.out.println(e.toString());
      	                  }
                  finally{
                          InsertStatement.close();
                    }
	          }
              catch(java.sql.SQLException e){
      	     }
  }

  private  boolean  deleteI_table(String sql,String tablename)
  {
             try{
                   Statement  SqlStatement = conn.createStatement();
                     try
                         {
                           if(sql!=null)
                             SqlStatement.executeUpdate(sql);

	                  }
                     catch(java.sql.SQLException e){
                           JOptionPane.showMessageDialog(this, tablename+"内的设施正在被引用，无法直接转换！"+e, "错误",
                                                        JOptionPane.ERROR_MESSAGE);
                           conn.rollback();
                           return  true;

      	                  }
                    finally{
                             SqlStatement.close();
                          }
	      }
              catch(java.sql.SQLException e){
                 return  true;

      	    }
           return  false;

  }

}//end class