android.database.sqlite.SQLiteException：表abc没有名为xyz的列

debugcn 发表于 Dev

Android开发人员

尝试在SQLite数据库中插入记录时出现以下错误-

android.database.sqlite.SQLiteException：表jolly没有名为noOfShares（代码1）的列：，而在编译时：INSERT INTO jolly（noOfShares，id，noOfMustGos，noOfSeen，caption，noOfBeenTheres，location）VALUES（？，？，？，？，？，？，？）

我不明白为什么它按此顺序显示列：

noOfShares
ID
noOfMustGos
noOfSeen
标题
noOfBeenTheres
地点

而我创建了具有不同列顺序的表，并以相同顺序分配值。我尝试卸载该应用程序，还更改了表名，但未解决。

适配器：

VideoSql videoSql;
    public View getView(final int i, View v, ViewGroup viewGroup) {
    videoSql=new VideoSql();
DatabaseHandler db = new DatabaseHandler(mContext);
        videoSql.setId(mVideos.get(i).getId());
        videoSql.setCaption(mVideos.get(i).getCaption());
        videoSql.setNoOfMustGos(mVideos.get(i).getNoOfMustGos());
        videoSql.setNoOfShares(mVideos.get(i).getNoOfShares());
        videoSql.setLocation(mVideos.get(i).getLocation());
        videoSql.setNoOfBeenTheres(mVideos.get(i).getNoOfBeenTheres());
        videoSql.setNoOfSeen(mVideos.get(i).getNoOfSeen());

        db.addContact(videoSql);
}

DatabaseHandler：

public class DatabaseHandler extends SQLiteOpenHelper {

    // All Static variables
    // Database Version
    private static final int DATABASE_VERSION = 1;
VideoSql mvideo;
    // Database Name
    private static final String DATABASE_NAME = "TDatabase";

    // Contacts table name
    private static final String TABLE_JOLLY = "jolly";

    // Contacts Table Columns names
    private static final String KEY_ID = "id";
    private static final String KEY_CAPTION = "caption";
    private static final String KEY_LOCATION = "location";
    private static final String KEY_NOSHARES = "noOfShares";
    private static final String KEY_NOBEENTHERE = "noOfBeenTheres";
    private static final String KEY_NOMUSTGO = "noOfMustGos";
    private static final String KEY_NOCOMMENTS = "noOfComments";
    private static final String KEY_NOSEEN = "noOfSeen";
    private static final String KEY_USERNAME = "userName";
    private static final String KEY_USERID = "userId";
    private static final String KEY_TIMESTAMP ="timestamp" ;
    private static final String KEY_FOLLOWED = "followed";
    private static final String KEY_BEENTHERE = "beenThere";
    private static final String KEY_MUSTGO = "mustGo";
    private static final String KEY_NOFOLLOWED = "noOfFollowed";
    private static final String KEY_NOFOLLOWERS = "noOfFollowers";
    private static final String KEY_USERHANDLE = "userHandle";
    private static final String KEY_DTS = "dts";
    private static final String KEY_FEATURED = "featured";
    public DatabaseHandler(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);

    }
    @Override
    public void onCreate(SQLiteDatabase db) {


        String CREATE_JOLLY_TABLE = "CREATE TABLE " + TABLE_JOLLY + "("
                + KEY_ID +  KEY_CAPTION +  KEY_LOCATION +  KEY_NOSHARES + KEY_NOBEENTHERE +KEY_NOMUSTGO +
                 KEY_NOSEEN +")" ;
        db.execSQL(CREATE_JOLLY_TABLE);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion {

        db.execSQL("DROP TABLE IF EXISTS " + TABLE_JOLLY);

        onCreate(db);
    }

    public void addContact(VideoSql videoSql)
    {
        SQLiteDatabase db = this.getWritableDatabase();

        ContentValues values = new ContentValues();
        values.put(KEY_ID, videoSql.getId());
        values.put(KEY_CAPTION, videoSql.getCaption());
        values.put(KEY_LOCATION, videoSql.getLocation());
        values.put(KEY_NOSHARES, videoSql.getNoOfShares());
        values.put(KEY_NOBEENTHERE, videoSql.getNoOfBeenTheres());
        values.put(KEY_NOMUSTGO, videoSql.getNoOfMustGos());

        values.put(KEY_NOSEEN, videoSql.getNoOfSeen());

        db.insert(TABLE_JOLLY, null, values);

        Log.e("addcontact", videoSql.getCaption());
        db.close(); // Closing database connection
    }

    // Getting All Contacts
    public List<VideoSql> getAllContacts() {
        List<VideoSql> contactList = new ArrayList<VideoSql>();

        String selectQuery = "SELECT  * FROM " + TABLE_JOLLY;

        SQLiteDatabase db = this.getWritableDatabase();
        Cursor cursor = db.rawQuery(selectQuery, null);


        if (cursor.moveToFirst())
        {
            do
            {
                VideoSql videoinfo = new VideoSql();
                videoinfo.setId(cursor.getString(0));
                videoinfo.setCaption(cursor.getString(1));
                videoinfo.setLocation(cursor.getString(2));
                videoinfo.setNoOfShares(cursor.getString(3));
                videoinfo.setNoOfBeenTheres(cursor.getString(4));
                videoinfo.setNoOfMustGos(cursor.getString(5));

                videoinfo.setNoOfSeen(cursor.getString(6));


                contactList.add(videoinfo);
            }
            while (cursor.moveToNext());
        }


        return contactList;
    }
}

路西法

实际上，您在创建表语法中缺少了每一列的数据类型。

您应该使用以下语法创建表，

String CREATE_JOLLY_TABLE = "CREATE TABLE " + TABLE_JOLLY + "("
            + KEY_ID + " integer primary key autoincrement,"
......<other column-name> <column-type>; ///

注意：完成上述建议的更改后，您应该首先从设备中删除旧的应用程序，然后再次对其进行测试，否则它将继续给您同样的错误，onCreate(SQLiteDatabase db)因为由于它已使用旧实例执行，因此不会执行方法。因此，要执行onCreate(SQLiteDatabase db)的代码，建议从设备中删除完全旧的应用程序，然后重新执行代码。

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

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