博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
contentResolver.Query()的四个参数
阅读量:6709 次
发布时间:2019-06-25

本文共 1663 字,大约阅读时间需要 5 分钟。

hot3.png

最早的managedQuery ( , , , ,);过时了,现在获取联系人列表的方法是contentResolver.Query()

public final Cursor query (Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder)

Since: API Level 1

Query the given URI, returning a Cursor over the result set.

For best performance, the caller should follow these guidelines:

  • Provide an explicit projection, to prevent reading data from storage that aren't going to be used.
  • Use question mark parameter markers such as 'phone=?' instead of explicit values in the selection parameter, so that queries that differ only by those values will be recognized as the same for caching purposes.

Parameters
uri The URI, using the content:// scheme, for the content to retrieve.
projection A list of which columns to return. Passing null will return all columns, which is inefficient.
selection A filter declaring which rows to return, formatted as an SQL WHERE clause (excluding the WHERE itself). Passing null will return all rows for the given URI.
selectionArgs You may include ?s in selection, which will be replaced by the values from selectionArgs, in the order that they appear in the selection. The values will be bound as Strings.
sortOrder How to order the rows, formatted as an SQL ORDER BY clause (excluding the ORDER BY itself). Passing null will use the default sort order, which may be unordered.

Returns
  • A Cursor object, which is positioned before the first entry, or null

上面是2.2版本的api写的。

解释一下:假如一条sql语句如下:
select * from anyTable where var='const'
那么anyTable就是uri,*就是projection,selection是“var=?",selectionArgs写成这样:new String[]{'const‘}
至于最后一个就简单了,就是排序方式。

转载于:https://my.oschina.net/liusicong/blog/348743

你可能感兴趣的文章
设计模式系列-享元模式
查看>>
2. 使用指针操作数组
查看>>
oracle权限
查看>>
什么是顶尖的互联网产品经理?
查看>>
Android App整体架构设计的思考
查看>>
《Layer弹窗加强版》
查看>>
Java学习进度(2013.03.12)—Struts2学习二
查看>>
网页制作实验内容
查看>>
oracle 误删除表恢复
查看>>
用Perl在终端上打印彩色字符
查看>>
MongoDB相关操作
查看>>
暴力探测蓝牙设备工具redfang
查看>>
Learn Beautiful Soup(4)—— 一个简单抓取图书信息的例子
查看>>
手机gps无法定位的解决方案
查看>>
使用ORACLE 透明数据加密 TDE
查看>>
IDEA编译的优化:不用每次make
查看>>
我的友情链接
查看>>
kafka 的原理介绍
查看>>
轻松学会Java高并发第一课-并发的基本概念
查看>>
Flutter 底部导航——BottomNavigationBar
查看>>