jdbc调用Oracle存储过程获取查询结果

oracle存储过程：

create or replace procedure getcar(result out sys_refcursor)
as
begin
open result for
    select * from  car_message; 
end getcar;

jdbc调用方法：

    try {
        Class.forName("oracle.jdbc.driver.OracleDriver");
    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    }
    try {  con=DriverManager.getConnection("jdbc:oracle:thin:@192.176.0.1:1521:orcl","test","123456");//这里ip地址需要变成自己的

        String procedure="{call getcar(?)}";
        CallableStatement cstmt=con.prepareCall(procedure);
        cstmt.registerOutParameter(1, OracleTypes.CURSOR);
        cstmt.execute();
        ResultSet rs=(ResultSet)cstmt.getObject(1);

/*       
将数据封装到列表（需要自己写bean类的car对象 和定义clist列表）
 while(rs.next())
        {
            int cmid=rs.getInt("id");
           String cname=rs.getString("cname");
          String ctext=rs.getString("ctext");
    
           Car tl=new Car(cmid,cname,ctext);
            clist.add(tl);   
        }
*/