(android) SQLite 数据操作（一）

main.xml文件

<?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"
    >
<TextView 
    android:layout_width="fill_parent"
    android:layout_height="wrap_content"
    android:text="@string/hello"
    />
<Button android:text="创建数据库"
 android:id="@+id/btncreatedatebase"
 android:layout_width="fill_parent"
  android:layout_height="wrap_content"></Button>
 
  <Button android:text="更新数据库"
 android:id="@+id/btnupdatedatebase"
 android:layout_width="fill_parent"
  android:layout_height="wrap_content"></Button>
 
  <Button android:text="insert"
 android:id="@+id/btninsert"
 android:layout_width="fill_parent"
  android:layout_height="wrap_content"></Button>
 
  <Button android:text="update"
 android:id="@+id/btnupdate"
 android:layout_width="fill_parent"
  android:layout_height="wrap_content"></Button>
 
  <Button android:text="query"
 android:id="@+id/btnquery"
 android:layout_width="fill_parent"
  android:layout_height="wrap_content"></Button>
</LinearLayout>

DatabaseHelper.java文件

package org.SQLiteTest;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;

public class DatabaseHelper extends SQLiteOpenHelper{

 private static final int VERSION=1;
 
 public DatabaseHelper(Context context, String name, CursorFactory factory,
   int version) {
  super(context, name, factory, version);
  // TODO Auto-generated constructor stub
 }
 public DatabaseHelper(Context context, String name) {
  this(context, name,VERSION);
  // TODO Auto-generated constructor stub
 }
 public DatabaseHelper(Context context, String name,int version) {
  this(context, name, null, version);
  // TODO Auto-generated constructor stub
 }
 @Override
 public void onCreate(SQLiteDatabase db) {
  // TODO Auto-generated method stub
  db.execSQL("create table user(id int,name varchar(20))");
 }

 @Override
 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  // TODO Auto-generated method stub
  
 }
 

}

SQLiteTest.java 文件

package org.SQLiteTest;
 
import android.app.Activity;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.Toast;

public class SQLiteTest extends Activity {
    /** Called when the activity is first created. */
 private Button btnCreateDatabase;
 private Button btnUpdateDatabase;
 private Button btnInsertTable;
 private Button btnUpdateTable;
 private Button btnQieryTable;
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);

  btnCreateDatabase=(Button)findViewById(R.id.btncreatedatebase);
  btnUpdateDatabase=(Button)findViewById(R.id.btnupdatedatebase);
  btnInsertTable=(Button)findViewById(R.id.btninsert);
  btnUpdateTable=(Button)findViewById(R.id.btnupdate);
  btnQieryTable=(Button)findViewById(R.id.btnquery);
  
  btnCreateDatabase.setOnClickListener(new CreateListener());
  btnUpdateDatabase.setOnClickListener(new UpdateListener());
  btnInsertTable.setOnClickListener(new InsertListener());
  btnUpdateTable.setOnClickListener(new UpdateRecordListener());
  btnQieryTable.setOnClickListener(new QueryRecordListener());
  
    }
   
    class CreateListener implements OnClickListener{
  @Override
  public void onClick(View v) {
   // TODO Auto-generated method stub
   DatabaseHelper dbhelper=new DatabaseHelper(SQLiteTest.this,"test_db");
   SQLiteDatabase db=dbhelper.getReadableDatabase();
   System.out.println("aaaaaaaa");
  }}
   
    class UpdateListener implements OnClickListener{
  @Override
  public void onClick(View v) {
   // TODO Auto-generated method stub
   DatabaseHelper dbhelper=new DatabaseHelper(SQLiteTest.this,"test_db",2);
   SQLiteDatabase db=dbhelper.getReadableDatabase();
   //db.delete("user", null, null);
   db.execSQL("drop table user");
   
  }}
   
    class InsertListener implements OnClickListener{
  @Override
  public void onClick(View v) {
   // TODO Auto-generated method stub
   ContentValues values=new ContentValues();
   values.put("id", 1);
   values.put("name","zhang san");
   DatabaseHelper dbhelper=new DatabaseHelper(SQLiteTest.this,"test_db");
   SQLiteDatabase db=dbhelper.getWritableDatabase();
   db.insert("user", null, values);
  }}
   
    class UpdateRecordListener implements OnClickListener{
  @Override
  public void onClick(View v) {
   // TODO Auto-generated method stub
   ContentValues values=new ContentValues();
   values.put("name","li si");
   DatabaseHelper dbhelper=new DatabaseHelper(SQLiteTest.this,"test_db");
   SQLiteDatabase db=dbhelper.getWritableDatabase();
   db.update("user", values, "id=?", new String[]{"1"});
  
  }}
 
    class QueryRecordListener implements OnClickListener{
  @Override
  public void onClick(View v) {
   // TODO Auto-generated method stub
      String name="";
   DatabaseHelper dbhelper=new DatabaseHelper(SQLiteTest.this,"test_db");
   SQLiteDatabase db=dbhelper.getReadableDatabase();
   Cursor cursor=db.query("user", new String[]{"id","name"}, "id=?", new String[]{"1"}, null, null, null);
   while(cursor.moveToNext())
    name+=cursor.getString(cursor.getColumnIndex("name"))+"\n";
   Toast.makeText(SQLiteTest.this, name, Toast.LENGTH_SHORT).show();
  }}
    
}