使用nutz进行复杂的数据库操作

一、Cnd类
1、Cnd.wrap(sql语句，参数)

Cnd.wrap("uname like '%ang%' and uage=20",null)

2、Cnd.where

Cnd.where("id","=","1");ExpGroup group1 = Cnd.exps("uname", "LIKE", "%y").and("uage", ">", "11");ExpGroup group2 = Cnd.exps("uname", "LIKE", "%c%").and("uage", "<", "30");Cnd.where(group1).or(group2);Cnd.where("age",">",30).and("name", "LIKE", "%K%").asc("name").desc("id")

3、Criteria

// 创建一个 Criteria 接口实例Criteria cri = Cnd.cri();// 组装条件if(...){    cri.where().andIn("id", 3,4,5).andIn("name", "Peter", "Wendal", "Juqkai");}else if(...){    cri.where().andLT("id", 9);}if(...){    cri.where().andLike("name", "%A%");}cri.getOrderBy().asc("name").desc("id");// 执行查询List<MyObj> list = dao.query(MyObj.class, cri, null);