private static LinkedList<Video> videoListFromResultSet(ResultSet resultSet) throws SQLException {
        LinkedList<Video> videos = new LinkedList<Video>();
        while (resultSet.next()) {
            videos.add(new Video(resultSet.getString(1), resultSet.getString(2), resultSet.getDate(3),
                    resultSet.getString(4), resultSet.getString(5), resultSet.getDouble(6), resultSet.getInt(7),
                    Arrays.asList(resultSet.getString(8).split(",")), Arrays.asList(resultSet.getString(9).split(",")),
                    Arrays.asList(resultSet.getString(10).split(",")),
                    Arrays.asList(resultSet.getString(11).split(","))));
        }
        return videos;
    }