结构分析:
一:新建数据库帮助类StudentHelper.class
public class StudentHelper extends SQLiteOpenHelper {
public StudentHelper(Context context) {
super(context, "student",null,1);
// TODO Auto-generated constructor stub
}
@Override
public void onCreate(SQLiteDatabase sqLiteDatabase) {
// TODO Auto-generated method stub
sqLiteDatabase.execSQL("create table students (_id integer primary key autoincrement,name varchar(30),number varchar(20),sex varchar(6))");
}
@Override
public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
// TODO Auto-generated method stub
}
}
注意点:
1、创建类的时候注意继承sqliteopenhelper
2、自动创建的默认构造函数中的参数只需要Context context即可
3.onCreate方法只会在第一次程序运行时执行,重复执行需要在虚拟机中清空数据并强制停止再重新运行
二:新建数据库DAO
public class StudentDAO {
private StudentHelper studentHelper;
public StudentDAO(Context context) {
studentHelper=new StudentHelper(context);
}
//增加操作
public void add(String name,String number,String sex) {
SQLiteDatabase sqLiteDatabase=studentHelper.getWritableDatabase();
sqLiteDatabase.execSQL("insert in