• Home
• ink.cory
• cory-web-spring-boot-starter
• 0.0.24
• source code
• ResourceDao.java

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

com.cory.dao.ResourceDao Maven / Gradle / Ivy

package com.cory.dao;

import com.cory.db.annotations.Dao;
import com.cory.db.annotations.Param;
import com.cory.db.annotations.Select;
import com.cory.model.Resource;

import java.util.List;

/**
 * generated by CodeGenerator on 2017/5/10.
 */
@Dao(model = Resource.class)
public interface ResourceDao extends BaseDao {

    @Select(customSql = "SELECT r.* FROM BASE_RESOURCE r WHERE r.IS_DELETED = 0 AND EXISTS(SELECT 1 FROM BASE_ROLE_RESOURCE_REL rel WHERE rel.IS_DELETED = 0 AND r.ID = rel.RESOURCE_ID AND rel.ROLE_ID = #{roleId})")
    List getByRole(@Param("roleId") Integer roleId);

    @Select(whereSql = "value = #{value}")
    Resource getByValue(@Param("value") String value);
}