Exemplo n.º 1
0
 public SiteInternal find(URL siteURL) {
   SiteInternal site = null;
   Statement st = null;
   ResultSet rs = null;
   try {
     Connection c = dbUtil.getConnection();
     st = c.createStatement();
     rs =
         st.executeQuery(
             "select * from jspider_site where host = '"
                 + siteURL.getHost()
                 + "' and port = "
                 + siteURL.getPort());
     if (rs.next()) {
       site = createSiteFromRecord(rs);
     } else {
       return null;
     }
   } catch (SQLException e) {
     log.error("SQLException", e);
   } finally {
     dbUtil.safeClose(rs, log);
     dbUtil.safeClose(st, log);
   }
   return site;
 }
Exemplo n.º 2
0
 public void save(int id, SiteInternal site) {
   StringBuffer sb = new StringBuffer();
   Connection connection = dbUtil.getConnection();
   Statement st = null;
   sb.append("update jspider_site set ");
   sb.append("handle=");
   sb.append(DBUtil.format(site.mustHandle()));
   sb.append(",robotstxthandled=");
   sb.append(DBUtil.format(site.isRobotsTXTHandled()));
   sb.append(",usecookies=");
   sb.append(DBUtil.format(site.getUseCookies()));
   sb.append(",useproxy=");
   sb.append(DBUtil.format(site.getUseProxy()));
   sb.append(",state=");
   sb.append(DBUtil.format(site.getState()));
   sb.append(",obeyrobotstxt=");
   sb.append(DBUtil.format(site.getObeyRobotsTXT()));
   sb.append(",basesite=");
   sb.append(DBUtil.format(site.isBaseSite()));
   sb.append(",useragent=");
   sb.append(DBUtil.format(site.getUserAgent()));
   sb.append(" where id = ");
   sb.append(DBUtil.format(id));
   try {
     st = connection.createStatement();
     st.executeUpdate(sb.toString());
   } catch (SQLException e) {
     log.error("SQLException", e);
   } finally {
     dbUtil.safeClose(st, log);
   }
 }
Exemplo n.º 3
0
 public void create(int id, SiteInternal site) {
   Connection connection = dbUtil.getConnection();
   Statement st = null;
   StringBuffer sb = new StringBuffer();
   sb.append("insert into jspider_site (");
   sb.append("id,");
   sb.append("host,");
   sb.append("port,");
   sb.append("handle,");
   sb.append("robotstxthandled,");
   sb.append("usecookies,");
   sb.append("useproxy,");
   sb.append("state,");
   sb.append("obeyrobotstxt,");
   sb.append("basesite,");
   sb.append("useragent");
   sb.append(") values (");
   sb.append(DBUtil.format(id));
   sb.append(",");
   sb.append(DBUtil.format(site.getHost()));
   sb.append(",");
   sb.append(DBUtil.format(site.getPort()));
   sb.append(",");
   sb.append(DBUtil.format(site.mustHandle()));
   sb.append(",");
   sb.append(DBUtil.format(site.isRobotsTXTHandled()));
   sb.append(",");
   sb.append(DBUtil.format(site.getUseCookies()));
   sb.append(",");
   sb.append(DBUtil.format(site.getUseProxy()));
   sb.append(",");
   sb.append(DBUtil.format(site.getState()));
   sb.append(",");
   sb.append(DBUtil.format(site.getObeyRobotsTXT()));
   sb.append(",");
   sb.append(DBUtil.format(site.isBaseSite()));
   sb.append(",");
   sb.append(DBUtil.format(site.getUserAgent()));
   sb.append(")");
   try {
     st = connection.createStatement();
     st.executeUpdate(sb.toString());
   } catch (SQLException e) {
     log.error("SQLException", e);
   } finally {
     dbUtil.safeClose(st, log);
   }
 }
Exemplo n.º 4
0
 public SiteInternal[] findAll() {
   ArrayList al = new ArrayList();
   Statement st = null;
   ResultSet rs = null;
   try {
     Connection c = dbUtil.getConnection();
     st = c.createStatement();
     rs = st.executeQuery("select * from jspider_site");
     while (rs.next()) {
       al.add(createSiteFromRecord(rs));
     }
   } catch (SQLException e) {
     log.error("SQLException", e);
   } finally {
     dbUtil.safeClose(rs, log);
     dbUtil.safeClose(st, log);
   }
   return (SiteInternal[]) al.toArray(new SiteInternal[al.size()]);
 }