<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.artfess.i18n.persistence.dao.I18nMessageTypeDao">
    <resultMap id="I18nMessageType" type="com.artfess.i18n.persistence.model.I18nMessageType">
        <id property="id" column="ID_" jdbcType="VARCHAR"/>
        <result property="type" column="TYPE_" jdbcType="VARCHAR"/>
        <result property="desc" column="DESC_" jdbcType="VARCHAR"/>
        
    </resultMap>

    <select id="getByType" parameterType="java.lang.String" resultMap="I18nMessageType">
	 select * from portal_i18n_message_type where type_ = #{type}
	</select>

</mapper>