Android中SQLite应用详解(6)

32. android:id=\

33. android:layout_width=\ 34. android:layout_height=\/> 35.

xmlns:android=\ android:orientation=\ android:layout_width=\ android:layout_height=\

android:layout_width=\android:layout_height=\android:text=\android:onClick=\

android:layout_width=\android:layout_height=\android:text=\android:onClick=\

android:layout_width=\android:layout_height=\android:text=\android:onClick=\

android:layout_width=\android:layout_height=\android:text=\android:onClick=\

android:layout_width=\android:layout_height=\android:text=\android:onClick=\

android:id=\

android:layout_width=\android:layout_height=\

[java]view plaincopyprint?

1. package com.scott.db; 2.

3. import java.util.ArrayList; 4. import java.util.HashMap; 5. import java.util.List; 6. import java.util.Map; 7.

8. import android.app.Activity; 9. import android.database.Cursor; 10. import android.database.CursorWrapper; 11. import android.os.Bundle; 12. import android.view.View; 13. import android.widget.ListView; 14. import android.widget.SimpleAdapter; 15. import android.widget.SimpleCursorAdapter; 16. 17.

18. public class MainActivity extends Activity { 19.

20. private DBManager mgr; 21. private ListView listView; 22.

23. @Override

24. public void onCreate(Bundle savedInstanceState) { 25. super.onCreate(savedInstanceState); 26. setContentView(R.layout.main);

27. listView = (ListView) findViewById(R.id.listView); 28. //初始化DBManager

29. mgr = new DBManager(this); 30. } 31.

32. @Override

33. protected void onDestroy() { 34. super.onDestroy();

35. //应用的最后一个Activity关闭时应释放DB 36. mgr.closeDB(); 37. } 38.

39. public void add(View view) {

40. ArrayList persons = new ArrayList(); 41.

42. Person person1 = new Person(\22, \43. Person person2 = new Person(\22, \44. Person person3 = new Person(\23, \45. Person person4 = new Person(\23, \46. Person person5 = new Person(\25, \47.

48. persons.add(person1); 49. persons.add(person2); 50. persons.add(person3); 51. persons.add(person4); 52. persons.add(person5); 53.

54. mgr.add(persons); 55. } 56.

57. public void update(View view) { 58. Person person = new Person(); 59. person.name = \60. person.age = 30; 61. mgr.updateAge(person); 62. } 63.

64. public void delete(View view) { 65. Person person = new Person(); 66. person.age = 30;

67. mgr.deleteOldPerson(person); 68. } 69.

70. public void query(View view) {

71. List persons = mgr.query();

72. ArrayList> list = new ArrayList

, String>>();

73. for (Person person : persons) {

74. HashMap map = new HashMap(

);

75. map.put(\

76. map.put(\

;

77. list.add(map); 78. }

79. SimpleAdapter adapter = new SimpleAdapter(this, list, android.

R.layout.simple_list_item_2,

80. new String[]{\

id.text1, android.R.id.text2}); 81. listView.setAdapter(adapter); 82. } 83.

84. public void queryTheCursor(View view) { 85. Cursor c = mgr.queryTheCursor();

86. startManagingCursor(c); //托付给activity根据自己的生命周期去管理

Cursor的生命周期

87. CursorWrapper cursorWrapper = new CursorWrapper(c) { 88. @Override

89. public String getString(int columnIndex) { 90. //将简介前加上年龄

91. if (getColumnName(columnIndex).equals(\92. int age = getInt(getColumnIndex(\

93. return age + \

mnIndex);

94. }

95. return super.getString(columnIndex); 96. } 97. };

98. //确保查询结果中有\列

99. SimpleCursorAdapter adapter = new SimpleCursorAdapter(this, an

droid.R.layout.simple_list_item_2, 100.

cursorWrapper, new String[]{\

nt[]{android.R.id.text1, android.R.id.text2}); 101.

ListView listView = (ListView) findViewById(R.id.listView)

; 102. 103. 104.

listView.setAdapter(adapter); } }

package com.scott.db;

import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map;

import android.app.Activity; import android.database.Cursor; import android.database.CursorWrapper; import android.os.Bundle; import android.view.View; import android.widget.ListView; import android.widget.SimpleAdapter; import android.widget.SimpleCursorAdapter;

public class MainActivity extends Activity {