Android下查询系统源码看短信的显示

查询系统源码看短信的显示如何写:

在providers.telephony:SmsProvider:

1.确定怎么查数据库中的表:

Uri=content://sms/conversations

2.确定查询语句:select映射条目from表where查询条件

表:

sms,(SELECTthread_idASgroup_thread_id,MAX(date)ASgroup_date,COUNT(*)ASmsg_countFROMsmsGROUPBYthread_id)ASgroups

查询条件:

sms.thread_id=groups.group_thread_idANDsms.date=groups.group_date

映射条目:

sms.bodyASsnippet

sms.thread_idASthread_id

groups.msg_countASmsg_count

所以查询语句:

select

sms.bodyASsnippet,sms.thread_idASthread_id,groups.msg_countASmsg_count

from

sms,(SELECTthread_idASgroup_thread_id,MAX(date)ASgroup_date,COUNT(*)ASmsg_countFROMsmsGROUPBYthread_id)ASgroups

where

sms.thread_id=groups.group_thread_idANDsms.date=groups.group_date

查询结果:

还需要号码,日期/时间

但看系统源码的映射列都已经写死,用户若添加自己需要的列会将系统的列覆盖:

看系统如何解决:找query:

这里的query是用户来调用的,所以projectionIn是用户传进来的,

继续找:同一个方法内,看query怎么处理projictionIn的,

点击查看如何处理用户传进来的projectionIn的,

再次点击发现进不去,为本类的方法:查找:

第一个在判断里面,略去不看,看第二个:将projection等各种参数建立成为一个sql语句,点击,发现进不去,,buildQuery为一个本类方法:查找其实现:

点击发现是一个本类方法,查找其实现:

分析源码:

将需要添加的列写好,测试正确性:

selectsms.bodyASsnippet,sms.thread_idASthread_id,groups.msg_countASmsg_count,sms.addressasaddress,sms.dateasdate

fromsms,(SELECTthread_idASgroup_thread_id,MAX(date)ASgroup_date,COUNT(*)ASmsg_countFROMsmsGROUPBYthread_id)ASgroups

wheresms.thread_id=groups.group_thread_idANDsms.date=groups.group_date

详细代码:

[java] view plain copy print ?

packagecom.itcode.SMSManager.utils;
importandroid.net.Uri;
publicclassSmsUtils{
publicstaticfinalUriSMSURL=Uri.parse("content://sms/conversations");
}

[java] view plain copy print ?

packagecom.itcode.SMSManager;
importandroid.app.Activity;
importandroid.content.AsyncQueryHandler;
importandroid.content.ContentResolver;
importandroid.database.Cursor;
importandroid.os.Bundle;
importandroid.util.Log;
importcom.itcode.SMSManager.utils.SmsUtils;
publicclassConversationActivityextendsActivity{
privateConversationAsyncQueryHandlerasyncQuery;
privatestaticfinalString[]CONVERSATIONSMSPROJECTION={
"sms.bodyASsnippet","sms.thread_idASthread_id",
"groups.msg_countASmsg_count","sms.addressasaddress",
"sms.dateasdate"};
publicstaticfinalStringTAG="ConversationActivity";
@Override
protectedvoidonCreate(BundlesavedInstanceState){
//TODOAuto-generatedmethodstub
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_conversion);
asyncQuery=newConversationAsyncQueryHandler(getContentResolver());
asyncQuery.startQuery(0,null,SmsUtils.SMSURL,
CONVERSATIONSMSPROJECTION,null,null,"dateDESC");
}
privateclassConversationAsyncQueryHandlerextendsAsyncQueryHandler{
privateStringvalue;
privateStringcolumnName;
publicConversationAsyncQueryHandler(ContentResolvercr){
super(cr);
//TODOAuto-generatedconstructorstub
}
/**
*当异步查询结束后调用的方法
*Calledwhenanasynchronousqueryiscompleted.
*tokenthetokentoidentifythequery,passedinfromstartQuery.
*cookie添加额外的数据的thecookieobjectpassedinfromstartQuery.
*cursor查询出来的结果集Thecursorholdingtheresultsfromthequery.
*/
@Override
protectedvoidonQueryComplete(inttoken,Objectcookie,Cursorcursor){
//TODOAuto-generatedmethodstub
super.onQueryComplete(token,cookie,cursor);
if(cursor!=null&&cursor.getCount()>0){
intcolumnCount=cursor.getColumnCount();
while(cursor.moveToNext()){
for(inti=0;i<columnCount;i++){
columnName=cursor.getColumnName(i);
value=cursor.getString(i);
Log.i(TAG,"当前是第"+cursor.getPosition()+"行:"+columnName+":"+value);
}
}
}
}
}
}

运行结果:

更多相关文章

随机推荐