Android Open Source - SQLiteDatabase Name Controller

• Back to SQLite/example  ↑

From Project

Back to project page SQLiteDatabase.

License

The source code is released under:

DO WHAT THE FUCK YOU WANT TO PUBLIC LICENSE Version 2, December 2004 Copyright (C) 2004 Sam Hocevar <sam@hocevar.net> Everyone is permitted to copy and distribute v...

Java Source Code

/*
 * Intellectual properties of Supun Lakshan Wanigarathna Dissanayake
 * Copyright (c) 2014, Supun Lakshan Wanigarathna Dissanayake. All rights reserved.
 * Created on : Oct 14, 2014, 10:39 PM/*from  ww w.  j a  v  a2s  .  c o  m*/
 */
package org.xfinity.android_sqlite_database_example.controller;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import org.jetbrains.annotations.NotNull;
import org.xfinity.android_sqlite_database_example.db.DbHandler;
import org.xfinity.android_sqlite_database_example.db.SQLiteDatabaseHelper;

import java.util.ArrayList;

/**
 * @author Supun Lakshan Wanigarathna Dissanayake
 * @mobile +94711290392
 * @email supunlakshan.xfinity@gmail.com
 */
public class NameController {

  private NameController() {
  }

  public static boolean addNameToDb(@NotNull Context context, String name) {
    SQLiteDatabaseHelper databaseHelper = SQLiteDatabaseHelper.getDatabaseInstance(context);
    try {
      SQLiteDatabase writableDatabase = databaseHelper.getWritableDatabase();
      String nameInsertSql = "insert into tbl_name(name) values (?)";
      long insertedId = DbHandler.performExecuteInsert(writableDatabase, nameInsertSql, new Object[]{name});
      return insertedId > 0;
    } finally {
      databaseHelper.close();
    }
  }

  public static ArrayList<String> readNamesFromDb(@NotNull Context context) {
    SQLiteDatabaseHelper databaseHelper = SQLiteDatabaseHelper.getDatabaseInstance(context);
    try {
      SQLiteDatabase readableDatabase = databaseHelper.getReadableDatabase();
      String nameReadSql = "select name from tbl_name";
      Cursor cursor = DbHandler.performRawQuery(readableDatabase, nameReadSql, null);
      ArrayList<String> names = new ArrayList<String>();
      for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext()) {
        names.add(cursor.getString(0));
      }
      cursor.close();
      return names;
    } finally {
      databaseHelper.close();
    }
  }
}

Java Source Code List

• Back to SQLite/example  ↑