如何在expo react native中使用sqlite文件

expo install expo-sqlite

import * as SQLite from 'expo-sqlite';

const db = SQLite.openDatabase('database.db');

db.transaction(tx => {
  tx.executeSql(
    'SELECT * FROM table_name',
    [],
    (_, { rows }) => {
      // 处理查询结果
      const data = rows._array;
      console.log(data);
    }
  );
});

db.transaction(tx => {
  tx.executeSql(
    'CREATE TABLE IF NOT EXISTS table_name (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT)',
    [],
    () => {
      tx.executeSql(
        'INSERT INTO table_name (name) VALUES (?)',
        ['John Doe'],
        () => {
          tx.executeSql(
            'SELECT * FROM table_name',
            [],
            (_, { rows }) => {
              // 处理查询结果
              const data = rows._array;
              console.log(data);
            }
          );
        }
      );
    }
  );
});