Android(安卓)SqlLiter使用

packagecom.jl;

importandroid.content.ContentValues;
importandroid.content.Context;
importandroid.database.Cursor;
importandroid.database.sqlite.SQLiteDatabase;
importandroid.database.sqlite.SQLiteOpenHelper;
importandroid.database.sqlite.SQLiteDatabase.CursorFactory;

publicclassdbHelperextendsSQLiteOpenHelper{

privatefinalstaticStringDATABASE_NAME="sec_db";
privatefinalstaticintDATABASE_VERSION=1;
privatefinalstaticStringTABLE_NAME="sec_pwd";
publicfinalstaticStringFIELD_ID="_id";
publicfinalstaticStringFIELD_TITLE="sec_Title";

publicdbHelper(Contextcontext)
{
super(context,DATABASE_NAME,null,DATABASE_VERSION);
}

@Override
publicvoidonCreate(SQLiteDatabasedb){
//TODOAuto-generatedmethodstub
Stringsql="Createtable"+TABLE_NAME+"("+FIELD_ID+"integerprimarykeyautoincrement,"
+FIELD_TITLE+"text);";
db.execSQL(sql);

}

@Override
publicvoidonUpgrade(SQLiteDatabasedb,intoldVersion,intnewVersion){
//TODOAuto-generatedmethodstub
Stringsql="DROPTABLEIFEXISTS"+TABLE_NAME;
db.execSQL(sql);
onCreate(db);
}

publiclonginsert(StringTitle)
{
SQLiteDatabasedb=this.getWritableDatabase();
ContentValuescv=newContentValues();
cv.put(FIELD_TITLE,Title);
longrow=db.insert(TABLE_NAME,null,cv);
returnrow;
}

/*执行删除，调用db的delete,需要三个参数*/

publicvoiddelete(intid)
{
SQLiteDatabasedb=this.getWritableDatabase();
Stringwhere=FIELD_ID+"=?";
String[]whereValue={Integer.toString(id)};
db.delete(TABLE_NAME,where,whereValue);
}

/*跟新表数据，执行update，需要四个参数*/

/*传入参数为限制条件，和更新后的值*/

publicvoidupdate(intid,StringTitle)
{
SQLiteDatabasedb=this.getWritableDatabase();
Stringwhere=FIELD_ID+"=?";
String[]whereValue={Integer.toString(id)};
ContentValuescv=newContentValues();
cv.put(FIELD_TITLE,Title);
db.update(TABLE_NAME,cv,where,whereValue);
}

/*查找，结果按id排序降序*/

publicCursorselect()
{
SQLiteDatabasedb=this.getReadableDatabase();
Cursorcursor=db.query(TABLE_NAME,null,null,null,null,null,"_iddesc");
returncursor;
}

}

from:http://www.cnblogs.com/TerryBlog/archive/2010/06/12/1757166.html

更多相关文章

随机推荐