Oracle

retrieve data from database into jsp(urgent)!!!

Please support our Oracle advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Sep 2006

Posts: 1

Reputation: aditi19mitra is an unknown quantity at this point

Solved Threads: 0

aditi19mitra aditi19mitra is offline

Offline

Newbie Poster

retrieve data from database into jsp(urgent)!!!

Oct 14th, 2006

hi guys,
i'm doin a prjct in which i've used oracle9i @ backend n jsp @frontend.can u tell me how do i retrieve the data back from the database to the jsp.i've successfully inserted d values but i'm clueless as to how to get it back in the proper order.

•

Join Date: Jan 2007

Posts: 6

Reputation: sandeep0708 is an unknown quantity at this point

Solved Threads: 0

sandeep0708 sandeep0708 is offline

Offline

Newbie Poster

Re: retrieve data from database into jsp(urgent)!!!

Jan 12th, 2007

•

Originally Posted by aditi19mitra

hi guys,
i'm doin a prjct in which i've used oracle9i @ backend n jsp @frontend.can u tell me how do i retrieve the data back from the database to the jsp.i've successfully inserted d values but i'm clueless as to how to get it back in the proper order.

this is simple u have to make a onject of Resultset and then access the value retrieved by object.next();......might this will work

•

Join Date: Jan 2007

Posts: 30

Reputation: Memento is an unknown quantity at this point

Solved Threads: 0

Memento

Offline

Light Poster

Re: retrieve data from database into jsp(urgent)!!!

Jan 14th, 2007

•

Originally Posted by aditi19mitra

hi guys,
i'm doin a prjct in which i've used oracle9i @ backend n jsp @frontend.can u tell me how do i retrieve the data back from the database to the jsp.i've successfully inserted d values but i'm clueless as to how to get it back in the proper order.

To get the results in the correct order you can add an ORDER BY clause to your query. DESC stands for descending which will start with the hightest values first.

SELECT t.col_1, t.col_2, t.date_col
FROM some_table t
WHERE t.col_1 = ‘something’
ORDER BY t.date_col DESC