步骤1:
在eclipse或myeclipse创建Java项目;
步骤2:
获取jar包,将加载到项目中。
存储空间\app\OracleWorkSapce\product\11.2.0\dbhome_1\jdbc\lib,选择 “ojdbc6_g.jar”,将其复制到eclipse的项目的lib中,然后选中 ,右键——>选择 Build Path ——>Configure Build Path...
步骤3:
Java代码如下:
package cn.itcast.procedure;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
public class Main {
public static void main(String[] args) throws Exception{
/**
* mysql:
* com.mysql.jdbc.Driver
* jdbc:mysql//localhost
* root
* root
*
* Oracle
* oracle.jdbc.OracleDriver
* jdbc:oracle:thin:@localhost:1521:orcl
* SCOTT
* digger*/
//1.定义变量
String driverClass="oracle.jdbc.OracleDriver";
String url="jdbc:oracle:thin:@localhost:1521:orcl";
String user="SCOTT";
String psw="digger";
//加载驱动
Class.forName(driverClass);
//2.获取连接对象
Connection conn = DriverManager.getConnection(url,user,psw);
//3.创建执行存储过程的语句对象
String sql="{call SYS.FINDINFO(?,?,?)}";
CallableStatement call = conn.prepareCall(sql);
//4.设置参数
call.setString(1, "002");
call.registerOutParameter(2, oracle.jdbc.OracleTypes.VARCHAR);
call.registerOutParameter(3, oracle.jdbc.OracleTypes.NUMBER);
//5.执行
call.execute();
//6.获取数据
String v_name=call.getString(2);
Integer v_salary=call.getInt(3);
System.out.println("员工名为:"+v_name+",工资是:"+v_salary);
//7.释放资源
call.close();
conn.close();
}
}