SQLite数据库简单的增删改查

MyHelper：

	public class MyHelper extends SQLiteOpenHelper {
	    public MyHelper(Context context) {
	        super(context, "week3", null, 1);
	    }
	
	    @Override
	    public void onCreate(SQLiteDatabase db) {
	        String sql = "create table news(id integer,title text,content text)";
	        db.execSQL(sql);
	    }
	
	    @Override
	    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
	
	    }
    }

Dao层：

public class Dao {

	    private SQLiteDatabase database;
	
	    public Dao(Context context) {
	        MyHelper helper = new MyHelper(context);
	        database = helper.getWritableDatabase();
	    }
	
	    public List<NewsBean.DataBean> cha(){
	        List<NewsBean.DataBean> list = new ArrayList<>();
	        Cursor cursor = database.query("news", null, null, null, null, null, null);
	        while (cursor.moveToNext()){
	            NewsBean.DataBean newsBean = new NewsBean.DataBean();
	            String news_id = cursor.getString(cursor.getColumnIndex("news_id"));
	            String news_summary = cursor.getString(cursor.getColumnIndex("news_summary"));
	            String news_title = cursor.getString(cursor.getColumnIndex("news_title"));
	            newsBean.setNews_id(news_id);
	            newsBean.setNews_summary(news_summary);
	            newsBean.setNews_title(news_title);
	            list.add(newsBean);
	        }
	        return list;
	    }
	
	    //添加
	    public void add(List<NewsBean.DataBean> list){
	        for (int i=0;i<list.size();i++){
	            ContentValues values = new ContentValues();
	            values.put("news_id",list.get(i).getNews_id());
	            values.put("news_summary",list.get(i).getNews_summary());
	            values.put("news_title",list.get(i).getNews_title());
	            database.insert("news", null, values);
	        }
	    }
	    
	    //删除
	    public void delete(int id){
	        mSqlData.delete("news","id=?",new String[]{String.valueOf(id)});
	    }
	    
	    //修改
	    public void update(int id,String title,String content){
	        ContentValues contentValues = new ContentValues();
	        contentValues.put("title",title);
	        contentValues.put("content",content);
        }
	}

解析完成之后调用Dao层的add添加方法，添加到数据库，然后调用cha方法，赋值即可