【Android】数据库 sqLite

首先新建一个类继承自SQLiteOpenHelper，实现方法public class MyDateBase1 extends SQLiteOpenHelper {public MyDateBase1(Context context) {super(context, "myDataBase", null, 1);}@Overridepublic void onCreate(SQLiteDatabase db) {}@Overridepublic void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {}}

在其他类中 直接new这个类，，并且getWritableDatabase和getreadableDatabase之后就可以了

DBHelper d = new DBHelper(this);SQLiteDatabase dbwrite,dbread;dbwrite = dbhelp.getWritableDatabase();dbread = dbhelp.getreadableDatabase();

可以在oncreate方法中执行数据库的初始化

增删改查的sql

insert into 表(name,age)values("","");delete from 表 where age=20;update 表 set name ="XX" where age = 20;Cursor c = dbRead.rawQuery("select * from student",null);while(c.moveToNext()){String name = c .getSrting(c.getColumuIndex("name"))int age = c.getInt(c.getColumuIndex("age"));}调用方法是

db.execSQL("");

背起简单的行攘，沐浴自由的风。