movefirst in java

[kkiub]

hi guys,

i need your help. i need to point cursor to my first record in my resultset. but no function movefirst in java. this in my code:

public SPO RetrievePOHdr (String cSQL) throws RemoteException {
    SPO PO = new SPO();			
    try {
	  DBConnection dbconn = new DBConnection ();
	  stmt = dbconn.getConn().createStatement();
	  sql = "SELECT * ";
	  sql = sql + " FROM pu_ordhdrfc, outer pu_ordlinefc ";
	  sql = sql + " WHERE puoh_company = puol_company ";
	  sql = sql + " and puoh_ordid = puol_ordid ";
	  sql = sql + cSQL;
	  rs = stmt.executeQuery(sql);
	  rs.movefirst(); --- error
	  String ordDate,expDate;
	  DateConvert dc = new DateConvert();
	  ordDate= dc.getStrdate((rs.getString("puoh_orddate")),"DBtoJSP");
	  expDate= dc.getStrdate((rs.getString("puoh_expdate")),"DBtoJSP");
	  PO.setcompany(rs.getString("puoh_company"));
	  PO.setordid(rs.getString("puoh_ordid"));
	  PO.setcontractid(rs.getString("puoh_contractid"));
	  PO.setsuppid(rs.getString("puoh_suppid"));
    }catch (SQLException ee) {
      System.out.println("error retrieve:" +ee);
    }
    return PO;
}

please help me.

[Belisarius]

You probably want "next()" rather than "movefirst()" (which, incidently, doesn't exist and is misspelled at any rate).

By calling "next()", you'll move the cursor to the first row of the ResultSet, and be able to access it's values. Any subsequent calls of "next()" will move the cursor down one until it hits the end, at which point it'll return "false".

[kkiub]

thank you so much