use of com.lidroid.xutils.view.annotation.event.OnClick in project xUtils by wyouflf.
the class DbFragment method testDb.
@OnClick(R.id.db_test_btn)
public void testDb(View view) {
String temp = "";
Parent parent = new Parent();
parent.name = "测试" + System.currentTimeMillis();
parent.setAdmin(true);
parent.setEmail("wyouflf@gmail.com");
try {
//DbUtils db = DbUtils.create(this.getActivity(), "/sdcard/", "test.db");
DbUtils db = DbUtils.create(this.getActivity());
db.configAllowTransaction(true);
db.configDebug(true);
Child child = new Child();
child.name = "child' name";
//db.saveBindingId(parent);
//child.parent = new ForeignLazyLoader<Parent>(Child.class, "parentId", parent.getId());
//child.parent = parent;
Parent test = db.findFirst(Selector.from(Parent.class).where("id", "in", new int[] { 1, 3, 6 }));
//Parent test = db.findFirst(Selector.from(Parent.class).where("id", "between", new String[]{"1", "5"}));
if (test != null) {
child.parent = test;
temp += "first parent:" + test + "\n";
resultText.setText(temp);
} else {
child.parent = parent;
}
parent.setTime(new Date());
parent.setDate(new java.sql.Date(new Date().getTime()));
//保存对象关联数据库生成的id
db.saveBindingId(child);
//.where(WhereBuilder.b("name", "=", "child' name")));
List<Child> children = db.findAll(Selector.from(Child.class));
temp += "children size:" + children.size() + "\n";
resultText.setText(temp);
if (children.size() > 0) {
temp += "last children:" + children.get(children.size() - 1) + "\n";
resultText.setText(temp);
}
Calendar calendar = Calendar.getInstance();
calendar.add(Calendar.DATE, -1);
calendar.add(Calendar.HOUR, 3);
List<Parent> list = db.findAll(Selector.from(Parent.class).where("id", "<", 54).and("time", ">", calendar.getTime()).orderBy("id").limit(10));
temp += "find parent size:" + list.size() + "\n";
resultText.setText(temp);
if (list.size() > 0) {
temp += "last parent:" + list.get(list.size() - 1) + "\n";
resultText.setText(temp);
}
//parent.name = "hahaha123";
//db.update(parent);
Parent entity = db.findById(Parent.class, child.parent.getId());
temp += "find by id:" + entity.toString() + "\n";
resultText.setText(temp);
List<DbModel> dbModels = db.findDbModelAll(Selector.from(Parent.class).groupBy("name").select("name", "count(name) as count"));
temp += "group by result:" + dbModels.get(0).getDataMap() + "\n";
resultText.setText(temp);
} catch (DbException e) {
temp += "error :" + e.getMessage() + "\n";
resultText.setText(temp);
}
}
use of com.lidroid.xutils.view.annotation.event.OnClick in project xUtils by wyouflf.
the class HttpFragment method downloadPage.
@OnClick(R.id.download_page_btn)
public void downloadPage(View view) {
Intent intent = new Intent(this.getActivity(), DownloadListActivity.class);
this.getActivity().startActivity(intent);
}
Aggregations