JTmhwdr5

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
8 WHERE OrderId = 55 AND ( OrderDate BETWEEN '2018-01-01' AND '2018-12-12')
9	
10String queryStr = "SELECT OrderId , OrderTotal FROM BookOrder WHERE OrderId = 55 AND ( OrderDate BETWEEN '2018-01-01' AND '2018-12-12')";
11sqLiteDatabase = this.getWritableDatabase();
12cursor = sqLiteDatabase.rawQuery(queryStr, null);
13if (cursor.moveToFirst()) {
14    do {
15        Log.d("data", "sub OrderId " + cursor.getInt(0));
16        Log.d("data", "sub OrderTotal " + cursor.getFloat(1));
17        Log.d("data", "--------------");
18    } while (cursor.moveToNext());
19}
20
21sqLiteDatabase.close();