counterdaoimpl.java

JetSpeed-2技术资料 JetSpeed-2技术资料 JetSpeed-2技术资料 JetSpeed-2技术资料 JetSpeed-2技术资料

/**
 * 
 */
package com.jdlssoft.portal.counter.dao;

import java.util.List;

import com.jdlssoft.portal.counter.entity.CounterDTO;
import com.jdlssoft.portal.counter.entity.CounterRowMapper;
import com.nci.nportal.ufw.dao.BaseDAO;
import com.nci.nportal.ufw.exception.DAOException;

/**
 * @project:
 * @function:
 * @author jones
 * @email: [e-mail]
 * @version:1.0
 */
public class CounterDAOImpl extends BaseDAO implements CounterDAO {

	/* (non-Javadoc)
	 * @see com.nci.nportal.counter.dao.CounterDAO#creatCounter(com.nci.nportal.counter.entity.CounterDTO)
	 */
	public boolean creatCounter(CounterDTO dto) throws DAOException {

		return false;
	}

	/* (non-Javadoc)
	 * @see com.nci.nportal.counter.dao.CounterDAO#getAllCountersNotDisabled()
	 */
	public List getAllCountersNotDisabled() throws DAOException {
		
		return null;
	}
	
	/* (non-Javadoc)
	 * @see com.nci.nportal.counter.dao.CounterDAO#getAllCounters()
	 */
	public List getAllCounters(){
		String sql="select * from NP_COUNTBRAND_TAB order by COUNTER_ID";		
		return findResult(sql, new CounterRowMapper());
	}
	
	/* (non-Javadoc)
	 * @see com.nci.nportal.counter.dao.CounterDAO#getAscCounters()
	 */
	public List getAscCounters() throws DAOException {
		String sql="select * from NP_COUNTBRAND_TAB where DISABLE_FLAG=0 and COUNTER_FLAG='asc' order by COUNTER_ID";
		return findResult(sql, new CounterRowMapper());
	}

	/* (non-Javadoc)
	 * @see com.nci.nportal.counter.dao.CounterDAO#getCounter()
	 */
	public int getCounter() throws DAOException {
		String sql="select COUNTER_NUMBER from NP_COUNTER_TAB";
		return getJdbcTemp().queryForInt(sql);
	}
	
	/* (non-Javadoc)
	 * @see com.nci.nportal.counter.dao.CounterDAO#updateCounter(int)
	 */
	public boolean updateCounter(int counterNumber) throws DAOException {
		if(counterNumber<=0)
			counterNumber=100;
		String sqls="update NP_COUNTER_TAB set COUNTER_NUMBER=? ";
		
		return updateEntity(sqls, new Object[]{new Integer(counterNumber)});
	}
	/* (non-Javadoc)
	 * @see com.nci.nportal.counter.dao.CounterDAO#getCounter(java.lang.String)
	 */
	public CounterDTO getCounter(String counterId) throws DAOException {
		if(counterId==null || "".equals(counterId) || "null".equalsIgnoreCase(counterId))
			return null;
		String sql="select * from NP_COUNTBRAND_TAB where COUNTER_ID=? ";
		CounterDTO dto=null;
		List list=findResult(sql,new Object[]{new Integer(counterId)}, new CounterRowMapper());
		if(list!=null && list.size()>0)
			dto=(CounterDTO)list.get(0);
		return dto;
	}

	public CounterDTO getCounterOfPortlet(String portletId) throws DAOException{
		if(portletId==null || "".equals(portletId) || "null".equalsIgnoreCase(portletId))
			return null;
		CounterDTO dto=null;

		return dto;
	}
	
	public boolean updateCounterOfPortlet(String counterId,String portletId) throws DAOException{


		return false;
	}
	
	public boolean createCounterOfPortlet(String counterId,String portletId) throws DAOException{

		return false;
	}
	
	public boolean isAlreadyExistCounterOfPortlet(String portletId) throws DAOException{
		return false;
	}
	
	/* (non-Javadoc)
	 * @see com.nci.nportal.counter.dao.CounterDAO#getDownCounters()
	 */
	public List getDownCounters() throws DAOException {
		String sql="select * from NP_COUNTBRAND_TAB where DISABLE_FLAG=0 and COUNTER_FLAG='desc' order by COUNTER_ID";
		return findResult(sql, new CounterRowMapper());
	}

	/* (non-Javadoc)
	 * @see com.nci.nportal.counter.dao.CounterDAO#removeCounter(java.lang.String)
	 */
	public boolean removeCounter(String counterId) throws DAOException {

		return false;
	}



	/* (non-Javadoc)
	 * @see com.nci.nportal.counter.dao.CounterDAO#updateCounter(com.nci.nportal.counter.entity.CounterDTO)
	 */
	public boolean updateCounter(CounterDTO dto) throws DAOException {

		return updateEntitys(null);
	}

	public boolean isAlreadyExist(CounterDTO dto) throws DAOException {
		// TODO Auto-generated method stub
		return false;
	}


}