Advertisement
Guest User

Untitled

a guest
Jul 7th, 2015
197
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.62 KB | None | 0 0
  1. public boolean isCardTapedInLastMinute(String date, String time,String UID) {
  2. String oneMinuteBefore = getOneMinuteBefore(time);
  3. String tables = TRX.TABLE_NAME;
  4. String[] columns = {TRX._ID};
  5. String selection = TRX.COLUMN_NAME_TRX_DATE + " = ? AND " +
  6. TRX.COLUMN_NAME_TRX_TIME + " >= ? AND " +
  7. TRX.COLUMN_NAME_CARD_ID + " = ?";
  8. String[] selectionArgs = {date, oneMinuteBefore, UID};
  9.  
  10. String sortOrder = TRX.COLUMN_NAME_TRX_DATE
  11. + BusDBContract.SORT_ORDER_DESC
  12. + ", "
  13. + TRX.COLUMN_NAME_TRX_TIME
  14. + BusDBContract.SORT_ORDER_DESC;
  15. String limit = "1";
  16. Cursor cursor = query(selection, selectionArgs, columns, tables, sortOrder, limit);
  17. if (null == cursor) {
  18. return false;
  19. }
  20. if (!cursor.moveToFirst()) {
  21. cursor.close();
  22. return false;
  23. }
  24.  
  25. return true;
  26.  
  27. }
  28.  
  29. private Cursor queryWith(String selection, String[] selectionArgs, String[] columns, String tables, String sortOrder, String limit) {
  30. SQLiteQueryBuilder builder = new SQLiteQueryBuilder();
  31. builder.setTables(tables);
  32. Cursor cursor;
  33.  
  34. try {
  35. cursor = builder
  36. .query(
  37. mBusOH.getReadableDatabase(),
  38. columns,
  39. selection,
  40. selectionArgs,
  41. null,
  42. null,
  43. sortOrder,
  44. limit);
  45. } catch (SQLException e) {
  46. Log.e(TAG, "[query]sql_exception: " + e.getMessage());
  47. return null;
  48. }
  49.  
  50. return cursor;
  51. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement