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