android sqlite 增删改[insert、up…

kevin0490

package com.db.imgfornote;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

public class DBHelper extends SQLiteOpenHelper {
<wbr><wbr><wbr>finalprivate static String mDbName="imgfornote";<br><wbr><wbr><wbr>finalprivate static int mDbVersion=1;<br><wbr><wbr><wbr>privatestatic DBHelper mInstance=null;<br><wbr><wbr><wbr>privatefinal static String mTUserPhoto="UserPhoto";<br><wbr><wbr><wbr>finalprivate static String mCreateSqlForNoteClass="create table if notexists NoteClass(classId integer primary key ascautoincrement,className NVARCHAR(100),rowTime timestamp default(datetime('now', 'localtime')))";<br><wbr><wbr><wbr>finalprivate static String mCreateSqlForUserPhoto="create table if notexists UserPhoto(photoId integer primary key ascautoincrement,photoName VARCHAR(200),userPt VARCHAR(200),titleVARCHAR(255),classId integer,content NVARCHAR(250),tagNVARCHAR(200),remark text,status integer default 0,rowTimetimestamp default (datetime('now', 'localtime')))";<br><wbr><wbr><wbr>finalprivate static String[] mInsertSqlForNoteClass={"insert intoNoteClass(className) values('默认分类[私有]');","insert intoNoteClass(className) values('读书笔记[私有]');","insert intoNoteClass(className) values('电子资料[公开]');"};<br><wbr><wbr><wbr>privateDBHelper(Context context, CursorFactory factory) {<br><wbr><wbr><wbr><wbr><wbr><wbr>super(context, mDbName, factory,mDbVersion);<wbr><wbr><wbr><br><wbr><wbr><wbr>}<br><wbr><wbr><wbr><br><wbr><wbr><wbr>publicstatic DBHelper GetInstance(Context context,SQLiteDatabase.CursorFactory factory)<br><wbr><wbr><wbr>{<br><wbr><wbr><wbr><wbr><wbr><wbr>if(mInstance==null){<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>mInstance = newDBHelper(context,factory);<wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr>}<br><wbr><wbr><wbr><wbr><wbr><wbr>return mInstance;<br><wbr><wbr><wbr>}<br><br><wbr><wbr><wbr>@Override<br><wbr><wbr><wbr>public voidonCreate(SQLiteDatabase db) {<br><wbr><wbr><wbr><wbr><wbr><wbr>// 创建表<br><wbr><wbr><wbr><wbr><wbr><wbr>db.execSQL(mCreateSqlForNoteClass);<wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr>db.execSQL(mCreateSqlForUserPhoto);<br><wbr><wbr><wbr><wbr><wbr><wbr>//初始化数据<br><wbr><wbr><wbr><wbr><wbr><wbr>for(inti=0;i&lt;mInsertSqlForNoteClass.length;i++)<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>db.execSQL(mInsertSqlForNoteClass);<br><wbr><wbr><wbr>}<br><br><wbr><wbr><wbr>@Override<br><wbr><wbr><wbr>public voidonUpgrade(SQLiteDatabase db, int oldVersion, int newVersion){<br><wbr><wbr><wbr><wbr><wbr><wbr>// TODO Auto-generated method stub<br><br><wbr><wbr><wbr>}<br><wbr><wbr><wbr><br><wbr><wbr><wbr>privateCursor ExecSQLForCursor(String sql, String[] selectionArgs){<br><wbr><wbr><wbr><wbr><wbr><wbr>SQLiteDatabase db =getWritableDatabase();<br><wbr><wbr><wbr><wbr><wbr><wbr>Log.i("ExecSQLForCursor",sql);<br><wbr><wbr><wbr><wbr><wbr><wbr>return db.rawQuery(sql, selectionArgs);<br><wbr><wbr><wbr>}<br><wbr><wbr><wbr>private voidExecSQL(String sql){<br><wbr><wbr><wbr><wbr><wbr><wbr>try{<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>SQLiteDatabase db =getWritableDatabase();<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>ExecSQL(sql,db);<br><wbr><wbr><wbr><wbr><wbr><wbr>}catch(Exception e){<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>Log.e("ExecSQL Exception",e.getMessage());<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>e.printStackTrace();<br><wbr><wbr><wbr><wbr><wbr><wbr>}<br><wbr><wbr><wbr>}<br><wbr><wbr><wbr>private voidExecSQL(String sql,SQLiteDatabase db ){<br><wbr><wbr><wbr>try{<br><wbr><wbr><wbr><wbr><wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>