db=SQLiteDatabase.openOrCreateDatabase("/data/data/com.lingdududu.db/databases/stu.db",null);

private void createTable(SQLiteDatabase db){
//創(chuàng)建表SQL語句
String stu_table="create table usertable(_id integer primary key autoincrement,sname text,snumber text)";
//執(zhí)行SQL語句
db.execSQL(stu_table);
}

private void insert(SQLiteDatabase db){
//實例化常量值
ContentValues cValue = new ContentValues();
//添加用戶名
cValue.put("sname","xiaoming");
//添加密碼
cValue.put("snumber","01005");
//調(diào)用insert()方法插入數(shù)據(jù)
db.insert("stu_table",null,cValue);
}

private void insert(SQLiteDatabase db){
//插入數(shù)據(jù)SQL語句
String stu_sql="insert into stu_table(sname,snumber) values('xiaoming','01005')";
//執(zhí)行SQL語句
db.execSQL(sql);
}

private void delete(SQLiteDatabase db) {
//刪除條件
String whereClause = "id=?";
//刪除條件參數(shù)
String[] whereArgs = {String.valueOf(2)};
//執(zhí)行刪除
db.delete("stu_table",whereClause,whereArgs);
}

private void delete(SQLiteDatabase db) {  
//刪除SQL語句  
String sql = "delete from stu_table where _id = 6";  
//執(zhí)行SQL語句  
db.execSQL(sql);  
}  

private void update(SQLiteDatabase db) {  
//實例化內(nèi)容值 ContentValues values = new ContentValues();  
//在values中添加內(nèi)容  
values.put("snumber","101003");  
//修改條件  
String whereClause = "id=?";  
//修改添加參數(shù)  
String[] whereArgs={String.valuesOf(1)};  
//修改  
db.update("usertable",values,whereClause,whereArgs);  
}

private void update(SQLiteDatabase db){  
//修改SQL語句  
String sql = "update stu_table set snumber = 654321 where id = 1";  
//執(zhí)行SQL  
db.execSQL(sql);  
}

private void query(SQLiteDatabase db) {  
//查詢獲得游標(biāo)  
Cursor cursor = db.query ("usertable",null,null,null,null,null,null);  
   
//判斷游標(biāo)是否為空  
if(cursor.moveToFirst() {  
//遍歷游標(biāo)  
for(int i=0;i<cursor.getCount();i++){  
cursor.move(i);  
//獲得ID  
int id = cursor.getInt(0);  
//獲得用戶名  
String username=cursor.getString(1);  
//獲得密碼  
String password=cursor.getString(2);  
//輸出用戶信息 System.out.println(id+":"+sname+":"+snumber);  
}  
}  
}

private void drop(SQLiteDatabase db){  
//刪除表的SQL語句  
String sql ="DROP TABLE stu_table";  
//執(zhí)行SQL  
db.execSQL(sql);  
} 

package com.lingdududu.testSQLite;
 
import com.lingdududu.testSQLiteDb.StuDBHelper;
 
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;
/*
* @author lingdududu
*/
public class SQLiteActivity extends Activity {
/** Called when the activity is first created. */
//聲明各個按鈕
private Button createBtn;
private Button insertBtn;
private Button updateBtn;
private Button queryBtn;
private Button deleteBtn;
private Button ModifyBtn;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
 
//調(diào)用creatView方法
creatView();
//setListener方法
setListener();
}
 
//通過findViewById獲得Button對象的方法
private void creatView(){
createBtn = (Button)findViewById(R.id.createDatabase);
updateBtn = (Button)findViewById(R.id.updateDatabase);
insertBtn = (Button)findViewById(R.id.insert);
ModifyBtn = (Button)findViewById(R.id.update);
queryBtn = (Button)findViewById(R.id.query);
deleteBtn = (Button)findViewById(R.id.delete);
}
 
//為按鈕注冊監(jiān)聽的方法
private void setListener(){
createBtn.setOnClickListener(new CreateListener());
updateBtn.setOnClickListener(new UpdateListener());
insertBtn.setOnClickListener(new InsertListener());
ModifyBtn.setOnClickListener(new ModifyListener());
queryBtn.setOnClickListener(new QueryListener());
deleteBtn.setOnClickListener(new DeleteListener());
}
 
//創(chuàng)建數(shù)據(jù)庫的方法
class CreateListener implements OnClickListener{
 
@Override
public void onClick(View v) {
//創(chuàng)建StuDBHelper對象
StuDBHelper dbHelper = new StuDBHelper(SQLiteActivity.this,"stu_db",null,1);
//得到一個可讀的SQLiteDatabase對象
SQLiteDatabase db =dbHelper.getReadableDatabase();
}
}
 
//更新數(shù)據(jù)庫的方法
class UpdateListener implements OnClickListener{
 
@Override
public void onClick(View v) {
// 數(shù)據(jù)庫版本的更新,由原來的1變?yōu)?
StuDBHelper dbHelper = new StuDBHelper(SQLiteActivity.this,"stu_db",null,2);
SQLiteDatabase db =dbHelper.getReadableDatabase();
}
}
 
//插入數(shù)據(jù)的方法
class InsertListener implements OnClickListener{
 
@Override
public void onClick(View v) {
 
StuDBHelper dbHelper = new StuDBHelper(SQLiteActivity.this,"stu_db",null,1);
//得到一個可寫的數(shù)據(jù)庫
SQLiteDatabase db =dbHelper.getWritableDatabase();
 
//生成ContentValues對象 //key:列名，value:想插入的值
ContentValues cv = new ContentValues();
//往ContentValues對象存放數(shù)據(jù)，鍵-值對模式
cv.put("id", 1);
cv.put("sname", "xiaoming");
cv.put("sage", 21);
cv.put("ssex", "male");
//調(diào)用insert方法，將數(shù)據(jù)插入數(shù)據(jù)庫
db.insert("stu_table", null, cv);
//關(guān)閉數(shù)據(jù)庫
db.close();
}
}
 
//查詢數(shù)據(jù)的方法
class QueryListener implements OnClickListener{
 
@Override
public void onClick(View v) {
 
StuDBHelper dbHelper = new StuDBHelper(SQLiteActivity.this,"stu_db",null,1);
//得到一個可寫的數(shù)據(jù)庫
SQLiteDatabase db =dbHelper.getReadableDatabase();
//參數(shù)1：表名
//參數(shù)2：要想顯示的列
//參數(shù)3：where子句
//參數(shù)4：where子句對應(yīng)的條件值
//參數(shù)5：分組方式
//參數(shù)6：having條件
//參數(shù)7：排序方式
Cursor cursor = db.query("stu_table", new String[]{"id","sname","sage","ssex"}, "id=?", new String[]{"1"}, null, null, null);
while(cursor.moveToNext()){
String name = cursor.getString(cursor.getColumnIndex("sname"));
String age = cursor.getString(cursor.getColumnIndex("sage"));
String sex = cursor.getString(cursor.getColumnIndex("ssex"));
System.out.println("query------->" + "姓名："+name+" "+"年齡："+age+" "+"性別："+sex);
}
//關(guān)閉數(shù)據(jù)庫
db.close();
}
}
 
//修改數(shù)據(jù)的方法
class ModifyListener implements OnClickListener{
 
@Override
public void onClick(View v) {
 
StuDBHelper dbHelper = new StuDBHelper(SQLiteActivity.this,"stu_db",null,1);
//得到一個可寫的數(shù)據(jù)庫
SQLiteDatabase db =dbHelper.getWritableDatabase();
ContentValues cv = new ContentValues();
cv.put("sage", "23");
//where 子句 "?"是占位符號，對應(yīng)后面的"1",
String whereClause="id=?";
String [] whereArgs = {String.valueOf(1)};
//參數(shù)1 是要更新的表名
//參數(shù)2 是一個ContentValeus對象
//參數(shù)3 是where子句
db.update("stu_table", cv, whereClause, whereArgs);
}
}
 
//刪除數(shù)據(jù)的方法
class DeleteListener implements OnClickListener{
 
@Override
public void onClick(View v) {
 
StuDBHelper dbHelper = new StuDBHelper(SQLiteActivity.this,"stu_db",null,1);
//得到一個可寫的數(shù)據(jù)庫
SQLiteDatabase db =dbHelper.getReadableDatabase();
String whereClauses = "id=?";
String [] whereArgs = {String.valueOf(2)};
//調(diào)用delete方法，刪除數(shù)據(jù)
db.delete("stu_table", whereClauses, whereArgs);
}
}
}

package com.lingdududu.testSQLiteDb; 
   
import android.content.Context; 
import android.database.sqlite.SQLiteDatabase; 
import android.database.sqlite.SQLiteDatabase.CursorFactory; 
import android.database.sqlite.SQLiteOpenHelper; 
import android.util.Log; 
   
public class StuDBHelper extends SQLiteOpenHelper { 
   
private static final String TAG = "TestSQLite"; 
public static final int VERSION = 1; 
   
//必須要有構(gòu)造函數(shù) 
public StuDBHelper(Context context, String name, CursorFactory factory, 
int version) { 
super(context, name, factory, version); 
} 
   
// 當(dāng)?shù)谝淮蝿?chuàng)建數(shù)據(jù)庫的時候，調(diào)用該方法  
public void onCreate(SQLiteDatabase db) { 
String sql = "create table stu_table(id int,sname varchar(20),sage int,ssex varchar(10))"; 
//輸出創(chuàng)建數(shù)據(jù)庫的日志信息 
Log.i(TAG, "create Database------------->"); 
//execSQL函數(shù)用于執(zhí)行SQL語句 
db.execSQL(sql); 
} 
   
//當(dāng)更新數(shù)據(jù)庫的時候執(zhí)行該方法 
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { 
//輸出更新數(shù)據(jù)庫的日志信息 
Log.i(TAG, "update Database------------->"); 
} 
}

<?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:id="@+id/createDatabase" 
android:layout_width="fill_parent"  
android:layout_height="wrap_content"  
android:text="創(chuàng)建數(shù)據(jù)庫" 
/>  
<Button 
android:id="@+id/updateDatabase" 
android:layout_width="fill_parent"  
android:layout_height="wrap_content"  
android:text="更新數(shù)據(jù)庫" 
/>  
<Button 
android:id="@+id/insert" 
android:layout_width="fill_parent"  
android:layout_height="wrap_content"  
android:text="插入數(shù)據(jù)" 
/> 
<Button 
android:id="@+id/update" 
android:layout_width="fill_parent"  
android:layout_height="wrap_content"  
android:text="更新數(shù)據(jù)" 
/> 
<Button 
android:id="@+id/query" 
android:layout_width="fill_parent"  
android:layout_height="wrap_content"  
android:text="查詢數(shù)據(jù)" 
/> 
<Button 
android:id="@+id/delete" 
android:layout_width="fill_parent"  
android:layout_height="wrap_content"  
android:text="刪除數(shù)據(jù)" 
/> 
</LinearLayout>