コード例 #1
0
 /*
  * Save Artwork
  *
  * @param Object Artwork
  */
 public void save(Artwork artwork) {
   if (checkIsThere(artwork.getId()) != 0) {
     update(artwork);
   } else {
     add(artwork);
   }
 }
コード例 #2
0
  /*
   * Update Artwork
   *
   * @param Object Artwork
   */
  private void update(Artwork artwork) {

    if (artwork.getGroupTitle() == null) {
      artwork.setGroupTitle("Unknow Title");
    }

    if (artwork.getThumbnailUrl() == null) {
      artwork.setThumbnailUrl(
          "http://torontoist.com/wp-content/uploads/2011/11/missing-art-640x479.jpg");
    }

    String sql = "UPDATE artwork SET title = ?, group_title = ?, thumbnail_url = ? WHERE id = ?";
    jdbcTemplate.update(
        sql,
        new Object[] {
          artwork.getTitle(), artwork.getGroupTitle(), artwork.getThumbnailUrl(), artwork.getId()
        });
  }
コード例 #3
0
  /*
   * Add Artist
   *
   * @param Object Artwork
   */
  public void add(Artwork artwork) {

    if (artwork.getGroupTitle() == null) {
      artwork.setGroupTitle("Unknown Title ");
    }

    if (artwork.getThumbnailUrl() == null) {
      artwork.setThumbnailUrl(
          "http://torontoist.com/wp-content/uploads/2011/11/missing-art-640x479.jpg");
    }

    String sql = "INSERT INTO artwork (id, title, group_title,thumbnail_url) VALUES (?,?,?,?)";
    jdbcTemplate.update(
        sql,
        new Object[] {
          artwork.getId(), artwork.getTitle(), artwork.getGroupTitle(), artwork.getThumbnailUrl()
        });

    System.out.println("Artwork Saved");
  }