android sqlite 增删改[insert、up…

本文深入探讨了数据库管理系统的设计原则和优化策略,包括数据模型选择、索引理论应用、事务管理优化等方面,旨在提高数据库系统的性能和效率。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

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>final private static String mDbName="imgfornote";<br><wbr><wbr><wbr>final private static int mDbVersion=1;<br><wbr><wbr><wbr>private static DBHelper mInstance=null;<br><wbr><wbr><wbr>private final static String mTUserPhoto="UserPhoto";<br><wbr><wbr><wbr>final private static String mCreateSqlForNoteClass="create table if not exists NoteClass(classId integer primary key asc autoincrement,className NVARCHAR(100),rowTime timestamp default (datetime('now', 'localtime')))";<br><wbr><wbr><wbr>final private static 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,rowTime timestamp default (datetime('now', 'localtime')))";<br><wbr><wbr><wbr>final private static String[] mInsertSqlForNoteClass={"insert into NoteClass(className) values('默认分类[私有]');","insert into NoteClass(className) values('读书笔记[私有]');","insert into NoteClass(className) values('电子资料[公开]');"};<br><wbr><wbr><wbr>private DBHelper(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>public static 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 = new DBHelper(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 void onCreate(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(int i=0;i&lt;mInsertSqlForNoteClass.length;i++)<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>db.execSQL(mInsertSqlForNoteClass[i]);<br><wbr><wbr><wbr>}<br><br><wbr><wbr><wbr>@Override<br><wbr><wbr><wbr>public void onUpgrade(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>private Cursor 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 void ExecSQL(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 void ExecSQL(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>
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值