Android SMS（一） —— 读取短信

分类：Android 2012-03-07 12:49 9440人阅读 评论(9) 收藏 举报 sms android integer string date 数据库

Android SMS Read

[java] view plain copy print ?
  1. packagecom.homer.sms;
  3. importjava.sql.Date;
  4. importjava.text.SimpleDateFormat;
  7. importandroid.app.Activity;
  8. importandroid.database.Cursor;
  9. importandroid.database.sqlite.SQLiteException;
  10. importandroid.net.Uri;
  11. importandroid.os.Bundle;
  12. importandroid.util.Log;
  13. importandroid.widget.ScrollView;
  14. importandroid.widget.TableLayout;
  15. importandroid.widget.TextView;
  17. /**
  18. *读取手机短信
  19. *
  20. *@authorsunboy_2050
  21. *@sincehttp://blog.csdn.net/sunboy_2050
  22. *@date2012.03.06
  23. */
  24. publicclasssmsReadextendsActivity{
  26. @Override
  27. publicvoidonCreate(BundlesavedInstanceState){
  28. super.onCreate(savedInstanceState);
  30. TextViewtv=newTextView(this);
  31. tv.setText(getSmsInPhone());
  33. ScrollViewsv=newScrollView(this);
  34. sv.addView(tv);
  36. setContentView(sv);
  37. }
  39. publicStringgetSmsInPhone(){
  40. finalStringSMS_URI_ALL="content://sms/";
  41. finalStringSMS_URI_INBOX="content://sms/inbox";
  42. finalStringSMS_URI_SEND="content://sms/sent";
  43. finalStringSMS_URI_DRAFT="content://sms/draft";
  44. finalStringSMS_URI_OUTBOX="content://sms/outbox";
  45. finalStringSMS_URI_FAILED="content://sms/failed";
  46. finalStringSMS_URI_QUEUED="content://sms/queued";
  48. StringBuildersmsBuilder=newStringBuilder();
  50. try{
  51. Uriuri=Uri.parse(SMS_URI_ALL);
  52. String[]projection=newString[]{"_id","address","person","body","date","type"};
  53. Cursorcur=getContentResolver().query(uri,projection,null,null,"datedesc");//获取手机内部短信
  55. if(cur.moveToFirst()){
  56. intindex_Address=cur.getColumnIndex("address");
  57. intindex_Person=cur.getColumnIndex("person");
  58. intindex_Body=cur.getColumnIndex("body");
  59. intindex_Date=cur.getColumnIndex("date");
  60. intindex_Type=cur.getColumnIndex("type");
  62. do{
  63. StringstrAddress=cur.getString(index_Address);
  64. intintPerson=cur.getInt(index_Person);
  65. Stringstrbody=cur.getString(index_Body);
  66. longlongDate=cur.getLong(index_Date);
  67. intintType=cur.getInt(index_Type);
  69. SimpleDateFormatdateFormat=newSimpleDateFormat("yyyy-MM-ddhh:mm:ss");
  70. Dated=newDate(longDate);
  71. StringstrDate=dateFormat.format(d);
  73. StringstrType="";
  74. if(intType==1){
  75. strType="接收";
  76. }elseif(intType==2){
  77. strType="发送";
  78. }else{
  79. strType="null";
  80. }
  82. smsBuilder.append("[");
  83. smsBuilder.append(strAddress+",");
  84. smsBuilder.append(intPerson+",");
  85. smsBuilder.append(strbody+",");
  86. smsBuilder.append(strDate+",");
  87. smsBuilder.append(strType);
  88. smsBuilder.append("]\n\n");
  89. }while(cur.moveToNext());
  91. if(!cur.isClosed()){
  92. cur.close();
  93. cur=null;
  94. }
  95. }else{
  96. smsBuilder.append("noresult!");
  97. }//endif
  99. smsBuilder.append("getSmsInPhonehasexecuted!");
  101. }catch(SQLiteExceptionex){
  102. Log.d("SQLiteExceptioningetSmsInPhone",ex.getMessage());
  103. }
  105. returnsmsBuilder.toString();
  106. }
  107. }

AndroidManifest.xml 权限

记得在AndroidManifest.xml中加入android.permission.READ_SMS这个permission

<uses-permissionandroid:name="android.permission.READ_SMS"/>


运行结果：

SMS_第1张图片


代码示例



URI主要有：

content://sms/ 所有短信
content://sms/inbox 收件箱
content://sms/sent 已发送
content://sms/draft 草稿
content://sms/outbox 发件箱
content://sms/failed 发送失败
content://sms/queued 待发送列表


sms主要结构：
  1. _id => 短消息序号 如100
  2. thread_id => 对话的序号 如100
  3. address => 发件人地址，手机号.如+8613811810000
  4. person => 发件人，返回一个数字就是联系人列表里的序号，陌生人为null
  5. date => 日期long型。如1256539465022
  6. protocol => 协议0SMS_RPOTO,1MMS_PROTO
  7. read => 是否阅读0未读，1已读
  8. status => 状态 -1接收，0complete,64pending,128failed
  9. type => 类型1是接收到的，2是已发出
  10. body => 短消息内容
  11. service_center => 短信服务中心号码编号。如+8613800755500
String[] projection = new String[]{"address", "body"};
Cursor cursor = getContentResolver().query(uri, projection, "where .." new String[]{"", ""}, "order by ..")


Android短信存储数据库

偶然发现了Android源码中的一个类MmsSmsDatabaseHelper.java，原来android将所有的短信信息都存入了mmssms.db中。

公开的SDK中没有这个类，不能直接使用。于是自己写了一个SQLiteOpenHelper，但是查询的时候发生SQL异常。看来不能为所欲为了，不过据网上资料介绍可以拷贝db文件来实现短信数据备份。

MmsSmsDatabaseHelper.java在Android源码中的路径：

packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java


sms数据库中的字段如下：

_id 一个自增字段，从1开始
thread_id 序号，同一发信人的id相同
address 发件人手机号码
person 联系人列表里的序号，陌生人为null
date 发件日期
protocol 协议，分为：0SMS_RPOTO,1MMS_PROTO
read 是否阅读0未读，1已读
status 状态-1接收，0complete,64pending,128failed
type
ALL = 0;
INBOX = 1;
SENT = 2;
DRAFT = 3;
OUTBOX = 4;
FAILED = 5;
QUEUED = 6;
body 短信内容
service_center 短信服务中心号码编号
subject 短信的主题
reply_path_present TP-Reply-Path
locked


sms数据库表字段类型的源码：

[java] view plain copy print ?
  1. privatevoidcreateSmsTables(SQLiteDatabasedb){
  2. //N.B.:Wheneverthecolumnsherearechanged,thecolumnsin
  3. //{@refMmsSmsProvider}mustbechangedtomatch.
  4. db.execSQL("CREATETABLEsms("+
  5. "_idINTEGERPRIMARYKEY,"+
  6. "thread_idINTEGER,"+
  7. "addressTEXT,"+
  8. "personINTEGER,"+
  9. "dateINTEGER,"+
  10. "date_sentINTEGERDEFAULT0,"+
  11. "protocolINTEGER,"+
  12. "readINTEGERDEFAULT0,"+
  13. "statusINTEGERDEFAULT-1,"+//aTP-Statusvalue
  14. //or-1ifit
  15. //statushasn't
  16. //beenreceived
  17. "typeINTEGER,"+
  18. "reply_path_presentINTEGER,"+
  19. "subjectTEXT,"+
  20. "bodyTEXT,"+
  21. "service_centerTEXT,"+
  22. "lockedINTEGERDEFAULT0,"+
  23. "error_codeINTEGERDEFAULT0,"+
  24. "seenINTEGERDEFAULT0"+
  25. ");");
  26. ....
  27. }

packages/providers/TelephonyProvider/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java


联系人为空

短信数据库里面如果你是先受到陌生短信之后再把陌生人添加到联系人列表的话，短信数据库里面的person字段就为null，如果你是先添加联系人再发短信的话，短信数据库里面的person字段就不为空了，所以你要是想通过短信数据库里的字段取得联系人的其他信息的话，只能通过地址来取。


Android SMS（二）—— 读取短信保存到 SQLite

分类：Android 2012-03-07 13:52 3895人阅读 评论(12) 收藏 举报 sms sqlite android date 数据库 string

Android 之 SMS 短信在Android系统中是保存在SQLite数据库中的，但不让其它程序访问（Android系统的安全机制）

现在我们在读取手机内的SMS短信，先保存在我们自己定义的SQLite数据库中，然后读取SQLite数据库提取短信，并显示


SMS短信SQLite存取代码：

[java] view plain copy print ?
  1. packagecom.homer.sms;
  3. importjava.sql.Date;
  4. importjava.text.SimpleDateFormat;
  6. importorg.loon.wsi.R;
  8. importandroid.app.Activity;
  9. importandroid.content.Context;
  10. importandroid.database.Cursor;
  11. importandroid.database.sqlite.SQLiteDatabase;
  12. importandroid.graphics.Color;
  13. importandroid.net.Uri;
  14. importandroid.os.Bundle;
  15. importandroid.util.Log;
  16. importandroid.widget.TableLayout;
  17. importandroid.widget.TableRow;
  18. importandroid.widget.TableRow.LayoutParams;
  19. importandroid.widget.TextView;
  21. /**
  22. *读取手机短信,先保存到SQLite数据，然后再读取数据库显示
  23. *
  24. *@authorsunboy_2050
  25. *@sincehttp://blog.csdn.net/sunboy_2050
  26. *@date2012.03.06
  27. */
  28. publicclasssmsRead4extendsActivity{
  30. TableLayouttableLayout;
  31. intindex=0;
  33. @Override
  34. publicvoidonCreate(BundlesavedInstanceState){
  35. super.onCreate(savedInstanceState);
  37. setContentView(R.layout.main);
  39. tableLayout=(TableLayout)findViewById(R.id.tableLayout);
  40. showSMS();
  41. }
  43. privatevoidshowSMS(){
  44. SmsHandersmsHander=newSmsHander(this);
  46. smsHander.createSMSDatabase();//创建SQLite数据库
  47. smsHander.insertSMSToDatabase();//读取手机短信，插入SQLite数据库
  48. Cursorcursor=smsHander.querySMSInDatabase(100);//获取前100条短信（日期排序）
  50. cursor.moveToPosition(-1);
  51. while(cursor.moveToNext()){
  52. StringstrAddress=cursor.getString(cursor.getColumnIndex("address"));
  53. StringstrDate=cursor.getString(cursor.getColumnIndex("date"));
  54. StringstrBody=cursor.getString(cursor.getColumnIndex("body"));
  56. SimpleDateFormatdateFormat=newSimpleDateFormat("yyyy-MM-ddHH:mm:ss");
  57. Datedate=newDate(Long.parseLong(strDate));
  58. strDate=dateFormat.format(date);
  60. StringsmsTitle=strAddress+"\t\t"+strDate;
  61. StringsmsBody=strBody+"\n";
  62. Log.i("tableRow",smsTitle+smsBody);
  64. //titleRow
  65. TableRowtrTitle=newTableRow(this);
  66. trTitle.setLayoutParams(newLayoutParams(LayoutParams.WRAP_CONTENT,LayoutParams.WRAP_CONTENT));
  68. TextViewtvTitle=newTextView(this);
  69. tvTitle.setText(smsTitle);
  70. tvTitle.getPaint().setFakeBoldText(true);//加粗字体
  71. tvTitle.setTextColor(Color.RED);
  72. tvTitle.setLayoutParams(newLayoutParams(LayoutParams.WRAP_CONTENT,LayoutParams.WRAP_CONTENT));
  73. trTitle.addView(tvTitle);
  74. tableLayout.addView(trTitle,newTableLayout.LayoutParams(LayoutParams.FILL_PARENT,LayoutParams.WRAP_CONTENT));
  76. //bodyRow
  77. TableRowtrBody=newTableRow(this);
  78. trBody.setLayoutParams(newLayoutParams(LayoutParams.WRAP_CONTENT,LayoutParams.WRAP_CONTENT));
  80. TextViewtvBody=newTextView(this);
  81. tvBody.setText(smsBody);
  82. tvBody.setLayoutParams(newLayoutParams(LayoutParams.WRAP_CONTENT,LayoutParams.WRAP_CONTENT));
  83. trBody.addView(tvBody);
  84. tableLayout.addView(trBody,newTableLayout.LayoutParams(LayoutParams.FILL_PARENT,LayoutParams.WRAP_CONTENT));
  85. }
  87. if(!cursor.isClosed()){
  88. cursor.close();
  89. cursor=null;
  90. }
  92. smsHander.closeSMSDatabase();
  93. index=0;
  94. }
  96. publicclassSmsHander{
  98. SQLiteDatabasedb;
  99. Contextcontext;
  101. publicSmsHander(Contextcontext){
  102. this.context=context;
  103. }
  105. publicvoidcreateSMSDatabase(){
  106. Stringsql="createtableifnotexistssms("
  107. +"_idintegerprimarykeyautoincrement,"
  108. +"addressvarchar(255),"+"personvarchar(255),"
  109. +"bodyvarchar(1024),"+"datevarchar(255),"
  110. +"typeinteger)";
  111. db=SQLiteDatabase.openOrCreateDatabase(context.getFilesDir().toString()+"/data.db3",null);//创建数据库
  112. db.execSQL(sql);
  113. }
  115. //获取手机短信
  116. privateCursorgetSMSInPhone(){
  117. UriSMS_CONTENT=Uri.parse("content://sms/");
  118. String[]projection=newString[]{"_id","address","person","body","date","type"};
  119. Cursorcursor=context.getContentResolver().query(SMS_CONTENT,projection,null,null,"datedesc");//获取手机短信
  121. while(cursor.moveToNext()){
  122. System.out.println("--sms--:"+cursor.getString(cursor.getColumnIndex("body")));
  123. }
  125. returncursor;
  126. }
  128. //保存手机短信到SQLite数据库
  129. publicvoidinsertSMSToDatabase(){
  130. LonglastTime;
  131. CursordbCount=db.rawQuery("selectcount(*)fromsms",null);
  132. dbCount.moveToFirst();
  133. if(dbCount.getInt(0)>0){
  134. Cursordbcur=db.rawQuery("select*fromsmsorderbydatedesclimit1",null);
  135. dbcur.moveToFirst();
  136. lastTime=Long.parseLong(dbcur.getString(dbcur.getColumnIndex("date")));
  137. }else{
  138. lastTime=newLong(0);
  139. }
  140. dbCount.close();
  141. dbCount=null;
  143. Cursorcur=getSMSInPhone();//获取短信（游标）
  144. db.beginTransaction();//开始事务处理
  145. if(cur.moveToFirst()){
  146. Stringaddress;
  147. Stringperson;
  148. Stringbody;
  149. Stringdate;
  150. inttype;
  152. intiAddress=cur.getColumnIndex("address");
  153. intiPerson=cur.getColumnIndex("person");
  154. intiBody=cur.getColumnIndex("body");
  155. intiDate=cur.getColumnIndex("date");
  156. intiType=cur.getColumnIndex("type");
  158. do{
  159. address=cur.getString(iAddress);
  160. person=cur.getString(iPerson);
  161. body=cur.getString(iBody);
  162. date=cur.getString(iDate);
  163. type=cur.getInt(iType);
  165. if(Long.parseLong(date)>lastTime){
  166. Stringsql="insertintosmsvalues(null,?,?,?,?,?)";
  167. Object[]bindArgs=newObject[]{address,person,body,date,type};
  168. db.execSQL(sql,bindArgs);
  169. }else{
  170. break;
  171. }
  172. }while(cur.moveToNext());
  174. cur.close();
  175. cur=null;
  176. db.setTransactionSuccessful();//设置事务处理成功，不设置会自动回滚不提交
  177. db.endTransaction();//结束事务处理
  178. }
  180. }
  182. //获取SQLite数据库中的全部短信
  183. publicCursorquerySMSFromDatabase(){
  184. Stringsql="select*fromsmsorderbydatedesc";
  185. returndb.rawQuery(sql,null);
  186. }
  188. //获取SQLite数据库中的最新size条短信
  189. publicCursorquerySMSInDatabase(intsize){
  190. Stringsql;
  192. CursordbCount=db.rawQuery("selectcount(*)fromsms",null);
  193. dbCount.moveToFirst();
  194. if(size<dbCount.getInt(0)){//不足size条短信，则取前size条
  195. sql="select*fromsmsorderbydatedesclimit"+size;
  196. }else{
  197. sql="select*fromsmsorderbydatedesc";
  198. }
  199. dbCount.close();
  200. dbCount=null;
  202. returndb.rawQuery(sql,null);
  203. }
  205. //获取SQLite数据库的前second秒短信
  206. publicCursorgetSMSInDatabaseFrom(longsecond){
  207. longtime=System.currentTimeMillis()/1000-second;
  208. Stringsql="select*fromsmsorderbydatedescwheredate>"+time;
  209. returndb.rawQuery(sql,null);
  210. }
  212. //关闭数据库
  213. publicvoidcloseSMSDatabase(){
  214. if(db!=null&&db.isOpen()){
  215. db.close();
  216. db=null;
  217. }
  218. }
  220. }
  221. }
运行结果：

SMS_第2张图片


代码示例


推荐参考：

Android 之 SMS 短信读取



更多相关文章

  1. android最简单的发送文本短信的demo
  2. android 拨打电话与发送短信
  3. Android中短信拦截的实现
  4. 关于 SQLiteOpenHelper 的自创建数据库目录文件
  5. Android 拦截 接收 短信
  6. android 读取短信内容
  7. Android 数据库事务操作

随机推荐

  1. android 遍历安装过的包名
  2. 横向 纵向结合的ScrollView
  3. android 内核添加tourch screen
  4. Android 一些常用的但是记不住的设置
  5. android 版 双色球号码生成
  6. android实现左右滑动菜单
  7. Android 自定义滚动视图
  8. android 按钮的点击缩放
  9. Android API之android.content.AsyncQuer
  10. android studio 与gradle的版本对应