Exemplo n.º 1
0
  private Shred populateShred(Shred shred) {
    // int ownerId = shred.getOwner().getId();
    // shred.setOwner(jdbcTemplate.queryForObject(
    // ShredderDAOImpl.GET_SHREDDER_BY_ID,
    // new Object [] {ownerId}, new ShredderMapper()
    // ));

    // Set rating
    String ratesql = "SELECT * FROM Rating WHERE ShredId=" + shred.getId();
    ShredRating rating =
        jdbcTemplate.queryForObject(
            ratesql, new BeanPropertyRowMapper<ShredRating>(ShredRating.class));
    shred.setRating(rating);
    shred.setShredComments(this.getShredCommentsForShredWithId(shred.getId()));
    // Set tags
    shred.setTags(this.getTagsForShredWithId(shred.getId()));
    return shred;
  }
Exemplo n.º 2
0
  public int persistShred(final Shred shred) {

    // Persist shred
    long t1 = System.currentTimeMillis();

    final String sql = "INSERT INTO Shred VALUES (DEFAULT,?,?,?,?,?,?)";
    KeyHolder keyHolder = new GeneratedKeyHolder();
    jdbcTemplate.update(
        new PreparedStatementCreator() {
          public PreparedStatement createPreparedStatement(Connection connection)
              throws SQLException {
            PreparedStatement ps = connection.prepareStatement(sql, new String[] {"id"});
            ps.setString(1, shred.getDescription());
            ps.setLong(2, shred.getOwner().getId());
            ps.setDate(3, shred.getTimeCreated());
            ps.setString(4, shred.getVideoPath());
            ps.setString(5, shred.getShredType());
            ps.setString(6, shred.getThumbnailpath());
            return ps;
          }
        },
        keyHolder);

    shred.setId((Integer) keyHolder.getKey());

    // Persist tags
    String insertTag = "INSERT INTO TagsForShred VALUES (?,?)";
    ;
    if (shred.getTags() != null) {
      for (Tag t : shred.getTags()) {
        this.jdbcTemplate.update(insertTag, shred.getId(), t.getId());
      }
    }

    // insert rating for this shred
    jdbcTemplate.update("INSERT INTO Rating VALUES(?, DEFAULT, DEFAULT)", shred.getId());

    System.out.println("Persist shred: " + (System.currentTimeMillis() - t1));
    logger.info("Persist shred: " + (System.currentTimeMillis() - t1));

    return shred.getId();
  }