android sqlite 如何创建表

在Android中使用SQLite创建表，通常需要使用SQLiteOpenHelper类来帮助管理数据库的创建和版本管理。以下是一个简单的示例，展示了如何在Android应用中创建一个名为`example.db`的数据库，并在其中创建一个名为`People`的表。

你需要创建一个继承自`SQLiteOpenHelper`的类，重写`onCreate`方法来创建表。

```java

import android.content.Context;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteOpenHelper;

public class DatabaseHelper extends SQLiteOpenHelper {

// 数据库版本号

private static final int DATABASE_VERSION = 1;

// 数据库名称

private static final String DATABASE_NAME = "example.db";

// 创建People表的SQL语句

private static final String CREATE_PEOPLE_TABLE = "CREATE TABLE " + People.TABLE_NAME + "("

+ People._ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"

+ People.COLUMN_NAME_NAME + " TEXT,"

+ People.COLUMN_NAME_AGE + " INTEGER"

+ ")";

// 删除People表的SQL语句

private static final String DROP_PEOPLE_TABLE = "DROP TABLE IF EXISTS " + People.TABLE_NAME;

// People表类

public static class People {

public static final String TABLE_NAME = "People";

public static final String COLUMN_NAME_NAME = "name";

public static final String COLUMN_NAME_AGE = "age";