package com.jtgh.cjhs.dao;

import java.util.List;

import org.springframework.data.jpa.repository.Query;

import com.jtgh.cjhs.dao.common.CjhsRepository;
import com.jtgh.cjhs.entity.DtywCbsbEntity;

/**
 *长江海事DAO
 * 
 * @author 刘福亮
 * 
 */
public interface DtywCbsbDao extends
		CjhsRepository<DtywCbsbEntity, String> {

	@Query(value = " SELECT * FROM (SELECT * FROM DTYW_CBSB WHERE ZWCM=?1 ORDER BY MRUT DESC)WHERE  ROWNUM<2   ", nativeQuery = true)
	public List<DtywCbsbEntity> findByZwcm(String zwcm);
}