public List<ProDepartmentEntity> queryProDepartmentAppSspq(String sspq) {
String hql = "select * from ProDepartment pd " +
"left join T_area t on t.ProDepartment=pd.name \n" +
"where pd.operationStatue=0 ";
if (!StringFacs.isEmpty(sspq)) {
hql+="and t.area_name='"+sspq+"'"; }
hql+="order by code";
List DepartmentEntity= jdbcTemplate.queryEntitys(hql, ProDepartmentEntity.class);
return DepartmentEntity;
}
更改hql
该博客介绍了如何使用JdbcTemplate执行SQL查询,从ProDepartment表中获取与操作状态为0的部门相关数据,通过LEFT JOIN连接区域表,并根据传入的地区名进行过滤,最后按编码进行排序。
摘要由CSDN通过智能技术生成