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_jzcode==null)frmErrorS=frmErrorS+",无法对应所属局站编码";
                                 if(Local_jjxcode==null)frmErrorS=frmErrorS+",分线盒编码中无法找到隶属于哪个交接箱";

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

                            MslinkStr           = TyResult.getString("mslink");
                            CodeStr             = TyResult.getString("ODF编码");
                            String Local_jfcode= TyResult.getString("所属机房编码");
                            String Local_jzcode = TyResult.getString("所属局站编码");
                            SecondSql="UPDATE ODF_T SET  TFLAG='1' where mslink="+MslinkStr;
                            FouthSql=InsertS.ODF+MslinkStr;
                            if(Local_jzcode!=null&&Local_jfcode!=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+",无法对应所属局站编码";
                                 if(Local_jfcode==null)frmErrorS=frmErrorS+",无法对应所属机房编码";

                                 WriteErrorExl(frmErrorS,cell,TyResult,cols);
                                 cell=null;
                                 rowindex++;
                                 rowindex_excel++;
                                }//end if
                             frmErrorS="错误类型：";
                             Local_jzcode=null;
                             Local_jfcode=null;
 	      }//end while
                              TyResult.close();
/*光交接箱*/
        }else if(tabName.equals("GJJ_T")){
	     while(TyResult.next())
              {

                            MslinkStr           = TyResult.getString("mslink");
                            CodeStr             = TyResult.getString("光交接箱编码");
                            String Local_jzcode = TyResult.getString("所属局站编码");
                            SecondSql="UPDATE GJJ_T SET TFLAG='1' where mslink="+MslinkStr;
                            FouthSql=InsertS.GJJ+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("GFX_T")){
	     while(TyResult.next())
              {

                               MslinkStr           = TyResult.getString("mslink");
                               CodeStr             = TyResult.getString("光分纤盒编码");
//                               String Local_jfcode= TyResult.getString("所属机房编码");
                               String Local_jzcode = TyResult.getString("所属局站编码");

                            SecondSql="UPDATE GFX_T SET  TFLAG='1' where mslink="+MslinkStr;
                            FouthSql=InsertS.GFX+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+",无法对应所属局站编码";
//                                 if(Local_jfcode==null)frmErrorS=frmErrorS+",无法对应所属机房编码";

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

/*ODM--新增的odm编码字段直接移植框号字段*/
        }else if(tabName.equals("ODM_T")){
	     while(TyResult.next())
              {

                            MslinkStr           = TyResult.getString("mslink");
                            String Local_odfcode = TyResult.getString("ODF编码");
                            SecondSql="UPDATE ODM_T SET  TFLAG='1' where mslink="+MslinkStr;
                            FouthSql=InsertS.ODM+MslinkStr;
                            if(Local_odfcode!=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(Local_odfcode==null)frmErrorS=frmErrorS+",无法对应所属ODF编码";

                                 WriteErrorExl(frmErrorS,cell,TyResult,cols);
                                 cell=null;
                                 rowindex++;
                                 rowindex_excel++;
                                }//end if
                              frmErrorS="错误类型：";
                              Local_odfcode=null;
	      }//end while
                              TyResult.close();
/*综合配线箱*/
 	}else if(tabName.equals("ZHX_T")){
	  String jf_id =null;
	     while(TyResult.next())
              {

                               MslinkStr           = TyResult.getString("mslink");
                               CodeStr             = TyResult.getString("综合配线箱编码");
                               String Local_jfcode= TyResult.getString("所属机房编码");
                               String Local_jzcode = TyResult.getString("所属局站编码");
                            SecondSql="UPDATE ZHX_T SET  TFLAG='1' where mslink="+MslinkStr;
                            FouthSql=InsertS.ZHX+MslinkStr;
                            if(Local_jzcode!=null&&Local_jfcode!=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+",无法对应所属局站编码";
                                 if(Local_jfcode==null)frmErrorS=frmErrorS+",无法对应所属机房编码";

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

 	}else if(tabName.equals("CQJ_T")){
	     while(TyResult.next())
              {

                            MslinkStr           = TyResult.getString("mslink");
                            CodeStr             = TyResult.getString("充气机编码");
                            String Local_jfcode= TyResult.getString("所属机房编码");
                            String Local_jzcode = TyResult.getString("所属局站编码");
                            SecondSql="UPDATE CQJ_T SET  TFLAG='1' where mslink="+MslinkStr;
                            FouthSql=InsertS.CQJ+MslinkStr;
                            if(Local_jzcode!=null&&Local_jfcode!=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)frmErro