java - 运行 SQLite 命令时 Android Studio 日志显示错误
问题描述
我正在尝试创建一个数据库和一个表来存储我的卡的详细信息,然后显示它。我创建了这个架构
public class MyDatabaseHelper extends SQLiteOpenHelper {
private Context context;
private static String DB_NAME="CardsDetails.db";
private static final int DB_VERSION=1;
private static final String table_name="my_cards";
private static final String id="_id";
private static final String card_num="Card Number";
private static final String cvv="cvv";
private static final String year="year";
private static final String month="month";
private static final String user_name="Name on Card";
public MyDatabaseHelper(@Nullable Context context) {
super(context,DB_NAME,null,DB_VERSION);
this.context=context;
}
@Override
public void onCreate(SQLiteDatabase db) {
String query= "CREATE TABLE "+table_name+" ("+id+" INTEGER PRIMARY KEY AUTOINCREMENT, "+"card_num"+" TEXT, "+month+" TEXT, "+year+" TEXT, "+cvv+" TEXT, "+user_name+" TEXT);";
db.execSQL(query);
}
@Override
public void onUpgrade(SQLiteDatabase db, int i, int i1) {
db.execSQL("DROP TABLE IF EXISTS "+table_name);
onCreate(db);
}
void addCard(String CardNo, String mon_, String year_, String cvv_, String name)
{
SQLiteDatabase db=this.getWritableDatabase();
ContentValues cv=new ContentValues();
cv.put(card_num,CardNo);
cv.put(month,mon_);
cv.put(year,year_);
cv.put(cvv,cvv_);
cv.put(user_name,name);
long result=db.insert(table_name,null,cv);
if(result==-1)
Toast.makeText(context,"Input Failed!",Toast.LENGTH_LONG).show();
else
Toast.makeText(context,"Card Saved Successfully",Toast.LENGTH_LONG).show();
}
}
但是,我在这段代码中遇到了一些我不理解的错误和异常。这是日志中的片段。
E/SQLiteLog: (1) near "on": syntax error
D/AndroidRuntime: Shutting down VM
E/AndroidRuntime: FATAL EXCEPTION: main
Process: com.antas.fingerprintauth, PID: 22200
android.database.sqlite.SQLiteException: near "on": syntax error (code 1 SQLITE_ERROR): , while compiling: CREATE TABLE my_cards (_id INTEGER PRIMARY KEY AUTOINCREMENT, card_num TEXT, month TEXT, year TEXT, cvv TEXT, Name on Card TEXT);
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:986)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:593)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:590)
at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:61)
at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:33)
at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1850)
at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1773)
at com.antas.fingerprintauth.MyDatabaseHelper.onCreate(MyDatabaseHelper.java:34)
at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:412)
at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:317)
at com.antas.fingerprintauth.MyDatabaseHelper.addCard(MyDatabaseHelper.java:45)
at com.antas.fingerprintauth.AddDetails$1.onClick(AddDetails.java:60)
at android.view.View.performClick(View.java:7218)
at android.view.View.performClickInternal(View.java:7187)
at android.view.View.access$3500(View.java:817)
at android.view.View$PerformClick.run(View.java:27629)
at android.os.Handler.handleCallback(Handler.java:883)
at android.os.Handler.dispatchMessage(Handler.java:100)
at android.os.Looper.loop(Looper.java:214)
at android.app.ActivityThread.main(ActivityThread.java:7707)
at java.lang.reflect.Method.invoke(Native Method)
at com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:516)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:950)
这是我将数据插入数据库的活动。
public class AddDetails extends AppCompatActivity {
EditText card_num, cvv, yr, mo, user;
int i = 0;
Button saveBtn;
ImageButton validate;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_add_details);
card_num = (EditText) findViewById(R.id.cardnum);
cvv = (EditText) findViewById(R.id.cvv);
yr = (EditText) findViewById(R.id.year);
mo = (EditText) findViewById(R.id.month);
saveBtn = (Button) findViewById(R.id.save);
user = (EditText) findViewById(R.id.nameCard);
validate = (ImageButton) findViewById(R.id.visibility);
card_num.requestFocus();
saveBtn.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View view) {
.setError("Enter Name on Card");
}
else {*/
MyDatabaseHelper myDatabaseHelper = new MyDatabaseHelper(AddDetails.this);
myDatabaseHelper.addCard(card_num.getText().toString().trim(), mo.getText().toString().trim(), yr.getText().toString().trim(), cvv.getText().toString().trim(), user.getText().toString().trim());
}
});
}
}
有人可以帮帮我吗!
解决方案
您正在使用在这些常量中定义的值创建 sql 语句。您的“name”参数的值是“name on card”,因此当它被替换到您的 create 语句中时,您会得到非法语法,因为表名不能包含空格。
推荐阅读
- jsf - com.sun.faces.el.ELUtils.coerce 处的 java.lang.NullPointerException
- c# - 实体框架将两个表连接在一起以在 MVC 视图中显示
- javascript - 如何使用流类型提示和 Jest 处理错误
- php - 尽管明显失败,但如果通过图像验证,为什么?
- java - RabbitTemplate 扩展 DirectReplyToMessageListenerContainer
- tensorflow - keras / tensorflow中的意思和stddev是什么意思
- arrays - 如何检查数组是否包含 ClosedRange?
- python - 为什么这段代码没有遍历所有 dict 的元素?
- python - 断言 os.path.isfile 仅适用于完整路径
- excel - 无法理解 VBA Excel 中“If..Then Go To”背后的逻辑