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