当前位置:Gxlcms > 数据库问题 > SQlite.GridView

SQlite.GridView

时间:2021-07-01 10:21:17 帮助过:20人阅读

com.testSQLite; import android.annotation.SuppressLint; import android.app.Activity; import android.database.Cursor; import android.database.SQLException; import android.database.sqlite.SQLiteDatabase; import android.os.Bundle; import android.util.Log; import android.view.View; import android.widget.Button; import android.widget.LinearLayout; import android.widget.Toast; public class testSQLite extends Activity { GVTable table; Button btnCreateDB, btnInsert, btnClose; SQLiteDatabase db; int id;//添加记录时的id累加标记,必须全局 private static final String TABLE_NAME = "stu"; private static final String ID = "id"; private static final String NAME = "name"; private static final String PHONE = "phone"; private static final String ADDRESS = "address"; private static final String AGE = "age"; @SuppressLint("ShowToast") @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.main); btnCreateDB = (Button) this.findViewById(R.id.btnCreateDB); btnCreateDB.setOnClickListener(new ClickEvent()); btnInsert = (Button) this.findViewById(R.id.btnInsertRec); btnInsert.setOnClickListener(new ClickEvent()); btnClose = (Button) this.findViewById(R.id.btnClose); btnClose.setOnClickListener(new ClickEvent()); table=new GVTable(this); table.gvSetTableRowCount(8);//设置每个分页的ROW总数 LinearLayout ly = (LinearLayout) findViewById(R.id.MainLinearLayout); table.setTableOnClickListener(new GVTable.OnTableClickListener() { @Override public void onTableClickListener(int x,int y,Cursor c) { c.moveToPosition(y); String str=c.getString(x)+" 位置:("+String.valueOf(x)+","+String.valueOf(y)+")"; Toast.makeText(testSQLite.this, str, 1000).show(); } }); table.setOnPageSwitchListener(new GVTable.OnPageSwitchListener() { @Override public void onPageSwitchListener(int pageID,int pageCount) { String str="共有"+String.valueOf(pageCount)+ " 当前第"+String.valueOf(pageID)+"页"; Toast.makeText(testSQLite.this, str, 1000).show(); } }); ly.addView(table); } class ClickEvent implements View.OnClickListener { @Override public void onClick(View v) { if (v == btnCreateDB) CreateDB(); else if (v == btnInsert) { InsertRecord(16);//插入16条记录 table.gvUpdatePageBar("select count(*) from " + TABLE_NAME, db); table.gvReadyTable("select * from " + TABLE_NAME, db); } else if (v == btnClose) { table.gvRemoveAll(); db.close(); } } } /** * 在内存创建数据库和数据表 */ void CreateDB() { // 在内存创建数据库 db = SQLiteDatabase.create(null); Log.e("DB Path", db.getPath()); String amount = String.valueOf(databaseList().length); Log.e("DB amount", amount); // 创建数据表 String sql = "CREATE TABLE " + TABLE_NAME + " (" + ID + " text not null, " + NAME + " text not null," + ADDRESS + " text not null, " + PHONE + " text not null," + AGE + " text not null "+");"; try { db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME); db.execSQL(sql); } catch (SQLException e) {} } /** * 插入N条数据 */ void InsertRecord(int n) { int total = id + n; for (; id < total; id++) { String sql = "insert into " + TABLE_NAME + " (" + ID + ", " + NAME+", " + ADDRESS+", " + PHONE+", "+AGE + ") values(‘" + String.valueOf(id) + "‘, ‘man‘,‘address‘,‘123456789‘,‘18‘);"; try { db.execSQL(sql); } catch (SQLException e) {} } } }

  2.2、GVTable.java

  1. <span style="color: #0000ff">package</span><span style="color: #000000"> com.testSQLite;
  2. </span><span style="color: #0000ff">import</span><span style="color: #000000"> java.util.ArrayList;
  3. </span><span style="color: #0000ff">import</span><span style="color: #000000"> java.util.HashMap;
  4. </span><span style="color: #0000ff">import</span><span style="color: #000000"> android.content.Context;
  5. </span><span style="color: #0000ff">import</span><span style="color: #000000"> android.database.Cursor;
  6. </span><span style="color: #0000ff">import</span><span style="color: #000000"> android.database.sqlite.SQLiteDatabase;
  7. </span><span style="color: #0000ff">import</span><span style="color: #000000"> android.util.Log;
  8. </span><span style="color: #0000ff">import</span><span style="color: #000000"> android.view.View;
  9. </span><span style="color: #0000ff">import</span><span style="color: #000000"> android.widget.AdapterView;
  10. </span><span style="color: #0000ff">import</span><span style="color: #000000"> android.widget.GridView;
  11. </span><span style="color: #0000ff">import</span><span style="color: #000000"> android.widget.LinearLayout;
  12. </span><span style="color: #0000ff">import</span><span style="color: #000000"> android.widget.SimpleAdapter;
  13. </span><span style="color: #0000ff">import</span><span style="color: #000000"> android.widget.AdapterView.OnItemClickListener;
  14. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">class</span> GVTable <span style="color: #0000ff">extends</span><span style="color: #000000"> LinearLayout
  15. {
  16. </span><span style="color: #0000ff">protected</span><span style="color: #000000"> GridView gvTable,gvPage;
  17. </span><span style="color: #0000ff">protected</span> SimpleAdapter saPageID,saTable;<span style="color: #008000">//</span><span style="color: #008000"> 适配器</span>
  18. <span style="color: #0000ff">protected</span> ArrayList<HashMap<String, String>> alistPageID, alistTable;<span style="color: #008000">//</span><span style="color: #008000"> 数据源</span>
  19. <span style="color: #0000ff">protected</span> <span style="color: #0000ff">int</span> TableRowCount = 10;<span style="color: #008000">//</span><span style="color: #008000">分页时,每页的Row总数</span>
  20. <span style="color: #0000ff">protected</span> <span style="color: #0000ff">int</span> TableColCount = 0;<span style="color: #008000">//</span><span style="color: #008000">每页col的数量</span>
  21. <span style="color: #0000ff">protected</span><span style="color: #000000"> SQLiteDatabase db;
  22. </span><span style="color: #0000ff">protected</span> String rawSQL = ""<span style="color: #000000">;
  23. </span><span style="color: #0000ff">protected</span> Cursor curTable;<span style="color: #008000">//</span><span style="color: #008000">分页时使用的Cursor</span>
  24. <span style="color: #0000ff">protected</span> OnTableClickListener clickListener;<span style="color: #008000">//</span><span style="color: #008000">整个分页控件被点击时的回调函数</span>
  25. <span style="color: #0000ff">protected</span> OnPageSwitchListener switchListener;<span style="color: #008000">//</span><span style="color: #008000">分页切换时的回调函数</span>
  26. <span style="color: #0000ff">public</span><span style="color: #000000"> GVTable(Context context)
  27. {
  28. </span><span style="color: #0000ff">super</span><span style="color: #000000">(context);
  29. </span><span style="color: #0000ff">this</span>.setOrientation(VERTICAL);<span style="color: #008000">//</span><span style="color: #008000">垂直
  30. </span><span style="color: #008000">//</span><span style="color: #008000">----------------------------------------</span>
  31. gvTable = <span style="color: #0000ff">new</span><span style="color: #000000"> GridView(context);
  32. </span><span style="color: #008000">//</span><span style="color: #008000"> addView(gvTable, new LinearLayout.LayoutParams(LayoutParams.FILL_PARENT, LayoutParams.WRAP_CONTENT));</span><span style="color: #008000">//</span><span style="color: #008000">宽长式样</span>
  33. addView(gvTable, <span style="color: #0000ff">new</span> LinearLayout.LayoutParams(LayoutParams.MATCH_PARENT, LayoutParams.WRAP_CONTENT));<span style="color: #008000">//</span><span style="color: #008000">宽长式样</span>
  34. <span style="color: #000000">
  35. alistTable </span>= <span style="color: #0000ff">new</span> ArrayList<HashMap<String, String>><span style="color: #000000">();
  36. saTable </span>= <span style="color: #0000ff">new</span><span style="color: #000000"> SimpleAdapter(context,
  37. alistTable,</span><span style="color: #008000">//</span><span style="color: #008000"> 数据来源</span>
  38. R.layout.items,<span style="color: #008000">//</span><span style="color: #008000">XML实现</span>
  39. <span style="color: #0000ff">new</span> String[] { "ItemText" },<span style="color: #008000">//</span><span style="color: #008000"> 动态数组与ImageItem对应的子项</span>
  40. <span style="color: #0000ff">new</span> <span style="color: #0000ff">int</span><span style="color: #000000">[] { R.id.ItemText });
  41. </span><span style="color: #008000">//</span><span style="color: #008000"> 添加并且显示</span>
  42. <span style="color: #000000"> gvTable.setAdapter(saTable);
  43. gvTable.setOnItemClickListener(</span><span style="color: #0000ff">new</span><span style="color: #000000"> OnItemClickListener()
  44. {
  45. @Override
  46. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span> onItemClick(AdapterView<?> _parent, View _view, <span style="color: #0000ff">int</span> _position, <span style="color: #0000ff">long</span><span style="color: #000000"> _id)
  47. {
  48. </span><span style="color: #0000ff">int</span> y = _position / curTable.getColumnCount() - 1;<span style="color: #008000">//</span><span style="color: #008000">标题栏的不算</span>
  49. <span style="color: #0000ff">int</span> x = _position %<span style="color: #000000"> curTable.getColumnCount();
  50. </span><span style="color: #0000ff">if</span> (clickListener != <span style="color: #0000ff">null</span><span style="color: #008000">//</span><span style="color: #008000">分页数据被点击</span>
  51. && y!=-1)<span style="color: #008000">//</span><span style="color: #008000">点中的不是标题栏时</span>
  52. <span style="color: #000000"> {
  53. clickListener.onTableClickListener(x,y,curTable);
  54. }
  55. }
  56. });
  57. </span><span style="color: #008000">//</span><span style="color: #008000">----------------------------------------</span>
  58. gvPage = <span style="color: #0000ff">new</span><span style="color: #000000"> GridView(context);
  59. gvPage.setColumnWidth(</span>40);<span style="color: #008000">//</span><span style="color: #008000">设置每个分页按钮的宽度</span>
  60. gvPage.setNumColumns(GridView.AUTO_FIT);<span style="color: #008000">//</span><span style="color: #008000">分页按钮数量自动设置
  61. </span><span style="color: #008000">//</span><span style="color: #008000"> addView(gvPage, new LinearLayout.LayoutParams(LayoutParams.FILL_PARENT, LayoutParams.WRAP_CONTENT));</span><span style="color: #008000">//</span><span style="color: #008000">宽长式样</span>
  62. addView(gvPage, <span style="color: #0000ff">new</span> LinearLayout.LayoutParams(LayoutParams.MATCH_PARENT, LayoutParams.WRAP_CONTENT));<span style="color: #008000">//</span><span style="color: #008000">宽长式样</span>
  63. alistPageID = <span style="color: #0000ff">new</span> ArrayList<HashMap<String, String>><span style="color: #000000">();
  64. saPageID </span>= <span style="color: #0000ff">new</span><span style="color: #000000"> SimpleAdapter(context,
  65. alistPageID,</span><span style="color: #008000">//</span><span style="color: #008000"> 数据来源</span>
  66. R.layout.items,<span style="color: #008000">//</span><span style="color: #008000">XML实现</span>
  67. <span style="color: #0000ff">new</span> String[] { "ItemText" },<span style="color: #008000">//</span><span style="color: #008000"> 动态数组与ImageItem对应的子项</span>
  68. <span style="color: #0000ff">new</span> <span style="color: #0000ff">int</span><span style="color: #000000">[] { R.id.ItemText });
  69. </span><span style="color: #008000">//</span><span style="color: #008000"> 添加并且显示</span>
  70. <span style="color: #000000"> gvPage.setAdapter(saPageID);
  71. </span><span style="color: #008000">//</span><span style="color: #008000"> 添加消息处理</span>
  72. gvPage.setOnItemClickListener(<span style="color: #0000ff">new</span><span style="color: #000000"> OnItemClickListener()
  73. {
  74. @Override
  75. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span> onItemClick(AdapterView<?> _parent, View _view, <span style="color: #0000ff">int</span> _position, <span style="color: #0000ff">long</span><span style="color: #000000"> _id)
  76. {
  77. LoadTable(_position);</span><span style="color: #008000">//</span><span style="color: #008000">根据所选分页读取对应的数据</span>
  78. <span style="color: #0000ff">if</span>(switchListener!=<span style="color: #0000ff">null</span>)<span style="color: #008000">//</span><span style="color: #008000">分页切换时</span>
  79. <span style="color: #000000"> {
  80. switchListener.onPageSwitchListener(_position, alistPageID.size());
  81. }
  82. }
  83. });
  84. }
  85. </span><span style="color: #008000">/**</span><span style="color: #008000">
  86. * 清除所有数据
  87. </span><span style="color: #008000">*/</span>
  88. <span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span><span style="color: #000000"> gvRemoveAll()
  89. {
  90. </span><span style="color: #0000ff">if</span>(<span style="color: #0000ff">this</span>.curTable!=<span style="color: #0000ff">null</span><span style="color: #000000">)
  91. curTable.close();
  92. alistTable.clear();
  93. saTable.notifyDataSetChanged();
  94. alistPageID.clear();
  95. saPageID.notifyDataSetChanged();
  96. }
  97. </span><span style="color: #008000">/**</span><span style="color: #008000">
  98. * 读取指定ID的分页数据,返回当前页的总数据
  99. * SQL:Select * From TABLE_NAME Limit 9 Offset 10;
  100. * 表示从TABLE_NAME表获取数据,跳过10行,取9行
  101. * </span><span style="color: #808080">@param</span><span style="color: #008000"> pageID 指定的分页ID
  102. </span><span style="color: #008000">*/</span>
  103. <span style="color: #0000ff">protected</span> <span style="color: #0000ff">void</span> LoadTable(<span style="color: #0000ff">int</span><span style="color: #000000"> pageID)
  104. {
  105. </span><span style="color: #0000ff">if</span>(curTable!=<span style="color: #0000ff">null</span>)<span style="color: #008000">//</span><span style="color: #008000">释放上次的数据</span>
  106. <span style="color: #000000"> curTable.close();
  107. String sql</span>= rawSQL+" Limit "+String.valueOf(TableRowCount)+ " Offset " +String.valueOf(pageID*<span style="color: #000000">TableRowCount);
  108. Log.e(</span>"sql"<span style="color: #000000">, sql);
  109. curTable </span>= db.rawQuery(sql, <span style="color: #0000ff">null</span><span style="color: #000000">);
  110. gvTable.setNumColumns(curTable.getColumnCount());</span><span style="color: #008000">//</span><span style="color: #008000">表现为表格的关键点!</span>
  111. TableColCount=<span style="color: #000000">curTable.getColumnCount();
  112. alistTable.clear();
  113. </span><span style="color: #008000">//</span><span style="color: #008000"> 取得字段名称</span>
  114. <span style="color: #0000ff">int</span> colCount =<span style="color: #000000"> curTable.getColumnCount();
  115. </span><span style="color: #0000ff">for</span> (<span style="color: #0000ff">int</span> i = 0; i < colCount; i++<span style="color: #000000">)
  116. {
  117. HashMap</span><String, String> map = <span style="color: #0000ff">new</span> HashMap<String, String><span style="color: #000000">();
  118. map.put(</span>"ItemText"<span style="color: #000000">, curTable.getColumnName(i));
  119. alistTable.add(map);
  120. }
  121. </span><span style="color: #008000">//</span><span style="color: #008000"> 列举出所有数据</span>
  122. <span style="color: #0000ff">int</span> recCount=<span style="color: #000000">curTable.getCount();
  123. </span><span style="color: #0000ff">for</span> (<span style="color: #0000ff">int</span> i = 0; i < recCount; i++) <span style="color: #008000">//</span><span style="color: #008000">定位到一条数据</span>
  124. <span style="color: #000000"> {
  125. curTable.moveToPosition(i);
  126. </span><span style="color: #0000ff">for</span>(<span style="color: #0000ff">int</span> ii=0;ii<colCount;ii++)<span style="color: #008000">//</span><span style="color: #008000">定位到一条数据中的每个字段</span>
  127. <span style="color: #000000"> {
  128. HashMap</span><String, String> map = <span style="color: #0000ff">new</span> HashMap<String, String><span style="color: #000000">();
  129. map.put(</span>"ItemText"<span style="color: #000000">, curTable.getString(ii));
  130. alistTable.add(map);
  131. }
  132. }
  133. saTable.notifyDataSetChanged();
  134. }
  135. </span><span style="color: #008000">/**</span><span style="color: #008000">
  136. * 设置表格的最多显示的行数
  137. * </span><span style="color: #808080">@param</span><span style="color: #008000"> row 表格的行数
  138. </span><span style="color: #008000">*/</span>
  139. <span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span> gvSetTableRowCount(<span style="color: #0000ff">int</span><span style="color: #000000"> row)
  140. {
  141. TableRowCount</span>=<span style="color: #000000">row;
  142. }
  143. </span><span style="color: #008000">/**</span><span style="color: #008000">
  144. * 取得表格的最大行数
  145. * </span><span style="color: #808080">@return</span><span style="color: #008000"> 行数
  146. </span><span style="color: #008000">*/</span>
  147. <span style="color: #0000ff">public</span> <span style="color: #0000ff">int</span><span style="color: #000000"> gvGetTableRowCount()
  148. {
  149. </span><span style="color: #0000ff">return</span><span style="color: #000000"> TableRowCount;
  150. }
  151. </span><span style="color: #008000">/**</span><span style="color: #008000">
  152. * 取得当前分页的Cursor
  153. * </span><span style="color: #808080">@return</span><span style="color: #008000"> 当前分页的Cursor
  154. </span><span style="color: #008000">*/</span>
  155. <span style="color: #0000ff">public</span><span style="color: #000000"> Cursor gvGetCurrentTable()
  156. {
  157. </span><span style="color: #0000ff">return</span><span style="color: #000000"> curTable;
  158. }
  159. </span><span style="color: #008000">/**</span><span style="color: #008000">
  160. * 准备分页显示数据
  161. * </span><span style="color: #808080">@param</span><span style="color: #008000"> rawSQL sql语句
  162. * </span><span style="color: #808080">@param</span><span style="color: #008000"> db 数据库
  163. </span><span style="color: #008000">*/</span>
  164. <span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span><span style="color: #000000"> gvReadyTable(String rawSQL,SQLiteDatabase db)
  165. {
  166. </span><span style="color: #0000ff">this</span>.rawSQL =<span style="color: #000000"> rawSQL;
  167. </span><span style="color: #0000ff">this</span>.db =<span style="color: #000000"> db;
  168. }
  169. </span><span style="color: #008000">/**</span><span style="color: #008000">
  170. * 刷新分页栏,更新按钮数量
  171. * </span><span style="color: #808080">@param</span><span style="color: #008000"> sql SQL语句
  172. * </span><span style="color: #808080">@param</span><span style="color: #008000"> db 数据库
  173. </span><span style="color: #008000">*/</span>
  174. <span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span><span style="color: #000000"> gvUpdatePageBar(String sql, SQLiteDatabase _db)
  175. {
  176. Cursor rec </span>= _db.rawQuery(sql, <span style="color: #0000ff">null</span><span style="color: #000000">);
  177. rec.moveToLast();
  178. </span><span style="color: #0000ff">long</span> recSize = rec.getLong(0);<span style="color: #008000">//</span><span style="color: #008000">取得总数</span>
  179. <span style="color: #000000"> rec.close();
  180. </span><span style="color: #0000ff">int</span> pageNum = (<span style="color: #0000ff">int</span>)(recSize/TableRowCount) + 1;<span style="color: #008000">//</span><span style="color: #008000">取得分页数</span>
  181. <span style="color: #000000">
  182. alistPageID.clear();
  183. </span><span style="color: #0000ff">for</span> (<span style="color: #0000ff">int</span> i = 0; i < pageNum; i++<span style="color: #000000">)
  184. {
  185. HashMap</span><String, String> map = <span style="color: #0000ff">new</span> HashMap<String, String><span style="color: #000000">();
  186. map.put(</span>"ItemText", "No." + String.valueOf(i));<span style="color: #008000">//</span><span style="color: #008000"> 添加图像资源的ID</span>
  187. <span style="color: #000000">
  188. alistPageID.add(map);
  189. }
  190. saPageID.notifyDataSetChanged();
  191. }
  192. </span><span style="color: #008000">//</span><span style="color: #008000">---------------------------------------------------------</span>
  193. <span style="color: #008000">/**</span><span style="color: #008000">
  194. * 表格被点击时的回调函数
  195. </span><span style="color: #008000">*/</span>
  196. <span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span><span style="color: #000000"> setTableOnClickListener(OnTableClickListener click)
  197. {
  198. </span><span style="color: #0000ff">this</span>.clickListener =<span style="color: #000000"> click;
  199. }
  200. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">interface</span><span style="color: #000000"> OnTableClickListener
  201. {
  202. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span> onTableClickListener(<span style="color: #0000ff">int</span> x,<span style="color: #0000ff">int</span><span style="color: #000000"> y,Cursor c);
  203. }
  204. </span><span style="color: #008000">//</span><span style="color: #008000">---------------------------------------------------------</span>
  205. <span style="color: #008000">/**</span><span style="color: #008000">
  206. * 分页栏被点击时的回调函数
  207. </span><span style="color: #008000">*/</span>
  208. <span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span><span style="color: #000000"> setOnPageSwitchListener(OnPageSwitchListener pageSwitch)
  209. {
  210. </span><span style="color: #0000ff">this</span>.switchListener =<span style="color: #000000"> pageSwitch;
  211. }
  212. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">interface</span><span style="color: #000000"> OnPageSwitchListener
  213. {
  214. </span><span style="color: #0000ff">public</span> <span style="color: #0000ff">void</span> onPageSwitchListener(<span style="color: #0000ff">int</span> pageID,<span style="color: #0000ff">int</span><span style="color: #000000"> pageCount);
  215. }
  216. }</span>

  2.3、main.xml

  1. <span style="color: #0000ff"><?</span><span style="color: #ff00ff">xml version="1.0" encoding="utf-8"</span><span style="color: #0000ff">?></span>
  2. <span style="color: #0000ff"><</span><span style="color: #800000">LinearLayout </span><span style="color: #ff0000">xmlns:android</span><span style="color: #0000ff">="http://schemas.android.com/apk/res/android"</span><span style="color: #ff0000">
  3. android:orientation</span><span style="color: #0000ff">="vertical"</span><span style="color: #ff0000"> android:layout_width</span><span style="color: #0000ff">="fill_parent"</span><span style="color: #ff0000">
  4. android:layout_height</span><span style="color: #0000ff">="fill_parent"</span><span style="color: #ff0000"> android:id</span><span style="color: #0000ff">="@+id/MainLinearLayout"</span><span style="color: #0000ff">></span>
  5. <span style="color: #0000ff"><</span><span style="color: #800000">Button
  6. </span><span style="color: #ff0000">android:layout_height</span><span style="color: #0000ff">="wrap_content"</span><span style="color: #ff0000">
  7. android:layout_width</span><span style="color: #0000ff">="fill_parent"</span><span style="color: #ff0000">
  8. android:id</span><span style="color: #0000ff">="@+id/btnCreateDB"</span><span style="color: #ff0000">
  9. android:text</span><span style="color: #0000ff">="创建数据库"</span> <span style="color: #0000ff">/></span>
  10. <span style="color: #0000ff"><</span><span style="color: #800000">Button
  11. </span><span style="color: #ff0000">android:layout_height</span><span style="color: #0000ff">="wrap_content"</span><span style="color: #ff0000">
  12. android:layout_width</span><span style="color: #0000ff">="fill_parent"</span><span style="color: #ff0000">
  13. android:text</span><span style="color: #0000ff">="插入一串实验数据"</span><span style="color: #ff0000">
  14. android:id</span><span style="color: #0000ff">="@+id/btnInsertRec"</span> <span style="color: #0000ff">/></span>
  15. <span style="color: #0000ff"><</span><span style="color: #800000">Button
  16. </span><span style="color: #ff0000">android:layout_height</span><span style="color: #0000ff">="wrap_content"</span><span style="color: #ff0000">
  17. android:layout_width</span><span style="color: #0000ff">="fill_parent"</span><span style="color: #ff0000">
  18. android:id</span><span style="color: #0000ff">="@+id/btnClose"</span><span style="color: #ff0000">
  19. android:text</span><span style="color: #0000ff">="关闭数据库"</span> <span style="color: #0000ff">/></span>
  20. <span style="color: #0000ff"></</span><span style="color: #800000">LinearLayout</span><span style="color: #0000ff">></span>

  2.4、items.xml

  1. <span style="color: #0000ff"><?</span><span style="color: #ff00ff">xml version="1.0" encoding="utf-8"</span><span style="color: #0000ff">?></span>
  2. <span style="color: #0000ff"><</span><span style="color: #800000">LinearLayout </span><span style="color: #ff0000">android:id</span><span style="color: #0000ff">="@+id/LinearLayout01"</span><span style="color: #ff0000">
  3. xmlns:android</span><span style="color: #0000ff">="http://schemas.android.com/apk/res/android"</span><span style="color: #ff0000">
  4. android:layout_width</span><span style="color: #0000ff">="fill_parent"</span><span style="color: #ff0000"> android:background</span><span style="color: #0000ff">="#555555"</span><span style="color: #ff0000">
  5. android:layout_height</span><span style="color: #0000ff">="wrap_content"</span><span style="color: #0000ff">></span>
  6. <span style="color: #0000ff"><</span><span style="color: #800000">TextView
  7. </span><span style="color: #ff0000">android:layout_below</span><span style="color: #0000ff">="@+id/ItemImage"</span><span style="color: #ff0000">
  8. android:text</span><span style="color: #0000ff">="TextView01"</span><span style="color: #ff0000">
  9. android:id</span><span style="color: #0000ff">="@+id/ItemText"</span><span style="color: #ff0000">
  10. android:bufferType</span><span style="color: #0000ff">="normal"</span><span style="color: #ff0000">
  11. android:singleLine</span><span style="color: #0000ff">="true"</span><span style="color: #ff0000">
  12. android:background</span><span style="color: #0000ff">="#000000"</span><span style="color: #ff0000">
  13. android:layout_width</span><span style="color: #0000ff">="fill_parent"</span><span style="color: #ff0000">
  14. android:gravity</span><span style="color: #0000ff">="center"</span><span style="color: #ff0000">
  15. android:layout_margin</span><span style="color: #0000ff">="1dip"</span><span style="color: #ff0000">
  16. android:layout_gravity</span><span style="color: #0000ff">="center"</span><span style="color: #ff0000">
  17. android:layout_height</span><span style="color: #0000ff">="wrap_content"</span><span style="color: #0000ff">></span>
  18. <span style="color: #0000ff"></</span><span style="color: #800000">TextView</span><span style="color: #0000ff">></span>
  19. <span style="color: #0000ff"></</span><span style="color: #800000">LinearLayout</span><span style="color: #0000ff">></span>

 

3、

4、

5、

 

SQlite.GridView

标签:ada   listview   添加   文件的   sql语句   end   near   绑定   span   

人气教程排行