将数据库结果添加到React Native中的对象数组

import React, { useEffect, useState } from 'react';
import { View, Text } from 'react-native';
import * as SQLite from 'expo-sqlite';

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

const App = () => {
  const [data, setData] = useState([]);

  useEffect(() => {
    db.transaction(tx => {
      tx.executeSql(
        'SELECT * FROM mytable',
        [],
        (_, { rows }) => {
          const results = rows._array;
          const dataArray = results.map(item => ({
            id: item.id,
            name: item.name,
            // Add more properties as per your database schema
          }));
          setData(dataArray);
        },
        (_, error) => {
          console.log(error);
        }
      );
    });
  }, []);

  return (
    <View>
      {data.map(item => (
        <Text key={item.id}>{item.name}</Text>
      ))}
    </View>
  );
};

export default App;