package com.sql;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
public class DataBaseHelpler extends SQLiteOpenHelper{
  private static final int VERSION = 1;
  public DataBaseHelpler(Context context, String name, CursorFactory factory,
      int version) {
    super(context, name, factory, version);
    // TODO Auto-generated constructor stub
  }
  public DataBaseHelpler(Context context,String name){
    this(context,name,VERSION);
  }
  public DataBaseHelpler(Context context, String name,int version){
    this(context, name, null, version);
  }
  @Override
  public void onCreate(SQLiteDatabase db) {
    // TODO Auto-generated method stub
    System.out.println("creat database");
    db.execSQL("create table student(no int,name verchar(20))");
  }
  @Override
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    // TODO Auto-generated method stub
    System.out.println("upgrade database");
  }
}

package com.sql;
import android.app.Activity;
import android.content.ContentValues;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
public class SQLiteActivity extends Activity {
  /** Called when the activity is first created. */
  private Button button_create,
          button_upgreate,
          button_insert,
          button_up,
          button_query,
          button_delete;
  @Override
  public void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.main);
    button_create = (Button) findViewById(R.id.button1);
    button_upgreate = (Button) findViewById(R.id.button2);
    button_insert = (Button) findViewById(R.id.button3);
    button_up = (Button) findViewById(R.id.button4);
    button_query = (Button) findViewById(R.id.button5);
    button_delete = (Button) findViewById(R.id.button6);
    //创建数据库
    button_create.setOnClickListener(new OnClickListener() {
      public void onClick(View v) {
        // TODO Auto-generated method stub
        DataBaseHelpler dbh = new DataBaseHelpler(SQLiteActivity.this,"tabel_one");
        SQLiteDatabase sql = dbh.getReadableDatabase();
      }
    });
    //更新数据库
    button_upgreate.setOnClickListener(new OnClickListener() {
      public void onClick(View v) {
        // TODO Auto-generated method stub
        DataBaseHelpler dbh = new DataBaseHelpler(SQLiteActivity.this,"tabel_one",2);
        SQLiteDatabase sql = dbh.getReadableDatabase();
      }
    });
    //向数据库中的表中插入内容
    button_insert.setOnClickListener(new OnClickListener() {
      public void onClick(View v) {
        // TODO Auto-generated method stub
        ContentValues values = new ContentValues();
        values.put("no", 123);
        values.put("name", "zhangsan");
        DataBaseHelpler dbh = new DataBaseHelpler(SQLiteActivity.this,"tabel_one",2);
        SQLiteDatabase sql = dbh.getReadableDatabase();
        sql.insert("tabel_one", null, values);
      }
    });
    //更新表的内容
    button_up.setOnClickListener(new OnClickListener() {
      public void onClick(View v) {
        // TODO Auto-generated method stub
        DataBaseHelpler dbh = new DataBaseHelpler(SQLiteActivity.this,"tabel_one");
        SQLiteDatabase sql = dbh.getReadableDatabase();
        ContentValues values = new ContentValues();
        values.put("name", "wangwu");
        sql.update("tabel_one", values, "id=?", new String[]{"1"});
      }
    });
    //查找表的内容
    button_query.setOnClickListener(new OnClickListener() {
      public void onClick(View v) {
        // TODO Auto-generated method stub
      }
    });
    //删除
    button_delete.setOnClickListener(new OnClickListener() {
      public void onClick(View v) {
        // TODO Auto-generated method stub
      }
    });
  }
}