KeyValueConfigMapper.java

package pwc.taxtech.atms.dao;

import java.util.List;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.session.RowBounds;
import pwc.taxtech.atms.MyMapper;
import pwc.taxtech.atms.entity.KeyValueConfig;
import pwc.taxtech.atms.entity.KeyValueConfigExample;

@Mapper
public interface KeyValueConfigMapper extends MyMapper {
    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table TAX_ADMIN.KEY_VALUE_CONFIG
     *
     * @mbg.generated
     */
    long countByExample(KeyValueConfigExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table TAX_ADMIN.KEY_VALUE_CONFIG
     *
     * @mbg.generated
     */
    int deleteByExample(KeyValueConfigExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table TAX_ADMIN.KEY_VALUE_CONFIG
     *
     * @mbg.generated
     */
    int deleteByPrimaryKey(String id);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table TAX_ADMIN.KEY_VALUE_CONFIG
     *
     * @mbg.generated
     */
    int insert(KeyValueConfig record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table TAX_ADMIN.KEY_VALUE_CONFIG
     *
     * @mbg.generated
     */
    int insertSelective(KeyValueConfig record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table TAX_ADMIN.KEY_VALUE_CONFIG
     *
     * @mbg.generated
     */
    List<KeyValueConfig> selectByExampleWithRowbounds(KeyValueConfigExample example, RowBounds rowBounds);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table TAX_ADMIN.KEY_VALUE_CONFIG
     *
     * @mbg.generated
     */
    List<KeyValueConfig> selectByExample(KeyValueConfigExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table TAX_ADMIN.KEY_VALUE_CONFIG
     *
     * @mbg.generated
     */
    KeyValueConfig selectByPrimaryKey(String id);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table TAX_ADMIN.KEY_VALUE_CONFIG
     *
     * @mbg.generated
     */
    int updateByExampleSelective(@Param("record") KeyValueConfig record, @Param("example") KeyValueConfigExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table TAX_ADMIN.KEY_VALUE_CONFIG
     *
     * @mbg.generated
     */
    int updateByExample(@Param("record") KeyValueConfig record, @Param("example") KeyValueConfigExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table TAX_ADMIN.KEY_VALUE_CONFIG
     *
     * @mbg.generated
     */
    int updateByPrimaryKeySelective(KeyValueConfig record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table TAX_ADMIN.KEY_VALUE_CONFIG
     *
     * @mbg.generated
     */
    int updateByPrimaryKey(KeyValueConfig record);

    @Select("SELECT  " +
            "        KEY_VALUE_CONFIG.ID AS id,  " +
            "        KEY_VALUE_CONFIG.KEY_CODE AS keyCode,  " +
            "        KEY_VALUE_CONFIG.NAME AS name,  " +
            "        KEY_VALUE_CONFIG.KEY_VALUE_TYPE AS keyValueType,  " +
            "        KEY_VALUE_CONFIG.FORMULA AS formula,  " +
            "        KEY_VALUE_CONFIG.IS_CONSTANT AS isConstant,  " +
            "        KEY_VALUE_CONFIG.CALCULATE_STATUS AS calculateStatus,  " +
            "        KEY_VALUE_CONFIG.RESULT_TYPE AS resultType,  " +
            "        KEY_VALUE_CONFIG.SERVICE_TYPE_IDS AS serviceTypeIds,  " +
            "        KEY_VALUE_CONFIG.INDUSTRY_IDS AS industryIds,  " +
            "        KEY_VALUE_CONFIG.DESCRIPTION AS description,  " +
            "        KEY_VALUE_CONFIG.CREATOR AS creator,  " +
            "        KEY_VALUE_CONFIG.CREATE_TIME AS createTime,  " +
            "        KEY_VALUE_CONFIG.UPDATOR AS updator,  " +
            "        KEY_VALUE_CONFIG.UPDATE_TIME AS updateTime,  " +
            "        KEY_VALUE_CONFIG.DATA_SOURCE AS dataSource  " +
            "        FROM  " +
            "        TAX_ADMIN.KEY_VALUE_CONFIG  " +
            "        ORDER BY  " +
            "        KEY_VALUE_CONFIG.CREATE_TIME" +
            "")
    List<KeyValueConfig> selectKeyValueConfigsByOrderByCreateTime();
}