1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

public String getSmsInPhone()

{

final String SMS_URI_ALL = "content://sms/";

final String SMS_URI_INBOX = "content://sms/inbox";

final String SMS_URI_SEND = "content://sms/sent";

final String SMS_URI_DRAFT = "content://sms/draft";

StringBuilder smsBuilder = new StringBuilder();

try{

ContentResolver cr = getContentResolver();

String[] projection = new String[]{"_id", "address", "person",

"body", "date", "type"};

Uri uri = Uri.parse(SMS_URI_ALL);

Cursor cur = cr.query(uri, projection, null, null, "date desc");

if (cur.moveToFirst()) {

String name;

String phoneNumber;

String smsbody;

String date;

String type;

int nameColumn = cur.getColumnIndex("person");

int phoneNumberColumn = cur.getColumnIndex("address");

int smsbodyColumn = cur.getColumnIndex("body");

int dateColumn = cur.getColumnIndex("date");

int typeColumn = cur.getColumnIndex("type");

do{

name = cur.getString(nameColumn);

phoneNumber = cur.getString(phoneNumberColumn);

smsbody = cur.getString(smsbodyColumn);

SimpleDateFormat dateFormat = new SimpleDateFormat(

"yyyy-MM-dd hh:mm:ss");

Date d = new Date(Long.parseLong(cur.getString(dateColumn)));

date = dateFormat.format(d);

int typeId = cur.getInt(typeColumn);

if(typeId == 1){

type = "接收";

} else if(typeId == 2){

type = "发送";

} else {

type = "";

}

smsBuilder.append("[");

smsBuilder.append(name+",");

smsBuilder.append(phoneNumber+",");

smsBuilder.append(smsbody+",");

smsBuilder.append(date+",");

smsBuilder.append(type);

smsBuilder.append("] ");

if(smsbody == null) smsbody = "";

}while(cur.moveToNext());

} else {

smsBuilder.append("no result!");

}

smsBuilder.append("getSmsInPhone has executed!");

} catch(SQLiteException ex) {

Log.d("SQLiteException in getSmsInPhone", ex.getMessage());

}

return smsBuilder.toString();

}