Android 数据库操作

核心提示：package com.android.pvs;import android.content.Context;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;import android.database.sqli

package com.android.pvs;

import android.content.Context;

import android.database.Cursor;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteOpenHelper;

/**

* 采用数据库进行辅助开发

*/

public class MyDataBase extends SQLiteOpenHelper {

private static final String my_database = "pvs_table";

public MyDataBase(Context context) {

super(context, my_database, null, 1);

}

//Called when the database is created for the first time

public void onCreate(SQLiteDatabase db) {

String sql = "create table pvs_sql" +

"(" +

"name text," +//创建name字段

"type INTEGER," +//类型:图片或者视频类型(0:图片;1:视频)

"jingdu INTEGER," +//经度

"weidu INTEGER," +//纬度

"address text,"+//拍照的地址

"time text," +//时间

// "hashold INTEGER," +//是否已经上传过(0:没有上传过 1:已经上传过))

// "holdProgress INTEGER," +//上传的进度百分比

"holdFile text" +//上传目录,没有上传为""

");"

;

db.execSQL(sql);//执行sql指令创建表

}

public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

}

/**

* 执行一条SQL指令

*/

public void execSQL(String sql){

this.getWritableDatabase().execSQL(sql);

}

/**

* 根据指定返回游标

*/

public Cursor getCursor(String sql){

return this.getWritableDatabase().rawQuery(sql, null);

}

/**

* 关闭数据库

*/

public void closeDataBase(){

this.close();

}

/**

* 删除数据库

*/

public void delete(){

}

}