数据库增加查询
来源:互联网 发布:php怎么写爬虫 编辑:程序博客网 时间:2024/05/21 10:07
private Context context;
private MyHelper myHelper;
public Dao(Context context) {
super();
this.context = context;
myHelper = new MyHelper(context);
}
public void insert(Bean be) {
SQLiteDatabase db = myHelper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("id", be.getId());
values.put("portrait", be.getPortrait());
values.put("author", be.getAuthor());
values.put("body", be.getBody());
values.put("pubDate", be.getPubDate());
values.put("imgSmall", be.getImgSmall());
db.insert("user", null, values);
}
public List<Bean> sel() {
List<Bean> list = new ArrayList<Bean>();
SQLiteDatabase db = myHelper.getReadableDatabase();
Cursor cursor = db.query("user", null, null, null, null, null, null);
while (cursor.moveToNext()) {
String id = cursor.getString(cursor.getColumnIndex("id"));
String author = cursor.getString(cursor.getColumnIndex("author"));
String portrait = cursor.getString(cursor
.getColumnIndex("portrait"));
String body = cursor.getString(cursor.getColumnIndex("body"));
String pubDate = cursor.getString(cursor.getColumnIndex("pubDate"));
String imgSmall = cursor.getString(cursor
.getColumnIndex("imgSmall"));
list.add(new Bean(id, portrait, author, body, pubDate, imgSmall));
}
return list;
}
}
private MyHelper myHelper;
public Dao(Context context) {
super();
this.context = context;
myHelper = new MyHelper(context);
}
public void insert(Bean be) {
SQLiteDatabase db = myHelper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("id", be.getId());
values.put("portrait", be.getPortrait());
values.put("author", be.getAuthor());
values.put("body", be.getBody());
values.put("pubDate", be.getPubDate());
values.put("imgSmall", be.getImgSmall());
db.insert("user", null, values);
}
public List<Bean> sel() {
List<Bean> list = new ArrayList<Bean>();
SQLiteDatabase db = myHelper.getReadableDatabase();
Cursor cursor = db.query("user", null, null, null, null, null, null);
while (cursor.moveToNext()) {
String id = cursor.getString(cursor.getColumnIndex("id"));
String author = cursor.getString(cursor.getColumnIndex("author"));
String portrait = cursor.getString(cursor
.getColumnIndex("portrait"));
String body = cursor.getString(cursor.getColumnIndex("body"));
String pubDate = cursor.getString(cursor.getColumnIndex("pubDate"));
String imgSmall = cursor.getString(cursor
.getColumnIndex("imgSmall"));
list.add(new Bean(id, portrait, author, body, pubDate, imgSmall));
}
return list;
}
}
0 0
- 数据库增加查询
- 数据库查询增加一列 序号
- 各类数据库查询自动增加序号
- VB6.0对数据库的增加 删除 查询(入门级别)
- 连接数据库 增加 删除 查询 修改 (swing中)
- 查询数据库没有主键的表名,并增加主键
- C#中winform对sql数据库的查询,删除,增加.
- MySql数据库 sql查询增加序号的伪列
- MySql数据库 sql查询增加序号的伪列
- Yii 1.0数据库操作 查询、增加、更新、删除
- Yii 1.0数据库操作 查询、增加、更新、删除(事务处理)
- Yii 1.0数据库操作 查询、增加、更新、删除
- Hibernate的基本操作数据库,增加,修改,删除,查询
- MySql数据库 sql查询增加序号的伪列
- MySql数据库的查询、删除、增加、修改语句
- 增加与查询备注
- SQLite 创建 查询 增加
- Linq查询 待增加
- MySQL单表百万数据记录分页性能优化
- Java学习日记【29至37总结】
- 【English】前行
- inode的理解
- Xml的解析
- 数据库增加查询
- Sum of Left Leaves
- ACM练习----1089
- 有符号byte范围如何计算?
- GCD编程dispatch_sync(同步)和dispatch_async(异步)方式执行并发队列任务区别
- android fragment中一些常见问题
- 测试怎样拿高工资(1)
- memcache、邮箱
- Decode String