how can i take 1st record from database??

[chyeeqi]

how can i take 1st record from database??
i had try tis way

rsS = stmtS.executeQuery("SELECT * FROM Reception");
        if( rsS.next());
         {
        Rec_Name.setText(rsS.getString(1));
        }

but i get the last record in the databse, how can i get the 1st record

[Tolls]

There's no such thing as the "first record"...unless you put an "order by" in the query.

[r035198x]

Google "<Your database name> rownum"

[Tolls]

Still won't matter.
rownum is (usually) simply a tag onto a query. It's not a physical thing.
Consequently, as I said, the concept of "first record" is meaningless without an order by...there's no guarantee (in SQL) that you'll get the rows back in the same order for the next time you run the query.

So the OP needs to figure out why, exactly, the result returned by the db was wrong.

[RamyaSivakanth]

Hi,
You can use scrollable ResultSet....u can set the pointer to first record using

first() in ResultSet and then u can retreive.
-Regards
Ramya

[Tolls]

Which, first off, will return the same record that the first call to next() returns, which is apparently the wrong record, and secondly does not alter the fact that, once again, without an order by the question is meaningless.