productstyleservicebean.java

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

package com.itcast.service.product.impl;

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.product.ProductStyleService;

@Service
@Transactional
public class ProductStyleServiceBean extends DaoSupport implements ProductStyleService {

	public void setVisibleStatu(Integer[] productstyleids, boolean statu) {
		if(productstyleids!=null && productstyleids.length>0){
			StringBuffer jpql = new StringBuffer();
			for(int i=0;i<productstyleids.length;i++){
				jpql.append('?').append((i+2)).append(',');
			}
			jpql.deleteCharAt(jpql.length()-1);
			Query query = em.createQuery("update ProductStyle o set o.visible=?1 where o.id in("+ jpql.toString()+ ")");
			query.setParameter(1, statu);
			for(int i=0;i<productstyleids.length;i++){
				query.setParameter(i+2, productstyleids[i]);
			}
			query.executeUpdate();
		}
	}
}