android---SQLite

 SQLiteAvtivity.java

 

package zlj.sqlite;import zlj.sqlite.db.DataBaseHelper;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;public class SQLiteActivity extends Activity { /** Called when the activity is first created. */private Button createButton = null;private Button upgradeButton = null;private Button addButton = null;private Button deleteButton = null;private Button modifyButton = null;private Button queryButton = null; @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.main); createButton = (Button)findViewById(R.id.createButton); createButton.setOnClickListener(new CreateClickListener()); upgradeButton = (Button)findViewById(R.id.upgradeButton); upgradeButton.setOnClickListener(new UpgradeClickListener()); addButton = (Button)findViewById(R.id.addButton); addButton.setOnClickListener(new AddClickListener()); deleteButton = (Button)findViewById(R.id.deleteButton); deleteButton.setOnClickListener(new DeleteClickListener()); modifyButton = (Button)findViewById(R.id.modifyButton); modifyButton.setOnClickListener(new ModifyClickListener()); queryButton = (Button)findViewById(R.id.queryButton); queryButton.setOnClickListener(new QueryClickListener()); } class CreateClickListener implements OnClickListener{@Overridepublic void onClick(View arg0) {// TODO Auto-generated method stubDataBaseHelper dbHelper = new DataBaseHelper(SQLiteActivity.this,"zlj_db");SQLiteDatabase db = dbHelper.getReadableDatabase();} } class UpgradeClickListener implements OnClickListener{@Overridepublic void onClick(View arg0) {// TODO Auto-generated method stubDataBaseHelper dbHelper = new DataBaseHelper(SQLiteActivity.this,"zlj_db",2);SQLiteDatabase db = dbHelper.getReadableDatabase();} } class AddClickListener implements OnClickListener{@Overridepublic void onClick(View arg0) {// TODO Auto-generated method stubContentValues values = new ContentValues();values.put("id", 1);values.put("name", "zhangsan");DataBaseHelper dbHelper = new DataBaseHelper(SQLiteActivity.this,"zlj_db");SQLiteDatabase db = dbHelper.getWritableDatabase();db.insert("user", null, values);} } class DeleteClickListener implements OnClickListener{@Overridepublic void onClick(View arg0) {// TODO Auto-generated method stubDataBaseHelper dbHelper = new DataBaseHelper(SQLiteActivity.this,"zlj_db");SQLiteDatabase db = dbHelper.getWritableDatabase();db.delete("user", "name=?", new String[]{"zhangsanfeng"});} } class ModifyClickListener implements OnClickListener{@Overridepublic void onClick(View arg0) {// TODO Auto-generated method stubDataBaseHelper dbHelper = new DataBaseHelper(SQLiteActivity.this,"zlj_db");SQLiteDatabase db = dbHelper.getWritableDatabase();ContentValues values = new ContentValues();values.put("name", "zhangsanfeng");db.update("user", values, "id=?", new String[]{"1"});} } class QueryClickListener implements OnClickListener{@Overridepublic void onClick(View arg0) {// TODO Auto-generated method stubDataBaseHelper dbHelper = new DataBaseHelper(SQLiteActivity.this,"zlj_db");SQLiteDatabase db = dbHelper.getWritableDatabase();Cursor cursor = db.query("user", new String[]{"id","name"}, "id=?", new String[]{"1"}, null, null, "id"); while(cursor.moveToNext()){ String name = cursor.getString(cursor.getColumnIndex("name")); System.out.println("query-->" + name); }} } }

 

 

DatabaseHelper.java

package zlj.sqlite.db;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);}public DataBaseHelper(Context context, String name) {super(context, name, null, VERSION);//为啥不能是是三个参数}public DataBaseHelper(Context context, String name, int version) {super(context, name, null, version);}@Overridepublic void onCreate(SQLiteDatabase db) {// TODO Auto-generated method stubSystem.out.println("create a database");db.execSQL("create table user(id int,name varchar(20))");}@Overridepublic void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {// TODO Auto-generated method stubSystem.out.println("update a database");}}

 

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="欢迎使用数据库" /><Button android:id="@+id/createButton" android:layout_width="fill_parent" android:layout_height="wrap_content" android:text="创建数据库" /><Button android:id="@+id/upgradeButton" android:layout_width="fill_parent" android:layout_height="wrap_content" android:text="升级数据库" /><Button android:id="@+id/addButton" android:layout_width="fill_parent" android:layout_height="wrap_content" android:text="增加数据" /><Button android:id="@+id/deleteButton" android:layout_width="fill_parent" android:layout_height="wrap_content" android:text="删除数据" /><Button android:id="@+id/modifyButton" android:layout_width="fill_parent" android:layout_height="wrap_content" android:text="更改数据" /><Button android:id="@+id/queryButton" android:layout_width="fill_parent" android:layout_height="wrap_content" android:text="查询数据" /> </LinearLayout>