sqlite数据库创建失败,大家帮忙看看咋回事啊小弟在此多谢了
sqlite数据库创建失败,大家帮忙看看怎么回事啊,小弟在此谢谢了
安卓sqlite调用的时候出了如下错误:
但是我创建了这一列啊
然后是创建这个表
安卓sqlite调用的时候出了如下错误:
05-11 18:29:13.947: I/Database(376): sqlite returned: error code = 1, msg = no such column: countnumber
05-11 18:29:13.947: D/AndroidRuntime(376): Shutting down VM
05-11 18:29:13.947: W/dalvikvm(376): threadid=1: thread exiting with uncaught exception (group=0x40015560)
05-11 18:29:13.956: E/AndroidRuntime(376): FATAL EXCEPTION: main
05-11 18:29:13.956: E/AndroidRuntime(376): android.database.sqlite.SQLiteException: no such column: countnumber: , while compiling: SELECT _id, name, price FROM MenuTbl ORDER BY countnumber desc
05-11 18:29:13.956: E/AndroidRuntime(376): at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method)
05-11 18:29:13.956: E/AndroidRuntime(376): at android.database.sqlite.SQLiteCompiledSql.compile(SQLiteCompiledSql.java:92)
但是我创建了这一列啊
常量类
*/
public final class Menus implements BaseColumns{
// 授权常量
public static final String AUTHORITY = "com.amaker.provider.MENUS";
// 访问Uri
public static final Uri CONTENT_URI = Uri.parse("content://" + AUTHORITY + "/menu1");
// 默认排序常量
public static final String DEFAULT_SORT_ORDER = null;// 按类型排序
// 按销量排序
public static final String COUNT_ORDER = "countnum desc";
// 表字段常量
public static final String TYPE_ID = "typeId"; //类型
public static final String NAME= "name"; // 名称
public static final String PRICE= "price"; // 价格
public static final String PIC= "pic"; // 图片
public static final String REMARK= "remark"; // 备注
// public static final String COUNT = "count"; //被点次数
public static final String COUNTNUM= "countnum";
}
然后是创建这个表
public class DBHelper extends SQLiteOpenHelper{
// 数据库名称常量
private static final String DATABASE_NAME = "Wireless_db";
// 数据库版本常量
private static final int DATABASE_VERSION = 2;
// 表名称常量
public static final String TABLES_TableTbl = "TableTbl";
public static final String TABLES_MenuTbl = "MenuTbl";
// 构造方法
public DBHelper(Context context) {
// 创建数据库
super(context, DATABASE_NAME,null, DATABASE_VERSION);
}
// 创建时调用
public void onCreate(SQLiteDatabase db) {
db.execSQL("CREATE TABLE " + TABLES_TableTbl + " ("
+ Tables._ID + " INTEGER PRIMARY KEY,"
+ Tables.NUM + " TEXT,"
+ Tables.FLAG + " TEXT,"
+ Tables.DESCRIPTION + " TEXT"
+ ");");
db.execSQL("CREATE TABLE " + TABLES_MenuTbl + " ("
+ Menus._ID + " INTEGER PRIMARY KEY,"
+ Menus.TYPE_ID + " INTEGER,"
+ Menus.NAME + " TEXT,"
+ Menus.PRICE + " INTEGER,"
+ Menus.PIC + " TEXT,"
+ Menus.REMARK + " TEXT,"