萝卜根

package com.cxybase.sqliteTest.db;
 
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.util.Log;
 
public class sqliteHelper extends SQLiteOpenHelper{
 
 private final static int VERSION = 1;
 private final static String TAG = "cxybase";
 
 public sqliteHelper(Context context, String name, CursorFactory factory,
 int version) {
 //必须通过super调用父类中的构造函数
 super(context, name, factory, version);
 // TODO Auto-generated constructor stub
 }
 
 public sqliteHelper(Context context, String name)
 {
 this(context, name, VERSION);
 }
 
 public sqliteHelper(Context context, String name, int version)
 {
 this(context,name, null,version);
 }
 
 
 @Override
 public void onCreate(SQLiteDatabase db) {
 // TODO Auto-generated method stub
 Log.i(TAG, "create a Database");
 
 String sql = "create table user(id int, name varchar(20))";
 db.execSQL(sql);
 }
 
 @Override
 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
 // TODO Auto-generated method stub
 Log.i(TAG, "update a Database");
 }
 
}

package com.cxybase.sqliteTest;
 
import android.app.Activity;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
 
import com.cxybase.sqliteTest.db.sqliteHelper;
 
public class sqliteTest extends Activity {
 
 private final static String TAG = "cxyabse";
 
 //声明控件对象
 private Button createDatabase = null; //创建数据苦
 private Button updateDatabase = null; //更新数据库
 private Button insert = null;
 private Button update = null; //更新数据库中的数据
 private Button query = null;
 private Button delete = null;
 
 /** Called when the activity is first created. */
 @Override
 public void onCreate(Bundle savedInstanceState) {
 super.onCreate(savedInstanceState);
 setContentView(R.layout.main);
 
 //根据控件ID获得控件对象,并设置相关的监听器
 createDatabase = (Button)findViewById(R.id.createDatabase);
 createDatabase.setOnClickListener(new createDatabaseListener());
 
 updateDatabase = (Button)findViewById(R.id.updateDatabase);
 updateDatabase.setOnClickListener(new updateDatabaseListener());
 
 insert = (Button)findViewById(R.id.insert);
 insert.setOnClickListener(new insertListener());
 
 update = (Button)findViewById(R.id.update);
 update.setOnClickListener(new updateRecordListener());
 
 query = (Button)findViewById(R.id.query);
 query.setOnClickListener(new queryListener());
 
 delete = (Button)findViewById(R.id.delete);
 delete.setOnClickListener(new deleteListener());
 }
 
 
 class createDatabaseListener implements OnClickListener
 {
 
 public void onClick(View v) {
 // TODO Auto-generated method stub
 sqliteHelper dbHelper = new sqliteHelper(sqliteTest.this, "test_cxybase_db");
 SQLiteDatabase db = dbHelper.getReadableDatabase();
 }
 
 }
 
 class updateDatabaseListener implements OnClickListener
 {
 
 public void onClick(View v) {
 // TODO Auto-generated method stub
 sqliteHelper dbHelper = new sqliteHelper(sqliteTest.this, "test_cxybase_db", 2);
 SQLiteDatabase db = dbHelper.getReadableDatabase();
 }
 
 }
 
 class insertListener implements OnClickListener
 {
 
 public void onClick(View v) {
 // TODO Auto-generated method stub
 ContentValues values = new ContentValues();
 
 values.put("id", 2);
 values.put("name", "zhangsan");
 
 sqliteHelper dbHelper = new sqliteHelper(sqliteTest.this, "test_cxybase.db",2);
 SQLiteDatabase db = dbHelper.getWritableDatabase();
 db.insert("user", null, values);
 
//            Log.i(TAG, "插入数据完成");
 
 }
 
 }
 
 class updateRecordListener implements OnClickListener
 {
 
 public void onClick(View v) {
 // TODO Auto-generated method stub
 sqliteHelper dbHelper = new sqliteHelper(sqliteTest.this, "test_cxybase.db",2);
 SQLiteDatabase db = dbHelper.getWritableDatabase();
 
 ContentValues values = new ContentValues();
 values.put("name", "lisi");
 
 //?为占位符
 //有几个占位符，最后一个参数就应该有几个值
 db.update("user", values, "id=?", new String[]{"1"});
 }
 
 }
 
 class queryListener implements OnClickListener
 {
 
 public void onClick(View v) {
 // TODO Auto-generated method stub
 sqliteHelper dbHelper = new sqliteHelper(sqliteTest.this, "test_cxybase.db",2);
 SQLiteDatabase db = dbHelper.getReadableDatabase();
 
 Cursor cur = db.query("user", new String[]{"id","name"}, "id=?", new String[]{"1"}, null, null, null);
 while(cur.moveToNext())
 {
 //cur.getColumnIndex("name")得到记录的编号
 String name = cur.getString(cur.getColumnIndex("name"));
 Log.i(TAG, "query--->" + name);
 }
 
 }
 
 }
 
 class deleteListener implements OnClickListener
 {
 
 public void onClick(View v) {
 // TODO Auto-generated method stub
 sqliteHelper dbHelper = new sqliteHelper(sqliteTest.this, "test_cxybase.db",2);
 SQLiteDatabase db = dbHelper.getWritableDatabase();
 
 db.delete("user", "id=?", new String[]{"1"});
 
 }
 
 }
 
}