Flutter sqflite 插入列表String

使用Flutter开发移动应用程序时，经常需要使用数据库来存储和管理数据。而在Flutter中，我们可以使用sqflite插件来实现数据库操作。本文将介绍如何使用sqflite插件来插入一个字符串列表，并提供相应的案例代码供参考。

dependencies:
  sqflite: ^1.3.0

dart
import 'package:sqflite/sqflite.dart';
import 'package:path/path.dart';
Future openDatabase() async {
  final String databasesPath = await getDatabasesPath();
  final String path = join(databasesPath, 'my_database.db');
  return await openDatabase(
    path,
    version: 1,
    onCreate: (Database db, int version) async {
      await db.execute(
        'CREATE TABLE IF NOT EXISTS my_table ('
        'id INTEGER PRIMARY KEY,'
        'value TEXT)',
      );
    },
  );
}

dart
Future insertList(List list) async {
  final Database db = await openDatabase();
  final Batch batch = db.batch();
  
  for (String value in list) {
    batch.insert('my_table', {'value': value});
  }
  
  await batch.commit();
}

dart
import 'package:flutter/material.dart';
import 'package:sqflite/sqflite.dart';
import 'package:path/path.dart';
void main() {
  runApp(MyApp());
}
class MyApp extends StatelessWidget {
  @override
  Widget build(BuildContext context) {
    return MaterialApp(
      title: 'Flutter SQFlite Demo',
      theme: ThemeData(
        primarySwatch: Colors.blue,
      ),
      home: MyHomePage(),
    );
  }
}
class MyHomePage extends StatelessWidget {
  @override
  Widget build(BuildContext context) {
    return Scaffold(
      appBar: AppBar(
        title: Text('Flutter SQFlite Demo'),
      ),
      body: Center(
        child: RaisedButton(
          child: Text('Insert List'),
          onPressed: () async {
            List list = ['Apple', 'Banana', 'Orange'];
            await insertList(list);
            print('List inserted successfully.');
          },
        ),
      ),
    );
  }
}
Future openDatabase() async {
  final String databasesPath = await getDatabasesPath();
  final String path = join(databasesPath, 'my_database.db');
  return await openDatabase(
    path,
    version: 1,
    onCreate: (Database db, int version) async {
      await db.execute(
        'CREATE TABLE IF NOT EXISTS my_table ('
        'id INTEGER PRIMARY KEY,'
        'value TEXT)',
      );
    },
  );
}
Future insertList(List list) async {
  final Database db = await openDatabase();
  final Batch batch = db.batch();
  
  for (String value in list) {
    batch.insert('my_table', {'value': value});
  }
  
  await batch.commit();
}