jdbcÖе÷ÓÃoracleº¯Êý

1¡¢´´½¨±í
 create table stud(
 sid int,
 sname varchar2(50),
 age number,
 score number(4,2))
²¢²åÈëһЩÊý¾Ý£¨×Ô¼ºÊÖ¶¯²åÈëһЩ°É£©
2¡¢´´½¨º¯Êý
create or replace function fun_getScores(
       v_age in stud.age%type
)
return number
is
       v_score number;
begin
      
       select sum(score) into v_score from stud where age > v_age;
       return v_score;
      
--Òì³£´¦Àí
exception
       when others then
       dbms_output.put_line(sqlcode||sqlerrm);
       return -1;
end;
3¡¢jdbcÖе÷ÓÃ
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.Types;
public class TestFun {
 public void test(){
 
  Connection con = null;
  Statement st = null;
  ResultSet rs = null;
  CallableStatement cst = null;
  try{
   Class.forName("oracle.jdbc.driver.OracleDriver");
   //ÏÂÃæµÄtanÊÇÊý¾Ý¿âÃû£¬Ä¬ÈÏÊÇorcl£¬loveÊÇ·ÃÎÊÃÜÂ룬ĬÈÏÊÇtiger,
          //1521ÊǶ˿ںţ¬Ä¬ÈÏÊÇ1521
   con = DriverManager.getConnection
("jdbc:oracle:thin:@192.168.1.103:1521:tan","scott","love");
   String sql =  "{? = call fun_getScores(?)}";
   cst = con.prepareCall(sql);
   cst.registerOutParameter(1, Types.NUMERIC);
   cst.setDouble(2, 2);
   cst.execute();
   double result = cst.getDouble(1);
   
   System.out.println("ÄêÁ䳬¹ý2ËêѧÉúµÄ³É¼¨×ÜºÍ "+result);
  }catch(Ex