学步园

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

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

SMS短信SQLite存取代码：

package com.homer.sms;</p> <p>import java.sql.Date;<br /> import java.text.SimpleDateFormat;</p> <p>import org.loon.wsi.R;</p> <p>import android.app.Activity;<br /> import android.content.Context;<br /> import android.database.Cursor;<br /> import android.database.sqlite.SQLiteDatabase;<br /> import android.graphics.Color;<br /> import android.net.Uri;<br /> import android.os.Bundle;<br /> import android.util.Log;<br /> import android.widget.TableLayout;<br /> import android.widget.TableRow;<br /> import android.widget.TableRow.LayoutParams;<br /> import android.widget.TextView;</p> <p>/**<br /> * 读取手机短信, 先保存到SQLite数据，然后再读取数据库显示<br /> *<br /> * @author sunboy_2050<br /> * @since http://blog.csdn.net/sunboy_2050<br /> * @date 2012.03.06<br /> */<br /> public class smsRead4 extends Activity {</p> <p> TableLayout tableLayout;<br /> int index = 0;</p> <p> @Override<br /> public void onCreate(Bundle savedInstanceState) {<br /> super.onCreate(savedInstanceState);</p> <p> setContentView(R.layout.main);</p> <p> tableLayout = (TableLayout) findViewById(R.id.tableLayout);<br /> showSMS();<br /> }</p> <p> private void showSMS() {<br /> SmsHander smsHander = new SmsHander(this);</p> <p> smsHander.createSMSDatabase(); // 创建SQLite数据库<br /> smsHander.insertSMSToDatabase(); // 读取手机短信，插入SQLite数据库<br /> Cursor cursor = smsHander.querySMSInDatabase(100); // 获取前100条短信（日期排序）</p> <p> cursor.moveToPosition(-1);<br /> while (cursor.moveToNext()) {<br /> String strAddress = cursor.getString(cursor.getColumnIndex("address"));<br /> String strDate = cursor.getString(cursor.getColumnIndex("date"));<br /> String strBody = cursor.getString(cursor.getColumnIndex("body"));</p> <p> SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");<br /> Date date = new Date(Long.parseLong(strDate));<br /> strDate = dateFormat.format(date);</p> <p> String smsTitle = strAddress + "\t\t" + strDate;<br /> String smsBody = strBody + "\n";<br /> Log.i("tableRow", smsTitle + smsBody);</p> <p> // title Row<br /> TableRow trTitle = new TableRow(this);<br /> trTitle.setLayoutParams(new LayoutParams(LayoutParams.WRAP_CONTENT, LayoutParams.WRAP_CONTENT));</p> <p> TextView tvTitle = new TextView(this);<br /> tvTitle.setText(smsTitle);<br /> tvTitle.getPaint().setFakeBoldText(true); // 加粗字体<br /> tvTitle.setTextColor(Color.RED);<br /> tvTitle.setLayoutParams(new LayoutParams(LayoutParams.WRAP_CONTENT, LayoutParams.WRAP_CONTENT));<br /> trTitle.addView(tvTitle);<br /> tableLayout.addView(trTitle, new TableLayout.LayoutParams(LayoutParams.FILL_PARENT, LayoutParams.WRAP_CONTENT));</p> <p> // body Row<br /> TableRow trBody = new TableRow(this);<br /> trBody.setLayoutParams(new LayoutParams(LayoutParams.WRAP_CONTENT, LayoutParams.WRAP_CONTENT));</p> <p> TextView tvBody = new TextView(this);<br /> tvBody.setText(smsBody);<br /> tvBody.setLayoutParams(new LayoutParams(LayoutParams.WRAP_CONTENT, LayoutParams.WRAP_CONTENT));<br /> trBody.addView(tvBody);<br /> tableLayout.addView(trBody, new TableLayout.LayoutParams(LayoutParams.FILL_PARENT, LayoutParams.WRAP_CONTENT));<br /> }</p> <p> if (!cursor.isClosed()) {<br /> cursor.close();<br /> cursor = null;<br /> }</p> <p> smsHander.closeSMSDatabase();<br /> index = 0;<br /> }</p> <p> public class SmsHander {</p> <p> SQLiteDatabase db;<br /> Context context;</p> <p> public SmsHander(Context context) {<br /> this.context = context;<br /> }</p> <p> public void createSMSDatabase() {<br /> String sql = "create table if not exists sms("<br /> + "_id integer primary key autoincrement,"<br /> + "address varchar(255)," + "person varchar(255),"<br /> + "body varchar(1024)," + "date varchar(255),"<br /> + "type integer)";<br /> db = SQLiteDatabase.openOrCreateDatabase(context.getFilesDir().toString() + "/data.db3", null); // 创建数据库<br /> db.execSQL(sql);<br /> }</p> <p> // 获取手机短信<br /> private Cursor getSMSInPhone() {<br /> Uri SMS_CONTENT = Uri.parse("content://sms/");<br /> String[] projection = new String[] { "_id", "address", "person", "body", "date", "type" };<br /> Cursor cursor = context.getContentResolver().query(SMS_CONTENT, projection, null, null, "date desc"); // 获取手机短信</p> <p> while (cursor.moveToNext()) {<br /> System.out.println("--sms-- : " + cursor.getString(cursor.getColumnIndex("body")));<br /> }</p> <p> return cursor;<br /> }</p> <p> // 保存手机短信到 SQLite 数据库<br /> public void insertSMSToDatabase() {<br /> Long lastTime;<br /> Cursor dbCount = db.rawQuery("select count(*) from sms", null);<br /> dbCount.moveToFirst();<br /> if (dbCount.getInt(0) > 0) {<br /> Cursor dbcur = db.rawQuery("select * from sms order by date desc limit 1", null);<br /> dbcur.moveToFirst();<br /> lastTime = Long.parseLong(dbcur.getString(dbcur.getColumnIndex("date")));<br /> } else {<br /> lastTime = new Long(0);<br /> }<br /> dbCount.close();<br /> dbCount = null;</p> <p> Cursor cur = getSMSInPhone(); // 获取短信（游标）<br /> db.beginTransaction(); // 开始事务处理<br /> if (cur.moveToFirst()) {<br /> String address;<br /> String person;<br /> String body;<br /> String date;<br /> int type;</p> <p> int iAddress = cur.getColumnIndex("address");<br /> int iPerson = cur.getColumnIndex("person");<br /> int iBody = cur.getColumnIndex("body");<br /> int iDate = cur.getColumnIndex("date");<br /> int iType = cur.getColumnIndex("type");</p> <p> do {<br /> address = cur.getString(iAddress);<br /> person = cur.getString(iPerson);<br /> body = cur.getString(iBody);<br /> date = cur.getString(iDate);<br /> type = cur.getInt(iType);</p> <p> if (Long.parseLong(date) > lastTime) {<br /> String sql = "insert into sms values(null, ?, ?, ?, ?, ?)";<br /> Object[] bindArgs = new Object[] { address, person, body, date, type };<br /> db.execSQL(sql, bindArgs);<br /> } else {<br /> break;<br /> }<br /> } while (cur.moveToNext());</p> <p> cur.close();<br /> cur = null;<br /> db.setTransactionSuccessful(); // 设置事务处理成功，不设置会自动回滚不提交<br /> db.endTransaction(); // 结束事务处理<br /> }</p> <p> }</p> <p> // 获取 SQLite 数据库中的全部短信<br /> public Cursor querySMSFromDatabase() {<br /> String sql = "select * from sms order by date desc";<br /> return db.rawQuery(sql, null);<br /> }</p> <p> // 获取 SQLite 数据库中的最新 size 条短信<br /> public Cursor querySMSInDatabase(int size) {<br /> String sql;</p> <p> Cursor dbCount = db.rawQuery("select count(*) from sms", null);<br /> dbCount.moveToFirst();<br /> if (size < dbCount.getInt(0)) { // 不足 size 条短信，则取前 size 条<br /> sql = "select * from sms order by date desc limit " + size;<br /> } else {<br /> sql = "select * from sms order by date desc";<br /> }<br /> dbCount.close();<br /> dbCount = null;</p> <p> return db.rawQuery(sql, null);<br /> }</p> <p> // 获取 SQLite数据库的前 second秒短信<br /> public Cursor getSMSInDatabaseFrom(long second) {<br /> long time = System.currentTimeMillis() / 1000 - second;<br /> String sql = "select * from sms order by date desc where date > " + time;<br /> return db.rawQuery(sql, null);<br /> }</p> <p> // 关闭数据库<br /> public void closeSMSDatabase() {<br /> if (db != null && db.isOpen()) {<br /> db.close();<br /> db = null;<br /> }<br /> }</p> <p> }<br /> }<br /> 运行结果：

代码示例

推荐参考：

Android 之 SMS 短信读取