使用sqliteDatabase操作sqlite数据库

使用sqliteOpenHelper对数据库进行版本管理

使用sqliteOpenHelper获取用于操作数据库的sqliteDatabase实例

使用事务操作sqlite数据库

使用sqliteDatabase的beginTransaction()方法可以开启一个事务，程序执行到endTransaction() 方法时会检查事务的标志是否为成功，如果为成功则提交事务，否则回滚事务。当应用需要提交事务，必须在程序执行到endTransaction()方法之 前使用setTransactionSuccessful() 方法设置事务的标志为成功，如果不调用setTransactionSuccessful() 方法，默认会回滚事务。使用例子如下： sqliteDatabase db = ....;

db.beginTransaction();//开始事务

try {

db.execsql("insert into person(name,4});

db.execsql("update person set name=? where personid=?",new Object[]{"传智",1});

db.setTransactionSuccessful();//调用此方法会在执行到endTransaction() 时提交当前事务，如果不调用此方法会回滚事务

} finally {

db.endTransaction();//由事务的标志决定是提交事务，还是回滚事务

}

db.close();

附: 个人课表的数据库

package com.android.course;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.sqliteDatabase;
import android.database.sqlite.sqliteOpenHelper;

public class Coursesql extends sqliteOpenHelper{
private static final String DB_NAME = "Curriculum.db";
private static final String TBL_NAME1 = "Course";
private static final String TBL_NAME2 = "CourseName";
private static final String TBL_NAME3= "CourseAddress";
private static final String CREATE_TBL1= " create table "
+ " Course(_id integer primary key autoincrement,WeekDay Text,CourseNum text," +
"CourseName text,CourseAddress text,CourseTeacher text) ";
private static final String CREATE_TBL2 = " create table "
+ " CourseName(_id integer primary key autoincrement,CourseName text) ";
private static final String CREATE_TBL3 = " create table "
+ " CourseAddress(_id integer primary key autoincrement,CourseAddress text) ";
private sqliteDatabase db;

public Coursesql(Context c) {
super(c,DB_NAME,2);
}

@Override //创建三个表
public void onCreate(sqliteDatabase db) {
this.db = db;
db.execsql(CREATE_TBL1);
db.execsql(CREATE_TBL2);
db.execsql(CREATE_TBL3);
}
public void onCreate(sqliteDatabase db,int num) {
this.db = db;
switch(num)
{
case 0:
db.execsql(CREATE_TBL1);
break;
case 1:
db.execsql(CREATE_TBL2);
break;
case 2:
db.execsql(CREATE_TBL3);
break;
}
}


//插入数据
public void insert(ContentValues values,int num) {
sqliteDatabase db = getWritableDatabase();
if(num ==0){
db.insert(TBL_NAME1,values);
}
else if(num == 1){
db.insert(TBL_NAME2,values);}
else if (num == 2){
db.insert(TBL_NAME3,values);
}
db.close();
}

//查询数据
public Cursor query(int num) {
sqliteDatabase db = getWritableDatabase();
Cursor c = null;
if(num ==0){
c = db.query(TBL_NAME1,null);
}
else if(num == 1){
c = db.query(TBL_NAME2,null);
}
else if(num == 2)
{
c = db.query(TBL_NAME3,null);
}
return c;
}
// 当天课表查询
public Cursor RawQuery(String Today)
{
sqliteDatabase db = getWritableDatabase();
String sql ="SELECT * FROM "+TBL_NAME1+" WHERE WeekDay=?";
Cursor c = db.rawQuery(sql,new String[]{Today});
return c;
}

// 根据_id 删除数据
public void del(int id,int num) {
if (db == null)
db = getWritableDatabase();
if(num == 0)
{
db.delete(TBL_NAME1,"_id=?",new String[] { String.valueOf(id) });}
else if(num ==1)
{
db.delete(TBL_NAME2,new String[] { String.valueOf(id) });
}
else if (num ==2)
{
db.delete(TBL_NAME3,new String[] { String.valueOf(id) });
}
}


//关闭数据库
public void close() {
if (db != null){
db.close();
}
}

//版本更新
public void Update(int num) {
sqliteDatabase db = getWritableDatabase();
switch(num)
{
case 0:
db.execsql("DROP TABLE IF EXISTS "+TBL_NAME1);
this.onCreate(db,num);
break;
case 1:
db.execsql("DROP TABLE IF EXISTS "+TBL_NAME2);
this.onCreate(db,num);
break;
case 2:
db.execsql("DROP TABLE IF EXISTS "+TBL_NAME3);
this.onCreate(db,num);
break;
}
}

　　/更新课程和课程地点 public void update(String CourseName,String CourseAddress,String Weekday,String CourseNum) { sqliteDatabase db = getWritableDatabase(); db.execsql( "update "+TBL_NAME1+" set CourseName=?,CourseAddress=? where WeekDay=? and CourseNum=?",new String[] {CourseName,CourseAddress,Weekday,CourseNum}); } @Override public void onUpgrade(sqliteDatabase db,int newVersion) { // TODO Auto-generated method stub } }