update2.java

java 读写EXCEL文件的源码

                                               else
                                                  successRow++;
                                }
                               else
                                {
                                 if(odm_code==null)frmErrorS=frmErrorS+",无法对应ODF编码与框号";
                                 if(Local_gld_code==null)frmErrorS=frmErrorS+",无法对应光缆段编码";

                                  WriteErrorExl(frmErrorS,cell,TyResult,cols);
                                 cell=null;
                                 rowindex++;
                                 rowindex_excel++;
                                }//end if
                                frmErrorS="错误类型：";
                                odm_code=null;
                                Local_gld_code=null;
	      }//end while
                              TyResult.close();
/*光交接箱端子信息表*/
 	}else if(tabName.equals("GJD_T")){
	     while(TyResult.next())
              {
                            MslinkStr=TyResult.getString("mslink");
                            String Local_code=TyResult.getString("光交接箱编码");
                            String glu_code  =TyResult.getString("光路编码");
                            SecondSql="UPDATE GJD_T SET  TFLAG='1' where mslink="+MslinkStr;
                            FouthSql=InsertS.GJD+MslinkStr;
                            if(Local_code!=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_code==null)frmErrorS=frmErrorS+",无法对应光交接箱编码";

                                  WriteErrorExl(frmErrorS,cell,TyResult,cols);
                                 cell=null;
                                 rowindex++;
                                 rowindex_excel++;
                                }//end if
                                frmErrorS="错误类型：";
                                Local_code=null;
	      }//end while
                              TyResult.close();
/*光交接箱端子与光缆纤芯表*/
 	}else if(tabName.equals("GJJX_T")){
	     while(TyResult.next())
              {
                            MslinkStr=TyResult.getString("mslink");
                            String Local_code=    TyResult.getString("光交接箱编码");
                            String Local_gld_code=TyResult.getString("光缆段编码");
                            SecondSql="UPDATE GJJX_T SET  TFLAG='1' where mslink="+MslinkStr;
                            FouthSql=InsertS.GJJX+MslinkStr;
                            if(Local_code!=null&&Local_gld_code!=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_code==null)frmErrorS=frmErrorS+",无法对应光交接箱编码";
                                 if(Local_gld_code==null)frmErrorS=frmErrorS+",无法对应光缆段编码";

                                  WriteErrorExl(frmErrorS,cell,TyResult,cols);
                                 cell=null;
                                 rowindex++;
                                 rowindex_excel++;
                                }//end if
                                frmErrorS="错误类型：";
                                Local_code=null;
                                Local_gld_code=null;
	      }//end while
                              TyResult.close();
/*光分纤盒端子信息表*/
 	}else if(tabName.equals("GFXD_T")){
	     while(TyResult.next())
              {
                            MslinkStr=TyResult.getString("mslink");
                            String Local_code=TyResult.getString("光分纤盒编码");
                            SecondSql="UPDATE GFXD_T SET  TFLAG='1' where mslink="+MslinkStr;
                            FouthSql=InsertS.GFXD+MslinkStr;
                            if(Local_code!=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_code==null)frmErrorS=frmErrorS+",无法对应光分纤盒编码";

                                  WriteErrorExl(frmErrorS,cell,TyResult,cols);
                                 cell=null;
                                 rowindex++;
                                 rowindex_excel++;
                                }//end if
                                frmErrorS="错误类型：";
                                Local_code=null;
	      }//end while
                              TyResult.close();
/*光分纤盒端子与光缆纤芯表*/
 	}else if(tabName.equals("GFGX_T")){
	     while(TyResult.next())
              {
                            MslinkStr=TyResult.getString("mslink");
                            String Local_code=TyResult.getString("光分纤盒编码");
                            String Local_gld_code=TyResult.getString("光缆段编码");
                            SecondSql="UPDATE GFGX_T SET  TFLAG='1' where mslink="+MslinkStr;
                            FouthSql=InsertS.GFGX+MslinkStr;
                            if(Local_code!=null&&Local_gld_code!=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_code==null)frmErrorS=frmErrorS+",无法对应光分纤盒编码";
                                 if(Local_gld_code==null)frmErrorS=frmErrorS+",无法对应光缆段编码";

                                  WriteErrorExl(frmErrorS,cell,TyResult,cols);
                                 cell=null;
                                 rowindex++;
                                 rowindex_excel++;
                                }//end if
                                frmErrorS="错误类型：";
                                Local_code=null;
                                Local_gld_code=null;
	      }//end while
                              TyResult.close();
/*光交设备跳纤表---出入端局向光纤编码是否对应还是对应光缆段编码*/
 	}else if(tabName.equals("GSTX_T")){
	     while(TyResult.next())
              {
                            MslinkStr= TyResult.getString("mslink");
                            String Local_rdjxcode = TyResult.getString("入端局向光纤编码");
                            String Local_cdjxcode = TyResult.getString("出端局向光纤编码");
                            String Local_rdtype   = TyResult.getString("入端光交设备类型");
                            String Local_rdcode   = TyResult.getString("入端光交设备编码");
                            String Local_cdtype   = TyResult.getString("出端光交设备类型");
                            String Local_cdcode   = TyResult.getString("出端光交设备编码");
                            SecondSql="UPDATE GSTX_T SET  TFLAG='1' where mslink="+MslinkStr;
                            FouthSql=InsertS.GSTX+MslinkStr;
                            if(Local_rdjxcode!=null&&Local_cdcode!=null&&Local_cdjxcode!=null&&Local_rdtype!=null&&Local_rdcode!=null&&Local_cdtype!=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_rdjxcode==null)frmErrorS=frmErrorS+",无法对应入端局向光纤编码";
                                 if(Local_cdjxcode==null)frmErrorS=frmErrorS+",无法对应出端局向光纤编码";
                                 if(Local_rdcode==null)frmErrorS=frmErrorS+",无法找到入端光交设备类型或编码";
                                 if(Local_cdcode==null)frmErrorS=frmErrorS+",无法找到出端光交设备类型或编码";

                                  WriteErrorExl(frmErrorS,cell,TyResult,cols);
                                 cell=null;
                                 rowindex++;
                                 rowindex_excel++;
                                }//end if
                                frmErrorS="错误类型：";
                                Local_rdjxcode =null;
                                Local_cdjxcode =null;
                                Local_rdtype   =null;
                                Local_rdcode   =null;
                                Local_cdtype   =null;
                                Local_cdcode   =null;
	      }//end while
                              TyResult.close();
/*光缆段路由表*/
 	}else if(tabName.equals("GDLY_T")){
	     while(TyResult.next())
              {
                            MslinkStr=TyResult.getString("mslink");
                            String Local_code=TyResult.getString("光缆段编码");
                            String Dss_type  =TyResult.getString("点设施类型");
                            String Dss_code  =TyResult.getString("点设施编码");
                            SecondSql="UPDATE GDLY_T SET TFLAG='1' where mslink="+MslinkStr;
                            FouthSql=InsertS.GDLY+MslinkStr;
                            if(Local_code!=null&&Dss_type!=null&&Dss_code!=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_code==null)frmErrorS=frmErrorS+",无法对应光缆段编码";
                                 if(Dss_type==null)frmErrorS=frmErrorS+",无法找到点设施类型";
                                 if(Dss_code==null)frmErrorS=frmErrorS+",无法找到点设施编码";

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