uploadfileservicebean.java

来自「巴巴运动网源码 传智博客出品 不全 一部分代码 可以参考」· Java 代码 · 共 33 行

package com.itcast.service.uploadfile.impl;

import java.util.List;

import javax.persistence.Query;

import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import com.itcast.service.base.DaoSupport;
import com.itcast.service.uploadfile.UploadFileService;

@Service
@Transactional
public class UploadFileServiceBean extends DaoSupport implements UploadFileService {

	public List<String> getFilepath(Integer[] ids){
		if(ids!=null && ids.length>0){
			StringBuffer jpql = new StringBuffer();
			for(int i=0; i<ids.length;i++){
				jpql.append('?').append((i+1)).append(',');
			}
			jpql.deleteCharAt(jpql.length()-1);
			Query query = em.createQuery("select o.filepath from UploadFile o where o.id in("+ jpql.toString()+ ")");
			for(int i=0; i<ids.length;i++){
				query.setParameter(i+1, ids[i]);
			}
			return query.getResultList();
		}
		return null;
	}
}