主要分为两部分:
数据库部分和Fragment部分
数据库部分:
DbHelper.java:
public class DbHelper extends SQLiteOpenHelper {
public String TB_NAME="friends";
public DbHelper(@Nullable Context context, @Nullable String name, @Nullable SQLiteDatabase.CursorFactory factory, int version) {
super(context, name, factory, version);
}
@Override
public void onCreate(SQLiteDatabase sqLiteDatabase) {
sqLiteDatabase.execSQL("CREATE TABLE IF NOT EXISTS " +
TB_NAME + "( f_id integer primary key autoincrement," +
"f_name varchar" + ")");
}
@Override
public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {
sqLiteDatabase.execSQL("DROP TABLE IF EXISTS " + TB_NAME);
onCreate(sqLiteDatabase);
}
}
MYDAO.java:
public class MYDAO {
private SQLiteDatabase mydb;
private DbHelper dbhelper;
public MYDAO(Context context) {
//构造方法,参数为上下文对象
//第1参数为上下文,第2参数为数据库名
dbhelper = new DbHelper(context,"test.db",null,1);
}
public Cursor AllQuerry(String tablename){
mydb=dbhelper.getReadableDatabase();
return mydb.rawQuery("select * from "+tablename,null);
}
public int getRecordsNumber(String tablename){
//返回数据表记录数
mydb = dbhelper.getReadableDatabase();
Cursor cursor= mydb.rawQuery("select * from "+tablename,null);
return cursor.getCount();
}
public void insertInfo(String name,String tablename){
//插入记录
mydb = dbhelper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("f_name", name);
long rowid