Sqlite数据库

创建Sqlite库

public class MySqlit extends SQLiteOpenHelper {
    public MySqlit(Context context) {
        super(context,"User.db",null,1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("create table user(aid text,title text,description text)");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }
}

Sqlite库的工具包 增删查改

public class UserDao {
    private MySqlit mySqlit;
    public UserDao(Context context){
     mySqlit=new MySqlit(context);
    }
    public void add(String aid,String title,String description){
        SQLiteDatabase database = mySqlit.getReadableDatabase();
        database.execSQL("insert into user(aid,title,description) values(?,?,?)",
                new String[]{aid,title,description});
        database.close();
        Log.d("pppppppppppppp",database.toString());
    }
    public List<User> select(){
        List<User> list = new ArrayList<>();
        SQLiteDatabase database = mySqlit.getReadableDatabase();
        Cursor cursor = database.rawQuery("select * from user",
                new String[]{});
        while(cursor.moveToNext()){
            String aid = cursor.getString(cursor.getColumnIndex("aid"));
            String title = cursor.getString(cursor.getColumnIndex("title"));
            String description = cursor.getString(cursor.getColumnIndex("description"));
            User user = new User(aid, title, description);
            list.add(user);
        }
        return list;
    }
}

调用Sqlite库的方法

userDao=new UserDao(getActivity());
for (int i = 0; i < articles.size(); i++) {
    aid = articles.get(i).getAid();
    title = articles.get(i).getTitle();
    description = articles.get(i).getDescription();
    userDao.add(aid,title,description);
}