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); }
