//演示java程序去调用orcale存储过程
package com.hl;
import java.sql.*;
public class TestOraclePro {
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection ct=null;
CallableStatement cs=null;
//加载驱动
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
ct=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:MYORA1","scott","tiger");
//创建CallableStatement
cs=ct.prepareCall("{call sp_pro3(?,?)}");
//给?赋值
cs.setString(1, "SMITH");
cs.setInt(2, 22);
//执行
cs.execute();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally
{
//关闭资源
try {
cs.close();
ct.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
java程序去调用orcale存储过程
最新推荐文章于 2021-04-15 03:22:35 发布