免费视频淫片aa毛片_日韩高清在线亚洲专区vr_日韩大片免费观看视频播放_亚洲欧美国产精品完整版

1. Exception e)   
2.         {   
3.             UpdataAdapter();   
4.         }   
5.     }   
6.   
7.   
8.     public boolean onKeyUp(int keyCode, KeyEvent event)   
9.     {   
10.         switch (keyCode)   
11.         {   
12.             case KeyEvent.KEYCODE_DPAD_LEFT:   
13.                 AddData();   
14.                 break;   
15.             case KeyEvent.KEYCODE_DPAD_RIGHT:   
16.                 DeleteData();   
17.                 break;   
18.             case KeyEvent.KEYCODE_1:   
19.                 UpData();   
20.                 break;   
21.             case KeyEvent.KEYCODE_2:   
22.                 DeleteTable();   
23.                 break;   
24.             case KeyEvent.KEYCODE_3:   
25.                 DeleteDataBase();   
26.                 break;   
27.         }   
28.         return true;   
29.     }   
30.   
31.   
32.     /* 刪除數(shù)據(jù)庫 */  
33.     public void DeleteDataBase()   
34.     {   
35.         this.deleteDatabase(DATABASE_NAME);   
36.         this.finish();   
37.     }   
38.   
39.   
40.     /* 刪除一個表 */  
41.     public void DeleteTable()   
42.     {   
43.         mSQLiteDatabase.execSQL("DROP TABLE " + TABLE_NAME);   
44.         this.finish();   
45.     }   
46.   
47.   
48.     /* 更新一條數(shù)據(jù) */  
49.     public void UpData()   
50.     {   
51.         ContentValues cv = new ContentValues();   
52.         cv.put(TABLE_NUM, miCount);   
53.         cv.put(TABLE_DATA, "修改后的數(shù)據(jù)" + miCount);   
54.   
55.         /* 更新數(shù)據(jù) */  
56.         mSQLiteDatabase.update(TABLE_NAME, cv, TABLE_NUM + "=" + Integer.toString(miCount - 1), null);   
57.   
58.         UpdataAdapter();   
59.     }   
60.   
61.   
62.     /* 向表中添加一條數(shù)據(jù) */  
63.     public void AddData()   
64.     {   
65.         ContentValues cv = new ContentValues();   
66.         cv.put(TABLE_NUM, miCount);   
67.         cv.put(TABLE_DATA, "測試數(shù)據(jù)庫數(shù)據(jù)" + miCount);   
68.         /* 插入數(shù)據(jù) */  
69.         mSQLiteDatabase.insert(TABLE_NAME, null, cv);   
70.         miCount++;   
71.         UpdataAdapter();   
72.     }   
73.       
74.   
75.     /* 從表中刪除指定的一條數(shù)據(jù) */  
76.     public void DeleteData()   
77.     {   
78.   
79.         /* 刪除數(shù)據(jù) */  
80.         mSQLiteDatabase.execSQL("DELETE FROM " + TABLE_NAME + " WHERE _id=" + Integer.toString(miCount));   
81.   
82.         miCount--;   
83.         if (miCount < 0)   
84.         {   
85.             miCount = 0;   
86.         }   
87.         UpdataAdapter();   
88.     }   
89.   
90.   
91.     /* 更行試圖顯示 */  
92.     public void UpdataAdapter()   
93.     {   
94.         // 獲取數(shù)據(jù)庫Phones的Cursor   
95.         Cursor cur = mSQLiteDatabase.query(TABLE_NAME, new String[] { TABLE_ID, TABLE_NUM, TABLE_DATA }, null, null, null, null, null);   
96.   
97.         miCount = cur.getCount();   
98.         if (cur != null && cur.getCount() >= 0)   
99.         {   
100.             // ListAdapter是ListView和后臺數(shù)據(jù)的橋梁   
101.             ListAdapter adapter = new SimpleCursorAdapter(this,   
102.             // 定義List中每一行的顯示模板   
103.                 // 表示每一行包含兩個數(shù)據(jù)項   
104.                 android.R.layout.simple_list_item_2,   
105.                 // 數(shù)據(jù)庫的Cursor對象   
106.                 cur,   
107.                 // 從數(shù)據(jù)庫的TABLE_NUM和TABLE_DATA兩列中取數(shù)據(jù)   
108.                 new String[] { TABLE_NUM, TABLE_DATA },   
109.                 // 與NAME和NUMBER對應的Views   
110.                 new int[] { android.R.id.text1, android.R.id.text2 });   
111.   
112.             /* 將adapter添加到m_ListView中 */  
113.             m_ListView.setAdapter(adapter);   
114.         }   
115.     }   
116.   
117.   
118.     /* 按鍵事件處理 */  
119.     public boolean onKeyDown(int keyCode, KeyEvent event)   
120.     {   
121.         if (keyCode == KeyEvent.KEYCODE_BACK)   
122.         {   
123.             /* 退出時，不要忘記關(guān)閉 */  
124.             mSQLiteDatabase.close();   
125.             this.finish();   
126.             return true;   
127.         }   
128.         return super.onKeyDown(keyCode, event);   
129.     }   
130. }  

package com.yarin.android.Examples_06_05;import android.app.Activity;import android.content.ContentValues;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;import android.graphics.Color;import android.os.Bundle;import android.view.KeyEvent;import android.widget.LinearLayout;import android.widget.ListAdapter;import android.widget.ListView;import android.widget.SimpleCursorAdapter;public class Activity01 extends Activity{private static int			miCount			= 0;/* 數(shù)據(jù)庫對象 */private SQLiteDatabase		mSQLiteDatabase	= null;/* 數(shù)據(jù)庫名 */private final static String	DATABASE_NAME	= "Examples_06_05.db";/* 表名 */private final static String	TABLE_NAME		= "table1";/* 表中的字段 */private final static String	TABLE_ID		= "_id";private final static String	TABLE_NUM		= "num";private final static String	TABLE_DATA		= "data";/* 創(chuàng)建表的sql語句 */private final static String	CREATE_TABLE	= "CREATE TABLE " + TABLE_NAME + " (" + TABLE_ID + " INTEGER PRIMARY KEY," + TABLE_NUM + " INTERGER,"+ TABLE_DATA + " TEXT)";/* 線性布局 */LinearLayout				m_LinearLayout	= null;/* 列表視圖-顯示數(shù)據(jù)庫中的數(shù)據(jù) */ListView					m_ListView		= null;/** Called when the activity is first created. */@Overridepublic void onCreate(Bundle savedInstanceState){super.onCreate(savedInstanceState);/* 創(chuàng)建LinearLayout布局對象 */m_LinearLayout = new LinearLayout(this);/* 設(shè)置布局LinearLayout的屬性 */m_LinearLayout.setOrientation(LinearLayout.VERTICAL);m_LinearLayout.setBackgroundColor(android.graphics.Color.BLACK);/* 創(chuàng)建ListView對象 */m_ListView = new ListView(this);LinearLayout.LayoutParams param = new LinearLayout.LayoutParams(LinearLayout.LayoutParams.FILL_PARENT, LinearLayout.LayoutParams.WRAP_CONTENT);m_ListView.setBackgroundColor(Color.BLACK);/* 添加m_ListView到m_LinearLayout布局 */m_LinearLayout.addView(m_ListView, param);/* 設(shè)置顯示m_LinearLayout布局 */setContentView(m_LinearLayout);// 打開已經(jīng)存在的數(shù)據(jù)庫mSQLiteDatabase = this.openOrCreateDatabase(DATABASE_NAME, MODE_PRIVATE, null);// 獲取數(shù)據(jù)庫Phones的Cursortry{/* 在數(shù)據(jù)庫mSQLiteDatabase中創(chuàng)建一個表 */mSQLiteDatabase.execSQL(CREATE_TABLE);}catch (Exception e){UpdataAdapter();}}public boolean onKeyUp(int keyCode, KeyEvent event){switch (keyCode){case KeyEvent.KEYCODE_DPAD_LEFT:AddData();break;case KeyEvent.KEYCODE_DPAD_RIGHT:DeleteData();break;case KeyEvent.KEYCODE_1:UpData();break;case KeyEvent.KEYCODE_2:DeleteTable();break;case KeyEvent.KEYCODE_3:DeleteDataBase();break;}return true;}/* 刪除數(shù)據(jù)庫 */public void DeleteDataBase(){this.deleteDatabase(DATABASE_NAME);this.finish();}/* 刪除一個表 */public void DeleteTable(){mSQLiteDatabase.execSQL("DROP TABLE " + TABLE_NAME);this.finish();}/* 更新一條數(shù)據(jù) */public void UpData(){ContentValues cv = new ContentValues();cv.put(TABLE_NUM, miCount);cv.put(TABLE_DATA, "修改后的數(shù)據(jù)" + miCount);/* 更新數(shù)據(jù) */mSQLiteDatabase.update(TABLE_NAME, cv, TABLE_NUM + "=" + Integer.toString(miCount - 1), null);UpdataAdapter();}/* 向表中添加一條數(shù)據(jù) */public void AddData(){ContentValues cv = new ContentValues();cv.put(TABLE_NUM, miCount);cv.put(TABLE_DATA, "測試數(shù)據(jù)庫數(shù)據(jù)" + miCount);/* 插入數(shù)據(jù) */mSQLiteDatabase.insert(TABLE_NAME, null, cv);miCount++;UpdataAdapter();}/* 從表中刪除指定的一條數(shù)據(jù) */public void DeleteData(){/* 刪除數(shù)據(jù) */mSQLiteDatabase.execSQL("DELETE FROM " + TABLE_NAME + " WHERE _id=" + Integer.toString(miCount));miCount--;if (miCount < 0){miCount = 0;}UpdataAdapter();}/* 更行試圖顯示 */public void UpdataAdapter(){// 獲取數(shù)據(jù)庫Phones的CursorCursor cur = mSQLiteDatabase.query(TABLE_NAME, new String[] { TABLE_ID, TABLE_NUM, TABLE_DATA }, null, null, null, null, null);miCount = cur.getCount();if (cur != null && cur.getCount() >= 0){// ListAdapter是ListView和后臺數(shù)據(jù)的橋梁ListAdapter adapter = new SimpleCursorAdapter(this,// 定義List中每一行的顯示模板// 表示每一行包含兩個數(shù)據(jù)項android.R.layout.simple_list_item_2,// 數(shù)據(jù)庫的Cursor對象cur,// 從數(shù)據(jù)庫的TABLE_NUM和TABLE_DATA兩列中取數(shù)據(jù)new String[] { TABLE_NUM, TABLE_DATA },// 與NAME和NUMBER對應的Viewsnew int[] { android.R.id.text1, android.R.id.text2 });/* 將adapter添加到m_ListView中 */m_ListView.setAdapter(adapter);}}/* 按鍵事件處理 */public boolean onKeyDown(int keyCode, KeyEvent event){if (keyCode == KeyEvent.KEYCODE_BACK){/* 退出時，不要忘記關(guān)閉 */mSQLiteDatabase.close();this.finish();return true;}return super.onKeyDown(keyCode, event);}}

   還有一點就是大家有必要知道一下數(shù)據(jù)庫的存儲地址。來張截圖吧。

   源碼請大家參考附件