public CrawlResource getCrawlResourceDetail(Long resId) {
CrawlResource resource = null;
Connection conn = null;
PreparedStatement pst = null;
ResultSet rs = null;
String sql =
" select a.res_id,a.channel_id,a.res_title,a.res_link,a.res_content,a.res_text,to_char(a.create_time,'yyyy-mm-dd hh24:mi:ss') create_time,a.res_status,a.res_img_path_set,a.res_file_path_set from twap_public_crawl_resource a where a.res_id = ? ";
try {
conn = JavaOracle.getConn();
pst = conn.prepareStatement(sql);
pst.setLong(1, resId);
rs = pst.executeQuery();
if (rs.next()) {
Clob clob = rs.getClob("res_text");
Reader inStream = clob.getCharacterStream();
char[] c = new char[(int) clob.length()];
inStream.read(c);
// data是读出并需要返回的数据，类型是String
String data = new String(new String(c).getBytes(), "GBK");
inStream.close();
resource = new CrawlResource();
resource.setChannelId(rs.getLong("channel_id"));
resource.setContent(data);
resource.setCreateTime(rs.getString("create_time"));
resource.setLink(rs.getString("res_link"));
resource.setResId(rs.getLong("res_id"));
resource.setStatus(rs.getString("res_status"));
resource.setTitle(rs.getString("res_title"));
resource.setImgPathSet(rs.getString("res_img_path_set"));
resource.setFilePathSet(rs.getString("res_file_path_set"));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
close(conn, pst, rs);
}
return resource;
}
