function executeRecordSetObj(SQL){ var conn = $.db.getConnection(); var pstmt = conn.prepareStatement(SQL); var rs = pstmt.executeQuery(); var rsm = rs.getMetaData(); var strObj = ''; while (rs.next()) { strObj += '{'; for (var i = 1; i <= rsm.getColumnCount(); i++){ strObj += '"' + rsm.getColumnName(i) + '":"' + rs.getString(i) + '",'; } strObj = strObj.substring(0, strObj.length - 1); strObj += '},' } rs.close(); pstmt.close(); conn.close(); return '[' + strObj.substring(0, strObj.length - 1) + ']'; }