manipulate ResultSet 1

[dekcool]

hi good day!

iam new with Java, please give me some idea on how can i get the records using ResultSet.

any inputs will gladly appreciate, thanks in advance

____________________________________________________
Invest your time in learning, Not just practicing.

DEK

 

[sedj]

I think you should read a JDBC tutorial :

http://java.sun.com/developer/onlineTraining/Database/JDBC20Intro/

But this is a very basic JDBC call :

Connection c = ...
// Get a Statement
Statement s = c.createStatement();
// Execute a query and get a ResultSet
ResultSet rs = s.executeQuery("select * from users where clue > 0");
while (rs.next()) {
     // do something
}

// close all db objects

--------------------------------------------------
Free Database Connection Pooling Software

http://www.primrose.org.uk

 

[dekcool]

thanks a lot i got it!

____________________________________________________
Invest your time in learning, Not just practicing.

DEK