此篇文章只写java文件不写Android控件了
首先创建一个专门写数据库的文件,使其继承SQLiteOpenHelper类
这里书写建库建表语句
package com.example.day02;
import android.content.ContentValues;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
public class MyDbHelper extends SQLiteOpenHelper {
public MyDbHelper(Context context, String name, CursorFactory factory,
int version) {
super(context, "RoleDB.db", null, 2);
// 创建数据库
}
}
@Override
public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
// TODO Auto-generated method stub
}
}
重写onCreate类(建表语句)
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
// 建表
db.execSQL("create table RoleDB(RoleID integer primary key autoincrement,RoleName varchar(64)"
+ ",RoleLevel int,RoleArea varchar(64))");
// 插入数据
ContentValues cv1 = new ContentValues();
cv1.put("RoleName", "农夫三拳有点疼");
cv1.put("RoleLevel", "75