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