最近在做项目的时候要往数据库中插入很多城市,而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();
}