android错误显示没有这样的表-Java 学习之路

我在我的项目中得到了 error no such table not found 我使用了 2 database . 一个是完美的工作，但另一个显示错误 .

这是我的代码

public void onCreate(SQLiteDatabase db) {
    // TODO Auto-generated method stub
    String CREATE_ADDRESS = " CREATE TABLE " + TABLE_ADDRESS  + "(" + KEY_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"+ KEY_STATE + " TEXT," + KEY_CITY + " TEXT," + KEY_ZIPCODE + " TEXT," + KEY_STREET + " TEXT," + KEY_DOOR + " TEXT,"+ ");";      
    try{
        db.execSQL(CREATE_ADDRESS);
    }catch (SQLException e)
    {
        e.printStackTrace();
    }
}

我试图使用此代码插入数据

public void addAddress(AddressList address)
{
    SQLiteDatabase db = this.getWritableDatabase();
    ContentValues values = new ContentValues();
    values.put(KEY_STATE, address.getState());
    values.put(KEY_CITY, address.getCity());
    values.put(KEY_ZIPCODE, address.getZipcode());
    values.put(KEY_STREET, address.getStreet());
    values.put(KEY_DOOR, address.getDoor());
    db.insert(TABLE_ADDRESS,null, values);

    db.close();
}

3 回答

在最后一个TEXT之后的create table语法中有一个额外的 , （逗号） . 您需要删除它，因为它根据create table的语法无效 .

用这个

String CREATE_ADDRESS = " CREATE TABLE " + TABLE_ADDRESS  + "(" + KEY_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"+ KEY_STATE + " TEXT," + KEY_CITY + " TEXT," + KEY_ZIPCODE + " TEXT," + KEY_STREET + " TEXT," + KEY_DOOR + " TEXT"+ ");";

回复于 2024-05-06T04:30:03+08:00

0
因为您的DML语句不正确，然后您的第二个表未创建 . 您必须从导致错误的语句中删除最后一个逗号 . 在表的最后一列后面不能是逗号，因为它是最后一列 .
```
+ KEY_DOOR + " TEXT"+ ");
```
回复于 2024-05-06T04:30:03+08:00

您已为最后一列添加了 , ＆ ; 分号 . 尝试删除最后的 , ＆ ; 可能会修复您的错误 .

public void onCreate(SQLiteDatabase db) {
 // TODO Auto-generated method stub
 String CREATE_ADDRESS = " CREATE TABLE " + TABLE_ADDRESS  + "(" + KEY_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"+ KEY_STATE + " TEXT," + KEY_CITY + " TEXT," + KEY_ZIPCODE + " TEXT," + KEY_STREET + " TEXT," + KEY_DOOR + "  TEXT" + ")";      
 try{
     db.execSQL(CREATE_ADDRESS);
 }catch (SQLException e)
 {
     e.printStackTrace();
 }
}

回复于 2024-05-06T04:30:03+08:00

android错误显示没有这样的表

3 回答

相关问题