【Content Provider】SQLiteDatabase中query、insert、update、delete方法参数说明
来源:互联网 发布:人会不会累死知乎 编辑:程序博客网 时间:2024/04/28 19:21
http://blog.sina.com.cn/s/blog_69092aea0101879o.html
SQLiteDataBase对象的query()接口:
public Cursor query (String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy,String limit)
table The table name to compile the query against.(要查询的表名.)columns A list of which columns to return. Passing null will return allcolumns, which is discouraged to prevent reading data from storagethat isn't going to be used.(想要显示的列,若为空则返回所有列,不建议设置为空,如果不是返回所有列)selection A filter declaring which rows to return, formatted as an SQL WHEREclause (excluding the WHERE itself). Passing null will return allrows for the given table.(where子句,声明要返回的行的要求,如果为空则返回表的所有行。)selectionArgs You may include ?s in selection, which will be replaced by thevalues from selectionArgs, in order that they appear in theselection. The values will be bound as Strings.( where子句对应的条件值 )groupBy A filter declaring how to group rows, formatted as an SQL GROUP BYclause (excluding the GROUP BY itself). Passing null will cause therows to not be grouped.(分组方式,若为空则不分组.)having A filter declare which row groups to include in the cursor, if rowgrouping is being used, formatted as an SQL HAVING clause(excluding the HAVING itself). Passing null will cause all rowgroups to be included, and is required when row grouping is notbeing used.(having条件,若为空则返回全部(不建议))orderBy How to order the rows, formatted as an SQL ORDER BY clause(excluding the ORDER BY itself). Passing null will use the defaultsort order, which may be unordered.(排序方式,为空则为默认排序方式)limit Limits the number of rows returned by the query, formatted as LIMITclause. Passing null denotes no LIMIT clause.(限制返回的记录的条数,为空则不限制)
Query the given table,returning a Cursor
Parameters
Returns
- A
Cursor
object,which is positioned before the first entry. Notethat Cursor
sare not synchronized, see the documentation for more details.
示例:
ContentValues cv =
new
ContentValues();
String[] args = {String.valueOf("a")};
query("user",new String[] {
SQLiteDataBase对象的insert()接口:
publiclong insert (String table, String nullColumnHack, ContentValues values)
Convenience method forinserting a row into the database.
Parameters
null
.SQL doesn't allow inserting a completely empty row without namingat least one column name. If yourprovided values
isempty, no column names are known and an empty row can't beinserted. If not set to null, the nullColumnHack
values
Returns
- the row ID of the newly insertedrow, or -1 if an error occurred
示例:
ContentValues cv =
new
ContentValues();
cv.put(
"username"
,
"a");cv.put(
"password"
,
"b");insert("user",
null
,cv);
SQLiteDataBase对象的update()接口:
publicint update (String table, ContentValues values, String whereClause, String[] whereArgs)
Convenience method for updatingrows in the database.
Parameters
whereArgs
the group of args to dealwith(whereClause语句中表达式的?占位参数列表)
Returns
- the number of rows affected
ContentValues cv =
new
ContentValues();
cv.put(
"username"
,
"c");cv.put(
"password"
,
"d");String[] args = {String.valueOf("a")};
update("user",cv,
"username=?"
,args)
SQLiteDataBase对象的delete()接口:
publicint delete (String table, String whereClause, String[] whereArgs)
Convenience method for deletingrows in the database.
Parameters
whereArgs
the optional WHERE clauseto apply when updating. Passing null will update allrows.(whereClause语句中表达式的?占位参数列表)
Returns
- the number of rows affected if awhereClause is passed in, 0 otherwise. To remove all rows and get acount pass "1" as the whereClause.
示例:
ContentValues cv =
new
ContentValues();
String[] args = {String.valueOf("c")};
delete("user",
"username=?"
,args);
0 0
- 【Content Provider】SQLiteDatabase中query、insert、update、delete方法参数说明
- SQLiteDatabase中query、insert、update、delete方法参数说明
- SQLiteDatabase中query、insert、update、delete方法参数说明
- SQLiteDatabase中query、insert、update、delete方法参数说明
- SQLiteDatabase中query、insert、update、delete方法参数说明
- SQLiteDatabase中query、insert、update、delete方法参数说明
- SQLiteDataBase中query、insert、update、delete方法参数说明
- SQLiteDatabase中query、insert、update、delete方法参数说明
- SQLiteDatabase中query、insert、update、delete方法参数说明
- SQLiteDatabase中query、insert、update、delete方法参数说明
- SQLiteDatabase中query、insert、update、delete方法参数说明
- SQLiteDatabase中query、insert、update、delete方法参数说明
- SQLiteDatabase中query、insert、update、delete方法参数说明
- SQLiteDatabase中query、insert、update、delete方法参数说明
- SQLiteDatabase中query、insert、update、delete方法参数说明
- Android---SQLITEDATABASE中QUERY、INSERT、UPDATE、DELETE方法参数说明
- SQLiteDatabase中query、insert、update、delete方法参数说明
- SQLiteDatabase中query、insert、update、delete方法参数说明
- 北京邮电大学《Hadoop大数据处理》课程2014年讲义
- 慎用new ClassPathXmlApplicationContext
- 如出一辙的云存储下的数据交互方式和程序访问入口
- 2014年7月微软MVP申请开始了!
- 向Facebook看齐,Twitter收购Android屏幕待机应用开发商Cover
- 【Content Provider】SQLiteDatabase中query、insert、update、delete方法参数说明
- [设计模式学习]简单工厂模式
- 我的pang友齐大福
- 关于 android 输入法
- cocoapods使用之替换ruby镜像
- How many Fibs?
- [android UI]官方下拉刷新控件SwipeRefreshLayout的使用
- Gallery控件初体验——简单的相册
- Html5 canvas黑客帝国文字瀑布效果