在Android一个数据库创建两个数据表
时间: 2023-05-25 09:06:56 浏览: 49
在Android中创建两个数据库表可以按照以下步骤进行:
1. 创建一个SQLiteOpenHelper类,继承自SQLiteOpenHelper。
2. 在SQLiteOpenHelper类中重写onCreate()方法,在该方法中创建两个数据表。
```java
public class MyDatabaseHelper extends SQLiteOpenHelper {
private static final String DATABASE_NAME = "my_database";
private static final int DATABASE_VERSION = 1;
// table1: student
private static final String CREATE_TABLE_STUDENT = "CREATE TABLE student (" +
"id INTEGER PRIMARY KEY AUTOINCREMENT," +
"name TEXT," +
"age INTEGER," +
"gender TEXT)";
// table2: teacher
private static final String CREATE_TABLE_TEACHER = "CREATE TABLE teacher (" +
"id INTEGER PRIMARY KEY AUTOINCREMENT," +
"name TEXT," +
"age INTEGER," +
"gender TEXT)";
public MyDatabaseHelper(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
// create table1: student
db.execSQL(CREATE_TABLE_STUDENT);
// create table2: teacher
db.execSQL(CREATE_TABLE_TEACHER);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
```
3. 在activity中调用SQLiteOpenHelper类的getWritableDatabase()方法获取可写数据库对象,然后可以对数据表进行增删改查操作。
```java
MyDatabaseHelper dbHelper = new MyDatabaseHelper(this);
SQLiteDatabase db = dbHelper.getWritableDatabase();
// insert data into table1: student
ContentValues values1 = new ContentValues();
values1.put("name", "Tom");
values1.put("age", 18);
values1.put("gender", "Male");
db.insert("student", null, values1);
// insert data into table2: teacher
ContentValues values2 = new ContentValues();
values2.put("name", "Lucy");
values2.put("age", 30);
values2.put("gender", "Female");
db.insert("teacher", null, values2);
db.close();
```
相关推荐
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)