Android Open Source - BaseAndroid Sample Controller

• Back to Development/data  ↑

From Project

Back to project page BaseAndroid.

License

The source code is released under:

MIT License

Java Source Code

/**
 * File: BaseDBController//  w w w . j  a  v a 2 s .  c om
 * CreationDate: 31/07/13
 * Author: "M. en C. Javier Silva Perez (JSP)"
 * Description: 
 *
 * Class that will be the connection between database and view classes, so it will include functions for inserting,
 * deleting, updating and getting rows in the data base, but will use DAO objects for getting and returning data
 */
package com.cmovil.baseandroid.controller;

import android.content.Context;
import android.database.Cursor;

import com.cmovil.baseandroid.dao.db.DBException;
import com.cmovil.baseandroid.dao.db.DatabaseDictionary;
import com.cmovil.baseandroid.dao.db.SampleDAO;
import com.cmovil.baseandroid.model.db.State;

import java.util.LinkedList;
import java.util.List;

/**
 * Class that will be the connection between database and view classes, so it will include generic functions for
 * inserting,
 * deleting, updating and getting rows in the data base, but will use DAO objects for getting and returning data
 *
 * @author "M. en C. Javier Silva Perez (JSP)"
 * @version 1.0
 * @since 19/09/13
 */
public class SampleController extends BaseDBController<State> {

  private static final String[] COLUMNS =
    new String[]{DatabaseDictionary.State._ID, DatabaseDictionary.State.COLUMN_NAME_NAME,
      DatabaseDictionary.State.COLUMN_NAME_ID_SERVER};

  /**
   * Constructor
   *
   * @param context
   *   The Context within which to work, used to create the DB
   */
  public SampleController(Context context) {
    super(new SampleDAO(context));
  }

  /**
   * Columns that will be returned by the sql statements
   *
   * @return A string array with the columns that will be returned in all sql statements
   */
  @Override
  protected String[] getColumns() {
    return COLUMNS;
  }

  /**
   * Fill up an object with cursor values, the cursor must be valid or exceptions could be thrown
   *
   * @param cursor
   *   Valid cursor for extract object information
   * @return A State object fill up with cursor information
   */
  public State fillUpObject(Cursor cursor) {
    State state = new State();
    state.setId(cursor.getInt(cursor.getColumnIndexOrThrow(DatabaseDictionary.State._ID)));
    state.setIdServer(cursor.getInt(cursor.getColumnIndexOrThrow(DatabaseDictionary.State.COLUMN_NAME_ID_SERVER)));
    state.setName(cursor.getString(cursor.getColumnIndexOrThrow(DatabaseDictionary.State.COLUMN_NAME_NAME)));
    return state;
  }

  /**
   * Gets the states with the selected server id
   *
   * @param idServer
   *   Server Id that will be searched in the database
   * @return A {@link com.cmovil.baseandroid.model.db.State} object with the values from the database or an empty
   * object
   * if no results where found
   *
   * @throws com.cmovil.baseandroid.dao.db.DBException
   *   if something goes wrong during SQL statements execution
   */
  public State getByServerId(Integer idServer) throws DBException {

    Cursor res = ((SampleDAO)baseDBDAO).getByServerId(idServer, COLUMNS);
    //If the cursor has at least one element, create the corresponding State object, if not,
    // return an empty object
    if (res != null && res.moveToFirst()) {
      State state = fillUpObject(res);
      res.close();
      return state;

    }
    if (res != null) {
      res.close();
    }
    return new State();
  }
}

Java Source Code List

• Back to Development/data  ↑