Android Open Source - OpenHSK C S V Exporter

From Project

Back to project page OpenHSK.

License

The source code is released under:

This work is licensed under a Creative Commons Attribution 3.0 Unported License. Original author of word lists: http://lingomi.com/ Original author of definitions: http://cc-cedict.org Original autho...

If you think the Android project OpenHSK listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.

Java Source Code

package edu.openhsk.utils;
/*from   ww w  . j a  v  a 2  s.  c  o m*/
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileWriter;

import edu.openhsk.repository.DatabaseHelper;

import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Environment;
import android.util.Log;

public class CSVExporter {
  private static final String LOG_TAG = CSVExporter.class.getSimpleName();
  private final DatabaseHelper dbh;

  public CSVExporter(DatabaseHelper dbh) {
    this.dbh = dbh;
  }
  
  public void exportWordListToCSVOnSDCard(int wordListId) throws Exception {
    SQLiteDatabase db = null;
    BufferedWriter writer = null;
    try {
      db = dbh.getReadableDatabase();
      
      //get word list name for use in filename
      String fileName = "testlist";
      Cursor cursor = db.rawQuery("SELECT name FROM t_wordlists WHERE _id = ?", 
          new String[] {String.valueOf(wordListId)});
      cursor.moveToFirst();
      fileName = cursor.getString(0);
      cursor.close();
      
      //get all words in a cursor
      cursor = db.rawQuery("SELECT word,pinyin,definition FROM t_words WHERE wordlistid = ?", 
          new String[] {String.valueOf(wordListId)});
      
      //create file
      File sdCard = Environment.getExternalStorageDirectory();
      String backupDBPath = sdCard.getAbsolutePath() + "//openhsk//exports//";
      File file = new File(backupDBPath);
      file.mkdirs();
      File file2 = new File(file, fileName + ".csv");
      file2.createNewFile();
      
      //write words to file
      writer = new BufferedWriter(new FileWriter(file2));
      cursor.moveToFirst();
      while (!cursor.isAfterLast()) {
        String word = cursor.getString(0);
        String pinyin = cursor.getString(1);
        String def = cursor.getString(2);
        writer.write(word + ";" + pinyin + ";" + def);
        writer.newLine();
        
        cursor.moveToNext();
      }
      cursor.close();
      
      Log.d(LOG_TAG, "Export successful");
    } finally {
      if (writer != null) writer.close();
      DatabaseHelper.closeDatabase(db);
    }
  }
}

Java Source Code List