java调用oracle的函数_Java调用Oracle函数

# re: Java调用Oracle函数 2013-05-12 15:02 wms

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

}

}

}

}

回复  更多评论