SQLiteException: no suchcolumn: date (code 1): ， 编译时: SELECT

Question

我正在使用数据库，我使用以下数据类

数据助手.java

private static final String CREATE_TABLE = "create table "
        + TABLE_MEMBER + "(" + MEMBER_ID
        + " INTEGER PRIMARY KEY AUTOINCREMENT, "
        + MEMBER_NAME + " TEXT NOT NULL,"
        + MEMBER_DATE + " TEXT NOT NULL);";

它将错误代码指向这两个Java文件

SQLController.java

 public Cursor readData() {
        String[] allColumns = new String[] { DBhelper.MEMBER_ID,DBhelper.MEMBER_NAME,DBhelper.MEMBER_DATE};
        Cursor c = database.query(DBhelper.TABLE_MEMBER, allColumns,null, null, null, null, null);
        if (c != null) {
        c.moveToFirst();
       }
        return c;
    }

主要活动.java

     protected void onCreate(Bundle savedInstanceState) {
            super.onCreate(savedInstanceState);

  setContentView(R.layout.activity_main);
        dbcon = new SQLController(this);
        dbcon.open();
        addmem_bt = (Button) findViewById(R.id.addmem_bt_id);
        lv = (ListView) findViewById(R.id.memberList_id);
        addmem_bt.setOnClickListener(new OnClickListener() {
            @Override
            public void onClick(View v) {
                Intent add_mem = new Intent(MainActivity.this, Add_member.class);
                startActivity(add_mem);
            }
        });
        // Attach The Data From DataBase Into ListView Using Crusor Adapter
        Cursor cursor = dbcon.readData();
        String[] from = new String[] { DBhelper.MEMBER_ID, DBhelper.MEMBER_NAME, DBhelper.MEMBER_DATE };
        int[] to = new int[] { R.id.member_id, R.id.member_name, R.id.member_date};

谢谢你所有的帮助

Answer 1

date 是 sqlite 中的一个函数，我怀疑你不能用作列名或别名