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

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

const db = SQLite.openDatabase({ name: 'mydatabase.db', location: 'default' });

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

  useEffect(() => {
    const fetchData = async () => {
      try {
        const results = await new Promise((resolve, reject) => {
          db.transaction((tx) => {
            tx.executeSql('SELECT * FROM mytable', [], (tx, results) => {
              const len = results.rows.length;
              let rows = [];
              for (let i = 0; i < len; i++) {
                rows.push(results.rows.item(i));
              }
              resolve(rows);
            }, reject);
          });
        });
        setData(results);
      } catch (error) {
        console.error('Error fetching data:', error);
      }
    };

    fetchData();
  }, []);

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

export default MyComponent;