[anderma8]

I hope this formats well:

Here is the query: static String GETMFDEMPINFO = "select serialno, keyop, keyopempno, keyopbld, keyoproom, keyopphone, altop, altopempno, altopbld, altoproom, altopphone, dolu from tbl_mfd";


Thanks for your input!


public MFDObjList getMFDList() {
Connection conn = getConnection();
Statement stmt = null;
ResultSet rs = null;

MFDObjList myList = new MFDObjList();

try {

stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSI TIVE, ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(GETMFDEMPINFO);

while (rs.next()) {
MFDObj myMFD = new MFDObj();

myMFD.setSerialNo(rs.getString("serialno"));
myMFD.setKeyOp(rs.getString("keyop"));
myMFD.setKeyOpEmpNo(rs.getString("keyopempno"));
myMFD.setKeyOpBld(rs.getString("keyopbld"));
myMFD.setKeyOpRoom(rs.getString("keyoproom"));
myMFD.setKeyOpPhone(rs.getString("keyopphone"));
myMFD.setAltOp(rs.getString("altop"));
myMFD.setAltOpEmpNo(rs.getString("altopempno"));
myMFD.setAltOpBld(rs.getString("altopbld"));
myMFD.setAltOpRoom(rs.getString("altoproom"));
myMFD.setAltOpPhone(rs.getString("altopphone"));

myList.addMFDItem(myMFD);
}

} catch (Exception ex) {
System.out.println("SQL Exception (" + ex.getMessage() + ")");
} finally {
returnResources(rs, stmt, conn);
}
return myList;
}