syscommanddao.java

国内很牛的软件公司花费两年半开发的用EJB3开发的代码,采用STRUTS和EJB3,目前系统进行第二版.所以拿出来共享

package com.ufmobile.platform.mstreet.sms;

import java.util.List;

import javax.persistence.EntityManager;
import javax.persistence.Query;


public class SysCommandDAO {
	
	public List<SysCommand> getSysCommand(EntityManager manager){
		Query query = manager.createQuery(" from SysCommand p");
		List list = query.getResultList();
		if(list != null && list.size() == 0){
			list = null;
		}

		return list;
	}

	public boolean delete(EntityManager manager, String cmd) {
//		SysCommand entity = manager.find(SysCommand.class, id);
//		if(entity != null){
				Query query = manager.createQuery("delete SysCommand p  where p.COMMAND=:command");
				query.setParameter("command", cmd);
				if(query.executeUpdate() == 1){
					return true;
					}
//		}
		return false;
	}

	public boolean save(EntityManager manager, SysCommand entity) {
		manager.persist(entity);
		entity = manager.merge(entity);
		return true;
	}

	public boolean update(EntityManager manager, SysCommand entity) {
		Query query = manager.createQuery("UPDATE SysCommand p SET " +
				" p.REMOTEINTERFACE=:remoteinterface" +
				"  WHERE p.COMMAND=:command");
		query.setParameter("command", entity.getCOMMAND());
		query.setParameter("remoteinterface", entity.getREMOTEINTERFACE());
		if(query.executeUpdate() == 1){
			return true;
		}
		else{
			return false;
		}
	}	
	
}