Guest User

Untitled

a guest
May 24th, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.91 KB | None | 0 0
  1. /* Some code */
  2.  
  3. stmtExtractSession = db.prepareStatement(
  4. "SELECT session_id, step, pg_desc, resp_body, session_log.tstamp as tstamp " +
  5. "FROM session_log INNER JOIN sessions " +
  6. "ON (session_id = id) " +
  7. "WHERE s_id = ?;");
  8.  
  9. /* Some code */
  10.  
  11. public void processFeature(String s_id, Feature feature)
  12. throws SQLException
  13. {
  14. stmtExtractSession.setString(1, s_id);
  15.  
  16. Logger log = WebCrawler.getLog();
  17. OptParser opts = WebCrawler.getOpts();
  18.  
  19. ResultSet rs = stmtExtractSession.executeQuery();
  20.  
  21. try {
  22. while (rs.next()) {
  23. feature.calculate(rs.getString("resp_body"));
  24.  
  25. log.log(Level.INFO,
  26. "Calculating feature " + feature.getName() +
  27. " for site " + s_id +
  28. " for row/session " + rs.getLong("session_id") +
  29. " and page " + rs.getString("pg_desc") +
  30. " at step " + rs.getInt("step") +
  31. " crawled on " + rs.getTimestamp("tstamp").toString() +
  32. ", value: " + feature.toString(),
  33. LOG_ID);
  34.  
  35. if (!opts.getTesting())
  36. insertFeature(feature, rs.getLong("session_id"), rs.getInt("step"));
  37. }
  38.  
  39. } finally {
  40. if (rs != null)
  41. rs.close();
  42. }
  43.  
  44. }
Add Comment
Please, Sign In to add comment