如何在android中将内容从文本文件复制到数据库

// 1. 创建或打开数据库连接
SQLiteOpenHelper dbHelper = new SQLiteOpenHelper(context, "mydatabase.db", null, 1) {
    @Override
    public void onCreate(SQLiteDatabase db) {
        // 创建表结构
        db.execSQL("CREATE TABLE IF NOT EXISTS mytable (id INTEGER PRIMARY KEY AUTOINCREMENT, content TEXT)");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // 升级数据库
    }
};

// 2. 读取文本文件内容
File file = new File("path/to/textfile.txt");
StringBuilder contentBuilder = new StringBuilder();
try {
    BufferedReader reader = new BufferedReader(new FileReader(file));
    String line;
    while ((line = reader.readLine()) != null) {
        contentBuilder.append(line);
    }
    reader.close();
} catch (IOException e) {
    e.printStackTrace();
}

String content = contentBuilder.toString();

// 3. 将文本内容插入到数据库
SQLiteDatabase db = dbHelper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("content", content);
db.insert("mytable", null, values);
db.close();