create or replace procedure ProcTestNew(v_monitordeviceid in number,curdata out sys_refcursor )

As

begin

  open curdata for

 select ID, IP,PORT from T_MONITOR_DEVICE where id=v_monitordeviceid;--带参数测试

  -- select ID, IP,PORT from T_MONITOR_DEVICE;

end ProcTestNew;

public void TestProc()

    {

         Connection conn=null;

         ResultSet rs=null;

          try {

              //this.getSession()为hibernate中的Session对象

            conn = SessionFactoryUtils.getDataSource(this.getSession().getSessionFactory()).getConnection();

              CallableStatement   proc = conn.prepareCall("{call ProcTestNew(?,?) }");

              BigDecimal b1 = new BigDecimal(1176);

                proc.setBigDecimal(1, b1);

                proc.registerOutParameter(2, OracleTypes.CURSOR);

                 proc.execute();

                  rs = (ResultSet) proc.getObject(2);

                  MonitorDevice m=new MonitorDevice();

                  while(rs != null && rs.next())

                  {

                      m.setId(Integer.valueOf(rs.getObject(1).toString()));

                      m.setIp((String)rs.getObject(2));

                       m.setPort((String)rs.getObject(3));

                       System.out.println(m.getId()+","+m.getIp()+","+m.getPort());

                  }

        } catch (SQLException e) {

            // TODO Auto-generated catch block

            e.printStackTrace();

        } 

    }