本文整理汇总了Java中com.lidroid.xutils.db.sqlite.WhereBuilder类的典型用法代码示例。如果您正苦于以下问题：Java WhereBuilder类的具体用法？Java WhereBuilder怎么用？Java WhereBuilder使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
WhereBuilder类属于com.lidroid.xutils.db.sqlite包，在下文中一共展示了WhereBuilder类的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: onClick
import com.lidroid.xutils.db.sqlite.WhereBuilder; //导入依赖的package包/类
@Click(value = { R.id.tv_delete, R.id.tv_cancel })
public void onClick(View v)
{
switch (v.getId())
{
case R.id.tv_delete:
switch (MSG)
{
case DELETE_BOOK_AND_FILE:
if (cb.isChecked()) FileKit.deleteFile(book.path);
case DELETE_BOOK:
db.delete(book);
db.delete(Toc.class, WhereBuilder.b("book_id", "=", book.id));
break;
case DELETE_FILE:
FileKit.deleteFile(file.path);
break;
}
break;
case R.id.tv_cancel:
break;
}
finish();
}
示例2: delUpload
import com.lidroid.xutils.db.sqlite.WhereBuilder; //导入依赖的package包/类
/**
* 删除上传信息
*
* @param uploadfilepath
* @return
*/
public boolean delUpload(String uploadfilepath) {
Selector selector = Selector.from(Upload.class);
selector.where(WhereBuilder.b("uploadfilepath", "=", uploadfilepath));
try {
Upload upload = db.findFirst(selector);
db.delete(upload);
} catch (DbException e) {
e.printStackTrace();
return false;
}
return true;
}
示例3: getBindId
import com.lidroid.xutils.db.sqlite.WhereBuilder; //导入依赖的package包/类
/**
* 获取上传资源Id
*
* @param uploadfilepath
* @return
*/
public String getBindId(String uploadfilepath) {
Selector selector = Selector.from(Upload.class);
selector.where(WhereBuilder.b("uploadfilepath", "=", uploadfilepath));
String bindId = "";
try {
Upload upload = db.findFirst(selector);
if (upload == null) {
return "";
}
bindId = upload.getSourceid();
} catch (DbException e) {
e.printStackTrace();
return "";
}
return bindId;
}
示例4: find
import com.lidroid.xutils.db.sqlite.WhereBuilder; //导入依赖的package包/类
@OnClick(R.id.db_find)
public void find(View view) {
try {
String temp = "";
// 查找全部
// List<Student> students = db.findAll(Student.class);
// for (Student student : students) {
// temp = temp + student.toString() + "\n";
// }
// 主键查找
// Student student = db.findById(Student.class, 10086);
// temp = student.toString();
//条件查找
List<Student> students = db.findAll(Selector.from(Student.class)
.where("name", "=", "李四")
.where(WhereBuilder.b("id", "=", 10010)).orderBy("name").limit(0).offset(10));
if (students == null) {
Toast.makeText(this.getActivity(), "没有数据请先添加数据", Toast.LENGTH_SHORT).show();
return;
}
for (Student student : students) {
temp = temp + student.toString() + "\n";
}
info.setText(temp);
} catch (DbException e) {
e.printStackTrace();
}
}
示例5: deleteAllChat
import com.lidroid.xutils.db.sqlite.WhereBuilder; //导入依赖的package包/类
public static void deleteAllChat(String aliasName) {
try {
db.delete(ChatHistory.class, WhereBuilder.b("sendAliasName", "=", aliasName).or("recvAliasName", "=", aliasName));
} catch (DbException e) {
Log.e(TAG, e.getMessage());
}
}
示例6: findChatHistory
import com.lidroid.xutils.db.sqlite.WhereBuilder; //导入依赖的package包/类
/**
* <p>Method ：findChatHistory
* <p>Description : 查询历史信息
*
* @param friendAliasName 好友别名
* @return
*/
public static List<ChatHistory> findChatHistory(String friendAliasName) {
//当前登陆人别名
String aliasName = getStringSharedPreferences(APPLICATION_CONTEXT, "IM", "aliasName", "");
try {
return db.findAll(Selector.from(ChatHistory.class)
.where("userAliasName", "=", aliasName)
.and(WhereBuilder.b("sendAliasName", "=", friendAliasName).or("recvAliasName", "=", friendAliasName)));
} catch (DbException e) {
Log.e(TAG, e.getMessage());
}
return null;
}
示例7: getDingOrCai
import com.lidroid.xutils.db.sqlite.WhereBuilder; //导入依赖的package包/类
/**
* 检查是否点过赞
* @param userId
* @param jokeId
* @return
*/
public DingOrCai getDingOrCai(int userId, int jokeId) {
DbUtils db = DbUtils.create(context);
DingOrCai dingOrCai = null;
try {
dingOrCai = db.findFirst(Selector.from(DingOrCai.class).where(WhereBuilder.b("user_id", "=", userId).and("joke_id", "=", jokeId)));
Log.d(TAG, "getDingOrCai success");
} catch (DbException e) {
Log.d(TAG, "getDingOrCai failure", e);
}
return dingOrCai;
}
示例8: getUnUpload
import com.lidroid.xutils.db.sqlite.WhereBuilder; //导入依赖的package包/类
/**
* 查找未同步到服务器的点赞数据
* @return
*/
public List<DingOrCai> getUnUpload() {
DbUtils db = DbUtils.create(context);
List<DingOrCai> dbModels = null;
try {
dbModels = db.findAll(Selector.from(DingOrCai.class).where(WhereBuilder.b("is_upload", "=", DingOrCai.NOT_UPLOAD)));
Log.d(TAG, "getUnUpload success");
} catch (DbException e) {
Log.d(TAG, "getUnUpload failure", e);
}
return dbModels;
}
示例9: getCollect
import com.lidroid.xutils.db.sqlite.WhereBuilder; //导入依赖的package包/类
/**
* 检查是否收藏过
* @param userId
* @param jokeId
* @return
*/
public Collect getCollect(int userId, int jokeId) {
DbUtils db = DbUtils.create(context);
Collect collect = null;
try {
collect = db.findFirst(Selector.from(Collect.class).where(WhereBuilder.b("user_id", "=", userId).and("joke_id", "=", jokeId)));
Log.d(TAG, "getDingOrCai success");
} catch (DbException e) {
Log.e(TAG, "getDingOrCai failure", e);
}
return collect;
}
示例10: cancelCollect
import com.lidroid.xutils.db.sqlite.WhereBuilder; //导入依赖的package包/类
/**
* 取消收藏
* @param jokeId
*/
public void cancelCollect(int jokeId) {
DbUtils db = DbUtils.create(context);
try {
db.delete(Collect.class, WhereBuilder.b("joke_id", "=", jokeId));
Log.d(TAG, "cancelCollect success");
} catch (DbException e) {
Log.e(TAG, "cancelCollect failure", e);
}
}
示例11: getCollects
import com.lidroid.xutils.db.sqlite.WhereBuilder; //导入依赖的package包/类
/**
* 获取我的收藏
* @param userId
* @return
*/
public List<Collect> getCollects(int userId) {
DbUtils db = DbUtils.create(context);
List<Collect> dbModels = null;
try {
dbModels = db.findAll(Selector.from(Collect.class).
where(WhereBuilder.b("user_id", "=", userId))
.orderBy("create_at", true));
Log.d(TAG, "getCollects success");
} catch (DbException e) {
Log.e(TAG, "getCollects failure", e);
}
return dbModels;
}
示例12: getDateFromDateBaseAndInitDate
import com.lidroid.xutils.db.sqlite.WhereBuilder; //导入依赖的package包/类
private void getDateFromDateBaseAndInitDate() {
String uid = spf.getString("Uid", "");
String did = device.getDid();
try {
scheduleDates.clear();
scheduleDates = dbUtils.findAll(
Selector.from(GosScheduleData.class).where("uid", "=", uid).and(WhereBuilder.b("did", "=", did)));
} catch (DbException e) {
e.printStackTrace();
}
for (GosScheduleData i : scheduleDates) {
i.setViewContent();
}
}
示例13: deletBookMark
import com.lidroid.xutils.db.sqlite.WhereBuilder; //导入依赖的package包/类
/**
* 删除书签
*
* @param bookMarko
*/
public void deletBookMark(String bookName,String bookId) {
try {
db.delete(BookMark.class, WhereBuilder.b("bookName", "=", bookName).and("bookId", "=", bookId));
} catch (DbException e) {
// TODO Auto-generated catch block
MyLogger.kLog().e(e);
}
}
示例14: hourAvera
import com.lidroid.xutils.db.sqlite.WhereBuilder; //导入依赖的package包/类
/**
* 从数据库中查询某个小时检查的平均值
*
* @param lastDay
* @param today
* @param tvbiJiao
*/
private float hourAvera(String today, String hour) {
java.text.DecimalFormat df = new java.text.DecimalFormat("#0.0");
DbUtils db = DbUtils.create(getActivity());
List<BltModel> blts;
float averageWater = 0;
WhereBuilder builder = WhereBuilder.b("date", "==", today)
.and("hour", "==", hour).and("modelstate", "==", checkType);
try {
blts = db.findAll(Selector.from(BltModel.class).where(builder));
if (blts != null) {
int totalWater = 0;
for (int i = 0; i < blts.size(); i++) {
totalWater = totalWater
+ Integer.parseInt(blts.get(i).getWater());
}
if (blts.size() > 0) {
averageWater = totalWater / blts.size();
averageWater = Float.parseFloat(df
.format(averageWater / 45.0f + 20.0));
}
}
} catch (DbException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
return 0;
}
return averageWater;
}
示例15: dayAvera
import com.lidroid.xutils.db.sqlite.WhereBuilder; //导入依赖的package包/类
/**
* 从数据库中查询某天检查的平均值
*
* @param lastDay
* @param today
* @param tvbiJiao
*/
private Average dayAvera(String day) {
Average average = new Average();
java.text.DecimalFormat df = new java.text.DecimalFormat("#0.0");
DbUtils db = DbUtils.create(getActivity());
List<BltModel> blts;
float averageWater = 0;
WhereBuilder builder = WhereBuilder.b("date", "==", day).and(
"modelstate", "==", checkType);
try {
blts = db.findAll(Selector.from(BltModel.class).where(builder));
if (blts != null) {
int totalWater = 0;
for (int i = 0; i < blts.size(); i++) {
totalWater = totalWater
+ Integer.parseInt(blts.get(i).getWater());
}
if (blts.size() > 0) {
averageWater = totalWater / blts.size();
average.setCount(blts.size());
averageWater = Float.parseFloat(df
.format(averageWater / 45.0f + 20.0));
average.setAverage(averageWater);
}
}
} catch (DbException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
return average;
}
return average;
}