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

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.:sad:

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

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

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

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

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

try with cusom tags