步骤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.function;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
public class Main {
public static void main (String[] args) throws Exception{
Class.forName("oracle.jdbc.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "SYS as sysdba", "root123");
CallableStatement call=conn.prepareCall("{? =call findClassinfoYearSal(?,?,?)}");
call.registerOutPa