Android Open Source - android-grog-db Table Country

• Back to SQLite/API  ↑

From Project

Back to project page android-grog-db.

License

The source code is released under:

Apache License

Java Source Code

/***
  Copyright (c) 2012 sprogcoder <sprogcoder@gmail.com>
  /*from  ww  w .java2s .c  o  m*/
  Licensed under the Apache License, Version 2.0 (the "License"); you may
  not use this file except in compliance with the License. You may obtain
  a copy of the License at
  
    http://www.apache.org/licenses/LICENSE-2.0
    
  Unless required by applicable law or agreed to in writing, software
  distributed under the License is distributed on an "AS IS" BASIS,
  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  See the License for the specific language governing permissions and
  limitations under the License.
 */

package com.sprogcoder.example.database;

import java.util.HashMap;
import java.util.Map;

import android.content.ContentValues;

import com.sprogcoder.grogdb.GrogTable;

public class TableCountry extends GrogTable
{

  private static final String TABLE_NAME = "Countries";
  private static Map<String, String> columns = new HashMap<String, String>();

  static
  {
    columns.put("COUNTRY_NAME", "TEXT");
    columns.put("COUNTRY_CAPITAL", "TEXT");
  }

  public TableCountry()
  {
    super(TABLE_NAME, columns);
  }

  public void addCountryCapital(String countryName, String countryCapital)
  {
    ContentValues cv = new ContentValues();
    cv.put("COUNTRY_NAME", countryName);
    cv.put("COUNTRY_CAPITAL", countryCapital);
    insertRow(TABLE_NAME, cv);
  }

  public String getCountryCapital(String countryName)
  {
    String args = "COUNTRY_NAME='" + countryName + "'";
    return getString(TABLE_NAME, args, "COUNTRY_CAPITAL");
  }
  
}

Java Source Code List

• Back to SQLite/API  ↑