SQLite 小例子。

     這是我在網站看到過一個網友做的SQLite一個小程式，覺得寫的不錯，以供提示參考，所以把轉載下來了。其實就是一個小收藏夾。

代碼如下：

 

ActivityMain_1.java

public class ActivityMain_1 extends Activity {<br />//聲明EditText執行個體<br />private EditText et1,et2,et3;<br />//聲明Button執行個體<br />private Button button;</p><p>@Override<br />protected void onCreate(Bundle savedInstanceState) {<br />// TODO Auto-generated method stub<br />super.onCreate(savedInstanceState);<br />setContentView(R.layout.main_1);</p><p>//根據ID獲得執行個體對象<br />et1 = (EditText) findViewById(R.id.EditText01);<br />et2 = (EditText) findViewById(R.id.EditText02);<br />et3 = (EditText) findViewById(R.id.EditText03);<br />button = (Button) findViewById(R.id.button);</p><p>//事件<br />button.setOnClickListener(new View.OnClickListener() {</p><p>@Override<br />public void onClick(View v) {<br />String name=et1.getText().toString();<br />String url =et2.getText().toString();<br />String desc = et3.getText().toString();</p><p>ContentValues values = new ContentValues();</p><p>values.put("name", name);<br />values.put("url", url);<br />values.put("desc", desc);</p><p>//執行個體化資料庫協助類<br />DBHelper helper = new DBHelper(getApplicationContext());<br />//開啟資料庫<br />helper.open(); </p><p>//插入資料<br />helper.insert(values);<br />//執行個體化Intent<br />Intent intent = new Intent(ActivityMain_1.this,QueryActivity.class);<br />startActivity(intent);<br />helper.close();<br />}<br />});</p><p>}</p><p>}<br /> 

QueryActivity.java

public class QueryActivity extends ListActivity {</p><p>private ListView listView;<br />private Cursor c;</p><p>@Override<br />protected void onCreate(Bundle savedInstanceState) {<br />// TODO Auto-generated method stub<br />super.onCreate(savedInstanceState);<br />//setContentView(R.layout.row);</p><p>//執行個體化資料庫協助類<br />final DBHelper help = new DBHelper(this);<br />help.open();<br />c= help.query();<br /> query();<br />//提示對話方塊<br />final AlertDialog.Builder builder = new AlertDialog.Builder(this);<br />listView.setOnItemClickListener(new OnItemClickListener() {<br />@Override<br />public void onItemClick(AdapterView<?> parent, View view,<br />int position, long id) {<br />final long temp = id;<br />builder.setMessage("真的要刪除該條記錄嗎？").setPositiveButton("是", new DialogInterface.OnClickListener() {</p><p>@Override<br />public void onClick(DialogInterface dialog, int which) {<br />System.out.println("yes");<br />help.del((int)temp);<br />//重新查詢<br />//query();<br />Cursor c = help.query();<br />//清單項目數組<br />String[] from ={"_id","name","url","desc"};<br />//清單項目ID<br />int[] to ={R.id.text0,R.id.text1,R.id.text2,R.id.text3};<br />//適配器<br />SimpleCursorAdapter adapter = new SimpleCursorAdapter(getApplicationContext(),R.layout.row,c,from,to);<br />ListView listView = getListView();<br />listView.setAdapter(adapter);</p><p>}<br />}).setNegativeButton("否", new DialogInterface.OnClickListener() {</p><p>@Override<br />public void onClick(DialogInterface dialog, int which) {<br />// TODO Auto-generated method stub</p><p>}<br />});<br />builder.create();<br />builder.show();<br />}<br />});</p><p>}<br />@Override<br />protected void onStop() {<br />// TODO Auto-generated method stub<br />super.onStop();</p><p>}<br />public void query(){<br />//清單項目數組<br />String[] from ={"_id","name","url","desc"};<br />//清單項目ID<br />int[] to ={R.id.text0,R.id.text1,R.id.text2,R.id.text3};</p><p>//適配器<br />SimpleCursorAdapter adapter = new SimpleCursorAdapter(this,R.layout.row,c,from,to);<br />//adapter.notifyDataSetChanged();<br />//列表視圖<br /> listView = getListView();<br />//為列表視圖添加適配器<br />listView.setAdapter(adapter);</p><p>}</p><p>}<br /> 

 

 

 

DBHelper.java

public class DBHelper extends SQLiteOpenHelper {</p><p>private static final String DB_NAME="coll.db";<br />//表名<br />private static final String TBL_NAME="logtable";<br />//建立SQL語句<br />private static final String CREATE_TBL = "create table logtable " +<br />"(_id integer primary key autoincrement,name text,url text,desc text)";<br />//SQLiteDatabase執行個體<br />private SQLiteDatabase db;</p><p>public DBHelper(Context context) {<br />super(context, DB_NAME, null, 2);</p><p>}<br />@Override<br />public void onCreate(SQLiteDatabase db) {</p><p>db.execSQL(CREATE_TBL);<br />}</p><p>//開啟資料庫<br />public void open(){<br />db = getWritableDatabase();<br />}</p><p>@Override<br />public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {<br />// TODO Auto-generated method stub<br />}</p><p>//插入方法<br />public void insert(ContentValues values){</p><p>db.insert(TBL_NAME, null, values);<br />}</p><p>//查詢方法<br />public Cursor query(){<br />Cursor c = db.query(TBL_NAME, null, null, null, null, null, null);<br />return c;<br />}</p><p>//刪除方法<br />public void del(int id){<br />db.delete(TBL_NAME, "_id=?", new String[]{String.valueOf(id)});<br />}</p><p>//關閉資料庫<br />public void close(){<br />if (db != null){<br />db.close();<br />}<br />}<br />}<br /> 

 

 

main_1.xml

<?xml version="1.0" encoding="UTF-8"?><br /><LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"<br />android:orientation="vertical"<br />android:layout_width="fill_parent"<br />android:layout_height="fill_parent"<br />></p><p><TextView<br />android:id="@+id/TextView01"<br />android:layout_width="fill_parent"<br />android:layout_height="wrap_content"<br />android:text="網站名稱"<br />/><br /><EditText<br />android:id="@+id/EditText01"<br />android:layout_width="fill_parent"<br />android:layout_height="wrap_content"</p><p>/><br /><TextView<br />android:id="@+id/TextView02"<br />android:layout_width="fill_parent"<br />android:layout_height="wrap_content"<br />android:text="URL"<br />/><br /><EditText<br />android:id="@+id/EditText02"<br />android:layout_width="fill_parent"<br />android:layout_height="wrap_content"<br />/><br /><TextView<br />android:id="@+id/TextView03"<br />android:layout_width="fill_parent"<br />android:layout_height="wrap_content"<br />android:text="網站描述"<br />/><br /><EditText<br />android:id="@+id/EditText03"<br />android:layout_width="fill_parent"<br />android:layout_height="wrap_content"<br />android:height="100px"<br />/></p><p><Button<br />android:id="@+id/button"<br />android:layout_width="wrap_content"<br />android:layout_height="wrap_content"<br />android:text="添加"<br />/><br /></LinearLayout> 

自訂布局：row.xml

<?xml version="1.0" encoding="UTF-8"?><br /><LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"<br />android:orientation="horizontal"<br />android:layout_width="fill_parent"<br />android:layout_height="fill_parent"<br />android:layout_gravity="center_vertical"<br />></p><p><TextView<br />android:id="@+id/text0"<br />android:layout_width="wrap_content"<br />android:layout_height="wrap_content"<br />android:paddingRight="10px"<br />/><br /><TextView<br />android:id="@+id/text1"<br />android:layout_width="wrap_content"<br />android:layout_height="wrap_content"<br />android:paddingRight="10px"<br />/><br /><TextView<br />android:id="@+id/text2"<br />android:layout_width="wrap_content"<br />android:layout_height="wrap_content"<br />android:paddingRight="10px"<br />/><br /><TextView<br />android:id="@+id/text3"<br />android:layout_width="wrap_content"<br />android:layout_height="wrap_content"<br />android:paddingRight="10px"<br />/></p><p></LinearLayout> 

 

結果：