mardi 5 mai 2015

How to insert CSV file into SQLite database on android?

I createed CSV file with name stats.csv inside android stodio, and so I created 3 classes:

first:

import android.app.Activity;
import android.os.Bundle;
import android.os.Parcelable;
import android.widget.ListView;

import java.io.InputStream;
import java.util.List;


public class MyDatabase extends Activity {

    private ListView listView;
    private ItemArrayAdapter itemArrayAdapter;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_my_database);

        listView = (ListView) findViewById(R.id.list_view);
        itemArrayAdapter = new ItemArrayAdapter(getApplicationContext(), R.layout.single_list_item);

        Parcelable state = listView.onSaveInstanceState();
        listView.setAdapter(itemArrayAdapter);
        listView.onRestoreInstanceState(state);

        InputStream inputStream = getResources().openRawResource(R.raw.stats);
        CSVReader csv = new CSVReader(inputStream);
        List<String[]> scoreList = csv.read();

        for(String [] scoreData : scoreList)
        {
            itemArrayAdapter.add(scoreData);
        }

    }

}

second:

import android.content.Context;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.ArrayAdapter;
import android.widget.TextView;

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


public class ItemArrayAdapter extends ArrayAdapter<String[]>{

    private List<String[]> scoreList = new ArrayList<String[]>();

    static class ItemViewHolder {
        TextView namee;
        TextView score;
    }

    public ItemArrayAdapter(Context context, int resource) {
        super(context, resource);
    }

    public void add(String[] object) {
        scoreList.add(object);
        super.add(object);
    }

    @Override
    public int getCount() {
        return this.scoreList.size();
    }

    @Override
    public String[] getItem(int position) {
        return this.scoreList.get(position);
    }

    @Override
    public View getView(int position, View convertView, ViewGroup parent) {
        View row = convertView;
        ItemViewHolder viewHolder;
        if(row == null) {
            LayoutInflater inflater = (LayoutInflater) this.getContext().getSystemService(Context.LAYOUT_INFLATER_SERVICE);
            row = inflater.inflate(R.layout.single_list_item, parent, false);
            viewHolder = new ItemViewHolder();
            viewHolder.namee = (TextView) row.findViewById(R.id.namee);
            viewHolder.score = (TextView) row.findViewById(R.id.score);
            row.setTag(viewHolder);
        } else {
            viewHolder = (ItemViewHolder) row.getTag();
        }

        String[] stat = getItem(position);
        viewHolder.namee.setText(stat[0]);
        viewHolder.score.setText(stat[1]);
        return row;

    }
}

third:

import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.util.ArrayList;
import java.util.List;


public class CSVReader {
    InputStream inputStream;
    
    public CSVReader (InputStream is) 
    {
        this.inputStream = is;
    }
    
    public List<String[]> read () {
        List<String[]> resultList = new ArrayList<String[]>();
        BufferedReader reader = new BufferedReader(new InputStreamReader(inputStream));
        
        try {
            String csvLine;
            while((csvLine = reader.readLine()) != null) {
                String[] row = csvLine.split(",");
                resultList.add(row);
            }
        } catch (IOException ex) {
            throw new RuntimeException("Error iv reading CSV file:" + ex);
        }
        finally {
            try {
                inputStream.close();
            } catch (IOException e) {
                throw new RuntimeException("Error while closing input strem:" + e);
            }
        }
        return resultList;
    }
}

^ these codes show me a list view of my csv file. but when i try to inserted into SQLite it doesn't work. here what i'm trying on third class:

import android.content.ContentValues;
import android.database.sqlite.SQLiteDatabase;
import android.util.Log;

import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.util.ArrayList;
import java.util.List;

public class CSVReader {
    InputStream inputStream;

    public CSVReader (InputStream is)
    {
        this.inputStream = is;
    }

    public List<String[]> read () {
        List<String[]> resultList = new ArrayList<String[]>();
        BufferedReader reader = new BufferedReader(new InputStreamReader(inputStream));
 
        SQLiteDatabase db =this.getWritableDatabase(); /* THE ERROR SHOWN HERE : " " */

        String csvLine = "";
        db.beginTransaction();
        try {
            while((csvLine = reader.readLine()) != null) {
                String[] row = csvLine.split(",");
                if (row.length != 2) {
                    Log.d("CSVParser", "Skipping Bad CSV Row");
                    continue;
                }
                ContentValues cv = new ContentValues(2);
                cv.put("namee", row[0].trim());
                cv.put("score", row[1].trim());
                db.insert("TABLE", null, cv);
                resultList.add(row);
            }
        } catch (IOException e) {
            e.printStackTrace();
        }
        db.setTransactionSuccessful();
        db.endTransaction();

        return resultList;
    }
}

the error message: " Error:(26, 32) error: cannot find symbol method getWritableDatabase() , "

can you help me please?

Aucun commentaire:

Enregistrer un commentaire