コード例 #1
0
  private RecordArticleStatAllTimeModel updateRecordArticleStatAllTime(
      RecordArticleStatAllTimeModel model) {

    String sql =
        "UPDATE recordarticlestatalltime SET  uniquevisitor=?, uniquevisitorarticleid=?,  uniquevisitorarticletitle=?, uniquevisitorarticleurl=?, pageview=?,"
            + "pageviewarticleid=?, pageviewarticletitle=?, pageviewarticleurl=?, visit=?, visitarticleid=?, visitarticletitle=?, visitarticleurl=?, site_id=? WHERE id = ?";

    jdbcTemplate.update(
        sql,
        model.getUniqueVisitor(),
        model.getUniqueVisitorArticleId(),
        model.getUniqueVisitorArticleTitle(),
        model.getUniqueVisitorArticleUrl(),
        model.getPageView(),
        model.getPageViewArticleId(),
        model.getPageViewArticleTitle(),
        model.getPageViewArticleUrl(),
        model.getVisit(),
        model.getVisitArticleId(),
        model.getVisitArticleTitle(),
        model.getVisitArticleUrl(),
        model.getSite().getId(),
        model.getId());

    return model;
  }
コード例 #2
0
  public RecordArticleStatAllTimeModel save(RecordArticleStatAllTimeModel model) {

    if (model.getId() != null) {
      return updateRecordArticleStatAllTime(model);
    } else {
      return addRecordArticleStatAllTimeModel(model);
    }
  }