insert into 表，插入变量

最新推荐文章于 2024-10-11 12:06:32 发布

艳阳天_.

最新推荐文章于 2024-10-11 12:06:32 发布

阅读量5.4k

点赞数

分类专栏： # ORACLE

本文链接：https://blog.csdn.net/MZ199290/article/details/80549647

版权

ORACLE 专栏收录该内容

44 篇文章 1 订阅

订阅专栏

 public void actionRemove_actionPerformed(ActionEvent e) throws Exception
    {
    	if(BillStatusEnum.Audit.equals(this.editData.getBillStatus())){
    		MsgBox.showInfo("已审核的单据不允许删除！");
    		SysUtil.abort();
    	}
          String UU = java.util.UUID.randomUUID().toString();
          SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//设置日期格式 
    	  String format = df.format(new Date()) ;// new Date()为获取当前系统时间
    	//删除之前保存前记录
    	try
    	{
    		String str = " insert into CT_GSP_CustmQualific_His (" + 
    		" FID, FNumber, FBizDate, FDescription, FCreateTime, FLastUpdateTime, FAuditorID, FCreatorID," +
    		" FLastUpdateUserID, FHandlerID, FFivouchered, CFBusinessLicense, CFBusLicToDt, CFIsMedWholeSale, CFIsMecWholeSale, CFLegalRept," +
    		" CFAuthPerson, CFAuthPersonID, CFAuthRange, CFMedSaleLicense,CFMedSaleLicToDt, CFMecSaleLicense, CFMecSaleLicToDt, CFAuditDt," +
    		" CFMediEstabLic, CFMediEstabToDt, CFGSPLicense, CFGSPToDt, CFIsMedicalEstab, CFAuthToDt, CFIsMedRetail, CFIsMecRetail," +
    		" CFCustomerNumID, CFStorageAddr, CFBillStatus, CFMcustomerName, CFMMregAddress, CFBusinessLicVPType, CFAnnualIns, CFOrgCodeCer," +
    		" CFOrgCodeCerDate, CFOrgCodeCerIns, CFConsigner, CFConsignerNo, CFConsignDate, CFSealStyle, CFAccountName, CFBankName," +
    		" CFAccountNo, CFTaxCer,CFQCSurvey, HisUU, HisType )" +
    	    " select " +
    	    " FID, FNumber, FBizDate, FDescription, FCreateTime,to_date('"+format+"','yyyy-mm-dd hh24:mi:ss'),FAuditorID, FCreatorID," +
    		" FLastUpdateUserID, FHandlerID, FFivouchered, CFBusinessLicense, CFBusLicToDt, CFIsMedWholeSale, CFIsMecWholeSale, CFLegalRept," +
    		" CFAuthPerson, CFAuthPersonID, CFAuthRange, CFMedSaleLicense, CFMedSaleLicToDt, CFMecSaleLicense, CFMecSaleLicToDt, CFAuditDt," +
    		" CFMediEstabLic, CFMediEstabToDt, CFGSPLicense, CFGSPToDt, CFIsMedicalEstab, CFAuthToDt, CFIsMedRetail, CFIsMecRetail," +
    		" CFCustomerNumID, CFStorageAddr, CFBillStatus, CFMcustomerName, CFMMregAddress, CFBusinessLicVPType, CFAnnualIns, CFOrgCodeCer," +
    		" CFOrgCodeCerDate, CFOrgCodeCerIns, CFConsigner, CFConsignerNo, CFConsignDate, CFSealStyle, CFAccountName, CFBankName," +
    		" CFAccountNo, CFTaxCer,CFQCSurvey, " +
    	    " '"+ UU +"', '变更前' from CT_GSP_CustmQualific where fnumber = '"+ txtNumber.getText() +"'";
    	   SQLExecutorFactory.getRemoteInstance(str).executeSQL();
    	      
//    	   String str2="  update CT_GSP_CustmQualific_His  set  FLastUpdateTime='"+format+"'  where fnumber = '"+ txtNumber.getText() +"'    "; 
//    	   SQLExecutorFactory.getRemoteInstance(str2).executeSQL();     
    	
    	     
    	}