Reading CSV then Insert Data to SQLITE

Reading CSV then Insert Data to SQLITE

I have a CSV file located in my assets folder. I need my program to get
the CSV file and then insert it's data to a table in SQLite.
Here's my current code
FileReader file;
file = new
FileReader("com.xylol.o_cha/assets/questions/question_bank.csv");
BufferedReader buffer = new BufferedReader(file);
String line = "";
String tableName ="O_CHA_QUESTIONS";
String columns = "QUESTION_ID, CATEGORY, ANIME
TITLE, QUESTION_DESC, CHOICE1, CHOICE2, CHOICE3,
CHOICE4, CORRECT_ANSWER, ANSWERED";
String str1 = "INSERT INTO " + tableName + " (" +
columns + ") values(";
String str2 = ");";
database.beginTransaction();
while ((line = buffer.readLine()) != null) {
StringBuilder sb = new StringBuilder(str1);
String[] str = line.split(",");
sb.append("'" + str[0] + "',");
sb.append(str[1] + "',");
sb.append(str[2] + "',");
sb.append(str[3] + "'");
sb.append(str[4] + "'");
sb.append(str2);
database.execSQL(sb.toString());
}
database.setTransactionSuccessful();
database.endTransaction();