数据库

最新推荐文章于 2022-04-28 14:08:50 发布

wangshuai_97

最新推荐文章于 2022-04-28 14:08:50 发布

阅读量174

点赞数

本文链接：https://blog.csdn.net/wangshuai_97/article/details/83719273

版权

SQLit

package com.bawei.www.wangshuai11_19;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

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

    @Override
    public void onCreate(SQLiteDatabase db) {
        //创建表
        db.execSQL("create table news(id integer primary key autoincrement," +
                "title text," +
                "summery text)");
    }

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

    }
}

Dao

package com.bawei.www.wangshuai11_19;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

import com.bawei.www.wangshuai11_19.Bean.NewsResponse;

import java.util.ArrayList;
import java.util.List;

public class Dao {

    private static Dao intance;
    private final SQLiteDatabase sqLiteDatabase;

    public Dao(Context context){
        SqliteHelper sqliteHelper = new SqliteHelper(context);
        sqLiteDatabase = sqliteHelper.getReadableDatabase();
    }

    public static Dao getIntance(Context context){
        if(intance==null){
            intance = new Dao(context);
        }
        return intance;
    }

    public ArrayList<NewsResponse.DataBean> query(){
        Cursor cursor = sqLiteDatabase.rawQuery("select * from news",null);
        ArrayList<NewsResponse.DataBean> nd = new ArrayList<>();
        while (cursor.moveToNext()) {
            String title = cursor.getString(cursor.getColumnIndex("title"));
            String summery = cursor.getString(cursor.getColumnIndex("summery"));
            NewsResponse.DataBean dataBean = new NewsResponse.DataBean(title,summery);
            nd.add(dataBean);
        }
        return nd;
    }

    public void add(List<NewsResponse.DataBean> data) {
        for (int i = 0;i< data.size();i++){
            String title= data.get(i).getNews_title();
            String summery =data.get(i).getNews_summary();
            sqLiteDatabase.execSQL("insert into news(title,summery) values(?,?)",new String[]{title,summery});
        }
    }

}