数据库Dao

package com.example.likai2018119zk3.sqlite;

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

public class MySqlite extends SQLiteOpenHelper {
public MySqlite(Context context) {
super(context, “lk”, null, 1);
}

@Override
public void onCreate(SQLiteDatabase db) {
    db.execSQL("create table news(id Integer primary key autoincrement,title text,content text)");
}

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

}

}

package com.example.likai2018119zk3.sqlite;

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

public class MySqlite extends SQLiteOpenHelper {
public MySqlite(Context context) {
super(context, “lk”, null, 1);
}

@Override
public void onCreate(SQLiteDatabase db) {
    db.execSQL("create table news(id Integer primary key autoincrement,title text,content text)");
}

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

}

}

package com.example.likai2018119zk3.sqlite;

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

import com.example.likai2018119zk3.bean.Mybean;

import java.util.List;

public class MyDao {
private MySqlite mySqlite;
private SQLiteDatabase mSqlData;

public MyDao(Context context) {
    mySqlite = new MySqlite(context);
    mSqlData = mySqlite.getWritableDatabase();
}


public long insert(List<Mybean.DataBean> list) {
    long num = 0;
    for (int i = 0; i < list.size(); i++) {
        Mybean.DataBean dataBean = list.get(i);
        ContentValues contentValues = new ContentValues();
        contentValues.put("title", dataBean.getNews_title());
        contentValues.put("content", dataBean.getNews_summary());
        mSqlData.insert("news", null, contentValues);
        num++;
    }
    return num;


}

public String select() {
    StringBuffer sb = new StringBuffer();
    Cursor cursor = mSqlData.query("news", null, null, null, null, null, null, null);
    while (cursor.moveToNext()) {
        String title = cursor.getString(cursor.getColumnIndex("title"));
        String content = cursor.getString(cursor.getColumnIndex("content"));
        sb.append(title).append(content);
    }
    return sb.toString();
}


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);
    mSqlData.update("news",contentValues,"id=?",new String[]{String.valueOf(id)});
}

}