@Resource
private DataPredictSetRepository dataPredictSetRespository;
String name = dataSelectTemplateVo.getName();
String domain = dataSelectTemplateVo.getDomain();
domain=getString(domain);
String sql = "";
sql="";
if(StringUtils.isNotempty(name))
{
sql + = "and locate ('" +name+"', name)>0;
//模糊查询
}
if (StringUtils.isNotEmpty(domain))
{
sql + ="and d.domain in (' " +domain+ " ' );
//多选
}
if(StringUtils.isNotEmpty(applicationType))
{
List<String> excList =Arrays.asList(applicationType.split(","));
sql+="and (locate ('" +excList.get(0)+"',application_type>0";
for(int index =1; index<excList.size();index++)
{
sql+="or d.application_type in('"+applicationType1+"'))";
}
Query nativeQuery = entityManger.createNativeQuery(sql);
nativeQuery.setFirstResult(dictPage.getOffset());
nativeQuery.unwrap(SQLQuery.class).setResultTransformer(Transformers.aliasToBean(DataSelectTemplateVo.class));
List[DataSelectTemplateVo> resultList = nativeQuery.getResultList();
Query nativeCountQuery = entityManger.createNativeQuery(countSql);
private String getString (String applicationType){
if(StringUtils.isNotEmpty(applicationType))
{
List[String> excList =Arrays.asList(applicationType.split(",");
applciationType=";
for(int i=0;i<excList.size();i++){
if(i!=(excList.size()-1))
{ applicationType+= excList.get(i) +"'"+","+"'";}
else{
applicationType+=excList.get(i);
}}}
------将传过来的list分割成字符串
List <String>domain =Arrays.asList(domain.split(","));
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)