在Android tablelayout中显示SQLite数据

// 创建SQLite数据库
public class DBHelper extends SQLiteOpenHelper {
    private static final String DATABASE_NAME = "mydatabase.db";
    private static final int DATABASE_VERSION = 1;

    public DBHelper(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        // 创建表格
        String createTableQuery = "CREATE TABLE mytable (id INTEGER PRIMARY KEY, name TEXT)";
        db.execSQL(createTableQuery);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // 升级数据库
        String dropTableQuery = "DROP TABLE IF EXISTS mytable";
        db.execSQL(dropTableQuery);
        onCreate(db);
    }
}

// 插入数据
public void insertData(String name) {
    SQLiteDatabase db = dbHelper.getWritableDatabase();
    ContentValues values = new ContentValues();
    values.put("name", name);
    db.insert("mytable", null, values);
    db.close();
}

// 查询数据
public List<String> getData() {
    List<String> dataList = new ArrayList<>();
    SQLiteDatabase db = dbHelper.getReadableDatabase();
    String[] columns = {"name"};
    Cursor cursor = db.query("mytable", columns, null, null, null, null, null);
    if (cursor.moveToFirst()) {
        do {
            String name = cursor.getString(cursor.getColumnIndex("name"));
            dataList.add(name);
        } while (cursor.moveToNext());
    }
    cursor.close();
    db.close();
    return dataList;
}

// 动态添加表格行
public void addTableRows(TableLayout tableLayout, List<String> dataList) {
    for (String data : dataList) {
        TableRow tableRow = new TableRow(this);
        TextView textView = new TextView(this);
        textView.setText(data);
        tableRow.addView(textView);
        tableLayout.addView(tableRow);
    }
}

// 在Activity中显示表格数据
public class MainActivity extends AppCompatActivity {
    private TableLayout tableLayout;
    private DBHelper dbHelper;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        tableLayout = findViewById(R.id.tableLayout);
        dbHelper = new DBHelper(this);

        // 插入数据
        dbHelper.insertData("Data 1");
        dbHelper.insertData("Data 2");
        dbHelper.insertData("Data 3");

        // 查询数据
        List<String> dataList = dbHelper.getData();

        // 动态添加表格行
        dbHelper.addTableRows(tableLayout, dataList);
    }
}