java - android.database.sqlite.SQLiteException:没有这样的列:名称(代码 1)
问题描述
我正在处理这个项目,如果应用程序离线,数据将保存到 SQLite。但是当我构建和运行时我得到了这个错误。我也检查了 SQL 查询。但无法得到确切的问题。
MainActivity.java
public class MainActivity extends AppCompatActivity {
RecyclerView recyclerView;
EditText name;
RecyclerView.LayoutManager layoutManager;
RecyclerAdapter recyclerAdapter;
ArrayList<Contact> arrayList=new ArrayList<>();
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
recyclerView=findViewById(R.id.recyclerView);
name=findViewById(R.id.name);
layoutManager=new LinearLayoutManager(this);
recyclerView.setLayoutManager(layoutManager);
recyclerView.setHasFixedSize(true);
recyclerAdapter=new RecyclerAdapter(arrayList);
recyclerView.setAdapter(recyclerAdapter);
readfromlite();
}
private void readfromlite()
{
arrayList.clear();
DbHelper dbHelper=new DbHelper(this);
SQLiteDatabase database=dbHelper.getReadableDatabase();
Cursor cursor=dbHelper.readlite(database);
while (cursor.moveToNext())
{
String name=cursor.getString(cursor.getColumnIndex(DbContract.NAME));
int sync_status= cursor.getInt(cursor.getColumnIndex(DbContract.sync_status));
arrayList.add(new Contact(name,sync_status));
}
recyclerAdapter.notifyDataSetChanged();
cursor.close();
dbHelper.close();
}
DBHelper.java
public class DbHelper extends SQLiteOpenHelper {
private static final int dbversion=1;
private static final String ctable= " create TABLE if not EXISTS " + DbContract.tname + " (id integer primary key autoincrement, " + DbContract.NAME + " text , " + DbContract.sync_status + " integer ) ; " ;
private static final String dtable= " drop table if EXISTS " + DbContract.tname ;
public DbHelper(Context context){
super(context,DbContract.dbname,null,dbversion);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(ctable);
}
@Override
public void onUpgrade(SQLiteDatabase db, int i, int i1) {
db.execSQL(dtable);
onCreate(db);
}
public void savelite(String name,int sync_status,SQLiteDatabase database){
ContentValues contentValues=new ContentValues();
contentValues.put(DbContract.NAME,name);
contentValues.put(DbContract.sync_status,sync_status);
database.insert(DbContract.tname,null,contentValues);
}
public Cursor readlite(SQLiteDatabase database){
String[] resultset={DbContract.NAME,DbContract.sync_status};
return (database.query(DbContract.tname,resultset,null,null,null,null,null));
}
public void updatelite(String name,int sync_status,SQLiteDatabase database){
ContentValues contentValues=new ContentValues();
contentValues.put(DbContract.sync_status,sync_status);
String selection=DbContract.NAME+"LIKE?";
String[] selection_args={name};
database.update(DbContract.tname,contentValues,selection,selection_args);
}
}
DbContract.java
public class DbContract {
public static final int SYNC_STATUS_OK=0;
public static final int SYNC_STATUS_FAILED=1;
public static final String dbname="contactdb";
public static final String tname="contactinfo";
public static final String NAME="name";
public static final String sync_status="syncstatus";
}
日志猫
2019-03-10 19:22:31.438 2946-2946/com.app.datamanager E/AndroidRuntime: FATAL EXCEPTION: main
Process: com.app.datamanager, PID: 2946
java.lang.RuntimeException: Unable to start activity ComponentInfo{com.app.datamanager/com.app.datamanager.MainActivity}: android.database.sqlite.SQLiteException: no such column: name (code 1): , while compiling: SELECT name, syncstatus FROM contactinfo
at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2947)
at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:3012)
at android.app.ActivityThread.-wrap12(ActivityThread.java)
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1716)
at android.os.Handler.dispatchMessage(Handler.java:110)
at android.os.Looper.loop(Looper.java:232)
at android.app.ActivityThread.main(ActivityThread.java:6802)
at java.lang.reflect.Method.invoke(Native Method)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1103)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:964)
Caused by: android.database.sqlite.SQLiteException: no such column: name (code 1): , while compiling: SELECT name, syncstatus FROM contactinfo
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:965)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:576)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1353)
at android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1200)
at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1071)
at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1239)
at com.app.datamanager.DbHelper.readlite(DbHelper.java:41)
at com.app.datamanager.MainActivity.readfromlite(MainActivity.java:52)
at com.app.datamanager.MainActivity.onCreate(MainActivity.java:36)
at android.app.Activity.performCreate(Activity.java:6974)
at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1118)
at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2900)
at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:3012)
at android.app.ActivityThread.-wrap12(ActivityThread.java)
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1716)
at android.os.Handler.dispatchMessage(Handler.java:110)
at android.os.Looper.loop(Looper.java:232)
at android.app.ActivityThread.main(ActivityThread.java:6802)
解决方案
此行产生语法错误的 sql 语句:
String selection=DbContract.NAME+"LIKE?";
如果您将像 'Bob' 这样的值作为参数传递,结果将是:(
nameLIKEBob
而不是name LIKE 'Bob'
),并且nameLIKEBob
将被视为列名。
您需要插入这样的空格:
String selection=DbContract.NAME+" LIKE ?";
推荐阅读
- python - googletrans python AttributeError:“NoneType”对象没有属性“组”
- visual-studio - 如何在优化校准上绘制 CImage?MFC
- python - 从列表中更新熊猫数据框值
- android - android以编程方式为来电设置名称
- android - 如何将我的应用程序从 expo 弹出到裸反应本机代码
- python - 如何使用数据帧与 pyspark 执行三重连接?
- powershell - 通过 PowerShell 添加新团队的问题
- c# - 拼写检查数据网格单元格
- javascript - 如何以 AM PM 格式计算时差
- svg - 动画 SVG:点击动画仅在点击边框时有效