Android กับ SQLite Database การเขียนแอนดรอยด์เพื่อติดต่อกับฐานข้อมูลของ SQLite

package com.myapp;

import android.os.Bundle;
import android.view.Menu;
import android.app.Activity;
import android.database.sqlite.SQLiteDatabase;

public class MainActivity extends Activity {
	
	SQLiteDatabase db;

	@Override
	public void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		setContentView(R.layout.activity_main);
		
		myDBClass myDb = new myDBClass(this);
		myDb.getWritableDatabase(); // First method
				
	}

}

Log.d("CREATE TABLE","Create Table Successfully.");

	// Insert Data
	public long InsertData(String strMemberID, String strName, String strTel) {
		// TODO Auto-generated method stub
		
		 try {
			SQLiteDatabase db;
     		db = this.getWritableDatabase(); // Write Data
     		
     		/**
     		 *  for API 11 and above
			SQLiteStatement insertCmd;
			String strSQL = "INSERT INTO " + TABLE_MEMBER
					+ "(MemberID,Name,Tel) VALUES (?,?,?)";
			
			insertCmd = db.compileStatement(strSQL);
			insertCmd.bindString(1, strMemberID);
			insertCmd.bindString(2, strName);
			insertCmd.bindString(3, strTel);
			return insertCmd.executeInsert();
			*/
			
     	   ContentValues Val = new ContentValues();
     	   Val.put("MemberID", strMemberID); 
     	   Val.put("Name", strName);
     	   Val.put("Tel", strTel);
    
			long rows = db.insert(TABLE_MEMBER, null, Val);

			db.close();
			return rows; // return rows inserted.
           
		 } catch (Exception e) {
		    return -1;
		 }

	}

  	   ContentValues Val = new ContentValues();
     	   Val.put("MemberID", strMemberID); 
     	   Val.put("Name", strName);
     	   Val.put("Tel", strTel);
    
			long rows = db.insert(TABLE_MEMBER, null, Val);

		final myDBClass myDb = new myDBClass(this);

		// Button1 (Insert)
        final Button btn1 = (Button) findViewById(R.id.button1);
        // Perform action on click
        btn1.setOnClickListener(new View.OnClickListener() {
            public void onClick(View v) {
            	
            	// Statement 1
            	long flg1 = myDb.InsertData("1","Weerachai", "0819876107");
            	if(flg1 > 0)
            	{
            	 Toast.makeText(MainActivity.this,"Insert(1) Data Successfully",
            			 	Toast.LENGTH_LONG).show(); 
            	}
            	else
            	{
               	 Toast.makeText(MainActivity.this,"Insert(1) Data Failed.",
         			 	Toast.LENGTH_LONG).show(); 
            	}
            	
            	// Statement 2
            	long flg2 = myDb.InsertData("2","Win", "021978032");
            	if(flg2 > 0)
            	{
            	 Toast.makeText(MainActivity.this,"Insert(2) Data Successfully",
            			 	Toast.LENGTH_LONG).show(); 
            	}
            	else
            	{
               	 Toast.makeText(MainActivity.this,"Insert(2) Data Failed.",
         			 	Toast.LENGTH_LONG).show(); 
            	}
            }
        });

	// Select Data
	public String[] SelectData(String strMemberID) {
		// TODO Auto-generated method stub
		
		 try {
			String arrData[] = null;	
			
			 SQLiteDatabase db;
			 db = this.getReadableDatabase(); // Read Data
				
			 Cursor cursor = db.query(TABLE_MEMBER, new String[] { "*" }, 
					 	"MemberID=?",
			            new String[] { String.valueOf(strMemberID) }, null, null, null, null);
			 
			 	if(cursor != null)
			 	{
					if (cursor.moveToFirst()) {
						arrData = new String[cursor.getColumnCount()];
						/***
						 *  0 = MemberID
						 *  1 = Name
						 *  2 = Tel
						 */
						arrData[0] = cursor.getString(0);
						arrData[1] = cursor.getString(1);
						arrData[2] = cursor.getString(2);
					}
			 	}
			 	cursor.close();
				db.close();
				return arrData;
				
		 } catch (Exception e) {
		    return null;
		 }

	}

			 Cursor cursor = db.query(TABLE_MEMBER, new String[] { "*" }, 
					 	"MemberID=?",
			            new String[] { String.valueOf(strMemberID) }, null, null, null, null);

		final myDBClass myDb = new myDBClass(this);

		// Button2 (Select)
        final Button btn2 = (Button) findViewById(R.id.button2);
        // Perform action on click
        btn2.setOnClickListener(new View.OnClickListener() {
            public void onClick(View v) {
            	String arrData[] = myDb.SelectData("1");
            	if(arrData == null)
            	{
               	 Toast.makeText(MainActivity.this,"Not found Data!",
         			 	Toast.LENGTH_LONG).show(); 
            	}
            	else
            	{
            		// arrData[0] MemberID
            		// arrData[0] Name
            		// arrData[0] Tel
                  	 Toast.makeText(MainActivity.this,"MemberID = " + arrData[0]
                  			 + ","  + arrData[1] + ","  + arrData[2],
              			 	Toast.LENGTH_LONG).show(); 
            	}
            }
        }); 

	// Select All Data
	public class sMembers {
		String _MemberID, _Name, _Tel;
		
		// Set Value
		public void sMemberID(String vMemberID){
	        this._MemberID = vMemberID;
	    }
		public void sName(String vName){
	        this._Name = vName;
	    }
		public void sTel(String vTel){
	        this._Tel = vTel;
	    }	
		
		// Get Value
		public String gMemberID(){
	        return _MemberID;
	    }
		public String gName(){
			 return _Name;
	    }
		public String gTel(){
	        return _Tel;
	    }	
	}
	
	public List<sMembers> SelectAllData() {
		// TODO Auto-generated method stub
		
		 try {
			 List<sMembers> MemberList = new ArrayList<sMembers>();
			 
			 SQLiteDatabase db;
			 db = this.getReadableDatabase(); // Read Data
				
			 String strSQL = "SELECT  * FROM " + TABLE_MEMBER;
			 Cursor cursor = db.rawQuery(strSQL, null);
			 
			 	if(cursor != null)
			 	{
			 	    if (cursor.moveToFirst()) {
			 	        do {
			 	        	sMembers cMember = new sMembers();
			 	        	cMember.sMemberID(cursor.getString(0));
			 	        	cMember.sName(cursor.getString(1));
			 	        	cMember.sTel(cursor.getString(2));
			 	        	MemberList.add(cMember);
			 	        } while (cursor.moveToNext());
			 	    }
			 	}
			 	cursor.close();
				db.close();
				return MemberList;
				
		 } catch (Exception e) {
		    return null;
		 }

	}

			 String strSQL = "SELECT  * FROM " + TABLE_MEMBER;
			 Cursor cursor = db.rawQuery(strSQL, null);

		final myDBClass myDb = new myDBClass(this);

		// Button3 (Select All Data)
        final Button btn3 = (Button) findViewById(R.id.button3);
        // Perform action on click
        btn3.setOnClickListener(new View.OnClickListener() {
            public void onClick(View v) {
            	// import com.myapp.myDBClass.sMembers;
            	List<sMembers> MebmerList = myDb.SelectAllData();   
            	if(MebmerList == null)
            	{
                  	 Toast.makeText(MainActivity.this,"Not found Data!",
              			 	Toast.LENGTH_LONG).show(); 
            	}
            	else
            	{
            		for (sMembers mem : MebmerList) {
                 	 Toast.makeText(MainActivity.this,"MemberID = " + mem.gMemberID()
                  			 + ","  + mem.gName() + ","  + mem.gTel(),
              			 	Toast.LENGTH_LONG).show(); 
            		}
            	}
            		

            }
        });  

	// Select All Data
	public String[][] SelectAllData() {
		// TODO Auto-generated method stub
		
		 try {
			String arrData[][] = null;	
			 SQLiteDatabase db;
			 db = this.getReadableDatabase(); // Read Data
				
			 String strSQL = "SELECT  * FROM " + TABLE_MEMBER;
			 Cursor cursor = db.rawQuery(strSQL, null);
			 
			 	if(cursor != null)
			 	{
					if (cursor.moveToFirst()) {
						arrData = new String[cursor.getCount()][cursor.getColumnCount()];
						/***
						 *  [x][0] = MemberID
						 *  [x][1] = Name
						 *  [x][2] = Tel
						 */
						int i= 0;
						do {				
							arrData[i][0] = cursor.getString(0);
							arrData[i][1] = cursor.getString(1);
							arrData[i][2] = cursor.getString(2);
							i++;
						} while (cursor.moveToNext());						

					}
			 	}
			 	cursor.close();
				
				return arrData;
				
		 } catch (Exception e) {
		    return null;
		 }

	}

		final myDBClass myDb = new myDBClass(this);

        // Button3 (Select All Data)
        final Button btn3 = (Button) findViewById(R.id.button3);
        // Perform action on click
        btn3.setOnClickListener(new View.OnClickListener() {
            public void onClick(View v) {
            	String arrData[][] = myDb.SelectAllData();  
            	if(arrData == null)
            	{
                  	 Toast.makeText(MainActivity.this,"Not found Data!",
              			 	Toast.LENGTH_LONG).show(); 
            	}
            	else
            	{	
            		int i = 0;
            		for(i = 0;i<=arrData.length-1;i++)
                 	 Toast.makeText(MainActivity.this,"MemberID = " + arrData[i][0]
                  			 + ","  + arrData[i][1] + ","  + arrData[i][2],
              			 	Toast.LENGTH_LONG).show(); 
            		}
            	}
            		
        });  

	// Update Data
	public long UpdateData(String strMemberID,String strName,String strTel) {
		// TODO Auto-generated method stub
		
		 try {
			
			SQLiteDatabase db;
     		db = this.getWritableDatabase(); // Write Data
     		
     		/**
     		 *  for API 11 and above
			SQLiteStatement insertCmd;
			String strSQL = "UPDATE " + TABLE_MEMBER
					+ " SET Name = ? "
					+ " , Tel = ? "
					+ " WHERE MemberID = ? ";
			
			insertCmd = db.compileStatement(strSQL);
			insertCmd.bindString(1, strName);
			insertCmd.bindString(2, strTel);
			insertCmd.bindString(3, strMemberID);
				
			return insertCmd.executeUpdateDelete();
			*
			*/
            ContentValues Val = new ContentValues();
            Val.put("Name", strName);
            Val.put("Tel", strTel);
     
            long rows = db.update(TABLE_MEMBER, Val, " MemberID = ?",
                    new String[] { String.valueOf(strMemberID) });

			db.close();
			return rows; // return rows updated.

		 } catch (Exception e) {
		    return -1;
		 }

	}

            long rows = db.update(TABLE_MEMBER, Val, " MemberID = ?",
                    new String[] { String.valueOf(strMemberID) });

		final myDBClass myDb = new myDBClass(this);

		// Button4 (Update)
        final Button btn4 = (Button) findViewById(R.id.button4);
        // Perform action on click
        btn4.setOnClickListener(new View.OnClickListener() {
            public void onClick(View v) {
            	long flg = myDb.UpdateData("2","Win Win", "021978032");
            	if(flg > 0)
            	{
            	 Toast.makeText(MainActivity.this,"Update Data Successfully",
            			 	Toast.LENGTH_LONG).show(); 
            	}
            	else
            	{
               	 Toast.makeText(MainActivity.this,"Update Data Failed.",
         			 	Toast.LENGTH_LONG).show(); 
            	}
            }
        });

	// Delete Data
	public long DeleteData(String strMemberID) {
		// TODO Auto-generated method stub
		
		 try {
			
			SQLiteDatabase db;
     		db = this.getWritableDatabase(); // Write Data
     		
     		/**
     		 * for API 11 and above
			SQLiteStatement insertCmd;
			String strSQL = "DELETE FROM " + TABLE_MEMBER
					+ " WHERE MemberID = ? ";
			
			insertCmd = db.compileStatement(strSQL);
			insertCmd.bindString(1, strMemberID);
			
			return insertCmd.executeUpdateDelete();
			*
			*/
				
			long rows =  db.delete(TABLE_MEMBER, "MemberID = ?",
		            new String[] { String.valueOf(strMemberID) });

			db.close();
			return rows; // return rows delete.

		 } catch (Exception e) {
		    return -1;
		 }

	}

			long rows =  db.delete(TABLE_MEMBER, "MemberID = ?",
		            new String[] { String.valueOf(strMemberID) });

		final myDBClass myDb = new myDBClass(this);

		// Button5 (Delete)
        final Button btn5 = (Button) findViewById(R.id.button5);
        // Perform action on click
        btn5.setOnClickListener(new View.OnClickListener() {
            public void onClick(View v) {
            	long flg = myDb.DeleteData("2");
            	if(flg > 0)
            	{
            	 Toast.makeText(MainActivity.this,"Delete Data Successfully",
            			 	Toast.LENGTH_LONG).show(); 
            	}
            	else
            	{
               	 Toast.makeText(MainActivity.this,"Delete Data Failed.",
         			 	Toast.LENGTH_LONG).show(); 
            	}
            }
        });
				
	}

<TableLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent" >

    <Button
        android:id="@+id/button1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="Insert" />

    <Button
        android:id="@+id/button2"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="Select" />

    <Button
        android:id="@+id/button3"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="Select All Data" />

    <Button
        android:id="@+id/button4"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="Update" />

    <Button
        android:id="@+id/button5"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="Delete" />
 
</TableLayout>