+ pEntityClass.getSimpleName().toUpperCase() + "." + ownerFieldName.toUpperCase() + " = " + idOwnerStr + ";\n"; recordSet = getSrvDatabase().retrieveRecords(query); if (recordSet.moveToFirst()) { do {
+ pEntityClass.getSimpleName().toUpperCase() + "." + ownerFieldName.toUpperCase() + "=" + ownerIdStr + ";\n"; recordSet = getSrvDatabase().retrieveRecords(query); if (recordSet.moveToFirst()) { do {
/** * <p>Retrieve a list of all entities.</p> * @param <T> - type of business object, * @param pEntityClass entity class * @return list of all business objects or empty list, not null * @throws Exception - an exception */ @Override public final <T> List<T> retrieveList( final Class<T> pEntityClass) throws Exception { List<T> result = new ArrayList<T>(); IRecordSet<RS> recordSet = null; try { String query = evalSqlSelect(pEntityClass) + ";\n"; recordSet = getSrvDatabase().retrieveRecords(query); if (recordSet.moveToFirst()) { do { result.add(retrieveEntity(pEntityClass, recordSet)); } while (recordSet.moveToNext()); } } finally { if (recordSet != null) { recordSet.close(); } } return result; }
String query = evalSqlSelect(pEntityClass) + " limit " + pPageSize + " offset " + pFirst + ";\n"; recordSet = getSrvDatabase().retrieveRecords(query); if (recordSet.moveToFirst()) { do {
String query = getHlpInsertUpdate().evalSqlInsert( pEntity.getClass().getSimpleName().toUpperCase(), columnsValues); recordSet = getSrvDatabase().retrieveRecords(query + " returning " + idName.toUpperCase() + ";\n"); recordSet.moveToFirst();
/** * <p>Retrieve entity from DB.</p> * @param <T> entity type * @param pEntityClass entity class * @param pQuery SELECT statement * @return entity or null * @throws Exception - an exception **/ @Override public final <T> T retrieveEntity( final Class<T> pEntityClass, final String pQuery) throws Exception { T entity = null; IRecordSet<RS> recordSet = null; try { recordSet = getSrvDatabase().retrieveRecords(pQuery); if (recordSet.moveToFirst()) { entity = retrieveEntity(pEntityClass, recordSet); } } finally { if (recordSet != null) { recordSet.close(); } } return entity; }
try { String insertedIdName = "INSERTEDID"; recordSet = getSrvDatabase().retrieveRecords( "select LAST_INSERT_ID() as " + insertedIdName + ";"); recordSet.moveToFirst();
try { String insertedIdName = "INSERTEDID"; recordSet = getSrvDatabase().retrieveRecords( "select last_insert_rowid() as " + insertedIdName + ";"); recordSet.moveToFirst();
try { String insertedIdName = "INSERTEDID"; recordSet = getSrvDatabase().retrieveRecords( "select SCOPE_IDENTITY() as " + insertedIdName + ";"); recordSet.moveToFirst();
String query = evalSqlSelect(pEntityClass) + " " + pQueryConditions + ";\n"; recordSet = getSrvDatabase().retrieveRecords(query); if (recordSet.moveToFirst()) { do {
String query = evalSqlSelect(pEntityClass) + " " + pQueryConditions + " limit " + pPageSize + " offset " + pFirst + ";\n"; recordSet = getSrvDatabase().retrieveRecords(query); if (recordSet.moveToFirst()) { do {
IRecordSet<RS> recordSet = null; try { recordSet = getSrvDatabase().retrieveRecords(query); if (recordSet.moveToFirst()) { do {
IRecordSet<RS> recordSet = null; try { recordSet = getSrvDatabase().retrieveRecords(query); if (recordSet.moveToFirst()) { do {
IRecordSet<RS> recordSet = null; try { recordSet = getSrvDatabase().retrieveRecords(query); if (recordSet.moveToFirst()) { do {
IRecordSet<RS> recordSet = null; try { recordSet = getSrvDatabase().retrieveRecords(query); if (recordSet.moveToFirst()) { do {
IRecordSet<RS> recordSet = null; try { recordSet = getSrvDatabase().retrieveRecords(query); if (recordSet.moveToFirst()) { do {
IRecordSet<RS> recordSet = null; try { recordSet = getSrvDatabase().retrieveRecords(pQuery); if (recordSet.moveToFirst()) { do {
recordSet = getSrvDatabase().retrieveRecords(this.queryMain); if (recordSet.moveToFirst()) { do {
IRecordSet<RS> recordSet = null; try { recordSet = getSrvDatabase().retrieveRecords(pQuery); if (recordSet.moveToFirst()) { do {
recordSet = getSrvDatabase().retrieveRecords(this.queryMain); if (recordSet.moveToFirst()) { do {