egovframework.rfc3.counter.dao
Class CounterDAO

java.lang.Object
  org.springframework.dao.support.DaoSupport
      org.springframework.orm.ibatis.support.SqlMapClientDaoSupport
          egovframework.rte.psl.dataaccess.EgovAbstractDAO
              egovframework.rfc3.common.dao.RfcCMSAbstractDAO
                  egovframework.rfc3.counter.dao.CounterDAO

All Implemented Interfaces:

org.springframework.beans.factory.InitializingBean

@Repository(value="CounterDAO")
public class CounterDAO
extends RfcCMSAbstractDAO

Constructor Summary

CounterDAO()

Method Summary

int	insertcounterCommon(CounterVO counterVO) 정보 insert
java.util.List<CounterVO>	selectcounterCommonList(CounterVO counterVO) 리스트
java.util.List<CounterVO>	selectcounterdayList(CounterVO counterVO) 일간 통계
java.util.List<CounterVO>	selectcountermonthList(CounterVO counterVO) 월간 통계
int	selectcounterTotCnt(CounterVO counterVO) 리스트 카운트
java.util.List<OfficeVO>	selectOfficeQrcodeTot(OfficeVO officeVO) 부서별 QRCODE 통계

Methods inherited from class egovframework.rfc3.common.dao.RfcCMSAbstractDAO

delete, desDecoding, desDecoding2, desDecodingList, desDecodingList2, desEncoding, desEncoding2, insert, list, listWithPaging, selectByPk, setSuperSqlMapClient, update

Methods inherited from class org.springframework.orm.ibatis.support.SqlMapClientDaoSupport

getDataSource, getSqlMapClient, getSqlMapClientTemplate, setDataSource, setSqlMapClient, setSqlMapClientTemplate

Methods inherited from class org.springframework.dao.support.DaoSupport

afterPropertiesSet

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

CounterDAO

public CounterDAO()

Method Detail

selectcounterTotCnt

public int selectcounterTotCnt(CounterVO counterVO)
                        throws java.lang.Exception

리스트 카운트

Parameters:

CounterVO -

Returns:

Throws:

java.lang.Exception

selectcounterCommonList

public java.util.List<CounterVO> selectcounterCommonList(CounterVO counterVO)
                                                  throws java.lang.Exception

리스트

Parameters:

CounterVO -

Returns:

Throws:

java.lang.Exception

insertcounterCommon

public int insertcounterCommon(CounterVO counterVO)
                        throws java.lang.Exception

정보 insert

Parameters:

CounterVO -

Returns:

Throws:

java.lang.Exception

selectcountermonthList

public java.util.List<CounterVO> selectcountermonthList(CounterVO counterVO)
                                                 throws java.lang.Exception

월간 통계

Parameters:

counterVO -

Returns:

Throws:

java.lang.Exception

selectcounterdayList

public java.util.List<CounterVO> selectcounterdayList(CounterVO counterVO)
                                               throws java.lang.Exception

일간 통계

Parameters:

counterVO -

Returns:

Throws:

java.lang.Exception

selectOfficeQrcodeTot

public java.util.List<OfficeVO> selectOfficeQrcodeTot(OfficeVO officeVO)
                                               throws java.lang.Exception

부서별 QRCODE 통계

Parameters:

officeVO -

Returns:

Throws:

java.lang.Exception