后端java

@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 excList =Arrays.asList(applicationType.split(","));
sql+="and (locate ('" +excList.get(0)+"',application_type>0";
for(int index =1; index 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 
------将传过来的list分割成字符串
 
List domain =Arrays.asList(domain.split(","));