package com.stx.liuzhou;
//pl/sql编程——过程的应用
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
//
public class TestOraclePro {
public static void main(String[] args) {
try{
//1.加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//2.得到链接
Connection ct = DriverManager.getConnection("jdbc:oracle:thin@127.0.0.1:1521:ORCL","scott","m123");
//2.创建一个callableStaement
CallableStatement cs = ct.prepareCall("{call sp_pro3(?,?)}");
//给问号赋值
cs.setString(1, "SMITH");
cs.setInt(2, 10);
//执行
cs.execute();
cs.close();
}catch (Exception e){
e.printStackTrace();
}
}
}