How to store an arraylist in an android database and retrieve it whenever I need to

Question

This is the method through which I would like to store the words in an arraylist and write them to the database.

public void loadWords(Context context) {

    AssetManager am = context.getAssets();
    wordList = new ArrayList<String>();

    try {

        InputStream inputStream = am.open("english-words-lowercase.txt");
        InputStreamReader inputStreamReader = new InputStreamReader(
                inputStream);
        BufferedReader bufferedReader = new BufferedReader(
                inputStreamReader);

        word = bufferedReader.readLine();

        while(word!=null){
            wordList.add(word);
            word = bufferedReader.readLine();

        }

    } catch (IOException e) {
        e.printStackTrace();
    }


}

So now I have an ArrayList with all the words I would like to use. How can I store it into a database so that I can read it whenever I want? And I will be using it to validate words that users will input, is this the best way to store the words or should I use a HashMap or some other storing techniques? Thank you!

Ansar · Accepted Answer · 2013-08-26 10:42:17Z

2

Array list can have duplicates .. so try to store it in a set. and store it in databse..Suppose if you are you have words(a,b,a,c,d).. here 'a' is repeated.. when you are using arraylist it will enter for two times.. but in the case of set it will not allow duplicate..ie 'a' will enter only one time.. and you can store it in database ans retreive when ever you want

Set<String> set = new HashSet<String>();
set.add("element here");

edited Aug 26, 2013 at 10:42

answered Aug 26, 2013 at 10:14

Ansar

3643 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

baselsader Over a year ago

Thank you for the fast reply, but could you please elaborate on duplicates and set? I am still new to android programming and don't know what a set is or how to make one?

Collectives™ on Stack Overflow

How to store an arraylist in an android database and retrieve it whenever I need to

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related