xSG0K0M1

1String CREATE_TBookOrder = "CREATE TABLE IF NOT EXISTS BookOrder (" +
2            "  `OrderId` INTEGER ," +
3            "  `OrderDate` DATE ," +
4            "  `OrderTotal` DOUBLE " +
5            ")";
6	
7SELECT OrderId , OrderTotal FROM BookOrder WHERE OrderId = 55 AND ( OrderDate BETWEEN '2018-01-01' AND '2018-12-12')
8	
9String queryStr = "SELECT OrderId , OrderTotal FROM BookOrder WHERE OrderId = 55 AND ( OrderDate BETWEEN '2018-01-01' AND '2018-12-12')";
10        sqLiteDatabase = this.getWritableDatabase();
11        cursor = sqLiteDatabase.rawQuery(queryStr, null);
12
13        if (cursor.moveToFirst()) {
14
15            do {
16
17                Log.d("data", "sub OrderId " + cursor.getInt(0));
18                Log.d("data", "sub OrderTotal " + cursor.getFloat(1));
19                Log.d("data", "--------------");
20
21            } while (cursor.moveToNext());
22        }
23
24        sqLiteDatabase.close();