updatet.java

java 读写EXCEL文件的源码

                                 {
                                  suFlag=execuUpdate(conn,null,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("XXK_T")){
	     while(TyResult.next())
              {
                               MslinkStr           = TyResult.getString("mslink");
                               CodeStr             = TyResult.getString("信息口编码");
                               SecondSql="UPDATE XXK_T SET  TFLAG='1' where mslink="+MslinkStr;
                               FouthSql=InsertS.XXK+MslinkStr;
                               if(CodeStr!=null&&AreaCodeStr!=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("XQ_T")){
	     while(TyResult.next())
              {
                               MslinkStr           = TyResult.getString("mslink");
                               CodeStr             = TyResult.getString("小区名称");
                               SecondSql="UPDATE XQ_T SET QY_ID='"+AreaCodeStr+"',  TFLAG='1' where mslink="+MslinkStr;
                               FouthSql=InsertS.XQ+MslinkStr;
                               if(CodeStr!=null&&AreaCodeStr!=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("JZW_T")){
	     while(TyResult.next())
              {

                               MslinkStr           = TyResult.getString("mslink");
                               CodeStr             = TyResult.getString("建筑物名称");
                               SecondSql="UPDATE JZW_T SET QY_ID='"+AreaCodeStr+"', TFLAG='1' where mslink="+MslinkStr;
                               FouthSql=InsertS.JZW+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("JXGX_T")){
	     while(TyResult.next())
              {

                               MslinkStr           = TyResult.getString("mslink");
                               CodeStr             = TyResult.getString("局向光纤编码");
                               String gl_code        = TyResult.getString("所属光缆编码");

                               SecondSql="UPDATE JXGX_T SET QY_ID='"+AreaCodeStr+"', TFLAG='1' where mslink="+MslinkStr;
                               FouthSql=InsertS.JXGX+MslinkStr;

                               if(CodeStr!=null&&gl_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(CodeStr==null)frmErrorS=frmErrorS+"局向光纤编码为空";
                                 if(gl_code==null)frmErrorS=frmErrorS+"无法对应光缆编码";

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

                               MslinkStr           = TyResult.getString("mslink");
                               CodeStr             = TyResult.getString("光路编码");
                               SecondSql="UPDATE GLU_T SET QY_ID='"+AreaCodeStr+"', TFLAG='1' where mslink="+MslinkStr;
                               FouthSql=InsertS.GLU+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("WXJZ_T")){
	     while(TyResult.next())
              {

                            MslinkStr           = TyResult.getString("mslink");
                            CodeStr             = TyResult.getString("无线基站编码");
                            String Local_dwcode = TyResult.getString("所属单位编码");

                            SecondSql="UPDATE WXJZ_T SET  TFLAG='1' where mslink="+MslinkStr;
                            FouthSql=InsertS.WXJZ+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("GYHT_T")){
	     while(TyResult.next())
              {

                            MslinkStr           = TyResult.getString("mslink");
                            CodeStr             = TyResult.getString("话亭编码");
                            String Local_dwcode = TyResult.getString("所属单位编码");
                            SecondSql="UPDATE GYHT_T SET  TFLAG='1' where mslink="+MslinkStr;
                            FouthSql=InsertS.GYHT+MslinkStr;
                            if(Local_dwcode!=null&&CodeStr!=null)
                                 {
                                  suFlag=execuUpdate(conn,SecondSql,FouthSql,jLabel1);
                                               if(suFlag!=null)
                                                 {