Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public boolean isCardTapedInLastMinute(String date, String time,String UID) {
- String oneMinuteBefore = getOneMinuteBefore(time);
- String tables = TRX.TABLE_NAME;
- String[] columns = {TRX._ID};
- String selection = TRX.COLUMN_NAME_TRX_DATE + " = ? AND " +
- TRX.COLUMN_NAME_TRX_TIME + " >= ? AND " +
- TRX.COLUMN_NAME_CARD_ID + " = ?";
- String[] selectionArgs = {date, oneMinuteBefore, UID};
- String sortOrder = TRX.COLUMN_NAME_TRX_DATE
- + BusDBContract.SORT_ORDER_DESC
- + ", "
- + TRX.COLUMN_NAME_TRX_TIME
- + BusDBContract.SORT_ORDER_DESC;
- String limit = "1";
- Cursor cursor = query(selection, selectionArgs, columns, tables, sortOrder, limit);
- if (null == cursor) {
- return false;
- }
- if (!cursor.moveToFirst()) {
- cursor.close();
- return false;
- }
- return true;
- }
- private Cursor queryWith(String selection, String[] selectionArgs, String[] columns, String tables, String sortOrder, String limit) {
- SQLiteQueryBuilder builder = new SQLiteQueryBuilder();
- builder.setTables(tables);
- Cursor cursor;
- try {
- cursor = builder
- .query(
- mBusOH.getReadableDatabase(),
- columns,
- selection,
- selectionArgs,
- null,
- null,
- sortOrder,
- limit);
- } catch (SQLException e) {
- Log.e(TAG, "[query]sql_exception: " + e.getMessage());
- return null;
- }
- return cursor;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement