Connection conn = session.connection();
ResultSet rs = null;
PreparedStatement ps = null;
sql.append("SELECT PACKINFO.OTHERS_REQ REQTEXT ");
sql.append("FROM MTG_CUST_PACK_INFO PACKINFO ");
sql.append("WHERE PACKINFO.INST_TYPE='PKG' ");
sql.append("AND PACKINFO.PKEY= :packPtr ");
ps = conn.prepareStatement(sql.toString());
ps.setString(1,packPtr);
rs = ps.executeQuery();
Clob clob = null;
String reqText = "";
if(rs.next()){
clob = (oracle.sql.CLOB) rs.getClob("REQTEXT"); // 获得CLOB字段信息
reqText = resolveClob(clob);
}
ps.close();
conn.close();
public String resolveClob(Clob clob) {
String str = "";
try{
if(clob!=null){
Reader is = clob.getCharacterStream();// 得到流
BufferedReader br = new BufferedReader(is);
String s = br.readLine();
StringBuffer sb = new StringBuffer();
while (s != null) {//
sb.append(s);
s = br.readLine();
}
str = sb.toString();
}
}catch(Exception e){
e.printStackTrace();
}
return str;
}