选择插入

INSERT INTO FIN_COA_POSTED (DEBIT_AMOUNT,CREDIT_AMOUNT)
SELECT DEBIT_AMOUNT+__amount,CREDIT_AMOUNT FROM FIN_COA_POSTED WHERE  
ID =(SELECT MAX(ID)  FROM FIN_COA_POSTED WHERE FK_CHART_OF_ACCOUNT=5);

使用Select更新

UPDATE fin_bank_account AS t1 JOIN 
(SELECT ID, BALANCE+__amount AS totalamount FROM fin_bank_account WHERE     
ID=7) 
AS t2 ON t1.id =t2.id 
SET  t1.balance =t2.totalamount;

注意

( IN __amount DOUBLE)

我们可以在hiberante中编写相应的HQL吗？请更新。谢谢