update and delete query

Update Query 

@Modifying

@Transactional

@Query("update CreateCustomer u set u.paid=:paid where u.id=:id")

public void UpdatePaidInCreateCustomer(@Param("paid") float paid,@Param("id") long id) ;

------------------------------------------------------------------------------

@Modifying

@Transactional

@Query("update CreateCustomer u set u.cgst=:cgst, u.sgst=:sgst,u.igst=:igst, u.otherCharges=:otherCharges, u.totalAmount=:totalAmount,u.paid=:paid,u.discount=:discount,u.remark=:remark,u.pmtMode=:pmtMode,u.recipt=:recipt  where u.CusRefid = :CusRefid")

public void updateTaxCGST(@Param("cgst") float cgst , @Param("sgst") float sgst , @Param("igst") float igst ,@Param("otherCharges") float otherCharges , @Param("totalAmount") float totalAmount,@Param("paid") float paid,@Param("discount") float discount,@Param("remark") String remark,

@Param("pmtMode") String pmtMode,@Param("recipt") String recipt,@Param("CusRefid") long CusRefid);


Delete Query (delete all same type item once)


@Transactional

@Modifying

@Query("delete from CreateBill2 b where b.cusrefid in(:integers)")

public void deleteBill2(List<Long> integers);

Comments