SQLiteOpenHelper添加

1.新建一个类,继承SQLiteOpenHelper
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, “bw.db”, null, 1);
}

@Override
public void onCreate(SQLiteDatabase db) {
    db.execSQL("create table student(id INTEGER PRIMARY KEY AUTOINCREMENT,author_name varchar(40))");
}

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

}

}

2.重写dao层
import android.content.ContentValues;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;

public class SQLDao {

private Context context;
private SQLiteDatabase db;

public SQLDao(Context context) {
    this.context = context;
    MySqlite sqlite = new MySqlite(context);
    db = sqlite.getReadableDatabase();
}

public long insert(String table, String nullColumnHack, ContentValues values){
    return db.insert(table,nullColumnHack,values);
}

}

3.实例化daoceng
SQLDao mDao = new SQLDao(getActivity());

4.添加
for (int i = 0;i<list.size();i++){
Toast.makeText(getActivity(),""+i,Toast.LENGTH_SHORT).show();
ContentValues contentValues = new ContentValues();
contentValues.put(“author_name”,list.get(i).getAuthor_name());
mDao.insert(“student”,null,contentValues);
}