Code example for SQLiteStatement

Methods: bindString, simpleQueryForLong

0
	   } 
	    
	   public boolean IsApprovedSender(String number)
	   { 
		   SQLiteStatement counter  = this.db.compileStatement(COUNT);
		   counter.bindString(1, number);
		   long val = counter.simpleQueryForLong();
		   if(val > 0)
			   return true; 
		   else 
			   return false; 
	   } 
 
	   public void deleteAll() { 
	      this.db.delete(TABLE_NAME, null, null);
	   } 
 
	   public List<String> selectAll() {
	      List<String> list = new ArrayList<String>();
	      Cursor cursor = this.db.query(TABLE_NAME, new String[] { "PhoneNumber" }, 
	        null, null, null, null, "PhoneNumber desc");