java - 返回列单元格的 ID

Question

嘿，这会返回参数中插入的日期的 ID 吗？想象一下，如果插入的日期是 01-07-2017 并且他在表中的 ID 是 4，它会返回 4 吗？

COL_1="ID";
COL_4="DATES";

public int getDateId(String date){
    int dateID=0;
    String last_query = "SELECT " + COL_1  + " FROM " + TABLE_NAME  + " WHERE " + COL_4 + " = '" + date + "'";
    Cursor c = database.rawQuery(last_query, null);
    if (c != null && c.moveToFirst())
    {
        dateID = c.getInt(c.getColumnIndex("ID"));
    }
    c.close();

    return dateID;
}

对我来说返回 0。

我在这里调用这个方法:

    @Override
    public void onSelectDate(Date date, View view) {


        if(DatesList.contains(date)){
            myDB = CustomApplication.getDatabaseHelper();

            final DateFormat df = new SimpleDateFormat("dd-MM-yyyy");

            String printedData = df.format(date.getTime());


            int dateID = myDB.getDateId(printedData);
            Log.d(Tag,""+dateID);
            String returnedData = myDB.getDates(dateID);

            Intent i = new Intent(getContext(),TesteInfoDisplay.class);



            startActivity(i);
        }
        else{
            Toast.makeText(getContext(),"Não tem nenhum teste nesse dia.",Toast.LENGTH_LONG).show();
        }

    }
};

数据库:https://gist.github.com/Poreis/2305632568388077be0ba122d029d3c7

Answer 1

只使用索引号而不是

c.getColumnIndex("ID")

然后试试这个

     COL_1="ID"
 COL_4="DATES"

     public int getDateId(String date){
int dateID=0;
String last_query = "SELECT " + COL_1  + " FROM " + TABLE_NAME  + " WHERE " + COL_4 + " = '" + date + "'";
Cursor c = database.rawQuery(last_query, null);
if (c != null && c.moveToFirst())
{
    dateID = c.getInt(0);
}
c.close();

return dateID;
}

我在这里调用这个方法:

    @Override
    public void onSelectDate(Date date, View view) {


        if(DatesList.contains(date)){
            myDB = CustomApplication.getDatabaseHelper();

            final DateFormat df = new SimpleDateFormat("dd-MM-yyyy");

            String printedData = df.format(date.getTime());


            int dateID = myDB.getDateId(printedData);
            Log.d(Tag,""+dateID);
            String returnedData = myDB.getDates(dateID);

            Intent i = new Intent(getContext(),TesteInfoDisplay.class);



            startActivity(i);
        }
        else{
            Toast.makeText(getContext(),"Não tem nenhum teste nesse dia.",Toast.LENGTH_LONG).show();
        }

    }
};

数据库: https://gist.github.com/Poreis/2305632568388077be0ba122d029d3c7