1.先创建数据库,数据表,写好属性和类型
2..在MyDao写入增删改查的方法;
3.将数据添加到数据库,根据集合的形式
4.删除数据库中的某一条'
public class MySql extends SQLiteOpenHelper {
public MySql(Context context, String name, CursorFactory factory, int version) { super(context, "nn.db", null, 1); }
@Override public void onCreate(SQLiteDatabase db) { db.execSQL("create table t_stu(t_id integer primary key autoincrement,t_title varchar(20),t_data varchar(20),t_auth varchar(20))"); }
@Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
2.在MyDao写入增删改查的方法;
public MyDao(Context context) { this.context = context; mySql = new MySql(context, "nn.db", null, 1); db = mySql.getWritableDatabase(); }
public Long insert(String table, String nullColumnHack, ContentValues values) { return db.insert(table, nullColumnHack, values); }
public int delete(String table, String whereClause, String[] whereArgs) { return db.delete(table, whereClause, whereArgs); }
public int update(String table, ContentValues values, String whereClause, String[] whereArgs) { return db.update(table, values, whereClause, whereArgs); }
public Cursor query(String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy){ return db.query(table, columns, selection, selectionArgs, groupBy, having, orderBy); } }
3.将数据添加到数据库,根据集合的形式
// 添加到数据库 for (int i = 0; i < list.size(); i++) { AA aa = list.get(i); ContentValues values = new ContentValues(); values.put("t_title", aa.getTitle()); values.put("t_data", aa.getDate()); values.put("t_auth", aa.getAuthor_name()); dao.insert("t_stu", null, values); }
4.删除数据库中的某一条'
// 删数据库中 dao.delete("t_stu", "t_title=?", new String[] { list.get(arg2).getTitle() });
