- Forum posts: 1
Jul 8, 2015, 5:29:20 AM via Website
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) {
}
}
Recommended editorial content
With your consent, external content is loaded here.
By clicking on the button above, you agree that external content may be displayed to you. Personal data may be transmitted to third-party providers in the process. You can find more information about this in our Privacy Policy.