rs40executeupdate uf_Leasecontract set USE_NATURE=+Use_nature+ RENT_TYPE=+Rent_type+ DETAILED_ADRESS=+Detailed_adress+ LEASE_TERM=+Lease_term+ TENANCY_UNIT=+Tenancy_unit+ LEASE_START=+Lease_start+ LE

rs40.execute("update uf_Leasecontract set USE_NATURE='"+Use_nature+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set RENT_TYPE='"+Rent_type+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set DETAILED_ADRESS='"+Detailed_adress+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set LEASE_TERM='"+Lease_term+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set TENANCY_UNIT='"+Tenancy_unit+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set LEASE_START='"+Lease_start+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set LEASE_STOP='"+Lease_stop+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set REMARKS='"+Remarks+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set CREATER='"+User_id+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set CREATE_DATE='"+nowDate+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set LESSOR='"+Lessor+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set LINK_NUMBER='"+LInk_number+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set DEPOSIT_BANK='"+Deposit_bank+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set BANK_ACCOUNT='"+Bank_account+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set PAY_METHOD='"+Pay_method+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set UNIT_PRICE='"+Unit_price+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set UNIT='"+Unit+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set DEPOSIT='"+Deposit+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set FALSIFY='"+Falsify+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set TOTAL_PRICE='"+Total_price+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set SIGN_DATE='"+Sign_date+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set PAY_AMOUNT='0' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set LAST_PAY='"+Total_price+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set STATUS='1' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set OLD_CONTRACT='"+Old_contract+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set RENT_CITY='"+Rent_city+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set PROVICE='"+Provice+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set CITY='"+City+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set LEASE_AREA='"+Lease_area+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set COUNT='"+Count+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set SUPPLIER_ID='"+provider+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set LEASEHOLDER='"+Leaseholder+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set MOST_NUMBER='"+Most_number+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set LEASEHOLDER_PHONE='"+Leaseholder_phone+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set TENANCY='"+Tenancy+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set PAY_TIMES='"+Pay_times+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set PAYER_COMPANY='"+Payer_company+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set House_address='"+House_id+"' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set Inovice_amount='0' where id='"+rs39.getString("id")+"' "); rs40.execute("update uf_Leasecontract set deposit_state='"+have_Deposit+"' where id='"+rs39.getString("id")+"' ")