检查 Android 中 Sqlite 中的现有记录？

发布于 2024-10-31 19:27:27 字数 536 浏览 0 评论 0原文

大家好，

我正在尝试在插入记录之前检查 Android 中是否存在现有记录。我收到一个异常，当我检查 logcat 时，它说它是一个语法错误。需要一些紧急帮助，

谢谢

DbConnection dbConnection = new DbConnection(EnterDetails.this);
db = dbConnection.getReadableDatabase();
Cursor cursor = db.rawQuery("SELECT 1 FROM" + DbConnection.TABLE + " WHERE "+ DbConnection.C_MNUMBER + " = " +EditTextMobileNumber.getText().toString().trim(),null);
boolean flag = (cursor.getCount() > 0);
Toast.makeText(EnterDetails.this,"Record Found",Toast.LENGTH_LONG).show();
return false;

原文

Hii guys

Im trying to check for an existing record in android before inserting a record. i get an exception and when i check the logcat it says its a syntax error. need some Urget help with this guys

thanks

DbConnection dbConnection = new DbConnection(EnterDetails.this);
db = dbConnection.getReadableDatabase();
Cursor cursor = db.rawQuery("SELECT 1 FROM" + DbConnection.TABLE + " WHERE "+ DbConnection.C_MNUMBER + " = " +EditTextMobileNumber.getText().toString().trim(),null);
boolean flag = (cursor.getCount() > 0);
Toast.makeText(EnterDetails.this,"Record Found",Toast.LENGTH_LONG).show();
return false;

分享到QQ

分享到微博