android-数据库的增删改查

数据库的增删改查

稍微修改下就可以做成一个项目

package irdc.ex05_05;

import android.app.Activity;
import android.database.Cursor;
import android.database.sqlite.SQLiteCursor;
import android.os.Bundle;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.widget.AdapterView;
import android.widget.EditText;
import android.widget.ListView;
import android.widget.SimpleCursorAdapter;

public class EX05_05 extends Activity
{
  private ToDoDB myToDoDB;
  private Cursor myCursor;
  private ListView myListView;
  private EditText myEditText;
  private int _id;
  protected final static int MENU_ADD = Menu.FIRST;
  protected final static int MENU_EDIT = Menu.FIRST + 1;
  protected final static int MENU_DELETE = Menu.FIRST + 2;

  @Override
  public boolean onOptionsItemSelected(MenuItem item)
  {
    super.onOptionsItemSelected(item);
    switch (item.getItemId())
    {
      case MENU_ADD:
        this.addTodo();
        break;
      case MENU_EDIT:
        this.editTodo();
        break;
      case MENU_DELETE:
        this.deleteTodo();
        break;
    }
    return true;
  }

  @Override
  public boolean onCreateOptionsMenu(Menu menu)
  {
    super.onCreateOptionsMenu(menu);
    /* �s�W�T��MENU */
    menu.add(Menu.NONE, MENU_ADD, 0, R.string.strAddButton);
    menu.add(Menu.NONE, MENU_EDIT, 0, R.string.strEditButton);
    menu.add(Menu.NONE, MENU_DELETE, 0, R.string.strDeleteButton);

    return true;
  }

  /** Called when the activity is first created. */
  @Override
  public void onCreate(Bundle savedInstanceState)
  {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.main);

    myListView = (ListView) this.findViewById(R.id.myListView);
    myEditText = (EditText) this.findViewById(R.id.myEditText);

    myToDoDB = new ToDoDB(this);
    /* ��oDataBase�̪���� */
    myCursor = myToDoDB.select();

    /* new SimpleCursorAdapter�ñNmyCursor�ǤJ�A��ܸ�ƪ���쬰todo_text */
    SimpleCursorAdapter adapter = new SimpleCursorAdapter(this, R.layout.list,
        myCursor, new String[]
        { ToDoDB.FIELD_TEXT }, new int[]
        { R.id.listTextView1 });
    myListView.setAdapter(adapter);

    /* �NmyListView�[�JOnItemClickListener */
    myListView.setOnItemClickListener(new AdapterView.OnItemClickListener()
    {

      @Override
      public void onItemClick(AdapterView<?> arg0, View arg1, int arg2,
          long arg3)
      {
        /* �NmyCursor������I�諸�� */
        myCursor.moveToPosition(arg2);
        /* ��o���_id���� */
        _id = myCursor.getInt(0);
        /* ��o���todo_text���� */
        myEditText.setText(myCursor.getString(1));
      }

    });
    myListView
        .setOnItemSelectedListener(new AdapterView.OnItemSelectedListener()
        {

          @Override
          public void onItemSelected(AdapterView<?> arg0, View arg1, int arg2,
              long arg3)
          {
            /* getSelectedItem�Ҩ�o���OSQLiteCursor */
            SQLiteCursor sc = (SQLiteCursor) arg0.getSelectedItem();
            _id = sc.getInt(0);
            myEditText.setText(sc.getString(1));
          }

          @Override
          public void onNothingSelected(AdapterView<?> arg0)
          {

          }

        });

  }

  private void addTodo()
  {
    if (myEditText.getText().toString().equals(""))
      return;
    /* �s�W��ƨ��Ʈw */
    myToDoDB.insert(myEditText.getText().toString());
    /* ���s�d�� */
    myCursor.requery();
    /* ���s��zmyListView */
    myListView.invalidateViews();
    myEditText.setText("");
    _id = 0;
  }

  private void editTodo()
  {
    if (myEditText.getText().toString().equals(""))
      return;
    /* �ק��� */
    myToDoDB.update(_id, myEditText.getText().toString());
    myCursor.requery();
    myListView.invalidateViews();
    myEditText.setText("");
    _id = 0;
  }

  private void deleteTodo()
  {
    if (_id == 0)
      return;
    /* �R����� */
    myToDoDB.delete(_id);
    myCursor.requery();
    myListView.invalidateViews();
    myEditText.setText("");
    _id = 0;
  }
}

数据库的类

package irdc.ex05_05;

import android.app.Activity;
import android.database.Cursor;
import android.database.sqlite.SQLiteCursor;
import android.os.Bundle;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.widget.AdapterView;
import android.widget.EditText;
import android.widget.ListView;
import android.widget.SimpleCursorAdapter;

public class EX05_05 extends Activity
{
  private ToDoDB myToDoDB;
  private Cursor myCursor;
  private ListView myListView;
  private EditText myEditText;
  private int _id;
  protected final static int MENU_ADD = Menu.FIRST;
  protected final static int MENU_EDIT = Menu.FIRST + 1;
  protected final static int MENU_DELETE = Menu.FIRST + 2;

  @Override
  public boolean onOptionsItemSelected(MenuItem item)
  {
    super.onOptionsItemSelected(item);
    switch (item.getItemId())
    {
      case MENU_ADD:
        this.addTodo();
        break;
      case MENU_EDIT:
        this.editTodo();
        break;
      case MENU_DELETE:
        this.deleteTodo();
        break;
    }
    return true;
  }

  @Override
  public boolean onCreateOptionsMenu(Menu menu)
  {
    super.onCreateOptionsMenu(menu);
    /* �s�W�T��MENU */
    menu.add(Menu.NONE, MENU_ADD, 0, R.string.strAddButton);
    menu.add(Menu.NONE, MENU_EDIT, 0, R.string.strEditButton);
    menu.add(Menu.NONE, MENU_DELETE, 0, R.string.strDeleteButton);

    return true;
  }

  /** Called when the activity is first created. */
  @Override
  public void onCreate(Bundle savedInstanceState)
  {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.main);

    myListView = (ListView) this.findViewById(R.id.myListView);
    myEditText = (EditText) this.findViewById(R.id.myEditText);

    myToDoDB = new ToDoDB(this);
    /* ��oDataBase�̪���� */
    myCursor = myToDoDB.select();

    /* new SimpleCursorAdapter�ñNmyCursor�ǤJ�A��ܸ�ƪ���쬰todo_text */
    SimpleCursorAdapter adapter = new SimpleCursorAdapter(this, R.layout.list,
        myCursor, new String[]
        { ToDoDB.FIELD_TEXT }, new int[]
        { R.id.listTextView1 });
    myListView.setAdapter(adapter);

    /* �NmyListView�[�JOnItemClickListener */
    myListView.setOnItemClickListener(new AdapterView.OnItemClickListener()
    {

      @Override
      public void onItemClick(AdapterView<?> arg0, View arg1, int arg2,
          long arg3)
      {
        /* �NmyCursor������I�諸�� */
        myCursor.moveToPosition(arg2);
        /* ��o���_id���� */
        _id = myCursor.getInt(0);
        /* ��o���todo_text���� */
        myEditText.setText(myCursor.getString(1));
      }

    });
    myListView
        .setOnItemSelectedListener(new AdapterView.OnItemSelectedListener()
        {

          @Override
          public void onItemSelected(AdapterView<?> arg0, View arg1, int arg2,
              long arg3)
          {
            /* getSelectedItem�Ҩ�o���OSQLiteCursor */
            SQLiteCursor sc = (SQLiteCursor) arg0.getSelectedItem();
            _id = sc.getInt(0);
            myEditText.setText(sc.getString(1));
          }

          @Override
          public void onNothingSelected(AdapterView<?> arg0)
          {

          }

        });

  }

  private void addTodo()
  {
    if (myEditText.getText().toString().equals(""))
      return;
    /* �s�W��ƨ��Ʈw */
    myToDoDB.insert(myEditText.getText().toString());
    /* ���s�d�� */
    myCursor.requery();
    /* ���s��zmyListView */
    myListView.invalidateViews();
    myEditText.setText("");
    _id = 0;
  }

  private void editTodo()
  {
    if (myEditText.getText().toString().equals(""))
      return;
    /* �ק��� */
    myToDoDB.update(_id, myEditText.getText().toString());
    myCursor.requery();
    myListView.invalidateViews();
    myEditText.setText("");
    _id = 0;
  }

  private void deleteTodo()
  {
    if (_id == 0)
      return;
    /* �R����� */
    myToDoDB.delete(_id);
    myCursor.requery();
    myListView.invalidateViews();
    myEditText.setText("");
    _id = 0;
  }
}

主界面

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
  android:orientation="vertical"
  android:layout_width="fill_parent"
  android:layout_height="fill_parent"
  android:background="@drawable/white"
  >
  <TextView  
  android:layout_width="fill_parent" 
  android:layout_height="wrap_content" 
  android:text="@string/hello"
  android:textColor="@drawable/black"
  >
  </TextView>  
  <EditText  
  android:id="@+id/myEditText" 
  android:layout_width="fill_parent" 
  android:layout_height="wrap_content" 
  android:textColor="@drawable/black"
  >
  </EditText>
  <ListView 
  android:id="@+id/myListView" 
  android:layout_width="fill_parent" 
  android:layout_height="wrap_content"
  android:background="@drawable/white"
  >
  </ListView>   
</LinearLayout>

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
  android:orientation="vertical"
  android:layout_width="fill_parent"
  android:layout_height="fill_parent"
  >
  <CheckedTextView android:id="@+id/listTextView1"
  xmlns:android="http://schemas.android.com/apk/res/android"
  android:layout_width="wrap_content"
  android:layout_height="wrap_content"
  android:textColor="@drawable/black"
  >
  </CheckedTextView>
</LinearLayout>