Android 讀取raw下的txt檔案

最近在做項目的時候要往資料庫中插入很多城市，而android中不支援一次插入多條資料。把sql語句粘到一個txt檔案中。然後通過一行一行的讀檔案來一條條插入。

讀取檔案的代碼：

public static String getString(int filePath) {                 Resources res = context.getResources();                 InputStream in = null;                 InputStreamReader inputStreamReader = null;try {                   in = res.openRawResource(filePath);                   inputStreamReader = new InputStreamReader(in, "gbk");} catch (UnsupportedEncodingException e1) {e1.printStackTrace();}BufferedReader reader = new BufferedReader(inputStreamReader);StringBuffer sb = new StringBuffer("");String line;try {while ((line = reader.readLine()) != null) {sb.append(line);sb.append("\n");}} catch (IOException e) {e.printStackTrace();}return sb.toString();}