src/com/dream/service/impl/ProductServiceImpl.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.dream.service.impl;


import java.util.LinkedHashMap;
import java.util.List;

import javax.persistence.Query;

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

import com.dream.bean.Product;
import com.dream.dao.DaoSupport;
import com.dream.page.QueryResult;
import com.dream.service.ProductService;

@Service
@Transactional
public class ProductServiceImpl extends DaoSupport implements ProductService {

	public void deleteProduct(Long[] 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("delete from Product o where o.id in("+jpql.toString()+")");
			for(int i=0;i<ids.length;i++){
				 query.setParameter(i+1, ids[i]);
			 }
			query.executeUpdate();
		 }
	}
	@Transactional(readOnly=true,propagation=Propagation.NOT_SUPPORTED)
	public boolean isexitscode(String code) {
		Query query = em.createQuery("select count(o) from Product o where o.code=?1");
		query.setParameter(1, code);
		Long count = (Long)query.getSingleResult();
		if(count>=1){
			return true;
		}
		return false;
	}
	@Transactional(readOnly=true,propagation=Propagation.NOT_SUPPORTED)
	public boolean isexitsname(String name) {
		Query query = em.createQuery("select count(o) from Product o where o.name=?1");
		query.setParameter(1, name);
		Long count = (Long)query.getSingleResult();
		if(count>=1){
			return true;
		}
		return false;
	}
	@Transactional(readOnly=true,propagation=Propagation.NOT_SUPPORTED)
	public List<Product> getAllPro(){
		Query query = em.createQuery("select o from Product o");
		return query.getResultList();
	}