当我添加没有这种表的新表 [英] no such table when i add a new table

查看:145
本文介绍了当我添加没有这种表的新表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我觉得功能onUpgrade之前,我添加一个新表。它不是错误没有工作监守。
当我添加的类别表(新表)。我从1更改database_version = 2当我运行模拟器.LOG猫起诉没有这样的表类,我不知道如何修改它。请检查
并告诉我为什么onUpgrade是不行的。

这是我的code(BookDBHelper)

 进口android.content.Context;
进口android.database.sqlite.SQLiteDatabase;
进口android.database.sqlite.SQLiteDatabase.CursorFactory;
进口android.database.sqlite.SQLiteOpenHelper;公共类BooksDBHelper扩展SQLiteOpenHelper {
// databse_name
公共静态字符串DATABSE_NAME =bookguk;
// database_version
受保护的静态最终诠释DATABASE_VERSION = 2; //<<< ---我把它从版本1更改为2版本时,添加一个新表类别//表名
公共静态字符串TABLE_BOOK =书;
公共静态字符串TABLE_IMAGE =图像;
公共静态字符串TABLE_INGREDIENT =成分;
公共静态字符串TABLE_CATEGORY =类别;
//列名
公共静态字符串KEY_ID =ID;
公共静态字符串KEY_TITLE =称号;
公共静态字符串KEY_SOLUTION =解决方案;
公共静态字符串KEY_BOK_ID =BOOKID;
公共静态字符串KEY_fILEPATH =文件路径;
公共静态字符串KEY_VALUE =值;
公共静态字符串KEY_UNIT =单位;
公共静态字符串KEY_NAME =名;
公共静态字符串KEY_CAT_ID =CAT_ID;公共静态字符串BOOK_CREATE_SQL =CREATE TABLE IF NOT EXISTS+ TABLE_BOOK +(+
                                + KEY_ID +INTEGER PRIMARY KEY AUTOINCREMENT,+
                                + KEY_TITLE +TEXT(50)不为空,+
                                + KEY_SOLUTION +TEXT(255)NOT NULL,+
                                + KEY_CAT_ID +INTEGER(11),+
                                外键(+ KEY_CAT_ID +)参考+ TABLE_CATEGORY +(+ KEY_ID +));公共静态字符串IMAGE_CREATE_SQL =CREATE TABLE IF NOT EXISTS+ TABLE_IMAGE +(+
                                + KEY_ID +INTEGER PRIMARY KEY AUTOINCREMENT,+
                                + KEY_fILEPATH +VACHAR(255),+
                                + KEY_BOK_ID +INTEGER(11),+
                                外键(+ KEY_BOK_ID +)参考+ TABLE_BOOK +(+ KEY_ID +));公共静态字符串INGREDIENT_CREATE_SQL =CREATE TABLE IF NOT EXISTS+ TABLE_INGREDIENT +(+
                                + KEY_ID +INTEGER PRIMARY KEY AUTOINCREMENT,+
                                + KEY_VALUE +DOUBLE(11),+
                                + KEY_UNIT +VACHAR(50),+
                                + KEY_fILEPATH +VACHAR(255),+
                                + KEY_BOK_ID +INTEGER(11),+
                                外键(+ KEY_BOK_ID +)参考+ TABLE_BOOK +(+ KEY_ID +));公共静态字符串CATEGORY_CREATE_SQL =CREATE TABLE IF NOT EXISTS+ TABLE_CATEGORY +(+
                                + KEY_ID +INTEGER PRIMARY KEY AUTOINCREMENT,+
                                + KEY_NAME +VACHAR(50)+
                                );//构造
公共BooksDBHelper(上下文的背景下){
    超(背景下,DATABSE_NAME,空,DATABASE_VERSION);
    // TODO自动生成构造函数存根
}//创建
@覆盖
公共无效的onCreate(SQLiteDatabase DB){
            db.execSQL(CATEGORY_CREATE_SQL);
    db.execSQL(BOOK_CREATE_SQL);
    db.execSQL(IMAGE_CREATE_SQL);
    db.execSQL(INGREDIENT_CREATE_SQL);
}@覆盖
公共无效onUpgrade(SQLiteDatabase分贝,INT oldVersion,诠释静态网页){
    // TODO自动生成方法存根    db.execSQL(DROP TABLE IF EXISTS+ TABLE_BOOK);
    db.execSQL(DROP TABLE IF EXISTS+ TABLE_IMAGE);
    db.execSQL(DROP TABLE IF EXISTS+ TABLE_INGREDIENT);
    db.execSQL(DROP TABLE IF EXISTS+ TABLE_CATEGORY);
    的onCreate(DB);}}

这是我的操作符(插入数据表类)

 包com.example.mutitablesql.db;进口的java.util.ArrayList;进口com.example.mutitablesql.entry.BookEntry;
进口com.example.mutitablesql.entry.CategoryEntry;
进口com.example.mutitablesql.entry.ImageEntry;
进口android.content.ContentValues​​;
进口android.content.Context;
进口android.database.Cursor;
进口android.database.sqlite.SQLiteDatabase;公共类BooksDB {
//นำ类booksDBHelperมาสร้างเป็น对象
私人BooksDBHelper帮手;
私人SQLiteDatabase分贝;//สร้าง构造
公共BooksDB(上下文的背景下){
    //คำสั่งเรียก构造ของ类BooksDBHelper
    助手=新BooksDBHelper(背景);
    DB = helper.getWritableDatabase();
}//插入到表类别
众长insertCategory(字符串名称){
    ContentValues​​值=新ContentValues​​();
    values​​.put(BooksDBHelper.KEY_NAME,名);
    返回db.insert(BooksDBHelper.TABLE_CATEGORY,空,价值);}

我的mainactivity code

 保护无效的onCreate(捆绑savedInstanceState){
    super.onCreate(savedInstanceState);
    的setContentView(R.layout.activity_main);
    上下文=这一点;
    DB =新BooksDB(背景);    db.insertCategory(ต้ม);
    db.insertCategory(ผัด);
    db.insertCategory(แกง);
    db.insertCategory(ทอด);
    db.insertCategory(ประเภทเส้น);
    db.insertCategory(เครื่องดื่ม);
    db.insertCategory(ของหวาน);
}

这是我的logcat修改

 九月九日至2日:47:29.869:E / SQLiteLog(1220):(1)附近的参考:语法错误
9月9日至2日:47:29.889:D / AndroidRuntime(1220):关闭VM
9月9日至2日:47:29.889:W / dalvikvm(1220):主题ID = 1:螺纹未捕获的异常退出(组= 0x40a71930)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):致命异常:主要
9月9日至2日:47:29.919:E / AndroidRuntime(1220):了java.lang.RuntimeException:无法启动活动ComponentInfo {com.example.mutitablesql / com.example.mutitablesql.MainActivity}:android.database.sqlite.SQLiteException :附近的参考:语法错误(code 1),在编译:CREATE TABLE IF NOT EXISTS书(ID INTEGER PRIMARY KEY AUTOINCREMENT,标题文本(50)NOT NULL,解决TEXT(255)不为空,CAT_ID INTEGER(11),外键(CAT_ID)参考类别(ID))
9月9日至2日:47:29.919:E / AndroidRuntime(1220):在android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2180)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):在android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2230)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):在android.app.ActivityThread.access $ 600(ActivityThread.java:141)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):在android.app.ActivityThread $ H.handleMessage(ActivityThread.java:1234)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):在android.os.Handler.dispatchMessage(Handler.java:99)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):在android.os.Looper.loop(Looper.java:137)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):在android.app.ActivityThread.main(ActivityThread.java:5041)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):在java.lang.reflect.Method.invokeNative(本机方法)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):在java.lang.reflect.Method.invoke(Method.java:511)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):在com.android.internal.os.ZygoteInit $ MethodAndArgsCaller.run(ZygoteInit.java:793)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):在com.android.internal.os.ZygoteInit.main(ZygoteInit.java:560)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):在dalvik.system.NativeStart.main(本机方法)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):android.database.sqlite.SQLiteException:由近造成参考:语法错误(code 1),在编译:CREATE TABLE IF NOT EXISTS书(ID INTEGER PRIMARY KEY AUTOINCREMENT,标题文本(50)NOT NULL,解决TEXT(255)NOT NULL,CAT_ID INTEGER(11),外键(CAT_ID)参考类别(ID))
9月9日至2日:47:29.919:E / AndroidRuntime(1220):在android.database.sqlite.SQLiteConnection.native prepareStatement(本机方法)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):在android.database.sqlite.SQLiteConnection.acquire preparedStatement(SQLiteConnection.java:882)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):在android.database.sqlite.SQLiteConnection prepare(SQLiteConnection.java:493)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):在android.database.sqlite.SQLiteSession prepare(SQLiteSession.java:588)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):在android.database.sqlite.SQLiteProgram<&初始化GT;(SQLiteProgram.java:58)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):在android.database.sqlite.SQLiteStatement<&初始化GT;(SQLiteStatement.java:31)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):在android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1663)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):在android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1594)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):在com.example.mutitablesql.db.BooksDBHelper.onCreate(BooksDBHelper.java:67)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):在com.example.mutitablesql.db.BooksDBHelper.onUpgrade(BooksDBHelper.java:82)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):在android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:257)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):在android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:164)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):在com.example.mutitablesql.db.BooksDB<&初始化GT;(BooksDB.java:23)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):在com.example.mutitablesql.MainActivity.onCreate(MainActivity.java:21)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):在android.app.Activity.performCreate(Activity.java:5104)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):在android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1080)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):在android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2144)
9月9日至2日:47:29.919:E / AndroidRuntime(1220):11 ...更多


解决方案

纵观到onUpgrade code:

  @覆盖
公共无效onUpgrade(SQLiteDatabase分贝,INT oldVersion,诠释静态网页){
    // TODO自动生成方法存根db.execSQL(DROP TABLE IF退出+ TABLE_BOOK);
db.execSQL(DROP TABLE IF退出+ TABLE_IMAGE);
db.execSQL(DROP TABLE IF退出+ TABLE_INGREDIENT);
db.execSQL(DROP TABLE IF退出+ TABLE_CATEGORY);
的onCreate(DB);

}

我知道你有一个错误拼写错误,退出是EXISTS

i think function onUpgrade is not working becuase before i add a new table .it's not error. when i add category table (a new table) . i change database_version = 2 from 1 when i run emulator .log cat sue "No such table category" and i don't know how to modify it. please check and tell me why onUpgrade isn't work.

This is my code (BookDBHelper)

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;

public class BooksDBHelper extends SQLiteOpenHelper {
//databse_name
public static String DATABSE_NAME = "bookguk";
// database_version
protected static final int DATABASE_VERSION = 2;  //  <<<---i have changed it to version 2 from version 1 when add a new table category

//table name
public static String TABLE_BOOK = "books";
public static String TABLE_IMAGE = "images";
public static String TABLE_INGREDIENT = "ingredients";
public static String TABLE_CATEGORY = "category";
//column_name
public static String KEY_ID = "id";
public static String KEY_TITLE = "title";
public static String KEY_SOLUTION = "solution";
public static String KEY_BOK_ID = "bookID";
public static String KEY_fILEPATH = "filepath";
public static String KEY_VALUE = "value" ;
public static String KEY_UNIT = "unit";
public static String KEY_NAME = "name";
public static String KEY_CAT_ID = "cat_id";

public static String BOOK_CREATE_SQL = "CREATE TABLE IF NOT EXISTS " + TABLE_BOOK + "(" +
                                ""+KEY_ID+" INTEGER PRIMARY KEY AUTOINCREMENT," +
                                ""+KEY_TITLE+" TEXT(50) not null," +
                                ""+KEY_SOLUTION+" TEXT(255) not null," +
                                ""+KEY_CAT_ID+" INTEGER(11)," +
                                " FOREIGN KEY("+KEY_CAT_ID+") REFERENCE "+TABLE_CATEGORY+" ("+KEY_ID+"))";

public static String IMAGE_CREATE_SQL = "CREATE TABLE IF NOT EXISTS " + TABLE_IMAGE + "(" +
                                ""+KEY_ID+" INTEGER PRIMARY KEY AUTOINCREMENT," +
                                ""+KEY_fILEPATH+" VACHAR(255)," +
                                ""+KEY_BOK_ID+" INTEGER(11)," +
                                " FOREIGN KEY("+KEY_BOK_ID+") REFERENCES "+TABLE_BOOK+" ("+KEY_ID+"))";

public static String INGREDIENT_CREATE_SQL = "CREATE TABLE IF NOT EXISTS " + TABLE_INGREDIENT + "(" +
                                ""+KEY_ID+" INTEGER PRIMARY KEY AUTOINCREMENT," +
                                ""+KEY_VALUE+" DOUBLE(11)," +
                                ""+KEY_UNIT+" VACHAR(50)," +
                                ""+KEY_fILEPATH+" VACHAR(255)," +
                                ""+KEY_BOK_ID+" INTEGER(11)," +
                                " FOREIGN KEY("+KEY_BOK_ID+")REFERENCES "+TABLE_BOOK+" ("+KEY_ID+"))";

public static String CATEGORY_CREATE_SQL = "CREATE TABLE IF NOT EXISTS " + TABLE_CATEGORY + "(" +
                                ""+KEY_ID+" INTEGER PRIMARY KEY AUTOINCREMENT," +
                                ""+KEY_NAME+" VACHAR(50) " +
                                ")";



//constructor
public BooksDBHelper(Context context) {
    super(context, DATABSE_NAME, null, DATABASE_VERSION);
    // TODO Auto-generated constructor stub
}

//create
@Override
public void onCreate(SQLiteDatabase db) {
            db.execSQL(CATEGORY_CREATE_SQL);
    db.execSQL(BOOK_CREATE_SQL);
    db.execSQL(IMAGE_CREATE_SQL);
    db.execSQL(INGREDIENT_CREATE_SQL);


}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    // TODO Auto-generated method stub

    db.execSQL("DROP TABLE IF EXISTS " + TABLE_BOOK );
    db.execSQL("DROP TABLE IF EXISTS " + TABLE_IMAGE );
    db.execSQL("DROP TABLE IF EXISTS " + TABLE_INGREDIENT );
    db.execSQL("DROP TABLE IF EXISTS " + TABLE_CATEGORY );
    onCreate(db);

}

}

This is my operator (insert data to table category)

package com.example.mutitablesql.db;

import java.util.ArrayList;

import com.example.mutitablesql.entry.BookEntry;
import com.example.mutitablesql.entry.CategoryEntry;
import com.example.mutitablesql.entry.ImageEntry;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

public class BooksDB {
//นำ class booksDBHelper มาสร้างเป็น object
private BooksDBHelper helper;
private SQLiteDatabase db;

//สร้าง constructor
public BooksDB(Context context){
    // คำสั่ง เรียก constructor ของclass BooksDBHelper
    helper = new BooksDBHelper(context);
    db = helper.getWritableDatabase();
}

//insert into table category
public long insertCategory(String name){
    ContentValues values = new ContentValues();
    values.put(BooksDBHelper.KEY_NAME, name);
    return db.insert(BooksDBHelper.TABLE_CATEGORY, null, values);

}

my mainactivity code

protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);
    context = this;
    db = new BooksDB(context);

    db.insertCategory("ต้ม");
    db.insertCategory("ผัด");
    db.insertCategory("แกง");
    db.insertCategory("ทอด");
    db.insertCategory("ประเภทเส้น");
    db.insertCategory("เครื่องดื่ม");
    db.insertCategory("ของหวาน");
}

this is my logcat edit

09-02 09:47:29.869: E/SQLiteLog(1220): (1) near "REFERENCE": syntax error
09-02 09:47:29.889: D/AndroidRuntime(1220): Shutting down VM
09-02 09:47:29.889: W/dalvikvm(1220): threadid=1: thread exiting with uncaught exception (group=0x40a71930)
09-02 09:47:29.919: E/AndroidRuntime(1220): FATAL EXCEPTION: main
09-02 09:47:29.919: E/AndroidRuntime(1220): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.mutitablesql/com.example.mutitablesql.MainActivity}: android.database.sqlite.SQLiteException: near "REFERENCE": syntax error (code 1): , while compiling: CREATE TABLE IF NOT EXISTS books(id INTEGER PRIMARY KEY AUTOINCREMENT,title TEXT(50) not null,solution TEXT(255) not null,cat_id INTEGER(11), FOREIGN KEY(cat_id) REFERENCE category (id))
09-02 09:47:29.919: E/AndroidRuntime(1220):     at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2180)
09-02 09:47:29.919: E/AndroidRuntime(1220):     at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2230)
09-02 09:47:29.919: E/AndroidRuntime(1220):     at android.app.ActivityThread.access$600(ActivityThread.java:141)
09-02 09:47:29.919: E/AndroidRuntime(1220):     at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1234)
09-02 09:47:29.919: E/AndroidRuntime(1220):     at android.os.Handler.dispatchMessage(Handler.java:99)
09-02 09:47:29.919: E/AndroidRuntime(1220):     at android.os.Looper.loop(Looper.java:137)
09-02 09:47:29.919: E/AndroidRuntime(1220):     at android.app.ActivityThread.main(ActivityThread.java:5041)
09-02 09:47:29.919: E/AndroidRuntime(1220):     at java.lang.reflect.Method.invokeNative(Native Method)
09-02 09:47:29.919: E/AndroidRuntime(1220):     at java.lang.reflect.Method.invoke(Method.java:511)
09-02 09:47:29.919: E/AndroidRuntime(1220):     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:793)
09-02 09:47:29.919: E/AndroidRuntime(1220):     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:560)
09-02 09:47:29.919: E/AndroidRuntime(1220):     at dalvik.system.NativeStart.main(Native Method)
09-02 09:47:29.919: E/AndroidRuntime(1220): Caused by: android.database.sqlite.SQLiteException: near "REFERENCE": syntax error (code 1): , while compiling: CREATE TABLE IF NOT EXISTS books(id INTEGER PRIMARY KEY AUTOINCREMENT,title TEXT(50) not null,solution TEXT(255) not null,cat_id INTEGER(11), FOREIGN KEY(cat_id) REFERENCE category (id))
09-02 09:47:29.919: E/AndroidRuntime(1220):     at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
09-02 09:47:29.919: E/AndroidRuntime(1220):     at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:882)
09-02 09:47:29.919: E/AndroidRuntime(1220):     at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:493)
09-02 09:47:29.919: E/AndroidRuntime(1220):     at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
09-02 09:47:29.919: E/AndroidRuntime(1220):     at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
09-02 09:47:29.919: E/AndroidRuntime(1220):     at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
09-02 09:47:29.919: E/AndroidRuntime(1220):     at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1663)
09-02 09:47:29.919: E/AndroidRuntime(1220):     at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1594)
09-02 09:47:29.919: E/AndroidRuntime(1220):     at com.example.mutitablesql.db.BooksDBHelper.onCreate(BooksDBHelper.java:67)
09-02 09:47:29.919: E/AndroidRuntime(1220):     at com.example.mutitablesql.db.BooksDBHelper.onUpgrade(BooksDBHelper.java:82)
09-02 09:47:29.919: E/AndroidRuntime(1220):     at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:257)
09-02 09:47:29.919: E/AndroidRuntime(1220):     at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:164)
09-02 09:47:29.919: E/AndroidRuntime(1220):     at com.example.mutitablesql.db.BooksDB.<init>(BooksDB.java:23)
09-02 09:47:29.919: E/AndroidRuntime(1220):     at com.example.mutitablesql.MainActivity.onCreate(MainActivity.java:21)
09-02 09:47:29.919: E/AndroidRuntime(1220):     at android.app.Activity.performCreate(Activity.java:5104)
09-02 09:47:29.919: E/AndroidRuntime(1220):     at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1080)
09-02 09:47:29.919: E/AndroidRuntime(1220):     at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2144)
09-02 09:47:29.919: E/AndroidRuntime(1220):     ... 11 more

解决方案

Taking a look into your onUpgrade code:

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    // TODO Auto-generated method stub

db.execSQL("DROP TABLE IF EXITS " + TABLE_BOOK );
db.execSQL("DROP TABLE IF EXITS " + TABLE_IMAGE );
db.execSQL("DROP TABLE IF EXITS " + TABLE_INGREDIENT );
db.execSQL("DROP TABLE IF EXITS " + TABLE_CATEGORY );
onCreate(db);

}

I realize that you have a mispelling error, EXITS is EXISTS

这篇关于当我添加没有这种表的新表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆