Sqlite

sqlite基本使用：

创建一个类是实现SQLiteOpenHelper类：

重写里面的三个方法：

public class Mydb extends SQLiteOpenHelper{


public Mydb(Context context) {
super(context, DBFinal.DB_NAME, null, DBFinal.DB_VERSION);

}
   //primary key
@Override
public void onCreate(SQLiteDatabase db) {
String str="create table %1$s(%2$s text,%3$s char(15),%4$s text)";
String sql=String.format(str, DBFinal.TABLE_NAME+DBFinal
.CLONMS_NAME+DBFinal.CLONMS_AGE+DBFinal.CLONMS_SEX);
db.execSQL(sql);
}


@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub

}


}

2. 创建这个类的对象:并对数据进行操作

public class DButil {
  static Mydb db;
  public static Mydb getInfo(Context context){
 if(db==null){
 db=new Mydb(context);
 }
 return db;
  }


  public static void insert(){
 SQLiteDatabase writeableDatabase =db.getWritableDatabase();
 ContentValues c=new ContentValues();
 c.put(DBFinal.CLONMS_NAME, "zs");
 c.put(DBFinal.CLONMS_AGE, "34");
 c.put(DBFinal.CLONMS_SEX, "male");
 writeableDatabase.insert(DBFinal.TABLE_NAME, null, c);
 writeableDatabase.execSQL("insert name=zs,age=22 while id=2");
 
 
  }
  public static void query(){
 SQLiteDatabase  readableDatabase=db.getReadableDatabase();
Cursor cursor =readableDatabase.query(DBFinal.TABLE_NAME, new String[]{
DBFinal.CLONMS_NAME,DBFinal.CLONMS_AGE,
DBFinal.CLONMS_SEX}, DBFinal.CLONMS_NAME+" = ?", 
new String[]{"zs"}, null, DBFinal.CLONMS_AGE, "asc");
while(cursor.moveToNext()){
String name=cursor.getString(cursor.getColumnIndex(DBFinal.CLONMS_NAME));
int id=cursor.getInt(cursor.getColumnIndex("id"));
}
readableDatabase.rawQuery("select DBFinal.CLONMS_NAME from DBFinal.DB_NAME", new String[]{"zs"});

  }
  public static void update(Object o){
 SQLiteDatabase writeableDatabase =db.getWritableDatabase();
 ContentValues values=new ContentValues();
 values.put("name", "zs");
 values.put("age", "23");
 writeableDatabase.update(DBFinal.TABLE_NAME, values, DBFinal.CLONMS_NAME+" = ?", new String[]{(String) o}) ; 
  }
  public static void delete(String name){
 SQLiteDatabase writeableDatabase =db.getWritableDatabase();
 writeableDatabase.delete(DBFinal.TABLE_NAME, DBFinal.CLOUNMS_ID+" = ?", new String[]{""+1});
  }
}