向SQLite数据库插入项时出错

Question

private static final int DB_VERSION = 1 ;
private static final String DB_NAME = "db-colors";
private static final String TABLE_COLORS = "tbl-colors";

private static final String CMD_CREATE_COLOR_TABLE =
        "CREATE TABLE IF NOT EXISTS '" + TABLE_COLORS +"' ('" +
                Colors.KEY_COLORNAME + "' TEXT, '" +
                Colors.KEY_COLORIMAGE + "' TEXT, '" +
                Colors.KEY_COLORRGB + "' TEXT )";


public ColorDBHelper(Context context) {
    super(context, DB_NAME, null, DB_VERSION);
}

@Override
public void onCreate(SQLiteDatabase db) {
    db.execSQL(CMD_CREATE_COLOR_TABLE);
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    db.execSQL("DROP TABLE IF EXISTS " + TABLE_COLORS );
}
public void insertColor(Colors color){

    ContentValues values = new ContentValues();
    values.put(Colors.KEY_COLORNAME,color.getColorName());
    values.put(Colors.KEY_COLORIMAGE,color.getColorImage());
    values.put(Colors.KEY_COLORRGB,color.getColorRgb());
    SQLiteDatabase database = getWritableDatabase();
    database.insert(TABLE_COLORS,null,values);
    Log.i("database","Database add an item : " + color.getColorName());
    if (database.isOpen())
        database.close();
}


public class Colors {

private String colorName ;
private String colorImage ;
private String colorRgb ;

public static final String KEY_COLORNAME = "colorName";
public static final String KEY_COLORIMAGE = "colorImage";
public static final String KEY_COLORRGB = "colorRgb";

public String getColorName() {
    return colorName;
}

public void setColorName(String colorName) {
    this.colorName = colorName;
}

public String getColorImage() {
    return colorImage;
}

public void setColorImage(String colorImage) {
    this.colorImage = colorImage;
}

public String getColorRgb() {
    return colorRgb;
}

public void setColorRgb(String colorRgb) {
    this.colorRgb = colorRgb;
}

@Override
public String toString() {

    return colorName;
}

Answer 1

您需要更改table_colors=“tbl-colors”；使用table_colors=“tbl_colors”；

由于“-”在sqlite中将被视为减号，因此需要使用“_”来代替“-”

表名验证

"xyz123" - valid
"123xyz" - not valid
"xyz_123" - valid
"_123xyz" - valid
"xyz-xyz" - not valid (looks like an expression)
"xyz.xyz" - not valid (looks like a database.table notation)