如何在Android Studio数据库中创建多个表 [英] How to create multiple tables in Android studio database

问题描述

很抱歉打扰大家，但是有时候我要寻求帮助。我是Android开发的新手，目前我正在频道ProgrammingKnowledge上关注youtube上创建android数据库的教程，但是，它仅适用于一个表，而我需要在数据库中拥有3个表，并且无法获取我的方式。任何帮助，将不胜感激。

Sorry to bother you all, but sometimes the help is what I have to ask for. I'm new to Android development, and currently I'm following tutorial for android database creation on youtube at channel ProgrammingKnowledge, however, it works only for one table, while I need to have 3 tables in the database, and can't get my way around it. Any help would be appreciated. Thanks in advance!

这是我目前拥有的代码。

This is the code I currently have.

公共类DatabaseHelper扩展了SQLiteOpenHelper {

public class DatabaseHelper extends SQLiteOpenHelper {

//database name declaration
public static final String DATABASE_NAME = "museum.db";
public static final String TABLE_NAME = "exponent_table";
public static final String COL_1 = "ID";
public static final String COL_2 = "TITLE";
public static final String COL_3 = "STORY";
public static final String COL_4 = "AUTHOR";
public static final String COL_5 = "DATE";





public DatabaseHelper(Context context) {
    super(context, DATABASE_NAME, null, 1);
    SQLiteDatabase db= this.getWritableDatabase(); //will create database and table, just for checking, will be replaced
}

@Override
public void onCreate(SQLiteDatabase db) {
    //creating tables ???
      db.execSQL("create table "+TABLE_NAME+" (ID INTEGER PRIMARY KEY AUTOINCREMENT, TITLE TEXT, STORY TEXT, AUTHOR TEXT, DATE STRING)");

}

@Override
public void onUpgrade(SQLiteDatabase db, int i, int i1) {
    db.execSQL("DROP TABLE IF EXISTS "+TABLE_NAME);
    onCreate(db);
}

}

我在链接上看到了类似的内容：
多表数据库SQLite android

I have seen something similar on the link: Multi-table database SQLite android

但还是不明白。

推荐答案

这是很好的教程。阅读它

this is very good tutorial..read it

您可以创建多个这样的表

you can create multiple tables like this

@Override
public void onCreate(SQLiteDatabase db) {   
  db.execSQL("create table "+TABLE_NAME+" (ID INTEGER PRIMARY KEY AUTOINCREMENT, TITLE TEXT, STORY TEXT, AUTHOR TEXT, DATE STRING)");
  db.execSQL("create table "+TABLE_NAME1+" (ID INTEGER PRIMARY KEY AUTOINCREMENT, Table1Field TEXT)");
}

@Override
public void onUpgrade(SQLiteDatabase db, int i, int i1) {
    db.execSQL("DROP TABLE IF EXISTS "+TABLE_NAME);
    db.execSQL("DROP TABLE IF EXISTS "+TABLE_NAME1);
    onCreate(db);
}

这篇关于如何在Android Studio数据库中创建多个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！