在Android应用中导入sql脚本

public class MyDatabaseHelper extends SQLiteOpenHelper {
    private static final String DATABASE_NAME = "mydatabase.db";
    private static final int DATABASE_VERSION = 1;
    private Context mContext;

    public MyDatabaseHelper(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
        mContext = context;
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        // 创建表和初始化数据
        String createTableSql = "CREATE TABLE IF NOT EXISTS mytable (id INTEGER PRIMARY KEY, name TEXT)";
        db.execSQL(createTableSql);

        // 导入SQL脚本
        importSqlScript(db, "myscript.sql");
    }

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

    private void importSqlScript(SQLiteDatabase db, String scriptFileName) {
        try {
            InputStream inputStream = mContext.getAssets().open(scriptFileName);
            BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(inputStream));
            String line;
            StringBuilder scriptBuilder = new StringBuilder();
            while ((line = bufferedReader.readLine()) != null) {
                scriptBuilder.append(line);
            }
            bufferedReader.close();

            String[] sqlStatements = scriptBuilder.toString().split(";");
            for (String sqlStatement : sqlStatements) {
                db.execSQL(sqlStatement);
            }
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}