working with a prepopulated SQLite file

  • Replies:0
Sean patrick Maiorca
  • Forum posts: 1

Jul 8, 2015, 5:29:20 AM via Website

I am writting a flashcard app and I will be using some spinners that are populated with data from an SQLlite file
here is the activities to add flashcards since I added the code to connect the SQLite and activity it crashes- the logcat says that the tables don't exist

package com.example.sean.russiantutor;

import java.util.ArrayList;
import java.util.List;

import android.app.Activity;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.view.inputmethod.InputMethodManager;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemSelectedListener;
import android.widget.ArrayAdapter;
import android.widget.Button;
import android.widget.EditText;
import android.widget.ListView;
import android.widget.Spinner;
import android.widget.Toast;

import java.util.List;


public class AddNewFlashCards extends Activity implements OnItemSelectedListener {


    private static final String TABLE_NAME = "nouns";
    private static final String FRIEND_ID = "_id_noun";
    private static final String FRIEND_NAME = "Russian_word";
    private static final String english = "English_word";

    private static final String DB_NAME = "Russian_Tutor.sqlite3";
    private SQLiteDatabase database;
    private ListView listView;
    private ArrayList<String> partsOfSpeech;


    SQLiteDatabase mydb;
    private   static String DBNAME = "Russian_Tutor.sqlite3";
    private static String TABLE = "parts_of_speech";

    // Spinner element
    Spinner partOfSpeechSpinner;
    private Object allLabels;


    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.add_new_flash_cards);

        // Spinner element
        partOfSpeechSpinner = (Spinner) findViewById(R.id.partOfSpeechSpinner);

// Spinner click listener
        partOfSpeechSpinner.setOnItemSelectedListener(this);

// Loading spinner data from database
        loadSpinnerData();





    }

    /**
     * Function to load the spinner data from SQLite database
     * */
    private void loadSpinnerData() {
        // database handler
        DataBaseHelper db = new DataBaseHelper(getApplicationContext());

        // Spinner Drop down elements
        List<String> lables = db.getAllLabels();

        // Creating adapter for spinner
        ArrayAdapter<String> dataAdapter = new ArrayAdapter<String>(this,
                android.R.layout.simple_spinner_item, lables);

        // Drop down layout style - list view with radio button
        dataAdapter
                .setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);

        // attaching data adapter to spinner
        partOfSpeechSpinner.setAdapter(dataAdapter);
    }

    @Override
    public void onItemSelected(AdapterView<?> adapterView, View view, int i, long l) {

    }

    @Override
    public void onNothingSelected(AdapterView<?> adapterView) {

    }
}

I copied the names from the database file so I am thinking I am not properly connecting things.
I could probably use an XML file- as the goal to the pull down is to put the words into differnt tables based on the part of speech but
I am wanting to do this with data from an SQLlite file just so I can learn how to do that- so I can get it to work with a vocabulary list.

import java.util.ArrayList;
import java.util.List;

import android.app.Activity;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.view.inputmethod.InputMethodManager;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemSelectedListener;
import android.widget.ArrayAdapter;
import android.widget.Button;
import android.widget.EditText;
import android.widget.ListView;
import android.widget.Spinner;
import android.widget.Toast;

import java.util.List;

public class AddNewFlashCards extends Activity implements OnItemSelectedListener {

private static final String TABLE_NAME = "nouns";
private static final String FRIEND_ID = "_id_noun";
private static final String FRIEND_NAME = "Russian_word";
private static final String english = "English_word";

private static final String DB_NAME = "Russian_Tutor.sqlite3";
private SQLiteDatabase database;
private ListView listView;
private ArrayList<String> partsOfSpeech;


SQLiteDatabase mydb;
private   static String DBNAME = "Russian_Tutor.sqlite3";
private static String TABLE = "parts_of_speech";

// Spinner element
Spinner partOfSpeechSpinner;
private Object allLabels;


@Override
public void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.add_new_flash_cards);

    // Spinner element
    partOfSpeechSpinner = (Spinner) findViewById(R.id.partOfSpeechSpinner);

// Spinner click listener
partOfSpeechSpinner.setOnItemSelectedListener(this);

// Loading spinner data from database
loadSpinnerData();

}

/**
 * Function to load the spinner data from SQLite database
 * */
private void loadSpinnerData() {
    // database handler
    DataBaseHelper db = new DataBaseHelper(getApplicationContext());

    // Spinner Drop down elements
    List<String> lables = db.getAllLabels();

    // Creating adapter for spinner
    ArrayAdapter<String> dataAdapter = new ArrayAdapter<String>(this,
            android.R.layout.simple_spinner_item, lables);

    // Drop down layout style - list view with radio button
    dataAdapter
            .setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);

    // attaching data adapter to spinner
    partOfSpeechSpinner.setAdapter(dataAdapter);
}

@Override
public void onItemSelected(AdapterView<?> adapterView, View view, int i, long l) {

}

@Override
public void onNothingSelected(AdapterView<?> adapterView) {

}

}

Reply