java存储过程的创建与调用

最新推荐文章于 2022-09-09 09:32:57 发布

maypol

最新推荐文章于 2022-09-09 09:32:57 发布

阅读量441

点赞数

分类专栏： java 文章标签： java 存储 exception session string null

本文链接：https://blog.csdn.net/maypol/article/details/5371485

版权

java 专栏收录该内容

18 篇文章 0 订阅

订阅专栏

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();
}