java调用有返回值的oracle存储过程

来源:互联网 发布:棋牌源码 编辑:程序博客网 时间:2024/05/05 23:20
Class.forName("oracle.jdbc.driver.OracleDriver");
    Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.131:1521:oral","1","1");
    CallableStatement call = conn.prepareCall("{call pro_Se(?)}");
    call.registerOutParameter(1,  Types.VARCHAR);
    call.execute();
    String rs = (String) call.getString(1);
    System.out.println(rs);