为Android创建表时出错

debugcn 发表于 Dev

bhavdip

在此类中，我将为此表声明表和列，但是

public static abstract class Wish_list_Table implements BaseColumns {
    public static final String TABLE_NAME = "WISH_LIST";
    public static final String COL_NAME = "NAME";
    public static final String COL_PHOTO = "PHOTO";
    public static final String COL_DATE = "DATE";
    public static final String COL_PRICE = "PRICE";
    public static final String COL_LATITUDE = "LATITUDE";
    public static final String COL_LONGITUDE = "LONGITUDE";
    public static final String COL_LOCATION = "LOCATION";
    public static final String COL_DESC = "DESC";

}

这是创建表的查询...这是日志猫的内容.....

java.lang.RuntimeException：无法获取提供程序com.info.wishlist.WishListProvider：android.database.sqlite.SQLiteException：在“ TABLEWISH_LIST”附近：语法错误（代码1）：，而在编译时：CREATE TABLEWISH_LIST（_idINTEGER PRIMARYKEY，NAMETEXT， DESCTEXT，地理位置，纬度，经度，价格，日期，照片）

public static final String CREATE_DB = "CREATE TABLE"
        + Wish_list_Table.TABLE_NAME + "(" + Wish_list_Table._ID
        + "INTEGER PRIMARY KEY," + Wish_list_Table.COL_NAME + "TEXT,"
        + Wish_list_Table.COL_DESC + "TEXT," + Wish_list_Table.COL_LOCATION
        + "REAL," + Wish_list_Table.COL_LATITUDE + "REAL,"
        + Wish_list_Table.COL_LONGITUDE + "REAL,"
        + Wish_list_Table.COL_PRICE + "INTEGER," + Wish_list_Table.COL_DATE
        + "INTEGER," + Wish_list_Table.COL_PHOTO + "BLOB)";

除了

您需要在列名称和类型之间放置空格

public static final String CREATE_DB = "CREATE TABLE "// note the space
+ Wish_list_Table.TABLE_NAME + "(" + Wish_list_Table._ID
    + " INTEGER PRIMARY KEY," + Wish_list_Table.COL_NAME + " TEXT,"
    + Wish_list_Table.COL_DESC + " TEXT," + Wish_list_Table.COL_LOCATION
    + " REAL," + Wish_list_Table.COL_LATITUDE + " REAL,"
    + Wish_list_Table.COL_LONGITUDE + " REAL,"
    + Wish_list_Table.COL_PRICE + " INTEGER," + Wish_list_Table.COL_DATE
    + " INTEGER," + Wish_list_Table.COL_PHOTO + " BLOB)";

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。