updatet.java

java 读写EXCEL文件的源码

                                                   WriteErrorExl(suFlag,cell,TyResult,cols);
                                                   cell=null;
                                                   rowindex++;
                                                   rowindex_excel++;
                                                 }//end if
                                               else
                                                  successRow++;
                                }
                               else
                                {
                                 if(CodeStr==null)frmErrorS=frmErrorS+"编码为空";
                                 if(Local_dwcode==null)frmErrorS=frmErrorS+",无法对应所属单位编码";

                                 WriteErrorExl(frmErrorS,cell,TyResult,cols);
                                 cell=null;
                                 rowindex++;
                                 rowindex_excel++;
                                }//end if
                              frmErrorS="错误类型：";
                              Local_dwcode=null;
	      }//end while
                              TyResult.close();
 /*公用电话机*/
 	}else if(tabName.equals("GYHJ_T")){
	     while(TyResult.next())
              {

                            MslinkStr           = TyResult.getString("mslink");
                            CodeStr             = TyResult.getString("话机编码");
                            String Local_dwcode = TyResult.getString("所属单位编码");
                            SecondSql="UPDATE GYHJ_T SET TFLAG='1' where mslink="+MslinkStr;
                            FouthSql=InsertS.GYHJ+MslinkStr;

                            if(Local_dwcode!=null&&CodeStr!=null)
                                 {
                                  suFlag=execuUpdate(conn,SecondSql,FouthSql,jLabel1);
                                               if(suFlag!=null)
                                                 {
                                                   WriteErrorExl(suFlag,cell,TyResult,cols);
                                                   cell=null;
                                                   rowindex++;
                                                   rowindex_excel++;
                                                 }//end if
                                               else
                                                  successRow++;
                                }
                               else
                                {
                                 if(CodeStr==null)frmErrorS=frmErrorS+"公用电话机编码为空";
                                 if(Local_dwcode==null)frmErrorS=frmErrorS+",无法对应所属单位编码";

                                 WriteErrorExl(frmErrorS,cell,TyResult,cols);
                                 cell=null;
                                 rowindex++;
                                 rowindex_excel++;
                                }//end if
                              frmErrorS="错误类型：";
                              Local_dwcode=null;
	      }//end while
                              TyResult.close();
 /*撑点*/
        }else if(tabName.equals("CD_T")){
	     while(TyResult.next())
              {

                            MslinkStr           = TyResult.getString("mslink");
                            CodeStr             = TyResult.getString("撑点编码");
                            SecondSql="UPDATE CD_T SET  TFLAG='1' where mslink="+MslinkStr;
                            FouthSql=InsertS.CD+MslinkStr;
                            if(CodeStr!=null)
                                 {
                                  suFlag=execuUpdate(conn,SecondSql,FouthSql,jLabel1);
                                               if(suFlag!=null)
                                                 {
                                                   WriteErrorExl(suFlag,cell,TyResult,cols);
                                                   cell=null;
                                                   rowindex++;
                                                   rowindex_excel++;
                                                 }//end if
                                               else
                                                  successRow++;
                                }
                               else
                                {
                                 if(CodeStr==null)frmErrorS=frmErrorS+"撑点编码为空";

                                 WriteErrorExl(frmErrorS,cell,TyResult,cols);
                                 cell=null;
                                 rowindex++;
                                 rowindex_excel++;
                                }//end if
                               frmErrorS="错误类型：";
	      }//end while
                              TyResult.close();
/*机房*/
 	}else if(tabName.equals("JF_T")){
	     while(TyResult.next())
              {

                            MslinkStr           = TyResult.getString("mslink");
                            CodeStr             = TyResult.getString("机房编码");
                            String Local_jzcode = TyResult.getString("所属局站编码");

                            SecondSql="UPDATE JF_T SET  TFLAG='1' where mslink="+MslinkStr;
                            FouthSql=InsertS.JF+MslinkStr;
                            if(Local_jzcode!=null&&CodeStr!=null)
                                 {
                                  suFlag=execuUpdate(conn,SecondSql,FouthSql,jLabel1);
                                               if(suFlag!=null)
                                                 {
                                                   WriteErrorExl(suFlag,cell,TyResult,cols);
                                                   cell=null;
                                                   rowindex++;
                                                   rowindex_excel++;
                                                 }//end if
                                               else
                                                  successRow++;
                                }
                               else
                                {
                                 if(CodeStr==null)frmErrorS=frmErrorS+"机房编码为空";
                                 if(Local_jzcode==null)frmErrorS=frmErrorS+",无法对应所属局站编码";

                                 WriteErrorExl(frmErrorS,cell,TyResult,cols);
                                 cell=null;
                                 rowindex++;
                                 rowindex_excel++;
                                }//end if
                             frmErrorS="错误类型：";
                             Local_jzcode=null;
	      }//end while
                             TyResult.close();
/*电杆*/
 	}else if(tabName.equals("DG_T")){
	     while(TyResult.next())
              {

                            MslinkStr           = TyResult.getString("mslink");
                            CodeStr             = TyResult.getString("电杆编码");
                            String Local_jzcode = TyResult.getString("所属局站编码");
                            SecondSql="UPDATE DG_T SET  TFLAG='1' where mslink="+MslinkStr;
                            FouthSql=InsertS.DG+MslinkStr;
                            if(Local_jzcode!=null&&CodeStr!=null)
                                 {
                                  suFlag=execuUpdate(conn,SecondSql,FouthSql,jLabel1);
                                        if(suFlag!=null)
                                                 {
                                                   WriteErrorExl(suFlag,cell,TyResult,cols);
                                                   cell=null;
                                                   rowindex++;
                                                   rowindex_excel++;
                                                 }//end if
                                               else
                                                  successRow++;
                                }
                               else
                                {
                                 if(CodeStr==null)frmErrorS=frmErrorS+"电杆编码为空";
                                 if(Local_jzcode==null)frmErrorS=frmErrorS+",无法对应所属局站编码";

                                 WriteErrorExl(frmErrorS,cell,TyResult,cols);
                                 cell=null;
                                 rowindex++;
                                 rowindex_excel++;
                               }//end if
                              frmErrorS="错误类型：";
                              Local_jzcode=null;
	      }//end while
                              TyResult.close();
/*配线架*/
        }else if(tabName.equals("PXJ_T")){
	     while(TyResult.next())
              {

                               MslinkStr           = TyResult.getString("mslink");
                               CodeStr             = TyResult.getString("mdf编码");
                               String Local_jzcode = TyResult.getString("所属局站编码");
                               SecondSql="UPDATE PXJ_T SET  TFLAG='1' where mslink="+MslinkStr;
                               FouthSql=InsertS.PXJ+MslinkStr;
                               if(Local_jzcode!=null&&CodeStr!=null)
                                 {
                                  suFlag=execuUpdate(conn,SecondSql,FouthSql,jLabel1);
                                               if(suFlag!=null)
                                                 {
                                                   WriteErrorExl(suFlag,cell,TyResult,cols);
                                                   cell=null;
                                                   rowindex++;
                                                   rowindex_excel++;
                                                 }//end if
                                               else
                                                  successRow++;
                                }
                               else
                                {
                                 if(CodeStr==null)frmErrorS=frmErrorS+"MDF编码为空";
                                 if(Local_jzcode==null)frmErrorS=frmErrorS+",无法对应所属局站编码";

                                 WriteErrorExl(frmErrorS,cell,TyResult,cols);
                                 cell=null;
                                 rowindex++;
                                 rowindex_excel++;
                                }//end if
                              frmErrorS="错误类型：";
                              Local_jzcode=null;
	      }//end while
                              TyResult.close();

/*IDF*/
        }else if(tabName.equals("IDF_T")){
	     while(TyResult.next())
              {

                               MslinkStr           = TyResult.getString("mslink");
                               CodeStr             = TyResult.getString("idf编码");
                               String Local_jzcode = TyResult.getString("所属局站编码");
                               SecondSql="UPDATE IDF_T SET  TFLAG='1' where mslink="+MslinkStr;
                               FouthSql=InsertS.IDF+MslinkStr;
                               if(Local_jzcode!=null&&CodeStr!=null)
                                 {
                                  suFlag=execuUpdate(conn,SecondSql,FouthSql,jLabel1);
                                               if(suFlag!=null)
                                                 {
                                                   WriteErrorExl(suFlag,cell,TyResult,cols);
                                                   cell=null;
                                                   rowindex++;
                                                   rowindex_excel++;
                                                 }//end if
                                               else
                                                  successRow++;
                                }
                               else
                                {
                                 if(CodeStr==null)frmErrorS=frmErrorS+"IDF编码为空";
                                 if(Local_jzcode==null)frmErrorS=frmErrorS+",无法对应所属局站编码";

                                 WriteErrorExl(frmErrorS,cell,TyResult,cols);
                                 cell=null;
                                 rowindex++;
                                 rowindex_excel++;
                                }//end if
                              frmErrorS="错误类型：";
                              Local_jzcode=null;
	      }//end while
                              TyResult.close();

/*网络交换机*/
          }else if(tabName.equals("WLJ_T")){
	     while(TyResult.next())
              {

                               MslinkStr           = TyResult.getString("mslink");