本文详细介绍了如何使用SQL和HQL通过组织ID获取角色配置的实现过程，包括构建动态SQL字符串和HQL字符串，以及使用findBySql和executeQueryByHQL方法进行查询。
public List<RoleConfiguration> getRoleConfigurationsByOrganizationsAndSql(List<Organizations> organizations){
List<RoleConfiguration> roleList = null;
// select * from roleconfiguration r where r.`OrganizationId` in (1,2)
String sql = "select * from roleconfiguration r where r.OrganizationId in (";
for (Organizations org : organizations) {
sql += org.getId()+",";
} // select * from roleconfiguration r where r.`OrganizationId` in (1,2,
if(sql.endsWith(",")){
sql = sql.substring(0, sql.length() -1); // select * from roleconfiguration r where r.`OrganizationId` in (1,2
}
sql += ")"; //// select * from roleconfiguration r where r.`OrganizationId` in (1,2)
roleList = this.findBySql(sql);
return roleList;
}
public List<RoleConfiguration> getRoleConfigurationsByOrganizationsAndHql(List<Organizations> organizations){
List<RoleConfiguration> roleList = null;
String hql = " select r from RoleConfiguration r where r.organizations.id in (";
for (Organizations org : organizations) {
hql += org.getId()+",";
}
if(hql.endsWith(",")){
hql = hql.substring(0, hql.length()-1);
}
hql += ")";
roleList = this.executeQueryByHQL(hql, null);
return roleList;
}
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
