@Override public int create(LinkCrawled linkCrawled) throws SQLException { if (linkCrawled.getLink() == null) { return -1; } // If the time crawled is not specified, use the current time if (linkCrawled.getTimeCrawled() == null || linkCrawled.getDateCrawled() == null) { linkCrawled.setTimeCrawled(Helper.getCurrentTime()); linkCrawled.setDateCrawled(Helper.getCurrentDate()); } Connection connection = null; PreparedStatement preparedStatement = null; ResultSet resultSet = null; try { connection = this.daoFactory.getConnection(); final Object[] values = { linkCrawled.getLink(), linkCrawled.get_originalLink(), linkCrawled.getPriority(), linkCrawled.getDomainTableId1(), linkCrawled.get_downloadDuration(), linkCrawled.get_extractedTime(), linkCrawled.get_httpStatusCode(), linkCrawled.get_relevance(), linkCrawled.get_distanceFromRelevantPage(), linkCrawled.get_freshness(), linkCrawled.getTimeCrawled(), linkCrawled.getDateCrawled() }; preparedStatement = DAOUtil.prepareStatement(connection, this.SQL_INSERT, true, values); preparedStatement.executeUpdate(); // Get the generated key (id) resultSet = preparedStatement.getGeneratedKeys(); int generatedKey = -1; if (resultSet.next()) { generatedKey = resultSet.getInt(1); } return generatedKey; } catch (final SQLException e) { LOG.error("Insert into link_crawled_table fails, " + e.getMessage()); return -1; } finally { DAOUtil.close(connection, preparedStatement, resultSet); } }
private LinkCrawled constructLinkCrawledObject(ResultSet resultSet) throws SQLException { final LinkCrawled linkCrawled = new LinkCrawled(); linkCrawled.setId(resultSet.getInt("id")); if (resultSet.wasNull()) { linkCrawled.setId(null); } linkCrawled.setLink(resultSet.getString("link")); if (resultSet.wasNull()) { linkCrawled.setLink(null); } linkCrawled.set_originalLink(resultSet.getString("originalLink")); if (resultSet.wasNull()) { linkCrawled.set_originalLink(null); } linkCrawled.setPriority(resultSet.getInt("priority")); if (resultSet.wasNull()) { linkCrawled.setPriority(null); } linkCrawled.setDomainTableId1(resultSet.getInt("domain_table_id_1")); if (resultSet.wasNull()) { linkCrawled.setDomainTableId1(null); } linkCrawled.set_downloadDuration(resultSet.getLong("download_duration")); if (resultSet.wasNull()) { linkCrawled.set_downloadDuration(null); } linkCrawled.set_extractedTime(resultSet.getLong("extracted_time")); if (resultSet.wasNull()) { linkCrawled.set_extractedTime(null); } linkCrawled.set_httpStatusCode(resultSet.getInt("statusCode")); if (resultSet.wasNull()) { linkCrawled.set_httpStatusCode(null); } linkCrawled.set_relevance(resultSet.getLong("relevance")); if (resultSet.wasNull()) { linkCrawled.set_relevance(null); } linkCrawled.set_distanceFromRelevantPage(resultSet.getLong("distanceFromRelevantPage")); if (resultSet.wasNull()) { linkCrawled.set_distanceFromRelevantPage(null); } linkCrawled.set_freshness(resultSet.getInt("freshness")); if (resultSet.wasNull()) { linkCrawled.set_freshness(null); } linkCrawled.setTimeCrawled(resultSet.getString("time_crawled")); if (resultSet.wasNull()) { linkCrawled.setTimeCrawled(null); } linkCrawled.setDateCrawled(resultSet.getString("date_crawled")); if (resultSet.wasNull()) { linkCrawled.setDateCrawled(null); } return linkCrawled; }