import android.annotation.SuppressLint;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;
public class MySqliteHelper extends SQLiteOpenHelper{
//数据库名称
private static String NAME = "info.db";
//数据库版本
private static int VERSION = 1;
/**
*
* @param context: 上下文对象
* @param name: 数据库名称
* @param factory: 游标工厂
* @param version: 数据库版本
*/
public MySqliteHelper(Context context, String name, CursorFactory factory,
int version) {
super(context, name, factory, version);
// TODO Auto-generated constructor stub
}
public MySqliteHelper(Context context){
super(context, NAME, null, VERSION);
// TODO Auto-generated constructor stub
}
/**
* 数据库第一次创建时 回调此方法
*/
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
String sql = "create table person(_id integer primary key,name varchar(16),age integer)";
//执行数据库语句
db.execSQL(sql);
}
/**
* 数据库版本发生改变时 调用newVersion > oldVersion 数据库版本升级
*/
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
if (newVersion > oldVersion) {
Log.i("==onUpgrade==","数据库版本升级");
}
}
/**
* 数据库版本发生改变时 调用oldVersion > newVersion 数据库版本降级
*
* 只有发生重大错误时 才调用此方法
*/
@Override
public void onDowngrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
super.onDowngrade(db, oldVersion, newVersion);
if (oldVersion > newVersion) {
Log.i("==onDowngrade==","数据库版本降级");
}
}
/**
* 每次打开数据库
*/
private void onpen() {
// TODO Auto-generated method stub
Log.i("==onpen==","数据库打开");
}
}
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;
public class MySqliteHelper extends SQLiteOpenHelper{
//数据库名称
private static String NAME = "info.db";
//数据库版本
private static int VERSION = 1;
/**
*
* @param context: 上下文对象
* @param name: 数据库名称
* @param factory: 游标工厂
* @param version: 数据库版本
*/
public MySqliteHelper(Context context, String name, CursorFactory factory,
int version) {
super(context, name, factory, version);
// TODO Auto-generated constructor stub
}
public MySqliteHelper(Context context){
super(context, NAME, null, VERSION);
// TODO Auto-generated constructor stub
}
/**
* 数据库第一次创建时 回调此方法
*/
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
String sql = "create table person(_id integer primary key,name varchar(16),age integer)";
//执行数据库语句
db.execSQL(sql);
}
/**
* 数据库版本发生改变时 调用newVersion > oldVersion 数据库版本升级
*/
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
if (newVersion > oldVersion) {
Log.i("==onUpgrade==","数据库版本升级");
}
}
/**
* 数据库版本发生改变时 调用oldVersion > newVersion 数据库版本降级
*
* 只有发生重大错误时 才调用此方法
*/
@Override
public void onDowngrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
super.onDowngrade(db, oldVersion, newVersion);
if (oldVersion > newVersion) {
Log.i("==onDowngrade==","数据库版本降级");
}
}
/**
* 每次打开数据库
*/
private void onpen() {
// TODO Auto-generated method stub
Log.i("==onpen==","数据库打开");
}
}