Sqlite所作增删改查示例
发布时间:2020-12-12 19:56:20 所属栏目:百科 来源:网络整理
导读:package com.db.imgfornote; import android.content.ContentValues; android.content.Context; android.database.Cursor; android.database.sqlite.SQLiteDatabase; android.database.sqlite.SQLiteDatabase.CursorFactory; android.database.sqlite.SQLite
package
com.db.imgfornote;
import
android.content.ContentValues;
android.content.Context;
android.database.Cursor;
android.database.sqlite.SQLiteDatabase;
android.database.sqlite.SQLiteDatabase.CursorFactory;
android.database.sqlite.SQLiteOpenHelper;
android.util.Log;
public
class
DBHelper
extends
SQLiteOpenHelper {
final
private
static
String mDbName=
"imgfornote"
;
static
int
mDbVersion=
1
;
static
DBHelper mInstance=
null
;
String mTUserPhoto=
"UserPhoto"
;
String mCreateSqlForNoteClass=
"create table if not exists NoteClass(classId integer primary key asc autoincrement,className NVARCHAR(100),rowTime timestamp default (datetime('now','localtime')))"
;
String mCreateSqlForUserPhoto=
"create table if not exists UserPhoto(photoId integer primary key asc autoincrement,photoName VARCHAR(200),userPt VARCHAR(200),title VARCHAR(255),classId integer,content NVARCHAR(250),tag NVARCHAR(200),remark text,status integer default 0,182)!important; background:none!important">;
String[] mInsertSqlForNoteClass={
"insert into NoteClass(className) values('默认分类[私有]');"
,
"insert into NoteClass(className) values('读书笔记[私有]');"
"insert into NoteClass(className) values('电子资料[公开]');"
};
private
DBHelper(Context context,CursorFactory factory) {
super
(context,mDbName,factory,mDbVersion);
}
DBHelper GetInstance(Context context,SQLiteDatabase.CursorFactory factory)
{
if
(mInstance==
){
mInstance =
new
DBHelper(context,factory);
}
return
mInstance;
}
@Override
void
onCreate(SQLiteDatabase db) {
// 创建表
db.execSQL(mCreateSqlForNoteClass);
db.execSQL(mCreateSqlForUserPhoto);
//初始化数据
for
(
int
i=
0
;i<mInsertSqlForNoteClass.length;i++)
db.execSQL(mInsertSqlForNoteClass[i]);
}
@Override
onUpgrade(SQLiteDatabase db,
oldVersion,182)!important; background:none!important">newVersion) {
// TODO Auto-generated method stub
}
Cursor ExecSQLForCursor(String sql,String[] selectionArgs){
SQLiteDatabase db =getWritableDatabase();
Log.i(
"ExecSQLForCursor"
{
SQLiteDatabase db =getWritableDatabase();
ExecSQL(sql,db);
}
catch
(Exception e){
Log.e(
"ExecSQL Exception"
ContentValues cv =
ContentValues();
cv.put(
"photoName"
;
{
String ord = (sort==
|| sort.toLowerCase().startsWith(
"a"
))?
"asc"
:
"desc"
;
String sql =
"select * from UserPhoto order by photoId "
+ord;
String[] args = {String.valueOf(row)};
(row>
){
sql +=
" limit ?"
;
else
{
args=
;
}
cur = ExecSQLForCursor(sql,args);
(Exception e) {
cur =
;
"SearchPhoto Exception"
photoId,182)!important; background:none!important">classId,String title,String content,String tag){
SQLiteDatabase db =getWritableDatabase();
ContentValues();
"classId"
db.delete(mTUserPhoto,args);
}
} (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |