Printing the all the sorted field values in a mysql column ( in java) -
i have table this
+-----------+-------------+ | attribute | score | +-----------+-------------+ | camera | 0.0819958 | | display | 0.327983 | | model | 0.70521 | | ram | 0.000304832 | +-----------+-------------+
i want sort attributes according score , want print of them. when execute below code 1 value. please help.
string tb = "select attribute qvtemp order score desc "; statement = con.getconnection().preparestatement(tb); resultset rs5 = statement.executequery(); string g = null; while (rs5.next()) { g = rs5.getstring(1); } system.out.println(g);
change following from:
while (rs5.next()) { g = rs5.getstring(1); } system.out.println(g);
to
while (rs5.next()) { g = rs5.getstring(1); system.out.println(g);//bring in loop }
Comments
Post a Comment