TestProc(25)

最新推荐文章于 2022-06-06 21:13:01 发布

翻译最新推荐文章于 2022-06-06 21:13:01 发布 · 346 阅读

文章标签：

#jdbc #JDBC #Jdbc #PROC #Proc

JDBC 专栏收录该内容

10 篇文章

订阅专栏

/**
*Title:TestProc
*Description:
*@Copyright:
*@Company:
*@autor:firefly
*@version:1.0
*@time:2012.10.30
*/

import java.sql.*;

public class TestProc {
public static void main(String [] args) {
  CallableStatement cstmt = null;
  Connection conn = null;
  try {
   Class.forName("oracle.jdbc.driver.OracleDriver");
   conn = DriverManager.getConnection("jdbc:oracle:thin:@122.207.171.222:1521:ORCL", "scott", "tiger");
   cstmt = conn.prepareCall("{call p(?, ?, ?, ?)}");
   cstmt.registerOutParameter(3, Types.INTEGER);
   cstmt.registerOutParameter(4, Types.INTEGER);
   cstmt.setInt(1, 3);
   cstmt.setInt(2, 4);
   cstmt.setInt(4, 5);
   cstmt.execute();
   System.out.println(cstmt.getInt(3));
   System.out.println(cstmt.getInt(4));
  } catch(ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException e) {
   e.printStackTrace();
  } finally {
   try {
    cstmt.close();
    conn.close();
   } catch (SQLException e) {
    e.printStackTrace();
   }
  }

}
}