1.使用SQL语句

2.使用内置函数操作数据库

public class MainActivity extends Activity {	@Override	protected void onCreate(Bundle savedInstanceState) {		super.onCreate(savedInstanceState);		setContentView(R.layout.activity_main);		SQLiteDatabase db = openOrCreateDatabase("stu.db", MODE_PRIVATE, null);        //创建一个SQL语句		db.execSQL("create table if not exists stutb(_id integer primary key autoincrement,name text not null,sex text not null,age integer not null)");        //创建键值		ContentValues values = new ContentValues();		values.put("name", "张三丰˝");		values.put("sex", "男");ß		values.put("age", 19);        //插入		long rowId = db.insert("stutb", null, values);        //values清除值		values.clear();        //更新		db.update("stutb", values, "_id>?", new String[]{"3"});		db.delete("stutb", "name like ?", new String[]{"%丰%"});		Cursor c = db.query("stutb", null, "_id>?", new String[]{"0"}, null, null, "name");		if (c!=null) {            //偏离查询到的值			String [] columns= c.getColumnNames();			while (c.moveToNext()) {				for (String columnName : columns) {					Log.i("info", c.getString(c.getColumnIndex(columnName)));				}			}			c.close();		}		db.close();	}}

3.SQLiteOpenHelper-数据库管理器

//继承SQLiteOpenHelperpublic class DBOpenHelper extends SQLiteOpenHelper{		public DBOpenHelper(Context context, String name) {		super(context, name, null, 1);		// 构造函数	}	public DBOpenHelper(Context context, String name, CursorFactory factory,			int version) {		super(context, name, factory, version);		// 构造函数	}	@Override//首次创建数据库的时候调用 一般可以把建库 建表的操作	public void onCreate(SQLiteDatabase db) {		// TODO Auto-generated method stub		db.execSQL("create table if not exists stutb(_id integer primary key autoincrement,name text not null,sex text not null,age integer not null)");		db.execSQL("insert into stutb(name,sex,age)values('小明','男',18)");	}	@Override//当数据库的版本变化的时候 会自动执行	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {		// TODO Auto-generated method stub			}}========public class MainActivity extends Activity {	@Override	protected void onCreate(Bundle savedInstanceState) {		super.onCreate(savedInstanceState);		setContentView(R.layout.activity_main);		DBOpenHelper helper =	new DBOpenHelper(MainActivity.this, "stu.db");//		helper.getReadableDatabase();//获取一个只读数据库		SQLiteDatabase db = helper.getWritableDatabase();//		db.query(table, columns, selection, selectionArgs, groupBy, having, orderBy)		Cursor c = db.rawQuery("select * from stutb", null);		if (c!=null) {			String [] cols = c.getColumnNames();			while (c.moveToNext()) {				for (String ColumnName : cols) {					Log.i("info", ColumnName+":"+c.getString(c.getColumnIndex(ColumnName)));				}			}			c.close();		}		db.close();	}}