Example #1
0
 /**
  * Updates a playlist that is selected by ID.
  *
  * @param p the playlist to be updated.
  * @throws SQLException
  */
 public void update(Playlist p) throws SQLException {
   String sql = "" + "UPDATE Playlist " + "SET Name = ? " + "WHERE ID =" + p.getId();
   Connection con = dataSource.getConnection();
   PreparedStatement ps = con.prepareStatement(sql);
   ps.setString(1, p.getName());
   int affectedRows = ps.executeUpdate();
   if (affectedRows == 0) {
     throw new SQLException("Unable to update playlist.");
   }
 }
Example #2
0
  /**
   * Puts a new playlist-object on the server.
   *
   * @param p a given playlist-object.
   * @return the newly created playlist object.
   * @throws SQLException
   */
  public Playlist insert(Playlist p) throws SQLException {
    String sql = "" + "INSERT INTO Playlist (Name)" + "VALUES(?)";

    Connection con = dataSource.getConnection();
    PreparedStatement ps = con.prepareStatement(sql, PreparedStatement.RETURN_GENERATED_KEYS);
    ps.setString(1, p.getName());

    int affectedRows = ps.executeUpdate();
    if (affectedRows == 0) {
      throw new SQLException("Unable to insert playlist.");
    }

    ResultSet keys = ps.getGeneratedKeys();
    keys.next();
    int id = keys.getInt(1);

    return new Playlist(id, p);
  }