In JSP I want to print out my database entries with the newest first?

So basically at the moment I have them printing out in order from first to last, so the oldest entries actually get printed out first. I am looking to print out the last entries first.

The ResultSet I am working with is SELECT * FROM ARTICLE.

With each entry I am printing out there are multiple fields so I am unable to just put each entry into an array.

Any ideas on how to print the entries out in the reverse order. Is there a variation on rs.next() or something?

Order them in the DB query. Instead of

SELECT * FROM ARTICLE

Use something like

SELECT * FROM ARTICLE ORDER BY Date DESC

If you don't have a Date column use what ever column denotes when it went into the database. If you have an auto-increment value, that will work. The DESC keyword makes it work in descending order. This way you don't have to change the logic in your code, the recordset object will have the data in the right order already, so when you .next() through it, it'll be in reverse order from newest to oldest.

Just so you're aware of it, the order in which records are stored in a database is not guaranteed, so the most recent entry can be the first one physically, the last one or somewhere in the middle. That's why you need the ORDER BY clause, and a field to order by.