grails 常用查询
来源:互联网 发布:csol租号软件 编辑:程序博客网 时间:2024/05/21 19:44
hql查询
1.查询记录个数
String hql = "select count(1) from User where username like :username" long count = (Long) User.executeQuery(hql, [username: "%${username}%"]).get(0)
2.查询id集合
def hql = "select id from User where username like :username" def ids = User.executeQuery(hql, [username: "%${username}%"])
3.删除id集合
def hql = "delete from User where id in (:ids)" User.executeUpdate(hql, [ids: ids])
4.查询全部记录通过集合
def hql = "from User where id in (:ids)" def users = User.executeQuery(hql, [ids: ids]) //def users = User.findAll(hql, [ids: ids])
5. not in 集合
def hql = "select id from User where id not in (select user.id from User where user.username like :username)" def ids = User.executeQuery(hql, [username: "%${username}%"])
其他查询
findAllBy 排序
def users = User.findAllByAge(age, [sort: “age”, order: “asc”])
findWhere
def user = User.findWhere([username: “admin”])
0 0
- grails 常用查询
- grails 查询
- Grails GROM查询
- grails 数据库查询
- Grails的动态查询
- Grails中的Where 查询
- grails数据库条件查询
- grails实现分页查询
- grails的分页查询
- grails Gorm查询错误
- Grails GORM查询
- grails常用快捷键
- Grails常用快捷键
- grails : 常用 grails 命令与中文解释
- grails 的查询方法总结
- Grails 查询分页 小试
- grails查询数据库最大id
- Grails输出jdbc查询sql
- win10 + cmd常见命令的使用
- 常用CSS优化总结——网络性能与语法性能建议
- MoveIt简析
- Java线程同步
- 把Qt的值传给OpenGL
- grails 常用查询
- HDU
- Window环境MatConvNet安装
- codeforce771B Bear and Different Names 贪心or思维
- 114
- 带宽
- 生物信息实用数据库与论坛
- 59条令人捧腹但真实的程序员编程语录
- JavaScript基础语法