1,数据库SQLit操作
一、使用DB管理数据库:
二、使用SQLiteDatabase打开数据库:
SQLiteDatabase db = openOrCreateDatabase("res_download.db", MODE_PRIVATE, null);
db.execSQL("SQL语句"); //执行原生SQL语句
三、数据库的添删改查:
//插入数据
public void insertData(SQLiteDatabase db,String table,Article article){
ContentValues values = new ContentValues();
values.put("title",article.getTitle());
values.put("author", article.getAuthor());
db.insert(table, null, values);
}
//删除数据
public void deletData(SQLiteDatabase db,String table,Integer id){
db.delete(table, "_id=?", new String[]{id.toString()});
}
//根据id修改数据
public void updataData(SQLiteDatabase db,String table,Integer id,Article article){
ContentValues values = new ContentValues();
values.put("title",article.getTitle());
values.put("author", article.getAuthor());
db.update(table, values, "_id=?", new String[]{id.toString()});
}
//根据id查询数据库
public Article selectData(SQLiteDatabase db,String table,Integer id){
Cursor cursor = db.query(table,null, "_id=?", new String[]{id.toString()}, null, null, null);
if(cursor.moveToFirst()){
String title = cursor.getString(cursor.getColumnIndex("title"));
String author = cursor.getString(cursor.getColumnIndex("author"));
return new Article(title,author);
}
return null;
}
//查询数据库所有数据
public List
selectDatas(SQLiteDatabase db,String table){
List
articles = new ArrayList
();
Cursor cursor = db.query(table,null, null, null, null, null, null);
while(cursor.moveToNext()){
int id = cursor.getInt(cursor.getColumnIndex("_id"));
String title = cursor.getString(cursor.getColumnIndex("title"));
articles.add(new Article(id,title));
}
return articles;
}
-----------------------
著作权归作者所有。
商业转载请联系作者获得授权,非商业转载请注明出处。
作者:坤少博客
源地址:https://www.ksalde.asia/282.html
来源:坤少博客
© 版权声明:本文为博主原创文章,转载请务必保留原文链接!