jdbc调用存储过程

package cn.gz.hy;

 

importjava.sql.CallableStatement;

importjava.sql.Connection;

importjava.sql.DriverManager;

import java.sql.ResultSet;

 

public class Fun_demo1{

  public static voidmain(String[] args)throws Exception {

    // 1. 定义变量

         String driverClass = "oracle.jdbc.OracleDriver";

         String url = "jdbc:oracle:thin:@localhost:1521:wd";

         String user = "GZ";

         String psw = "123";

        

         Class.forName(driverClass);

        

         // 2. 获取连接对象

         Connection conn = DriverManager.getConnection(url,user, psw);

         // 3. 创建执行存储过程的语句对象

         String sql = "{callTest_fun(?,?,?)}";

         CallableStatement call =conn.prepareCall(sql);

        

         // 4. 设置参数

         call.setInt(1, 1);

         call.registerOutParameter(2,oracle.jdbc.OracleTypes.VARCHAR);

         call.registerOutParameter(3,oracle.jdbc.OracleTypes.VARCHAR);

        

         // 5. 执行

         call.execute();

         //ResultSetresultSet = call.executeQuery();

        

         //6. 获取数据

         String ename =call.getString(2);

         String durl = call.getString(3);

         System.out.println("员工名："+ename+"路径是："+durl);

        

         // 7. 释放资源

         call.close();

         conn.close();

  }

 

}