Home.... | log in.... | Pub my question! | Sign-up....

Java-index >> Java Essentials >> Training

storing the more dan 1 rows retrieved from database in java

hii want to store the rows retrieved from the database into my java prog.there are more dan 1 rows.how can i do dat using resultset?can anybody help me with an exampleregardsambika

[222 byte] By [ambika_mullasseria] at [2007-11-27 8:48:39]

«« Reverse String
»» determing the socket factory currently used

# 1

May be following code help u....

List lstStroeData = new arrayList();

ResultSet rs = stmt.executeQuery(selectQuery);

while (rs.next()) {

Object obj = new Object();

obj .setattribute1(rs.getString(1));

obj .setattribute2(rs.getString(2));

obj .setattribute3(rs.getString(3));

obj .setattribute4(rs.getInt(4));

lstStroeData.add(obj);

}

lstStroeData will have all rows fetched from database.

Enjoy codding,

Brijesh

brijesha at 2007-7-12 20:56:13 >

top of Java-index,Java Essentials,Training...

Java Essentials New Topic

Java Essentials Hot Topic