sqlite
来源:互联网 发布:java环境搭建教程 编辑:程序博客网 时间:2024/06/03 19:01
Dao类
public class MySQLIDao {
private final MySQLite mySQLite;
private Cursor cursor;
public MySQLIDao(Context context) {
mySQLite = new MySQLite(context);
}
//添加方法
public void add(DataBean dataBean){
SQLiteDatabase db = mySQLite.getWritableDatabase();
ContentValues values=new ContentValues();
values.put("title",dataBean.getTitle());
values.put("address",dataBean.getAddress());
values.put("price",dataBean.getPrice());
values.put("pricebask",dataBean.getPriceback());
values.put("tags",dataBean.getTags());
values.put("img",dataBean.getImg());
db.insert("yuekao",null,values);
db.close();
}
//查询
public List<DataBean> query(){
List<DataBean> list=new ArrayList<>();
SQLiteDatabase db = mySQLite.getWritableDatabase();
Cursor cursor = db.query("yuekao", null, null, null, null, null, null);
while (cursor.moveToNext())
{
String title=cursor.getString(cursor.getColumnIndex("title"));
String address=cursor.getString(cursor.getColumnIndex("address"));
int price=cursor.getInt(cursor.getColumnIndex("price"));
String pricebask=cursor.getString(cursor.getColumnIndex("pricebask"));
String tags=cursor.getString(cursor.getColumnIndex("tags"));
String img=cursor.getString(cursor.getColumnIndex("img"));
list.add(new DataBean(title,address,price,pricebask,tags,img));
}
return list;
}
//模糊查询,并排序
public List<DataBean> queryorder(int id,String pricabask){
List<DataBean> list=new ArrayList<>();
SQLiteDatabase db = mySQLite.getWritableDatabase();
String sql;
if(id==0)
{
//升序
sql="select * from yuekao where pricebask like '%"+pricabask+"%' order by price asc";
}else
{
//降序
sql="select * from yuekao where pricebask like '%"+pricabask+"%' order by price desc";
}
Cursor cursor = db.rawQuery(sql, null);
while (cursor.moveToNext())
{
String title= cursor.getString(cursor.getColumnIndex("title"));
String address= cursor.getString(cursor.getColumnIndex("address"));
int price= cursor.getInt(cursor.getColumnIndex("price"));
String pricebask= cursor.getString(cursor.getColumnIndex("pricebask"));
String tags= cursor.getString(cursor.getColumnIndex("tags"));
String img= cursor.getString(cursor.getColumnIndex("img"));
list.add(new DataBean(title,address,price,pricebask,tags,img));
}
return list;
}
}
- SQLite
- SQLite
- SQLite
- SQLite
- SQLite
- sqlite
- sqlite
- SQLite
- SQLite
- sqlite
- SQLite
- SQLite
- SQLite
- SQLite
- SQLite
- sqlite
- sqlite
- sqlite
- 2017-09-22 关于C++获取网页的一些心得
- 图片二次采样
- PTA 求链式线性表的倒数第K项(C语言实现)
- bzoj1264: [AHOI2006]基因匹配Match
- js serialize()
- sqlite
- asp.net---网站的动态交互
- Gym
- python字典保持有序
- xmc4300 ethercat 学习之路
- 区块链风暴来袭,这五大行业将受到强烈冲击
- 每日区块链:Raiden发布新产品:以太坊测试网将出现更简单的微支付;澳大利亚证券投资委员会也许运行区块链监管节点
- xlistview的判断
- Java简单类、变量详解(概念和分类、声明、命名、初始化)