Android 创建DBHelper类

来源:互联网 发布:数据库份额 编辑:程序博客网 时间:2024/06/07 03:38
public class DBHelper extends SQLiteOpenHelper {    private static int mVersion = 1;    private static String name = "apps.db";    public DBHelper(Context context) {        super(context, name, null, mVersion);    }    @Override    public void onCreate(SQLiteDatabase db) {        String sql = "create table book(_id int primary key autoincrememt, name varchar(32) ,price double , publishtime date)";        db.execSQL(sql);    }    @Override    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {        String sql = "DROP TABLE IF EXISTS book";        db.execSQL(sql);        this.onCreate(db);    }}
0 0
原创粉丝点击