java´æ´¢¹ý³ÌµÄ´´½¨Óëµ÷ÓÃ

create or replace procedure updateProject is  
begin  
  update project p set p.total_intend_gather =   
  (select sum(ig.gather_sum) from intend_gather ig where ig.project_number=p.project_number);  
    
  update project p set p.total_actual_gather =   
  (select sum(ag.gahter_sum) from actual_gather ag where ag.project_number=p.project_number);  
    
  update project p set p.total_invoice=  
(select sum(invoice.invoice_sum) from invoice invoice  
 where invoice.intend_id in  
 (select ig.intend_id  from intend_gather ig where ig.project_number=p.project_number));  
   
end updateProject; 
Session session = this.getSession();  
Transaction tx =null;  
try {  
    tx = session.beginTransaction();  
    Connection con = session.connection();  
    String procedure = "{call updateproject() }";  
    CallableStatement cstmt = con.prepareCall(procedure);  
    cstmt.executeUpdate();  
    tx.commit();  
 
} catch (Exception e) {  
   tx.rollback();  
}