num-mall / pretty-num-server

package com.uccc.number.mapper;

import com.uccc.number.domain.Prefix;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * Created by bert on 2021-09-22 12:43
 */
public interface ImportNumberMapper {
    static final String PREFIX = "prefix";
    static final String COLUMN_NAMES = "id,number_prefix,mobile,city,province,type";

    @Select({
            "<script>",
            "select " + COLUMN_NAMES,
            "from " + PREFIX,
            "where number_prefix = #{numberPrefix}",
            "</script>",
    })
    Prefix getPrefixByNumber(@Param("numberPrefix") String numberPrefix);
}