<span style="font-family:SimSun;font-size:18px;">package com.example.login;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
public class DBHelper extends SQLiteOpenHelper {
private static final String DATABASE_NAME = "mydb.db";
private static final int VERSION = 1;
private static final String CREATE_SQL = "create table if not exists Users"+
"(id int primary key,name,password)";
private static final String DELETE_SQL = "drop table if exists Users;";
public DBHelper(Context context) {
super(context, DATABASE_NAME, null, VERSION);
// TODO Auto-generated constructor stub
}
@Override
public void onCreate(SQLiteDatabase arg0) {
// TODO Auto-generated method stub
arg0.execSQL(CREATE_SQL);
}
@Override
public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
// TODO Auto-generated method stub
arg0.execSQL(DELETE_SQL);
arg0.execSQL(CREATE_SQL);
}
}</span>
android SQLite SQLiteOpenHelper
最新推荐文章于 2024-04-04 14:25:56 发布