oracle取游标结果集,通过游标读取oracle存储过程返回的结果集

public JhSkyZgTkRequest getTsthsDate() {

//  Session session = this.getSessionFactory().openSession();

Connection conn = null;

JhSkyZgTkRequest jhSkyZgTkRequest = new JhSkyZgTkRequest();

ResultSet rs = null;

CallableStatement st = null;

PlTkItem plTkItem = null;

try {

conn = newOracleConn.getOracleConn();

String proc = "{call PKG_RTN_CURSOR.SKY_Get_tsths(?)}";

st = conn.prepareCall(proc);

st.registerOutParameter(1,oracle.jdbc.OracleTypes.CURSOR);

st.execute();

StringBuffer sb = new StringBuffer();

rs=(ResultSet)   st.getObject(1);

while (rs.next()) {

plTkItem = new PlTkItem();

plTkItem.setTkpzHm(rs.getString("tkpzHm"));

plTkItem.setYxtsphm(rs.getString("yxtsphm"));

plTkItem.setYshm(rs.getString("yshm"));

String date = rs.getString("kprq");

date = date.substring(0, 10);

date = date.replaceAll("-", "");

plTkItem.setKprq(date);

plTkItem.setKpje(rs.getDouble("kpje"));

plTkItem.setZsjgDm(rs.getString("zsjgdm"));

plTkItem.setZsjgQc(rs.getString("zsjgqc"));

plTkItem.setTkgkDm(rs.getString("tkgkdm"));

plTkItem.setTkgkMc(rs.getString("tkgkmc"));

plTkItem.setSpzlDm(rs.getString("spzldm"));

plTkItem.setSpzlMc(rs.getString("spzlmc"));

plTkItem.setNsrsbh(rs.getString("nsrsbh"));

plTkItem.setNsrmc(rs.getString("nsrmc"));

plTkItem.setYhzlDm(rs.getString("yhzldm"));

plTkItem.setSkkhhhh(rs.getString("skkhhhh"));

plTkItem.setSkkhhMc(rs.getString("skkhhmc"));

plTkItem.setYskmDm(rs.getString("yskmdm"));

plTkItem.setYskmMc(rs.getString("yskmmc"));

plTkItem.setYsfpblDm(rs.getString("ysfpblDm"));

plTkItem.setYsfpblMc(rs.getString("ysfpblmc"));

plTkItem.setYszl(rs.getString("yszl"));

plTkItem.setYsjcDm(rs.getString("ysjcdm"));

plTkItem.setZlqbz(rs.getString("zlqbz"));

plTkItem.setFzbz(rs.getString("fzbz"));

plTkItem.setTbyyDm(rs.getString("tbyydm"));

plTkItem.setTkyyMc(rs.getString("tkyymc"));

plTkItem.setTkyj(rs.getString("tkyj"));

plTkItem.setSpjg(rs.getString("spjg"));

plTkItem.setPzwh(rs.getString("pzwh"));

plTkItem.setZzlx(rs.getString("zzlx"));

plTkItem.setZsxmDm(rs.getString("zsxmdm"));

plTkItem.setZsxmMc(rs.getString("zsxmmc"));

plTkItem.setZspmDm(rs.getString("zspmdm"));

plTkItem.setZspmMc(rs.getString("zspmmc"));

plTkItem.setTtse(rs.getDouble("ttse"));

plTkItem.setTkbz(rs.getString("tkbz"));

plTkItem.setQdDm(rs.getString("qddm"));

plTkItem.setSkrmc(rs.getString("skrmc"));

plTkItem.setSkrzh(rs.getString("skrzh"));

jhSkyZgTkRequest.addPlTkItem(plTkItem);

sb.append(plTkItem.toString());

}

conn.commit();

log.info("调用存储过程:SKY_Get_tsths()获取数据为"

+ jhSkyZgTkRequest.getPlTkItem().size() + "条.每条记录信息如下："

+ sb.toString());

} catch (Exception e) {

try {

conn.rollback();

} catch (SQLException e1) {

e1.printStackTrace();

}

log.error("调用存储过程:SKY_Get_tsths()发生错误,错误信息如下:" + e.getMessage());

e.printStackTrace();

} finally {

try {

if (st != null)

st.close();

if (conn != null)

conn.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

return jhSkyZgTkRequest;