android - 为什么查询无法执行？

Question

我是被动英语..我有一个数据库连接

           String sql = "INSERT INTO " + TABLE_TRANSAKSI
                    + " (kdCabang, kdRoti, noNota ) " + " VALUES ( '"
                    + kdCabang + "' , '" + cursor.getString(0) + "' , '"
                    + noNota + "'";

            dbHelper.getWritableDatabase().execSQL(sql);
            Log.d("INSERT noNota", sql);

我认为我的代码已经正确..但在我的日志猫...

09-08 15:23:53.811: ERROR/Database(21975): Failure 1 (near "'1'": syntax error) on 0x343fc0 when preparing 'INSERT INTO TRANSAKSI (kdCabang, kdRoti, noNota )  VALUES ( 'TKRS' , 'KRKJ' , '1''.

谁能说出我的错？谢谢 be4

Answer 1

您缺少右括号。

应该是:

String sql = "INSERT INTO " + TABLE_TRANSAKSI
                    + " (kdCabang, kdRoti, noNota ) " + " VALUES ( '"
                    + kdCabang + "' , '" + cursor.getString(0) + "' , '"
                    + noNota + "')";

生产:

'INSERT INTO TRANSAKSI (kdCabang, kdRoti, noNota )  VALUES ( 'TKRS' , 'KRKJ' , '1')'.

这一切都在错误消息中 - 你需要学会阅读和理解它们。