zhou-hao e67ff3257b 3.1.0 hace 5 años
..
src e67ff3257b 3.1.0 hace 5 años
README.md d71ac57048 优化文档 hace 7 años
pom.xml e67ff3257b 3.1.0 hace 5 años

README.md

通用服务类

提供通用增删改查服务

DSL查改删

查询,实现DefaultDSLQueryService接口

    // select * from user where name = ? limit 0,1
   createQuery().where("name","张三").single();
    // select * from user where name = ? or name = ?
   createQuery().where("name","张三").or().is("name","李四").list();
    //select * from user where name = ? and (age> ? and age <?)
   createQuery().where("name","张三").nest().gt("age",10).or().lt("age",20).end().list();

修改,实现DefaultDSLUpdateService接口

    // update user set ... where name = ?
   createUpdate(data).where("name","张三").exec();
    //不会修改为null的属性,
    // update user set name=?,age=? where name = ?
   createUpdate(data).include("name","age").where("name","张三").exec();
    // update user set name=? where name = ?
   createUpdate().set("name","新张三").where("name","张三").exec();

删除,实现DefaultDSLDeleteService接口

//delete from user where name = ?
createDelete().where("name","张三").exec();

查改删,条件使用的方式都相同.