package com;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Types;
public class TestProcedureOne {
public TestProcedureOne() {
}
public static void main(String[] args) {
String driver = "oracle.jdbc.driver.OracleDriver";
String strUrl = "jdbc:oracle:thin:@localhost:1521:orcl";
Connection conn = null;
CallableStatement cstmt = null;
try {
Class.forName(driver);
conn = DriverManager.getConnection(strUrl, "wms", "wms");
cstmt = conn.prepareCall("{?=call add_three_numbers(?,?,?)}");
cstmt.registerOutParameter(1, Types.INTEGER);
cstmt.setInt(2,4);
cstmt.setInt(3,5);
cstmt.setInt(4,6);
cstmt.execute();
System.out.println("調用函數add_three_numbers:"+cstmt.getInt(1));
} catch (SQLException ex2) {
ex2.printStackTrace();
} catch (Exception ex2) {
ex2.printStackTrace();
}
finally {
try {
if (cstmt != null) {
cstmt.close();
if (conn != null) {
conn.close();
}
}
} catch (SQLException e) {
System.out.println("SQL state" + e.getSQLState());
System.out.println("錯誤消息" + e.getMessage());
System.out.println("錯誤代碼" + e.getErrorCode());
e.printStackTrace();
}
}
}
}
回復 更多評論