我的数据是否成功插入数据库？

Question

我用database的.replace方法插入数据到数据库，取数据时总是取不到，怀疑是没插入成功

//插入数据的方法
public void addAccount (UserInfo userInfo){
        //获取数据库
        SQLiteDatabase database = userAccount.getReadableDatabase();
        //封装用户信息
        ContentValues values = new ContentValues();
        values.put(UserAccountTable.ID,userInfo.getUserId());
        values.put(UserAccountTable.NAME,userInfo.getName());
        values.put(UserAccountTable.NICK,userInfo.getNick());
        values.put(UserAccountTable.PICTURE,userInfo.getPicture());

        database.replace(UserAccountTable.TABLE_NAME,null,values);
}
//获取数据的方法
public UserInfo getAccountInfo(String id){
        //获取数据库
        SQLiteDatabase database = userAccount.getReadableDatabase();
        //查询
        String sql = "select * from " + UserAccountTable.TABLE_NAME + " where " + UserAccountTable.ID + "=?";
        Cursor cursor = database.rawQuery(sql, new String[]{id});

        UserInfo userInfo = null;
        if (cursor.moveToNext()) {
            userInfo = new UserInfo();
            //封装
            userInfo.setName(cursor.getString(cursor.getColumnIndex(UserAccountTable.NAME)));
            userInfo.setUserId(cursor.getString(cursor.getColumnIndex(UserAccountTable.ID)));
            userInfo.setNick(cursor.getString(cursor.getColumnIndex(UserAccountTable.NICK)));
            userInfo.setPicture(cursor.getString(cursor.getColumnIndex(UserAccountTable.PICTURE)));
        }
        //关闭
        cursor.close();
        return userInfo;
}

Answer 1

已解决，之前建好的表有问题，后面无论怎么改动建表语句，都不会更改建好的表，把之前建好的表删掉，重新建表就好了。