当我添加没有这种表的新表 [英] no such table when i add a new table
问题描述
我觉得功能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屋!