首先是创建db数据库， android有一个 sqliteOpenHelper类可以使用

package com.example.testcustomerlistsql;

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 DataBaseHelper extends sqliteOpenHelper {

	public DataBaseHelper(Context context,String name,CursorFactory factory,int version){
		super(context,name,factory,version);
	}

	public void onCreate(sqliteDatabase db){
		Log.d("LL","Create a table Customer_List _start");
		
		db.execsql("CREATE TABLE IF NOT EXISTS customerlist(_id integer primary key autoincrement," +
		"user_id varchar(30),user_mobile varchar(30),user_name varchar(30),id_type varchar(30),identification varchar(30),status varchar(1))");
	}

	public void onUpgrade(sqliteDatabase db,int oldVersion,int newVersion) {
		Log.d("LL","更新表结构");		
		
		db.execsql("DROP TABLE IF EXISTS customerlist"); 
		onCreate(db); 
	}
}

		  //使用execsql方法向表中插入数据
		  db.execsql("insert into hero_info(name,level) values('bb',1)");
		  //使用insert方法向表中插入数据
		  ContentValues values = new ContentValues();
		  values.put("name","xh");
		  values.put("level",2);
		  //调用方法插入数据
		  db.insert("hero_info","id",values);

sqld.delete(dbc,"user_id=?",new String[]{UserID});

		DataBaseHelper db = new DataBaseHelper(CustomerList.this,"user",null,2);
		
		sqliteDatabase sqld = db.getWritableDatabase();
		Cursor cursor = sqld.query(dbc,new String[] { "_id","user_id","user_mobile","user_name","id_type","identification","status"},null);
		
		int i = 0;
		while (cursor.moveToNext()) {
			String _id = cursor.getString(cursor.getColumnIndex("_id"));
			String user_id = cursor.getString(cursor.getColumnIndex("user_id"));
			String user_mobile = cursor.getString(cursor.getColumnIndex("user_mobile"));
			String user_name = cursor.getString(cursor.getColumnIndex("user_name"));
			String id_type = cursor.getString(cursor.getColumnIndex("id_type"));
			String identification = cursor.getString(cursor.getColumnIndex("identification"));;
			String status = cursor.getString(cursor.getColumnIndex("status"));
			
			Log.d("LL","_id——>" + _id + "   user_id——>" + user_id +"   status——>" + status
					+ "  user_mobile——>" + user_mobile + "  user_name——>" + user_name
					+ "  id_type——>" + id_type + "  identification——>" +identification);

			strUserId[i] = user_id;
			strMobile[i] = user_mobile;
			strName[i] = user_name;
			strIdType[i] = id_type;
			strIdentification[i]= identification;
			strStatus[i]= status;
			i++;
		}
		cursor.close();
		sqld.close();
	

sqd.update(dbc,values,new String[]{strUserId[i]});

db.execsql("ALTER TABLE hero_info ADD COLUMN asd INTEGER DEFAULT 0");