1.想要创建数据库首先要写一个类,继承SQLiteOpenHelper这个类
public class shujuku extends SQLiteOpenHelper {
//创建数据库的方法
public shujuku(Context context, String name, CursorFactory factory, int version) {
super(context, name, factory, version);
// TODO Auto-generated constructor stub
}
//数据库创建时调用的方法
@Override
public void onCreate(SQLiteDatabase db) {
//创建表
db.execSQL("create table soin(" +
"_id integer primary key autoincrement," +
"name char(10)," +
"phone char(20)," +
"salary integer(10)" +
");");
System.out.println("数据创建!");
}
//数据库升级时调用的方法
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
System.out.println("数据升级!");
}
}