9、DB2 Application Development with Java

github5actions

于 2025-12-02 15:05:05 发布

阅读量4

点赞数

CC 4.0 BY-SA版权

分类专栏： DB2应用开发实战指南文章标签： DB2 Java JDBC

本文链接：https://blog.youkuaiyun.com/github5actions/article/details/155937360

DB2应用开发实战指南专栏收录该内容

22 篇文章 ¥499.90

订阅专栏¥69.90

会员秒杀 ¥9.9 重磅福利

超级会员免费看

DB2 Application Development with Java

1. JDBC Application Development

1.1 Calling Stored Procedures with CallableStatement

A CallableStatement object can be used to call stored procedures. For example, to call the high_paid_employees stored procedure, the following code can be used:

CallableStatement cstmt;
// (1) Create the CallableStatement object to invoke the stored procedure
cstmt = con.prepareCall("call high_paid_employees(?)");
// (2) Set the input parameter
cstmt.setInt(1, 80000);
// (3) Execute the query and get the result set
ResultSet rs = cstmt.executeQuery();
System.out.println("High - paid employees list\n" +
                   "------------------------");
// (4) Loop